CourseWikia com Practical Data Analysis SQL and Tableau with Real Projects

CourseWikia com Practical Data Analysis SQL and Tableau with Real Projects

Name	[ CourseWikia.com ] Practical Data Analysis - SQL and Tableau with Real Projects	DOWNLOAD Copy Link
Total Size	3.8 GB
Total Files	195
Last Seen	2024-11-07 23:44
Hash	4B83938391FFD40A17F6945D42800ECF78131489

/
Get Bonus Downloads Here.url	0.2 KB
/.../1. Introduction and Thank you!/
1. Introduction.mp4	19.5 MB
1. Introduction.srt	1.9 KB
/.../10. Date Functions/
1. Year, Month, Day and Get Date.mp4	11.0 MB
1. Year, Month, Day and Get Date.srt	2.1 KB
1.1 Data Types.docx	6.3 KB
1.2 SQL and Tableau course -68-73.pdf	202.4 KB
2. DateDiff.mp4	29.3 MB
2. DateDiff.srt	2.7 KB
3. Show the difference in months between each order and todays date.html	0.2 KB
4. DateAdd.mp4	29.4 MB
4. DateAdd.srt	4.0 KB
5. Date table.mp4	11.9 MB
5. Date table.srt	1.4 KB
6. Cast and Convert.mp4	15.8 MB
6. Cast and Convert.srt	2.8 KB
6.1 SQL and Tableau course -74-77.pdf	54.2 KB
7. Joining tables on more than one condition.mp4	16.3 MB
7. Joining tables on more than one condition.srt	2.2 KB
8. Date Functions - Questions and Answers.mp4	70.9 MB
8. Date Functions - Questions and Answers.srt	7.8 KB
/.../11. String Functions/
1. Concat.mp4	31.1 MB
1. Concat.srt	3.2 KB
1.1 SQL and Tableau course -78-81.pdf	150.8 KB
2. Substring.mp4	19.9 MB
2. Substring.srt	3.0 KB
/.../12. Google Sheets and Pivot Tables/
1. Google Sheets - Pivot Tables.mp4	88.7 MB
1. Google Sheets - Pivot Tables.srt	9.7 KB
2. Any Questions.mp4	1.1 MB
2. Any Questions.srt	0.4 KB
/.../13. Adventureworks Analysis Project/
1. Countries' Sales by Age Group.mp4	109.2 MB
1. Countries' Sales by Age Group.srt	13.0 KB
2. Products' Sales by Age Group.mp4	100.9 MB
2. Products' Sales by Age Group.srt	10.8 KB
3. Sales in USA and Australia compared.mp4	75.2 MB
3. Sales in USA and Australia compared.srt	6.8 KB
4. Products First Reorder Date.mp4	104.2 MB
4. Products First Reorder Date.srt	9.8 KB
5. Products with high stock levels.mp4	92.8 MB
5. Products with high stock levels.srt	9.3 KB
6. Sales on Promotion.mp4	50.0 MB
6. Sales on Promotion.srt	4.5 KB
7. Change in value between a customers' first and last purchase.mp4	79.1 MB
7. Change in value between a customers' first and last purchase.srt	7.4 KB
/.../14. Profile of customers who purchased a bike/
1. Customers by commute distance and country.mp4	154.7 MB
1. Customers by commute distance and country.srt	11.4 KB
2. Amount of bike purchases by salary.mp4	70.9 MB
2. Amount of bike purchases by salary.srt	7.2 KB
3. Sales for customers with children vs no children.mp4	110.1 MB
3. Sales for customers with children vs no children.srt	10.1 KB
4. Putting it together.mp4	51.0 MB
4. Putting it together.srt	5.0 KB
5. Additional Analysis - Next Product Purchased after Bike Part 1.mp4	102.0 MB
5. Additional Analysis - Next Product Purchased after Bike Part 1.srt	12.2 KB
6. Additional Analysis - Next Product Purchased after Bike Part 2.mp4	90.3 MB
6. Additional Analysis - Next Product Purchased after Bike Part 2.srt	12.4 KB
/.../15. Create Tableau Dashboard/
1. Getting the data for Tableau.mp4	67.2 MB
1. Getting the data for Tableau.srt	5.5 KB
10. Format and publish the dashboard to Tableau Public.mp4	90.7 MB
10. Format and publish the dashboard to Tableau Public.srt	10.8 KB
11. Add Additional Sheet to Dashboard - Country Sales in a Map.mp4	40.1 MB
11. Add Additional Sheet to Dashboard - Country Sales in a Map.srt	5.9 KB
12. Add Additional Sheet to Dashboard - Running Total Chart.mp4	72.3 MB
12. Add Additional Sheet to Dashboard - Running Total Chart.srt	8.1 KB
2. Download and install Tableau Public.mp4	20.3 MB
2. Download and install Tableau Public.srt	3.2 KB
3. Tableau Overview.mp4	24.8 MB
3. Tableau Overview.srt	5.3 KB
4. Create Dual Axies Chart.mp4	33.5 MB
4. Create Dual Axies Chart.srt	6.4 KB
5. Create Country sales donut chart.mp4	32.1 MB
5. Create Country sales donut chart.srt	7.0 KB
6. Create stacked bar chart and grouping our data.mp4	37.2 MB
6. Create stacked bar chart and grouping our data.srt	7.1 KB
7. Create Sales Cards.mp4	26.4 MB
7. Create Sales Cards.srt	6.7 KB
8. Accessories bar chart.mp4	19.6 MB
8. Accessories bar chart.srt	4.4 KB
9. Building our dashboard.mp4	81.8 MB
9. Building our dashboard.srt	12.2 KB
9.1 logo.JPG	16.3 KB
/.../16. Create your Own Stock Price Tracker/
1. What we'll do in this section.mp4	6.9 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	86.3 MB
10. Add 2 Additional Cards - One Year Low and One Year % Change.srt	10.5 KB
2. Getting our Data.mp4	37.7 MB
2. Getting our Data.srt	4.6 KB
3. Connect Tableau to Data Source and Change Default Properties.mp4	11.7 MB
3. Connect Tableau to Data Source and Change Default Properties.srt	3.1 KB
4. Build our Candlestick Chart.mp4	56.2 MB
4. Build our Candlestick Chart.srt	12.3 KB
5. Create our Volume and Volatility Charts.mp4	29.7 MB
5. Create our Volume and Volatility Charts.srt	5.0 KB
6. Import Logos to Tableau.mp4	24.6 MB
6. Import Logos to Tableau.srt	3.8 KB
7. Create Last Price and % Change Cards.mp4	33.8 MB
7. Create Last Price and % Change Cards.srt	7.3 KB
8. Put Dashboard Together.mp4	118.8 MB
8. Put Dashboard Together.srt	14.0 KB
9. Format & Publish our Dashboard.mp4	141.3 MB
9. Format & Publish our Dashboard.srt	15.5 KB
/.../17. More Tableau Practice - Stock Portfolio Dashboard/
1. Introduction - What you will do in this section.mp4	5.3 MB
1. Introduction - What you will do in this section.srt	1.0 KB
10. Building our Tableau Dashboard.mp4	63.9 MB
10. Building our Tableau Dashboard.srt	10.5 KB
11. Publishing our Dashboard.mp4	22.3 MB
11. Publishing our Dashboard.srt	2.5 KB
12. Formatting our Tableau Dashboard.mp4	119.3 MB
12. Formatting our Tableau Dashboard.srt	14.3 KB
2. Getting our Stock Data.mp4	40.0 MB
2. Getting our Stock Data.srt	6.5 KB
3. Download Tableau and Connect to Data Source.mp4	24.2 MB
3. Download Tableau and Connect to Data Source.srt	4.6 KB
4. Create Cards for Stock Value and ProfitLoss.mp4	47.5 MB
4. Create Cards for Stock Value and ProfitLoss.srt	12.9 KB
5. Create Donut Donut.mp4	29.5 MB
5. Create Donut Donut.srt	6.8 KB
6. 3 Month Trend Charts and Stock Overview.mp4	48.5 MB
6. 3 Month Trend Charts and Stock Overview.srt	10.9 KB
7. 3 Month Portfolio Value chart.mp4	13.2 MB
7. 3 Month Portfolio Value chart.srt	2.4 KB
8. Performance % of Each Stock.mp4	23.8 MB
8. Performance % of Each Stock.srt	5.4 KB
9. Individual Stock Chart and Parameter.mp4	56.8 MB
9. Individual Stock Chart and Parameter.srt	9.6 KB
/.../2. Download SQL Server Management studio and Adventureworks database/
1. Download SQL Server Management studio and Adventureworks database.mp4	48.1 MB
1. Download SQL Server Management studio and Adventureworks database.srt	6.2 KB
/.../3. What is SQL and a Relational Database/
1. SQL, Relational Database and Entity Relationship Diagram.mp4	17.8 MB
1. SQL, Relational Database and Entity Relationship Diagram.srt	3.4 KB
1.1 ERD.JPG	102.7 KB
1.2 SQL and Tableau course -1-6.pdf	163.7 KB
2. Quick SSMS overview.mp4	26.5 MB
2. Quick SSMS overview.srt	3.4 KB
/4. Beginner SQL/
1. Select, From, Where, And, Or.mp4	30.9 MB
1. Select, From, Where, And, Or.srt	5.9 KB
1.1 SQL and Tableau course -6-14.pdf	221.2 KB
2. Select, From, Where, And, Or - Questions and Answers.mp4	32.5 MB
2. Select, From, Where, And, Or - Questions and Answers.srt	3.9 KB
3. Upper and Lower.mp4	18.8 MB
3. Upper and Lower.srt	2.6 KB
3.1 SQL and Tableau course -15-23.pdf	104.0 KB
4. IN and NOT IN operators.mp4	15.0 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	45.5 MB
6. Distinct, Like and Order By.srt	6.0 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	29.7 MB
1. Inner Join.srt	4.3 KB
1.1 SQL and Tableau course -24-32.pdf	232.6 KB
2. Show All Columns from the Sales and Customer table.html	0.2 KB
3. Left and Right Join.mp4	20.1 MB
3. Left and Right Join.srt	3.1 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	41.5 MB
5. Joins - 2 Questions and Answers.srt	4.8 KB
6. Union and Union All.mp4	21.8 MB
6. Union and Union All.srt	3.2 KB
6.1 SQL and Tableau course -33-38.pdf	117.5 KB
7. Show all Employees and Customers.html	0.2 KB
/6. Aggregate Functions/
1. Sum, Round and Group by.mp4	22.4 MB
1. Sum, Round and Group by.srt	4.0 KB
1.1 SQL and Tableau course -39-43.pdf	76.9 KB
2. Show the sum of all orders on each day.html	0.2 KB
3. Having and Practice Question.mp4	29.8 MB
3. Having and Practice Question.srt	4.2 KB
4. Count.mp4	16.4 MB
4. Count.srt	3.0 KB
4.1 SQL and Tableau course -44-48.pdf	50.1 KB
5. Count how many distinct customers there were on each day.html	0.2 KB
6. Max and Min.mp4	17.0 MB
6. Max and Min.srt	2.8 KB
7. Average.mp4	23.0 MB
7. Average.srt	4.0 KB
8. Questions on Aggregate Functions.mp4	37.3 MB
8. Questions on Aggregate Functions.srt	4.8 KB
/.../7. Sub Query and Common Table Expression (CTE)/
1. Sub Queries.mp4	26.5 MB
1. Sub Queries.srt	4.7 KB
1.1 SQL and Tableau course -49-54.pdf	38.3 KB
2. Common Table Expression (CTE).mp4	28.1 MB
2. Common Table Expression (CTE).srt	5.3 KB
/.../8. Case Statement and Flags/
1. Case When.mp4	27.7 MB
1. Case When.srt	4.2 KB
1.1 SQL and Tableau course -55-57.pdf	78.2 KB
2. Flags.mp4	31.0 MB
2. Flags.srt	3.9 KB
2.1 SQL and Tableau course -58-60.pdf	68.2 KB
/9. Window Functions/
1. Row_number().mp4	26.9 MB
1. Row_number().srt	3.8 KB
1.1 SQL and Tableau course -61-67.pdf	298.2 KB
2. Row Number Q and A.mp4	29.2 MB
2. Row Number Q and A.srt	3.5 KB
3. Lead and Lag.mp4	36.6 MB
3. Lead and Lag.srt	5.6 KB
/~Get Your Files Here !/
Bonus Resources.txt	0.4 KB
Total files 195