1-844-696-6465 (US)        +91 77600 44484        help@dezyre.com
cortana-intelligence-suite-workshop.jpg

Analytics Workload using Microsoft Cortana, Azure, Power Shell and Visual Studio

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

Users who bought this project also bought

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
  • HDInsight
  • 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

What will you get

  • Access to recording of the complete project
  • Access to all material related to project like data files, solution files etc.

Project Description

Welcome to the Cortana Intelligence Suite workshop – Azure SQL Data Warehouse Focus delivered by your Microsoft Data Science team. In this workshop, 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.

Modules:

  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

Instructors

 
Chris

Working in the world of Features Engineering in the Data Science team

A highly experienced professional with over 14 years' experience of architecting, designing and implementing Microsoft SQL Server business intelligence projects at an enterprise scale. Significant experience of leading and mentoring both business and technical project stakeholders in maximising investment in business i see more...