Power BI Certification Training (Exam DA-100)

This instructor-led, Power BI Certification training for Exam DA100 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 Certified: Data Analyst Associate qualification.

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 Exam DA-100: Analyzing Data with Microsoft Power BI.

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

Power BI Certification Training (Exam DA-100): Course Outline

Prepare the Data (20-25%)

Get data from different data sources

Identify and connect to a data source
Change data source settings
Select a shared dataset or create a local dataset
Select a storage mode
Choose an appropriate query type
Identify query performance issues
Use the Common Data Service (CDS)
Use parameters

2. Profile the data

Identify data anomalies
Examine data structures
Interrogate column properties
Interrogate data statistics

Clean, transform, and load the data

Resolve inconsistencies, unexpected or null values, and data quality issues
Apply user-friendly value replacements
Identify and create appropriate keys for joins
Evaluate and transform column data types
Apply data shape transformations to table structures
Combine queries
Apply user-friendly naming conventions to columns and queries
Leverage Advanced Editor to modify Power Query M code
Configure data loading
Resolve data import errors

Model the Data (25-30%)

Design a data model

Define the tables
Configure table and column properties
Define quick measures
Flatten out a parent-child hierarchy
Define role-playing dimensions
Define a relationship’s cardinality and cross-filter direction
Design the data model to meet performance requirements
Resolve many-to-many relationships
Create a common date table
Define the appropriate level of data granularity

Develop a data model

Apply cross-filter direction and security filtering
Create calculated tables
Create hierarchies
Create calculated columns
Implement row-level security roles
Set up the Q&A feature

Create measures by using DAX

Use DAX to build complex measures
Use CALCULATE to manipulate filters
Implement Time Intelligence using DAX
Replace numeric columns with measures
Use basic statistical functions to enhance data
Create semi-additive measures

Optimize model performance

Remove unnecessary rows and columns
Identify poorly performing measures, relationships, and visuals
Improve cardinality levels by changing data types
Improve cardinality levels through summarization
Create and manage aggregations

Visualize the Data (20-25%)

Create reports

Add visualization items to reports
Choose an appropriate visualization type
Format and configure visualizations
Import a custom visual
Configure conditional formatting
Apply slicing and filtering
Add an R or Python visual
Configure the report page
Design and configure for accessibility
Configure automatic page refresh

Create dashboards

Set mobile view
Manage tiles on a dashboard
Configure data alerts
Use the Q&A feature
Add a dashboard theme
Pin a live report page to a dashboard
Configure data classification

Enrich reports for usability

Configure bookmarks
Create custom tooltips
Edit and configure interactions between visuals
Configure navigation for a report
Apply sorting
Configure Sync Slicers
Use the selection pane
Use drillthrough and cross filter
Drilldown into data using interactive visuals
Export report data
Design reports for mobile devices

Analyze the Data (10-15%)

Enhance reports to expose insights

Apply conditional formatting
Apply slicers and filters
Perform top N analysis
Explore statistical summary
Use the Q&A visual
Add a Quick Insights result to a report
Create reference lines by using Analytics pane
Use the Play Axis feature of a visualization

Perform advanced analysis

Identify outliers
Conduct Time Series analysis
Use groupings and binnings
Use the Key Influencers to explore dimensional variances
Use the decomposition tree visual to break down a measure
Apply AI Insights

Deploy and Maintain Deliverables (10-15%)

Manage datasets

Configure a dataset scheduled refresh
Configure row-level security group membership
Providing access to datasets
Configure incremental refresh settings
Promote or certify a dataset

Create and manage workspaces

Create and configure a workspace
Recommend a development lifecycle strategy
Assign workspace roles
Configure and update a workspace app
Publish, import, or update assets in a workspace
Apply sensitivity labels to workspace content

Private Instructor-Led Online Training

If you have several staff members that need to complete this training, we can arrange a private instructor-led online training course tailored to the requirements of your organisation. Each person is given remote access to a computer in our training centre and provided with lots of opportunities to practice all of the techniques being taught remotely. This means that your staff can attend a course either in the office or from home.

On-site Training

N.B. For the moment, we have replaced on-site training with private online courses.

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