3rd - 4th May 2018 Introduction to Microsoft Power BI


This 2 day course will give delegates a thorough introduction with practical exercises to using the Microsoft Power BI. This hands 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

Recommended Prerequisites: None

Course Schedule: 2 Days, 16 Academic Hours

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 Datasources
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 & 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 PowerBI

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

Visualistion 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 & A

How to ask questions in Power BI Q & A
Preparing a workbook for Q & A

Size limit in Power BI

Limitation of the free Power BI subscription

Conclusion
Your Trainer

Our international certified trainers are highly experienced Microsoft Power BI practitioners who have real-world expertise.
Key Information

I – Laptops will be provided for all candidates with pre-installed Microsoft PowerBI.

II – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of place on the course).


For more information on our training, please enquire use the form above or call 07035368449