DATA ANALYTICS USING POWER BI
Available Dates & Locations
COURSE OVERVIEW
Data Analysts enable businesses to maximize the value of their data assets by using Microsoft Power BI. As a subject matter expert, Data Analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations.
This course is design in-line with Microsoft Power BI exam PL-300 objectives. It will cover 4 main modules, in each module, we will practice the skills required using hands on practical workshops led by certified Microsoft instructor. We will provide study guide, exercises and practice tests to get you ready to pass the exam.
COURSE OBJECTIVES
By completely attending this course, participants will be able to:
- Importing data from various data sources
- Cleansing and preparing data using power query tools
- Modeling data and creating relationship between data tables
- Creating measures using Data Analysis Expressions (DAX)
- Perform data analysis
- Use data visualization to interpret data and present results in the form of dashboard
- Optimize and improve data model performance
- Publish reports to Power BI service (online) for sharing and collaboration
- Maintain and manage data source connectivity using gateways and other Power BI service features
Note
This course requires the use of laptop running on windows operating system with Microsoft Power BI desktop latest version installed.
TARGET COMPETENCIES
- Data Collection & Connectivity
- Data cleansing
- Data Analysis
- Model the data
- Visualize and analyze the data
- Deploy and maintain assets
The audience for this course is data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. It is also targeting professionals who want to earn Microsoft certificate as a Power BI data analyst associate.
This is a hands-on course with about 20% on design and structure and 80% uses Power BI as a commanding tool to consume and transform data, Model and visualize data, Configure dashboards, reports, and apps in the Power BI Service. Individuals will be required to complete exercises, case studies, and projects on a daily basis.
