Power BI Training
- Offered byMindMajix
Power BI Training at MindMajix Overview
Duration | 20 hours |
Total fee | ₹15,600 |
Mode of learning | Online |
Credential | Certificate |
Power BI Training at MindMajix Highlights
- Earn a certificate of completion from Mindmajix
- Get FREE demo on request
- Comes with 24/7 lifetime support
- Get 100% money back guarantee
- Real-time project use cases for learning
Power BI Training at MindMajix Course details
- For IT professionals, business intelligence developers, and business analysts can also benefit by getting trained on Power BI
- This 20 hours long training program is designed based on Power BI 10.0 (and above) features and helps you secure Microsoft Certified: Power BI Data Analyst Associate (ExamPL-300) certification
- The learning will be based on five real-time industry use cases and projects, and we will help you prepare for interviews and make you the best fit for Power BI Analyst, and Data warehouse Expert jobs
- This course covers topics used in the actual implementations in BI Industry, such as designing and building scalable data models, designing visualizations and reporting data insights
- The learning materials, exercises and lab we provide would help you practice the Power BI capabilities you learn during the training
- This course offers topic-based learning on maximizing the value of organizational data assets, data repositories and data processes, both on-premise and in the cloud using Power BI
- Self paced also available - INR 9000
Power BI Training at MindMajix Curriculum
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
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