£469

Advanced Analytics with Microsoft Tools

Event Information

Share this event

Date and Time

Location

Location

London

London

United Kingdom

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Friends Who Are Going
Event description

Description

Type: Workshop

Level: Intermediate

Duration: 1 Day

This pre-con is to do advanced analytics with Microsoft Tools SQL Server 2017, Program R, Azure Machine Learning and Power BI. We will be covering the main components of Analytical Tools explaining the architecture of SQL Server 2016 for Analytics and also the latest Features in SQL Server 2017.

Learning

  • Describe the components for Analytical Tools
  • Explaining the architecture of SQL Server 2016 for Analytics
  • Explaining the latest Features in SQL Server 2017
  • How to use R in Power BI
  • R Script & R Visuals in Power BI
  • Machine Learning Models in Azure
  • Explaining Azure Machine Learning
  • Advanced Analytics with Microsoft Tool

Course Information

Modules

Module 1 – Introduction to Microsoft Analytical Tools

  1. Microsoft SQL Server 2017 & 2016 Architecture
  2. Understanding Database Objects like Stored Procedures and etc.
  3. Basic Understanding of R
  4. Basics on Microsoft Power BI
  5. Microsoft Azure Machine Learning

Module 2 – Microsoft SQL Server

  1. R Server and R Database
  2. Exploring SQL Server 2016 & 2017 Features
  3. R Engine inside SQL Server
  4. Building Analytical Models in SQL Server
  5. Visualizations on Analytical Models

Module 3 – R

  1. Architecture
  2. Exploring with R Studio
  3. R Language – Functions, Loops, Conditions etc.
  4. Building Analytical Models
  5. R Visualizations

Module 4 – Microsoft Power BI

  1. Introduction to Power BI
  2. R Connectors
  3. R Script in Data Modelling
  4. R Custom Visuals
  5. Advanced Models in Power BI R

Module 5 – Azure ML

  1. Basic Concepts of Azure
  2. Exploring Azure ML Studio
  3. Using R Scripts inside ML Studio
  4. Building Models
  5. Evaluate and Train Model
  6. Azure ML Models Web Service

Pre-Requisites

  1. Data Professionals with basic understanding of database
  2. Any data professional with statistical knowledge is a plus

Demos

  • Configuring R Server and Database for SQL Server 2016 & 2017
  • Exploring R Studio and Microsoft R Open
  • Writing basic program in R
  • Building Models & visuals in R studio
  • Exploring SQL Server Management Studio in specific to R
  • Running R Models inside SQL Server Management Studio
  • Exploring Azure ML
  • Working with different algorithms in Azure ML and how to use them for predictive, descriptive and prescriptive analysis
  • Evaluating created model and export as web service
  • R Algorithms like decision tree, linear model, regression and etc.
  • R integration with Power BI
  • Running R Scripts in Power BI Desktop
  • R virtualization in Power BI

Course Material

Printed Material will be provided.

EVENT Location will be updated 1 week prior to the Workshop date.

Contact us for any issues and custom workshops for your location, info@dageop.com
Share with friends

Date and Time

Location

London

London

United Kingdom

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved