Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Python
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Data Modeling with SQL Business Intelligence Semantic Model (BISM) Tabular
Overview

This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.

At Course Completion

  • Understand what machine learning is.
  • Understand the differences between supervised and unsupervised methods.
  • Understand the analytics spectrum.
  • Understand the development methodology.
  • Understand and utilize the Azure Machine Learning Studio interface.
  • Understand and utilize tools for cleaning.
  • Understand the differences between text files and binary files.
  • Understand structures of data.
  • Understand and utilize steps for data cleaning.
  • Understand and utilize feature selection.
  • Understand feature engineering.
  • Understand and utilize regression.
  • Understand and utilize classification.
  • Understand and utilize clustering.
  • Understand anomaly detection.
  • Understand and utilize the Azure Machine Learning Cheat Sheet.
  • Understand and utilize visualizations.
  • Understand data acquisition.
  • Understand data preparation.
  • Understand feature selection.
  • Understand and utilize Train Data.
  • Understand cross validation and comparing regressions.
  • Evaluate solutions and learn from examples.
  • Understand and utilize regression algorithms.
  • Understand and utilize classification algorithms.
  • Understand and utilize clustering algorithms.
  • Understand utilize joined datasets.
  • Understand and utilize Power BI.
Prerequisites

Before attending this course, students must have:
  • A working knowledge of SQL Server
Target Student

The course is targeted towards business analysts, business intelligence developers, and SQL Professionals.

Course duration

2 Days

Course outline

Module 1: Course Overview


This module explains how the class will be structured and introduces course materials and additional administrative information.

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing

Lab 1: Course Overview

  • Creating Your Azure Machine Learning Account

After completing this module, students will be able to:

  • Successfully log into their virtual machine.
  • Have a full understanding of what the course intends to cover.

Module 2: What is Machine Learning?


In this module, we will explain machine learning and the concepts behind it.

  • Introduction
  • One Methodology
  • Supervised vs. Unsupervised Methods
  • Analytics Spectrum
  • Development Methodology with Azure Machine Learning Studio
  • Be Very Vigilant

Lab 1: What is Machine Learning?

  • None

After completing this module, students will be able to:

  • Understand what machine learning is.
  • Understand the differences between supervised and unsupervised methods.
  • Understand the analytics spectrum.
  • Understand the development methodology.

Module 3: Introduction to Azure Machine Learning Studio


In this module, we will explore the Azure Machine Learning Studio interface and walk through the options available.

  • Experiments
  • Web Services
  • Notebooks
  • Datasets
  • Trained Models
  • Settings
  • Walkthrough Exercise and Group Discussions

Lab 1: Introduction to Azure Machine Learning Studio

  • Group Walkthrough Exercise and Discussion: Introduction to Azure Machine Learning Studio
  • Individual Exercise: Introduction to Azure Machine Learning Studio

After completing this module, students will be able to:

  • Understand and utilize the Azure Machine Learning Studio interface.

Module 4: Data Preperation


In this module, we will cover the steps necessary for data cleaning and explore other data preparation techniques.

  • Tools for Cleaning
  • Text Files vs. Binary Files
  • Structures of Data
  • Steps for Data Cleaning
  • Common Cleaning Tasks
  • Feature Selection
  • Feature Engineering
  • Group Discussion

Lab 1: Data Preparation

  • Group Exercise: Statistical Visualizations
  • Individual Exercise: Remove Duplicate Rows
  • Individual Exercise: Clipping Outliers
  • Individual Exercise: Feature Imbalance
  • Individual Exercise: Feature Selection

After completing this module, students will be able to:

  • Understand and utilize tools for cleaning.
  • Understand the differences between text files and binary files.
  • Understand structures of data.
  • Understand and utilize steps for data cleaning.
  • Understand and utilize feature selection.
  • Understand feature engineering.

Module 5: Machine Learning Algorithms


In this module, we will explain the different types of algorithms available and their uses.

  • Regression
  • Classification
  • Clustering
  • Anomaly Detection
  • Azure Machine Learning Cheat Sheet
  • Visualizations
  • Group Discussion and Exercises

Lab 1: Machine Learning Algorithms

  • Group Exercise: Azure Machine Learning Cheat Sheet
  • Group Exercise: Binary Classification Model
  • Group Exercise: Split Data
  • Group Exercise: Unbalanced Datasets
  • Group Exercise: Classification Using Multivariate
  • Group Exercise: Visualize a Clustering Model

After completing this module, students will be able to:

  • Understand and utilize regression.
  • Understand and utilize classification.
  • Understand and utilize clustering.
  • Understand anomaly detection.
  • Understand and utilize the Azure Machine Learning Cheat Sheet.
  • Understand and utilize visualizations.

Module 6: Building Models - Exercises


In this module, we explore the topic of customer propensity (inclinations and tendencies) and how to use Machine Learning to help with this common business question. This is an exercise module which contains both instructor-led and individual exercises.

  • Group Discussion 1: Data Acquisition
  • Group Discussion 2: Data Preparation
  • Group Discussion 3: Feature Selection
  • Group Discussion 4: Train Data
  • Group Discussion 5: Cross Validation and Comparing Regressions
  • Group Discussion 6: Results
  • Group Discussion: Evaluate the Solutions – Learn from Examples

Lab 1: Building Models - Exercises

  • Group Exercise and Discussion: Data Acquisition
  • Group Exercise and Discussion: Data Preparation
  • Group Exercise and Discussion: Feature Selection
  • Group Exercise and Discussion: Train Data
  • Group Exercise and Discussion: Cross Validation and Comparing Regressions
  • Individual Exercise: Regression
  • Individual Exercise: Classification
  • Individual Exercise: Clustering

After completing this module, students will be able to:

  • Understand data acquisition.
  • Understand data preparation.
  • Understand feature selection.
  • Understand and utilize Train Data.
  • Understand cross validation and comparing regressions.
  • Evaluate solutions and learn from examples.
  • Understand and utilize regression algorithms.
  • Understand and utilize classification algorithms.
  • Understand and utilize clustering algorithms.

Module 7: Visualizing Analytical Models with Power BI


In this module, we will explore the visualizations and options available using Power BI.

  • What is Power BI?
  • Creating a Power BI Account
  • Deploying to Power BI
  • Visualizations

Lab 1: Visualizing Analytical Models with Power BI

  • Individual Exercise: Join Datasets
  • Individual Exercise: Power BI

After completing this module, students will be able to:

  • Understand utilize joined datasets.
  • Understand and utilize Power BI.



Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved