Data Analysis and Presentation Using Power BI

Curriculum

Overview

TRAINING CONTENTS

Power BI is a technology-driven business intelligence tool provided by Microsoft that lets you visualize your data and share insights with the decision makers professionally. Using Power BI, you can connect billions of data from different data sources, process the data, create the relational data model, present the dynamic summarized live business data visually and share with your colleagues in the web.

The business users form supply chain, human resource, sales & marketing, finance, business research & development and other departments can present their high-level summarized data in Power BI to get quick decision for analysis profit, loss, demand, supply, various performances, KPIs, scorecards, profitably etc.

This course has been designed for the users who have no previous experience to work in Power BI and want to learn Power BI step-by-step from very beginning in easy way. We will discuss various concepts of Power BI, licensing, components of Power BI, cycle of Power BI etc. We will also show the various practical examples in detail from sample data using Power Query, Power Pivot, data modeling, reporting and finally sharing on web for the final data consumer.

Who this course is for?

People who have never used Power BI before and is looking for a hands-on approach to learn it
Data analyzers and periodic reporters
Business managers and decision makers
IT people working in BI platform
Reporters from Accounts & Finance, HRM, Sales & Marketing, Supply Chain, Costing, Business Analysts, etc.

What You’ll Learn:

Learn the complete workflow in Power BI
Various concepts of Power BI
Power BI licensing
Storytelling with data
Connecting data with different sources
Data processing in Power Query
Data modeling in Power Pivot
Various examples of DAX
Designing visual presentation on Powe BI Desktop
Sharing the Power BI report to the web

INTRODUCTION OF POWERBI

General concepts of PowerBI
Parts of PowerBI
Why PowerBI? – Various Examples of PowerBI repots
The Workflow of Power BI
Explore PowerBI screen
Concept of report, data, and model
Steps to connect with various source data
Prepare your first visualization on PowerBI

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
Table data transforming in PowerQuery
Working with text tools, numeric values, and date/time
Grouping and aggregation
Unpivoting the pivotal data
Merging & Appending multiple table data
Data consolidating and importing from a folder
Connecting data using M-Query
Adding new column in PowerQuery (general and calculated custom column)
Checking data quality of connected data
Managing connection

BUILD A RELATIONAL DATA MODEL

Principals of database normalization
Importing data into data model
Understanding DIM table and FACT table
Creating and managing Relationships among tables
Carefulness of data relationship
Concepts of one to many, many to many and many to one relationships
Importing Query to data model

ADD CALCULATED FIELDS & ITEMS WITH DAX

Adding new elements in the data model
Working with Data Analysis Expression (DAX)
Adding calculated custom columns in the data model
Creating measure in the data model
Example of few most using DAX functions in Data model
Presenting custom column value and measure on Power BI report

DESIGN INTERACTIVE POWER BI REPORTS

Exploring the report view on PowerBI window
Adding object to the PowerBI canvas
Inserting column, bar, pie, donut, and other general charts
Inserting geographical map chart
Data visualization with treemap
Data visualization with trendline
Data visualization with Matrix
Data visualization with text card
Presenting KPI on report
Using conditional formatting
Filtering report with slicers

Project: Master dashboard project using PowerQuery, PowerPivot and PowerBI

PUBLISHING THE POWER BI REPORT ON WEB

About PowerBI Web service
Sharing and collaborating with others
Publishing the PowerBI report on web
Setup of auto refreshing the report

Note:

After completing every lesson click on the “COMPLETE ” button the go to the next lesson.
Must set up your first name, last name, and display name from settings of your profile for your certificate. [Log in> Profile> Settings> General> Fill up the required fields> Save Changes ]
Do not click on the “FINISH COURSE” button without watching all the videos.
After watching all the videos click on the “FINISH COURSE ”button then the Certificate will be generated.
More details: https://thrivingskill.com/faqs/

Training Instructor: