About the event:

Our 2-day beginners’ course is designed for those who are new to Power BI. On the course, we deliver practical exercises demonstrating the features of this data visualisation tool. On completion of the course participants will be able to confidently produce visualisations in dashboards and reports.

Time: 9:00am – 5:00pm

Venue: Online via Zoom

Cost: USD $450 / NGN ₦200,000

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

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI.

For more information on our training, please enquire through +2348103382376 or email training@habanerodata.net. Check out the list of courses we offer at www.habanerodata.net.

Who can attend this training?

Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architect

What are the recommended prerequisites to this course?

Basic knowledge of Business Intelligence and relational database systems.

Course Syllabus:

Day 1

The world of Self-Service Business Intelligence

Introduction to Data Visualisation & Data Analysis

Introduction to Power BI

What is Power BI?

Understanding Business Intelligence (BI)

Getting started with Power BI

Overview of the components of Power BI:-

Power BI Service

Report Server

Power Query

Data Modelling

Power BI Desktop

Let's examine Power BI Desktop

Basic concepts of Power BI

Using Power BI to get data

Types of Microsoft Power BI data sources

Working with common data Sources: CSV, Excel, Text files

Connecting to CSV files

Databases: Microsoft Access, SQL Server

Web: Google Analytics, Salesforce, Facebook

Cloud Services: One Drive, Office 365

Cleaning, Transforming and shaping your data

Common Query Tasks in Power BI

Exploring the Power BI Query Editor

Utilising Power Query for data import

Using Variables under Queries

Error Handing in Queries

Scrape and Cleanse your data

Appending and Merging Data from different data sources

Overview of data transformations

Unpivot

Split Columns

Extract

Group

Data Modelling within Power BI

What is a data model?

Overview of the relationships between the tables

Create and manage relationships in Power BI Designer

Cross Filter Direction

Calculated Columns in Power BI Designer

Measures in Power BI Designer

Data Types in Power BI

Sort by Columns in Power BI Designer

Power BI Reports

Creating a Power BI Reports

Saving a Power BI Report

Uploading Power BI Designer files

Difference between Report and Dashboards

Creating Charts

Gauge and Ribbon Charts

Custom Visuals

Power BI Service

Overview of the Power BI Service

Gateways

Workspaces

Content Packs and Apps

Security

Power BI Premium

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

Day 2

Data Alerts

Setting up Data driven alerts

Using Annotations

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

Visualisation types in Power BI

Creating a column chart

Bar, Line, Area and Pie Charts

Scatter chart

Histograms

Optimising Geographic data

Power BI Dashboards

Prepare your dashboard layout

Creating a dashboard

Sharing a dashboard

Publishing Reports

Creating a Power BI App

Create and manage a content pack

Power BI Mobile apps

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

Summary

For more information on our training, please enquire through +2348103382376 or email training@habanerodata.net. Check out the list of courses we offer at www.habanerodata.net.

Data Analytics & Business Intelligence Training Using Power BI - July 2021