Training Course on Data Analysis and Visualization using Microsoft Power BI
Course Overview
The Data Analysis and Visualization using Microsoft Power BI course is designed to introduce participants to Microsoft Power BI, from the basics of operating the tools, through to advanced data analysis and visualization techniques. Participants will have a comprehensive understanding of Microsoft Power BI for data analysis and visualization, enabling them to create compelling reports and dashboards for effective decision-making.
Target Audience
This is an introductory-level course suitable for professionals seeking to leverage Microsoft Power BI for comprehensive data analysis and visualization. Prior familiarity with data concepts and analysis tools is recommended to maximize learning and application during the course.
Course Objectives:
At the end of this Data Analysis and Visualization using Microsoft Power BI training course participants will be able to:
- Understand the core concepts and components of Power BI.
- Connect to different data sources and import data into Power BI.
- Perform data transformation and data shaping tasks.
- Create interactive and visually appealing reports and dashboards.
- Apply advanced analytics techniques using DAX (Data Analysis Expressions).
- Collaborate and share insights with others in the organization.
- Implement data governance and security measures within Power BI.
Requirements
- Microsoft Power BI Desktop
- This course is designed for PC/Windows users (currently not available for Mac)
Course Duration
Online training: 6 days
Classroom training: 5 days
Course Outline
Module 1: Introduction to Power BI and Data Sources
- Components of Power BI
- Features of Power BI
- Power BI workflow
- Self-Service ETL (Extract Transform Load)
- Setup and Configuration of Power BI
- Excel
- Online sources (Google Sheets, Kobo Toolbox, ONA, SurveyCTO, DHIS)
- Databases (PostgreSQL, MySQL, Microsoft SQL Server)
Module2: Data Transformation and Cleaning
- Using first Rows as Headers
- Rename fields & Replacing data values in cells, rows
- Changing data types & Change order of columns
- Un-pivoting Columns
- Grouping and splitting column into multiple
- Extract feature (before /after delimiter)
- Adding new columns
- Filters and Parameters
- View Native Queries vs Unfold Queries
Module 3: Modelling and Table Relationship
- Table relationship (One to One, One to many, Many to many)
- Introduction to Data Analysis Expression (DAX)
- Measures and calculated Column
- Row Context Vs Filter Context
Module 4: DAX Functions
- Aggregate Functions
- Date and Time Functions
- Time Intelligence Functions
- Filter Functions
- Relationship/Navigation Functions
- Logical Functions
- Text Functions
Module 5: Visualization and Charts (Power View)
- Stacked Bar chart and Stacked Column chart
- Clustered Bar chart and Clustered Column chart
- 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
- Map and Filled map
- KPI
- Q &A visual
- Fine tune your visualization using Parameters and Slicers
- Deciding on when to use a particular visual
Module 6: Building and Sharing a Dashboard
- Workspace
- Datasets
- Reports
- Create Dashboard
- Modify and update Dashboard
- Share your Dashboard
- Power Q&A and Insights
- Configuring Row level security
- Setting up user roles
Module 7: 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
Note: This course outline provides a general structure for a 5-day training program on Data Analysis and Visualization using Microsoft Power BI. The specific content, activities, and duration of each session may be adjusted based on the target audience, learning objectives, and available time.
Classroom Training Schedule
Start Date | End Date | Location | Cost | Apply |
---|---|---|---|---|
May 20, 2024 | May 24, 2024 | Nairobi | $ 950 | Register |
Jun 24, 2024 | Jun 28, 2024 | Nairobi | $ 950 | Register |
Jul 29, 2024 | Aug 02, 2024 | Nairobi | $ 950 | Register |
Sep 02, 2024 | Sep 06, 2024 | Nairobi | $ 950 | Register |
Oct 07, 2024 | Oct 11, 2024 | Nairobi | $ 950 | Register |
Nov 11, 2024 | Nov 15, 2024 | Nairobi | $ 950 | Register |
Dec 16, 2024 | Dec 20, 2024 | Nairobi | $ 950 | Register |
Virtual Training Schedule
Start Date | End Date | Location | Cost | Apply | |||
---|---|---|---|---|---|---|---|
Jun 03, 2024 | Jun 08, 2024 | Online | $ 400 | Register | |||
Jul 08, 2024 | Jul 13, 2024 | Online | $ 400 | Register | |||
Aug 12, 2024 | Aug 17, 2024 | Online | $ 400 | Register | |||
Sep 16, 2024 | Sep 21, 2024 | Online | $ 400 | Register | |||
Oct 21, 2024 | Oct 26, 2024 | Online | $ 400 | Register | |||
Nov 25, 2024 | Nov 30, 2024 | Online | $ 400 | Register |
Registration Process
Enrolling in our training programs is effortless! Upon submitting your details on the course registration link, a representative will get in touch with the relevant information.
Group Discounts
Boost your team's skills and maximize value with our attractive group discounts. Enroll 3 or more participants and enjoy significant discounts on any of our training programs.
Course Language
This Training course is offered in ENGLISH . Please indicate the language of choice during registration.
Training Approach
Our instructor-led trainings use well guided presentations, practical exercises, and group acivities. Participants are encouraged to bring any data relevant to their job responsibilities. Training manuals and additional reference materials are provided to the participants.
Certification
Upon completion of training, the participant will be issued with a certificate of Completion.
Post Training Support
Our commitment our clients success extends beyond the training program. We offer ongoing 3 months support through Q&A sessions, online forums, and access to our expert instructors.
Tailor-Made Course
We design customized training programs and inhouse workshops to meet specific training needs and organizational goals. Contact us to find out more: training@perk-gafrica.com