How I Used Pragmatic Works' Training to Pass the Power BI 70-778 Certification

analyzing-and-visualizing-data-with-microsoft-power-bi_thumb.png

I recently took and passed the Microsoft certification exam 70-778 for Power BI called Analyzing and Visualizing Data with Microsoft Power BI. I’ve taken Microsoft certification exams in the past, but for the first time I took the exam using the online proctor method. I read several reviews by others that had a rough experience with this method of doing exams, but luckily I had a very positive experience.

Now that I’ve taken this exam for myself, I want share how you can use the Power BI training offered by Pragmatic Works to prepare for the 70-778 exam.

Exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI

The exam is broken down into three sections: Consume and Transform Data By Using Power BI Desktop, Model and Visualize Data, and Configure Dashboards in the Power BI Service. So let’s break down each of these sections of the exam and learn which courses offered by Pragmatic Works would benefit you when studying for these sections.

Consume and Transform Data By Using Power BI Desktop

Connect to Data Sources

Perform Transformations

Cleanse Data

Model and Visualize Data

Create and optimize data models

Create calculated columns, tables and measures

Create performance KPIs

Create hierarchies

Introduction to Power BI: Module 5 – Creating the Data Model

Create and format interactive visualizations

Manage custom reporting solutions

Advanced Power BI: Module 8 – Power BI Embedded

Configure Dashboards in the Power BI Service

Configure a dashboard

Introduction to Power BI: Module 11 – Using the Power BI Services

Publish dashboards

Introduction to Power BI: Module 11 – Using the Power BI Services

Configure security for dashboards

Configure organizational content packs and apps

These are some great resources to get you started, but you should always be on the lookout for more! I’d recommend giving a read to my good friend Dustin Ryan’s blog that covers several other resources that will help you get prepared! To those of you getting ready to take this exam, I wish you luck!

Click here to learn more about our On-Demand Training platform that includes 30+ courses.

• Microsoft MVP • Leads all training programs for Pragmatic Works • Business Intelligence consultant with work experience building SQL Server data warehouses • Experience building SharePoint BI solutions with Excel Services, PowerPivot, PerformancePoint, Reporting Services and Power View • Work daily with entire BI stack: SSIS, SSAS, SSRS for SQL Server • Speaking history at multiple SQL Saturdays, SQL Rally and PASS Summit • Planned and implemented Both proof of concepts and full production ready BI solutions. • Professional Association for SQL Server (PASS) member • Leads the Jacksonville SQL Server User Group • Author of 6 SQL Server books