[ CourseWikia.com ] Practical Data Analysis - SQL and Tableau with Real Projects

File Name

Size

Get Bonus Downloads Here.url

181 B

~Get Your Files Here !/1. Introduction and Thank you!/1. Introduction.mp4

19 MB

~Get Your Files Here !/1. Introduction and Thank you!/1. Introduction.srt

1.8 kB

~Get Your Files Here !/10. Date Functions/1. Year, Month, Day and Get Date.mp4

10 MB

~Get Your Files Here !/10. Date Functions/1. Year, Month, Day and Get Date.srt

2.0 kB

~Get Your Files Here !/10. Date Functions/1.1 Data Types.docx

6.2 kB

~Get Your Files Here !/10. Date Functions/1.2 SQL and Tableau course -68-73.pdf

198 kB

~Get Your Files Here !/10. Date Functions/2. DateDiff.mp4

28 MB

~Get Your Files Here !/10. Date Functions/2. DateDiff.srt

2.6 kB

~Get Your Files Here !/10. Date Functions/3. Show the difference in months between each order and todays date.html

155 B

~Get Your Files Here !/10. Date Functions/4. DateAdd.mp4

28 MB

~Get Your Files Here !/10. Date Functions/4. DateAdd.srt

3.9 kB

~Get Your Files Here !/10. Date Functions/5. Date table.mp4

11 MB

~Get Your Files Here !/10. Date Functions/5. Date table.srt

1.3 kB

~Get Your Files Here !/10. Date Functions/6. Cast and Convert.mp4

15 MB

~Get Your Files Here !/10. Date Functions/6. Cast and Convert.srt

2.7 kB

~Get Your Files Here !/10. Date Functions/6.1 SQL and Tableau course -74-77.pdf

53 kB

~Get Your Files Here !/10. Date Functions/7. Joining tables on more than one condition.mp4

16 MB

~Get Your Files Here !/10. Date Functions/7. Joining tables on more than one condition.srt

2.2 kB

~Get Your Files Here !/10. Date Functions/8. Date Functions - Questions and Answers.mp4

68 MB

~Get Your Files Here !/10. Date Functions/8. Date Functions - Questions and Answers.srt

7.6 kB

~Get Your Files Here !/11. String Functions/1. Concat.mp4

30 MB

~Get Your Files Here !/11. String Functions/1. Concat.srt

3.2 kB

~Get Your Files Here !/11. String Functions/1.1 SQL and Tableau course -78-81.pdf

147 kB

~Get Your Files Here !/11. String Functions/2. Substring.mp4

19 MB

~Get Your Files Here !/11. String Functions/2. Substring.srt

2.9 kB

~Get Your Files Here !/12. Google Sheets and Pivot Tables/1. Google Sheets - Pivot Tables.mp4

85 MB

~Get Your Files Here !/12. Google Sheets and Pivot Tables/1. Google Sheets - Pivot Tables.srt

9.5 kB

~Get Your Files Here !/12. Google Sheets and Pivot Tables/2. Any Questions.mp4

1.0 MB

~Get Your Files Here !/12. Google Sheets and Pivot Tables/2. Any Questions.srt

374 B

~Get Your Files Here !/13. Adventureworks Analysis Project/1. Countries' Sales by Age Group.mp4

104 MB

~Get Your Files Here !/13. Adventureworks Analysis Project/1. Countries' Sales by Age Group.srt

13 kB

~Get Your Files Here !/13. Adventureworks Analysis Project/2. Products' Sales by Age Group.mp4

96 MB

~Get Your Files Here !/13. Adventureworks Analysis Project/2. Products' Sales by Age Group.srt

10 kB

~Get Your Files Here !/13. Adventureworks Analysis Project/3. Sales in USA and Australia compared.mp4

72 MB

~Get Your Files Here !/13. Adventureworks Analysis Project/3. Sales in USA and Australia compared.srt

6.6 kB

~Get Your Files Here !/13. Adventureworks Analysis Project/4. Products First Reorder Date.mp4

99 MB

~Get Your Files Here !/13. Adventureworks Analysis Project/4. Products First Reorder Date.srt

9.5 kB

~Get Your Files Here !/13. Adventureworks Analysis Project/5. Products with high stock levels.mp4

88 MB

~Get Your Files Here !/13. Adventureworks Analysis Project/5. Products with high stock levels.srt

9.1 kB

~Get Your Files Here !/13. Adventureworks Analysis Project/6. Sales on Promotion.mp4

48 MB

~Get Your Files Here !/13. Adventureworks Analysis Project/6. Sales on Promotion.srt

4.4 kB

~Get Your Files Here !/13. Adventureworks Analysis Project/7. Change in value between a customers' first and last purchase.mp4

76 MB

~Get Your Files Here !/13. Adventureworks Analysis Project/7. Change in value between a customers' first and last purchase.srt

7.2 kB

~Get Your Files Here !/14. Profile of customers who purchased a bike/1. Customers by commute distance and country.mp4

148 MB

~Get Your Files Here !/14. Profile of customers who purchased a bike/1. Customers by commute distance and country.srt

11 kB

~Get Your Files Here !/14. Profile of customers who purchased a bike/2. Amount of bike purchases by salary.mp4

68 MB

~Get Your Files Here !/14. Profile of customers who purchased a bike/2. Amount of bike purchases by salary.srt

7.1 kB

~Get Your Files Here !/14. Profile of customers who purchased a bike/3. Sales for customers with children vs no children.mp4

105 MB

~Get Your Files Here !/14. Profile of customers who purchased a bike/3. Sales for customers with children vs no children.srt

9.8 kB

~Get Your Files Here !/14. Profile of customers who purchased a bike/4. Putting it together.mp4

49 MB

~Get Your Files Here !/14. Profile of customers who purchased a bike/4. Putting it together.srt

4.9 kB

~Get Your Files Here !/14. Profile of customers who purchased a bike/5. Additional Analysis - Next Product Purchased after Bike Part 1.mp4

97 MB

~Get Your Files Here !/14. Profile of customers who purchased a bike/5. Additional Analysis - Next Product Purchased after Bike Part 1.srt

12 kB

~Get Your Files Here !/14. Profile of customers who purchased a bike/6. Additional Analysis - Next Product Purchased after Bike Part 2.mp4

86 MB

~Get Your Files Here !/14. Profile of customers who purchased a bike/6. Additional Analysis - Next Product Purchased after Bike Part 2.srt

12 kB

~Get Your Files Here !/15. Create Tableau Dashboard/1. Getting the data for Tableau.mp4

64 MB

~Get Your Files Here !/15. Create Tableau Dashboard/1. Getting the data for Tableau.srt

5.4 kB

~Get Your Files Here !/15. Create Tableau Dashboard/10. Format and publish the dashboard to Tableau Public.mp4

86 MB

~Get Your Files Here !/15. Create Tableau Dashboard/10. Format and publish the dashboard to Tableau Public.srt

11 kB

~Get Your Files Here !/15. Create Tableau Dashboard/11. Add Additional Sheet to Dashboard - Country Sales in a Map.mp4

38 MB

~Get Your Files Here !/15. Create Tableau Dashboard/11. Add Additional Sheet to Dashboard - Country Sales in a Map.srt

5.8 kB

~Get Your Files Here !/15. Create Tableau Dashboard/12. Add Additional Sheet to Dashboard - Running Total Chart.mp4

69 MB

~Get Your Files Here !/15. Create Tableau Dashboard/12. Add Additional Sheet to Dashboard - Running Total Chart.srt

7.9 kB

~Get Your Files Here !/15. Create Tableau Dashboard/2. Download and install Tableau Public.mp4

19 MB

~Get Your Files Here !/15. Create Tableau Dashboard/2. Download and install Tableau Public.srt

3.1 kB

~Get Your Files Here !/15. Create Tableau Dashboard/3. Tableau Overview.mp4

24 MB

~Get Your Files Here !/15. Create Tableau Dashboard/3. Tableau Overview.srt

5.2 kB

~Get Your Files Here !/15. Create Tableau Dashboard/4. Create Dual Axies Chart.mp4

32 MB

~Get Your Files Here !/15. Create Tableau Dashboard/4. Create Dual Axies Chart.srt

6.2 kB

~Get Your Files Here !/15. Create Tableau Dashboard/5. Create Country sales donut chart.mp4

31 MB

~Get Your Files Here !/15. Create Tableau Dashboard/5. Create Country sales donut chart.srt

6.8 kB

~Get Your Files Here !/15. Create Tableau Dashboard/6. Create stacked bar chart and grouping our data.mp4

36 MB

~Get Your Files Here !/15. Create Tableau Dashboard/6. Create stacked bar chart and grouping our data.srt

7.0 kB

~Get Your Files Here !/15. Create Tableau Dashboard/7. Create Sales Cards.mp4

25 MB

~Get Your Files Here !/15. Create Tableau Dashboard/7. Create Sales Cards.srt

6.6 kB

~Get Your Files Here !/15. Create Tableau Dashboard/8. Accessories bar chart.mp4

19 MB

~Get Your Files Here !/15. Create Tableau Dashboard/8. Accessories bar chart.srt

4.3 kB

~Get Your Files Here !/15. Create Tableau Dashboard/9. Building our dashboard.mp4

78 MB

~Get Your Files Here !/15. Create Tableau Dashboard/9. Building our dashboard.srt

12 kB

~Get Your Files Here !/15. Create Tableau Dashboard/9.1 logo.JPG

16 kB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/1. What we'll do in this section.mp4

6.6 MB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/1. What we'll do in this section.srt

595 B

~Get Your Files Here !/16. Create your Own Stock Price Tracker/10. Add 2 Additional Cards - One Year Low and One Year % Change.mp4

82 MB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/10. Add 2 Additional Cards - One Year Low and One Year % Change.srt

10 kB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/2. Getting our Data.mp4

36 MB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/2. Getting our Data.srt

4.5 kB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/3. Connect Tableau to Data Source and Change Default Properties.mp4

11 MB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/3. Connect Tableau to Data Source and Change Default Properties.srt

3.0 kB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/4. Build our Candlestick Chart.mp4

54 MB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/4. Build our Candlestick Chart.srt

12 kB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/5. Create our Volume and Volatility Charts.mp4

28 MB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/5. Create our Volume and Volatility Charts.srt

4.9 kB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/6. Import Logos to Tableau.mp4

24 MB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/6. Import Logos to Tableau.srt

3.7 kB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/7. Create Last Price and % Change Cards.mp4

32 MB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/7. Create Last Price and % Change Cards.srt

7.2 kB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/8. Put Dashboard Together.mp4

113 MB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/8. Put Dashboard Together.srt

14 kB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/9. Format & Publish our Dashboard.mp4

135 MB

~Get Your Files Here !/16. Create your Own Stock Price Tracker/9. Format & Publish our Dashboard.srt

15 kB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/1. Introduction - What you will do in this section.mp4

5.1 MB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/1. Introduction - What you will do in this section.srt

1011 B

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/10. Building our Tableau Dashboard.mp4

61 MB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/10. Building our Tableau Dashboard.srt

10 kB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/11. Publishing our Dashboard.mp4

21 MB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/11. Publishing our Dashboard.srt

2.5 kB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/12. Formatting our Tableau Dashboard.mp4

114 MB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/12. Formatting our Tableau Dashboard.srt

14 kB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/2. Getting our Stock Data.mp4

38 MB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/2. Getting our Stock Data.srt

6.4 kB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/3. Download Tableau and Connect to Data Source.mp4

23 MB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/3. Download Tableau and Connect to Data Source.srt

4.5 kB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/4. Create Cards for Stock Value and ProfitLoss.mp4

45 MB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/4. Create Cards for Stock Value and ProfitLoss.srt

13 kB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/5. Create Donut Donut.mp4

28 MB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/5. Create Donut Donut.srt

6.7 kB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/6. 3 Month Trend Charts and Stock Overview.mp4

46 MB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/6. 3 Month Trend Charts and Stock Overview.srt

11 kB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/7. 3 Month Portfolio Value chart.mp4

13 MB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/7. 3 Month Portfolio Value chart.srt

2.3 kB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/8. Performance % of Each Stock.mp4

23 MB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/8. Performance % of Each Stock.srt

5.2 kB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/9. Individual Stock Chart and Parameter.mp4

54 MB

~Get Your Files Here !/17. More Tableau Practice - Stock Portfolio Dashboard/9. Individual Stock Chart and Parameter.srt

9.4 kB

~Get Your Files Here !/2. Download SQL Server Management studio and Adventureworks database/1. Download SQL Server Management studio and Adventureworks database.mp4

46 MB

~Get Your Files Here !/2. Download SQL Server Management studio and Adventureworks database/1. Download SQL Server Management studio and Adventureworks database.srt

6.1 kB

~Get Your Files Here !/3. What is SQL and a Relational Database/1. SQL, Relational Database and Entity Relationship Diagram.mp4

17 MB

~Get Your Files Here !/3. What is SQL and a Relational Database/1. SQL, Relational Database and Entity Relationship Diagram.srt

3.3 kB

~Get Your Files Here !/3. What is SQL and a Relational Database/1.1 ERD.JPG

100 kB

~Get Your Files Here !/3. What is SQL and a Relational Database/1.2 SQL and Tableau course -1-6.pdf

160 kB

~Get Your Files Here !/3. What is SQL and a Relational Database/2. Quick SSMS overview.mp4

25 MB

~Get Your Files Here !/3. What is SQL and a Relational Database/2. Quick SSMS overview.srt

3.3 kB

~Get Your Files Here !/4. Beginner SQL/1. Select, From, Where, And, Or.mp4

30 MB

~Get Your Files Here !/4. Beginner SQL/1. Select, From, Where, And, Or.srt

5.7 kB

~Get Your Files Here !/4. Beginner SQL/1.1 SQL and Tableau course -6-14.pdf

216 kB

~Get Your Files Here !/4. Beginner SQL/2. Select, From, Where, And, Or - Questions and Answers.mp4

31 MB

~Get Your Files Here !/4. Beginner SQL/2. Select, From, Where, And, Or - Questions and Answers.srt

3.8 kB

~Get Your Files Here !/4. Beginner SQL/3. Upper and Lower.mp4

18 MB

~Get Your Files Here !/4. Beginner SQL/3. Upper and Lower.srt

2.5 kB

~Get Your Files Here !/4. Beginner SQL/3.1 SQL and Tableau course -15-23.pdf

102 kB

~Get Your Files Here !/4. Beginner SQL/4. IN and NOT IN operators.mp4

14 MB

~Get Your Files Here !/4. Beginner SQL/4. IN and NOT IN operators.srt

2.3 kB

~Get Your Files Here !/4. Beginner SQL/5. Show all columns for customers who are from New York, London or Mumbai using IN.html

155 B

~Get Your Files Here !/4. Beginner SQL/6. Distinct, Like and Order By.mp4

43 MB

~Get Your Files Here !/4. Beginner SQL/6. Distinct, Like and Order By.srt

5.9 kB

~Get Your Files Here !/4. Beginner SQL/7. Show all Customers with Last Name Yang, Lin or Alvarez using the IN operator.html

155 B

~Get Your Files Here !/5. Intermediate SQL/1. Inner Join.mp4

28 MB

~Get Your Files Here !/5. Intermediate SQL/1. Inner Join.srt

4.2 kB

~Get Your Files Here !/5. Intermediate SQL/1.1 SQL and Tableau course -24-32.pdf

227 kB

~Get Your Files Here !/5. Intermediate SQL/2. Show All Columns from the Sales and Customer table.html

155 B

~Get Your Files Here !/5. Intermediate SQL/3. Left and Right Join.mp4

19 MB

~Get Your Files Here !/5. Intermediate SQL/3. Left and Right Join.srt

3.0 kB

~Get Your Files Here !/5. Intermediate SQL/4. Show all customers and their orders, even if they made no orders.html

155 B

~Get Your Files Here !/5. Intermediate SQL/5. Joins - 2 Questions and Answers.mp4

40 MB

~Get Your Files Here !/5. Intermediate SQL/5. Joins - 2 Questions and Answers.srt

4.7 kB

~Get Your Files Here !/5. Intermediate SQL/6. Union and Union All.mp4

21 MB

~Get Your Files Here !/5. Intermediate SQL/6. Union and Union All.srt

3.1 kB

~Get Your Files Here !/5. Intermediate SQL/6.1 SQL and Tableau course -33-38.pdf

115 kB

~Get Your Files Here !/5. Intermediate SQL/7. Show all Employees and Customers.html

155 B

~Get Your Files Here !/6. Aggregate Functions/1. Sum, Round and Group by.mp4

21 MB

~Get Your Files Here !/6. Aggregate Functions/1. Sum, Round and Group by.srt

3.9 kB

~Get Your Files Here !/6. Aggregate Functions/1.1 SQL and Tableau course -39-43.pdf

75 kB

~Get Your Files Here !/6. Aggregate Functions/2. Show the sum of all orders on each day.html

155 B

~Get Your Files Here !/6. Aggregate Functions/3. Having and Practice Question.mp4

28 MB

~Get Your Files Here !/6. Aggregate Functions/3. Having and Practice Question.srt

4.1 kB

~Get Your Files Here !/6. Aggregate Functions/4. Count.mp4

16 MB

~Get Your Files Here !/6. Aggregate Functions/4. Count.srt

3.0 kB

~Get Your Files Here !/6. Aggregate Functions/4.1 SQL and Tableau course -44-48.pdf

49 kB

~Get Your Files Here !/6. Aggregate Functions/5. Count how many distinct customers there were on each day.html

155 B

~Get Your Files Here !/6. Aggregate Functions/6. Max and Min.mp4

16 MB

~Get Your Files Here !/6. Aggregate Functions/6. Max and Min.srt

2.7 kB

~Get Your Files Here !/6. Aggregate Functions/7. Average.mp4

22 MB

~Get Your Files Here !/6. Aggregate Functions/7. Average.srt

3.9 kB

~Get Your Files Here !/6. Aggregate Functions/8. Questions on Aggregate Functions.mp4

36 MB

~Get Your Files Here !/6. Aggregate Functions/8. Questions on Aggregate Functions.srt

4.6 kB

~Get Your Files Here !/7. Sub Query and Common Table Expression (CTE)/1. Sub Queries.mp4

25 MB

~Get Your Files Here !/7. Sub Query and Common Table Expression (CTE)/1. Sub Queries.srt

4.6 kB

~Get Your Files Here !/7. Sub Query and Common Table Expression (CTE)/1.1 SQL and Tableau course -49-54.pdf

37 kB

~Get Your Files Here !/7. Sub Query and Common Table Expression (CTE)/2. Common Table Expression (CTE).mp4

27 MB

~Get Your Files Here !/7. Sub Query and Common Table Expression (CTE)/2. Common Table Expression (CTE).srt

5.1 kB

~Get Your Files Here !/8. Case Statement and Flags/1. Case When.mp4

26 MB

~Get Your Files Here !/8. Case Statement and Flags/1. Case When.srt

4.1 kB

~Get Your Files Here !/8. Case Statement and Flags/1.1 SQL and Tableau course -55-57.pdf

76 kB

~Get Your Files Here !/8. Case Statement and Flags/2. Flags.mp4

30 MB

~Get Your Files Here !/8. Case Statement and Flags/2. Flags.srt

3.9 kB

~Get Your Files Here !/8. Case Statement and Flags/2.1 SQL and Tableau course -58-60.pdf

67 kB

~Get Your Files Here !/9. Window Functions/1. Row_number().mp4

26 MB

~Get Your Files Here !/9. Window Functions/1. Row_number().srt

3.7 kB

~Get Your Files Here !/9. Window Functions/1.1 SQL and Tableau course -61-67.pdf

291 kB

~Get Your Files Here !/9. Window Functions/2. Row Number Q and A.mp4

28 MB

~Get Your Files Here !/9. Window Functions/2. Row Number Q and A.srt

3.4 kB

~Get Your Files Here !/9. Window Functions/3. Lead and Lag.mp4

35 MB

~Get Your Files Here !/9. Window Functions/3. Lead and Lag.srt

5.5 kB

~Get Your Files Here !/Bonus Resources.txt

386 B