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

Description

[ DevCourseWeb.com ] Sales Forecasting Dashboard Using Looker, Big Query And Sql

If You Need More Stuff, kindly Visit and Support Us -->> 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.

If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com

Get More Tutorials and Support Us -->> https://FreeCourseWeb.com

We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...

File list

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