MCA Microsoft Data Analyst (Power BI) Associate Training & Certification Boot Camp – 5 Days
This Bootcamp is available in the following formats. Select format to view pricing.
Exams Included & Administered During Camp:
PL-900: Microsoft Power Platform Fundamentals
DA-100: Analyzing Data with Microsoft Power BI
What's Included
Airfare To/From Sarasota or Tampa
2 Microsoft Test Vouchers
2 Microsoft Official Courses
5 Nights of Lodging
1 Retake Voucher (per exam, if needed)
Microsoft Study Labs & Simulations
Ground Transportation
Onsite Pearson Vue Test Center
Instructor Led Classroom Training
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 Power Flow.
The Microsoft Data Analyst Boot Camp Is Taught Using Microsoft Official Courseware
PL-900T00: Microsoft Power Platform Fundamentals
DA-100T00: Analyzing Data with Microsoft Power BI
While attending this 5 day instructor led live camp - students will take two exams (PL-900 / DA-100) 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.
Skills Gained:
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
Describe the Power Platform components: Power Apps, Power BI and Microsoft Automate
Describe the Power Platform components: Common Data Service, Connectors and AI builder
Describe cross-cloud scenarios across M365, Dynamics 365, Microsoft Azure and 3rd party services
Identify benefits and capabilities of Power Platform
Identify the basic functionality and business value Power Platform components
Implement simple solutions with Power Apps, Power Automate, Power BI, and Power Virtual Agents
Topics Covered in this Official Boot Camp
Introduction to Power Platform
Lessons
- Power Platform Overview
- Module Summary
Get Started with Power Apps
Lessons
- Power Apps Overview
- How to Build an App Solution
- Create Staff Canvas App
- Complete the App
Lab : How to Build a Basic Canvas App 2
- Create Security Canvas App
Introduction to Common Data Service
Lessons
- Common Data Service Overview
- Module Summary
Lab : Data Modeling
- Create Environment and Solution
- Create Entities and Relationships
- Import Data
Get Started with Power Automate
Lessons
- Power Automate Overview
- How to Build an Automated Solution
Lab : Build a Simple Flow
- Create Visit Notification Flow
- Create Security Sweep Flow
Get Started with Power BI
Lessons
- Power BI Overview
- How to Build a Simple Dashboard
Lab : Build a Power BI Report
Power BI Portfolio
Lessons
- The Power BI Portfolio
- Identifying Tasks of the Data Analyst
Lab : Getting Started
- Getting Started
Getting and Profiling Data
Lessons
- Data Sources
- Storage Modes
- Query Performance
- Data Profiling
Lab : Preparing Data in Power BI Desktop
- Prepare Data
Cleaning and Transforming Data
Lessons
- User-Friendliness
- Combining Queries
- Data cleaning and transformation
- Advanced capabilities
- Configuring data loading and resolving errors
Lab : Loading Data in Power BI Desktop
- Loading Data
Designing a Data Model
Lessons
- Data modeling basics
- Measures and Dimensions
- Model Performance
Lab : Data Modeling in Power BI Desktop
- Create Model Relationships
- Configure Tables
- Review the model interface
- Create Quick Measures
Developing a Data Model
Lessons
- Common data modeling techniques
- Adding columns to support the data model
- Row-level security
- Q&A considerations
Lab : Advanced Data Modeling
- Create a man-to-many relationship
- Enforce row-level security
Creating Model Calculations with DAX
Lessons
- Introduction to DAX
- Creating tables and columns
- Measures
- The CALCULATE expression
- Time-Intelligence functions
Lab : Using DAX in Power BI – Part 1
- Create Calculated tables
- Create Measures
Lab : Using DAX in Power BI – Part 2
- Work with Filter content
- Work with Time-Intelligence
- Publish the Power BI Desktop file
Optimizing Model Performance
Lessons
- Fine-tune the data model
- Cardinality
- Identifying performance issues
Creating Reports
Lessons
- Selecting a visualization
- Configuring visualizations
- Formatting pages
- Enhancing the report
Lab : Designing a report in Power BI Desktop – Part 1
- Create a report
- Sign in to the Power BI Service
Enhancing Reports for Usability and Performance
Lessons
- Bookmarks and navigation
- Designing cohesive pages and interactions
- Improving reports
Lab : Designing a report in Power BI Desktop – Part 2
- Configure Sync Slicers
- Configure Drill-through
- Add Conditional Formatting
- Add Bookmarks and Buttons
- Explore the Report
Creating Dashboards
Lessons
- Dashboard design
- Real-time dashboards
- Dashboard enhancements
Lab : Creating a Power BI Dashboard
- Create a Dashboard
- Refresh the dataset
- Review the dashboard
Enhancing Reports and Applying Advanced Analytics
Lessons
- Navigation
- Basic analysis
- Grouping, binning, and clustering
- Analysis over time
- Advanced analysis
Lab : Data Analysis in Power BI Desktop
- Create a report
- Create a Scatter chart
- Create a Forecast
- Work with a Decomposition Tree
- Work with Key Influencers
Managing and Sharing Power BI Assets
Lessons
- Dataset management
- Enhancing datasets
- Configure row-level security
- Create and Manage workspaces
- Enhancing datasets and reports in the workspace
- Sharing and distributing content
Lab : Publishing and Sharing Power BI Content
- Configure dataset security
- Share a Dashboard
- Publish an APP
Working with Paginated Reports in Power BI
Lessons
- Introduction to Paginated Reports
- Data sources and datasets
- Adding visual elements
- Enhancing and publishing reports
Lab : Creating a Paginated report
- Getting Started
- Develop the report
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 a state of the art training center with spacious classrooms, no sound transference between rooms, large individual desk, Herman Miller Aeron chairs & great common areas.
CLASSROOM SERVERS & LABS - Students work on a dedicated Dell 8700 / 8900 with an Intel i7 (6th generation), 32GB memory with 512GB SSD drives. Most labs are administered with Microsoft Data Center Hosted Labs Environments - providing the very best in performance and reliability.
CAMPUS INTERNET - The campus is connected with a 300Mbs Verizon Fios Business Connection which provides complete internet (including VPN) access for students.
COMMON AREA - Unlike any training facility ever - break room with Mame Arcade, high end "kitchen" with snacks, drinks (Starbucks Coffee, 100% juices, sodas, etc) and breathtaking terrace.
LODGING - We use the Marriott Fairfield Inn & Suites Lakewood Ranch. This "upgraded" hotel offers extremely comfortable beds, great breakfast and very fast (Verizon) internet access.
NEARBY AMENITIES - 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, Quiznos, Chili's and over 20 additional choices in the immediate area. All of these options are offered in a pedestrian walking village.