OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.

Microsoft Certified

Data Analyst Associate with Power BI

John David Ariansen, SuperDataScience Team, and Ligency Team

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.

Read more

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.

Enroll now

What's inside

Learning objectives

  • 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

Syllabus

Introduction
Welcome! Course Overview
A Note About the Course Structure
Installing Power BI Desktop
Read more
Setting Up Power BI Service
Signing Up for Microsoft Trial Account
Get the Materials
Excel vs. Power BI
Setting Expectations

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

How to Get an Analytics Job Podcast
EXTRA: Learning Path
Power BI Basics
Section Introduction
Business Challenge Blueprint
Prepare the Data
Model the Data
Visualize the Data
Analyze the Data
Deploy and Maintain Deliverables
Preparing Data with Power BI
Get Data from Different Sources
Choosing the Correct Type of Query
Data Source Settings
Select a Shared Dataset or Create a Local Data Set
Select a Storage Mode
Identify Query Perfomance Issues
Use Parameters
Profile The Data
Identify Data Anomalies
Examine Data Structures
Interrogate Column Properties and Statistics
Clean, Transform and Load the Data
Resolve Inconsistencies, Unexpected or Null Values, and Data Quality Issues
Apply User Friendly Value Replacements
Identify and Create Appropriate Keys for Joins
Evaluate and Transform Column Data Types
Apply Data Shape Transformations to Table Structures
Combine Queries Through Merge
Combine Queries Through Append
Apply User-Friendly Naming Conventions to Columns and Queries
Leverage Advanced Editor to Modify Power Query M Code
Configure Data Loading
Resolve Data Import Errors
Additional Prepare the Data Lectures
Query Editor
Changing Locale
Basic Transformations
Text Transformations
Date Transformations
Creating a Calculated Column
Creating Conditional Columns
Understanding Pivoting and Unpivoting
Connecting to a Folder
Query Dependency View
Case Study Introduction
Case Study Part 1.1
Case Study Part 1.2
Modeling the Data with Power BI
What is a data model?
Design a Data Model
Define the Tables
Configure Table and Column Properties
Define Quick Measures
Flatten Out a Parent Child Hierarchy
Design the Data Model to Meet Performance Requirements
Resolve Many to Many Relationships
Create a Common Date Table
Define the Appropriate Level of Data Granularity
Create Calculated Tables
Create Hierarchies
Implement Row-Level Security Roles
Set Up the Q&A Feature
Create Measures by Using DAX
Use DAX to Build Complex Measures
Use CALCULATE to Manipulate Filters
Implement Time Intelligence Using DAX
Replace Numeric Columns with Measures
Remove Unnecessary Rows and Columns
Additional Model the Data Lectures
Understanding Cardinality
Types of Tables
Filter Direction
Two Way Filtering Direction
Manage Query Group
Case Study Part 2
Visualize the Data with Power BI
Create Reports
Add Visualization Items to Reports
Choose an Appropriate Visualization Type
Format and Configure Visualizations
Import a Custom Visual
Apply Filtering
Configure the Report Page
Set Mobile View
Use the Q&A Feature
Create Custom Tooltips

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Modeled directly from the DA-100 exam structure, which ensures comprehensive coverage of the material needed to pass the Microsoft Power BI certification exam
Covers preparing, modeling, visualizing, and analyzing data, which are essential skills for data analysts working with Power BI in a professional setting
Includes instruction on DAX and advanced data visualization techniques, which are critical for creating insightful and impactful reports and dashboards in Power BI
Requires learners to sign up for a Microsoft Trial Account, which may pose a barrier to some learners who do not have access to this service or are restricted from using it
Teaches learners how to deploy and maintain deliverables in Power BI, which is a crucial aspect of data analysis that ensures insights are accessible and up-to-date
Includes case studies to reinforce learning, which allows learners to apply their knowledge and skills to real-world scenarios and deepen their understanding of Power BI

Save this course

Save Microsoft Certified: Data Analyst Associate with Power BI to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft Certified: Data Analyst Associate with Power BI with these activities:
Review Excel Fundamentals
Reinforce your understanding of Excel, as Power BI builds upon many Excel concepts.
Browse courses on Excel
Show steps
  • Review basic formulas and functions.
  • Practice creating charts and graphs.
  • Familiarize yourself with pivot tables.
Review 'Storytelling with Data'
Improve your ability to communicate insights effectively through data visualizations by learning storytelling techniques.
View Storytelling with You: Plan, Create, and... on Amazon
Show steps
  • Read the chapters on choosing the right visuals and eliminating clutter.
  • Analyze examples of effective and ineffective data visualizations.
  • Apply the principles to your own Power BI reports.
Review 'The Definitive Guide to DAX'
Deepen your understanding of DAX, which is crucial for creating advanced measures and calculations in Power BI.
View The Definitive Guide to DAX: Business... on Amazon
Show steps
  • Read the chapters on CALCULATE and time intelligence functions.
  • Work through the examples provided in the book.
  • Try implementing the concepts in Power BI using sample datasets.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Follow Advanced Visualization Tutorials
Enhance your visualization skills by following tutorials on advanced chart types and techniques.
Browse courses on Visualization
Show steps
  • Search for tutorials on creating custom visuals in Power BI.
  • Follow tutorials on using advanced formatting options.
  • Experiment with different chart types to find the best way to present your data.
DAX Function Exercises
Solidify your DAX skills through targeted exercises, focusing on common functions and scenarios.
Browse courses on DAX
Show steps
  • Find online resources with DAX practice questions.
  • Solve exercises related to CALCULATE, FILTER, and ALL functions.
  • Create your own practice scenarios based on real-world business problems.
Build a Personal Finance Dashboard
Apply your Power BI skills to a practical project by creating a dashboard to track your personal finances.
Show steps
  • Gather your financial data from bank statements and other sources.
  • Import and clean the data in Power BI.
  • Create visualizations to track income, expenses, and savings.
  • Design an interactive dashboard with filters and drill-down capabilities.
Contribute to a Power BI Community Project
Deepen your understanding of Power BI by contributing to an open-source project related to data analysis or visualization.
Browse courses on Power BI
Show steps
  • Find an open-source Power BI project on GitHub or a similar platform.
  • Identify areas where you can contribute, such as bug fixes, documentation, or new features.
  • Submit your contributions and participate in the project's community.

Career center

Learners who complete Microsoft Certified: Data Analyst Associate with Power BI will develop knowledge and skills that may be useful to these careers:
Data Analyst
Data analysts are crucial for organizations looking to leverage data for strategic decision making. This role involves collecting, cleaning, and interpreting large datasets. A data analyst builds reports and dashboards that help stakeholders understand complex trends. This course, designed around the Microsoft DA-100 Power BI exam, helps build a foundation for preparing, modeling, visualizing and analyzing data. The course's focus on using Power BI to create visualizations and reports directly aligns with the core responsibilities of a data analyst, making this course important for those wishing to enter the field.
See salaries and explore the career path for Data Analyst
Business Intelligence Analyst
A business intelligence analyst transforms raw data into actionable insights, using tools like Power BI to create reports and dashboards that guide business strategy. They work closely with various departments to understand their data needs and provide data-driven solutions. Because this course is centered on Power BI, a core tool for a business intelligence analyst, it is a useful step for those in the field. This course covers data preparation, modeling, analysis, and visualization, all of which are needed to excel as a business intelligence analyst.
See salaries and explore the career path for Business Intelligence Analyst
Report Developer
Report developers are specialists who design and create reports for organizations, often using specific business intelligence tools and programming. They collect requirements, build data models, and design visualizations that clearly communicate insights. This course provides a direct route into the role of a report developer. The extensive coverage of Power BI in this course allows you to master the software needed for report creation. The course also covers how to model, visualize and analyze data, which is important for creating effective reports.
See salaries and explore the career path for Report Developer
Analytics Consultant
An analytics consultant works with clients to identify their data needs, craft strategies, and develop analytical solutions. This role demands a strong grasp of data interpretation and presentation, and often requires expertise in data visualization tools. This course helps build a foundation for these skills, as it is heavily focused on data visualization, modeling and analysis tools within Power BI. This program is useful for anyone looking to consult on analytics, as it provides the practical skills to deliver on data driven solutions, and the confidence to lead projects.
See salaries and explore the career path for Analytics Consultant
Data Visualization Specialist
A data visualization specialist focuses on creating clear, compelling, and interactive visualizations that communicate complex data insights. This role requires creativity and a deep understanding of data presentation principles. This course helps you build a foundation for data visualization. The course’s focus on preparing, modeling, and visualizing data in Power BI, as well as advanced techniques makes this course useful for a aspiring data visualization specialist. It also provides practical experience in creating visualizations.
See salaries and explore the career path for Data Visualization Specialist
Database Administrator
A database administrator (DBA) is responsible for the performance, integrity, and security of databases. This role ensures that data is accessible, optimized, and secure. While a DBA primarily works with database systems, understanding how data is transformed and visualized is a benefit. This course provides insight into how Power BI connects to, transforms and models data. It might be useful for a DBA to take this course to better grasp the end-to-end data workflow. Understanding how data is used can help make a DBA more effective in their role.
See salaries and explore the career path for Database Administrator
Financial Analyst
Financial analysts interpret financial data, develop reports, and provide recommendations to help businesses make informed decisions. This work involves creating financial models and using data to forecast trends. Although this course does not directly cover finance, it may be useful for a financial analyst because it provides skills in data visualization, modeling, and analysis with Power BI. These skills can be applied to financial data to improve reporting and analysis. The course provides a method for preparing, modeling, and visualizing data, which can be useful for this role.
See salaries and explore the career path for Financial Analyst
Market Research Analyst
Market research analysts study market conditions to examine potential sales of a product or service. They gather and analyze data on consumer behavior, demographics, and competitor strategies. This involves using various data tools to present findings to stakeholders. While this course cannot directly make someone a market research analyst, it may be useful because it focuses on data visualization using Power BI. This will be an important skill for a market research analyst who needs to present data to stakeholders. This course provides an introduction to these skills.
See salaries and explore the career path for Market Research Analyst
Operations Analyst
An operations analyst examines and improves business processes by analyzing data and making recommendations on efficiency. They use a variety of tools to monitor performance and identify areas for improvement. While this course does not directly cover operations management, it may be helpful as a tool for presenting the data used in an operations analyst role. The skills in Power BI learned through this course can be applied to analyze and visualize operational data. This course will help an operations manager communicate better with stakeholders.
See salaries and explore the career path for Operations Analyst
Project Manager
Project managers plan, execute, and oversee projects. They need to track progress, manage resources, and communicate updates using various tools for project tracking and reporting. While this course may not seem directly relevant to project management, it may be helpful because it provides a tool for data visualization. Understanding how to analyze and visualize project data using Power BI can aid in project monitoring and reporting, which are important aspects of a project manager’s role. Additionally the confidence gained from the course can be useful.
See salaries and explore the career path for Project Manager
Sales Analyst
Sales analysts examine sales data to identify trends, patterns, and opportunities for improvement. They track sales performance, analyze customer behavior, and provide insights to sales teams. While this course may not directly address sales strategies, it can be a helpful tool for visualizing sales data. The skills in Power BI gained in this course can be applied to analyze and visualize sales performance, helping in the presentation of trends and patterns in sales data. The course is useful for those who need to analyze sales data.
See salaries and explore the career path for Sales Analyst
Marketing Analyst
Marketing analysts evaluate and improve the effectiveness of marketing campaigns through data analysis. They track key performance indicators, analyze customer behavior, and provide insights to marketing teams. While this course may not directly teach marketing principles, it can be helpful for visualizing marketing data. The Power BI skills learned in this course can be applied to analyze and visualize campaign performance. This allows a marketing analyst to better understand the impact of their efforts.
See salaries and explore the career path for Marketing Analyst
Human Resources Analyst
Human Resources Analysts use data to monitor employee trends, analyze workforce demographics, and support HR strategies. This role requires strong analytical skills and an ability to translate data into useful information. Although this course does not focus on HR principles, it can be useful as it teaches how to create visualizations using Power BI. These skills are helpful to present HR data to stakeholders. The course helps build a toolkit for communicating employee information effectively.
See salaries and explore the career path for Human Resources Analyst
Risk Analyst
A risk analyst identifies and assesses potential risks and develops strategies to mitigate them. This role involves a good grasp of data analysis to evaluate risk. While this course won't teach risk assessment, it may be helpful to a risk analyst as Power BI provides a way to visualize data. This course can help a risk analyst communicate findings more clearly to stakeholders. The ability to present data effectively is an important asset in analyzing risk, and thus this course can be helpful here.
See salaries and explore the career path for Risk Analyst
Supply Chain Analyst
A supply chain analyst is responsible for examining and optimizing a company's supply chain operations. They do this by collecting data related to logistics, production, and procurement. They provide insight on inefficiencies and suggest areas for improvement. While this course doesn't delve into supply chain principles, it may be useful for visualizing data. By providing a foundation in Power BI, this course allows a supply chain analyst to better analyze and present data to stakeholders.
See salaries and explore the career path for Supply Chain Analyst

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Microsoft Certified: Data Analyst Associate with Power BI.
Cover image
The Definitive Guide to DAX
Save
Comprehensive guide to DAX, the formula language used in Power BI. It provides in-depth explanations of DAX concepts and functions, along with practical examples. It valuable resource for anyone who wants to master DAX and build complex measures in Power BI. This book is commonly used by Power BI professionals.
The Definitive Guide to DAX: Business Intelligence...
Paperback
$$$
The Definitive Guide to Dax (Business Skills)
Paperback
$$$
Definitive Guide to DAX, The: Business intelligence...
Kindle Edition
$$
Cover image
Storytelling with You
Save
Focuses on the art of communicating insights through data visualization. It teaches you how to choose the right visuals, eliminate clutter, and focus your audience's attention on the key takeaways. While not Power BI specific, the principles are directly applicable to creating effective Power BI reports. This book is valuable as additional reading to improve the impact of your Power BI deliverables.
Storytelling with You: Plan, Create, and Deliver a...
Paperback
$$
Storytelling with You: Plan, Create, and Deliver a...
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Similar courses are unavailable at this time. Please try again later.
Effort
7.5 total hours
Via
Udemy
Instructors
John David Ariansen
SuperDataScience Team
Ligency Team
Language
English
Good to know
Modeled directly from the DA-100 exam structure, which ensures comprehensive coverage of the material needed to pass the Microsoft Power BI certification exam
Covers preparing, modeling, visualizing, and analyzing data, which are essential skills for data analysts working with Power BI in a professional setting
Includes instruction on DAX and advanced data visualization techniques, which are critical for creating insightful and impactful reports and dashboards in Power BI
Requires learners to sign up for a Microsoft Trial Account, which may pose a barrier to some learners who do not have access to this service or are restricted from using it
Teaches learners how to deploy and maintain deliverables in Power BI, which is a crucial aspect of data analysis that ensures insights are accessible and up-to-date
Includes case studies to reinforce learning, which allows learners to apply their knowledge and skills to real-world scenarios and deepen their understanding of Power BI
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser