Danh mục
Duocmmo Tedu Tin học văn phòng Laravel Cyberlearn Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Business
Business Analytics & Intelligence
Microsoft Power BI
Microsoft Power BI - The Complete Masterclass [2023 EDITION]

Microsoft Power BI - The Complete Masterclass [2023 EDITION]

Loại khoá học: Business Analytics & Intelligence

Master Power BI Desktop, Cloud & Mobile and advanced analytics with DAX (also Data Science)!

image
50.000 VND
1.999.000 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

Do you want to learn the skills to professionally analyze data?

Do you want to learn all the steps to create impressive reports?

Then Microsoft Power BI is the right tool for you!


In this course you will learn – step by step – everything that is important in Power BI to become an advanced Power BI report creator.


That’s what you’ll learn:


Power BI Desktop, Power BI Cloud & Power BI Mobile!


✓ Understand everything from scratch – step by step, very structured and practice-oriented

✓ Learn all the important tools – know when and how to use them properly

✓ Connect different data sources – from basics to advanced

✓ Create your data model – and understand it

✓ Master DAX – to do more advanced analysis on your data

✓ Get to know all the different visualizations – and how to use them

✓ Storytelling with data – learn how to visualize your data effectively

✓ Create interactive visualizations – with drill throughs and drill downs

✓ Advanced analysis – learn how to use R Script in Power BI (Data Science)

✓ Forecasting – Advanced analytics which can be helpful in Data Science

✓ Row-Level Security – Implement the security concept to control access to the data



This course is right for you if...


... you have never worked with Power BI and want to learn everything hands-on in one course.

... OR you have already some basic knowledge and want to dive deeper and become more advanced in the whole universe of Power BI.


This is the course that covers everything in Power BI to become an advanced report devolopper! 

Enroll now to get life long access!

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

Yêu cầu

Nội dung khoá học

17 sections

Introduction

10 lectures
Welcome!
00:22
What is Power BI?
03:01
Download & Installing Power BI Desktop
04:06
Quick Interface Tour
04:31
Mini Project: Transform Data
06:52
Mini Project: Visualize Data
05:07
Mini Project: Creating a Data Model
07:21
Course Outline: What will you learn in this course?
05:02
How to lean best with this course?
03:18
All source files & course slides
00:12

Preparing our Project

2 lectures
Creating our initial project file
04:08
Working with the attached project files
03:51

Data Transformation - The Query Editor

26 lectures
Exploring the Query Editor
06:11
Connecting to our data source
06:48
Editing rows
08:10
Changing data types
08:24
Replacing values
03:27
Close & Apply
03:29
Connecting to a csv file
03:21
Connecting to a web page
05:04
Extracing characters
06:18
Splitting & merging columns
09:22
Creating conditional columns
05:52
A little note regarding the next lecture
00:31
Creating columns from examples
08:38
Merging Queries
17:23
Pivoting & Unpivoting
05:43
Appending Queries
08:20
Practice & Solution: Population table
14:30
The Fact-Dimension-Model
09:19
Practice: Load the dimension table
03:48
Organizing our queries in groups
02:59
Text to be used in the next lecture
00:12
Entering data manually
04:43
Creating an index column
03:04
Workflow & more transformations
04:38
Module summary
05:05
Exercise 1
1 question

Data Transformation - Advanced

12 lectures
Advanced Editor - Best practices
08:43
Performance: References vs. Duplicating
09:50
Performance: Enable / Disable Load & Report Refresh
04:31
Group by
04:47
Mathematical Operations
04:54
Run R Script
14:36
Using Parameters to dynamically transform data
06:28
M formula language: Basics
06:40
M formula language: Values, Lists & Tables
13:57
M formula language: Functions
13:13
M formula language: More functions & steps
05:02
Exercise 2
1 question

Creating a Data Model

8 lectures
Why a data model?
05:07
Create & edit relationships
06:16
One-to-many & one-to-one relationship
05:49
Many-to-many (m:n) relationship
08:15
Cross filter direction
05:56
Activate & deactivate relationships
05:52
Module summary
03:04
Exercise 3
1 question

Data Visualization

24 lectures
Our first visual
07:57
The format tab
11:52
Understanding tables
09:53
Conditional formatting
08:48
The Pie Chart
05:32
All about the filter visual
12:32
The filter pane for developers
08:52
Cross filtering & edit interactions
03:56
Exercise 4
1 question
Syncing slicers across pages
07:06
Creating drill downs
08:29
Creating drill throughs
06:50
The tree map visual
07:06
The decomposition tree
05:23
Understanding the matrix visual
05:17
Editing pages
07:15
Buttons & Actions
09:28
Bookmarks to customize your report
09:31
Analytics and Forecasts with line charts
10:12
Working with custom visuals
07:17
R Script to use
00:13
Get data using R Script & R Script visual
08:26
Asking questions - Q&A visual
03:45
Wrap up - data visualization
08:09

Power BI & Python

10 lectures
Python in Power BI - Plan of attack
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:18
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

DAX - The Essentials

15 lectures
Intro
02:32
The project data
04:09
DAX cheat sheet
00:12
All files for the DAX part
00:15
Measures vs. Calculated Columns
14:37
Automatically creating a date table in DAX
08:17
CALENDAR
05:08
Creating a complete date table with features
03:43
Script to be used in your future projects
00:26
Creating key measure table
03:19
Aggregation functions
06:07
The different versions of COUNT
14:05
SUMX - Row based calculations
08:32
DAX Exercise 1
01:18
DAX Solution 1
00:19

DAX - The CALCULATE function

7 lectures
CALCULATE - The basics
10:53
Changing the context with FILTER
06:31
ALL
07:53
ALLSELECTED
03:13
ALLEXCEPT
07:24
DAX Exercise 2
00:55
DAX Solution 2
00:19

DAX - Time Intelligence

4 lectures
Time Intelligence intro & DATEADD
11:18
Year-to-Date & Month-to-Date
05:19
TOTALYTD vs. DATESYTD
08:54
DATESBETWEEN
05:15

DAX - Advanced topics

4 lectures
Logical operators
09:27
Formatting & Commenting
05:48
Using Variables
09:47
Using quick measures in a smart way
04:11

Tell a story with your data - learn to visualize effectively

8 lectures
Intro - Best practices
01:01
Show empathy & indentify the requirements
02:37
Find the most suitable KPIs
02:18
Choose an effective visual
03:39
Make use of natural reading pattern
02:58
Tell a story using visual cues
05:21
Avoid chaos & group information
02:17
Wrap up - storytelling with data
01:41

Power BI Service - Power BI Cloud

18 lectures
How to go on now?
03:13
Power BI Pro vs Premium & Signing up
03:54
An alternative if you don't have a business email
00:24
Exploring the interface
04:10
Discovering your workspace
02:31
Little note on the next lecture - Uploading your report
00:32
Connecting Power BI Desktop & Cloud
04:00
Understanding datasets & reports
03:24
Working on reports
03:53
Updating reports from Power BI Desktop
04:29
Creating and working with workspaces
07:13
Installing & using a data gateway
12:53
Get Quick Insights
02:33
Creating dashboards
04:05
Sharing our results through Apps
10:09
Power BI Mobile App
05:26
Creating the layout for the Mobile App
03:46
Wrap up - Power BI Cloud
07:13

Row-Level Security

7 lectures
Intro
03:20
Creating a Row-Level Security
04:51
Row-Level Security in the Cloud
03:31
Row-Level Security & Data Model
04:38
Dynamic Row-Level Security
07:28
Dynamic Many-to-Many RLS
04:04
Hierarchical Row-Level Security
12:55

More data sources

4 lectures
JSON & REST API
09:57
Setting up a local MySQL database
14:01
Connecting to a MySQL database in Power BI
04:59
Connecting to a SQL database (PostgreSQL)
05:01

Next steps to improve & stay up to date

2 lectures
Congratulations & next steps
06:24
More data to practiсe
00:19

Bonus

1 lectures
Bonus lecture
01:07

Đá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?

Khoá học liên quan

Six Sigma: Certified Lean Six Sigma Black Belt | Accredited

Six Sigma: Certified Lean Six Sigma Black Belt | Accredited

99 VND
50.000 VND
The Data Analyst Course: Complete Data Analyst Bootcamp

The Data Analyst Course: Complete Data Analyst Bootcamp

185 VND
50.000 VND
Speak Like a Pro: Public Speaking for Professionals

Speak Like a Pro: Public Speaking for Professionals

119 VND
50.000 VND
Hotel Management - Revenue Management for Beginners

Hotel Management - Revenue Management for Beginners

1.099.000 VND
50.000 VND
Mastering Data Visualization: Theory and Foundations

Mastering Data Visualization: Theory and Foundations

99 VND
50.000 VND
Hướng Dẫn Bán Hàng Shopee từ A-Z: Bí Mật Nghìn Đơn Dễ Dàng

Hướng Dẫn Bán Hàng Shopee từ A-Z: Bí Mật Nghìn Đơn Dễ Dàng

25 VND
50.000 VND
7 bước thuyết phục bằng ngôn ngữ báo chí

7 bước thuyết phục bằng ngôn ngữ báo chí

399.000 VND
50.000 VND
Elasticsearch 8 and the Elastic Stack: In Depth and Hands On

Elasticsearch 8 and the Elastic Stack: In Depth and Hands On

1.799.000 VND
50.000 VND
The Ultimate Hands-On Hadoop: Tame your Big Data!

The Ultimate Hands-On Hadoop: Tame your Big Data!

2.199.000 VND
50.000 VND
LinkedIn Marketing & Lead Generation Bootcamp for B2B Sales

LinkedIn Marketing & Lead Generation Bootcamp for B2B Sales

1.499.000 VND
50.000 VND
Distillation columns : Principles , Operation & Design

Distillation columns : Principles , Operation & Design

1.699.000 VND
50.000 VND
Retail for Business Analysts and Management Consultants

Retail for Business Analysts and Management Consultants

1.399.000 VND
50.000 VND
Microsoft Power BI Portfolio in a Day

Microsoft Power BI Portfolio in a Day

849.000 VND
50.000 VND
Analytics Engineering Bootcamp

Analytics Engineering Bootcamp

65 VND
50.000 VND
Sales Forecasting

Sales Forecasting

899.000 VND
50.000 VND
Modern Dropshipping: Fast Shipping Times With Local Products

Modern Dropshipping: Fast Shipping Times With Local Products

1.699.000 VND
50.000 VND
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.

Get khoá học cho tôi