LIVE Instructor-Led Courses
Dismiss

Data Analytics with Power BI training course

Learn from practicing experts how to perform Advanced Analytics with Power BI

JBI training course London UK

" I enjoyed the depth that we covered analytical techniques such as anomaly detection and  cluster analysis, whilst improving my knowledge on DAX and KPIs. The trainer was informative, patient and kept the training engaging."

BC, Performance analyst, Data Analysis with Power BI, April 2021

Public Courses

22/04/24 - 2 days
£1495 +VAT
03/06/24 - 2 days
£1495 +VAT
15/07/24 - 2 days
£1495 +VAT

Customised Courses

* Train a team
* Tailor content
* Flex dates
From £1200 / day
EDF logo Capita logo Sky logo NHS logo RBS logo BBC logo CISCO logo
JBI training course London UK

  • Gain an understanding of Data Analysis and Data Science
  • Explore Statistical Summary
  • Identify Outliners
  • Conduct series forecasting using an established suite of methods for time series prediction
  • Advanced Analytics Custom Visuals
  • Clustering techniques using standard and custom visuals
  • Visualise combined KPIs to help you with multi-line chart and labels for current date, values and variances
  • Compare different methods of creating visuals based on R and Python
  • Use decision trees and decomposition tree to analyse important decision criteria
  • Explore the key influence visual
  • Use small multiples to allow easy comparison of different parts of your dataset
  • Use Anomaly detection features
  • Analyse Twitter posts and media impressions with Twitter Analysis tools
  • Learn to create 'What If' parameters to dynamically transform your dataOn special request (extra half day)  : AI and Power BI: use Azure cognitive services in Power BI
  • Text analysis
  • Sentiment analysis
  • Key feature identification

 

A short video from Power BI with DAX programming

WHAT IF SCENARIOS

  • Create “What if” parameters
  • Create Dashboard to show effect of parameter variation
  • Create Multiple “What if Parameters”
  • Combine multiple parameters on a Dashboard

Python and R in Power BI

  • Set up Power BI to use Python and R language to create visuals
  • Increase your choice of charts using R in PowerBI
  • Try different visualizations using Python and R

TIME SERIES FORECAST

  • Create forecast based on previous years values using DAX
  • Create projected forecast using Line chart
  • Create projected forecast in ARIMA using Python

KEY FEATURE ANALYSIS

  • Analyse what are the key features that influence your returning customer
  • Analyse what are the key features that influence your employee leaving

COMBINED KPI

  • Visualize combined KPIs
  • Analise the relative variance of combined KPIs
  • Show the single components of the combined KPIs

ERLANG ALGORITM

  • Create a call centre staffing tool to calculate the number of staff required to meet your SLA level

DECISION TREE

  • Analyse whether your employees are prone to leave or not using a decision tree

Apply Advanced Power BI Analytical Techniques

  • Anomaly detection
  • Discover anomalies in your data: unusually high or low records
  • Cluster analysis
  • Outliner detection
  • Cross sell opportunities
  • Pattern recognition
  • Customer segmentation
  • Pareto rule
  • Dynamic ranked list
  • Decomposition tree (see December summary)

TWITTER ANALYSIS

  • Import tweeter feeds
  • Time line visual for twitter posts
  • Word cloud analysis with custom visual
  • Word cloud analysis with Python
  • Life connection stream to tweeter feeds
  • Create sentiment analysis using Azure Cognitive systems
  • Import tweeter feeds
  • Time line visual for twitter posts
  • Word cloud analysis with custom visual
  • Word cloud analysis with Python
  • Life connection stream to tweeter feeds
  • Create sentiment analysis using Azure 
JBI training course London UK

This course is aimed at delegates who feel comfortable using Power BI's basic features and who are looking to take the tool to the next level of Data Analysis and who would also like to get a gentle introduction to Python.


5 star

4.8 out of 5 average

" I enjoyed the depth that we covered analytical techniques such as anomaly detection and  cluster analysis, whilst improving my knowledge on DAX and KPIs. The trainer was informative, patient and kept the training engaging."

BC, Performance analyst, Data Analysis with Power BI, April 2021

Watch live client feedback from Data Analytics courses: 

“JBI  did a great job of customizing their syllabus to suit our business  needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and  the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

JBI training course London UK

Newsletter

 

Sign up for the JBI Training newsletter to stay updated with world-class technology training opportunities, including Analytics, AI, ML, DevOps, Web, Backend and Security. Our Power BI Training Course is especially popular.  Gain new skills, useful tips, and validate your expertise with an industry-leading organisation, all tailored to your schedule and learning preferences.



Our Power BI Data Analysis training course is aimed at delegates who want to get more out of their data using a combination of Power BI's inbuilt tools and simple DAX and Python coding to help with more complex data analysis and predictive modelling tasks.

This is a gentle introduction to Data Analysis and Data Science and should appeal to the more adventurous Power BI users, who need to step up a level, without the need for a formal Data Science background.


The course is a fully hands-on, 100% practical one in which you will test different ways of analysing your data to answer questions like: What are my forecasted sales for next year? Why are employees leaving?  What is the ideal staff number for my call centre? How can I analyse sentiment on Twitter posts?

A simple scenario that may be covered on the course is visually displaying how to predict your profit if sales increase. “What If” parameters allow you to create different scenarios in which you can dynamically change the value of one parameter and see the effect of this change on your measure.

You will compare different methods of creating visuals based on Data Analysis and Machine Learning, R and Python. You will create a visual that explains the key factors that influence your clients to come back... And many other case scenarios.

You can also take a sample of your data (in excel or csv format) and apply algorithms.

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

 

Copyright © 2023 JBI Training. All Rights Reserved.
JB International Training Ltd  -  Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us

POPULAR

Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course