Data Analysis Using Power BI

Instructor

MD. Nazmul Muneer, MCT

Categories

MS Office

Please fill following information

Data Analysis Using Power BI_WEB_Feb_2022.png

Overview
Instructor

Introduction Of Power BI

General concepts of PowerBI
Parts of PowerBI
Why PowerBI?
Various Examples of PowerBI repots
The Workflow of Power I
Explore PowerBI screen
Concept of report, data, and model
Steps to connect with source data

Project-1: 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 queries
Data consolidating and importing from a folder
Connecting data using M-Query
Adding new column in PowerQuery
Checking data quality of connected data

Build a Relational Data Model

Principals of database normalization
Importing data in data model
Understanding DIM table and FACT table
Creating and managing Relationships among tables
Importing Query to data model

Add Calculated Fields & Items With Dax

Adding new elements in the data model
Working with Data Analysis Expression (DAX)
Example of few most using DAX functions in Data model

Design Interactive Power BI Reports

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

Project-2: 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

Course Information

Reg. Ends 19 February, 2022
Start Date 20 February, 2022
End Date 28 February, 2022
Class Schedule 8:00 PM TO 10:00 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.