Data Analysis and Presentation Using Power BI

TRAINING CONTENTS

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 the 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:

Nazmul Muneer

Courses of this Instructor:

1. Microsoft Excel – Advanced Level
2. Most Common Features of Excel for Professionals
3. Microsoft Excel – VBA & Macro
4. Lookup Functions with Practical Business Case Study
5. Microsoft Excel-Professional Tips & Tricks
6. Most Out of Excel
7. Advanced Automated Dashboard Reporting System Using Excel
8. Microsoft Excel Advanced Data Processing and Reporting Techniques
9. Advanced Excel with Practical Business Case Studies
10. Advanced Dashboard Reporting Using Excel
11. Excel for Accounting & Finance Professionals