Microsoft Certified: Data Analyst Associate with Power BI
4.4 (1,148 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
31,106 students enrolled

Microsoft Certified: Data Analyst Associate with Power BI

Analyzing and Visualizing Data with Power BI Exam Guide
4.4 (1,148 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
31,106 students enrolled
Last updated 7/2020
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7.5 hours on-demand video
  • 5 articles
  • 10 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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
Requirements
  • Have a computer with an internet connection
Description

In this course the students will learn the entire Power BI interface. From connecting to a data source all the way through sharing insights with their organization. The main sections break down into connecting to data, building a data model, building visualizations, uncovering insights and sharing insights.

These lectures will break down all the concepts covered in the Exam DA-100 in simple, easy to follow lectures. These concepts will then be applied to a case study where the students will get to reinforce their learning.

So why take this course?

Trust. Once you finish this course you will have all the knowledge necessary to clear the Power BI DA-100 exam. Not only will you have intermediate knowledge of Power BI but you will also have proof. This proof can help you land your next analytics job. Whether you're starting out or looking for a promotion, a certification in BI will go a long way. Hiring managers need to know that you can actually analyze data effectively and this new Certification will help calm this concern.

Easy to Follow. Power BI is a complex tool but this course breaks down all the components of Power BI into their base elements. Once you have a solid understanding of a component of Power BI, this course will then apply what you've learned to a real world case study. Then finally, after you've learned about a skill then successfully applied it, this course will test your level of understanding through Q&A. This course is laid out in a very logical way so that each lecture builds off the previous lecture. By the time you finish this course you will have all the tools necessary to conduct effective analysis that will have a huge impact on your organization.

Applicable. This course is taught by a practicing professional. This means the case studies will be based off cutting edge use cases that provide real world value in the business world. No more learning basic, out of touch case studies from a book. This course will teach you all the fundamentals of Power BI plus give you some dashboard templates to help you tackle problems out in the business world.

Who this course is for:
  • Anyone interested in taking the Exam DA-100
  • Those Looking to Build Their Power BI Knowledge
  • Data Analysts
  • Business Analysts
  • Students Looking to Break into the Analytics Industry
Course content
Expand all 143 lectures 07:25:35
+ Introduction
10 lectures 17:39
Signing Up for Microsoft Trial Account
00:06
Get the Materials
00:05
Setting Expectations
03:47

Check out our Youtube channel here: https://www.youtube.com/channel/UCZ8UzvXx1bqdV9HInq1DM0A?sub_confirmation=1

Preview 04:27
How to Get an Analytics Job Podcast
00:05
BONUS: Learning Path
00:33
+ Power BI Basics
7 lectures 15:30
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 01:56:22
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
29 lectures 01:30:15
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
Optimize Model Performance
00:51
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
30 lectures 01:35:31
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
Create Dashboards
00:49
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

If you didn't save your work. Here's a link to the completed file from the previous section of the case study: https://drive.google.com/file/d/17KvnC_i2zdQUZsWuArmYsBeg4TV8mIM3/view?usp=sharing

Case Study 3.2
03:53

If you didn't save your work. Here's a link to the completed file from the previous section of the case study: https://drive.google.com/file/d/1YW5RND5lcFZZrPxnzi3AlWSThsogbYhD/view?usp=sharing

Case Study 3.3
05:42
+ Analyze the Data with Power BI
16 lectures 01:00:47
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 14:05
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 35:25
Section Introduction
00:52
Hiring Manager Interview: Emerging Trends in the Analytics Space
28:21
Analytics Industry Veteran: Power BI vs. Tableau
06:12