Microsoft Power BI for Business Intelligence

User Avatar
MD. Nazmul Muneer, MCT

Please fill following information

Microsoft Power BI for Business Intelligence

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
author avatar
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.

    Book Your Seat

    Please fill following information

    You May Like

    Leave A Reply

    Your email address will not be published. Required fields are marked *

    eleven − five =

    Message modal