MS Power BI

( 6 Reviews )
৳ 4500

Overview:

Power BI is a leading business analytics tool designed to empower organizations and individuals to transform raw data into meaningful insights and actionable information. Providing a user-friendly interface, Power BI offers robust capabilities for data visualization, reporting, and analytics, enabling users to create interactive dashboards, compelling reports, and real-time data visualizations. With seamless integration options, versatile connectivity to various data sources, and advanced AI-powered analytics capabilities, Power BI facilitates data-driven decision-making, enhances collaboration, and drives organizational success. Whether you’re a data analyst, business professional, or IT specialist, Power BI provides the tools, features, and functionalities needed to unlock the full potential of your data assets and gain a competitive edge in today’s dynamic business world. By bridging the gap between data complexity and actionable intelligence, Power BI serves as a catalyst for innovation, efficiency, and competitive advantage, positioning businesses to thrive in an increasingly data-driven world.

Course objectives:

 By the end of this training course participants will be able to:

  • Create interactive visualizations to deliver business insights.
  • Extract business intelligence by using DAX, M, and Power Query.
  • Share Datasets, Reports, and Dashboards in the Power BI Service.
  • Pre-format and import data from an Excel Report using Power Query and M.
  • Add value with measures, calculated columns, and calculated tables using DAX.
  • Import data from relational databases and integrate it with other data sources.
  • Profile, shape, and filter tables to prepare for analyses by fixing data issues.
  • Integrate data from CSV files and Excel Workbooks.
  • Explore and extend a Power BI data model.

    • Target audience: 

    Business professionals who wish to polish their Business Intelligence or starting their career in this sector.

    Delivery methods:

  • Projects
  • Practical exercises
  • Best practice theory exploration

    • Course outline

    Module 1: 

  • What is Power BI and Why is Power BI
  • Microsoft Excel vs Microsoft Power BI
  • Microsoft Power BI Licensing
  • Download and Installation of Power BI Software
  • Power BI Interface
  • Power BI Workflow
  • Data Connection

    • Module 2: 

  • Query View
  • Applied Steps. Difference between Close and Apply
  • Difference Between Transform and Add Column
  • Merge Column: Transform and Add Column
  • Reduce Row
  • Fill
  • Replace: Value & Error
  • Use First Row as Header and Vice-Versa

    • Module 3:

  • Text Manipulation: Transform and Add Column
  • Number Calculation: Transform and Add Column
  • Column Management: Conditional Column, Index Column, Duplicate Column, Custom Column, Column from Example
  • Date & Time

    • Module 4: 

  • Combine: Merge Queries and Append Queries. Load Enabled
  • Data Reshaping: Pivot Column vs Unpivot Column, Transpose,
  • Reverse Rows
  • Grouping: Group by Basic, Group  by Advance, Group Operations, Add Grouping and Aggregation

    • Module 5: 

  • What is M Language
  • Why M Language to be Used
  • Syntax of M Language
  • Objects of M Language
  • Application of M Language

    • Module 6: 

  • Understanding Table Relationship
  • One to Many, Many to Many, One to One Relationship
  • Fact Table land Dimension Table
  • What is Star Schema
  • M Language vs Dax
  • Dax Introduction
  • Calculated Column vs Measures
  • Analyzing Data

    • Module 7: 

  • Recap
  • Dax Measure Filter Context
  • More Calculation with Dax
  • More Analysis with Dax

    • Module 8: 

  • Format Report Page
  • Create and Modify Different Types of Charts
  • Create and Modify Map
  • Create and Modify Table and Matrix
  • Apply Conditional Formatting
  • Create and Modify Card
  • Create and Modify Multi Row Card
  • Filter Concept of Card and Multi Row Card
  • New Card in Power BI

    • Module 9: 

  • Report and Visual Theme
  • Tooltips and Interactions
  • Align Visuals Element
  • Filter Types
  • Drill Through
  • Slicer
  • Insert Elements: Text, Button, Shapes
  • Objects and Actions: Page Navigation, Bookmark, Drill Through, Web URL

    • Projects

    Other Features:

    International Standard Modules

    Post-training follow-up for one month.

    Add Your Tags:

    Use spaces to separate tags. Use single quotes (') for phrases.

    • Be the first to review this product

    WRITE YOUR OWN REVIEW

    How do you rate this product? *

    Relevant Products

    product Quick View

    Microsoft Excel: Professional Foundation

    ৳ 1990
    Add to Wishlist Add to Cart Add to Compare
    product Quick View

    MS Power BI

    ৳ 4500
    Add to Wishlist Add to Cart Add to Compare
    product Quick View

    Python Basic Course

    ৳ 6000
    Add to Wishlist Add to Cart Add to Compare