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.


Before attending this course, students must have:

At Course Completion

After completing this course, students will be able to:

Course Outline

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

Module 2: Introducing Power BI and Excel Data Model.

Module 3: Power BI Data and Importing Data from Files

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

Module 5: Modeling Data and Importing Data from Excel Reports

Module 6: Interactive Data Visualizations and Creating and Formatting Measures

Module 7: Direct Connectivity and Visualizing Data in Excel

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

Module 9: Power BI Mobile

202 S.E. Church Street, Suite 203 Leesburg, VA 20175
202 Church Street S.E. , Suite 203 Leesburg, VA 20175
800-453-596 (Toll Free)