Microsoft Cortana Intelligence Suite Analytics Workshop

Microsoft Cortana Intelligence Suite Analytics Workshop

In this big data project, we'll work through a real-world scenario using the Cortana Intelligence Suite tools, including the Microsoft Azure Portal, PowerShell, and Visual Studio.
explanation image


Each project comes with 2-5 hours of micro-videos explaining the solution.

ipython image

Code & Dataset

Get access to 50+ solved projects with iPython notebooks and datasets.

project experience

Project Experience

Add project experience to your Linkedin/Github profiles.

Customer Love

Read All Reviews
profile image

Camille St. Omer linkedin profile url

Artificial Intelligence Researcher, Quora 'Most Viewed Writer in 'Data Mining'

I came to the platform with no experience and now I am knowledgeable in Machine Learning with Python. No easy thing I must say, the sessions are challenging and go to the depths. I looked at graduate... Read More

profile image

James Peebles linkedin profile url

Data Analytics Leader, IQVIA

This is one of the best of investments you can make with regards to career progression and growth in technological knowledge. I was pointed in this direction by a mentor in the IT world who I highly... Read More

What will you learn

The Data Science Process
CIS Platform components
Administration concepts
Tools installation and overview
PowerShell Interface
Cortana Intelligence Process
Cortana Intelligence Suite Platform
Azure Data Catalog
Azure Data Factory
Azure Platform as a Services Capabilities
Azure Portal
Azure SQL Data Warehouse
Azure SQL Data Warehouse Table Geometries
Azure Storage
ADC Interface
Visual Studio Interface (and RTVS)
Massively Parallel Processing
Colunmstore Indexing
PolyBase and Windows Azure Blob Storage
SQL Server Management Studio
Techniques for discovery

Project Description

Welcome to the Cortana Intelligence Suite workshop – Azure SQL Data Warehouse Focus delivered by your Microsoft Data Science team. In this big data project, you’ll cover a series of modules that guide you from understanding an analytics workload, the Cortana Intelligence Suite Process, Massive Parallel Processing and loading a data warehouse using various tools. You’ll also learn how to work through a real-world scenario using the Cortana Intelligence Suite tools, including the Microsoft Azure Portal, PowerShell, and Visual Studio, among others.


  1. CIS overview and how Azure SQL Data Warehouse fits into CIS
  2. Introduction to Azure SQL Data Warehouse
  3. Working with Tables, Indexes, and Statistics
  4. Loading data into Azure SQL Data Warehouse
  5. Managing Security and Administration.
  6. Workshop recap (Extended Class)

Skills taught:

  1. Understand the CIS Process (General level), Understand CIS Components (General Level), set up and configure the development environment
  2. Understand how to create an Azure SQL Data Warehouse using various tools.
  3. Understand SQL Data Warehouse and its constructs, Implement loading activities into Azure SQL Data Warehouse.
  4. Manage the security and administration of an Azure SQL Data Warehouse

Similar Projects

Explore hive usage efficiently in this hadoop hive project using various file formats such as JSON, CSV, ORC, AVRO and compare their relative performances

In this project, we will look at two database platforms - MongoDB and Cassandra and look at the philosophical difference in how these databases work and perform analytical queries.

In this big data project, we will be performing an OLAP cube design using AdventureWorks database. The deliverable for this session will be to design a cube, build and implement it using Kylin, query the cube and even connect familiar tools (like Excel) with our new cube.

Curriculum For This Mini Project

03h 55m