Power BI Training

BY
Mindmajix Technologies

Mode

Online

Fees

₹ 8000 10000

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video and Text Based

Course and certificate fees

Fees information
₹ 8,000  ₹10,000
certificate availability

Yes

certificate providing authority

Mindmajix Technologies

The syllabus

Module 1 - Getting started with Microsoft Power BI

  • Understanding the Power BI Tools
  • Installing Power BI & Connecting to Data
  • The "Locale" used in the curriculum
  • Working with the query Editor
  • Working with the data model and creating a visualization

Module 2 - Introduction to Power BI Desktop

  • Overview of workflow  in power bi desktop
  • Introduction to different views of the data model
  • Taking a closer look at the query editor interface
  • Required Poer BI Settings

Module 3 -Data Transformation with Power Query

  • What is a query Editor?
  • About the attached data
  • Connecting Power BI Desktop to the data
  • Editing Rows
  • Understanding Append Queries
  • Editing Columns
  • Replacing Values
  • Formatting Data
  • Pivoting & Unpivoting Columns
  • Splitting Columns
  • Creating a new Group for the queries
  • \Intro Star Schema
  • Duplicating & Referencing Queries
  • Entering Data Manually
  • Merging Queries
  • Creating an Index Column
  • Duplicating Column and extracting info
  • Creating Conditional Columns
  • Performing Basic Mathematical Operations
  • Improving Performance and Loading Data into Data Model
  • Module Summary

Module 4 - Data Modeling & Relationships

  • Query Editor & the data model. Why are they different?
  • Intro to relationships
  • Editing relationships
  • Concepts are cardinality
  • Cross Filter selection & Many to many relationship
  • Active properties

Module 5 - DAX — Measures & Calculations

  • M-Language & DAX. How are they different?
  • DAX | Measures | Calculated Values
  • DAX will include complex functions like Calculate, SUM, SUMX, RELATED, ALLEXCEPT, CONCATENATE, LOOKUPVALUE, IF, SEARCH, DATEADD, DIVIDE, and many more.
  • Categorizing Data

Module 6 - Working in the Report View to Visualize the Results

  • Report view interface
  • Creating visuals
  • Add tooltips and interactions/markings
  • Data color
  • Hierarchies & Drill-down
  • Formatting charts & Sorting
  • Introduction to slicers
  • Treemaps & Tables
  • Types of filters
  • Multi-row cards
  • Combined visuals & waterfalls

Module 7 - Power Bi Service & Power BI Mobile

  • Why Power Bi Service?
  • Comparison Power BI Free & Premium
  • Logging into Power Bi Service
  • Interface overview
  • Importing data from Desktop to Service
  • Dataset menu
  • Working on reports
  • Dashboard overview
  • Workspace & Gateways
  • Installing Gateways - Personal & On-premise
  • Working alone or collaborating with colleagues
  • Collaborating in App Workspace
  • Sharing the results
  • Publishing the app
  • Content packs from online services
  • Power Bi Mobile Overview
  • Excluding dataset from sharing

Module 8 - Row-Level Security, Deployment & Governance

  • Row-level security roles,
  • Refresh schedules
  • Workspace permissions
  • Intro to deployment pipelines — the "manage and secure" skills that are easy PL-300 marks and everyday job tasks.

Module 9 - Performance Optimization

  • Reducing model size
  • Star-schema best practices
  • Using Performance Analyzer
  • Writing DAX that scales.

Module 10 - Other Data Source

  • JSON Data
  • Importing data from the rest of the APIs
  • Setting up a SQL Server
  • Importing data from SQL Server

Module 11 - Power Apps with Power BI

  • Overview
  • Basic Power App Concept
  • Canvas Apps | Navigation | Customisation
  • Contents (Galleries, Data Cards, Forms, Triggers, Functions & Formulas, Edit Forms, Text Boxes)

Module 12 - Microsoft Fabric & Copilot Primer

  • How Power BI sits inside Microsoft Fabric
  • What semantic models
  • OneLake mean for reporting
  • How Copilot in Power BI assists report creation.

Module 13 - Practice Test & Interview Questions

Instructors

Ms Meenakshi
BI Developer
Freelancer

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses