Brochure
Enquire
- 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
- Home
- Mindmajix Technologies
- Courses
- Power BI Training in London
Quick Facts
| particular | details | ||||
|---|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays, Weekends
|
Course and certificate fees
Fees information
₹ 8,000 ₹10,000
certificate availability
Yes
certificate providing authority
Mindmajix Technologies
The syllabus
Getting started with Microsoft Power BI
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
An Introduction to Query Editor
- 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
Data & Relationship View
- 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
- 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
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
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
Other Data Source
- JSON Data
- Importing data from the rest of the APIs
- Setting up a SQL Server
- Importing data from SQL Server
PowerApp
- Overview
- Basic Power App Concept
- Canvas Apps | Navigation | Customisation
- Contents (Galleries, Data Cards, Forms, Triggers, Functions & Formulas, Edit Forms, Text Boxes)
Practice Test & Interview Questions
Instructors
Articles
Popular Articles
prev
next
