Analyzing Data With Excel

After completing this course, you will be able to explore and extend a classic Excel dashboard, Explore and extend an Excel data model and Pre-format and import a .CSV file.

Prerequisites:

• You´ll have the perfect starting point for your training with these prerequisites:
• - Basic knowledge of the Microsoft Windows operating system and its core functionality.
• - Working knowledge of relational databases.
• - Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
• - Basic knowledge of data analytics.

Curriculum:

• Course 20779A: Analyzing Data with Excel
• Module 1: Data Analysis in Excel
• This module looks at the classic Excel dashboard and at ways to extend it.
• Lessons
• - Classic Data Analysis with Excel
• - Excel Pivot Tables
• - Limitations of Classic Data Analysis
• Module 2: The Excel Data Model
• This module looks at the classic Excel data model and at ways to extend it.
• Lessons
• - Using an Excel Data Model
• - DAX
• Module 3: Importing Data from Files
• This module looks at pre-formatting and importing CSV files.
• Lessons
• - Importing Data into Excel
• - Shaping and Transforming Data
• - Loading Data
• Module 4: Importing Data from Databases
• This module looks at how to import data into Excel from a SQL Server database.
• Lessons
• - Available Data Sources
• - Previewing, Shaping, and Transforming Data
• - Table Relationships and Hierarchies
• - Loading Data
• Module 5: Importing Data from Excel Reports
• This module describes how to import data from a report.
• Lessons
• - Importing Data from Excel Reports
• - Transforming Excel report Data
• Module 6: Creating and Formatting Measures
• This module describes how to create and format measures.
• Lessons
• - DAX
• - Measures
• - Advanced DAX Functions
• Module 7: Visualizing Data in Excel
• This module describes how to visualize data in Excel.
• Lessons
• - Pivot Charts
• - Cube Functions
• - Charts for Cube Functions
• Module 8: Using Excel with Power BI
• This module describes how to use Excel with Power BI.
• Lessons
• - Power BI
• - Uploading Excel Data to Power BI
• - Power BI Mobile App