# Tableau Training Important Links

[USA Superstore Excel File for Offline Challenges (All Weeks)](https://docs.google.com/spreadsheets/d/1MKS2OKoBc-FJ1D34jYSbYKfWBV1COnoG/edit?usp=drive_link&ouid=100081933013190532820&rtpof=true&sd=true)

---

# Week 1

[Week 1 Demo Dashboard](https://public.tableau.com/profile/shashank2918#!/vizhome/CS1_16083065027160/Theory)

[CSV Data File for Week 1](https://drive.google.com/file/d/1MaC1ytssBU65LjrYV-GocX3dyo88bYRh/view?usp=sharing)

[Offline Challenge for Week 1](https://public.tableau.com/profile/shashank2918#!/vizhome/HM1_Sales_USA/SalesDashboardforUSA)

*Additional Reading/Learning:*
* [YouTube Video - Understanding Histogram](https://www.youtube.com/watch?v=gSEYtAjuZ-Y)
* [YouTube Video - Descriptive Stats](https://www.youtube.com/watch?v=E4HAYd0QnRc)
* [YouTube Video - Descriptive Stats](https://www.youtube.com/watch?v=mk8tOD0t8M0)
* [YouTube Video - Box Plots](https://www.youtube.com/watch?v=mhaGAaL6Abw)
* [PDF - Descriptive Stats detailed reading](https://www.sydney.edu.au/content/dam/students/documents/mathematics-learning-centre/introduction-to-descriptive-statistics.pdf)
* [Chart Selection](https://infoinspired.com/wp-content/uploads/2017/08/chart-selection-tool.jpg)
* [Stephen Few Whitepapers on Viz best practices](http://www.perceptualedge.com/library.php#Whitepapers)

---

# Week 2

[Week 2 Demo Dashboard](https://public.tableau.com/profile/shashank2918#!/vizhome/CS2_StockMarketAnalysis_15994150337090/Dashboard1)

[In Class CSV Files](https://drive.google.com/drive/folders/1yUQqaSNxKzEkgUyrPdN7dZKAIjysx5am?usp=sharing)

[BSE Stock Data (for later use if needed)](https://www.bseindia.com/markets/equity/EQReports/StockPrcHistori.aspx?flag=0)

[Company Logos](https://drive.google.com/drive/folders/1bsdxX852gsEV-n_6D8Km8pJ2UlKVOoM7?usp=sharing)

[Offline Challenge for Week 2](https://public.tableau.com/profile/shashank2918#!/vizhome/HW2TrendandDistUSA/Dashboard1)

*Additional Reading/Learning:*
* [YouTube Video - Tableau Layout Containers](https://www.youtube.com/watch?v=96371LvULXM)
* [YouTube Video - The 12 Dates (tips) of Tableau](https://www.youtube.com/watch?v=wa2gDlG8Xao)
* [YouTube Video - Different Filtering Types for Different Effects](https://www.youtube.com/watch?v=tT5TFyoJ-XA)
* [YouTube Video - Grouping in Tableau](https://www.youtube.com/watch?v=UAPH5W9Pq90)

---

# Week 3

[Week 3 Demo Dashboard](https://public.tableau.com/profile/shashank2918#!/vizhome/Covid19_15981322501020/Topicsthisweek)

[Covid Data](https://drive.google.com/file/d/1jrh6XWuxD8hmEL4Gy5L0oQYRfqpUPQeM/view?usp=sharing)

[World Bank Data](https://docs.google.com/spreadsheets/d/13tRnCMXgltFI35mHZMB5XGqw3e_Telmd/edit?usp=sharing&ouid=100081933013190532820&rtpof=true&sd=true)

[John Hopkins Github Daily Data (for later use if needed)](https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data/csse_covid_19_daily_reports)

[Calculation Demo Raw Data (for later use if needed)](https://drive.google.com/file/d/1oFw125R41fww6jfHJClGip8wHOixUm0C/view?usp=sharing)

[Offline Challenge for Week 3](https://public.tableau.com/profile/shashank2918#!/vizhome/HW3_NonReturnedOrders/USASalesExcludingreturnedorders)

[Download Tableau Desktop by Versions](https://www.tableau.com/support/releases)

[Download Tableau Prep](https://www.tableau.com/products/prep/download)

*Additional Reading/Learning:*
* [YouTube Video - A Beginner's Guide to Maps](https://www.youtube.com/watch?v=bnmQCF3t6q0)
* [YouTube Video - Relationships, Joins and Unions in Tableau](https://www.youtube.com/watch?v=EL1m1akHhC4)
* [YouTube Video - Tableau Actions](https://www.youtube.com/watch?v=jdpnOaZM31Y)
* [YouTube Video - Learn Tableau Basic Calculations ](https://www.youtube.com/watch?v=QimVQl5AoYM)
* [YouTube Video - LoD Calculations 1 ](https://www.youtube.com/watch?v=IvZd1L9zWxo)
* [YouTube Video - LoD Calculations 2 ](https://www.youtube.com/watch?v=4e8XTYCZQD8)
* [YouTube Video - LoD Calculations 3 ](https://www.youtube.com/watch?v=N5cmVwnG7nE)
* [YouTube Video - LoD Calculations 4 ](https://www.youtube.com/watch?v=iJrFNcLeYvk)
* [YouTube Video - LoD Calculations 5 ](https://www.youtube.com/watch?v=bRNi5ehIm2Q)

---

# Week 4

[Week 4 Demo Dashboard](https://public.tableau.com/profile/shashank2918#!/vizhome/CS4_TableauDesktop/Topics?publish=yes)

[SQL for Tableau](https://www.flerlagetwins.com/2018/09/sql-part1.html)

[Tableau Prep Offline Challenge](https://drive.google.com/drive/folders/1-2ODBi7FtEItHFnWUUHJ1Wl0xs6vHXl1?usp=sharing)

*Additional Reading/Learning:*
* [YouTube Video - Tableau Prep Complete Tutorial Basic to Advanced](https://www.youtube.com/watch?v=sVf5O6-zNEY)
* [YouTube Video - 50 charts in 50 minutes](https://www.youtube.com/watch?v=6eXdGJCQ7Oc)
* [YouTube Video - Tips & Tricks Charts Edition](https://www.youtube.com/watch?v=S5QN-fK2-wU)
* [YouTube Video - Alteryx](https://www.youtube.com/watch?v=YISWJ-G7Zt4)

---

# Week 5

[Super Store Hyper File](https://drive.google.com/file/d/1TazLhON9iDKP2RMSvF6YEJ88b_5d9oRD/view?usp=sharing)

[Top 10 Batsman](https://docs.google.com/spreadsheets/d/1ruMaA9soh7NgZMVqDkxafl-1DaQSmK_q/edit?usp=sharing&ouid=100081933013190532820&rtpof=true&sd=true)

[Tableau Online - Sign up and login](https://sso.online.tableau.com/public/idp/SSO)

[TWBX file for uploading in Tableau Online](https://drive.google.com/file/d/1-HLToRfgm5jkAI0ivpNS85JjR7YcEOEr/view?usp=sharing)

[Install base R](https://cran.r-project.org/)

[Install R Studio (only after you install base R)](https://rstudio.com/products/rstudio/download/#download)

*Additional Reading/Learning:*
* [Benefits of Tableau Server](https://insightwhale.com/what-is-tableau-server-benefits-for-it-projects/)
* [Documentary - The Secret Rules of Modern Living Algorithms](https://www.youtube.com/watch?v=kiFfp-HAu64)
* [YouTube Video - Introduction to Clustering and K-means Algorithm](https://www.youtube.com/watch?v=7Qv0cmJ6FsI)
* [YouTube Video - StatQuest: K-means clustering](https://www.youtube.com/watch?v=4b5d3muPQmA)
* [YouTube Video - K-means clustering: how it works](https://www.youtube.com/watch?v=_aWzGGNrcic)
* [YouTube Video - Linear Regression Fun and Easy Machine Learning](https://www.youtube.com/watch?v=CtKeHnfK5uA)
* [YouTube Video - Simple Regression](https://www.youtube.com/watch?v=SYY_BPciXPw)
* [YouTube Video - Statistics 101: Linear Regression, The Very Basics](https://www.youtube.com/watch?v=ZkjP5RJLQF4)
* [YouTube Video - Introducing Time Series Analysis and forecasting](https://www.youtube.com/watch?v=GUq_tO2BjaU)
* [YouTube Video - Introduction to Forecasting](https://www.youtube.com/watch?v=98K7AG32qv8)
* [YouTube Video - R Programming for Beginners](https://www.youtube.com/watch?v=BvKETZ6kr9Q)

Silicon Valley TV Show (requires paid subscription):
[Watch on HBO](https://www.hbo.com/silicon-valley)
[Watch on Hotstar](https://www.hotstar.com/in/tv/silicon-valley/8210)

---

# Week 6

[K Means Iris Flower Data](https://drive.google.com/file/d/1W0Zc4uhrzc3rgQwIZk4HaxqHyrxczp13/view?usp=sharing)

[AirPassenger Time Series Data](https://drive.google.com/file/d/1D3_71AYj-I8WQgOj1QMjYoD-4-dtlK7h/view?usp=sharing)

[Soap Sales](https://drive.google.com/file/d/1tzqKUZPbEtvUV-F3if07VzIL7Qj-hDWc/view?usp=sharing)

[Motor Trend Cars Magazine Data (mtcars)](https://drive.google.com/file/d/1h62G83ilJyEiVJRYckzQciwwokJ2BVmD/view?usp=sharing)

[R code library for MLR](https://drive.google.com/file/d/1UJiY_e9aoi0rJj6ii2X7g1jnFRSLddsB/view?usp=sharing)

[R and Tableau Integration - Sample File](https://drive.google.com/file/d/1VIvw_8zJrNi_rg0OnLuoD1ZaC1QeJiS_/view?usp=sharing)

[Earthquake Story](https://public.tableau.com/app/profile/tableau.docs.team/viz/EarthquakeTrendStory2/Finished-Earthquakestory)

[Package workbook for Earthquake Story](https://drive.google.com/file/d/1ZCP583kURLs5o4C6kWUWSNVMwFEJD_Jw/view?usp=sharing)

---

# Miscellaneous

[Files for Joining/Blending](https://drive.google.com/drive/folders/1exsauJDkDfpAXhOtYDsnfKaIRDDbhWBB?usp=sharing)

[Tableau Certification Old Format](https://drive.google.com/file/d/1fybvGHfpSfgr6cesxzPLVSowRGfgdLdW/view?usp=sharing)

[Tableau Certified Data Analyst (New)](https://docs.google.com/document/d/1kEicNZxYY8svmVfySajbWkzPb9iZ20cU/edit?usp=sharing&ouid=100081933013190532820&rtpof=true&sd=true)