reed.co.uk Courses

Header

Power BI MCSA Certification Training (Including Exams 70-778 and 70-779)

Classroom based course with study materials, tutor support and final exam included


G Com Solutions Limited

Summary

Price
£1,914 inc VAT
Payment options

Payment may be made by credit card or BACS.

Study method
Classroom
Duration
5 Days, Full-time
Qualification
Microsoft Certified Solutions Associate (MCSA) Office 365 Power BI Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI
Professional What's this?
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

11 students enquired about this course

Add to basket or enquire

Location & dates

Location
Start date
End date
08/07/2019
12/07/2019

End date: 12/07/2019

Additional info: 9:30 a.m. till 5:00 p.m. Lunch provided.

Address
Tower Bridge Business Centre
46-48 East Smithfield
Central London
London
E1W1AW
19/08/2019
23/08/2019

End date: 23/08/2019

Additional info: 9:30 a.m. till 5:00 p.m. Lunch provided.

Address
Tower Bridge Business Centre
46-48 East Smithfield
Central London
London
E1W1AW
23/09/2019
27/09/2019

End date: 27/09/2019

Additional info: 9:30 a.m. till 5:00 p.m. Lunch provided.

Address
Tower Bridge Business Centre
46-48 East Smithfield
Central London
London
E1W1AW
11/11/2019
15/11/2019

End date: 15/11/2019

Additional info: 9:30 a.m. till 5:00 p.m. Lunch provided.

Address
Tower Bridge Business Centre
46-48 East Smithfield
Central London
London
E1W1AW

Overview

This instructor-led, Power BI certification training workshop is aimed at specialists in data analysis, data science, and business intelligence, who wish to validate and demonstrate their knowledge by obtaining the relevant Microsoft Power BI MCSA:BI Reporting certification.

Qualification

Microsoft Certified Solutions Associate (MCSA) Office 365 Power BI Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI
Awarded by Microsoft

Course media

Resources

  • Download Power BI Certification course brochure - download

Description

This instructor-led workshop is aimed at specialists in data analysis, data science, and business intelligence, who wish to validate and demonstrate their knowledge by obtaining the relevant Microsoft Power BI certification.

Delegates on this course will need to be familiar with the essentials of data analysis, databases and cloud computing; as well as the key elements of Power BI Desktop and the Power BI service. The topics covered on the course will be mainly at the intermediate and advanced level. Delegates will also need to be native English speakers or speak English fluently.

This Power BI certification course provides in-depth coverage of all of the topics which you will need to master in order to pass the Microsoft Power BI 70-778 and Excel BI 70-779 certifications. The training is very much hands-on; and delegates will be given numerous opportunities to complete real-world, practical projects.

COURSE OUTLINE

DAY ONE: DATA, QUERY EDITOR & M

Data connection
Connecting to data sources; Importing Excel data;
Connecting to SQL Server; Importing data vs Live Query;
Connecting to SSAS cubes; Understanding custom
connections

Cleaning up & transforming data
Modifying query steps; Understanding data types; Removing
unwanted space; Splitting & combining; Creating new
columns; Creating conditional columns

Advanced Query Editor Operations
Combining queries; Referencing a query; Converting a query
into a function; Understanding function syntax; Invoking a
function

Understanding the M language
Using the Formula Bar; Using the Advanced Editor; Overview
of the M Language; Using M Functions; The Let statement;
Understanding M variables; Writing logical statements;
Using text functions; Using date functions

DAY TWO: DATA MODELLING & DAX

Data modelling
Creating table relationships; Using active & inactive
relationships; Cross filter direction; Assume Referential
Integrity; Calculated columns; Implicit & explicit measures;
Creating hierarchies in Power BI; Creating hierarchies in
Excel; RELATED, RELATEDTABLE & EARLIER; Row & filter
context; The X functions; The CALCULATE function; ALL
function variations; The FILTER function; Using time
intelligence functions; Using What-if parameters

Advanced DAX
Using DAX Studio for debugging, Writing complex formulas,
Using variables, Calculating moving averages, Calculating
running totals, Percentile calculations, Creating advanced
time intelligence formulas, Using multiple date tables,
Working with non-standard calendars

Calculated tables
DAX functions that return tables; The CALCULATETABLE
function; The ADDCOLUMNS function; The SUMMARIZE
function; SUMMARIZE with ROLLUP; The CROSSJOIN
function; The TOPN function; The ROW function

DAY THREE: Desktop, service & mobile

Power BI Products & Subscriptions
The Roles of Power BI Desktop & of the Power BI service;
Azure Active Directory integration; Office 365 integration;
Power BI free, Pro & Premium; Tenant settings; Power BI
Report Server overview

Reports & Dashboards
Report & dashboard differences; Optimizing reports &
dashboards for mobile; Understanding dashboard tiles;
Optimizing Q&A; dashboard settings; Setting data alerts;
Pinning Excel content to dashboards

Publishing content
Creating security groups; Creating app workspaces;
Publishing apps; Apps versus content packs; Sharing reports
& dashboards; Publishing reports to the web; Embedding a
report in SharePoint; Using Analyze in Excel

Refreshing content
Using on premises gateways; Customizing dataset refresh
settings; Scheduling refresh frequency; Adding & removing
data sources, Live data connections; Connecting to
OneDrive for Business and Azure SQL databases

DAY FOUR: DATA VISUALIZATION & BEYOND

Excel Visualization
Creating PivotTables; PivotTable aggregation options;
Filtering data; Using slicers; Slicer options; Creating
timelines; Timeline options; Report connections; Creating
pivot charts; Excel chart types; Excel chart components;
Creating KPIs

Advanced Power BI visualization
Setting visual interactions; Using the Analytics pane; Using
Ask a Question; Using the Selection pane; Creating
bookmarks; Creating hyperlinks; Creating & using report
themes; Report, page & visual level filters; row-level security;
Drill-down options; Drill-through options; Using R visuals

Custom Visuals
Microsoft’s custom visual SDK; the role of JavaScript, jQuery
and TypeScript; Overview of D3.js; Using custom visuals

Power BI Embedded
Overview of Power BI Embedded; Embed tokens and
capacity; Embedding for licensed and unlicensed users;
Integrating dashboards, reports and tiles into an app

DAY FIVE: THE EXAM

There is no training on day 5; this is the day of the two exams.

In the morning, you will take Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI. And, in the afternoon, you will sit Exam 70-779: Analyzing and Visualizing Data with Microsoft Excel.

Don’t forget to bring two forms of ID with you; your passport, and a credit card bearing the same name, will do the trick. (If you prefer not to take the exams immediately after your training, then, for you, the course will finish at the end of day four.)

Who is this course for?

Aimed at specialists in data analysis, data science, and business intelligence, who wish to validate and demonstrate their knowledge by obtaining the relevant Microsoft certification.

Requirements

Delegates on this course will need to be familiar with the essentials of data analysis, databases and cloud computing; as well as the key elements of Power BI Desktop and the Power BI service. The topics covered on the course will be mainly at the intermediate and advanced level. Delegates will also need to be native English speakers or speak English fluently.

Career path

Passing the Power BI 70-778 exam could be your first step towards obtaining Microsoft’s new MCSA: BI Reporting certification. The certification is designed to prove your expertise in analyzing data using Microsoft Power BI and Excel; and requires two exams:

  1. 70-778 Analyzing and Visualizing Data with Power BI
  2. 70-779 Analyzing and Visualizing Data with Microsoft Excel

Questions and answers

Rating and reviews

There haven't been any reviews for this course yet.

Please sign in to review this course.