Analyzing Data with Excel - 20779 Course Outline

(3 days)Overview
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 Pivot Charts, the Excel Data Model, and Power BI.

*** NOTE: This class also available in On-Demand, eLearning Format ***
Too busy at work to miss 3 days out of the office to take this class? Consider the MOC On-Demand version of this course. Watch videos developed by Microsoft, take the same hands-on labs, access an online expert 24/7, and study at on your own time, at your own pace. For details on this alternative format, go toMOC On-Demand 20779: Analyzing Data with Excel

Audience profile
This course is intended for anyone responsible for analyzing data with Excel.

The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

Prerequisites
Before attending this course, students must have:
• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Good Knowledge of Excel spreadsheets, functions, and charts.
• Working knowledge of relational databases.

At course completion
After completing this course, students will be able to:
• Explore and extend a classic Excel dashboard.
• Explore and extend an Excel data model.
• Pre-format and import a .CSV file.
• Import data from a SQL Server database
• Import data from a report.
• Create measures using advanced DAX functions.
• Create data visualizations in Excel.
• Create a Power BI dashboard with Excel.

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
Lab : Creating a Power BI Dashboard with Excel
• Uploading Excel Data
• Creating a Power BI Dashboard