• Home
  • Courses
    • Business and Management
    • Finance & Accounts
    • Human Resource
    • Marketing & Sales
    • Personal Development Skills
    • Workplace Wellbeing
    • Compliance Management
    • Skill Development
  • Webinar
    • Webinar on Power BI
    • Webinar on Internal Control
  • Contact
  • Become an Instructor
    • Cart

      0
    • RegisterLogin
ECDLECDL
  • Home
  • Courses
    • Business and Management
    • Finance & Accounts
    • Human Resource
    • Marketing & Sales
    • Personal Development Skills
    • Workplace Wellbeing
    • Compliance Management
    • Skill Development
  • Webinar
    • Webinar on Power BI
    • Webinar on Internal Control
  • Contact
  • Become an Instructor
    • Cart

      0
    • RegisterLogin

MS Office

  • Home
  • All courses
  • MS Office
  • Data Analysis Using Power BI

Data Analysis Using Power BI

User Avatar
MD. Nazmul Muneer, MCT
MS Office

Please fill following information

Data-Analysis-Using-Power-BI_December_2021_WEB
  • 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 21 December, 2021
  • Start Date 22 December, 2021
  • End Date 28 December, 2021
  • Class Schedule 8:30 PM TO 10:30 PM
  • Total Hours 8
  • 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.

  • Share:

    Book Your Seat

    Please fill following information

    Leave A Reply Cancel reply

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

    5 + nine =

    Latest Courses

    Project Management Professional (PMP)

    Project Management Professional (PMP)

    Financial Management for startup Business

    Financial Management for startup Business

    The Essentials of Lean Supply Chain Management

    The Essentials of Lean Supply Chain Management

    ecdl logo

    +8801767804408

    training@ecdl.com.bd

    Trade Licence No.: 03-079607

    Company

    • About Us
    • Courses
    • Contact

    Links

    • Become an Instructor
    • Terms of use
    • Privacy Policy
    • Refund Policy

    Recommend

    • Enroute Center for Development Ltd.
    • Enroute International Ltd
    • Enroute Digital Lab
    • Sudoksho

    Copyright © 2025, Enroute Center for Development Ltd.

    • Facebook
    • LinkedIn
    • Youtube

    Login with your site account

    12 + nineteen =

    Lost your password?

    Not a member yet? Register now

    Register a new account

    15 − four =

    Are you a member? Login now

    Modal title

    Message modal