Course Details

 Analyzing and Visualizing Data using Microsoft Power BI Training Course

INTRODUCTION

In today’s data-driven world, effective data analysis and visualization are crucial for making informed business decisions. Microsoft Power BI is a powerful tool that allows users to connect to various data sources, transform raw data into meaningful insights, and create interactive dashboards and reports. This course is designed for professionals looking to enhance their data analysis skills and leverage Power BI for creating visually compelling reports and data visualizations.

The Analyzing and Visualizing Data using Microsoft Power BI course provides a comprehensive introduction to Power BI's features and capabilities. Participants will learn how to gather, clean, and visualize data while applying best practices in reporting and dashboard creation. Whether you're a beginner or have some experience with data analysis, this course will equip you with the tools to effectively interpret and present data to stakeholders.

COURSE OBJECTIVES:

By the end of this course, participants will be able to:

• Understand the basics of Microsoft Power BI: Gain familiarity with Power BI’s interface, key features, and various tools for data analysis and reporting.
• Connect to various data sources: Learn how to import data from multiple sources such as Excel, SQL databases, cloud-based services, and online datasets.
• Clean and transform data: Use Power Query to clean, reshape, and prepare data for analysis using advanced data transformation techniques.
• Create data models: Develop relationships between datasets and build robust data models for efficient analysis and reporting.
• Build interactive reports and dashboards: Learn to create compelling, interactive visualizations, reports, and dashboards to effectively communicate insights to different audiences.
• Understand DAX (Data Analysis Expressions): Use DAX functions and formulas to perform calculations, aggregations, and more complex data manipulations.
• Publish and share reports: Learn how to publish reports to the Power BI service and share them with stakeholders, enabling real-time collaboration and decision-making.
• Utilize advanced analytics and AI features: Explore the use of Power BI’s built-in AI capabilities, including key influencers and predictive analytics, for deeper insights.
• Understand best practices in data visualization: Learn how to apply data visualization principles to create clear, meaningful, and actionable reports.
• Collaborate and integrate Power BI with other Microsoft tools: Understand how Power BI integrates with other Microsoft tools like Excel, SharePoint, and Teams to enhance collaboration and productivity.

COURSE DURATION

5 Days

COURSE OUTLINE

Introduction to Power BI

• Components of Power BI
• Features of Power BI
• Power BI workflow
• Self Service ETL (Extract Transform Load)
• Setup and Configuration of Power BI

Connecting to Data Sources

• Excel
• Online sources (Google Sheet, Kobo Toolbox, ONA, SurveyCTO, DHIS)
• Databases (PostgreSQL, MySQL, Microsoft SQL Server)

Data Transformation: Data Management and Data Cleaning Processes in Power BI (Power Query)

• 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

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

DAX Functions

• Aggregate Functions
• Date and Time Functions
• Time Intelligence Functions
• Filter Functions
• Relationship/Navigation Functions
• Logical Functions
• Text Functions

Visualization and Charts (Power View)

• Stacked Bar chart and Stacked Column chart
• Clustered Bar chart and Clustered Column chart
• Line char t & 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

Building and Sharing a Dashboard

• Workspace
• Datasets
• Reports
• Create Dashboard
• Modify and update Dashboard
• Share your Dashboard
• Power Q&A and Insights

Data Security in Power BI

• Configuring Row level security
• Setting up user roles

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

Configuring Data Refresh

• Types of Data refresh (Package Refresh, Model/Data refresh, Tile Refresh, Visual/Container Refresh)
• Understand & Configure Data Management Gateways
• Configuring & scheduling Data refresh

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

CERTIFICATION

Upon successful completion of this training, participants will be issued with a Macskills Training and Development Institute Certificate

TRAINING VENUE

Training will be held at Macskills Training Centre. We also tailor make the training upon request at different locations across the world.

AIRPORT PICK UP AND ACCOMMODATION

Airport pick up and accommodation is arranged upon request

TERMS OF PAYMENT

Payment should be made to Macskills Development Institute bank account before the start of the training and receipts sent to info@macskillsdevelopment.com