Competency Development & Trainings

We engage individuals, companies, NGOs, and Governments to provide services that close competency gaps and enhance workforce productivity through our carefully designed set of short courses. Our courses can be customized to suite your peculiar needs.

Read More

Consultancies

We provide strategic consulting services for both professionals and corporate organizations. Our consultancies are strategically designed to provide tools, techniques and methodologies that can deliver on your core objectives and set goals.

Read More

Course Name: Advanced Data Visualizing and Analysis using Microsoft Power BI

Special offer for group registration:
Number of participants Fees
2-5 $ 700
6 -10 $ 650
11-50 $ 500
> 50 $ 450
To register as a group, contact us through: E: trainings@vitalextralearning.com or give us a call on T: +254707053111
Course Date Duration Location Fee: Registrations
Date: 05/12/2022 - 09/12/2022 5 Days Kigali, Rwanda $ 750 Click to register
Date: 30/01/2023 - 03/02/2023 5 Days Pretoria, S/Africa $ 950 Click to register
Date: 20/02/2023 - 24/02/2023 5 Days Kigali, Rwanda $ 950 Click to register
Date: 20/03/2023 - 24/03/2023 5 Days Nairobi, Kenya $ 950 Click to register
Date: 24/04/2023 - 28/04/2023 5 Days Abuja, Nigeria $ 950 Click to register
Date: 08/05/2023 - 12/05/2023 5 Days Nairobi, Kenya $ 950 Click to register
Date: 19/06/2023 - 23/06/2023 5 Days Mombasa, Kenya $ 960 Click to register

Duration

5 Days

Our Contacts:

Email: info@ vitalextralearning.com

Telephone:
+234 (0) 8038 066705,
+234 (0) 9039055940
+254 707 053 111

Website:
www.vitalextralearning.com

Important quick links:
Customized training
How to apply
Group registration
Frequently asked questions
Sign up for our course newsletter!

Introduction

Monitoring and evaluation professionals and researchers work with vast data that if not well handled can be overwhelming and difficult to use in decision making. Microsoft Power BI aids in visualizing data and sharing insights. The program helps in extracting, analyzing and comprehending large quantities of data thereby ensuring easier data presentation and informed decision making. In this course, participants will learn how to analyze data using Microsoft Power BI analytics tools and create user-friendly visualization dashboards and reports. 

 

Learning outcomes

By the end of this course, the participants will be able to:

  • Connect, import, shape, and transform data for business intelligence (BI)
  • Visualize data, create reports, and schedule automated data reports
  • Create and share report dashboards
  • Utilize Power BI API and mobile app
  • Use natural language queries
  • Create real-time dashboards

 

Who should enroll?

This course is useful for professionals who use data as part of their work and who need to make decisions from data analysis. Those with prior understanding of programming and statistics finds it easier to take this course.

 

 

Why train with us

Vital Extra Learning guarantees our clients:

  • State-of-the-art facilities and training infrastructure
  • Extended tradition of hand-holding during post engagement
  • Service delivery through highly seasoned industry experts.
  • Value for money

 

TOPICS TO BE COVERED:

Module 1: Introduction

Introduction to Power BI 

  • Uses of Power BI
  • Components of Power BI
  • Features of Power BI
  • Power BI workflow
  • Self Service ETL (Extract Transform Load)
  • Download and Install BI Desktop
  • Setup and configuration of Power BI

 

Understanding Power BI Screen

  • Report, data and relationship
  • Add, rename, duplicate, hide and delete pages

 

Connecting to Data Sources

  • Getting data from excel files
  • Getting data from text files
  • Loading data from multiple data sources
  • Removing unwanted columns from tables

 

Module 2: Data Transformation

Data Cleaning and Management in Power BI (Power Query)

  • Setting up the header row (using the first rows of the data)
  • Renaming fields
  • Changing/replacing data values
  • Changing data types
  • Changing the order of columns
  • Pivoting and un-pivoting data
  • Grouping and splitting columns
  • Extracting data
  • Adding new fields/columns

 

Power BI Filters 

  • Slicer
  • Basic filters
  • Advanced filters
  • Top N Filters
  • Filters on measures
  • Page level filters
  • Report level filters
  • Drill through filters
  • Generating queries (native queries vs unfold queries)

 

Modeling 

  • Table relationship (one to one, one to many, many to many)
  • Data Analysis Expression (DAX)
  • Measures and calculated Columns
  • Mastering DAX using quick measures

 

Module 3: Visualization and Charts (Power View)

Power BI Charts

  • Clustered and stacked column Chart
  • Clustered and stacked bar Chart
  • Introducing natural-language queries
  • Importing custom visuals
  • Line chart & area chart
  • Line and clustered column chart
  • Line and stacked column chart
  • Ribbon & waterfall chart
  • Funnel & tree map visuals
  • Pie-chart and doughnut chart
  • Table chart and matrix chart
  • Slicer, gauge, card visuals

 

Other visualization

  • Map and filled map
  • ArcGIS maps for Power BI
  • KPI
  • Q & A visual
  • Fine tune your visualization using parameters and slicers
  • Deciding on when to use a particular visual

 

Module 4: Power BI Dashboards

Building and Sharing a Dashboard

  • Workspace
  • Datasets
  • Reports
  • Create dashboard
  • Modify and update dashboard
  • Share your dashboard
  • Power Q&A and Insights

 

Best Practices for Power BI Dashboards

  • Dashboard best practices
  • Understanding relationship
  • Dashboard actions
  • Add reports to a dashboard
  • Add title to dashboard
  • How to add image to dashboard
  • Add video to dashboard
  • Add web content to dashboard
  • Dashboard settings
  • Delete a dashboard
  • Pin report to a dashboard

 

Configuring Data Refresh

  • Types of data refresh (Package Refresh, Model/Data refresh, Tile Refresh, Visual/Container Refresh)
  • Understand & configure data management gateways
  • Configuring & scheduling data refresh

 

Module 5: Other Topics

Data Security in Power BI

  • Configuring row level security
  • Setting up user roles

 

Power BI for Mobile

  • Configuring Power BI for Mobile
  • Visualize dashboards and report on Power BI Mobile
  • Commenting on reports and dashboards in Power BI Mobile

 

Excel Power BI

  • Power Query and Power Pivot on Excel
  • Visualize and Edit Power BI reports using excel analyzer
  • Building reports on Excel and publishing to Power BI service

 

Sharing Power BI Work

  • Inviting users (internal and external) to see a dashboard (share dashboard)
  • Share a report
  • Sharing workspace
  • Data refresh in Power BI

 

TRAINING CUSTOMIZATION

This training can be customized for your institution or delivered at your preferred location upon request. For training customization, contact us through
Email: info@ vitalextralearning.com
Telephone:
+234 (0) 8038 066705,
+234 (0) 9039055940
+254 707 053 111

LANGUAGE
English

_ Nigeria _

Register for any of our short courses and get a lifetime opportunity to visit Jabi Lake/Mall for a 1 day full of fun. You will have the pleasure of enjoying panoramic view of Abuja city, speed boat riding and Nigerian best dishes. All for free!

OUR APPROACH – TADs
We THINK
We ANALYSE
We DEVELOP AND DELIVER SOLUTIONS that satisfy our clients