Course Details

This course is designed for Business Analysts, Financial Analysts, Statisticians and Business Intelligence professionals. It builds on the Introduction to Data Analysis using Excel course by going in depth in analyzing and visualizing data with Excel. It covers all the methods for connecting and importing data, cleaning and modeling data, and creating visually appealing reports and dashboards. This course will prepare participants for the Microsoft 70-779 exam by covering all the required skills. There are quizzes at the end of each module that mirror the format of the 70-779 exam questions.

The course is broken down into 5 live data labs. Please take a look at the schedule below.

WHAT YOU WILL LEARN

• How to import from data sources
• Perform data transformations
• Cleanse data
• Create and Optimize Data Models
• Create calculated columns, measures, and tables
• Create performance KPIs
• Create hierarchies
• Create and manage PivotTables
• Create and manage PivotCharts
• Interact with Power BI
• Import Excel data from Power BI
• Manipulate Excel data in Power BI

LIVE ONLINE LABS

1. Consume and Transform data 1
2. Consume and Transform data 2
3. Modeling data 1
4. Modeling data 2
5. Visualizing data

WHO SHOULD ATTEND

• Business Analysts
• Financial Analysts
• Statisticians
• Business Intelligence professionals

PREREQUISITES

• Attendance in the Introduction to Data Analysis using Excel course is desirable
• Experience with Microsoft Excel
• Some knowledge of relational databases and reporting
• Some knowledge of PowerPivot
• An awareness of key business functions such as revenue, profitability, and accounting is desirable