17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Udemy - Sales Forecasting Dashboard Using Looker, Big Query And Sql
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
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...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~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
