Course Details
Course Description:
The new analytics tools in Excel make it easy to conduct, manipulate, and gain insights from big data. PowerPivot extends the use of PivotTables with a data model and offers improved data summarization and cross‑tabulation and advanced calculations. Power Query retrieves data from a variety of sources and can be cleaned up before being added to the data model. Power View creates interactive dashboards. Power Map is a 3D visualization tool to create map charts and interactive tours. These tools bring the power of advanced analytics to the average Excel user.
Target Student:- Individuals whose job responsibilities include complex Excel reports and advanced analytics
Lesson 1 – Understanding Power Pivot and the Power BI Tools
- What is Power Pivot, Power Query, Power View, and Power Map
- Why use the Power BI Tools
- Excel versus Power Pivot
- Pivot Table Examples with Excel Data
- Power Pivot Examples with a Data Model
- Power View and Power Map Examples
- Working with an Excel List
- Using VLOOKUP to add Helper Columns
- Working with an Excel Table
- Cleaning up Tables
- Working with Normalized Tables
- Understanding Acceptable Data Types
- Adding Excel Tables to Power Pivot
- Importing Access Tables
- Saving the File
- Adding and Maintaining Data in Power Pivot
- What is a Data Model
- Understanding Key Fields
- Creating Relationships between Tables in the Model
- Managing Relationships
- Create and Use Linked Tables
- Create and Use Hierarchies
- Types of Calculations in Power Pivot
- Creating a Calculated Column
- Creating a Calculated Field (Measures)
- Implicit Calculated Field
- Explicit Calculated Field
- Understanding DAX Measure Rules and Best Practices
- Choosing Between Calculated Columns and Measures
- Creating a Key Performance Indicator (KPI)
- Understanding Data Analysis Expressions (DAX) Formulas
- Where to use DAX formulas
- Understanding the DAX syntax
- How to create DAX formulas
- Types of operations you can perform with DAX
- Working with Filter Function
- Working with Time Intelligence Functions
- Using Multiple Functions in a Formula
- Using Multiple Data Tables
- Creating Pivot Tables
- Filtering Data using Slicers
- Add Visualizations to a Pivot Table
- Creating Pivot Charts
- Formatting Pivot Charts
- Using Multiple Charts and Tables
- Visualizing Data with Power View
- Creating a Basic Report
- Making Improvements with Power View
- Creating Tables and Matrices
- Building Bar, Column, and Pie Charts
- Constructing Line and Scatter Charts
- Producing Map-Based Visualizations
- Linking Visualizations in Power View
- Using Tiles to Organize the Data
- Filtering Groups and Views
- Exposing the Dashboard
- Importing Data
- Transforming, Cleansing, and Filtering Data
- Merging and Shaping Data
- Grouping and Aggregating Data
- Inserting Calculated Columns
- Preparing the Data for Mapping
- Creating a Map-Based Graph
- Creating Heat and Region Maps
- Adding Multiple Layers to a Map
- Analyzing Changes Over Time
- Creating a Tour
- Excel Introduction or equivalent skills
- Previous experience with PivotTables is helpful, but not required
We offer live-instructor group training classes for your team.
Upskill your team from the comfort of your office or online.
Benefits of Group Training Include:
- Experienced Professional Instructor Trains Your Team
- Content Focused On Your Team's Needs
- Convenient Scheduling and Class Setup
- Significant Per/Student Cost Savings
- Online, On-Site and Blended Options Available
Virtual Live Instructor
Financing Available
Free Repeat
Testimonials
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
Great class!
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
We offer private Excel group training services for organizations looking to upskill their team members with a live-instructor.
Training options include:
Learn more about how Excel Private Group Training from Business Computer Skills can help your team.
