1 - Data Analysis in Excel
Classic Data Analysis with ExcelExcel Pivot TablesLimitations of Classic Data AnalysisLab : Building a Classic Excel Dashboard
2 - The Excel Data Model
Using an Excel Data ModelDAXLab : Explore an Excel Data Model
3 - Importing Data from Files
Importing Data into ExcelShaping and Transforming DataLoading DataLab : Importing Data from a CSV File
4 - Importing Data from Databases
Available Data SourcesPreviewing, Shaping, and Transforming DataTable Relationships and HierarchiesLoading DataLab : Import Data from Multiple Sources
5 - Importing Data from Excel Reports
Importing Data from Excel ReportsTransforming Excel report DataLab : Importing Data from a Report
6 - Creating and Formatting Measures
DAXMeasuresAdvanced DAX FunctionsLab : Creating Measures using Advanced DAX Functions
7 - Visualizing Data in Excel
Pivot ChartsCube FunctionsCharts for Cube FunctionsLab : Data Visualization in Excel
8 - Using Excel with Power BI
Power BIUploading Excel Data to Power BIPower BI Mobile AppLab : Creating a Power BI Dashboard with Excel
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques.
The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.