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


  • 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


    • 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

Our Top Trainers

Pavan Bhawsar

Pavan is a Microsoft Certified Trainer at CloudThat. He is an enthusiastic and passionate trainer, empathic observer towards the trending technologies with demonstrated skill in Azure and hybrid Cloud Administration. He has 6+ years of corporate experience, etc.

Yanish Sahu

Yanish works as a Corporate Trainer with CloudThat Technologies. He is very passionate about learning new technologies. He is part of CloudThat’ s Microsoft team which helps to deploy Microsoft 365 setup. He is skilled on topics etc.

Sohini Rakshit

Sohini serves as a trainer for Azure cloud at CloudThat Technologies. She is an experienced Cloud Consultant and Architect, Corporate trainer working on Microsoft Azure around multi-tier distributed application design planning and deployment for several Cloud Solutions. She holds a etc.

Lakhan Kriplani

He had involved in various client projects to set up infrastructure on Cloud for various Analytics applications, E-Commerce, setup CICD Pipeline using AWS services. He has experience in developing highly secure, scalable web applications using MVC architecture. etc.

Jagadesh Gonnagar

He has been a part of several large and complex software development projects with global clients. He has worked in USA for over 11 years before relocating to India. He has expertise in Database design/development, Web development, etc.

Devi Vara Prasad

A Microsoft Certified Trainer with more than 15+ years of Corporate, Online and Classroom Training Experience, well versed in AWS an Azure Cloud platforms and have been delivering trainings for more than 5years. Also has a vast etc.

Anjali Srivastava

Anjali serves as a Research Associate for IoT (including AI/ML) and Azure cloud at CloudThat technologies. She is an experienced Solutions Engineer & Developer, corporate trainer working on Microsoft Azure around multi-tier distributed application design planning and deployment for several etc.

Ajay Kumar Lodha

Ajay is cloud obsessed and cloud addict, that's how he describes himself. Ajay has been working with all the major cloud computing platforms like AWS, Azure, and GCP for more than 5 years now. He is into etc.

Prarthit Mehta

Prarthit has been involved in various large and complex projects with global clients. He has experience in Microsoft, MS office 365 & AWS Infrastructure technologies and Windows servers, designing Active Directory and managing various domain services. He etc.

Priyant Gupta

Priyant is working in the Microsoft Technology space for last 5 years and is sharing the knowledge gained on Azure Administration, Azure Data Engineering and Dynamics 365 CE Apps. He has trained 1000+ professionals as a corporate trainer at etc.

Course Fee

Select Course date

Add to Wishlist

Course Price at

₹ 29900 + 18% GST

Enroll Now