Home

All courses

Microsoft Certified: Data Analyst Associate with Power BI

Business

Business Analytics & Intelligence

Microsoft Power BI

Microsoft Certified: Data Analyst Associate with Power BI

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

4.4

(6484)

56968 enrolled on this course

Last updated 11/2021

John David Ariansen

₹ 3499.0

₹ 4999.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

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

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

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction

1.1-Welcome! Course Overview

1.2-A Note About the Course Structure

1.3-Installing Power BI Desktop

1.4-Setting Up Power BI Service

1.5-Signing Up for Microsoft Trial Account

1.6-Get the Materials

1.7-Excel vs. Power BI

1.8-Setting Expectations

1.9-What is the Value of a Power BI Certification?

1.10-How to Get an Analytics Job Podcast

1.11-EXTRA: Learning Path

2-Power BI Basics

2.1-Section Introduction

2.2-Business Challenge Blueprint

2.3-Prepare the Data

2.4-Model the Data

2.5-Visualize the Data

2.6-Analyze the Data

2.7-Deploy and Maintain Deliverables

3-Preparing Data with Power BI

3.1-Section Introduction

3.2-Get Data from Different Sources

3.3-Choosing the Correct Type of Query

3.4-Data Source Settings

3.5-Select a Shared Dataset or Create a Local Data Set

3.6-Select a Storage Mode

3.7-Identify Query Perfomance Issues

3.8-Use Parameters

3.9-Profile The Data

3.10-Identify Data Anomalies

3.11-Examine Data Structures

3.12-Interrogate Column Properties and Statistics

3.13-Clean, Transform and Load the Data

3.14-Resolve Inconsistencies, Unexpected or Null Values, and Data Quality Issues

3.15-Apply User Friendly Value Replacements

3.16-Identify and Create Appropriate Keys for Joins

3.17-Evaluate and Transform Column Data Types

3.18-Apply Data Shape Transformations to Table Structures

3.19-Combine Queries Through Merge

3.20-Combine Queries Through Append

3.21-Apply User-Friendly Naming Conventions to Columns and Queries

3.22-Leverage Advanced Editor to Modify Power Query M Code

3.23-Configure Data Loading

3.24-Resolve Data Import Errors

3.25-Additional Prepare the Data Lectures

3.26-Query Editor

3.27-Changing Locale

3.28-Basic Transformations

3.29-Text Transformations

3.30-Date Transformations

3.31-Creating a Calculated Column

3.32-Creating Conditional Columns

3.33-Understanding Pivoting and Unpivoting

3.34-Connecting to a Folder

3.35-Query Dependency View

3.36-Case Study Introduction

3.37-Case Study Part 1.1

3.38-Case Study Part 1.2

4-Modeling the Data with Power BI

4.1-Section Introduction

4.2-What is a data model?

4.3-Design a Data Model

4.4-Define the Tables

4.5-Configure Table and Column Properties

4.6-Define Quick Measures

4.7-Flatten Out a Parent Child Hierarchy

4.8-Design the Data Model to Meet Performance Requirements

4.9-Resolve Many to Many Relationships

4.10-Create a Common Date Table

4.11-Define the Appropriate Level of Data Granularity

4.12-Create Calculated Tables

4.13-Create Hierarchies

4.14-Implement Row-Level Security Roles

4.15-Set Up the Q&A Feature

4.16-Create Measures by Using DAX

4.17-Use DAX to Build Complex Measures

4.18-Use CALCULATE to Manipulate Filters

4.19-Implement Time Intelligence Using DAX

4.20-Replace Numeric Columns with Measures

4.21-Remove Unnecessary Rows and Columns

4.22-Additional Model the Data Lectures

4.23-Understanding Cardinality

4.24-Types of Tables

4.25-Filter Direction

4.26-Two Way Filtering Direction

4.27-Manage Query Group

4.28-Case Study Part 2

5-Visualize the Data with Power BI

5.1-Section Introduction

5.2-Create Reports

5.3-Add Visualization Items to Reports

5.4-Choose an Appropriate Visualization Type

5.5-Format and Configure Visualizations

5.6-Import a Custom Visual

5.7-Apply Filtering

5.8-Configure the Report Page

5.9-Set Mobile View

5.10-Use the Q&A Feature

5.11-Create Custom Tooltips

5.12-Edit and Configure Interactions Between Visuals

5.13-Configure Sync Slicers

5.14-Use the Selection Pane

5.15-Drilldown into Data Using Interactive Visuals

5.16-Export Report Data

5.17-Additional Visualize the Data Lectures

5.18-Use Drilldown Functionality within a Hierarchy

5.19-Include and Exclude Data

5.20-Creating Bar Charts

5.21-Creating Line and Area Graphs

5.22-Pie Charts, Donut Charts and Treemaps

5.23-Focus Mode, See Data and Exporting Data

5.24-Adding Shapes, Images and Textboxes

5.25-Creating Maps

5.26-Creating a Table and Matrix

5.27-Case Study 3.1

5.28-Case Study 3.2

5.29-Case Study 3.3

6-Analyze the Data with Power BI

6.1-Section Introduction

6.2-Enhance Reports to Expose Insights

6.3-Color and Conditional Formatting

6.4-Apply Slicers

6.5-Perform Top N Analysis

6.6-Create Reference Lines by Using Analytics Pane

6.7-Use the Play Axis Feature of a Visualization

6.8-Perform Advanced Analysis

6.9-Conduct Time Series Analysis

6.10-Grouping and Binning

6.11-Use the Key Influencers to Explore Dimensional Variances and Outliers

6.12-Use the Decomposition Tree Visual to Break Down Measure

6.13-Apply AI Insights

6.14-Case Study 4.1

6.15-Case Study 4.2

6.16-Case Study 4.3

7-Deploy and Maintain Deliverables

7.1-Section Introduction

7.2-Manage Datasets

7.3-Install a Gateway

7.4-Configure a Dataset Scheduled Refresh

7.5-Configure Row Level Security Membership

7.6-Providing Access to a Dataset

7.7-Endorse a Dataset

7.8-Create and Manage Workspaces

7.9-Create and Configure a Workspace

7.10-Assign Workspace Roles

8-Conclusion

8.1-Section Introduction

8.2-Hiring Manager Interview: Emerging Trends in the Analytics Space

8.3-Analytics Industry Veteran: Power BI vs. Tableau

9-Congratulations!! Don't forget your Prize :)

9.1-Bonus: How To UNLOCK Top Salaries (Live Training)

Course Categories

Popular Courses

Microsoft Certified: Data Analyst Associate with Power BI

Description

What you'll learn

Requirements

Course Content

You May Like