Sales Forecasting Dashboard using Looker, Big Query and SQL

Course Curriculum

Chapter 1: Before we start – Prerequisites

Lecture 1: Why it is so important to start using predictive analytics for your career!

Lecture 2: The Solution – Overview

Lecture 3: Is this course for you?

Lecture 4: Overview Course Content

Lecture 5: Can you do this course without prior knowledge?

Lecture 6: Why in a real world example time series forecasting based on M-Learning fails?

Chapter 2: Set up Google Big Query

Lecture 1: Google Cloud/ Big Query – Account Setup and why it´s free

Lecture 2: Google Cloud and navigating to Google Big Query

Lecture 3: Overview Google Big Query and creating the dataset

Chapter 3: Example Dataset and loading the data into Google Big Query

Lecture 1: Overview and access the data

Lecture 2: Overview example data that we want to forecast

Lecture 3: Why a separate dim_date table is needed?

Lecture 4: Loading the data into Google Big Query

Chapter 4: Basic SQL Concepts

Lecture 1: Introduction

Lecture 2: Basic SQL Query

Lecture 3: Group/ Aggregate costs by date [Important for your own data]

Lecture 4: You don´t want to have the same date in multiple rows

Chapter 5: The SQL – Forecast Query

Lecture 1: What the Query will do, explained in Google Sheets (I)

Lecture 2: What the Query will do, explained in Google Sheets (II)

Lecture 3: The Forecast Query in Google Big Query

Lecture 4: How to make the Forecast Query work (changes you need to make)

Lecture 5: Running the query and explain the result

Lecture 6: Save the query as a view in Google Big Query

Lecture 7: Connect the forecast view to looker studio and take a first look

Lecture 8: Explore the data and create a calculated field

Lecture 9: Create all forecasts, add a budget line, change designs

Lecture 10: Final thoughts on the forecast model and recommendation on usage

Lecture 11: Create all the other forecasts in SQL (sales, sales_volume,…)

Chapter 6: Creating the Forecast Dashboard in Looker Studio

Lecture 1: Introduction

Lecture 2: Copy the base report

Lecture 3: Creating the first Page [Manager View] and adding a data source

Lecture 4: Review of the first page and general dashboard design overview

Lecture 5: Second Page (1) – Goal Tracking – Scribble

Lecture 6: Second Page (2) – Goal Tracking – Start

Lecture 7: Second Page (2) – Goal Tracking – Add the data

Lecture 8: Second Page (3) – Goal Tracking – Actual and Goal – Visualization Options

Lecture 9: Second Page (4) – Goal Tracking – Complete the First Forecast Model

Lecture 10: Second Page (5) – Goal Tracking – Complete the second Forecast Model

Lecture 11: Second Page (6) – Goal Tracking – Finalizing

Lecture 12: Dashboard Template – How to copy the report

Chapter 7: How to create the Dashboard in Microsoft Power BI

Lecture 1: Power BI Settings and connecting the data

Lecture 2: Power BI Explore the data and creating a line chart

Lecture 3: Power BI Creating the running sum measures

Lecture 4: Power BI Finalizing

Chapter 8: How to create the forecast dashboard with your own data?

Lecture 1: Introduction

Lecture 2: Tips on how to load your own data into Google Big Query

Lecture 3: How to modify your data to make the query work – recap of other lectures.