MCSA: BI Reporting

This training help you gain expertise in analyzing data with both Power BI and Excel.


48 Hrs


• Before attending this course, students must have:
• Excellent knowledge of relational databases and reporting.
• Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
• Some exposure to basic programming constructs (such as looping and branching).
• An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
• Familiarity with Microsoft Office applications – particularly Excel.
• 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 equivalent to having attended course 10994.

CodeNameDuration (Hrs)
70-778Analyzing and Visualizing Data with Power BI24
70-779Analyzing and Visualizing Data with Microsoft Excel24

After you complete this course you will be able to:

• Perform Power BI desktop data transformation.
• Describe Power BI desktop modelling.
• Create a Power BI desktop visualization.
• Implement the Power BI service.
• Describe how to connect to Excel data.
• Describe how to collaborate with Power BI data.
• Connect directly to data stores.
• Describe the Power BI developer API.
• Describe the Power BI mobile app.
• 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.

This course is designed for:

The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data and students who are experienced with analyzing data with Excel and who wish to add BI techniques.