This 2-day course will give delegates a thorough introduction with practical exercises to using the Microsoft Power BI. This hand on course is ideal for beginners.
Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.
Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects
Course Syllabus:
Day 1
Getting started with Microsoft Power BI
- What is Power BI
- Understanding BI
- Understanding Microsoft Power BI
Power BI Designer
- Basic concepts of Power BI
- Using Microsoft Power BI to get data
- Types of Microsoft Power BI Data sources
- Connecting to Data Sources
- Merging Queries
Power BI Reports
- Creating Power BI Reports
- Saving a Power BI Report
- Uploading Power BI Designer files
- Difference between Report and Dashboards
Refreshing Data in Power BI
- Data sources that support refresh in Power BI
- Setting up a refresh schedule
Power BI features in Tablets and Mobile
- Accessing your report and dashboards from Mobile
Data Alerts
- Setting up Data driven alerts
- Using Annotations
Day 2
Transforming and shape your Data
- Query Overview in Power BI Designer
- Shape and Combine Data in Power BI Designer
- Common Query Tasks in Power BI
- Using Variables under Queries
- Error Handing in Queries
Data Modelling within Power-BI
- Create and manage relationships in Power BI Designer
- Calculated Columns in Power BI Designer
- Measures in Power BI Designer
- Data Types in Power BI
- Sort by Columns in Power BI Designer
Visualisation types in Power BI
- Creating a column chart
- Creating Bar, Line and Pie Charts
- Creating a scatter chart
Power BI Dashboards
- Creating a dashboard
- Sharing a dashboard
Working with Natural Language using Q and A
- How to ask questions in Power BI Q and A
- Preparing a workbook for Q and A
Size limit in Power BI
- Limitation of the free Power BI subscription
Conclusion