Udemy - Sales Forecasting Dashboard Using Looker, Big Query And Sql

seeders: 5
leechers: 10
updated:
Added by freecoursewb in Other > Tutorials

Download Fast Safe Anonymous
movies, software, shows...

Files

[ DevCourseWeb.com ] Udemy - Sales Forecasting Dashboard Using Looker, Big Query And Sql
  • Get Bonus Downloads Here.url (0.2 KB)
  • ~Get Your Files Here ! 1 - Before we start Prerequisites
    • 1 - Why it is so important to start using predictive analytics for your career.mp4 (6.8 MB)
    • 2 - The Solution Overview.mp4 (95.6 MB)
    • 3 - Is this course for you.mp4 (14.4 MB)
    • 4 - Overview Course Content.mp4 (28.3 MB)
    • 5 - Can you do this course without prior knowledge.mp4 (74.2 MB)
    • 6 - Why in a real world example time series forecasting based on MLearning fails.mp4 (27.3 MB)
    2 - Set up Google Big Query
    • 7 - Google Cloud Big Query Account Setup and why its free.mp4 (11.9 MB)
    • 8 - Google Cloud and navigating to Google Big Query.mp4 (18.4 MB)
    • 9 - Overview Google Big Query and creating the dataset.mp4 (82.2 MB)
    3 - Example Dataset and loading the data into Google Big Query
    • 10 - Link to the google spreadsheet.txt (0.1 KB)
    • 10 - Overview and access the data.mp4 (6.7 MB)
    • 11 - Overview example data that we want to forecast.mp4 (31.6 MB)
    • 12 - Why a separate dimdate table is needed.mp4 (12.1 MB)
    • 13 - Loading the data into Google Big Query.mp4 (190.6 MB)
    4 - Basic SQL Concepts
    • 14 - Introduction.mp4 (4.9 MB)
    • 15 - Basic SQL Query.mp4 (69.5 MB)
    • 16 - Group Aggregate costs by date Important for your own data.mp4 (47.0 MB)
    • 17 - You dont want to have the same date in multiple rows.mp4 (29.8 MB)
    5 - The SQL Forecast Query
    • 18 - What the Query will do explained in Google Sheets I.mp4 (43.6 MB)
    • 19 - What the Query will do explained in Google Sheets II.mp4 (10.1 MB)
    • 20 - Forecast-Model-SQL-with-latest-data-yesterday.txt (2.6 KB)
    • 20 - The Forecast Query in Google Big Query.mp4 (27.7 MB)
    • 21 - Forecast-Model-SQL-with-latest-data-yesterday.txt (2.6 KB)
    • 21 - How to make the Forecast Query work changes you need to make.mp4 (28.9 MB)
    • 22 - Running the query and explain the result.mp4 (54.9 MB)
    • 23 - Save the query as a view in Google Big Query.mp4 (39.9 MB)
    • 24 - Connect the forecast view to looker studio and take a first look.mp4 (28.6 MB)
    • 25 - Explore the data and create a calculated field.mp4 (46.5 MB)
    • 25 - Forecast-Model-data-studio-formula.txt (0.1 KB)
    • 26 - Create all forecasts add a budget line change designs.mp4 (74.5 MB)
    • 27 - Final thoughts on the forecast model and recommendation on usage.mp4 (41.2 MB)
    • 28 - Create all the other forecasts in SQL sales salesvolume.mp4 (413.7 MB)
    6 - Creating the Forecast Dashboard in Looker Studio
    • 29 - Introduction.mp4 (4.2 MB)
    • 30 - Copy the base report.mp4 (12.3 MB)
    • 30 - Looker Studio Template.txt (0.1 KB)
    • 31 - Creating the first Page Manager View and adding a data source.mp4 (106.2 MB)
    • 32 - Review of the first page and general dashboard design overview.mp4 (37.1 MB)
    • 33 - Second Page 1 Goal Tracking Scribble.mp4 (9.3 MB)
    • 34 - Second Page 2 Goal Tracking Start.mp4 (17.4 MB)
    • 35 - Second Page 2 Goal Tracking Add the data.mp4 (52.7 MB)
    • 36 - Second Page 3 Goal Tracking Actual and Goal Visualization Options.mp4 (72.8 MB)
    • 37 - Second Page 4 Goal Tracking Complete the First Forecast Model.mp4 (102.7 MB)
    • 38 - Second Page 5 Goal Tracking Complete the second Forecast Model.mp4 (35.1 MB)
    • 39 - Second Page 6 Goal Tracking Finalizing.mp4 (27.5 MB)
    • 40 - Dashboard Template How to copy the report.mp4 (20.7 MB)
    • 40 - Link to the Report Template.txt (0.0 KB)
    • 40 - Person1.png (415.3 KB)
    • 40 - Person2.png (7.6 MB)
    • 40 - Untitled-design.png (3.3 MB)
    7 - How to create the Dashboard in Microsoft Power BI
    • 41 - Power BI Settings and connecting the data.mp4 (23.0 MB)
    • 42 - Power BI Explore the data and creating a line chart.mp4 (20.3 MB)
    • 43 - Power BI Creating the running sum measures.mp4 (28.1 MB)
    • 44 - Forecast-Dashboard-Power-BI.pbix (53.2 KB)
    • 44 - Power BI Finalizing.mp4 (53.6 MB)
    8 - How to create the forecast dashboard with your own data
    • 45 - Introduction.mp4 (8.3 MB)
    • 46 - Tips on how to load your own data into Google Big Query.mp4 (25.9 MB)
    • 47 - How to modify your data to make the query work recap of other lectures.mp4 (26.9 MB)
    • Bonus Resources.txt (0.4 KB)

Description

Sales Forecasting Dashboard Using Looker, Big Query And Sql

https://DevCourseWeb.com

Published 1/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.20 GB | Duration: 3h 36m

Create a real world sales-/ marketing forecast model and a goal tracking report that works with minimum data history.

What you'll learn
How to create a real world sales forecasting dashboard.
Learn how to create a simple forecasting model using rolling averages in Google Big Query SQL.
Get familiar with Google Big Query
Learn advanced techniques in Looker Studio and Power BI to visualize your forecast

Requirements
Beginner level knowledge in looker studio, creating dashboards, excel is recommended.
No SQL coding experience is needed, i will show you how to use the code without prior knowledge.
To create a Google Cloud Project you need A CREDIT- or DEBIT CARD. You will NOT encounter any charges and be in the FREE Tier of Google Cloud.



Download torrent
2.2 GB
seeders:5
leechers:10
Udemy - Sales Forecasting Dashboard Using Looker, Big Query And Sql


Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
2.2 GB
seeders:5
leechers:10
Udemy - Sales Forecasting Dashboard Using Looker, Big Query And Sql


Torrent hash: EA8EFB2561F753A7AB3F7A2A595020C2289E98B6