EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE


Data Analytics Training Course


Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

Data Analytics training course (code: DATAANALYTICS)

Access Cloud based data and create modern, powerful Dashboards with Power BI, R and AML


SEE MORE COURSES IN THIS CATEGORY

TRAINING COURSE OVERVIEW

Our Data Analytics training course is aimed at looking to model cloud and other corporate data using Power BI Dashboard visualizations and who further want to customise and tweak their data using R and Azure Machine Learning. 

We will look at the modern tools, visualizations, and mobile reporting capabilities that SQL Server 2016 provides on any device

 


AUDIENCE

This course is aimed at those who need to build customised, interactive Dashboards which empower businesses and colleagues to harness the growing amount of data being produced by the business systems in the cloud



DETAILHIGHLIGHTS

 POWER BI SERVICE

                        Self-service BI
                        Organisational BI
                        Portal
                        Content Items
                        Datasets
                        Connecting to Data

VISUALIZING DATA

                        Reports

                        Reading View

                        Editing View

                        Visualisations and Custom Visualisations

                        Dashboards

POWER BI MOBILE

                        Native Applications (iOS/Android/Windows)

                        Viewing Content

                        Sharing & Collaboration

                        Embedding dashboards in applications                          

DATA MODELLING FUNDAMENTALS

                        Data Models

                        Schemas

                        Relationships

                        Connectivity

                        Power BI Desktop

                        Design Environment              

                        Navigation

                        Importing Data

TRANSFORMING DATA

                        Queries & the Query Editor

                        Data Previews

                        Shaping & Cleansing Data

                        Basic Transformations

                        Loading Transformed Data

                        Combining Datasets

                        Functions

                        Date Tables

REFINING THE MODEL

                        Tables & Columns

                        Data View

                        Exploring Data

                        Managing Schema & Data Changes

                        Connections & Tables

                        Data Refresh

                        Relating Tables

                        Rules & Limitations

                        Auto-Detecting

                        Relationship View

CALCULATIONS

                        Data Analysis Expressions

                        Calculated Columns

                        Measures

                        DAX Syntax

                        DAX Functions

                        Advanced Relationships    

R LANGUAGE

INTRODUCTION TO BASICS

Take your first steps with R. Discover the basic data types in R and assign your first variable.

VECTORS

Analyze gambling behaviour using vectors. Create, name and select elements from vectors.

MATRICES

Learn how to work with matrices in R. Do basic computations with them and demonstrate your knowledge by analyzing the Star Wars box office figures.

FACTORS

R stores categorical data in factors. Learn how to create, subset and compare categorical data.

DATA FRAMES

When working R, you’ll probably deal with Data Frames all the time. Therefore, you need to know how to create one, select the most interesting parts of it, and order them.

LISTS

Lists allow you to store components of different types. Section 6 will show you how to deal with lists.

BASIC GRAPHICS

Discover R’s packages to do graphics and create your own data visualizations.

AZURE MACHINE LEARNING


WHAT IS MACHINE LEARNING?

Getting Started
Finding Patterns
Machine Learning essentials
The Main Points

THE MACHINE LEARNING PROCESS

Asking the Right Question
Illustrating the Machine Learning Process
Example Machine Learning Scenarios
The Main Points

A CLOSER LOOK AT THE MACHINE LEARNING PROCESS

Terminology
Data Pre-processing
Categorizing Machine Learning Problems
Styles of Machine Learning Algorithms
Training and Testing a Model
Using a Model

Deploying packages
Scheduling packages with SQL Server Agent
Security

Reporting Services Configuration Manager
Security overview

  • Power BI Service
  • Visualizing Data
  • Power BI Desktop
  • Power BI Cloud
  • Power BI Mobile
  • Data Modelling Fundamentals
  • R language fundamentals
  • Dashboard scripting with R
  • Azure Machine Learning
  • AML for Cloud data
Receive the latest version of this course into your inbox


See why people choose JBI

"At jbi even the sales team are technical so you are able to ask questions before the course"

Garima Aon

Call our Tech Team :  0800 028 6400  request info



PUBLIC COURSES (LONDON, UK)
 

11th Sep 2017 - 4 days £2495 see discount £2246
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


 

 

 

 

Get in touch
0800 028 6400




 

 

view all case studies

 

 

Our inspiring and up-to-date courses gain exceptional feedback

►"great tips to help reduce build times"
► "we got access to exclusive content"
► "intensive course meant less time off"

►"what an inspiring trainer !"
► "colleagues at 2 sites joined via web"
► "I passed my exam the next day"

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