• Blog
  • Reviews
  • Contact Us
  • Locations
1-844-BOOTCAMP
or 1-941-218-0007
Certification Camps
  • BOOTCAMPS
    • Microsoft 365 Enterprise
      • MCE Microsoft 365 Enterprise Administrator
      • MCE Microsoft 365 Teams Voice Engineer
      • MCA Microsoft 365 Messaging Administrator
      • MCA Microsoft 365 Security Administrator
      • MCA Microsoft 365 Teams Administrator
      • MCA Microsoft 365 Modern Desktop
    • Microsoft Azure Admin
      • MCE Azure Solutions Architect
      • MCE Azure DevOps Engineer
      • MCA Azure Administrator
      • MCA Azure Security Engineer
      • MCA Windows Server Hybrid Administrator
      • MCS Azure Virtual Desktop
    • Microsoft Azure Data
      • MCA Azure Database Administrator
      • MCA Azure Data Engineer
      • MCA Azure Data Analyst Power BI
    • Microsoft Power Platform
      • MCE Microsoft Power Platform Combo
      • MCE Power Platform Solution Architect
      • MCA Power Platform Functional Consultant
      • MCA Power Platform Developer
    • Microsoft Developer
      • MCE Azure DevOps Engineer
      • MCA Azure Developer
      • MCA Power Platform Developer
      • MCA Microsoft 365 Developer
    • Microsoft Security
      • MCE Cyber Security Architect Expert
      • MCA Identity & Access Admin
      • MCA Information Protection Admin
      • MCA Security Operations Analyst
    • Combo Classes
      • Azure Admin & Azure Architect
      • Azure Developer & Azure DevOps
      • Microsoft 365 Desktop & Enterprise Admin
      • Microsoft 365 Security & Enterprise Admin
      • Power Platform Consultant & Architect
    • Amazon Web Services
      • Architecting on AWS Accelerator
      • AWS Cloud Prac Solutions & Architect Associate
      • AWS Certified Developer Associate
      • AWS Certified DevOps Engineer Professional
    • CompTia
      • CompTia A+ Essentials
      • CompTIA Cloud+ 5 Days (1 Course, 1 Exam, 1 Cert)
      • CompTIA CySA+ (Cyber Security Analyst+)
      • CompTia Network+
      • CompTia Security+
    • Information Security
      • EC-Council Certified Ethical Hacker (CEH)
      • (ISC)² CISSP
    • Cisco
      • Cisco CCNP Routing and Switching
      • Cisco CCNA
  • Find Training
    • Training By Job Role
      • Developer
      • Administrator
      • Architect
      • Data Engineer
      • DevOps
      • Security
    • Vendors
      • Microsoft
      • Amazon
      • Cisco
      • CompTIA
      • Ec-Council
    • Microsoft Technical
      • Azure
      • Microsoft 365
      • Power Platform
      • Security
      • Messaging
      • Modern Desktop
      • Windows Server
      • SQL Server
    • Click here to find your course
  • SCHEDULE
  • Role Based Certifications
  • Pay an Invoice
Home > Certifications
MICROSOFT AZURE DATA CERTIFICATION

MCA Microsoft Azure Data Analyst (Power BI) Associate

$3,995 CLASSROOM LIVE
Price includes: Instructor Led Class, Official Courseware, Labs and Exams

Training Schedule and Pricing

Our training model blends knowledge and certification prep into one solution. Interact face-to-face with vendor certified trainers AT OUR TRAINING CENTER IN SARASOTA, FL - OR - attend the same instructor-led live camp ONLINE.

Select Delivery Format:
Classroom Live
Remote Classroom Live
Check Box To Include:
  • Apr
    03
    2023
    Delivery Format:
    CLASSROOM LIVE
    Date:
    04.03.2023 - 04.07.2023
    Location:
    SARASOTA
    Price Includes:
    Instructor Led Class, Official Courseware, Labs and Exams
    $3,995
    5 days
    Enroll Generate a Quote Ask a Question
  • Apr
    24
    2023
    Delivery Format:
    CLASSROOM LIVE
    Date:
    04.24.2023 - 04.28.2023
    Location:
    SARASOTA
    Price Includes:
    Instructor Led Class, Official Courseware, Labs and Exams
    $3,995
    5 days
    Enroll Generate a Quote Ask a Question
  • May
    08
    2023
    Delivery Format:
    CLASSROOM LIVE
    Date:
    05.08.2023 - 05.12.2023
    Location:
    SARASOTA
    Price Includes:
    Instructor Led Class, Official Courseware, Labs and Exams
    $3,995
    5 days
    Enroll Generate a Quote Ask a Question
  • View Entire Schedule
  • May
    22
    2023
    Delivery Format:
    CLASSROOM LIVE
    Date:
    05.22.2023 - 05.26.2023
    Location:
    SARASOTA
    Price Includes:
    Instructor Led Class, Official Courseware, Labs and Exams
    $3,995
    5 days
    Enroll Generate a Quote Ask a Question
  • Jun
    12
    2023
    Delivery Format:
    CLASSROOM LIVE
    Date:
    06.12.2023 - 06.16.2023
    Location:
    SARASOTA
    Price Includes:
    Instructor Led Class, Official Courseware, Labs and Exams
    $3,995
    5 days
    Enroll Generate a Quote Ask a Question
  • Jun
    26
    2023
    Delivery Format:
    CLASSROOM LIVE
    Date:
    06.26.2023 - 06.30.2023
    Location:
    SARASOTA
    Price Includes:
    Instructor Led Class, Official Courseware, Labs and Exams
    $3,995
    5 days
    Enroll Generate a Quote Ask a Question
  • Jul
    24
    2023
    Delivery Format:
    CLASSROOM LIVE
    Date:
    07.24.2023 - 07.28.2023
    Location:
    SARASOTA
    Price Includes:
    Instructor Led Class, Official Courseware, Labs and Exams
    $3,995
    5 days
    Enroll Generate a Quote Ask a Question
azure training

Bootcamps:

  • MCA Microsoft Power BI Data Analyst Associate Training & Certification Boot Camp - 5 Days (2 Courses, 2 Exams, 2 Certs)

Course Delivery

This course is available in the following formats:

Classroom Live
Duration:
5 days
Remote Classroom Live
Duration:
5 days
Request More Information

Exams Included & Administered During Camp:

PL-900: Microsoft Power Platform Fundamentals

PL-300: MIcrosoft Power BI Data Analyst

What's Included

  • 4 Microsoft Test Vouchers2 Microsoft Test Vouchers
  • Microsoft Training Books2 Microsoft Official Courses
  • 2 Retake Vouchers (If needed)1 Retake Voucher (per exam, if needed)
  • Microsoft Study Labs & SimulationsMicrosoft Study Labs & Simulations
  • Onsite Prometric Testing CenterOnsite Pearson Vue Test Center
  • Instructor Led Classroom TrainingInstructor Led Classroom Training
  • Course Description
  • Microsoft Gold Learning Partner
  • Facilities

The NEW Microsoft Data Analyst Training & Certification 5 Day Boot Camp prepares students responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations. Students will also use Microsoft Power Platform to Create a simple PowerApp, connect data with CDS, build a Power BI Dashboard, and automate a process with Microsoft Flow.

The Microsoft Data Analyst Boot Camp Is Taught Using Microsoft Official Courseware

PL-900T00: Microsoft Power Platform Fundamentals
PL-300T00: Microsoft Power BI Data Analyst

While attending this 5 day instructor led live camp - students will take two exams (PL-900 / PL-300) to achieve two Microsoft Certifications - MCA Microsoft Certified Data Analyst & Microsoft Certified Power Platform.  This hands on, instructor led live camp focuses on real world responsibilities of a Data Analyst covering the information needed for the certification exams which are administered while attending.

The focus and objectives of this camp include

Describe Microsoft Power Platform components
Describe Microsoft Dataverse, Connectors and AI builder
Describe cross-cloud scenarios across M365, Dynamics 365, Microsoft Azure and 3rd party services
Identify benefits and capabilities of Microsoft Power Platform
Identify the basic functionality and business value Microsoft Power Platform components
Implement simple solutions with Power Apps, Power Automate, Power BI, and Power Virtual Agents

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

Topics Covered in this Official Boot Camp

Introduction to Microsoft Power PlatformIntroduction to Microsoft DataverseGet Started with Power AppsGet Started with Power AutomateGet Started with Power BIIntroduction to Power Virtual AgentsGet Started with Microsoft Data AnalyticsPrepare Data in Power BIClean, Transform, and Load Data in Power BIDesign a Data Model in Power BICreate Model Calculations using DAX in Power BIOptimize Model Performance in Power BICreate Reports in Power BICreate Dashboards in Power BIIdentify Patterns and Trends in Power BICreate and Manage Workspaces in Power BIManage Files and Datasets in Power BI
Introduction to Microsoft Power Platform

Introduction to Microsoft Power Platform

Learn about the components of Microsoft Power Platform, ways to connect data, and how organizations can leverage this technology to create business solutions.

Lesson

  • Microsoft Power Platform Overview
  • Module Summary

After completing this module, students will be able to:

  • Identify when to use each Microsoft Power Platform component application to create business solution
  • Learn the value of using Microsoft Power Platform to create business solutions
  • Learn the components and features of Microsoft Power Platform
Introduction to Microsoft Dataverse

Introduction to Microsoft Dataverse

Dataverse allows you to delve into powerful, scalable data solutions in the cloud. Learn what makes Dataverse tick and how it can work with Microsoft Power Platform to create unique and efficient business solutions.

Lesson

  • Microsoft Dataverse Overview
  • Module Summary

Lab : Data Modeling

  • Create Solution
  • Add Existing and Create New Tables
  • Create Relationships
  • Import Data

After completing this module, students will be able to:

  • Descibe the difference between Dataverse and Common Data Model
  • Explain use cases and limitations of business rules and process flows
  • Explain what environments, tables, columns, and relationships are in Dataverse
Get Started with Power Apps

Get Started with Power Apps

Learn about the value and capabilities of Power Apps, and ways other organizations have leverage this technology to build simple applications for their business.

Lesson

  • Introduction to Power Apps
  • How to build a canvas app
  • How to build a model-driven app
  • Introduction to Power Apps portals

Lab : How to build a canvas app, part 1

  • Create Staff Canvas App
  • Complete the App

Lab : How to build a canvas app, part 2

  • Create Security Canvas App

Lab : How to build a model-driven app

  • Customize Views and Forms
  • Create Model-Driven Application

Lab : How to build a Power Apps portal

  • Provision a Power Apps portal
  • Create a Portal Webpage
  • Change the Portal Theme

After completing this module, students will be able to:

  • Learn how other organizations digitize their processes using Power Apps
  • See Power Apps in action and learn options for making your first app
  • Learn about what Power Apps is and its business value
Get Started with Power Automate

Get Started with Power Automate

Learn how users can leverage Power Automate to improve business efficiency and productivity.

Lesson

  • Power Automate Overview
  • How to Build an Automated Solution

Lab : Power Automate

  • Create Visit Notification flow
  • Create Security Sweep Flow

After completing this module, students will be able to:

  • See how Power Automate works and looks from the user’s perspective
  • Build a simple flow
  • Learn the business value and features of Power Automate
Get Started with Power BI

Get Started with Power BI

Learn how organizations can use Power BI to easily clean, display, and understand data to ensure better informed decisions.

Lesson

  • Power BI Overview
  • How to Build a Simple Dashboard

Lab : How to build a simple dashboard

  • Create Power BI Report
  • Create Power BI Dashboard

After completing this module, students will be able to:

  • See how Power BI works and looks from the user’s perspective
  • Learn how to build a simple Power BI dashboard
  • Describe the business value and features of Power BI
Introduction to Power Virtual Agents

Introduction to Power Virtual Agents

Learn about the value and capabilities of Power Virtual Agents and ways organizations can leverage this technology to build chatbot solutions for their business.

Lesson

  • Power Virtual Agents overview
  • How to build a chatbot

Lab : How to build a basic chatbot

  • Sign up for PVA and Create a New Bot
  • Create Topics
  • Test Topics
  • Change the Greeting
  • Publish the Bot

After completing this module, students will be able to

  • Describe the business value and features of Power Virtual Agents
  • Build a basic chatbot
  • Learn essential components that make up Power Virtual Agents and chatbots
Get Started with Microsoft Data Analytics

Get Started with Microsoft Data Analytics

This module explores the different roles in the data space, outlines the important roles and responsibilities of a Data Analysts, and then explores the landscape of the Power BI portfolio.

Lesson

  • Data Analytics and Microsoft
  • Getting Started with Power BI

After completing this module, students will be able to:

  • Explore the different roles in data
  • Identify the tasks that are performed by a data analyst
  • Describe the Power BI landscape of products and services
  • Use the Power BI service
Prepare Data in Power BI

Prepare Data in Power BI

This module explores identifying and retrieving data from various data sources. You will also learn the options for connectivity and data storage and understand the difference and performance implications of connecting directly to data vs. importing it.

Lesson

  • Get data from various data sources

Lab : Preparing Data in Power BI Desktop

  • Prepare Data

After completing this module, students will be able to:

  • Identify and retrieve data from different data sources
  • Understand the connection methods and their performance implications
  • Use Microsoft Dataverse
  • Connect to a data flow
Clean, Transform, and Load Data in Power BI

Clean, Transform, and Load Data in Power BI

This module teaches you the process of profiling and understanding the condition of the data. They will learn how to identify anomalies, look at the size and shape of their data, and perform the proper data cleaning and transforming steps to prepare the data for loading into the model.

Lesson

  • Data shaping
  • Data Profiling
  • Enhance the data structure

Lab : Transforming and Loading Data in Power BI Desktop

  • Loading Data

After completing this module, students will be able to:

  • Apply data shape transformations
  • Enhance the structure of the data
  • Profile and examine the data
Design a Data Model in Power BI

Design a Data Model in Power BI

This module teaches the fundamental concepts of designing and developing a data model for proper performance and scalability. This module will also help you understand and tackle many of the common data modeling issues, including relationships, security, and performance.

Lesson

  • Introduction to data modeling
  • Working with tables
  • Dimensions and Hierarchies

Lab : Data Modeling in Power BI Desktop

  • Create Model Relationships
  • Configure Tables and Column Properties
  • Create hierarchies

After completing this module, students will be able to:

  • Understand the basics of data modeling
  • Define relationships and their cardinality
  • Implement Dimensions and Hierarchies
Create Model Calculations using DAX in Power BI

Create Model Calculations using DAX in Power BI

This module introduces you to the world of DAX and its true power for enhancing a model. You will learn about aggregations and the concepts of Measures, calculated columns and tables, and Time Intelligence functions to solve calculation and data analysis problems.

Lesson

  • Introduction to DAX
  • Real-time dashboards
  • Advanced DAX

Lab : Introduction to DAX in Power BI Desktop

  • Create calculated tables
  • Create calculated columns
  • Create measures

Lab : Advanced DAX in Power BI Desktop

  • Use the CALCULATE() function to manipulate filter context
  • Use Time Intelligence functions

After completing this module, students will be able to:

  • Understand DAX
  • Use DAX for simple formulas and expressions
  • Create calculated tables and measures
  • Build simple measures
  • Work with Time Intelligence and Key Performance Indicators
Optimize Model Performance in Power BI

Optimize Model Performance in Power BI

In this module you are introduced to steps, processes, concepts, and data modeling best practices necessary to optimize a data model for enterprise-level performance.

Lesson

  • Optimize the data model for performance
  • Optimize DirectQuery Models

After completing this module, students will be able to:

  • Understand the importance of variables
  • Enhance the data model
  • Optimize the storage model
Create Reports in Power BI

Create Reports in Power BI

This module introduces you to the fundamental concepts and principles of designing and building a report, including selecting the correct visuals, designing a page layout, and applying basic but critical functionality. The important topic of designing for accessibility is also covered.

Lesson

  • Design a report
  • Enhance the report

Lab : Designing a report in Power BI Desktop

  • Design a report
  • Configure visual fields and format properties

Lab : Enhancing reports with interaction and formatting in Power BI Desktop

  • Create and configure Sync Slicers
  • Create a drillthrough page
  • Apply conditional formatting
  • Create and use Bookmarks

After completing this module, students will be able to:

  • Design a report page layout
  • Select and add effective visualizations
  • Add basic report functionality
  • Add report navigation and interactions
Create Dashboards in Power BI

Create Dashboards in Power BI

In this module you will learn how to tell a compelling story through the use of dashboards and the different navigation tools available to provide navigation. You will be introduced to features and functionality and how to enhance dashboards for usability and insights.

Lesson

  • Create a Dashboard
  • Real-time Dashboards
  • Enhance a Dashboard

Lab : Creating a Dashboard in Power BI Service

  • Create a Dashboard
  • Pin visuals to a Dashboard
  • Use Q&A to create a dashboard tile

After completing this module, students will be able to:

  • Create a Dashboard
  • Understand real-time Dashboards
  • Enhance Dashboard usability
Identify Patterns and Trends in Power BI

Identify Patterns and Trends in Power BI

This module helps you apply additional features to enhance the report for analytical insights in the data, equipping you with the steps to use the report for actual data analysis. You will also perform advanced analytics using AI visuals on the report for even deeper and meaningful data insights.

Lesson

  • Advanced Analytics
  • Data Insights through AI visuals

Lab : Data Analysis in Power BI Desktop

  • Create animated scatter charts
  • Use the visual to forecast values

After completing this module, students will be able to:

  • Use the Analyze feature
  • Identify outliers in data
  • Use the AI visuals
  • Use the Advanced Analytics custom visual
Create and Manage Workspaces in Power BI

Create and Manage Workspaces in Power BI

This module will introduce you to Workspaces, including how to create and manage them. You will also learn how to share content, including reports and dashboards, and then learn how to distribute an App.

Lesson

  • Creating Workspaces
  • Sharing and Managing Assets

After completing this module, students will be able to:

  • Create and manage a workspace
  • Understand workspace collaboration
  • Monitor workspace usage and performance
  • Distribute an App
Manage Files and Datasets in Power BI

Manage Files and Datasets in Power BI

This module will introduce you to parameters and datasets. You will also learn how to manage datasets and parameters, build dynamic reports with parameters, and set dataset refresh options.

Lesson

  • Parameters
  • Datasets

After completing this module, students will be able to:

  • Manage datasets and parameters
  • Build dynamic reports with parameters
  • Schedule dataset refresh
  • Troubleshoot gateway service connectivity

Module 12: Row-level Security in Power BIThis module will introduce you to row-level security, both static and dynamic methods, and how to implement.Lesson

  • Security in Power BI

Lab : Enforce Row-Level Security

  • Configure many-to-many relationships
  • Enforce row-level security

After completing this module, students will be able to:

  • Implement row-level security using both the Static and Dynamic methods

Certification Camps has developed a comprehensive training / delivery format which focuses on learning beyond the core content accessible to any Microsoft training provider. Our program incorporates interactive demonstrations with explanations which go beyond the content of the book. Additional content, videos, labs & demonstrations are provided to expand on advanced topics - providing additional insight and perspective.  Certification Camps training is not the typical book & PowerPoint presentation found at any local training center.

As a Microsoft Certified Partner with Gold Learning Competency - we adhere to the strict guidelines, standards and requirements to use Microsoft's exclusive curriculum. More over - our standards go beyond the "minimum requirements" set forth by Microsoft Learning.

We leverage our partnership benefits of courseware customization to build end to end technology training solutions. Students gain practical skills which can be implemented immediately.

At most training centers - learning starts on the first day of class and ends on the last day. Our boot camp training program is designed to offer resources before, during and after.

CERTIFICATION CAMPS FACILITIES

CAMPUS - Certification Camps built out training center with spacious classrooms, new desk, Herman Miller Aeron chairs & comfortable common areas.  Each classroom has a maximum of two rows - so everyone is able to be engaged without the "back row" feeling.

CLASSROOM EQUIPMENT - Students work on a dedicated Dell Client Desktop with 32GB memory with 512GB SSD drives - All Labs are executed the extremely fast Microsoft Data Center Hosted Lab Environment .

CAMPUS INTERNET - The campus is connected with a 1Gbps (1,000 Mbps) Verizon Fios Business Connection which provides complete internet (including VPN) access for students.

COMMON AREA - Amenties including snacks, drinks (Coffee, 100% juices, sodas, etc) all complimentary.

LODGING - We use the Hyatt Place Lakewood Ranch. This "upgraded" hotel offers extremely comfortable beds, great breakfast and very fast  internet access.

NEAR BY - Many shops, restaurants and grocery options are available within walking distance. Additionally - the hotel provided scheduled shuttle services. Restaurants like Cheesecake Factory, California Pizza Kitchen, Panera Bread, Bone Fish Grill, Ruby Tuesday's, Five Guys, Chipotle, Chili's and over 20 additional choices in the immediate area.

About

  • About Us
  • Reviews
  • Contact Us
  • Blog

Bootcamps

  • SQL Server
  • Microsoft 365 Enterprise
  • Windows Server
  • Microsoft Azure Admin
  • Windows Client
  • Exchange Server
  • System Center
  • Microsoft Developer
  • Information Security
  • CompTia
  • Cisco

Vendors

  • Microsoft
  • Amazon
  • Cisco
  • CompTia
  • Ec-Council

Job Role

  • Developer
  • Administrator
  • Architect
  • Data Engineer
  • DevOps
  • Security

Registration

  • More Info
  • Register for a Bootcamp
  • Pay Invoice

Copyright © 2023 Certification Camps. All rights reserved.

  • Terms & Conditions
  • Privacy Policy