CHA0011_Advanced Analytics with Microsoft Tools

ByDr. SubraMANI Paramasivam

CHA0011_Advanced Analytics with Microsoft Tools





Intermediate CHA0011 1 Day $ 250


  • 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


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


  • The core functionality of Azure ML and how to set it up, components in Azure ML, how to work with different algorithms in Azure ML and how to use them for predictive, descriptive and prescriptive analysis, how to evaluate created model and analysis, how to create web service.
  • The basic of R language, Main data structure in R, Exploring and Understanding Data in R, different R packages, some main concept of statistics.
  • R Algorithms like decision tree, linear model, regression and etc
    R integration (Power BI, SQL Server): setup R in Power Bi and SQL Server, R visualization in Power BI, predictive analysis in SQL Server 2016, Azure ML with R


Module 1 – Introduction to Microsoft Analytical Tools

  1. Microsoft SQL Server 2017 & 2016
  2. Basic Understanding of R & Python
  3. Microsoft Power BI with R
  4. Microsoft Azure Machine Learning

Module 2 – Microsoft SQL Server

  1. R Server and R Database
  2. Python in SQL Server 2017
  3. Analytical Models in SQL Server
  4. Visualizations on Analytical Models

Module 3 – R & Python

  1. Architecture
  2. R Language – Functions, Loops, Conditions etc.
  3. Python Language
  4. Analytical Models

Module 4 – Microsoft Power BI

  1. Introduction to Power BI
  2. R Script & R Visuals
  3. R Custom Visuals
  4. Advanced Models in Power BI R

Contact us for any issues and custom workshops for your location,