Master Microsoft Power Bi In 21 Days

Master Microsoft Power BI in 21 Days

What you'll 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.
Requirements
No Programming Knowledge is required, Basic understanding of Data is enough
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 exampleHow 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-LanguageWhich one to use? DAX or M-LanguageImplement DAX formula and M-language practicallyWhat 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.

Overview

Section 1: Day 1-2 : Overview of Microsoft Power BI

Lecture 1 Welcome to the Course

Lecture 2 What is Microsoft Power BI?

Lecture 3 How to Install Power BI & Necessary Project Setup

Lecture 4 How to Connect Power BI to Source Files

Lecture 5 What is Query Editor & how to work with Query Editor

Lecture 6 What is Data Model & How to create your first Visual

Lecture 7 Useful Resources

Section 2: Day 3 - 4 : Power BI Desktop : Introduction

Lecture 8 Introduction

Lecture 9 How to use Course resources

Lecture 10 Understand Power BI Desktop workflow

Lecture 11 Understand the interface of Data Model & Query Editor

Lecture 12 How to create Project Files & recommended settings

Lecture 13 Useful Resources

Section 3: Day 5 - 6: Query Editor : All about Query Editor & interface

Lecture 14 Connect source files to Power BI Desktop

Lecture 15 Data Transformation - Keeping & Removing rows, Remove Empty Rows

Lecture 16 Append Queries, Working with Columns - Rename Columns, Replacing Values

Lecture 17 How to Format Data & Handling Formatting Errors

Lecture 18 How to Pivot and Unpivot data

Lecture 19 How to Split Data

Lecture 20 Create Groups & Clean up project

Lecture 21 What we learned and Next steps

Section 4: Day 7- 10 : Part II : Query Editor

Lecture 22 What is Star Schema?

Lecture 23 How to use Star Schema in our Project

Lecture 24 What is Query Duplicates & References?

Lecture 25 Creating Dimension Table - DIM Region table & Remove duplicates

Lecture 26 Understanding Merging Queries - Theory

Lecture 27 Merging Queries - Practically

Lecture 28 What is Join Kind? Theory

Lecture 29 Merging Queries Applied & Finish Dimension Table - DIM Region table

Lecture 30 Take a Break - Understand Next steps

Lecture 31 Creating Dimension table - Creating DIM-Age table

Lecture 32 What is FACT table & How to Create FACT table

Lecture 33 Speed up the performance of our Project

Section 5: Day 11 - 14 : Data Model Part I : Data & Relationship View

Lecture 34 Module Introduction

Lecture 35 What is relationships?

Lecture 36 What is Cardinality? Understand Types of Cardinality

Lecture 37 Cross Filter Direction & Active Properties & its Use

Lecture 38 What is M Language? What is DAX?

Lecture 39 Difference between M and DAX with Practical Example

Lecture 40 Basics of DAX and its syntax

Lecture 41 Understand DAX Data Types

Lecture 42 Understand Operators & DAX Functions

Lecture 43 Calendar Function Example

Lecture 44 Apply DAX basics practically

Lecture 45 Understanding IF & Related

Lecture 46 What is Calculated Columns and Measures & Its Difference & Create First Measure

Lecture 47 CALCULATE & FILTER Understanding

Lecture 48 Calculate & Filter - Practically

Lecture 49 Conclusion

Lecture 50 Useful Resources

Section 6: Day 15 - 17 : Visuals in Report View

Lecture 51 Module Introduction

Lecture 52 Basic Visual Concepts

Lecture 53 Creating our First Visuals

Lecture 54 Understanding Tooltips & Interactions

Lecture 55 Diving into Hierarchies & Drill Mode

Lecture 56 Data Colors & Conditional formatting

Lecture 57 Formatting Reports

Lecture 58 Formatting report pages & Visuals

Lecture 59 Working with Report themes

Lecture 60 What is Slicer and its Use

Lecture 61 Default Summarization & Sorting

Lecture 62 Working with Treempas & Tables & Syncing Slicers

Lecture 63 Filter Types : Visual, Page & Report

Lecture 64 Working with Row cards

Lecture 65 Creating Combined Visuals & Waterfalls

Lecture 66 Using Custom Visuals

Lecture 67 Conclusion

Lecture 68 Useful Resources

Section 7: Day 17 - 18 : Power BI Pro (Service) : Move the project to Cloud

Lecture 69 Module Introduction

Lecture 70 Need of Power BI Pro (Service) & Service vs Pro vs Premium

Lecture 71 How to Register for Power BI Pro

Lecture 72 Alternative to non-business emails

Lecture 73 Explore Power BI pro Interface

Lecture 74 Connecting Power BI Pro & power BI Desktop

Lecture 75 Understanding Datasets in Power BI Pro & Work with reports

Lecture 76 Creating Dashboards

Lecture 77 Refreshing Data with Gateways

Lecture 78 Sharing and Collaboration

Lecture 79 Working with Power BI Mobile

Lecture 80 Conclusion

Section 8: Day - 19 Other Data Sources

Lecture 81 How to Import JSON Data

Lecture 82 Importing Data from REST APIs

Lecture 83 Setting up mySQL Server

Lecture 84 Importing data from mySQL Server

Lecture 85 Conclusion

Section 9: Day -19 Stay updated with Power BI World

Lecture 86 Introduction

Lecture 87 Helpful Resources

Section 10: Day 20 - 21 : Custom Visuals : Power BI for developers

Lecture 88 Module Introduction

Lecture 89 The required Technologies & Tools

Lecture 90 setting up and Installing required tools

Lecture 91 Creating New Visual

Lecture 92 Analyzing the Project & the code

Lecture 93 Using D3.js and creating first shape

Lecture 94 Getting started with Bars

Lecture 95 Rendering chart for test data

Lecture 96 Binding real data

Lecture 97 Coloring the Bars

Lecture 98 Adding an Axis

Lecture 99 Package & conclusion

Section 11: Final Conclusion

Lecture 100 Congratulations!! Step Ahead

Anyone who is interested to learn Microsoft Power BI and build powerful visualization,Developers who wants to build custom visuals,All Business analyst or data analyst who knows data and wanted to learn how to leverage that data to Power Analytics visualizations and dashboards