Next course begins April 1st

Power BI Essentials – Beginners

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. We will help you to gain practical knowledge that will make you a competent Power BI user quickly. On completion of the course participants will be able to confidently produce visualisations in dashboards and reports.

What you'll learn

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.

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

Course Content

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

  • Lets 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
  • Shape 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

Setting up Data driven alerts

  • Using Annotations

 

Visualisation types in Power BI

  • Creating a column chart
  • Creating Bar, Line, Area and Pie Charts
  • Creating a 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

Upcoming Dates

LocationDatePrice
OnlineApril 1st, 2024N150,000
AccraApril 4th, 2024₵4500
AbujaApril 18th, 2024N200,000
AccraMay 13th, 2024C4500
KigaliMay 13th, 2024RF415,000
OnlineMay 22nd, 2024N150,000
LagosJune 3rd, 2024₦200,000
LagosJune 10th, 2024₦200,000
AbujaJuly 22nd, 2024N200,000

Delivery Methods

Classroom Training

Unlock your potential with our classroom training courses. Our portfolio of business intelligence training courses are delivered by BI experts across Africa.

Online Training

Our online trainings (live instructor-led) are delivered by certified instructors and are designed to replicate a classroom experience which enables full interactions.

Onsite Training

Our onsite training team allows us to bring our skills and expertise to you. Onsite courses are developed in conjunction with you, ensuring your expectations are exceeded.

1-to-1 Training

With our one-to-one training you’ll not only receive the undivided attention of the trainer, but one-to-one training allows you to tailor the training to your specific needs.

From ₦200,000
C4500 | RF415,000

Certification

Refreshments

Training multiple people?

Empower your teams with business intelligence training courses delivered by subject matter experts.

Apply for Power BI Essentials – Beginners

Which date are you interested in?

Apply for Power BI Essentials – Beginners

Which date are you interested in?