Udemy - Become a Data Analyst: Excel, SQL & Tableau - 3-in-1 Bund...

Files:

• [CourseClub.Me].url (0.1 KB)
• [FreeCourseSite.com].url (0.1 KB)
• [GigaCourse.Com].url (0.0 KB)

• 1 - Introduction.mp4 (28.2 MB)

• 44 - Named Ranges.mp4 (65.3 MB)
• 45 - Indirect Functions.mp4 (35.9 MB)

• 46 - Shortcuts.mp4 (103.8 MB)

• 47 - Macros.mp4 (71.5 MB)

• 48 - Advanced Excel Analytics in Excel.mp4 (123.0 MB)

• 49 - Infographic Example 1.mp4 (116.6 MB)
• 50 - Infographic Example 2.mp4 (37.0 MB)

• 51 - Introduction.mp4 (22.9 MB)

• 52 - Installing PostgreSQL and pgAdmin in your PC.mp4 (83.4 MB)
• 53 - If pgAdmin is not opening.html (1.6 KB)

• 54 - Case Study Part 1 Business problems.mp4 (37.8 MB)
• 55 - Case Study Part 2 How SQL is Used.mp4 (59.0 MB)

• 56 - CREATE.mp4 (91.1 MB)
• 57 - INSERT.mp4 (73.0 MB)
• 58 - Import data from File.mp4 (42.0 MB)
• 59 - SELECT statement.mp4 (31.8 MB)
• 60 - SELECT DISTINCT.mp4 (46.2 MB)
• 61 - WHERE.mp4 (32.6 MB)
• 62 - Logical Operators.mp4 (50.5 MB)
• 63 - UPDATE.mp4 (38.2 MB)
• 64 - DELETE.mp4 (30.0 MB)
• 65 - ALTER part 1.mp4 (46.3 MB)
• 66 - ALTER part 2.mp4 (84.1 MB)

• [CourseClub.Me].url (0.1 KB)
• [FreeCourseSite.com].url (0.1 KB)
• [GigaCourse.Com].url (0.0 KB)

• 67 - Restore and Backup.mp4 (81.4 MB)
• 68 - Debugging restoration issues.mp4 (53.6 MB)
• 69 - Creating DB using CSV files.mp4 (38.4 MB)
• 70 - Debugging summary and Code for CSV files.html (2.2 KB)
2 - Excel Basics
• 2 - Getting started with Excel.mp4 (52.1 MB)
• 3 - Course Resources.html (0.4 KB)
• 4 - This is a milestone.mp4 (21.9 MB)
• 5 - Worksheet basics.mp4 (93.6 MB)
• 6 - Entering values and Formulas.mp4 (38.3 MB)
• 7 - Data Formats.mp4 (48.7 MB)
• 8 - Data Handling Basics Cut Copy Paste.mp4 (89.8 MB)
• 9 - Saving and Printing in Excel.mp4 (52.2 MB)
20 - Selection commands Filtering
• 71 - IN.mp4 (29.6 MB)
• 72 - BETWEEN.mp4 (52.3 MB)
• 73 - LIKE.mp4 (72.7 MB)
21 - Selection commands Ordering
• 74 - Side Lecture Commenting in SQL.mp4 (13.1 MB)
• 75 - ORDER BY.mp4 (72.8 MB)
• 76 - LIMIT.mp4 (29.3 MB)
22 - Alias
• 77 - AS.mp4 (27.3 MB)
23 - Aggregate Commands
• 78 - COUNT.mp4 (43.9 MB)
• 79 - SUM.mp4 (26.1 MB)
• 80 - AVERAGE.mp4 (21.1 MB)
• 81 - MIN MAX.mp4 (32.3 MB)
24 - Group By Commands
• 82 - GROUP BY.mp4 (104.7 MB)
• 83 - HAVING.mp4 (38.8 MB)
25 - Conditional Statement
• 84 - CASE WHEN.mp4 (35.1 MB)
26 - JOINS
• 85 - Introductions to Joins.mp4 (8.6 MB)
• 86 - Concepts of Joining and Combining Data.mp4 (65.0 MB)
• 87 - Preparing the data.mp4 (15.7 MB)
• 88 - Inner Join.mp4 (51.1 MB)
• 89 - Left Join.mp4 (40.0 MB)
• 90 - Right Join.mp4 (39.0 MB)
• 91 - Full Outer Join.mp4 (34.3 MB)
• 92 - Cross Join.mp4 (20.2 MB)
• 93 - Intersect and Intersect ALL.mp4 (26.5 MB)
• 94 - Except.mp4 (14.0 MB)
• 95 - Union.mp4 (38.8 MB)
27 - Subqueries
• 96 - Part1 Subquery in WHERE clause.mp4 (25.7 MB)
• 97 - Part2 Subquery in FROM clause.mp4 (34.7 MB)
• 98 - Part3 Subquery in SELECT clause.mp4 (29.1 MB)
28 - Views and Indexes
• 100 - INDEX.mp4 (36.7 MB)
• 99 - VIEWS.mp4 (37.0 MB)
29 - String Functions
• 101 - LENGTH.mp4 (16.4 MB)
• 102 - UPPER LOWER.mp4 (10.0 MB)
• 103 - REPLACE.mp4 (24.2 MB)
• 104 - TRIM LTRIM RTRIM.mp4 (45.0 MB)
• 105 - CONCATENATION.mp4 (15.8 MB)
• 106 - SUBSTRING.mp4 (39.7 MB)
• 107 - LIST AGGREGATION.mp4 (30.8 MB)
3 - Essential Excel functions
• 10 - Basic Formula Operations.mp4 (134.7 MB)
• 11 - Mathematical Functions Part 1.mp4 (79.0 MB)
• 12 - Mathematical Functions Part 2.mp4 (64.7 MB)
• 13 - Difference between RANK RANKAVG and RANKEQ.html (0.7 KB)
• 14 - Textual Functions Part 1.mp4 (77.2 MB)
• 15 - Textual Functions Part 2.mp4 (73.3 MB)
• 16 - Logical Functions.mp4 (87.8 MB)
• 17 - DateTime Functions.mp4 (46.8 MB)
• 18 - Lookup Functions V Lookup Hlookup IndexMatch.mp4 (62.5 MB)
30 - Mathematical Functions
• 108 - CEIL FLOOR.mp4 (16.5 MB)
• 109 - RANDOM.mp4 (24.3 MB)
• 110 - SETSEED.mp4 (18.2 MB)
• 111 - ROUND.mp4 (13.7 MB)
• 112 - POWER.mp4 (10.8 MB)
31 - DateTime Functions 0. Websites you may like
• [CourseClub.Me].url (0.1 KB)
• [FreeCourseSite.com].url (0.1 KB)
• [GigaCourse.Com].url (0.0 KB)
• 113 - CURRENT DATE TIME.mp4 (28.5 MB)
• 114 - AGE.mp4 (23.8 MB)
• 115 - EXTRACT.mp4 (51.2 MB)
32 - PATTERN STRING MATCHING
• 116 - PATTERN MATCHING BASICS.mp4 (36.0 MB)
• 117 - ADVANCE PATTERN MATCHING REGULAR EXPRESSIONS Part 1.mp4 (50.1 MB)
• 118 - ADVANCE PATTERN MATCHING REGULAR EXPRESSIONS Part 2.mp4 (31.5 MB)
33 - Windows Functions
• 119 - Introduction to Window functions.mp4 (60.7 MB)
• 120 - Introduction to Row number.mp4 (39.5 MB)
• 121 - Implementing Row number in SQL.mp4 (186.9 MB)
• 122 - RANK and DENSERANK.mp4 (57.9 MB)
• 123 - NTILE function.mp4 (70.0 MB)
• 124 - AVERAGE function.mp4 (63.5 MB)
• 125 - COUNT.mp4 (34.0 MB)
• 126 - SUM TOTAL.mp4 (93.4 MB)
• 127 - RUNNING TOTAL.mp4 (68.1 MB)
• 128 - LAG and LEAD.mp4 (75.2 MB)
34 - COALESCE function
• 129 - COALESCE function.mp4 (45.2 MB)
35 - Data Type conversion functions
• 130 - Converting Numbers Date to String.mp4 (61.6 MB)
• 131 - Converting String to Numbers Date.mp4 (28.9 MB)
36 - User Access Control functions
• 132 - User Access Control 1 Grant and Revoke.mp4 (42.7 MB)
• 133 - User Access Control 2 Drop Alter users.mp4 (32.7 MB)
37 - Nail that Interview
• 134 - Tablespace.mp4 (31.1 MB)
• 135 - PRIMARY KEY FOREIGN KEY.mp4 (21.2 MB)
• 136 - ACID compliance.mp4 (38.0 MB)
• 137 - Truncate.mp4 (17.6 MB)
38 - Performance tuning tips
• 138 - TIP 1 EXPLAIN.mp4 (28.3 MB)
• 139 - TIP 2.mp4 (6.3 MB)
• 140 - TIP 3.mp4 (15.1 MB)
• 141 - TIP 4 VACCUM.mp4 (3.2 MB)
• 142 - TIP 5.mp4 (12.7 MB)
• 143 - TIP 6 STRING FUNCTIONS.mp4 (16.5 MB)
• 144 - TIP 7 JOINS.mp4 (12.4 MB)
• 145 - TIP 8 SCHEMAS.mp4 (36.9 MB)
39 - Database Basics
• 146 - What is SQL.mp4 (9.6 MB)
• 147 - Tables and DBMS.mp4 (16.2 MB)
• 148 - Types of SQL commands.mp4 (23.9 MB)
• 149 - PostgreSQL.mp4 (15.6 MB)
4 - Data Tools
• 19 - Data Tools Part 1.mp4 (90.2 MB)
• 20 - Data Tools Part 2.mp4 (48.7 MB)
40 - TABLEAU
• 150 - Introduction.mp4 (21.9 MB)
• 151 - Why Tableau.mp4 (19.7 MB)
• 152 - Tableau Products.mp4 (52.6 MB)
41 - Installation and getting started
• 153 - Installing Tableau desktop and Public.mp4 (36.2 MB)
• 154 - About the data.mp4 (133.9 MB)
• 155 - Connecting to data.mp4 (76.4 MB)
• 156 - Live vs Extract.mp4 (21.7 MB)
42 - Combining data to create Data model
• 157 - Combining data from multiple tables.mp4 (29.0 MB)
• 158 - Relationships in Tableau.mp4 (68.5 MB)
• 159 - Joins in Tableau.mp4 (37.5 MB)
• 160 - Types of Joins in Tableau.mp4 (36.3 MB)
• 161 - Union in Tableau.mp4 (53.5 MB)
• 162 - Physical Logical layer and Data models.mp4 (33.0 MB)
• 163 - The visualization screen Sheet.mp4 (47.4 MB)
43 - Data categorization in Tableau
• 164 - Types of Data Dimensions and Measures.mp4 (35.0 MB)
• 165 - Types of Data Discreet and Continuous.mp4 (28.2 MB)
• 166 - Changing Data type in Tableau.mp4 (52.1 MB)
44 - Most used charts
• 167 - Bar charts.mp4 (73.3 MB)
• 168 - Line charts.mp4 (52.6 MB)
• 169 - Scatterplots.mp4 (38.5 MB)
45 - Customizing charts using Marks shelf
• 170 - Marks cards.mp4 (82.9 MB)
• 171 - Dropping Dimensions and Measures on marks card.mp4 (63.1 MB)
• 172 - Dropping Dimensions on Line chart.mp4 (26.7 MB)
• 173 - Adding marks in scatterplot.mp4 (24.5 MB)
46 - Other important charts
• 174 - Text tables heat map and highlight tables.mp4 (47.6 MB)
• 175 - Pie charts.mp4 (46.5 MB)
• 176 - Area charts.mp4 (74.3 MB)
• 177 - Creating custom hierarchy.mp4 (26.1 MB)
• 178 - Tree map.mp4 (34.7 MB)
• 179 - Dual combination charts.mp4 (50.3 MB)
• 180 - Creating Bins.mp4 (30.7 MB)
• 181 - Histogram.mp4 (26.8 MB)
47 - Grouping and Filtering data
• 182 - Grouping Data.mp4 (52.6 MB)
• 183 - Filtering data.mp4 (56.3 MB)
• 184 - Dimension filters.mp4 (62.6 MB)
• 185 - Measure filters.mp4 (22.9 MB)
• 186 - DateTime filters.mp4 (50.7 MB)
• 187 - Filter options.mp4 (49.6 MB)
• 188 - Types of filters and order of operation.mp4 (71.3 MB)
• 189 - Customizing visual filters.mp4 (60.6 MB)
• 190 - Sorting options.mp4 (87.8 MB)
48 - Map chart in Tableau
• 191 - How to make a map chart.mp4 (49.7 MB)
• 192 - Considerations before making a Map chart.mp4 (24.2 MB)
• 193 - Marks card for customizing maps.mp4 (62.4 MB)
• 194 - Customizing maps using map menu.mp4 (95.3 MB)
• 195 - Layers in a Map.mp4 (69.9 MB)
• 196 - Visual toolbar on a map.mp4 (35.7 MB)
• 197 - Custom background images.mp4 (77.9 MB)
• 198 - Territories in maps.mp4 (44.0 MB)
• 199 - Data blending for missing geocoding.mp4 (83.6 MB)
49 - Calculations and Analytics
• 200 - Calculated fields in Tableau.mp4 (83.8 MB)
• 201 - Functions in Tableau.mp4 (12.0 MB)
• 202 - Table calculations theory.mp4 (37.3 MB)
• 203 - Table calculations in Tableau.mp4 (72.3 MB)
• 204 - Understanding LOD expressions.mp4 (155.5 MB)
• 205 - LOD expressions examples.mp4 (83.7 MB)
• 206 - Analytics pane.mp4 (125.4 MB)
5 - Formatting data and tables
• 21 - Formatting data and tables.mp4 (166.6 MB)
50 - Sets and Parameters
• 207 - Understanding sets in Tableau.mp4 (17.4 MB)
• 208 - Creating Sets in Tableau.mp4 (62.8 MB)
• 209 - Parameters.mp4 (98.1 MB)
51 - Dashboard and Story
• 210 - Dashboard part 1.mp4 (104.5 MB)
• 211 - Dashboard part 2.mp4 (82.2 MB)
• 212 - Story.mp4 (25.4 MB)
52 - Appendix
• 213 - Connecting to SQL data source.mp4 (36.4 MB)
• 214 - Connecting to cloud storage services.mp4 (19.1 MB)
53 - Congratulations and about your certificate
• 215 - The final milestone.mp4 (12.7 MB)
• 216 - Bonus lecture.html (2.4 KB)
6 - Pivot Tables
• 22 - Pivot Tables.mp4 (73.7 MB)
7 - Excel Charts
• 23 - Excel Charts Categories of messages that can be conveyed.mp4 (16.9 MB)
• 24 - Elements of charts.mp4 (27.5 MB)
• 25 - The Easy way of creating charts.mp4 (23.5 MB)
• 26 - Bar and column charts.mp4 (91.5 MB)
• 27 - Formatting charts Part 1.mp4 (69.8 MB)
• 28 - Formatting charts Part 2.mp4 (32.0 MB)
• 29 - Line Charts.mp4 (87.2 MB)
• 30 - Area Charts.mp4 (48.3 MB)
• 31 - Pie and Doughnut Charts.mp4 (104.5 MB)
• 32 - Why we should avoid Pie charts.mp4 (19.5 MB)
• 33 - Scatter plot or XY chart.mp4 (133.5 MB)
• 34 - Frequency Distribution and Histograms.mp4 (91.5 MB)
• 35 - Waterfall Charts.mp4 (77.6 MB)
• 36 - Hierarchy Charts Sunburst and Treemap.mp4 (70.7 MB)
• 37 - Combination charts.mp4 (61.7 MB)
• 38 - Sparklines.mp4 (42.4 MB)
8 - Pivot Charts 0. Websites you may like
• [CourseClub.Me].url (0.1 KB)
• [FreeCourseSite.com].url (0.1 KB)
• [GigaCourse.Com].url (0.0 KB)
• 39 - Pivot Charts.mp4 (47.1 MB)
9 - Special purpose charts
• 40 - Stock charts.mp4 (94.7 MB)
• 41 - Radar charts.mp4 (34.8 MB)
• 42 - Surface charts.mp4 (49.7 MB)
• 43 - Heatmaps.mp4 (40.5 MB)