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 Certified: Data Analyst Associate with Power BI

Microsoft Certified: Data Analyst Associate with Power BI

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

Analyzing and Visualizing Data with Microsoft Power BI - Exam Guide. Get Microsoft Certification in 30 days.

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

The BI industry is booming, and every day, more hiring managers and recruiters are looking for professionals who not only know their way around BI tools, but have certifications to back their claims.

Knowing this, what are you doing to let everyone know you mean business?

Becoming Power BI certified is a must if you want to remain competitive in the analytics job market. Employers need to know that you can use their BI stack without training, and certifications do just that—they endorse the skills that can’t be measured on a resume, portfolio, or in an interview.

By mastering Power BI, you become more efficient at work and are able to communicate and uncover deeper insights than before. You also gain the confidence to lead more projects and solve complex business challenges.

And that's where this course comes into play.

The Microsoft Certified: Data Analyst Associate with Power BI course is modeled directly from the DA-100 exam structure, so you can rest assured that everything that you'll see in the Microsoft PowerBI exam, you'll also see it in the course, and in the same order!

So, get ready for your Power BI certification and master everything you need to know to pass the DA-100 exam. Learn to prepare, model, visualize, and analyze data; deploy and maintain deliverables in Power BI. Plus, DAX, advanced data visualization techniques, and more.

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

How to connect to data

How to transform data sources

How to create a data model

How to build visualizations

How to share your insights with others in your organization

Learn all the topics covered in the Microsoft DA-100 PowerBI Exam

Yêu cầu

  • Have a computer with an internet connection

Nội dung khoá học

9 sections

Introduction

11 lectures
Welcome! Course Overview
02:10
A Note About the Course Structure
01:43
Installing Power BI Desktop
01:37
Setting Up Power BI Service
02:27
Signing Up for Microsoft Trial Account
00:06
Get the Materials
00:18
Excel vs. Power BI
02:22
Setting Expectations
03:47
What is the Value of a Power BI Certification?
04:27
How to Get an Analytics Job Podcast
00:05
EXTRA: Learning Path
00:33

Power BI Basics

7 lectures
Section Introduction
01:21
Business Challenge Blueprint
02:02
Prepare the Data
02:33
Model the Data
02:46
Visualize the Data
02:31
Analyze the Data
02:23
Deploy and Maintain Deliverables
01:54

Preparing Data with Power BI

38 lectures
Section Introduction
00:25
Get Data from Different Sources
00:48
Choosing the Correct Type of Query
02:02
Data Source Settings
01:22
Select a Shared Dataset or Create a Local Data Set
01:11
Select a Storage Mode
02:17
Identify Query Perfomance Issues
03:46
Use Parameters
04:49
Profile The Data
00:34
Identify Data Anomalies
03:38
Examine Data Structures
01:49
Interrogate Column Properties and Statistics
02:41
Clean, Transform and Load the Data
00:53
Resolve Inconsistencies, Unexpected or Null Values, and Data Quality Issues
05:21
Apply User Friendly Value Replacements
02:01
Identify and Create Appropriate Keys for Joins
03:23
Evaluate and Transform Column Data Types
03:12
Apply Data Shape Transformations to Table Structures
04:48
Combine Queries Through Merge
03:23
Combine Queries Through Append
02:22
Apply User-Friendly Naming Conventions to Columns and Queries
04:24
Leverage Advanced Editor to Modify Power Query M Code
03:13
Configure Data Loading
01:42
Resolve Data Import Errors
02:59
Additional Prepare the Data Lectures
00:52
Query Editor
03:45
Changing Locale
01:36
Basic Transformations
03:08
Text Transformations
04:55
Date Transformations
04:37
Creating a Calculated Column
02:26
Creating Conditional Columns
04:15
Understanding Pivoting and Unpivoting
04:30
Connecting to a Folder
03:06
Query Dependency View
01:59
Case Study Introduction
00:55
Case Study Part 1.1
06:53
Case Study Part 1.2
10:22

Modeling the Data with Power BI

28 lectures
Section Introduction
00:37
What is a data model?
03:41
Design a Data Model
00:46
Define the Tables
02:03
Configure Table and Column Properties
05:00
Define Quick Measures
04:05
Flatten Out a Parent Child Hierarchy
04:12
Design the Data Model to Meet Performance Requirements
02:16
Resolve Many to Many Relationships
02:22
Create a Common Date Table
03:42
Define the Appropriate Level of Data Granularity
03:05
Create Calculated Tables
02:24
Create Hierarchies
04:29
Implement Row-Level Security Roles
04:16
Set Up the Q&A Feature
03:45
Create Measures by Using DAX
02:57
Use DAX to Build Complex Measures
02:58
Use CALCULATE to Manipulate Filters
03:09
Implement Time Intelligence Using DAX
03:48
Replace Numeric Columns with Measures
03:36
Remove Unnecessary Rows and Columns
02:43
Additional Model the Data Lectures
00:51
Understanding Cardinality
03:35
Types of Tables
02:15
Filter Direction
03:14
Two Way Filtering Direction
02:00
Manage Query Group
02:08
Case Study Part 2
09:27

Visualize the Data with Power BI

29 lectures
Section Introduction
00:31
Create Reports
00:59
Add Visualization Items to Reports
02:41
Choose an Appropriate Visualization Type
05:08
Format and Configure Visualizations
03:11
Import a Custom Visual
01:23
Apply Filtering
05:41
Configure the Report Page
03:35
Set Mobile View
02:33
Use the Q&A Feature
03:01
Create Custom Tooltips
03:55
Edit and Configure Interactions Between Visuals
01:54
Configure Sync Slicers
01:47
Use the Selection Pane
02:16
Drilldown into Data Using Interactive Visuals
03:05
Export Report Data
02:32
Additional Visualize the Data Lectures
01:08
Use Drilldown Functionality within a Hierarchy
03:06
Include and Exclude Data
01:42
Creating Bar Charts
07:25
Creating Line and Area Graphs
03:57
Pie Charts, Donut Charts and Treemaps
02:56
Focus Mode, See Data and Exporting Data
02:02
Adding Shapes, Images and Textboxes
02:16
Creating Maps
03:22
Creating a Table and Matrix
05:34
Case Study 3.1
07:27
Case Study 3.2
03:53
Case Study 3.3
05:42

Analyze the Data with Power BI

16 lectures
Section Introduction
00:31
Enhance Reports to Expose Insights
00:42
Color and Conditional Formatting
03:36
Apply Slicers
02:29
Perform Top N Analysis
03:16
Create Reference Lines by Using Analytics Pane
07:09
Use the Play Axis Feature of a Visualization
01:59
Perform Advanced Analysis
00:36
Conduct Time Series Analysis
04:50
Grouping and Binning
03:28
Use the Key Influencers to Explore Dimensional Variances and Outliers
06:52
Use the Decomposition Tree Visual to Break Down Measure
03:06
Apply AI Insights
02:10
Case Study 4.1
07:46
Case Study 4.2
06:41
Case Study 4.3
05:36

Deploy and Maintain Deliverables

10 lectures
Section Introduction
00:42
Manage Datasets
00:48
Install a Gateway
00:04
Configure a Dataset Scheduled Refresh
02:49
Configure Row Level Security Membership
01:13
Providing Access to a Dataset
02:11
Endorse a Dataset
02:25
Create and Manage Workspaces
00:31
Create and Configure a Workspace
01:52
Assign Workspace Roles
01:30

Conclusion

3 lectures
Section Introduction
00:52
Hiring Manager Interview: Emerging Trends in the Analytics Space
28:21
Analytics Industry Veteran: Power BI vs. Tableau
06:12

Congratulations!! Don't forget your Prize :)

1 lectures
BONUS: Cloud Skills for ML & AI (COUPON inside)
01:39

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

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
Piping Design Engineering & Piping Isometrics Masterclass

Piping Design Engineering & Piping Isometrics Masterclass

1.499.000 VND
50.000 VND
ChatGPT4- ChatGPT for Product management & Business analysis

ChatGPT4- ChatGPT for Product management & Business analysis

429.000 VND
50.000 VND
Become a Product Manager | Learn the Skills & Get the Job

Become a Product Manager | Learn the Skills & Get the Job

2.199.000 VND
50.000 VND
Learn to build an e-commerce app with .Net Core and Angular

Learn to build an e-commerce app with .Net Core and Angular

1.799.000 VND
50.000 VND
The Ultimate Project Management PMP Prep Course (35 PDUs)

The Ultimate Project Management PMP Prep Course (35 PDUs)

1.799.000 VND
50.000 VND
ChatGPT Masterclass: ChatGPT Guide for Beginners to Experts!

ChatGPT Masterclass: ChatGPT Guide for Beginners to Experts!

1.249.000 VND
50.000 VND
Discover, Validate & Launch New Business Ideas with ChatGPT

Discover, Validate & Launch New Business Ideas with ChatGPT

1.399.000 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
Amazon KDP Niche Research Mastery (Kindle Direct Publishing)

Amazon KDP Niche Research Mastery (Kindle Direct Publishing)

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