1-844-BOOTCAMP
or 1-941-218-0007
Home > Certifications
MICROSOFT AZURE DATA CERTIFICATION

MCSA: SQL 2016 BI Reporting

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

Bootcamps:

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:

70-778: Analyzing Data with Power BI*

70-779:  Analyzing Data with Excel*

What's Included

  • Airfare To/From Sarasota or TampaAirfare - Your Location To Tampa, FL*
  • 4 Microsoft Test Vouchers2 Microsoft Test Vouchers
  • Microsoft Training Books2 Microsoft Official Courses
  • 12 Nights of Lodging5 Nights of Lodging
  • 2 Retake Vouchers (If needed)1 Retake Voucher (per exam, if needed)
  • Microsoft Study Labs & SimulationsMicrosoft Study Labs & Simulations
  • Ground TransportationGround Transportation
  • Onsite Prometric Testing CenterOnsite Pearson Vue Test Center
  • Instructor Led Classroom TrainingInstructor Led Classroom Training

The Microsoft Official MCSA SQL 2016 BI Reporting certification boot camp is a 5 day comprehensive deep dive into the SQL Server 2016 reporting tools. This camp covers topics such as Power BI Service, Power BI Mobile App and Excel tools including Excel Data Model & Power Pivot Charts.

The Microsoft SQL 2016 Business Intelligence Reporting boot camp incorporates Microsoft Official Courses -

20778 Analyzing Data with Power BI
20779 Analyzing Data with Excel

If your goal is to learn how to use SQL Server 2016 and gain the knowledge needed to pass the certification exams (70-778 / 70-779) - you've found the right place. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives.

Topics covered in this boot camp:

Perform Power BI desktop data transformation.
Describe Power BI desktop modelling.
Create a Power BI desktop visualization.
Implement the Power BI service.
Describe how to connect to Excel data.
Describe how to collaborate with Power BI data.
Connect directly to data stores.
Describe the Power BI developer API.
Describe the Power BI mobile app.

Explore and extend a classic Excel dashboard.
Explore and extend an Excel data model.
Pre-format and import a .CSV file.
Import data from a SQL Server database
Import data from a report.
Create measures using advanced DAX functions.
Create data visualizations in Excel.
Create a Power BI dashboard with Excel.

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

During Camp - While attending camp - you will work hands on with an industry leading "real world experienced" Microsoft Certified Trainer.