EXCEPTIONAL TRAINING FOR DATA PROFESSIONALS

Power BI Data Analysis Training Course

Analyse and present your data using Power BI and Python - A first step into Data Science

NEXT COURSE
1 Jul London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

Power BI Data Analysis training course (code: POWERBIDATA)

TRAINING COURSE OVERVIEW

Our Power BI Data Analysis training course is aimed at delegates who are looking 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 fully hands-on, 100% practical course in which you will test different way of analysing your data to answer questions like: what are my forecasted sales for next year? Why are employee leaving?  What is the ideal staff number for my call centre? How can analyse sentiment on twitter post?

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 you what are the key factors that influence your clients to come back …. And many other case scenarios.

You can take a sample of your data (excel or csv format) and try applying the algorithm to your data.

 

 

AUDIENCE

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.


CONTENT

DETAILHIGHLIGHTS


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

Create What if Parameter table

Compare Dashboard with multiple parameters and Dashboard with Parameter table


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

 

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

 

WHAT IF SCENARIOS
TIME SERIES FORECAST
KEY FEATURE ANALYSIS
COMBINED KPI
ERLANG ALGORITM
DECISION TREE
  • TWITTER ANALYSYS

UPDATES
Receive the latest version of this course into your inbox



LONDON COURSES
- INCLUDES LUNCH -

1st Jul 2019 - 2 days £1495
Book

see all dates


X

Show Discount for this course


PRIVATE COURSES


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400
or request quote


  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote


CONTACT
0800 028 6400



Why JBI ?

►"great technology tips"
► "Access to exclusive content"
► "Short course means less time off"

►"Inspiring trainers"
► "Joined via web"
► "Knowledgable sales staff"

NEWSLETTER
Get exclusive news about upcoming programs, technical insights & special offers