Master Microsoft Power BI in 21 Days

Master Microsoft Power BI in 21 Days

Master Microsoft Power BI in 21 Days

Master Microsoft Power BI in 21 Days

Language: english

Note: 4.4/5 (51 notes) 4,509 students

Instructor(s): Atul Kadlag

Last update: 2022-03-27

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 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 DAXDAX 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.


 

Who this course is for

  • 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

 

Course 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

 

Master Microsoft Power BI in 21 DaysMaster Microsoft Power BI in 21 Days

Time remaining or 733 enrolls left

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate