Course Details
This training already retired on 30th of June 2020.
See other Microsoft courses
Objectives
After completing this course, students 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 CSV files
- 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
Prerequisites
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