Power BI Certification Training for Exam 70-778

    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 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 the Microsoft Power BI 70-778 certification: Consume and Transform Data By Using Power BI Desktop; Model and Visualize Data; and Configure Dashboards in the Power BI Service. The training is very much hands-on; and delegates will be given numerous opportunities to complete real-world, practical projects.

    Power BI 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

    Reports & Dashboards

    Report & dashboard differences; Optimizing reports &

    dashboards for mobile; Understanding dashboard tiles; Optimizing Q&A; dashboard settings

    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

    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; RELATED, RELATEDTABLE & EARLIER; Implicit & explicit measures; Row & filter context; The X functions; The CALCULATE function; ALL function variations; The FILTER function; Using time intelligence functions; Using 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

    Advanced 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

    Power Apps & Flow

    Overview of PowerApps and Flow; Creating a powerapp; Using the PowerApp custom visual; Adding a Power BI tile inside a power app; Using streaming data sets; Using the Power BI – Add rows to dataset step

    DAY FIVE: THE EXAM

    There is no training on day 5; this is the day of the exam. (If you prefer not to take the exam 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

    DateDurationCourse Title
    15/01/20185 daysPower BI Certification
    19/02/20185 daysPower BI Certification
    19/03/20185 daysPower BI Certification
    16/04/20185 daysPower BI Certification
    14/05/20185 daysPower BI Certification
    11/06/20185 daysPower BI Certification
    09/07/20185 daysPower BI Certification
    13/08/20185 daysPower BI Certification
    10/09/20185 daysPower BI Certification
    08/10/20185 daysPower BI Certification
    12/11/20185 daysPower BI Certification
    10/12/20185 daysPower BI Certification