• Blog
  • Reviews
  • Contact Us
  • Locations
1-844-BOOTCAMP
or 1-941-218-0007
Certification Camps
  • HOME
  • BOOTCAMPS
    • Microsoft 365 Enterprise
      • MCE Microsoft 365 Enterprise Administrator
      • MCA Microsoft 365 Messaging Administrator
      • MCA Microsoft 365 Security Administrator
      • MCA Microsoft 365 Teams Administrator
      • MCA Microsoft 365 Modern Desktop Administrator
    • Microsoft Azure Admin
      • MCA Azure Administrator
      • MCA Azure Security Engineer
      • MCA Windows Server Hybrid Administrator
      • MCE Azure DevOps Engineer
      • MCE Azure Solutions Architect
      • MCS Azure Virtual Desktop
    • Microsoft Azure Data
      • MCA Azure Database Administrator
      • MCA Azure Data Engineer
      • MCA Azure Data Analyst Power BI
      • MCA Power Platform Functional Consultant
    • Microsoft Azure Developer
      • MCA Azure Developer
      • MCE Azure DevOps Engineer
    • Microsoft Security, Compliance & Identity
      • MCA Identity & Access Admin
      • MCA Information Protection Admin
      • MCA Security Operations Analyst
    • Combo Classes
      • Azure Admin & Azure Architect
      • Azure Admin & Azure DevOps
      • Azure Developer & Azure DevOps
      • Microsoft 365 Desktop & Enterprise Admin
      • Microsoft 365 Security & Enterprise Admin
    • CompTia
      • CompTia A+ Essentials
      • CompTIA Cloud+
      • CompTia Network+
      • CompTia Security+
    • Information Security
      • EC-Council Certified Ethical Hacker (CEH)
      • (ISC)² CISSP
    • Cisco
      • Cisco CCNP Routing and Switching
      • Cisco CCNA
    • Amazon Web Services
      • AWS Certified Solutions Architect Associate
  • SCHEDULE
  • Role Based Certifications
  • Pay an Invoice
Home > Bootcamps
MICROSOFT AZURE ADMIN BOOTCAMP

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

$3,995 CLASSROOM LIVE
Price includes: Instructor Led Class, Official Courseware, Labs and Exams
The Microsoft Power BI Data Analyst Associate boot camp teaches students how to use Power BI to design and build scalable data models. This camp covers TWO Microsoft courses (Microsoft Power Platform Fundamentals and Microsoft Power BI Data Analyst), TWO Microsoft exams (PL900 and PL300) for TWO Microsoft certifications (Microsoft Power BI Data Analyst Associate and Microsoft Certified Power Platform Fundamentals) at our training facility in Florida or Online.
Register for this bootcamp before the end of January (for any date) and get $250 discount.
Get Coupon Code.

Training Schedule and Pricing

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

Select Delivery Format:
Classroom Live
Remote Classroom Live
Check Box To Include:
  • Jun
    27
    2022
    Delivery Format:
    CLASSROOM LIVE
    Date:
    06.27.2022 - 07.01.2022
    Location:
    SARASOTA
    Price Includes:
    Instructor Led Class, Official Courseware, Labs and Exams
    $3,995
    5 days
    Enroll Generate a Quote Ask a Question
  • Jul
    25
    2022
    Delivery Format:
    CLASSROOM LIVE
    Date:
    07.25.2022 - 07.29.2022
    Location:
    SARASOTA
    Price Includes:
    Instructor Led Class, Official Courseware, Labs and Exams
    $3,995
    5 days
    Enroll Generate a Quote Ask a Question
  • Aug
    29
    2022
    Delivery Format:
    CLASSROOM LIVE
    Date:
    08.29.2022 - 09.02.2022
    Location:
    SARASOTA
    Price Includes:
    Instructor Led Class, Official Courseware, Labs and Exams
    $3,995
    5 days
    Enroll Generate a Quote Ask a Question
  • Sep
    26
    2022
    Delivery Format:
    CLASSROOM LIVE
    Date:
    09.26.2022 - 09.30.2022
    Location:
    SARASOTA
    Price Includes:
    Instructor Led Class, Official Courseware, Labs and Exams
    $3,995
    5 days
    Enroll Generate a Quote Ask a Question
  • Oct
    24
    2022
    Delivery Format:
    CLASSROOM LIVE
    Date:
    10.24.2022 - 10.28.2022
    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
  • Nov
    28
    2022
    Delivery Format:
    CLASSROOM LIVE
    Date:
    11.28.2022 - 12.02.2022
    Location:
    SARASOTA
    Price Includes:
    Instructor Led Class, Official Courseware, Labs and Exams
    $3,995
    5 days
    Enroll Generate a Quote Ask a Question
  • Dec
    19
    2022
    Delivery Format:
    CLASSROOM LIVE
    Date:
    12.19.2022 - 12.23.2022
    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

Certifications

  • MCA Microsoft Azure Data Analyst (Power BI) Associate

Course Delivery

This course is available in the following formats:

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

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
  • Instructor Led Classroom TrainingInstructor Led Classroom Training

Exams Included & Administered During Camp:

PL-900: Microsoft Power Platform Fundamentals

PL-300: Microsoft Power BI Data Analyst

  • Course Description
  • Microsoft Azure Certifications
  • Microsoft Gold Learning Partner
  • Facilities

The NEW Microsoft Power BI 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 Power 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 Power BI Data Analyst Associate & Microsoft Certified Power Platform.  This hands on, instructor led live camp focuses on real world responsibilities of a Power BI Data Analyst covering the information needed for the certification exams which are administered while attending.

Skills Gained:

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 Power PlatformIntroduction to Common Data ServiceGet 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 BIRow-level Security in Power BI
Introduction to Power Platform

Introduction to Power Platform

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

Lessons

  • Power Platform Overview
  • Module Summary

After completing this module, students will be able to:

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

Introduction to Common Data Service

Introduction to Common Data Service

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

Lessons

  • Common Data Service Overview
  • Module Summary

Lab : Data Modeling

  • Create Solution
  • Create Entities and Relationships
  • Import Data

After completing this module, students will be able to:

  • Descibe the difference between Common Data Service and Common Data Model
  • Explain use cases and limitations of business rules and process flows
  • Explain what environments, entities, fields, and relationships are in common data service
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.

Lessons

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

Lessons

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

Lessons

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

Lessons

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

Lessons

  • Data Analytics and Microsoft
  • Getting Started with Power BI

Lab : Getting Started

  • Getting Started

After completing this module, you 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.

Lessons

  • Get data from various data sources
  • Optimize performance
  • Resolve data errors

Lab : Preparing Data in Power BI Desktop

  • Prepare Data

After completing this module, you will be able to:

  • Identify and retrieve data from different data sources
  • Understand the connection methods and their performance implications
  • Optimize query performance
  • Resolve data import errors
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.

Lessons

  • Data shaping
  • Enhance the data structure
  • Data Profiling

Lab : Transforming and Loading Data

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

Lessons

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

Lab : Data Modeling in Power BI Desktop

  • Create Model Relationships
  • Configure Tables
  • Review the model interface
  • Create Quick Measures

Lab : Advanced Data Modeling in Power BI Desktop

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

After completing this module, you will be able to:

  • Understand the basics of data modeling
  • Define relationships and their cardinality
  • Implement Dimensions and Hierarchies
  • Create histograms and rankings
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.

Lessons

  • Introduction to DAX
  • DAX context
  • 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, you 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
Row-level Security in Power BI

Row-level Security in Power BI

This 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

Microsoft Job Role-based Azure Certifications

Microsoft has aligned Azure certifications and training to job roles - focusing on Admin, Dev or Architect.
Each certification requires 2 exams and no certification has any prerequisite certification requirements.

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
  • Office 365
  • Windows Client
  • Exchange Server
  • Sharepoint Server
  • System Center
  • Microsoft Azure Developer
  • Information Security
  • CompTia
  • Cisco

Certifications

  • Microsoft Azure Data
  • Microsoft 365
  • Windows Server
  • Microsoft Windows Client
  • Microsoft 365 Messaging Server
  • Microsoft 365 Enterprise
  • Microsoft 365 Teamwork
  • Microsoft Azure Admin
  • Microsoft Azure Developer
  • Microsoft Technology Associate
  • Information Security
  • CompTia
  • Cisco

Registration

  • More Info
  • Register for a Bootcamp
  • Pay Invoice

Technical Training

  • SQL Server
  • Microsoft 365
  • Microsoft Azure
  • Windows Server
  • Windows Client
  • Exchange Server
  • Office 365
  • Sharepoint
  • System Center
  • Visual Studio

Copyright © 2021 Certification Camps. All rights reserved.

  • Terms & Conditions
  • Privacy Policy