£1,595.00 – £3,980.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.
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.
Connecting to data sources; Importing Excel data; Connecting to SQL Server; Importing data vs Live Query; Connecting to SSAS cubes; Understanding custom connections
Modifying query steps; Understanding data types; Removing unwanted space; Splitting & combining; Creating new columns; Creating conditional columns
Combining queries; Referencing a query; Converting a query into a function; Understanding function syntax; Invoking a function
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
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
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
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
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
Report & dashboard differences; Optimizing reports & dashboards for mobile; Understanding dashboard tiles; Optimizing Q&A; dashboard settings; Setting data alerts; Pinning Excel content to dashboards
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
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
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
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
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 scheduled training courses take place at the following address:
Tower Bridge Business Centre
46-48 East Smithfield
London E1W 1AW
Tel: 0800 998 9248
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.
|Choose a Date||
15-19 Jul 2019 – London, 2-6 Sep 2019 – London, 21-25 Oct 2019 – London, 2-6 Dec 2019 – London, 27-31 Jan 2020 – London, 24-28 Feb 2020 – London, 20-24 Apr 2020 – London, 1-5 Jun 2020 – London, On-site training – Zone A, On-site training – Zone B, On-site training – Zone C