Microsoft Certified: Data Analyst Associate with Power BI

Name: Microsoft Certified: Data Analyst Associate with Power BI
Brand: Udemy
SKU: course:2864860
Rating: 4.3 (2493 reviews)

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

(2,493 ratings)

35,987 students

Created by John David Ariansen, Ligency Team

Last updated 1/2021

English

English [Auto]

30-Day Money-Back Guarantee

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

Curated for the Udemy for Business collection

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 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 on 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

Featured review

Ida Russell

45 courses

3 reviews

6 months ago

I loved this course. It was fast and straight to the point. There is not a lot of "fluff" or over exaggerated explanations. The modules are short, and you can easily go back to a section to walk through a process without having to look at an entire presentation to find the one thing you were looking for.

8 sections • 142 lectures • 7h 25m total length

Preview02:10
A Note About the Course Structure
01:43
Preview01:37
Preview02:27
Signing Up for Microsoft Trial Account
00:06
Get the Materials
00:05
Preview02:22
Setting Expectations
03:47
Preview04:27
How to Get an Analytics Job Podcast
00:05
BONUS: Learning Path
00:33

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

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

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

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

John David Ariansen

Experienced Tableau Consultant and Analytics Educator

4.3 Instructor Rating
3,512 Reviews
40,040 Students
5 Courses

I tell stories through data. Currently I am the Director of Analytics and Co-founder of Silvertone Analytics. We focus on three main verticals - Manufacturing, Marketing and Nonprofit Impact Analysis.

Outside of my consultancy, I work with students helping them break into the analytics field and I am also on the Board of Directors for Triad Local First, a nonprofit that promotes localism here in the Greensboro, NC. On the board I advise on how to leverage data to drive strategy but I also teach classes available to the 360 local member businesses on how they can use their data to drive their decision making process. I love getting to work with these small businesses!

I post weekly content to my Youtube channel focused on Tableau and how you can grow your Analytics Career.

Ligency Team

Helping Data Scientists Succeed

4.5 Instructor Rating
467,811 Reviews
1,676,910 Students
109 Courses

Hi there,

We are the Ligency PR and Marketing team. You will be hearing from us when new courses are released, when we publish new podcasts, blogs, share cheatsheets and more!

We are here to help you stay on the cutting edge of Data Science and Technology.

See you in class,

Sincerely,

The Real People at Ligency

Microsoft Certified: Data Analyst Associate with Power BI

What you'll learn

Requirements

Description

Who this course is for:

Featured review

Course content

Instructors

Microsoft Certified: Data Analyst Associate with Power BI

What you'll learn

Requirements

Description

Who this course is for:

Featured review

Course content

Introduction11 lectures • 19min

Power BI Basics7 lectures • 16min

Preparing Data with Power BI38 lectures • 1hr 56min

Modeling the Data with Power BI28 lectures • 1hr 29min

Visualize the Data with Power BI29 lectures • 1hr 35min

Analyze the Data with Power BI16 lectures • 1hr 1min

Deploy and Maintain Deliverables10 lectures • 14min

Conclusion3 lectures • 35min

Instructors