Elevate your data analysis skills with our 'Analyzing Data with Excel' course, designed for professionals and SQL Server report creators looking to harness advanced BI techniques using Power Query, PivotTables, and Power BI.
Design and extend Excel dashboards and data models.
Implement data import and transformation from various files and databases.
Create advanced measures using DAX functions.
Visualize data effectively using Excel and Power BI.
The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Power Query Power Pivot Tables, Pivot Charts, the Excel Data Model, and Power BI.
No upcoming dates. Please check back later.
Classic Data Analysis with Excel
Excel Pivot Tables
Limitations of Classic Data Analysis
Lab: Building a Classic Excel Dashboard
Using an Excel Data Model
DAX
Lab: Explore an Excel Data Model
Importing Data into Excel
Shaping and Transforming Data
Loading Data
Lab: Importing Data from a CSV File
Available Data Sources
Previewing, Shaping, and Transforming Data
Table Relationships and Hierarchies
Loading Data
Lab: Import Data from Multiple Sources
Importing Data from Excel Reports
Transforming Excel report Data
Lab: Importing Data from a Report
DAX
Measures
Advanced DAX Functions
Lab: Creating Measures using Advanced DAX Functions
Pivot Charts
Cube Functions
Charts for Cube Functions
Lab: Data Visualization in Excel
Power BI
Uploading Excel Data to Power BI
Power BI Mobile App
Lab: Creating a Power BI Dashboard with Excel
Your team deserves training as unique as they are.
Let us tailor the course to your needs at no extra cost.
Trusted by Engineers at:
and more...
Aaron Steele
Casey Pense
Chris Tsantiris
Javier Martin
Justin Gilley
Kathy Le
Kelson Smith
Oussama Azzam
Pascal Rodmacq
Randall Granier
Aaron Steele
Casey Pense
Chris Tsantiris
Javier Martin
Justin Gilley
Kathy Le
Kelson Smith
Oussama Azzam
Pascal Rodmacq
Randall Granier