Microsoft Power BI for beginners

This course teaches Power BI from basic to advanced level.

4.25 (137 reviews)
Udemy
platform
English
language
Other
category
Microsoft Power BI for beginners
3,521
students
3 hours
content
Jul 2022
last update
$49.99
regular price

What you will learn

Fundamentals of Power BI , Installation , importing data , data fields , models , designer ,Visualization component :- Table , bar chart , line chart , pie chart , map , card , stacked chart , Gauge , KPI and Funnel graph.

DAX basics , Cloning , Filter , SUM , SUMX ,FilterContext , RowContext,All , AllExcept,Inner join , left join , right jon , cross join and Summarize.

Covers Calculate columns , measures , slicer , sharing report online , pages in power BI , power query editor, modelling relationships,Import vs Direct Query and Connecting to SQL Server.

Fact , dimension tables, OLAP , OLTP Design , Star schema , Snow flake and Denormalizaed design

Why take this course?

Learn Power BI Step by Step:- Beginners

Chapter 1:- What is Power BI?

Chapter 2:- Downloading and installing Power BI.

Chapter 3:- Importing Data in Power BI.

Chapter 4:- Viewing data, fields, designer and model.

Chapter 5:- Table, bar chart and line chart components.

Chapter 6:- Formatting visualization components.

Chapter 7:- Applying Analytics.

Chapter 8:- Auto filtering.

Chapter 9:- Exporting report to PDF

Chapter 10:- Adding a calculated column.

Chapter 11:- Adding a measure column.

Chapter 12:- Adding Pages.

Chapter 13:- Stacked bar chart, Column chart components.

Chapter 14:- Legend, Axis and Values.

Chapter 15:- Apply filters using Power Query Editor.

Chapter 16:- Line Chart, Pie chart, Map and Card Components.

Chapter 17:- Slicer component.

Chapter 18:- Modeling relationship.

Chapter 19:- Publishing and sharing report online.

Chapter 20:- The Market place.

Chapter 21:- Themes.

Chapter 22:- Revising things.


Lab 2:- Connecting SQL Server with Power BI.

Chapter 23:- Downloading and installing SQL Server.

Chapter 24:- Importing CSV file data in to SQL Server.

Chapter 25:- Connecting Power BI with SQL Server.

Chapter 26:- Import and Direct Query options.


Lab 3:- Line, Area, Stacke, API, Gauge and Funnel.

Chapter 27:- Line chart, Area chart and stacked charts.

Chapter 28:- Gauge charts.

Chapter 29:- KPI, Key performance indicators.

Chapter 30:- Funnel Graph.

Lab 4 :- Star Schema and Snow flake design


Chapter 31 :- OLAP and OLTP design.

Chapter 33 :- Fact tables and dimension.

Chapter 34 :- Star schema design.

Chapter 35 :- Stressing Denormalized design.

Chapter 36 :- Redundant data issue.

Chapter 37 :- Snow flake design.

Chapter 38 :- Consuming in Power BI.

Chapter 39 :- SQL Scripts of the lessons.

Lab 5 :- DAX queries

Chapter 38 :- DAX Definition

Chapter 39 :- Cloning a table

Chapter 40 :- Applying filter

Chapter 41 :- SUM and SUMX

Chapter 42 :- FilterContext and RowContext

Chapter 43 :- Calculate :- Changing the context

Chapter 44 :- Akk and AllExcept

Chapter 45 :- SelectColumns

Chapter 46 :- Inner Join, Left Join and Cross Join

Chapter 47 :- Joins with out releationships

Chapter 48 :- Summarize, Applying group by

Our review

🌟 **Overall Course Review** The course "Power BI for Beginners" has received an overwhelmingly positive response from recent reviewers, with a global rating of 4.25 out of 5. The content is praised for its clarity and depth in explaining the fundamentals of Power BI to beginners. Here's a detailed breakdown of the reviews: **Pros:** - **Comprehensive Content:** The course provides a thorough introduction to Power BI, covering the basics in a clear and detailed manner. It is particularly effective for those with no prior knowledge of the software. - **Crisp Explanations:** The explanations are very crisp and allow learners to understand the concepts without overwhelming them with unnecessary complexity. - **Structured Lessons:** The lessons are designed to be short and to the point, facilitating easier learning and retention of information. - **Navigation and Relationship Understanding:** The course effectively helps users understand how to navigate Power BI and form relationships between fields, which is crucial for data analysis. - **Practical Application:** Users appreciate the practical application of concepts through real-life examples. **Cons:** - **Version Mismatch:** Some reviewers experienced issues where the version of Power BI shown in the course did not match the current UI/UX, leading to some confusion and the need for additional searching for certain features. - **Incomplete Coverage:** Several key concepts that are essential for a comprehensive understanding of Power BI are missing from the course material. These include Power BI Architecture, components, workflow, building blocks, dashboards, natural language query, Power BI Gateway, Drill through Filters, and Security Implementation. - **Inaccurate Information:** At least one reviewer reported that some of the information provided in the course was incorrect and the resources recommended for that chapter were also outdated. The course creator was contacted via Telegram regarding this issue but did not respond. - **Overemphasis on SQL:** Some sections of the course delve deeper into SQL than necessary, which might be overwhelming for beginners who are just looking to use CSV files and do not require advanced SQL knowledge at this stage. In summary, "Power BI for Beginners" is a solid entry-level course that covers the essentials well. However, learners should be aware of the gaps in coverage and the potential for outdated information or UI discrepancies. It is recommended that these issues are addressed to improve the overall learning experience and ensure the course remains up-to-date with current Power BI features and best practices.

Charts

Price

Microsoft Power BI for beginners - Price chart

Rating

Microsoft Power BI for beginners - Ratings chart

Enrollment distribution

Microsoft Power BI for beginners - Distribution chart

Related Topics

2510316
udemy ID
8/15/2019
course created date
9/3/2019
course indexed date
Bot
course submited by