Course Overview

This BootCamp course from CloudThat will help candidates prepare for the DA-100 Microsoft Azure certification exam. The curriculum of this courses will show how data analysts can leverage the Power of Microsoft BI in analyzing data and extracting value out of it.

Note: This exam is retired. A replacement exam, Exam PL-300: Microsoft Power BI Data Analyst is available from February 28, 2022.

After completing this course, students will be able to:

  • Ingest, clean, and transform data
  • Model data for performance and scalability
  • Design and create reports for data analysis
  • Apply and perform advanced report analytics
  • Manage and share report assets
  • Create paginated reports in Power BI

Upcoming Batches

India Online Enroll
Start Date End Date

To be Decided

Key Features

  • Our training modules have 50% -60% hands-on lab sessions to encourage Thinking-Based Learning (TBL)
  • Interactive-rich virtual and face-to-face classroom teaching to inculcate Problem-Based Learning (PBL)
  • Microsoft certified instructor-led training and mentoring sessions to develop Competency-Based Learning (CBL)
  • Well-structured use-cases to simulate challenges encountered in a Real-World environment
  • Integrated teaching assistance and support through experts designed Learning Management System (LMS) and ExamReady platform
  • Being a Microsoft Learning Partner provides us with the edge over competition

Who Should Attend

  • Data Analyst

Prerequisites

  • Basic knowledge of Cloud platform: Azure
  • IT industry work experience or those pursuing a degree in the IT field
  • Strong learning acumen

Course Outline Download Course Outline

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
  • Indentify Query Performance Issues
  • Use the Common Data Service (CDS)
  • Use Parameters

Profile the Data

  • Indentify Data Anomalies
  • Examine Data Structures
  • Interrogate Column Properties
  • Interrogate Data Statistics

Clean, Transform, and Load the Data

  • Resolve Inconsistencies, Unexpected or Null Values, and Data Quality Issues
  • Apply User-friendly Value Replacements
  • Indentify 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
  • Resolve Data Import Errors

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

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

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

Optimize Model Performance

  • Remove Unnecessary Rows and Columns
  • Indentify Poorly Performing Measures, Relationships, and Visuals
  • Improve Cardinality Levels by Changing Data Types
  • Improve Cardinality Levels Through Summarization
  • Create and Manage Aggregations

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

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

Enrich Reports for Usability

  • Configure Bookmarks
  • Create Custom Tooltips
  • Edit and Configure Interactions Between Visuals
  • Configure Navigation for a Report
  • Apply Sorting
  • Configure Sync Slicers
  • Use the Selection Pane
  • Use Drillthrough and Cross Filter
  • Drilldown into Data using Interactive Visuals
  • Export Report Data

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

Perform Advanced Analysis

  • Indentify 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

Manage Datasets

  • Configure a Dataset Scheduled Refresh
  • Configure Row-level Security Group Membership
  • Providing Access to Datasets
  • Configure Incremental Refresh Settings
  • Endorse a Dataset

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

Certification

    • By earning DA-100 certification, you will prove competency of Data Analysts working with Microsoft Power BI
    • Imbibe skills to Ingest, clean, and transform data as a data analyst
    • Demonstrate abilities of report generation, analysis, data modelling for performance monitoring
    • On successful completion of DA-100: Analyzing Data with Microsoft Power BI training aspirants receive a Course Completion Certificate from us
    • By successfully clearing the DA-100: Analyzing Data with Microsoft Power BI exams, aspirants earn Microsoft Certification

Course Fee

Select Course date

Add to Wishlist

Course ID: 1408

Course Price at

₹ 29900 + 18% GST

Enroll Now

Reviews

S

Sundeep kandapaneni

Cloudthat is helpful to gain knowledge on cloud technologies and their free trainings will help to step up the career/change the domain. Be future ready and stay ahead.

P

Pravesh

Had a wonderful experience about Power BI introduction. Interested to have a successful future sessions :).

SN

Subanulla Bn

Good Thing in CloudThat free Sessions and Webinars and will come to know New Technologies.