Mô tả

Learn data visualization through Microsoft Power BI and create opportunities for you or key decision-makers to discover data patterns such as customer purchase behavior, sales trends, or production bottlenecks.   

You'll learn all of the features in Power BI that allow you to explore, experiment with, fix, prepare, and present data easily, quickly, and beautifully.   

Use Microsoft Power BI to Analyze and Visualize Data So You Can Respond Accordingly   

  • Connect Power BI to a Variety of Datasets   

  • Drill Down and Up in Your Visualization and Calculate Data   

  • Visualize Data in the Form of Various Charts, Plots, and Maps   

Convert Raw Data Into Compelling Data Visualizations Using Microsoft Power BI   

Each section provides exercises that will challenge you so you can learn by immediately applying what you're learning.   

Content is updated as new versions of Power BI are released. You can always return to the course to further hone your skills, while you stay ahead of the competition.   

Contents and Overview   

This course begins with Power BI basics. You will navigate the software, connect it to a data file, and export a worksheet, so even beginners will feel completely at ease.   

To be able to find trends in your data and make accurate forecasts, you'll learn how to work with hierarchies and time series.   

Also, to make data easier to digest, you'll tackle how to use aggregations to summarize information. You will also use granularity to ensure accurate calculations.   

In order to begin visualizing data, you'll cover how to create various charts, maps, scatterplots, and interactive dashboards for each of your projects.   

You'll even learn how to join multiple data sources into one in order to combine diverse sources of information in one analytical solution.   

Finally, you'll cover some of the latest and most advanced custom visualizations in Microsoft Power BI, where you will create histograms, brick charts, and more.   

By the time you complete this course, you'll be a highly proficient Power BI user. You will be using your skills as a data scientist to extract knowledge from data so you can analyze and visualize complex questions with ease.   

You'll be fully prepared to collect, examine, and present data for any purpose, whether you're working with scientific data or you want to make forecasts about buying trends to increase profits.   

Bạn sẽ học được gì

Learn Power BI from scratch

Build Reports

Use DAX

Create Visualizations

Clean Data with PowerQuery

Connect to data sources

Yêu cầu

  • Windows PC. You can't natively install Power BI on Mac or Linux.
  • The course is designed to take people from beginner to pro in just 15 days. We start from the basics and have a step-by-step guided approach stretched over 15 days

Nội dung khoá học

16 sections

Day 1: Understanding the Basics (Beginner)

21 lectures
Welcome!
02:13
What is Power BI?
02:42
All Files for Download
01:02
Download & Installation
02:24
Navigate the Interface
07:47
The Interface
3 questions
Tip: Efficient Pane Switching
00:59
Important: Initial Settings
04:24
Getting Data
03:54
Our Project Data
02:15
Working with the Query Editor
05:10
The Query Editor
1 question
Important: Using Attached Project Files
04:41
Editing Rows & Columns
06:10
Changing Data Types
08:21
Chaning Data Types Using Locales
04:27
Data Types, Replace & Edit rows
4 questions
Replacing Values
05:54
Summary of the Day
02:07
Welcome challenge!
00:45
Final project for today
1 question

Day 2: Data Prep & Data Model Fundamentals (Beginner)

15 lectures
Goals Day 2
01:41
Exctracting values
06:54
Split columns
06:56
Text operations
06:43
Numerical operations
04:05
Data Model & Relationships
05:19
Practice: Data Cleaning & Relationship
00:16
Solution: Data Cleaning & Relationship
00:15
Solution: Data Cleaning & Relationship
05:48
Stacked column chart
04:48
The Format Pane
07:30
Data Labels
04:30
Pie Chart - Guidelines
09:25
Pie chart
05:53
Final Project: Day 2
1 question

Day 3: Data Preparation, Modeling & Visualization

16 lectures
Goals Day 3
01:25
Append Queries
08:02
Append Queries
1 question
Merge & Group
02:15
Hide Tables
03:01
Date Hierarchies
07:41
Drill Down & Hierarchies
04:37
Line Charts
07:16
Project: Day 3
1 question
Files from folder
05:12
Fact-Dimension model
08:21
Fact-Dimension model
2 questions
Edit relationships
03:56
Activate & Deactivate relationships
03:26
Audo-detect & manage relationships
03:25
Final quiz for today
3 questions

Day 4: Data Transformations (Intermediate)

7 lectures
Tables
07:04
Customizing Tables
06:37
Conditional Formatting (Rules)
05:30
Practice Project
2 questions
Merge Queries
08:25
Pivot & Unpivot
07:38
Many-to-Many relationships & Crossfilter Direction
05:45

Day 5: Interactive Visualizations (Intermediate)

11 lectures
Slicer Visual
08:03
Edit Page
05:37
Practice Project
1 question
Filter Pane
06:29
TopN & Relative Date Filter
05:33
Sync Slicers
04:37
Treemap Visual
05:14
Edit Interactions
04:19
Drillthrough
07:04
Tooltips
03:10
Practice Project
1 question

Day 6: Advanced Transformations & Visualizations (Advanced)

11 lectures
Custom Columns
05:48
Enable & Disable Load
06:36
References & Duplicates
07:01
Columns from Example
05:23
Project
1 question
Visual Header & Sorting
03:02
Conditional Columns
04:34
Maps
08:08
Filled Maps
03:27
Forecasts
05:30
Find Anomalies
03:33

Day 7: Advanced Dashboard Enhancements

11 lectures
Drillthrough with Button
06:33
Clear & Apply Slicers
05:54
Back & Reset Buttons
03:58
Bookmarks
08:58
Challenge: Bookmark & TopN
00:21
Solution: Bookmark & TopN
04:38
Card Visual
07:39
Multi-Row-Card
05:51
Final project for today!
1 question
Report Page Tooltip
07:25
Working with Themes
06:53

Day 8: DAX Essentials

9 lectures
Calculated Columns
08:38
Measures
07:06
AVERAGE
04:29
Measure Table
02:44
COUNT, DISTINCTCOUNT & More
07:15
SUMX & Iterative Functions
06:47
AVERAGEX
02:35
ROUND
03:34
RELATED
04:41

Day 9: DAX - CALCULATE & Filtering

9 lectures
CALCULATE
07:34
FILTER
06:02
Operators & Comments
04:41
DAX Challenges
01:14
Solutions
00:21
ALL
07:35
ALL on Columns
04:22
ALLEXCEPT
03:11
ALLSELECTED
03:17

Day 10: DAX - Time Intelligence & ChatGPT

9 lectures
DATEADD
07:50
Year-to-Date & Month-to-Date
06:44
FORMAT
08:07
Complete Date Table
05:13
Complete Date Table with features
00:37
ChatGPT for DAX in Power BI
08:12
ChatGPT for Advanced Measures
08:16
DAX Challenges
01:25
DAX Solutions
00:27

Day 11 - Publishing Reports & Power BI Service (Intermediate)

12 lectures
Goals Day 11
01:43
How to go on from here?
02:59
Power BI Pro vs Free vs Premium
07:41
Sign up for free
02:40
Alternative method without work mail
04:10
Quick Interface Tour
02:56
My workspace
02:13
Publishing reports
02:33
Editing reports
05:41
Updating reports with Power BI Desktop
06:06
Creating & Exploring Workspaces
09:50
Final project for today
1 question

Day 12- Scheduling, Data Gateway & Mobile App (Advanced)

9 lectures
Goals Day 12
02:01
Installing & using a Data Gateway
15:30
Scheduled refresh
03:20
Creating apps
06:40
Creating Dashboards
06:06
Get Quick Insights
03:00
Using Mobile App
05:43
Creating Mobile Layout
07:00
Project for today
1 question

Day 13 - Row-Level & Page-Level Security (Pro)

7 lectures
Goals for Day 13
01:31
Basic Row-Level Security
05:54
Row-Level Security in the cloud
03:26
Data Model & Row-Level Security
04:40
Dynamic RLS
09:34
Many-to-Many RLS
04:43
Page-Level Security
11:16

Day 14 - Python, Machine Learning & SQL (Pro)

14 lectures
Goals for Day 14
02:27
Plan of action
02:57
Setting up Python for Power BI
03:03
Transforming data using Python
11:24
Python script I used in the next lecture
00:13
Creating visualizations using Python
07:55
Python script II used in the next lecture
01:21
Violin plots, pair plots & ridge plots using Python
07:13
Python script III used in the next lecture
00:14
Machine learning (BayesTextAnalyzer) using Python
09:53
Performance & Troubleshooting
03:27
Loading data from web in JSON
09:57
Setting up a MySQL database
14:01
Loading data from SQL database
04:59

Day 15 - M language Fundamentals (Pro)

10 lectures
Goals for Day 15
02:10
What is the M language?
06:08
Basics about the advanced editor
06:21
Values & Lists
05:02
Table functions & transforming columns
07:39
Quick Challenge 1
00:32
Each & Table.AddColumns
08:59
Quick Challenge 2
00:40
More functions & Next steps
05:59
Final Capstone Project
1 question

Congratulations

2 lectures
You made it!
01:14
Bonus
01:49

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.