Power BI MCSA Certification Training (Exam Included)

£1,495.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.

Clear
SKU: PWB-INCT-010 Category:

Description

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.

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

Additional information

Choose a Date

4-8 Feb 2019, 25-29 Mar 2019, 13-17 May 2019, 8-12 Jul 2019, 2-6 Sep 2019, 21-25 Oct 2019, 2-6 Dec 2019, On-site training at your offices