Microsoft Power BI-The Complete Course for Beginners to Advanced

OVERVIEW OF THE COURSE

Microsoft Power BI is a robust analytics solution used to transform your data into powerful and rich visuals. You can view your entire business on a dashboard professionally, create stunning interactive reports, and view your data consistently across your organization. Drill-down the value to get the answer that is important to you. This long detailed course covers the contents step by step from very beginning how to use Power BI components to bring your data to life and focus on what matters to you.

After completion this detailed long course, the Power BI fear will be disappeared, and you will be able to create your business reports confidently. Your data analysis skill will be enhanced through database concepts, Power Query, PowerPivot, Data modeling, data relationships, visualization, Dashboard creation, Report sharing, configuring workspace and gateway, data refreshing and everything you need for Power BI. And surely this skill will add tremendous value in your professional life.

TRAINING METHODOLOGY

100% practical classroom training
The trainer will provide 15-20 datasets
The trainer will provide a customized PDF lecture sheet
The lecture sheet is directly related to the working datasets. After the training it will help to recall

WHO SHOULD JOIN

• Data analyzers
• Periodic reporters
• Business people who want to create analytical reports for the decision makers
• Trainers who want to get detailed knowledge on various Power BI concepts

TRAINING CONTENTS

INTRODUCTION OF POWER BI

• What is Power BI? Basic Introduction
• Various concepts of Power BI from very beginning step by step
• Why Power BI? – Various Examples of Power BI repots
• Excel Vs Power BI – Differences & Relationships
• Power BI Licensing and what parts are FREE
• A practical full cycle project to understand how Power BI works

CONNECT & TRANSFORM THE RAW DATA

• Data connection from different type of data sources
• Importing data from excel, text, pdf, csv, SQL, Oracle, Access..
• Transforming from unstructured ugly data to clean data
• Setting Query properties
• Working with text tools, numeric values, and date/time
• Grouping and aggregation
• Unpivoting the pivotal data
• Merging & Appending queries
• Data consolidating and importing from multiple data sets
• Using M-Query
• Using condition
• Using custom calculations
• Data source settings in Power Query
• Preparing data by flash-filling intelligence

BUILD A RELATIONAL DATA MODEL

• Principals of database normalization
• Concepts of data model
• Data table Vs lookup table
• Understanding primary key and foreign key
• Creating and managing Relationships among tables
• Relationships Vs merged tables
• Understanding different types of relationships
• How relationship works on visualization
• Understanding filter flow of relationships
• Importing Query to data model

ADDING CALCULATION IN DATA MODEL

• Understanding Data Analysis Expression (DAX)
• Creating new calculated column in the data model
• Creating new measure in the data model
• Examples of implicit and explicit measure
• DAX functions for Date calculation
• DAX functions for data formatting
• Using RELATED function
• Using IF() condition in the data model
• Using various Aggregation function
• Using CALCULATE function
• Using SUMX function
• Using ALL function
• Using few other important DAX functions
• Various methods of calculations
• Understanding DAX operator

DESIGNING INTERACTIVE POWER BI REPORTS

• Exploring the report view on Power BI window
• Adding object to the Power BI canvas
• Drilling down the top-value to breakdown
• Inserting basic charts and visuals
• Using conditional formatting
• Presenting target vs achievement
• Stopping interaction the dependent visuals
• Configuring the dependent visuals
• Using bookmark report in Power BI
• Importing new visuals
• Explore Your Data Using Power BI Q&A (Natural Language)
• Filtering with slicers
• Syncing Slicers Across Pages
• Using Decomposition Tree for hierarchical data presentation
• Setting Row Level Security (RLS)
• Inserting text cards
• Data visualizing with treemap
• Data visualizing with trendline
• PROJECT: Master dashboard project

PUBLISHING THE POWER BI REPORT ON WEB

• About Power BI Web service
• Comparing Power BI desktop Vs Power BI Service
• Power BI Pro Vs Premium
• Publishing the Power BI report on web
• Sharing and collaborating with others
• Row Level Security (RLS) in the Cloud
• Installing and Configuring a Data Gateway
• Schedule Refresh the Power BI Report
• Managing workspace in the Power BI web