Practical Data Analysis – SQL & Tableau with Real Projects

Files Included :

1 Introduction.mp4 (18.61 MB)
MP4
1 Year, Month, Day and Get Date.mp4 (10.48 MB)
MP4
2 DateDiff.mp4 (27.98 MB)
MP4
4 DateAdd.mp4 (28.05 MB)
MP4
5 Date table.mp4 (11.31 MB)
MP4
6 Cast and Convert.mp4 (15.02 MB)
MP4
7 Joining tables on more than one condition.mp4 (15.51 MB)
MP4
8 Date Functions - Questions and Answers.mp4 (67.63 MB)
MP4
1 Concat.mp4 (29.61 MB)
MP4
2 Substring.mp4 (18.98 MB)
MP4
1 Google Sheets - Pivot Tables.mp4 (84.57 MB)
MP4
2 Any Questions.mp4 (1.05 MB)
MP4
1 Countries' Sales by Age Group.mp4 (104.11 MB)
MP4
2 Products' Sales by Age Group.mp4 (96.26 MB)
MP4
3 Sales in USA and Australia compared.mp4 (71.73 MB)
MP4
4 Products First Reorder Date.mp4 (99.38 MB)
MP4
5 Products with high stock levels.mp4 (88.49 MB)
MP4
6 Sales on Promotion.mp4 (47.66 MB)
MP4
7 Change in value between a customers' first and last purchase.mp4 (75.47 MB)
MP4
1 Customers by commute distance and country.mp4 (147.53 MB)
MP4
2 Amount of bike purchases by salary.mp4 (67.65 MB)
MP4
3 Sales for customers with children vs no children.mp4 (105 MB)
MP4
4 Putting it together.mp4 (48.64 MB)
MP4
5 Additional Analysis - Next Product Purchased after Bike Part 1.mp4 (97.23 MB)
MP4
6 Additional Analysis - Next Product Purchased after Bike Part 2.mp4 (86.09 MB)
MP4
1 Getting the data for Tableau.mp4 (64.09 MB)
MP4
10 Format and publish the dashboard to Tableau Public.mp4 (86.47 MB)
MP4
11 Add Additional Sheet to Dashboard - Country Sales in a Map.mp4 (38.24 MB)
MP4
12 Add Additional Sheet to Dashboard - Running Total Chart.mp4 (68.92 MB)
MP4
2 Download and install Tableau Public.mp4 (19.34 MB)
MP4
3 Tableau Overview.mp4 (23.65 MB)
MP4
4 Create Dual Axies Chart.mp4 (31.98 MB)
MP4
5 Create Country sales donut chart.mp4 (30.57 MB)
MP4
6 Create stacked bar chart and grouping our data.mp4 (35.45 MB)
MP4
7 Create Sales Cards.mp4 (25.22 MB)
MP4
8 Accessories bar chart.mp4 (18.65 MB)
MP4
9 Building our dashboard.mp4 (78.01 MB)
MP4
1 What we'll do in this section.mp4 (6.62 MB)
MP4
10 Add 2 Additional Cards - One Year Low and One Year % Change.mp4 (82.29 MB)
MP4
2 Getting our Data.mp4 (35.99 MB)
MP4
3 Connect Tableau to Data Source and Change Default Properties.mp4 (11.12 MB)
MP4
4 Build our Candlestick Chart.mp4 (53.63 MB)
MP4
5 Create our Volume and Volatility Charts.mp4 (28.33 MB)
MP4
6 Import Logos to Tableau.mp4 (23.5 MB)
MP4
7 Create Last Price and % Change Cards.mp4 (32.23 MB)
MP4
8 Put Dashboard Together.mp4 (113.29 MB)
MP4
9 Format & Publish our Dashboard.mp4 (134.72 MB)
MP4
1 Introduction - What you will do in this section.mp4 (5.1 MB)
MP4
10 Building our Tableau Dashboard.mp4 (60.97 MB)
MP4
11 Publishing our Dashboard.mp4 (21.25 MB)
MP4
12 Formatting our Tableau Dashboard.mp4 (113.81 MB)
MP4
2 Getting our Stock Data.mp4 (38.15 MB)
MP4
3 Download Tableau and Connect to Data Source.mp4 (23.12 MB)
MP4
4 Create Cards for Stock Value and ProfitLoss.mp4 (45.26 MB)
MP4
5 Create Donut Donut.mp4 (28.1 MB)
MP4
6 3 Month Trend Charts and Stock Overview.mp4 (46.25 MB)
MP4
7 3 Month Portfolio Value chart.mp4 (12.61 MB)
MP4
8 Performance % of Each Stock.mp4 (22.72 MB)
MP4
9 Individual Stock Chart and Parameter.mp4 (54.19 MB)
MP4
1 Download SQL Server Management studio and Adventureworks database.mp4 (45.85 MB)
MP4
1 SQL, Relational Database and Entity Relationship Diagram.mp4 (16.95 MB)
MP4
2 Quick SSMS overview.mp4 (25.3 MB)
MP4
1 Select, From, Where, And, Or.mp4 (29.45 MB)
MP4
2 Select, From, Where, And, Or - Questions and Answers.mp4 (30.97 MB)
MP4
3 Upper and Lower.mp4 (17.91 MB)
MP4
4 IN and NOT IN operators.mp4 (14.31 MB)
MP4
6 Distinct, Like and Order By.mp4 (43.38 MB)
MP4
1 Inner Join.mp4 (28.36 MB)
MP4
3 Left and Right Join.mp4 (19.18 MB)
MP4
5 Joins - 2 Questions and Answers.mp4 (39.53 MB)
MP4
6 Union and Union All.mp4 (20.79 MB)
MP4
1 Sum, Round and Group by.mp4 (21.33 MB)
MP4
3 Having and Practice Question.mp4 (28.41 MB)
MP4
4 Count.mp4 (15.6 MB)
MP4
6 Max and Min.mp4 (16.23 MB)
MP4
7 Average.mp4 (21.93 MB)
MP4
8 Questions on Aggregate Functions.mp4 (35.54 MB)
MP4
1 Sub Queries.mp4 (25.25 MB)
MP4
2 Common Table Expression (CTE).mp4 (26.8 MB)
MP4
1 Case When.mp4 (26.4 MB)
MP4
2 Flags.mp4 (29.6 MB)
MP4
1 Row number().mp4 (25.67 MB)
MP4
2 Row Number Q and A.mp4 (27.89 MB)
MP4
3 Lead and Lag.mp4 (34.89 MB)
MP4