Analyzing Data with Power BI

Overview
This two-day training provides participants with the basic knowledge and skills to create simple reports and analyse data with Power BI Desktop.
Target Audience
The target audience for this course are managers, executives and business users who need to analyze data & create interactive reports or dashboards.

Learning Objectives:
After completing this course, students will be able to:

• Describe key features of a self-service BI solution
• Describe Power BI and its data sources
• Model, shape, and combine data
• Describe Power BI data visualizations

Course Outlines

Module 1: Introduction to Self-Service BI Solutions
In this module students will be introduced to the key concepts in business intelligence, data
analysis, and data visualization. In addition, they will learn the rationale for self-service BI,
considerations for using self-service BI, and how Microsoft products can be used to implement
a self-service BI solution.

• Introduction to business intelligence
• Introduction to data analysis
• Introduction to data visualization
• Microsoft tools for self-service BI

Module 2: Introducing Power BI
This module introduces Power BI desktop where you connect to data and build your reports. Power BI makes things visually appealing. It has an easy drag and drop functionality, with features that allow you to copy all formatting across visualizations.

Power BI service will host your reports on cloud for users to view & consume your reports without the need to install Power BI. Interactions between visuals, drill down and filtering capabilities will still function as normal.

• Power BI Desktop
• Creating a Microsoft account and its advantages
• Power BI service (cloud based)
• Microsoft Power BI vs Other BI applications

Module 3: Power BI Data
This module describes Power BI data sources. Power BI can access vast volumes of data from multiple sources. It allows you to view, analyse, and visualize vast quantities of data that cannot be opened in Excel. When the source is changed, a one click re-fresh is needed to see the updated reports. Power BI uses powerful compression algorithms to import and cache the data within the PBIX file.

• Identify and connect to a data source
• Handling data from multiple sources
• Changing the data source settings
• Select a storage mode / load setting
• Examine data structures, interrogate column properties
• Remove unnecessary rows / columns for optimisation of performance

Module 4: Interactive Data Visualizations
This module describes Power BI visualizations. Data visualization is the graphical representation of information and data. By using visual elements like charts, maps, data visualization tools provide an accessible way to see and understand trends, outliers, and patterns in data.

• Creating Power BI reports
• Adding visuals to reports & choosing the right visuals
• Configure and formatting visuals
• Importing custom visuals from App Source
• Importing downloaded visuals from file
• Using slicers to filter visuals
• Using the filter pane to filter visuals & reports
• Perform top N analysis
• Sorting visuals and configuring a custom sort
• Creating a hierarchy and performing drilldown into data
• Using built-in measures to summarise data
• Edit and configure interactions between visuals
• Design and configure for accessibility

Module 5: Shaping and Combining Data
This module describes how to shape and combine data. The most important part of any BI tool is combining, cleaning & re-organise data into a tabular format to enable data modelling & analytics.

• Introduction to Power Query
• Resolve inconsistencies, unexpected / null values, and data quality issues
• Identify and create appropriate keys for joins
• Transforming and re-shaping data, date transformations
• Apply user-friendly naming conventions to columns and queries
• Combining data (multiple scenarios in appending data)
• Combining data (merging data vs related tables)
• Configure data loading
• Formulas in Power Query

Module 6: Modelling Data
This module describes how to model data in Power BI. Getting insights to your data is the goal of data analytics. Here, important metrics is calculated for comparison / tracking performance.

• Introduction to Power Pivot
• Understanding Relationships
• Introduction to Data Analysis Expression (DAX)
• Formulas in Power Pivot – Calculated columns and measures
• Handling dates in Power Pivot
• Best practise in data modelling
• Building an Interactive Report

Pricing:
RM 750 Per Person (HRD Corp Claimable Course)

Join Today!