prospen.co.za

ProspenAfrica | Training and Consulting Services Provider

Power Bi: Visualization and Dashboards

3 Day Training

Dates: 14 – 16 August | 25 – 27 September | 29 – 31 October 2024
Locations: Johannesburg, South Africa
Platform: Available In-Class

Price: Available on request

Course Introduction

The “Power BI: Visualization & Dashboards” course is designed to provide comprehensive training on Microsoft Power BI, focusing on data visualization and dashboard creation. Over three days, participants will learn to harness the power of Power BI to transform raw data into actionable insights through interactive and visually compelling dashboards. The course covers essential topics from basic introductions to advanced data transformation, DAX functions, and effective dashboard design, ensuring a holistic understanding of Power BI.

Course Objectives

By the end of this Power Bi: Visualization & Dashboards course, participants will be able to:

  1. Understand the fundamental components and interface of Power BI.

  2. Load and transform data using Power Query.

  3. Build data models and create relationships between tables.

  4. Develop basic and advanced visualizations.

  5. Design and publish interactive dashboards.

  6. Apply advanced DAX functions for complex calculations.

  7. Utilize Power BI’s advanced features including custom visuals, AI capabilities, and integration with other Microsoft tools.

  8. Implement best practices for dashboard design and user experience.

  9. Publish and share dashboards with appropriate permissions and access controls.

  10. Work on real-world datasets to create comprehensive reports and dashboards.

Who should attend?

This course is ideal for:

  • Business Analysts and Data Analysts who want to enhance their data visualization skills.

  • BI Professionals looking to expand their knowledge of Power BI.

  • IT Professionals responsible for data reporting and dashboard creation.

  • Managers and Team Leads who need to interpret data and make data-driven decisions.

  • Anyone interested in learning how to transform data into actionable insights using Power BI.

IT and Records Courses

Training Methodology

Our diverse instructional approaches ensure effective learning:

– Lectures & Presentations: Engage with expert-driven, stimulating content.
– Course Material: Access well-crafted supporting resources.
– Group Work: Collaborate on discussions and case studies for practical insights.
– Workshops & Role-Play: Participate in immersive, scenario-based activities.
– Practical Application: Focus on applying theoretical knowledge in real situations.
– Post-Training Support: Receive extensive support after training for skill implementation.

Training Outline

DAY 1: INTRODUCTION TO POWER BI

Morning Session (8:30 AM – 12:30 PM)

  1. Welcome & Course Overview

  • Introduction to the course & learning objectives

  • Power BI & its use in business

  • Overview of Power BI & its components

  1. Introduction to Power BI Desktop

  • Installing Power BI Desktop (on a laptop)

  • Navigating the Power BI interface

  • Introduction to data sources & Power BI data connections

  1. Data Loading & Transformation with Power Query

  • Connecting to various data sources (Excel, CSV, Text, PDF, SharePoint, SQL, etc.)

  • Basic data transformation techniques

  • Data cleaning & shaping in Power BI

Lunch Break (12:30 PM – 1:00 PM)

Afternoon Session (1:30 PM – 5:00 PM)

  1. Data Modelling

  • Introduction to data modelling concepts

  • Creating relationships between tables

  • Understanding DAX (Data Analysis Expressions) basics

  1. Creating Basic Visualizations

  • Overview of available visualization types

  • Creating and formatting charts, tables, and matrices

  • Best practices for data visualization

  1. Interactive Dashboards

  • Introduction to dashboards

  • Creating interactive dashboards with slicers and filters

  • Tiding up your dashboard looks

  • Publishing dashboards to Power BI Service

DAY 2: ADVANCED VIZ TECHNIQUES AND DASHBOARD DESIGN

Morning Session (8:30 AM – 12:30 PM)

  1. Advanced Data Transformation

  • Advanced data cleaning techniques

  • Using M language for complex transformations

  • Combining multiple data sources

  1. Advanced DAX Functions

  • Calculated columns & measures

  • Time intelligence functions

  • Advanced DAX formulas for complex calculations

  1. Advanced Visualizations

  • Custom visuals & their applications

  • Using maps & geographical data

  • Creating KPI indicators & cards

  • Refreshing dashboards

Lunch Break (12:30 PM – 1:30 PM)

Afternoon Session (1:30 PM – 5:00 PM)

  1. Designing Effective Dashboards

  • Principles of good dashboard design

  • Using themes & templates for consistency

  • Enhancing user experience with navigation features

  1. Publishing and Sharing Dashboards

  • Publishing reports to Power BI Service

  • Sharing dashboards with colleagues

  • Managing permissions & access

  1. Project

  • Working on real-world datasets

  • Creating a comprehensive report & dashboard

  • Presenting the final dashboards in class

DAY 3: HANDS-ON PRACTICE AND ADVANCED TOPICS

Morning Session (8:30 AM – 12:30 PM)

  1. Hands-On Practice

  • Guided hands-on exercises based on the previous days’ learnings

  • Creating complex reports & dashboards

  1. Advanced Topics

  • Introduction to Power BI Embedded

  • Using Power BI with other Microsoft tools (Azure)

  • Utilizing AI features

  • Advanced security & governance features

Lunch Break (12:30 PM – 1:30 PM)

Afternoon Session (1:30 PM – 5:00 PM)

  1. Q&A Session

  • Addressing specific questions & challenges

  1. Project Work

  • Working on advanced individual or group projects

  • Feedback from the instructor

  1. Course Review and Wrap-Up

  • Recap of key concepts & takeaways

  • Course evaluation and feedback

Related Courses

Advanced Electronic Document and Records Management
Dates: 22 - 26 Jul | 09 - 13 Sep | 11 - 15 Nov 2024

Advanced Electronic Document and Records Management

View More
Azure Big Data Analytics Training
Dates: Available on Request

Azure Big Data Analytics Training

View More
Basic Registry, Records, And Archives Management Course
Dates: 15 - 19 Jul | 16 - 20 Sep | 02 - 06 Dec 2024

Basic Registry, Records, And Archives Management Course

View More
Big Data Analytics with Python Training
Dates: Available on Request

Big Data Analytics with Python Training

View More

Open chat
Need Help? Chat with Us
Scan the code
Powered by Prospen Africa
Welcome to Prospen Africa!
Check out our 15% Off sale when you purchase QCTO Training Material