| 1 - Why it is so important to start using predictive analytics for your career.mp4 | 6.8 MB | ||
| 10 - Link to the google spreadsheet.txt | 102.4 B | ||
| 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 | ||
| 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 MB | ||
| 17 - You dont want to have the same date in multiple rows.mp4 | 29.8 MB | ||
| 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 | ||
| 2 - The Solution Overview.mp4 | 95.6 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 | 102.4 B | ||
| 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 | ||
| 29 - Introduction.mp4 | 4.2 MB | ||
| 3 - Is this course for you.mp4 | 14.4 MB | ||
| 30 - Copy the base report.mp4 | 12.3 MB | ||
| 30 - Looker Studio Template.txt | 102.4 B | ||
| 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 | ||
| 4 - Overview Course Content.mp4 | 28.3 MB | ||
| 40 - Dashboard Template How to copy the report.mp4 | 20.7 MB | ||
| 40 - Link to the Report Template.txt | 0 B | ||
| 40 - Person1.png | 415.3 KB | ||
| 40 - Person2.png | 7.6 MB | ||
| 40 - Untitled-design.png | 3.3 MB | ||
| 41 - Power BI Settings and connecting the data.mp4 | 23 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 59 total files | |||
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.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - Sales Funnel Mastery - Transform Leads Into Paying Customers Posted by
freecoursewb in Other
|
926.9 MB | freecoursewb | 23 hours | 10 | 17 |
|
Udemy - Demo like a Pro - Beginners Guide to Software Demos in Sales Posted by
freecoursewb in Other
|
844.6 MB | freecoursewb | 1 week | 18 | 4 |
|
Udemy - Copilot prompts with Excel - Pareto and seasonal sales trends Posted by
freecoursewb in Other
|
3.3 GB | freecoursewb | 2 weeks | 5 | 10 |
| 3.8 GB | freecoursewb | 1 month | 3 | 1 | |
| 1.9 GB | freecoursewb | 2 months | 0 | 0 |
All Comments