Power BI Essential Training
- Offered byUDEMY
Power BI Essential Training at UDEMY Overview
Duration | 4 hours |
Total fee | ₹499 |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Go to Website  |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
- Faculty
Power BI Essential Training at UDEMY Highlights
- Certificate of completion
- 30-Day Money-Back Guarantee
- Full lifetime access
- Learn from 17 downloadable resources and 9 articles
Power BI Essential Training at UDEMY Course details
- Power Query, Data Modeling, DAX, Dashboards & Reports using Power BI
- Quick methods for Data Analysis techniques, creating Visualization and Reports
- Creative Data connection techniques using Power Query
- Data Insights by learning quick and simple techniques
- Learn how to automate your Reports and avoid repetitive tasks
- Knowledge is Power. Learn how to use it
- We all are surrounded by data and data is everywhere, but problem is to handle chaotic data to turn into the reports to take business decisions
- WHAT IS POWER BIPower BI is a collection of software services that work together to turn your unrelated sources of data into interactive insights.Power BI lets you easily connect to your data sources, visualize (or discover) what's important, and share that with anyone or everyone you want.BIG DATA IS EVERYWHEREThe term & big data has been around since the 1990s, yet the explosion of data in the past few years has driven home its relevance and importance
Power BI Essential Training at UDEMY Curriculum
Introduction
Welcome note
Introduction
Download Power Bi Desktop
Download the Data Resources
Starting with Power BI Desktop
Power BI release
Understanding Data and Data types
Need to combine data from multiple tables
Tools to bring data into shape
Power BI Desktop
Data Connectivity and Power Query
What is Power Query?
Download Data to connect with Power Query
Importing Data in Power Query Desktop
Append Data in Power Query
Merge Query option
Power Query Quiz
Data Transformation in Power Query
Download the pbix file of Append & Merge
Other Key Power Query tools and options
Power Query Editor
Editing Queries & Data Refresh
Data Transformation
Advanced Power Query & M Language
Advanced Power Query Intro
Connect with different file types like Excel, text/csv, Access File, PDF file
Importing Data from Web
Connecting PQ
Connect with multiple Excel Sheets in a Wrokbook
Connecting all files from a folder
Power Query Advance
Using Power BI Desktop
Using Power BI Desktop Canvas
Download Case Study (MS Access File)
Connect Case Study data in Power BI
Selecting different Visuals
Choosing Visuals wisely
Editing your Visuals
Card Visual importance
Using Slicers in Power BI
Power BI
What is covered so far?
Building Data Modeling
Understanding Data Modeling
Difference between Fact table and Dimension tables
What is the Relationshiop concept
Star Schema approach in building Relationship
Testing your Model
Fixing Issues with Model
Data Model
Importance of building a Correct Data Model
DAX and Model Optimization
What is DAX?
Why DAX is necessary
Calculated Field vs Measure
Understanding the Need for Model Optimization
DAX
Time Intelligence feature
Importance of CALENDARAUTO Function
Time Comparison functions YTD, MTD etc.
Use of Quick Measures
DAX optimization
Dashboard Reports and Case Studies
Solving the Case Studies
Case Study 1 (Data Model Optimization)
Case Study 1 (DAX Measures)
Case Study 1 (Dashboard preparation)
Chosing Color Theme
Dashboard Reprort -Case Study 2
Case Study 2 Task
Case Study 2 Data prepartion
Case Study 2 Data Model Complete
Case Study 2 - Assignment
Case Sutdy 2 Dashboard Task
Power BI Essential Training at UDEMY Faculty details
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?