Microsoft Certified: Data Analyst Associate: DA-100: Analyzing Data with Microsoft Power BI

  • 18 Courses | 25h 29m 51s
  • 2 Books | 15h 38m
 
Explore how to design and build scalable data models, clean and transform data, and enable advanced analytic capabilities through data visualizations as you prepare for the DA-100: Analyzing Data with Microsoft Power BI certification exam.

GETTING STARTED

Data Preparation and Processing: Using Power BI for Data Analysis

  • Playable
    1. 
    Course Overview
    3m 7s
    NOW PLAYING
  • Playable
    2. 
    The DA-100 Power BI Certification
    5m 8s
    UP NEXT

COURSES INCLUDED

Data Preparation and Processing: Using Power BI for Data Analysis
Most businesses have an enormous amount of data in their possession. But this data is only as valuable as the quality of the processes used to understand it. So how do you gather seemingly disparate data from multiple sources and turn it into digestible insights for all to use? One way to do this is to use Power BI, Microsoft's business analytics service. Use this course to comprehend exactly what's involved in data analysis, including specific tasks and job roles. Examine how Power BI's suite of features can facilitate these tasks efficiently and effectively. Furthermore, see the steps involved in taking the DA-100 certification exam, which tests the learner's ability to analyze data using Power BI. Upon completion, you'll have a theoretical understanding of how Power BI is used to carry out data analysis.
9 videos | 1h 9m has Assessment available Badge
Data Preparation and Processing: Loading & Transforming Data in Power BI
Using Power BI for data analysis means you can pull data from multiple places into one location and turn that combined data into meaningful insights. Use this course to learn how to connect different data sources to Power BI and the types of transformations that can be applied to this data. Install Power BI desktop. Load data from CSV, XML, and JSON files as well as from SQL Server. Use Power Query within Power BI to apply transformations. Then, explore transformations crucial to building meaningful, responsive, and informative visualizations, such as trimming out unnecessary data and merging columns containing related information. Upon completion, you'll be able to load data into Power BI and transform it for analysis.
10 videos | 1h 20m has Assessment available Badge
Data Preparation and Processing: Preparing Data for Visualizations in Power BI
A vital step between gathering data and creating a report or visualization from it is transforming it into a cohesive form. Use this course to gain hands-on experience in transforming raw data for visualizations. Practice combining related data into a single table. While doing so, perform a preliminary analysis of the data so you can imagine what visualizations can be created from it. Next, combine data from several files into a single table and conduct several transformations, from aggregating data to filtering out unnecessary rows. Finally, build a simple column chart visual from the contents of a Power BI table. While doing so, identify the different storage modes in Power BI and how they affect your visuals. Upon completion, you'll be able to prepare data for visualization using a variety of transformations.
12 videos | 1h 51m has Assessment available Badge
Power BI Data Model Design: An Overview of Data Modeling
Data as a form of currency is an analogy that's been around since the early 2000s. However, data itself is worthless. The real value is in the insights you gain from it; this is where data analysis comes in. Data modeling is a crucial part of data analysis, helping turn raw data into accurate insights and meaningful reports. Use this course to learn how to design and optimize data models through Power BI Desktop. Examine the star and snowflake schemas. Learn about the DAX formula language. Then, conduct a range of tasks, including combining tables, defining calculated columns, creating measures, and counting values. Upon course completion, you'll know how to use data modeling to transform raw data into powerful visuals and reports. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
12 videos | 1h 49m has Assessment available Badge
Power BI Data Model Design: Applying the DAX Formula Language
Power BI does the heavy lifting when it comes to analyzing data. One way it does this is through the DAX formula language. By learning how to use this language, you can vastly improve the insights you get from data. Use this course to learn how to conduct several data analysis operations using the DAX formula language. Begin by performing aggregation operations, such as sum and average. Learn how to generate and work with blank data in DAX. Explore a variety of counting functions, ranging from simple counts of values to conditional counts based on filters. Lastly, practice using the IF and SWITCH functions. Upon course completion, you'll know how to use DAX to calculate values and reference table data in Power BI. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
10 videos | 1h 16m has Assessment available Badge
Power BI Data Model Design: Working with Filters
The more you master DAX in Power BI, the better the insights and reports you'll get from data. The filter context is a need-to-know DAX concept. Use this course to get hands-on experience working with this aspect of Power BI. Start by exploring the relationships between tables in Power BI. Move on to using the CALCULATE function. Then, see how a filter context can be defined so that it only points to a subset of the overall data and how you can continue to perform operations within this filter context. Moving on, examine a breadth of options for ignoring the filter context for specific use cases, including how to bypass filters using various DAX functions. When you're done, you'll be able to use DAX functions to perform operations on a subset of data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
10 videos | 1h 22m has Assessment available Badge
Power BI Data Model Design: Using Time Intelligence
A big part of data analysis is evaluating how data behaves over time. Power BI's DAX language includes time intelligence functions that enable you to aggregate, compare, and manipulate data using time periods. Use this course to learn how to model data using time-based analysis. Begin by creating a date table. Then use DAX time intelligence functions to extract values from a date. Also, learn how to define dates as a hierarchy, which can then be applied in visualizations. Moving along, practice operating on a range of dates that are shifted from the range in the current context by a specified interval. Finally, perform year-to-date and month-to-date computations from the date in the current context. When you're done, you'll be able to apply a variety of time functions to your data. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
7 videos | 54m has Assessment available Badge
Power BI Data Model Design: Advanced Modeling Technique
A well-designed data model eliminates irrelevant and uninterpretable analyses and ensures insightful and well-performing reports. Use this course to step up your data analysis using Power BI's advanced data modeling features. Begin by loading a sales dataset containing a large fact table and multiple dimension tables and modeling it into a snowflake schema. See how Power BI automatically detects relationships. Then, learn how to apply detailed configurations of relationships, from setting the right cardinality to applying bi-directional cross-filtering. Next, explicitly define a hierarchy in your data to model a set of geographical values. Learn further detailed configurations, such as setting a default aggregation operation on fields and hiding specific ones from the reports view. Lastly, learn how to implement row-level security. When you're done, you'll be able to use Power BI's advanced data modeling capabilities. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.
15 videos | 1h 56m has Assessment available Badge
Understanding Data Visualization
Microsoft Power BI is a powerful and versatile visualization technology widely used in data analytics, especially business data analysis. Business analysts can use this service to build and publish interactive reports for executive audiences as well as collaborators. Get your head around the specifics of data visualization in this introductory course. Explore different types of visualizations and their use-cases, covering standard charts and those for more specific cases. Learn about the structure of Power BI and how it helps with data visualization. Then, examine report creation in Power BI. When you've finished, you'll understand the theory behind data visualization in Power BI and be ready to move on to creating and formatting charts in Power BI. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
8 videos | 58m has Assessment available Badge
Creating & Formatting Charts In Power BI
Workhorse visualizations, such as line charts, column charts, and bar charts, are beneficial in all visualization use cases. Microsoft Power BI does a great job of making these common charts easy to put together and thoroughly customizable. Take this hands-on course to learn how to create and customize various chart types using Power BI. Learn how to create and customize column charts and bar charts from imported data. Explore how to import time-related data using Power Query and transform it into line charts. Then, experiment with multiple formatting operations on the line chart. Upon course completion, you'll be able to build line, bar, and column charts that are engaging and meaningful and be ready to learn how to create more advanced charts, including ribbon and pie charts. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
13 videos | 1h 31m has Assessment available Badge
Leveraging Power BI with Ribbon, Line, Column, & Pie Charts
In addition to the ubiquitous line, bar, and column charts, Microsoft Power BI supports other compelling visualizations. These include ribbon charts, a clever way to plot the evolution of both ranks and absolute quantities over time, and funnel charts, useful for representing a linear sequence of events. Advance your Power BI chart-building skills with this hands-on course. Learn how to visualize various kinds of data in the most beneficial way using line and stacked column charts (a combination of line charts and stacked column charts) as well as ribbon, pie, donut, and funnel charts. When you've finished this course, you'll be able to build both standard and specialized charts in Power BI. You'll then be ready to work with maps, waterfall charts, and scatter plots. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
12 videos | 1h 22m has Assessment available Badge
Maps, Waterfall Charts, & Scatter Plots in Power BI
Microsoft Power BI is used in some of the world's largest enterprises. Its powerful map visualizations are great for representing global business data. Its waterfall charts benefit financial planners and analysts, while its scatter plots are ideal for data scientists. Through this practical course, learn how to use Power BI to visualize global business data. Work with Power BI maps, applying various customization techniques. Create waterfall charts for drilling through hierarchical data and representing cumulative processes. Then, create scatter charts to show the relationship between two variables and clusters within data. Lastly, use bubble charts to convey information via the size and color of each point in the chart. When you're done, you'll be able to use multiple advanced charts in Power BI and be ready to work with matrix and treemap controls. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
10 videos | 1h 7m has Assessment available Badge
Matrix & Treemap Controls in Power BI
As datasets grow larger and more complex, there is an ever-increasing need to organize data into categories and hierarchies. This is what the matrix and treemap controls in Power BI are designed to do. In this course, learn how to utilize matrices and treemaps to their full potential. Create a matrix widget and add aggregations. Create row and column hierarchies from hierarchical fields. Drill through hierarchical treemaps. And format matrices using color scales, data bars, and icons. Additionally, visualize the composition of a whole using treemaps. Learn how to create and filter data through slicers. And sync slicers across different pages and widgets in a report. Upon course completion, you'll have an advanced ability to use Power BI visualizations, ready to move on to using the Power BI service. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
15 videos | 1h 42m has Assessment available Badge
Using the Power BI Service
Microsoft was a pioneer in desktop applications. But when it adapted to the cloud, it had spectacular success. Similarly, Microsoft's Power BI service has a powerful desktop app in addition to a multifunctional web service. Learn to use the Power BI web service in this hands-on course. Start with publishing reports for other people to view. Then pin visualizations and reports to a dashboard, even live-pinning an entire report to the dashboard. Finally, learn how to use various dashboard features, including the Q&A, which uses natural language processing to answer queries about your data. When you're done, you'll be able to leverage the Power BI Software as a Service and be ready to move on to analyzing and sharing data through Power BI. This is one of a series of four paths that can be used to prepare for the DA-100: Analyzing Data with Microsoft Power BI exam.
7 videos | 39m has Assessment available Badge
Analysis & Sharing Features in Power BI
Analyzing data can throw light on game-changing insights. To action these insights, it's imperative the appropriate data is shared with the right people. Learn how to analyze and share data using Power BI in this DA-100 preparatory course. Explore considerations when building Power BI reports and collaborating with others. Learn how to streamline report deployment and sharing using Power BI pipelines, which help manage large and complex report deployments. And examine critical practices for securing reports by limiting the data accessible to viewers. Moving on, examine essentials to keep in mind when preparing for the DA-100 certification. Finally, get hands-on with Power BI Desktop, performing some preliminary analysis to identify outliers in your data. Upon completion, you'll know how to analyze data and share reports competently. You'll also be more prepared for the DA-100 certification exam.
10 videos | 1h 31m has Assessment available Badge
Extracting Insights from Data Using Power BI
Getting insights from data isn't always straightforward. However, using a tool like Power BI helps with heavy lifting. Through this hands-on course, learn to obtain insights from data using a combination of Power BI's visualization and analysis features. Explore how and why numeric data is summarized. Discover how the sum, mean, and median statistics, among others, give different views of the same data. Practice modeling data into customized groups to better represent it to end users. Use scatter charts to identify clusters and enable analysis of snapshots of data with a play axis. Finally, use the key influencers visual to identify how certain metrics are influenced by values in other fields. Upon completion, you'll know how to take advantage of the analytics features of Power BI visuals. You'll also be more prepared for the DA-100 certification exam.
14 videos | 1h 54m available Badge
Applying Power BI's Advanced Analysis Features
It can be overwhelming to think about analyzing data to meet all pre-defined requirements. Luckily, advancements in technology can help with this analysis. Learn to use the Power BI features made possible by AI and other advanced techniques in this demo-based course. Use Power BI's Analyze feature to understand values and metrics in sales data. Apply the forecasting feature to a line chart to estimate future sales. Then find outliers in terms of daily sales using the anomaly detection feature. Next, use the Q&A visual to allow users to extract insights from data using plain English. Finally, create a decomposition tree to break down the sales data across different categories. Upon completion, you'll know how to use advanced analysis features in Power BI to extract pertinent insights from your data. You'll also be more prepared for the DA-100 certification exam.
9 videos | 1h 18m has Assessment available Badge
Sharing Power BI Reports & Workspaces
Analyzing data and building reports is only useful if the right people can access and understand those reports. Take this course to learn how to involve others in your Power BI reports, be it collaborators in report development or consumers of your analysis. Begin by building a report configured with row-level security. Then, test it in Power BI Desktop before publishing it to the Power BI service. Via the Power BI service, share your workspace with teammates and other collaborators using different roles and permissions. Then use the Pipeline feature to streamline report deployment. Finally, learn to enhance report performance and collaboration by adding endorsements and using the native performance analyzer. Upon completion, you'll know how to use advanced analysis features in Power BI to extract pertinent insights from your data. You'll also be more prepared for the DA-100 certification exam.
12 videos | 1h 43m has Assessment available Badge
SHOW MORE
FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

BOOKS INCLUDED

Book

Data Analysis with Microsoft Power BI
Including hands-on exercises based on real-life business scenarios, this book teaches you the skills you need to interact with, author, and maintain robust visualizations and custom data models.
Book Duration 6h 12m Book Authors By Brian Larson

Book

Pro Power BI Desktop: Self-Service Analytics and Data Visualization for the Power User, Third Edition
Deliver eye-catching and insightful business intelligence with Microsoft Power BI Desktop. This new edition has been updated to cover all the latest features of Microsoft's continually evolving visualization product.
Book Duration 9h 26m Book Authors By Adam Aspin

YOU MIGHT ALSO LIKE

CHANNEL Data Engineer
Likes 179 Likes 179  
Likes 25 Likes 25