Microsoft Power BI for Business Intelligence

Instructor

MD. Nazmul Muneer, MCT

Categories

MS Office

Please fill following information

Microsoft Power BI for Business Intelligence

Overview
Instructor

INTRODUCTION OF POWER BI

What is Power BI?
Basic Introduction
General concepts of Power BI
Parts of Power BI
Why Power BI?
Various Examples of Power BI repots
Excel Vs Power BI
Differences & Relationships
Which parts are FREE for Power BI
The Workflow of Power BI
Explore Power BI screen
Steps to connect with source data

PROJECT-1: A practical full cycle project to clear 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
Table data transforming in Power Query
Working with text tools, numeric values, and date/time
Grouping and aggregation
Unpivoting the pivotal data
Merging & Appending queries
Data consolidating and importing from a folder
Connecting data using M-Query
Adding new conditional & custom columns
Checking data quality of connected data

BUILD A RELATIONAL DATA MODEL

Principals of database normalization
Data table Vs lookup table
Understanding primary key and foreign key
Relationships Vs merged tables
Understanding star schemas and snowflake schemas
Creating and managing Relationships among tables
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
Example of few most using DAX functions in Data model
Understanding DAX operator

DESIGN INTERACTIVE POWER BI REPORTS

Exploring the report view on Power BI window
Adding object to the Power BI canvas
Inserting basic charts and visuals
Using conditional formatting
Filtering with date slicers
Inserting text cards
Data visualizing with tree map
Data visualizing with trendline

PROJECT-2: Master dashboard project using Power Query, PowerPivot and Power BI

PUBLISHING THE POWER BI REPORT ON WEB

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

Course Information

Reg. Ends 10 March, 2022
Start Date 11 March, 2022
End Date 15 March, 2022
Class Schedule 08:30 PM to 10:30 PM
Total Hours 10 Hours
Venue Title Online Live Training
Venue Address www.sudoksho.com/class-room

MD. Nazmul Muneer, MCT

Microsoft Certified Trainer

Md. Nazmul Muneer is a Microsoft Certified Professional "Microsoft Excel (Excel and Excel 2019)" and also obtained the prestigious Certificate from Microsoft "Microsoft Certified Trainer (MCT)".

Md. Nazmul Muneer is one of the key contributors in the Accounts & Finance department of Beximco Pharmaceuticals Ltd. with 12+ years job experience and has previous work experience in Energypac Power Generation Ltd. Mr. Muneer also works as a freelance Excel automation consultant and Facilitator. In the last few years he has conducted more than 300 professional Excel training programs in many national and multinational corporate houses and educated in Excel more than 7,000 participants through effective training.

He is a regular Excel Facilitator and online course author of few leading training institutes and platforms. He also conducted Excel presentation in few educational institutes including Dhaka University, Jagannath University, United University, ICMAB, ICAB and more. He has also conducted exclusive corporate professional training programs for many Bangladeshi and MNCs organizations.

He is expertise in developing automated formula-based Excel dashboard, VBA/Macro based Excel application, strategic business model, various problem-solving calculators, What-if Analysis model, data analysis dashboard using Business Intelligence (BI) tools, KPI automation etc.

Mr. Muneer has obtained educational experience in two different disciplines. He is a post graduate in Accounting and has a Diploma in Professional Software Engineering. These have enabled him to acquire vast IT knowledge on developing Database Software, Advanced Excel with VBA, Access with programming, VB, SQL server, Crystal report, IBM AS/400, ORACLE E-Business Suit functional and implementation, etc.