Instructor-led (classroom)
Beginner
1 day
English
PowerPivot is a powerful data exploration tool based on in-memory computing technologies that provides unmatched analytical performance to process billions of rows almost instantaneously. In this Microsoft Excel 2013 PowerPivot Training course, students will learn how to use PowerPivot to import and manipulate data, create PowerPivot reports, use DAX functions, create key performance indicators (KPI) and use slicers and hierarchies to enhance the visualization of data. Exercises accompany each lesson to enhance the learning process. The courseware covers the buttons on the PowerPivot tab and accompanying tabs for creating and editing tables and charts. The power in PowerPivot is the ability to import data from multiple sources. The course provides examples using an Access database, copy and paste, text file and Excel file. In addition, calculated fields and columns are defined and used to enhance your PivotTable.
Before attending this course, students must have:
This course is intended for students with a sound working knowledge of Microsoft Excel 2013 and general computing proficiency, including those who will be using Excel to make business decisions.
A 360-degree learning approach that you can adapt to your learning style
Engage and learn more with these live and highly-interactive classes alongside your peers
24/7 Teaching Assistance Keep engaged with integrated teaching
Projects provide you with sample work to show prospective employers.
Real-world projects relevant to what youāre learning throughout the program
A support team focused on helping you succeed alongside a peer community
After completing this course, students will be able to:
Introduction to PowerPivot 2013
This module explains how to enable PowerPivot in Excel 2013.Ā It also reviews the PowerPivot workspace and gives a brief explanation of the various actions available in the workspace.
Lessons
Lab : Enable PowerPivot
After completing this module, students will be able to:
Enable PowerPivotĀ
Building Data Models
This module begins with defining a data model and how it is used to create PivotTables and PivotCharts.Ā The Manage Data Model window is discussed in detail in this module.Ā In addition, the various methods for adding data to the model are covered.
Lessons
Lab : Create a data model
After completing this module, students will be able to:
Ā
Ā
Create a PivotTable and PivotChart
This module covers the difference between tables and charts and the various options that are available.Ā In addition, this module will walk the user through creating a basic PivotTable and PivotChart.Ā PivotTable Tools and PivotChart Tools contextual tabs are covered in this module.Ā These tabs allow further customization to the basic PivotChart and PivotTable.
LessonsĀ Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā
Lab : Create a basic PivotTable
Lab : Use the analyze tab to change your PivotTable
Lab : Use the analyze tab to change your PivotTable
Lab : Create a basic PivotChart
Lab : Use the analyze tab to change your PivotChart
Lab : Use the design tab to change your PivotChart
Lab : Use the format tab to change your PivotChart
After completing this module, students will be able to:
Ā
Use DAX in PowerPivot
This module introduces DAX – Data Analysis eXpressions language and its use in creating complex calculations to be used in PivotTables or PivotCharts.Ā DAX operators and formulas are discussed.Ā Calculated columns and calculated fields are defined and used in this module.
Lessons
Lab : Create a calculated column with data from the same table
Lab : Create a calculated column with data from a different table
Lab : Create a calculated field
After completing this module, students will be able to:
Ā
Enhance PivotTables and PivotCharts
This module covers using KPIs (Key Performance Indicators), slicers and hierarchies to further enhance your PivotCharts and PivotTables.Ā In addition the slicer tools options contextual tab is covered.Ā This tab allows customization to the display of the slicers.
Lessons
Lab : Create a KPI
Lab : Create slicers
Lab : Create hierarchies
After completing this module, students will be able to:
Ā
Create and use hierarchies in a PivotTable/PivotChart.
By submitting this form, I consent to the processing of the personal data that I provide The Data Tech Labs Inc. in accordance with and as described in the Privacy Policy.
Ā© 2020 The Data Tech Labs Inc. All rights reserved.
Microsoft Power Platform App Maker
Designing & Implementing Azure AI Solution
Microsoft Azure Administrator
Developing Solutions For Microsoft Azure
Microsoft Azure Architect Design Exam
Implementing Azure Data Solution
Administering Relational Databases On Microsoft Azure
