Power BI Cloud Service & Excel Combo Course

(MOC 20779 & MOC 20778)

About This Course

Attendees can take advantage of this 5-day instructor-led course which provides students with the knowledge and skills to analyze data with Power BI. Apply Power BI techniques to Excel and other data sources for analysis.

Import data from multiple sources in our training environment to practice modeling the queried results in Power BI. Create data visualizations that can later be saved as a report to use on a Dashboard.

Who should Attend

The audience of this course are business analysts and executive professionals. Anyone who analyzes data utilizing Power BI. Users who are experienced with the analyzing data with Excel and wish to use Power BI techniques. 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.
• Working knowledge of relational databases.
• Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
• Basic knowledge of data analytics.

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.
• Describe self-service BI.
• Describe the Power BI suite of products.
• Connect to data sources and optimize data models.
• Shape and combine data from different sources.
• Model data.
• Create reports and manage solutions.
• Describe the Power BI developer API.
• Describe the Power BI mobile app.

Course Outline

Module 1: Introduction to Self-Service BI Solutions and Data Analysis in Excel

• Introduction to Business Intelligence
• Introduction to Data Analysis
• Introduction to Data Visualization
• Overview of Self-Service BI
• Considerations for Self-Service BI
• Microsoft Tools for Self-Service BI
• Classic Data Analysis with Excel
• Excel Pivot Tables
• Limitations of Classic Data Analysis

Module 2: Introducing Power BI and Excel Data Model.

• Power BI
• The Power BI Service
• Using an Excel Data Model
• DAX

Module 3: Power BI Data and Importing Data from Files

• Using Excel as a Data Source for Power BI
• The Power BI Data Model
• Using Databases as a Data Source for Power BI
• The Power BI Service
• Importing Data into Excel
• Shaping and Transforming Data
• Loading Data

Module 4: Shaping and Combining Data and Importing Data from Databases

• Power BI Desktop Queries
• Shaping Data
• Combining Data
• Available Data Sources
• Previewing, Shaping, and Transforming Data
• Table Relationships and Hierarchies
• Loading Data

Module 5: Modeling Data and Importing Data from Excel Reports

• Relationships
• DAX Queries
• Calculations and Measures
• Importing Data from Excel Reports
• Transforming Excel report Data

Module 6: Interactive Data Visualizations and Creating and Formatting Measures

• Creating Power BI Reports
• Managing a Power BI Solution
• DAX
• Measures
• Advanced DAX Functions

Module 7: Direct Connectivity and Visualizing Data in Excel

• Cloud Data
• Connecting to Analysis Services
• Pivot Charts
• Cube Functions
• Charts for Cube Functions

Module 8: The Developer API and Using Excel with Power BI

• The Developer API
• Custom Visuals
• Power BI
• Uploading Excel Data to Power BI
• Power BI Mobile App

Module 9: Power BI Mobile

• Power BI Mobile Apps
• Using the Power BI Mobile App
• Power BI Embedded

We look forward to your great success.