Food Security and Agriculture

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
Mar 11, 2024 Mar 15, 2024 Nairobi $ 950 Register
Apr 15, 2024 Apr 19, 2024 Nairobi $ 400 Register
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
Mar 25, 2024 Mar 30, 2024 Online $ 400 Register
Apr 29, 2024 May 04, 2024 Online $ 400 Register
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