Training Course on Data Analysis and Visualization using Microsoft Power BI (DMC007)
Training Course on Data Analysis and Visualization using Microsoft Power BI
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.
Requirements
- Microsoft Power BI Desktop
- This course is designed for PC/Windows users (currently not available for Mac)
Course Duration
Online Training: 7 days (4hrs per day)
Classroom Training: 5 days (7hrs per day)
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.
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)
Module 2: 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: The specific content, activities, and duration of each session may be adjusted based on the target audience, learning objectives, and available time.
Course Language
English
Training Methodology
Presentations are well guided, practical exercise, a plenary presentation, and group work. Participants are encouraged to bring any data relevant to their job responsibilities. This is hands-on, product-oriented training and will mostly involve practical exercises. Each participant MUST bring along their own working laptop and android phone.
Certification
Upon completion of training, the participant will be issued with a certificate of Completion.
Related Courses
Explore more courses in Data Management & Analysis
