Practical Data Analysis - SQL and Tableau with Real Projects

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1. Introduction and Thank you!
• 1. Introduction.mp4 (18.6 MB)
• 1. Introduction.srt (1.8 KB)
10. Date Functions
• 1. Year, Month, Day and Get Date.mp4 (10.5 MB)
• 1. Year, Month, Day and Get Date.srt (2.0 KB)
• 1.1 Data Types.docx (6.2 KB)
• 1.2 SQL and Tableau course -68-73.pdf (197.7 KB)
• 2. DateDiff.mp4 (28.0 MB)
• 2. DateDiff.srt (2.6 KB)
• 3. Show the difference in months between each order and todays date.html (0.2 KB)
• 4. DateAdd.mp4 (28.1 MB)
• 4. DateAdd.srt (3.9 KB)
• 5. Date table.mp4 (11.3 MB)
• 5. Date table.srt (1.3 KB)
• 6. Cast and Convert.mp4 (15.0 MB)
• 6. Cast and Convert.srt (2.7 KB)
• 6.1 SQL and Tableau course -74-77.pdf (53.0 KB)
• 7. Joining tables on more than one condition.mp4 (15.5 MB)
• 7. Joining tables on more than one condition.srt (2.2 KB)
• 8. Date Functions - Questions and Answers.mp4 (67.6 MB)
• 8. Date Functions - Questions and Answers.srt (7.6 KB)
11. String Functions
• 1. Concat.mp4 (29.6 MB)
• 1. Concat.srt (3.2 KB)
• 1.1 SQL and Tableau course -78-81.pdf (147.3 KB)
• 2. Substring.mp4 (19.0 MB)
• 2. Substring.srt (2.9 KB)
12. Google Sheets and Pivot Tables
• 1. Google Sheets - Pivot Tables.mp4 (84.6 MB)
• 1. Google Sheets - Pivot Tables.srt (9.5 KB)
• 2. Any Questions.mp4 (1.0 MB)
• 2. Any Questions.srt (0.4 KB)
13. Adventureworks Analysis Project
• 1. Countries' Sales by Age Group.mp4 (104.1 MB)
• 1. Countries' Sales by Age Group.srt (12.7 KB)
• 2. Products' Sales by Age Group.mp4 (96.3 MB)
• 2. Products' Sales by Age Group.srt (10.5 KB)
• 3. Sales in USA and Australia compared.mp4 (71.7 MB)
• 3. Sales in USA and Australia compared.srt (6.6 KB)
• 4. Products First Reorder Date.mp4 (99.4 MB)
• 4. Products First Reorder Date.srt (9.5 KB)
• 5. Products with high stock levels.mp4 (88.5 MB)
• 5. Products with high stock levels.srt (9.1 KB)
• 6. Sales on Promotion.mp4 (47.7 MB)
• 6. Sales on Promotion.srt (4.4 KB)
• 7. Change in value between a customers' first and last purchase.mp4 (75.5 MB)
• 7. Change in value between a customers' first and last purchase.srt (7.2 KB)
14. Profile of customers who purchased a bike
• 1. Customers by commute distance and country.mp4 (147.5 MB)
• 1. Customers by commute distance and country.srt (11.1 KB)
• 2. Amount of bike purchases by salary.mp4 (67.7 MB)
• 2. Amount of bike purchases by salary.srt (7.1 KB)
• 3. Sales for customers with children vs no children.mp4 (105.0 MB)
• 3. Sales for customers with children vs no children.srt (9.8 KB)
• 4. Putting it together.mp4 (48.6 MB)
• 4. Putting it together.srt (4.9 KB)
• 5. Additional Analysis - Next Product Purchased after Bike Part 1.mp4 (97.2 MB)
• 5. Additional Analysis - Next Product Purchased after Bike Part 1.srt (11.9 KB)
• 6. Additional Analysis - Next Product Purchased after Bike Part 2.mp4 (86.1 MB)
• 6. Additional Analysis - Next Product Purchased after Bike Part 2.srt (12.1 KB)
15. Create Tableau Dashboard
• 1. Getting the data for Tableau.mp4 (64.1 MB)
• 1. Getting the data for Tableau.srt (5.4 KB)
• 10. Format and publish the dashboard to Tableau Public.mp4 (86.5 MB)
• 10. Format and publish the dashboard to Tableau Public.srt (10.6 KB)
• 11. Add Additional Sheet to Dashboard - Country Sales in a Map.mp4 (38.2 MB)
• 11. Add Additional Sheet to Dashboard - Country Sales in a Map.srt (5.8 KB)
• 12. Add Additional Sheet to Dashboard - Running Total Chart.mp4 (68.9 MB)
• 12. Add Additional Sheet to Dashboard - Running Total Chart.srt (7.9 KB)
• 2. Download and install Tableau Public.mp4 (19.3 MB)
• 2. Download and install Tableau Public.srt (3.1 KB)
• 3. Tableau Overview.mp4 (23.7 MB)
• 3. Tableau Overview.srt (5.2 KB)
• 4. Create Dual Axies Chart.mp4 (32.0 MB)
• 4. Create Dual Axies Chart.srt (6.2 KB)
• 5. Create Country sales donut chart.mp4 (30.6 MB)
• 5. Create Country sales donut chart.srt (6.8 KB)
• 6. Create stacked bar chart and grouping our data.mp4 (35.5 MB)
• 6. Create stacked bar chart and grouping our data.srt (7.0 KB)
• 7. Create Sales Cards.mp4 (25.2 MB)
• 7. Create Sales Cards.srt (6.6 KB)
• 8. Accessories bar chart.mp4 (18.6 MB)
• 8. Accessories bar chart.srt (4.3 KB)
• 9. Building our dashboard.mp4 (78.0 MB)
• 9. Building our dashboard.srt (11.9 KB)
• 9.1 logo.JPG (15.9 KB)
16. Create your Own Stock Price Tracker
• 1. What we'll do in this section.mp4 (6.6 MB)
• 1. What we'll do in this section.srt (0.6 KB)
• 10. Add 2 Additional Cards - One Year Low and One Year % Change.mp4 (82.3 MB)
• 10. Add 2 Additional Cards - One Year Low and One Year % Change.srt (10.2 KB)
• 2. Getting our Data.mp4 (36.0 MB)
• 2. Getting our Data.srt (4.5 KB)
• 3. Connect Tableau to Data Source and Change Default Properties.mp4 (11.1 MB)
• 3. Connect Tableau to Data Source and Change Default Properties.srt (3.0 KB)
• 4. Build our Candlestick Chart.mp4 (53.6 MB)
• 4. Build our Candlestick Chart.srt (12.0 KB)
• 5. Create our Volume and Volatility Charts.mp4 (28.3 MB)
• 5. Create our Volume and Volatility Charts.srt (4.9 KB)
• 6. Import Logos to Tableau.mp4 (23.5 MB)
• 6. Import Logos to Tableau.srt (3.7 KB)
• 7. Create Last Price and % Change Cards.mp4 (32.2 MB)
• 7. Create Last Price and % Change Cards.srt (7.2 KB)
• 8. Put Dashboard Together.mp4 (113.3 MB)
• 8. Put Dashboard Together.srt (13.7 KB)
• 9. Format & Publish our Dashboard.mp4 (134.7 MB)
• 9. Format & Publish our Dashboard.srt (15.1 KB)
17. More Tableau Practice - Stock Portfolio Dashboard
• 1. Introduction - What you will do in this section.mp4 (5.1 MB)
• 1. Introduction - What you will do in this section.srt (1.0 KB)
• 10. Building our Tableau Dashboard.mp4 (61.0 MB)
• 10. Building our Tableau Dashboard.srt (10.3 KB)
• 11. Publishing our Dashboard.mp4 (21.2 MB)
• 11. Publishing our Dashboard.srt (2.5 KB)
• 12. Formatting our Tableau Dashboard.mp4 (113.8 MB)
• 12. Formatting our Tableau Dashboard.srt (14.0 KB)
• 2. Getting our Stock Data.mp4 (38.1 MB)
• 2. Getting our Stock Data.srt (6.4 KB)
• 3. Download Tableau and Connect to Data Source.mp4 (23.1 MB)
• 3. Download Tableau and Connect to Data Source.srt (4.5 KB)
• 4. Create Cards for Stock Value and ProfitLoss.mp4 (45.3 MB)
• 4. Create Cards for Stock Value and ProfitLoss.srt (12.6 KB)
• 5. Create Donut Donut.mp4 (28.1 MB)
• 5. Create Donut Donut.srt (6.7 KB)
• 6. 3 Month Trend Charts and Stock Overview.mp4 (46.3 MB)
• 6. 3 Month Trend Charts and Stock Overview.srt (10.6 KB)
• 7. 3 Month Portfolio Value chart.mp4 (12.6 MB)
• 7. 3 Month Portfolio Value chart.srt (2.3 KB)
• 8. Performance % of Each Stock.mp4 (22.7 MB)
• 8. Performance % of Each Stock.srt (5.2 KB)
• 9. Individual Stock Chart and Parameter.mp4 (54.2 MB)
• 9. Individual Stock Chart and Parameter.srt (9.4 KB)
2. Download SQL Server Management studio and Adventureworks database
• 1. Download SQL Server Management studio and Adventureworks database.mp4 (45.9 MB)
• 1. Download SQL Server Management studio and Adventureworks database.srt (6.1 KB)
3. What is SQL and a Relational Database
• 1. SQL, Relational Database and Entity Relationship Diagram.mp4 (17.0 MB)
• 1. SQL, Relational Database and Entity Relationship Diagram.srt (3.3 KB)
• 1.1 ERD.JPG (100.3 KB)
• 1.2 SQL and Tableau course -1-6.pdf (159.9 KB)
• 2. Quick SSMS overview.mp4 (25.3 MB)
• 2. Quick SSMS overview.srt (3.3 KB)
4. Beginner SQL
• 1. Select, From, Where, And, Or.mp4 (29.5 MB)
• 1. Select, From, Where, And, Or.srt (5.7 KB)
• 1.1 SQL and Tableau course -6-14.pdf (216.1 KB)
• 2. Select, From, Where, And, Or - Questions and Answers.mp4 (31.0 MB)
• 2. Select, From, Where, And, Or - Questions and Answers.srt (3.8 KB)
• 3. Upper and Lower.mp4 (17.9 MB)
• 3. Upper and Lower.srt (2.5 KB)
• 3.1 SQL and Tableau course -15-23.pdf (101.5 KB)
• 4. IN and NOT IN operators.mp4 (14.3 MB)
• 4. IN and NOT IN operators.srt (2.3 KB)
• 5. Show all columns for customers who are from New York, London or Mumbai using IN.html (0.2 KB)
• 6. Distinct, Like and Order By.mp4 (43.4 MB)
• 6. Distinct, Like and Order By.srt (5.9 KB)
• 7. Show all Customers with Last Name Yang, Lin or Alvarez using the IN operator.html (0.2 KB)
5. Intermediate SQL
• 1. Inner Join.mp4 (28.4 MB)
• 1. Inner Join.srt (4.2 KB)
• 1.1 SQL and Tableau course -24-32.pdf (227.2 KB)
• 2. Show All Columns from the Sales and Customer table.html (0.2 KB)
• 3. Left and Right Join.mp4 (19.2 MB)
• 3. Left and Right Join.srt (3.0 KB)
• 4. Show all customers and their orders, even if they made no orders.html (0.2 KB)
• 5. Joins - 2 Questions and Answers.mp4 (39.5 MB)
• 5. Joins - 2 Questions and Answers.srt (4.7 KB)
• 6. Union and Union All.mp4 (20.8 MB)
• 6. Union and Union All.srt (3.1 KB)
• 6.1 SQL and Tableau course -33-38.pdf (114.8 KB)
• 7. Show all Employees and Customers.html (0.2 KB)
6. Aggregate Functions
• 1. Sum, Round and Group by.mp4 (21.3 MB)
• 1. Sum, Round and Group by.srt (3.9 KB)
• 1.1 SQL and Tableau course -39-43.pdf (75.1 KB)
• 2. Show the sum of all orders on each day.html (0.2 KB)
• 3. Having and Practice Question.mp4 (28.4 MB)
• 3. Having and Practice Question.srt (4.1 KB)
• 4. Count.mp4 (15.6 MB)
• 4. Count.srt (3.0 KB)
• 4.1 SQL and Tableau course -44-48.pdf (48.9 KB)
• 5. Count how many distinct customers there were on each day.html (0.2 KB)
• 6. Max and Min.mp4 (16.2 MB)
• 6. Max and Min.srt (2.7 KB)
• 7. Average.mp4 (21.9 MB)
• 7. Average.srt (3.9 KB)
• 8. Questions on Aggregate Functions.mp4 (35.5 MB)
• 8. Questions on Aggregate Functions.srt (4.6 KB)
7. Sub Query and Common Table Expression (CTE)
• 1. Sub Queries.mp4 (25.3 MB)
• 1. Sub Queries.srt (4.6 KB)
• 1.1 SQL and Tableau course -49-54.pdf (37.4 KB)
• 2. Common Table Expression (CTE).mp4 (26.8 MB)
• 2. Common Table Expression (CTE).srt (5.1 KB)
8. Case Statement and Flags
• 1. Case When.mp4 (26.4 MB)
• 1. Case When.srt (4.1 KB)
• 1.1 SQL and Tableau course -55-57.pdf (76.4 KB)
• 2. Flags.mp4 (29.6 MB)
• 2. Flags.srt (3.9 KB)
• 2.1 SQL and Tableau course -58-60.pdf (66.6 KB)
9. Window Functions
• 1. Row_number().mp4 (25.7 MB)
• 1. Row_number().srt (3.7 KB)
• 1.1 SQL and Tableau course -61-67.pdf (291.2 KB)
• 2. Row Number Q and A.mp4 (27.9 MB)
• 2. Row Number Q and A.srt (3.4 KB)
• 3. Lead and Lag.mp4 (34.9 MB)
• 3. Lead and Lag.srt (5.5 KB)
• Bonus Resources.txt (0.4 KB)