Master Microsoft Power BI in 21 Days
What you will learn
Students can learn the basics of Microsoft Power BI & can understand to connect to different data sources & Create their own data models
Students will get deeper knowledge on Microsoft Power BI and can understand more advanced features
In 21 Days student can get started with Power BI, can build own datasets, can create visualizations and can publish & share across different places
End to End understanding of Microsoft Power BI
As a Power BI analysts, one can learn to create visualization which will be helpful for business.
Description
If you want to learn Microsoft Power BI from the basics if you want to improve your analytical skills which have vast demand in the market.
Following are the topics you are going to learn from in this course.
- What is Power BI?
- What technology or toolset is needed to learn Power BI?
- Why do we need Power BI?
- Different components in the Power BI area.
- What is Power BI Desktop? How to start using it? How to create the projects in Power BI Desktop?
- How to connect to a different database in Power BI Desktop?
- Understand Query Editor and how to use it?
- How to create Data Model? How to create relationships?
- Understand different relationship types, Cardinality and join Kinds with Practical example
- How to create your First Visuals?
- What are different visuals you can create, what are different formatting capabilities that can be used to make the most of the visuals?
- Learn about Microsoft Power BI service?
- How to Move your local project created in Power BI Desktop to Cloud?
- How to create different dashboards? How to publish it.
- How to share and collaborate your applications with other users.
- Explore all aspects of Microsoft Power BI Pro service.
- What is DAX? DAX vs M-Language
- Which one to use? DAX or M-Language
- Implement DAX formula and M-language practically
- What is Power BI Mobile?
- How to set up Power BI Mobile? How to access different reports/dashboards in Power BI Mobile?
- What are Custom Visuals and what’s it used?
- Tools and technologies needed to create Custom visuals?
- How to bind real data with Custom visuals.
- all these with theory and practical examples.
English
language
Content
Day 1-2 : Overview of Microsoft Power BI
Welcome to the Course
What is Microsoft Power BI?
How to Install Power BI & Necessary Project Setup
How to Connect Power BI to Source Files
What is Query Editor & how to work with Query Editor
What is Data Model & How to create your first Visual
Useful Resources
Day 3 – 4 : Power BI Desktop : Introduction
Introduction
How to use Course resources
Understand Power BI Desktop workflow
Understand the interface of Data Model & Query Editor
How to create Project Files & recommended settings
Useful Resources
Day 5 – 6: Query Editor : All about Query Editor & interface
Connect source files to Power BI Desktop
Data Transformation – Keeping & Removing rows, Remove Empty Rows
Append Queries, Working with Columns – Rename Columns, Replacing Values
How to Format Data & Handling Formatting Errors
How to Pivot and Unpivot data
How to Split Data
Create Groups & Clean up project
What we learned and Next steps
Day 7- 10 : Part II : Query Editor
What is Star Schema?
How to use Star Schema in our Project
What is Query Duplicates & References?
Creating Dimension Table – DIM Region table & Remove duplicates
Understanding Merging Queries – Theory
Merging Queries – Practically
What is Join Kind? Theory
Merging Queries Applied & Finish Dimension Table – DIM Region table
Take a Break – Understand Next steps
Creating Dimension table – Creating DIM-Age table
What is FACT table & How to Create FACT table
Speed up the performance of our Project
Day 11 – 14 : Data Model Part I : Data & Relationship View
Module Introduction
What is relationships?
What is Cardinality? Understand Types of Cardinality
Cross Filter Direction & Active Properties & its Use
What is M Language? What is DAX?
Difference between M and DAX with Practical Example
Basics of DAX and its syntax
Understand DAX Data Types
Understand Operators & DAX Functions
Calendar Function Example
Apply DAX basics practically
Understanding IF & Related
What is Calculated Columns and Measures & Its Difference & Create First Measure
CALCULATE & FILTER Understanding
Calculate & Filter – Practically
Conclusion
Useful Resources
Day 15 – 17 : Visuals in Report View
Module Introduction
Basic Visual Concepts
Creating our First Visuals
Understanding Tooltips & Interactions
Diving into Hierarchies & Drill Mode
Data Colors & Conditional formatting
Formatting Reports
Formatting report pages & Visuals
Working with Report themes
What is Slicer and its Use
Default Summarization & Sorting
Working with Treempas & Tables & Syncing Slicers
Filter Types : Visual, Page & Report
Working with Row cards
Creating Combined Visuals & Waterfalls
Using Custom Visuals
Conclusion
Useful Resources
Day 17 – 18 : Power BI Pro (Service) : Move the project to Cloud
Module Introduction
Need of Power BI Pro (Service) & Service vs Pro vs Premium
How to Register for Power BI Pro
Alternative to non-business emails
Explore Power BI pro Interface
Connecting Power BI Pro & power BI Desktop
Understanding Datasets in Power BI Pro & Work with reports
Creating Dashboards
Refreshing Data with Gateways
Sharing and Collaboration
Working with Power BI Mobile
Conclusion
Day – 19 Other Data Sources
How to Import JSON Data
Importing Data from REST APIs
Setting up mySQL Server
Importing data from mySQL Server
Conclusion
Day -19 Stay updated with Power BI World
Introduction
Helpful Resources
Day 20 – 21 : Custom Visuals : Power BI for developers
Module Introduction
The required Technologies & Tools
setting up and Installing required tools
Creating New Visual
Analyzing the Project & the code
Using D3.js and creating first shape
Getting started with Bars
Rendering chart for test data
Binding real data
Coloring the Bars
Adding an Axis
Package & conclusion
Final Conclusion
Congratulations!! Step Ahead