DA-100: Analyzing Data with Microsoft Power BI

Back to Dashboard

Hey there, great course, right? Do you like this course?

All of the most interesting lessons further. In order to continue you just need to purchase it

Get course

₹29,900

Course sections

Section 1

Module 1: Prepare the Data

Section 2

Get Data from different Data Sources

Identify and Connect to a Data Source

Change Data Source Settings

Select a Shared Dataset or Create a Local Dataset

Select a Storage Mode

Choose an Appropriate Query Type

Identify Query Performance Issues

Use the Common Data Service (CDS)

Section 3

Profile the Data

Identify Data Anomalies

Examine Data Structures

Interrogate Column Properties

Interrogate Data Statistics

Section 4

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

Apply User-friendly Naming Conventions to Columns and Queries

Leverage Advanced Editor to Modify Power Query M code

Configure Data Loading

Section 5

Module 2: Model the Data

Section 6

Design a Data Model

Define the Tables

Configure Table and Column Properties

Define Quick Measures

Flatten out a Parent-child Hierarchy

Define Role-playing Dimensions

Define a Relationship’s Cardinality and Cross-filter Direction

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

Section 7

Develop a Data Model

Apply Cross-Filter Direction and Security Filtering

Create Calculated Tables

Create Hierarchies

Create Calculated Columns

Implement Row-level Security Roles

Set up the Q&A Feature

Section 8

Create Measures by using DAX

Use DAX to Build Complex Measures

Use CALCULATE to Manipulate Filters

Implement Time Intelligence using DAX

Replace Nmeric Columns with Measures

Use Basic Statistical Functions to Enhance Data

Create Semi-Additive Measures

Section 9

Optimize Model Performance

Remove Unnecessary Rows and Columns

Identify Poorly Performing Measures, Relationships, and Visuals

Improve Cardinality Levels by Changing Data Types

Improve Cardinality Levels Through Summarization

Create and Manage Aggregations

Section 10

Module 3: Visualize the Data

Section 11

Create Reports

Add Visualization Items to Reports

Choose an Appropriate Visualization Type

Format and Configure Visualizations

Import a Custom Visual

Configure Conditional Formatting

Apply Slicing and Filtering

Add an R or Python Visual

Configure the Report Page

Design and Configure for Accessibility

Section 12

Create Dashboards

Set Mobile View

Manage tiles on a Dashboard

Configure Data Alerts

Use the Q&A Feature

Add a Dashboard Theme

Pin a Live Report Page to a Dashboard

Configure Data Classification

Section 13

Enrich Reports for Usability

Configure Bookmarks

Create Custom Tooltips

Edit and Configure Interactions Between Visuals

Configure Navigation for a Report

Configure Sync Slicers

Use the Selection Pane

Use Drillthrough and Cross Filter

Drilldown into Data using Interactive Visuals

Export Report Data

Section 14

Module 4: Analyze the Data

Section 15

Enhance Reports to Expose Insights

Apply Conditional Formatting

Apply Slicers and Filters

Perform top N Analysis

Explore Statistical Summary

Use the Q&A Visual

Add a Quick Insights Result to a Report

Create Reference Lines by using Analytics Pane

Use the Play Axis Feature of a Visualization

Section 16

Perform Advanced Analysis

Identify Outliers

Conduct Time Series Analysis

Use Goupings and Binnings

Use the Key Influencers to Explore Dimensional Variances

Use the Decomposition Tree Visual to Break Down a Measure

Apply AI Insights

Section 17

Module 5: Deploy and Maintain Deliverables

Section 18

Manage Datasets

Configure a Dataset Scheduled Refresh

Configure Row-level Security Group Membership

Providing Access to Datasets

Configure Incremental Refresh Settings

Endorse a Dataset

Section 19

Create and Manage Workspaces

Create and Configure a Workspace

Recommend a Development Lifecycle Strategy

Assign Workspace Roles

Configure and Update a Workspace App

Publish, Import, or Update Assets in a Workspace

Module 1: Prepare the Data

Those Other College Expenses You Aren’t Thinking About

Lesson is locked. Please Buy course to proceed.