Analyzing and Visualizing Data with Power BI Training Course

Analyzing and Visualizing Data with Power BI Training Course

Advanced | 5 days | Face to Face / Online / Elearning | Certificate
01

Course Overview

Course Summary
Course Title Analyzing and Visualizing Data with Power BI Training Course
Organization Tech For Development (T4D)
Venue Tech For Development (T4D) Training Centre
Duration 5 days
Target Industries
Target Job Roles
Course Fees (Face-to-Face) USD 1,500/KES 99,000 (Exclusive of VAT)
Course Fees (Virtual) USD 1,000/KES 70,000 (Exclusive of VAT)
Training Modes Virtual and face-to-face training
Payment Payment should be made to the Tech For Development (T4D) bank account on or before the start of the course
Accreditation Tech For Development Certificate of Course Completion

Course Overview

This course offered by T4D equips you with the skills to transform raw data into clear, actionable insights. Learn to navigate Power BI Desktop and Service, effectively acquire and transform data. Master the art of creating compelling visualizations like charts, maps, and dashboards to communicate data stories effectively. Whether you're a data analyst, business professional, or anyone seeking to leverage data for better decision-making, this course empowers you to become a Power BI pro.

Duration

5 Days

Target Audience

  • Business Analysts
  • Data Analysts
  • Marketing Professionals
  • Financial Analysts
  • Project Managers
  • IT Professionals
  • Data Scientists
  • Decision Makers and Executives
  • Individuals seeking to enhance data visualization skills
  • Professionals involved in reporting and performance tracking
  • Anyone interested in leveraging Power BI for data analysis and visualization

Personal Impact

  • Develop skills in data analysis and visualization using Power BI.
  • Enhance ability to transform raw data into actionable insights.
  • Improve communication of data findings through compelling visualizations.
  • Increase efficiency and accuracy in data exploration and analysis.
  • Gain a valuable skillset sought after in today's data-driven job market.

Organizational Impact

  • Empower employees to make data-driven decisions.
  • Improve communication and collaboration across departments through shared dashboards.
  • Enhance problem-solving capabilities by leveraging data visualization.
  • Increase efficiency and productivity through self-service data analysis.
  • Gain a competitive advantage by unlocking the power of data insights.

Course Objectives

  • Understand Power BI Desktop and its components
  • Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two steps
  • How to work in the different views of the Data Model
  • How to create calculated columns and measures
  • How to build relationships between different tables
  • How to create a report with different interactive visualization types
  • Learn how to use Power BI service to create dashboards and to share and publish your results
  • How to access your results from multiple devices using Power BI Mobile
  • Get to know the different tools of the Power BI universe and learn how to use them
02

Course Modules

Course Outline

Module I: Quick Start Power BI Service

  • Get Power BI Tools
  • Introduction to Tools and Terminology
  • Dashboard in Minutes
  • Refreshing Power BI Service Data
  • Interacting with your Dashboards
  • Sharing Dashboards and Reports
  • Case Study: Implementing a Power BI Dashboard for Sales Tracking in a Retail Company.

Module 2: Getting and Transforming Data with Power BI Desktop

  • Introduction to Power BI Desktop
  • Getting Data: Excel vs Power BI Desktop & Service
  • Data Structure for Q&A
  • Direct Query vs Import Data
  • Modeling with Power BI
  • Introduction to Modeling
  • Setup and Manage Relationships
  • Cardinality and Cross Filtering
  • Default Summarization & Sort by
  • Creating Calculated Columns
  • Case Study: Transforming and Modeling Data for Market Analysis in a Consumer Goods Company.

Module 3: Power BI Desktop Visualizations

  • Creating Visualizations
  • Color Formatting
  • Setting Sort Order
  • Scatter & Bubble Charts & Play Axis
  • Tooltips
  • Slicers, Timeline Slicers & Sync Slicers
  • Cross Filtering and Highlighting
  • Visual, Page and Report Level Filters
  • Drill Down/Up and Hierarchies
  • Reference/Constant Lines
  • Tables, Matrices & Conditional Formatting
  • KPI’s, Cards & Gauges
  • Map Visualizations
  • Custom Visuals
  • Managing and Arranging
  • Drillthrough
  • Custom Report Themes
  • Grouping and Binning
  • Selection Pane, Bookmarks & Buttons
  • Case Study: Creating Interactive Visualizations for Financial Performance Reporting in an Investment Firm.

Module 4: Power BI Service Visualization Tools

  • Introduction
  • Standalone Tiles
  • Data Driven Alerts
  • Quick and Related Insights
  • Publishing and Sharing
  • Sharing Options Overview
  • Publish from Power BI Desktop
  • Publish to Web
  • Share Dashboard with Power BI Service
  • Workspaces and Apps (Power BI Pro)
  • Content Packs (Power BI Pro)
  • Print or Save as PDF
  • Row Level Security (Power BI Pro)
  • Export Data from a Visualization
  • Publishing for Mobile Apps
  • Export to PowerPoint
  • Case Study: Utilizing Power BI Service to Streamline Reporting and Collaboration Across Departments in a Manufacturing Company.

Module 5: Refreshing Datasets

  • Understanding Data Refresh
  • Personal Gateway (Power BI Pro and 64-bit Windows)
  • Replacing a Dataset
  • Troubleshooting Refreshing
  • Power BI and Excel Together
  • Options for Publishing from Excel
  • Pin Excel Elements to Power BI
  • Connect to Data using Power BI Publisher/Analyze in Excel
  • Excel Publish: Upload and Export to Power BI
  • Sharing Published Excel Dashboards
  • Case Study: Establishing a Data Refresh Strategy for Real-Time Analytics in a Healthcare Organization.
03

Course Administration

Methodology

Instructor-led sessions use a blended learning approach combining presentations, guided practical exercises, web-based tutorials, and group work, delivered by seasoned industry experts. All facilitation and course materials are in English, so participants should be reasonably proficient in the language.

Accreditation

Upon successful completion of this training, participants will be issued a Tech For Development Certificate of Course Completion

Training Venue

The training will be held at the Tech For Development Training Centre. The course fee covers the course tuition, training materials, two break refreshments, and lunch. All participants will additionally cater to their travel expenses, visa application, insurance, and other personal expenses.

Accommodation & Airport Transfer

Arranged upon request.For reservations contact the Training Officer:
Email: [email protected]
Phone: (+254) 790 824 179

Tailor-Made

This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our T4D Training Centre or at a convenient location.

Payment

Payment should be transferred to the T4D account through a bank on or before the start of the course. Send proof of payment to [email protected].

Course Reviews

Based on 0 participant feedback

No reviews yet for this course. Be the first to share your experience!

Write a Course Review

Please share your honest feedback below.

5 / 5 (Excellent)
Date Cost
2026 Schedules
Nairobi
14 Dec - 18 Dec
KES 99,000 |
$1,500
Register
Johannesberg
Mombasa
Kigali
Addis Ababa
Kuala Lumpur
Accra
Cairo
Cape Town
Pretoria
Dar es Salaam
Naivasha
Kisumu
Arusha
Machakos
Nakuru
Kampala
Dubai
Zanzibar
2027 Schedules
Dar es Salaam
11 Jan - 15 Jan

$2,100
Register
08 Feb - 12 Feb

$2,100
Register
08 Mar - 12 Mar

$2,100
Register
12 Apr - 16 Apr

$2,100
Register
10 May - 14 May

$2,100
Register
14 Jun - 18 Jun

$2,100
Register
12 Jul - 16 Jul

$2,100
Register
09 Aug - 13 Aug

$2,100
Register
13 Sep - 17 Sep

$2,100
Register
11 Oct - 15 Oct

$2,100
Register
08 Nov - 12 Nov

$2,100
Register
06 Dec - 10 Dec

$2,100
Register
Kigali
Addis Ababa
Kuala Lumpur
Accra
Pretoria
Cape Town
Johannesberg
Cairo
Arusha
Machakos
Zanzibar
Kisumu
Nakuru
Mombasa
Nairobi
Naivasha
Kampala
Dubai