Analyzing and Visualizing Data with Power BI

This course offered by IRES 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

Who should attend?

1. People who never worked with Power BI and who want to understand how to use these tools
2. Anyone who is interested in learning how to connect the different Power BI tools with each other
3. People who want to understand how to create customized visuals with the Power BI Developer tools

Personal Impact

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

Organizational Impact

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

Course Objectives

1. Understand Power BI Desktop and its components
2. 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
3. How to work in the different views of the Data Model
4. How to create calculated columns and measures
5. How to build relationships between different tables
6. How to create a report with different interactive visualization types
7. Learn how to use Power BI service to create dashboards and to share and publish your results
8. How to access your results from multiple devices using Power BI Mobile
9. Get to know the different tools of the Power BI universe and learn how to use them

Course Outline

Module I: Quick Start Power BI Service

1. Get Power BI Tools

2. Introduction to Tools and Terminology

3. Dashboard in Minutes

4. Refreshing Power BI Service Data

5. Interacting with your Dashboards

6. Sharing Dashboards and Reports

Module 2: Getting and Transforming Data with Power BI Desktop

1. Introduction to Power BI Desktop

2. Getting Data: Excel vs Power BI Desktop & Service

3. Data Structure for Q&A

4. Direct Query vs Import Data

5. Modeling with Power BI

   • Introduction to Modeling

   • Setup and Manage Relationships

   • Cardinality and Cross Filtering

   • Default Summarization & Sort by

   • Creating Calculated Columns

Module 3: Power BI Desktop Visualizations

1. Creating Visualizations

2. Color Formatting

3. Setting Sort Order

4. Scatter & Bubble Charts & Play Axis

5. Tooltips

6. Slicers, Timeline Slicers & Sync Slicers

7. Cross Filtering and Highlighting

8. Visual, Page and Report Level Filters

9. Drill Down/Up and Hierarchies

10. Reference/Constant Lines

11. Tables, Matrices & Conditional Formatting

12. KPI’s, Cards & Gauges

13. Map Visualizations

14. Custom Visuals

15. Managing and Arranging

16. Drillthrough

17. Custom Report Themes

18. Grouping and Binning

19. Selection Pane, Bookmarks & Buttons

Module 4: Power BI Service Visualization Tools

1. Introduction

2. Standalone Tiles

3. Data Driven Alerts

4. Quick and Related Insights

5. 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

Module 5: Refreshing Datasets

1. Understanding Data Refresh

2. Personal Gateway (Power BI Pro and 64-bit Windows)

3. Replacing a Dataset

4. Troubleshooting Refreshing

5. 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 2016 Publish: Upload and Export to Power BI

   • Sharing Published Excel Dashboards

Related Courses

1. Digital Skills and Literacy Course for Managers Training Course
2. ICT for HIV/AIDS Surveillance and Reporting Course
3. Zoho Analytics Course
4. Front-End Web Development Using React JS Course
5. Stakeholder Management Course
6. Program and Budget Analysis Using Microsoft Excel Course

Course Administration Details

Methodology

The instructor led trainings are delivered using a blended learning approach and comprise of presentations, guided sessions of practical exercise, web-based tutorials and group work.

Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.

All facilitation and course materials will be offered in English. Therefore, the participants should be reasonably proficient in English.

Accreditation

Upon successful completion of this training, participants will be issued with an Indepth Research Institute (IRES) certificate certified by the National Industrial Training Authority (NITA).

Training Locations

The training will be held at IRES Training Centre. The course fee covers the course tuition, training materials, two break refreshments and lunch. 

In addition to our training in Kenya (Nairobi, Mombasa, Kisumu, Nakuru, and Naivasha), we conduct training in the following locations:

1. Dubai - United Arab Emirates
2. Cairo - Egypt
3. Cape Town, Johannesburg, and Pretoria - South Africa
4. Zanzibar, Dar-es-Salaam, and Arusha - Tanzania
5. Kigali - Rwanda
6. Accra - Ghana
7. Kampala - Uganda

Accommodation and Airport Transfer

Accommodation and airport transfer are arranged upon request. For reservations contact us via the following:

1. Email: [email protected]
2. Phone: +254715 077 817

Tailor-Made Program

This training can also be customized to suit the needs of you or your institution upon request. You can have it delivered in our IRES Training Centre or at a convenient location. For further inquiries, please contact us.