MCSA: Power BI Reporting

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

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.

Our scheduled course is held in Peterborough; and we can also deliver this course on-site, anywhere in the UK.

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.

Power BI MCSA Certification Training: Course Outline

DAY ONE: 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 TWO: 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 THREE: 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 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 EXAMS

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

(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.)


Our charge for supplying Microsoft Power BI Certification training courses in Reading is £750, per day.
Our fee for delivering on-site Power BI Certification courses in Bedford is £750, per day.
The cost of supplying on-site Power BI Certification training courses in Coventry is £750, per day.
Our charge for delivering in-house Power BI Certification courses in The West Midlands is £695, per day.
The fee for running on-site Power BI Certification training in Edinburgh is £825, per day.
Our fee for delivering on-site Power BI Certification training in Sheffield is £750, per day.
Our price for delivering on-site Power BI Certification courses in Basingstoke is £695, per day.
The cost of supplying on-site Power BI Certification training courses in Teesside is £750, per day.
Our price for running customized Power BI Certification training courses in Swindon is £695, per day.
Our price for supplying customized Power BI Certification courses in Burnley is £750, per day.
Our fee for delivering on-site Power BI Certification courses in Cambridge is £695, per day.
The charge for running on-site Power BI Certification training courses in Chelmsford is £750, per day.
The cost for running on-site Power BI Certification training courses in Tyneside is £750, per day.
The cost of supplying on-site Power BI Certification training in Glasgow is £825, per day.
The charge for running Microsoft Power BI Certification training courses in Colchester is £695, per day.
The cost of supplying customized Power BI Certification training courses in Barnsley is £750, per day.
Our price for supplying on-site Power BI Certification training courses in Cheltenham is £695, per day.
Our charge for delivering customized Power BI Certification courses in Exeter is £695, per day.
The cost of supplying in-house Power BI Certification courses in Blackburn is £695, per day.
The fee for running in-house Power BI Certification training courses in Poole is £750, per day.
Our charge for supplying customized Power BI Certification training courses in Blackpool is £750, per day.
The cost of supplying in-house Power BI Certification training courses in Bristol is £695, per day.
The cost of supplying in-house Power BI Certification training courses in Chesterfield is £695, per day.
The charge for running in-house Power BI Certification courses in Warrington is £850, per day.
Our charge for delivering in-house Power BI Certification courses in Milton Keynes is £695, per day.
Our charge for delivering in-house Power BI Certification training courses in Nottingham is £695, per day.
The cost for running customized Power BI Certification training in Mansfield is £825, per day.
Our price for running on-site Power BI Certification training in Gloucester is £750, per day.
The cost for running on-site Power BI Certification training in Maidstone is £750, per day.
Our price for delivering customized Power BI Certification training courses in Plymouth is £750, per day.
Our charge for supplying in-house Power BI Certification training courses in Manchester is £695, per day.
The cost for running customized Power BI Certification training in Basildon is £695, per day.
The charge for running in-house Power BI Certification training courses in Crawley is £750, per day.
Our charge for delivering on-site Power BI Certification training in Preston is £695, per day.
The cost of supplying customized Power BI Certification training in Worcester is £695, per day.
Our price for running customized Power BI Certification training in Derby is £750, per day.
Our price for running customized Power BI Certification training courses in Thanet is £750, per day.
Our charge for delivering customized Power BI Certification training in Grimsby is £695, per day.
Our price for delivering on-site Power BI Certification training courses in Swansea is £750, per day.
Our price for delivering customized Power BI Certification training in Doncaster is £695, per day.
Our charge for supplying customized Power BI Certification training in Farnborough/Aldershot is £695, per day.
The fee for running on-site Power BI Certification training in Accrington/Rossendale is £695, per day.
Our fee for delivering Microsoft Power BI Certification training courses in Ipswich is £695, per day.
Our charge for supplying on-site Power BI Certification training in Telford is £695, per day.
The fee for running on-site Power BI Certification training in Aberdeen is £750, per day.
Our price for delivering Microsoft Power BI Certification training courses in Oxford is £695, per day.
Our price for delivering on-site Power BI Certification courses in Ireland is £695, per day.
The cost of supplying customized Power BI Certification courses in High Wycombe is £695, per day.
The fee for running customized Power BI Certification training in London is £695, per day.
The cost of supplying on-site Power BI Certification training in Lincoln is £750, per day.
Our price for supplying in-house Power BI Certification courses in Bournemouth is £750, per day.
Our price for running in-house Power BI Certification training courses in Belfast is £695, per day.
Our fee for delivering in-house Power BI Certification courses in Peterborough is £695, per day.
Our price for supplying on-site Power BI Certification training in Cardiff is £750, per day.
The fee for running Microsoft Power BI Certification training courses in Sunderland is £750, per day.
Our price for supplying on-site Power BI Certification courses in York is £695, per day.
Our charge for supplying on-site Power BI Certification training in Medway Towns is £750, per day.
The fee for running customized Power BI Certification training courses in Stoke-on-Trent is £750, per day.
Our fee for delivering customized Power BI Certification training in Eastbourne is £695, per day.
Our price for supplying customized Power BI Certification training in Newport is £750, per day.
The cost of supplying customized Power BI Certification courses in Wigan is £695, per day.
Our price for delivering customized Power BI Certification training in Kingston upon Hull is £695, per day.
The fee for running Microsoft Power BI Certification training courses in Leicester is £750, per day.
Our price for delivering customized Power BI Certification training courses in South Hampshire is £695, per day.
Our charge for supplying on-site Power BI Certification training in West Yorkshire is £695, per day.
Our charge for delivering on-site Power BI Certification training courses in Norwich is £750, per day.
Our charge for supplying customized Power BI Certification courses in Hastings is £750, per day.
Our price for delivering on-site Power BI Certification courses in Northampton is £750, per day.
The charge for running customized Power BI Certification training in Dundee is £850, per day.
The cost for running in-house Power BI Certification training courses in Southend-on-Sea is £695, per day.
The cost for running on-site Power BI Certification training courses in Brighton and Hove is £695, per day.
Our charge for supplying in-house Power BI Certification courses in Torquay is £850, per day.
Our charge for delivering in-house Power BI Certification training courses in Slough is £695, per day.
The cost for running on-site Power BI Certification training in Burton-upon-Trent is £695, per day.
The fee for running on-site Power BI Certification training courses in Liverpool is £695, per day.
The cost for running on-site Power BI Certification training courses in Luton is £695, per day.
The cost of supplying in-house Power BI Certification training courses in Birkenhead is £750, per day.

Power BI Training 2018: Certification Schedule

Date Duration Course Title
15/01/2018 5 days Power BI Certification
19/02/2018 5 days Power BI Certification
19/03/2018 5 days Power BI Certification
16/04/2018 5 days Power BI Certification
14/05/2018 5 days Power BI Certification
11/06/2018 5 days Power BI Certification
09/07/2018 5 days Power BI Certification
13/08/2018 5 days Power BI Certification
10/09/2018 5 days Power BI Certification
08/10/2018 5 days Power BI Certification
12/11/2018 5 days Power BI Certification
10/12/2018 5 days Power BI Certification