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 Practical Guide 2023

Microsoft Power BI - The Practical Guide 2023

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

Dive in and learn the Power BI tools! Learn Data Analysis & Visualization and more in Power BI Desktop & Power BI Pro!

image
50.000 VND
2.199.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ả

This course turned more than 250.000 students into Power BI professionals and was specifically created for business users who need to learn fast, comprehensive and efficient to get the job done!

-

In the course you can take two paths:

- The Complete Path (full >15h course also teaching more advanced concepts & features)

- The Summary Path (2h crash course to master Power BI as quick as possible)

Both approaches will teach you Power BI in great detail and turn you into a Power BI professional. You decide what learning type you are - it’s your choice!

-

You want to analyze data from single or multiple sources? You want to create your individual datasets based on these sources and transform your results into beautiful and easy-to-make visualizations? You also want to share your results with colleagues or collaborate on your projects? Finally, you want to be able to access your data from multiple devices?

Then the Power BI tools are the tools to choose for you!

In this course you will learn why Power BI offers you a comprehensive set of Business Intelligence tools for your data analysis goals and how to use these tools to fulfill all of the above tasks - and more. Imagine to quickly structure your data, to easily add calculations to it and to create and publish nice-looking charts in just a few minutes. 

This is what you will learn:

  • Get to know the different tools of the Power BI universe and learn how to use them

  • Understand Power BI Desktop and its components

  • Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two steps

  • Learn how to filter and format data, how pivoting and unpivoting works

  • How to work in the different views of the Data Model

  • How to create calculated columns and measures

  • How to build relationships between different tables

  • How to create a report with different interactive visualization types

  • Learn how to use Power BI Pro to create dashboards and to share and publish your results

  • How to access your results from multiple devices using Power BI Mobile

  • And more!

Don't miss this opportunity to become a Power BI expert today! Enrol now, unlock your potential & transform your career today!

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

At the end of this course students will be able to analyse data from different data sources and create their own datasets

Students will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together

Students will have the required knowledge to dive deeper into Power BI and find out more about its advanced features

Yêu cầu

  • For the majority of the course you must have a computer with Windows as operating system
  • Basic understanding of data analysis is a plus but not required
  • For multiple modules of this course a work or school email address is required to sign up

Nội dung khoá học

14 sections

Getting Started

11 lectures
Welcome to This Course
00:55
What is Power BI?
05:46
Installing Power BI Desktop
03:33
Connecting Power BI Desktop to Source Files
10:06
Creating our First Visuals
07:34
Join our Online Learning Community
00:23
Comparing Excel & Power BI
03:20
Course Outline
05:30
The Two Ways (Paths) Of Taking This Course
02:22
How to Get the Most Out of This Course
03:14
Important: How to Access Course Resources, Project Files & Slides
09:48

Understanding the Power BI Desktop Basics & Preparing the Course Project

4 lectures
Module Introduction
01:26
The Power BI Desktop Workflow
05:15
Interface Tour
09:27
Important! Creating the Project Template & Recommended Settings
05:37

Data Preparation in the Power Query Editor

22 lectures
Module Introduction
01:12
Understanding Data Preparation / Cleaning / Cleansing
04:50
Connecting Power BI Desktop to Source Files
10:35
How Power BI Queries Data
05:01
Understanding Basic Row Operations
09:07
Filtering Data
06:00
Analyzing Columns & Removing Blank Fields
10:59
Understanding & Using the Append Feature
08:27
Choosing & Removing Columns
07:05
Append Behind the Scenes
02:50
Understanding the Transpose Feature
02:58
Replacing Values
07:35
Working with Dates - The Basics
06:50
Understanding Data Formats
05:50
Handling Data Format Errors
08:18
Understanding Pivoting & Unpivoting
04:30
Applying Pivoting & Unpivoting
03:55
Fixing a Sorting Problem
02:11
Extracting Data, Splitting Columns & Sorting Multiple Columns
09:24
Introducing the "Group By" Feature
04:20
Improving the Project Structure
03:16
Wrap Up
03:06

Data Transformation in the Power Query Editor

25 lectures
Module Introduction
00:56
Data Warehouse, Data Model & Data Schema
05:45
The Star Schema - Theory
06:14
Applying the Star Schema to our Project
02:26
Understanding References
04:07
Comparing References & Duplicates
06:39
Importing Country & Region Codes
07:53
Using "Enter Data" to Create a Table
03:01
Understanding the Merge Feature
03:29
How to Join Tables
03:19
Understanding Outer, Inner & Anti Joins
05:37
Join Kind in Practice
05:02
Handling Merge Errors
11:31
Understanding the DIM-age Table
03:26
Bringing Back the "age-group" Column
04:41
Getting the Maximum Values From Each Age Group
03:30
Creating Conditional Columns
07:23
Creating an Index Column
02:26
Creating a DIM-gender Table
03:16
Understanding the FACT Table
03:02
Finishing the FACT Table
08:50
Applying Basic Mathematical Operations
02:30
Using the Enable Load Feature
06:58
Wrap Up
02:46
Time to Practice - Query Editor
1 question

The Data Model: Working with Relationships & DAX (Data Analysis Espressions)

36 lectures
Module Introduction
01:26
Query Editor vs Data Model
04:39
Understanding Relationships
02:34
Creating our First Relationship
09:59
Understanding Cardinality & Difference Relationship Types
02:23
One to Many & Many to One
02:23
One to One
01:38
Many to Many
03:28
Fixing the Column Order Bug
03:33
Understanding the Cross Filter Direction
11:15
Understanding Active Properties
01:41
Adding Relationships to the Project
06:56
M-Language vs DAX (Data Analysis Expressions)
04:17
Creating a Custom Column with the M-Language
06:29
Creating a Calculated Column with DAX
07:01
M vs DAX - What Should I Choose?
02:24
The DAX Basics
02:59
The Core DAX Syntax
04:01
DAX Data Types
02:59
DAX Operators
04:54
DAX Core Functions
04:19
Creating a Table with the CALENDAR Function
11:48
Extracting Data with the DOT Notation
04:05
Adding & Dividing Columns
08:00
Working with IF Functions
06:42
Understanding Relationship Functions
04:40
Calculated Column vs Measure
01:51
Understanding & Creating Measures
05:14
Working with FILTER & CALCULATE Functions - Theory
05:44
Combining CALCULATED & FILTER Functions
09:11
Adding the Filter Condition to CALCULATE
03:32
Using Measures in Measures
04:24
Changing the Measure's Home Table
04:20
Understanding the Data Category
03:00
Wrap Up
02:39
Time to Practice - Data Model & Relationships
1 question

Creating Visuals in the Report View

31 lectures
Module Introduction
01:03
The Power BI Workflow & Understanding Basics Visual Elements
04:49
Creating & Duplicating Pages
02:08
Organizing Visuals
06:02
Creating a New Visual
03:00
Creating Line & Column Charts
07:02
How FILTER Affects the Visual
06:39
Understanding Interactions
05:22
Hierarchies & Drill Down
07:30
Formatting Chart Colors
07:50
The Canvas
03:00
Formatting the Page Background / Wallpaper
02:37
Formatting the Filter Pane & Filter Cards
07:17
Formatting Visuals: General Settings
04:42
Diving Deeper Into Formatting Visuals
08:04
Working with Report Themes
07:13
Finishing the Report Theme
02:23
Understanding the Slicer
09:35
Default Summarization & Sorting Order
04:20
Creating Treemaps & Working with Multiple Slicers
06:36
Creating Tables
06:36
Syncing Slicers
03:11
Filter on Visual, Page & Report Level
09:47
Creating Single & Multi Row Cards
07:48
Adding a Secondary Y-Axis
04:34
Combining Column & Line Charts
02:51
The Waterfall Chart
03:11
Importing Visuals
02:18
Finishing Touches
05:09
Wrap Up
04:24
Time to Practice - Visualizations
1 question

Power BI Pro & Mobile: Sharing & Collaborating with Workspaces & Apps

24 lectures
Module Introduction
01:52
The Next Steps
04:57
Power BI Pro Pricing
04:14
Power BI Pro Interface Tour
06:38
Publishing & My Workspace - Theory
03:19
Publishing / Importing Power BI Desktop Projects to Pro
04:10
Datesets Walkthrough
04:25
List View vs Lineage View
04:02
Exploring Reports In Pro
04:46
Understanding Dashboards
07:20
Creating Reports & Dashboards
07:32
Diving Deeper Into "My Workspace", Understanding Refresh and a Refresh Error
04:34
Gateways - Theory
01:40
Gateways: Configuring Manual & Scheduled Refreshs
11:53
Sharing Data From "My Workspace" via Direct Access
13:44
Sharing Links
05:42
Understanding Collaboration Workspaces - Theory
01:37
Creating Colaboration Workspaces
08:09
Sharing Data via Apps
01:38
Publishing & Unpublishing Apps
09:20
Deleting Collaboration Workspaces
01:15
Workspaces vs Apps
02:19
Working with Power BI Mobile
05:48
Wrap Up
02:48

Other Data Sources

7 lectures
Module Introduction
01:21
Importing JSON Data
06:28
Updated Star Wars API URL
00:08
Importing Data from REST APIs
05:00
Preparation: Setting up a MySQL Server
08:09
Importing Data from a MySQL Server (and other SQL Servers)
06:38
Wrap Up
00:56

How to Stay Up-to-Date in the Power BI World?

3 lectures
Module Introduction
00:43
Helpful Resources
05:01
Using Preview Features
01:17

Course Round Up

1 lectures
Congratulations! What you Learned & How to Continue
06:36

Optional: Power BI Desktop Crash Course / Introduction & Summary

33 lectures
Module Introduction
01:29
Project Setup
03:55
Connecting Power BI Desktop to the Source Files
01:53
Query Editor Walkthrough
04:27
Removing Blank Rows & Fixing Format Errors
05:08
Saving the Project
00:54
Duplicates vs References
07:27
Appending Queries
04:46
Splitting Columns & Extracting Data
03:04
Basic Column Interactions
02:56
Data Modelling Theory
06:20
Creating the "Orders" Table
03:41
Working with Indexes
03:15
The Formula Bar
04:17
Merging Queries
04:25
Loading Data Into the Data Model
06:11
Creating Line Charts
05:28
Understanding Relationships
05:32
Formatting Numbers in Charts
03:15
Understanding Interactions
03:11
Hierarchies & Drill-Down
05:10
Sorting Axis Values
01:36
Formatting Visuals & Applying Report Themes
03:15
Reports, Map Visual & Default Summarization
04:35
The Data Category
01:40
Applying Filters to Visuals
04:53
Understanding Slicers
04:10
Creating Tables
04:59
Working with DAX ("Data Analytics Expressions")
06:07
Sorting Weekdays with Calculated Columns
04:25
Fixing the Revenue Calculation
01:50
Introducing Measures
07:14
Working with Quick Measures
05:03

Bonus: Selected Features by Example & Refresher Project

7 lectures
About this Module
00:23
Understanding Column from Examples
06:34
Group By, Big Data & DAX Studio
09:42
Please Read: Bonus Project Introduction
00:14
Taxi Project - Query Editor
22:12
Taxi Project - Data Model & Visuals
22:20
Taxi Project - Power BI Service
15:32

This Course Was Completely Updated

1 lectures
Old Course Content Download
00:38

Course Roundup

2 lectures
Course Roundup
00:55
Bonus: More Content!
00:20

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