Understand your customer

Profiling, Segmentation, Targeting and Recommendation using Microsoft Azure ML, SQL, Power BI

  • What Will I Learn?

    Prepare data using SQL Understand the main conceptions of classification models Construct a customer dashboard using Power BI Create a segmentation model using SQL Build a targeting model using Azure ML Build a recommendation system using Azure ML

  • The course is for you if

    you have solid business knowledge as Business Analyst, Marketer, manager or analytical mindset regardless in which department you have been working

  • This course may not be for you if

    you are looking for an in-depth discussion of the deeper mathematical and statistical theories behind the data science algorithms.

Pricing options

Description

Throughout the course, you will learn the basics concepts in order to understand and apply advanced analytics.

You will engage in 5 hands-on labs for creating advanced models.

Because our goal is to get you up to speed as quickly as possible, we’ll cover through the 30 lectures,

You will learn the main concepts of data science such as Data mining Process, Machine learning, and classification model.

You will be introduced to a Marketing framework analysis based on 4 elements: Explore, Segment, Target and Recommend.

You will learn the basics of three tools: SQL, Power BI, and Microsoft Azure ML.

You will be able to test and practice all these skills through 5 Quizzes and 5 hands-on Labs: Data Preparation using SQL, Customer Dashboard using POWER BI, managerial segmentation with SQL, targeting and recommendation models using Microsoft Azure ML Studio.

The ultimate course purpose is to unleash the potential of data science for your career and your organization

Course curriculum

  • 1

    Welcome to the course!

    • How to use this course

    • A message from the instructor

    • Before we begin...

  • 2

    Introduction

    • Set the expectations

    • Introduction : Citizen Data Scientist

  • 3

    Lay the foundation

    • Introduction

    • Definitions

    • Data Science Process

    • Data Science Toolbox

    • Setup the Lab Environment : Tools & Data

    • Microsoft Azure Machine Learning

    • Marketing Framework Analysis

    • Quiz 1

  • 4

    Explore

    • Introduction

    • Case study : Adventure Works

    • SQL Basics

    • Install Adventure Works Database

    • Lab 1 : Data preparation using SQL

    • Lab 2 : Customer Dashboard using Power BI

    • Quiz 2

  • 5

    Segment

    • Introduction

    • Types of segmentation

    • Managerial Segmentation

    • Lab 3 : Managerial segmentation using SQL

  • 6

    Target

    • Introduction

    • Classification Model : the Basics

    • Classification fundamental concept : Bias-Variance Tradeoff

    • Overview Diagram of Azure Machine Learning Studio

    • Lab 4 : Bike Buyers targeting using Azure ML - Part 1

    • Lab 4 : Bike Buyers targeting using Azure ML - Part 2

    • Quiz 4

  • 7

    Recommend

    • Introduction

    • Recommendation System: Definition and types

    • Recommendation System: How it works

    • Lab 5 : Next Best Offer using Azure ML - Part 1

    • Lab 5 : Next Best Offer using Azure ML - Part 2

  • 8

    Conclusion

    • Wrap up

    • Before you go...

Take your skills to the next level

Instructor(s)

Mohamed Jendoubi

Fondateur d'Uluumy, Expert en IA

Notre mission est de démocratiser l’IA. Je cumule plus de 10 ans d’expérience en analytique avancées. J’ai une maîtrise en intelligence d’affaires de HEC Montréal et un Master Spécialisé en Ingénierie des Systèmes Informatiques Communicants de la grande école d’ingénieurs IMT Atlantique. Je suis un adepte de l’apprentissage tout au long de la vie.