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