Power BI MCSA Certification Training (including exams 70-778 and 70-779)

£1,695.00 £1,595.00

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.

SKU: PWB-INCT-015 Category:


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.

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 both Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI and Exam 70-779: Analyzing and Visualizing Data with Microsoft Excel.

The training is very much hands-on; and delegates will be given numerous opportunities to complete real-world, practical projects.

Contact Us

Subject (required)

Your Name (required)


Email (required)


Please Describe your Requirement

Upload Example Document(s) (Zip multiple files)

Course Outline


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


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


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


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. In the afternoon, you will sit Exam 70-779: Analyzing and Visualizing Data with Microsoft Excel

Our Training Location

Our scheduled training courses take place at the following address:
Tower Bridge Business Centre
46-48 East Smithfield
London E1W 1AW
Tel: 0800 998 9248

On-site Training

When booking on-site training, use the pricing zone map below to determine the daily rate based on the location of your organization: zone A, £795, per day; zone B, £895, per day; zone C, £995, per day.

Price Zones

Additional information

Choose a Date

27-31 Jan 2020 (Discounted)