Curriculum
- 16 Sections
- 47 Lessons
- 3 Days
Expand all sectionsCollapse all sections
- Module 1: Data Analysis in ExcelThis module looks at the classic Excel dashboard and at ways to extend it.3
- Module 1 Lab : Building a Classic Excel DashboardAfter completing this module, students will be able to: Describe classic data analysis with Excel Describe Excel pivot tables Describe the limitations of classic data analysis with Excel.3
- Module 2: The Excel Data ModelThis module looks at the classic Excel data model and at ways to extend it.Lessons2
- Module 2 Lab : Explore an Excel Data ModelAfter completing this module, students will be able to: Describe an Excel data model View data within an Excel data table Describe DAX4
- Module 3: Importing Data from FilesThis module looks at pre-formatting and importing CSV files.3
- Module 3 Lab : Importing Data from a CSV FileAfter completing this module, students will be able to: Import data into excel. Shape and transform data. Load data.2
- Module 4: Importing Data from DatabasesThis module looks at how to import data into Excel from a SQL Server database.4
- Module 4 Lab : Import Data from Multiple SourcesAfter completing this module, students will be able to: Identify available data sources. Preview, shape, and transform data. Explain table relationships and hierarchies. Load data from various sources.3
- Module 5: Importing Data from Excel ReportsThis module describes how to import data from a report.2
- Module 5 Lab : Importing Data from a ReportAfter completing this module, students will be able to: Import data from Excel reports. Transform Excel report data.3
- Module 6: Creating and Formatting MeasuresThis module describes how to create and format measures.3
- Module 6 Lab : Creating Measures using Advanced DAX Functions.After completing this module, students will be able to: Explain what DAX is and when to use it. Describe a measure. Use some of the advanced functions within DAX.3
- Module 7: Visualizing Data in ExcelThis module describes how to visualize data in Excel.3
- Module 7 Lab : Data Visualization in ExcelAfter completing this module, students will be able to: Create and refine a pivot chart. Describe cube functions and when to use them. Describe a number of charts for use with cube functions.3
- Module 8: Using Excel with Power BIThis module describes how to use Excel with Power BI.3
- Module 8 Lab : Creating a Power BI Dashboard with ExcelAfter completing this module, students will be able to: Describe Power Bi and the various versions available. Upload Excel data to Power BI. Describe the Power BI App.3
