Training

Microsoft Power BI

Connect, Integrate, Model and Visualize Business Data Reliably!

Microsoft Power BI

Duration: 3 days | 18 hours

Available delivery methods:

Classroom

Connect, Integrate, Model and Visualize Business Data Reliably!

Course Information

This is the introductory course to the award-winning analytics tool.

Learn how to turn data into powerful insights that direct and drive informed business decisions – giving your business the edge over competitors. By taking our Microsoft Power BI course, you will be able to connect, model, and then explore your data with visual reports that you can collaborate, publish, and share.

Power BI integrates with other tools, including Microsoft Excel, so you can get up to speed quickly and work seamlessly with your existing solutions.

smt2 ondemand video icon WEBINAR: How the Power BI dashboard works (example: COVID-19 Analysis).

Key areas covered on the course include:

Introduction to Power BI

  • What is Power BI?
  • The Power BI service
  • Power BI Report Server
  • Power BI Desktop
  • Reports and Dashboards
  • Datasets
  • Row-Level Security
  • Content Packs
  • Natural Language Queries

​​Data Sources

  • Connecting to Files
  • Importing Excel Files
  • Publishing to Power BI from Excel
  • Updating Files in Power BI
  • Data Refresh
  • The Power BI Data Model
  • Managing Data Relationships
  • Optimizing the Model for Reporting
  • Hierarchies
  • SQL Servers
  • Other Data Sources
  • R Script Data Connector
  • Configuring Data for Q&A
  • Creating Content Packs
  • Creating a Group

Shaping and Combining Data

  • The Query Editor
  • Applied Steps
  • Advanced Editor
  • Shaping Data
  • Formatting Data
  • Transforming Data
  • Combining Data
  • Merging Data

Modelling Data

  • What are the Relationships?
  • Viewing Relationships
  • Creating Relationships
  • Cardinality
  • Cross Filter Direction
  • What is DAX?
  • Syntax
  • Functions
  • Context
  • Calculated Columns
  • Calculated Tables
  • Measures

Interactive Data Visualizations

  • Power BI Reports: Page Layout and Formatting
  • Multiple Visualizations
  • Creating Charts
  • Using Geographic Data
  • Histograms
  • Power BI Admin Portal
  • Service Settings
  • Desktop Settings
  • Dashboard and Report Settings

Prerequisites

There are no formal prerequisites, but you should have Essential Excel skills.

What is Microsoft Power BI?

Microsoft Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.  

What’s included in this course?

3 days’ worth of Instructor-led, practical and interactive training, a course pack including all presentation slides, and a certificate.

Learners taking this course are:

  • Data Analysts
  • Business Analysts
  • Marketing Analysts
  • Process Analysts
  • Financial Analysts

What key skills will I gain in this course?

  • Data Analysis
  • Data Visualization
  • Microsoft Power BI

Do you offer In-house corporate training?

We offer corporate trainings for a minimum number of 6 participant at your preferred venue.

Find out more


Or call us now
+254 20 222 95 66
+254 716 56 88 99
+254 732 56 88 99

 

Interested in our training courses?

Get 20% off!

...on select training bundles.

Our Best Selling Courses

Microsoft Excel - Essentials

Become more effective in your reporting processes. Gain useful data manipulation skills!

Advanced Analysis & Visualization in Excel

Make the process of “Data to Decisions” efficient and cost effective.

Analytics for Finance Professionals in Excel

Drive productivity, efficiency, transparency and lower risk as a Finance professional.

Advanced PowerPoint

For professional, engaging in presentations that yield results.

Microsoft Excel - Intermediate

Become more effective in your reporting processes. Gain useful data manipulation skills!

Report Automation with Excel VBA/Macros

Get ahead of others! Automate the mundane tasks and create stunning reports with greater flexibility.

Microsoft Power BI

Connect, Integrate, Model and Visualize Business Data Reliably!

Microsoft Excel - Advanced

Connect, Integrate, Analyze and Visualize data like a pro!

Advanced Excel + Financial Modelling & Forecasting in Excel

Efficiently build an effective and robust financial model based on real-world financial modelling challenges.

Data Analysis & Visualization in Power BI

Connect, Integrate, Model and Visualize Business Data Reliably!

R for Data Science

Python for Data Science

Are you ready to transform your business?

Contact Us

0716 56 88 99

Pin It on Pinterest