FreeCourseSite com Udemy Become Data Analyst Excel SQL Tableau in Bundle

FreeCourseSite com Udemy Become Data Analyst Excel SQL Tableau in Bundle

Name	[FreeCourseSite.com] Udemy - Become a Data Analyst Excel, SQL & Tableau - 3-in-1 Bundle	DOWNLOAD Copy Link
Total Size	11.1 GB
Total Files	228
Last Seen	2024-10-05 23:47
Hash	C0ED0C3D85D8F5EBB5CFED54548AC1ECE3EE92E7

/0. Websites you may like/
[CourseClub.Me].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/1 - Introduction/
1 - Introduction.mp4	29.5 MB
/10 - Named Ranges/
44 - Named Ranges.mp4	68.5 MB
45 - Indirect Functions.mp4	37.6 MB
/11 - Excel Shortcuts/
46 - Shortcuts.mp4	108.8 MB
/12 - Macros/
47 - Macros.mp4	75.0 MB
/13 - Advanced Excel/
48 - Advanced Excel Analytics in Excel.mp4	128.9 MB
/14 - Creative Infographics/
49 - Infographic Example 1.mp4	122.3 MB
50 - Infographic Example 2.mp4	38.8 MB
/15 - SQL/
51 - Introduction.mp4	24.1 MB
/16 - Installation and getting started/
52 - Installing PostgreSQL and pgAdmin in your PC.mp4	87.5 MB
53 - If pgAdmin is not opening.html	1.6 KB
/17 - Case Study Demo/
54 - Case Study Part 1 Business problems.mp4	39.6 MB
55 - Case Study Part 2 How SQL is Used.mp4	61.8 MB
/18 - Fundamental SQL statements/
56 - CREATE.mp4	95.6 MB
57 - INSERT.mp4	76.6 MB
58 - Import data from File.mp4	44.0 MB
59 - SELECT statement.mp4	33.4 MB
60 - SELECT DISTINCT.mp4	48.5 MB
61 - WHERE.mp4	34.2 MB
62 - Logical Operators.mp4	53.0 MB
63 - UPDATE.mp4	40.1 MB
64 - DELETE.mp4	31.4 MB
65 - ALTER part 1.mp4	48.5 MB
66 - ALTER part 2.mp4	88.1 MB
/.../0. Websites you may like/
[CourseClub.Me].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/19 - Restore and Backup/
67 - Restore and Backup.mp4	85.4 MB
68 - Debugging restoration issues.mp4	56.2 MB
69 - Creating DB using CSV files.mp4	40.3 MB
70 - Debugging summary and Code for CSV files.html	2.2 KB
/2 - Excel Basics/
2 - Getting started with Excel.mp4	54.6 MB
3 - Course Resources.html	0.4 KB
4 - This is a milestone.mp4	22.9 MB
5 - Worksheet basics.mp4	98.1 MB
6 - Entering values and Formulas.mp4	40.1 MB
7 - Data Formats.mp4	51.1 MB
8 - Data Handling Basics Cut Copy Paste.mp4	94.1 MB
9 - Saving and Printing in Excel.mp4	54.7 MB
/20 - Selection commands Filtering/
71 - IN.mp4	31.1 MB
72 - BETWEEN.mp4	54.8 MB
73 - LIKE.mp4	76.2 MB
/21 - Selection commands Ordering/
74 - Side Lecture Commenting in SQL.mp4	13.8 MB
75 - ORDER BY.mp4	76.4 MB
76 - LIMIT.mp4	30.7 MB
/22 - Alias/
77 - AS.mp4	28.7 MB
/23 - Aggregate Commands/
78 - COUNT.mp4	46.1 MB
79 - SUM.mp4	27.3 MB
80 - AVERAGE.mp4	22.2 MB
81 - MIN MAX.mp4	33.8 MB
/24 - Group By Commands/
82 - GROUP BY.mp4	109.8 MB
83 - HAVING.mp4	40.6 MB
/25 - Conditional Statement/
84 - CASE WHEN.mp4	36.8 MB
/26 - JOINS/
85 - Introductions to Joins.mp4	9.0 MB
86 - Concepts of Joining and Combining Data.mp4	68.2 MB
87 - Preparing the data.mp4	16.4 MB
88 - Inner Join.mp4	53.6 MB
89 - Left Join.mp4	42.0 MB
90 - Right Join.mp4	40.8 MB
91 - Full Outer Join.mp4	35.9 MB
92 - Cross Join.mp4	21.2 MB
93 - Intersect and Intersect ALL.mp4	27.8 MB
94 - Except.mp4	14.6 MB
95 - Union.mp4	40.6 MB
/27 - Subqueries/
96 - Part1 Subquery in WHERE clause.mp4	26.9 MB
97 - Part2 Subquery in FROM clause.mp4	36.4 MB
98 - Part3 Subquery in SELECT clause.mp4	30.5 MB
/28 - Views and Indexes/
100 - INDEX.mp4	38.5 MB
99 - VIEWS.mp4	38.8 MB
/29 - String Functions/
101 - LENGTH.mp4	17.2 MB
102 - UPPER LOWER.mp4	10.4 MB
103 - REPLACE.mp4	25.3 MB
104 - TRIM LTRIM RTRIM.mp4	47.1 MB
105 - CONCATENATION.mp4	16.6 MB
106 - SUBSTRING.mp4	41.6 MB
107 - LIST AGGREGATION.mp4	32.3 MB
/3 - Essential Excel functions/
10 - Basic Formula Operations.mp4	141.2 MB
11 - Mathematical Functions Part 1.mp4	82.8 MB
12 - Mathematical Functions Part 2.mp4	67.8 MB
13 - Difference between RANK RANKAVG and RANKEQ.html	0.8 KB
14 - Textual Functions Part 1.mp4	81.0 MB
15 - Textual Functions Part 2.mp4	76.9 MB
16 - Logical Functions.mp4	92.0 MB
17 - DateTime Functions.mp4	49.1 MB
18 - Lookup Functions V Lookup Hlookup IndexMatch.mp4	65.5 MB
/30 - Mathematical Functions/
108 - CEIL FLOOR.mp4	17.3 MB
109 - RANDOM.mp4	25.4 MB
110 - SETSEED.mp4	19.1 MB
111 - ROUND.mp4	14.4 MB
112 - POWER.mp4	11.3 MB
/.../0. Websites you may like/
[CourseClub.Me].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/31 - DateTime Functions/
113 - CURRENT DATE TIME.mp4	29.9 MB
114 - AGE.mp4	24.9 MB
115 - EXTRACT.mp4	53.7 MB
/32 - PATTERN STRING MATCHING/
116 - PATTERN MATCHING BASICS.mp4	37.8 MB
117 - ADVANCE PATTERN MATCHING REGULAR EXPRESSIONS Part 1.mp4	52.5 MB
118 - ADVANCE PATTERN MATCHING REGULAR EXPRESSIONS Part 2.mp4	33.1 MB
/33 - Windows Functions/
119 - Introduction to Window functions.mp4	63.7 MB
120 - Introduction to Row number.mp4	41.5 MB
121 - Implementing Row number in SQL.mp4	195.9 MB
122 - RANK and DENSERANK.mp4	60.7 MB
123 - NTILE function.mp4	73.4 MB
124 - AVERAGE function.mp4	66.6 MB
125 - COUNT.mp4	35.7 MB
126 - SUM TOTAL.mp4	97.9 MB
127 - RUNNING TOTAL.mp4	71.4 MB
128 - LAG and LEAD.mp4	78.8 MB
/34 - COALESCE function/
129 - COALESCE function.mp4	47.4 MB
/35 - Data Type conversion functions/
130 - Converting Numbers Date to String.mp4	64.6 MB
131 - Converting String to Numbers Date.mp4	30.3 MB
/36 - User Access Control functions/
132 - User Access Control 1 Grant and Revoke.mp4	44.8 MB
133 - User Access Control 2 Drop Alter users.mp4	34.3 MB
/37 - Nail that Interview/
134 - Tablespace.mp4	32.6 MB
135 - PRIMARY KEY FOREIGN KEY.mp4	22.3 MB
136 - ACID compliance.mp4	39.9 MB
137 - Truncate.mp4	18.4 MB
/38 - Performance tuning tips/
138 - TIP 1 EXPLAIN.mp4	29.7 MB
139 - TIP 2.mp4	6.6 MB
140 - TIP 3.mp4	15.9 MB
141 - TIP 4 VACCUM.mp4	3.3 MB
142 - TIP 5.mp4	13.4 MB
143 - TIP 6 STRING FUNCTIONS.mp4	17.3 MB
144 - TIP 7 JOINS.mp4	13.0 MB
145 - TIP 8 SCHEMAS.mp4	38.7 MB
/39 - Database Basics/
146 - What is SQL.mp4	10.0 MB
147 - Tables and DBMS.mp4	17.0 MB
148 - Types of SQL commands.mp4	25.1 MB
149 - PostgreSQL.mp4	16.3 MB
/4 - Data Tools/
19 - Data Tools Part 1.mp4	94.6 MB
20 - Data Tools Part 2.mp4	51.1 MB
/40 - TABLEAU/
150 - Introduction.mp4	22.9 MB
151 - Why Tableau.mp4	20.6 MB
152 - Tableau Products.mp4	55.1 MB
/41 - Installation and getting started/
153 - Installing Tableau desktop and Public.mp4	37.9 MB
154 - About the data.mp4	140.4 MB
155 - Connecting to data.mp4	80.1 MB
156 - Live vs Extract.mp4	22.8 MB
/42 - Combining data to create Data model/
157 - Combining data from multiple tables.mp4	30.4 MB
158 - Relationships in Tableau.mp4	71.9 MB
159 - Joins in Tableau.mp4	39.4 MB
160 - Types of Joins in Tableau.mp4	38.0 MB
161 - Union in Tableau.mp4	56.1 MB
162 - Physical Logical layer and Data models.mp4	34.6 MB
163 - The visualization screen Sheet.mp4	49.7 MB
/43 - Data categorization in Tableau/
164 - Types of Data Dimensions and Measures.mp4	36.7 MB
165 - Types of Data Discreet and Continuous.mp4	29.5 MB
166 - Changing Data type in Tableau.mp4	54.6 MB
/44 - Most used charts/
167 - Bar charts.mp4	76.9 MB
168 - Line charts.mp4	55.1 MB
169 - Scatterplots.mp4	40.4 MB
/45 - Customizing charts using Marks shelf/
170 - Marks cards.mp4	86.9 MB
171 - Dropping Dimensions and Measures on marks card.mp4	66.2 MB
172 - Dropping Dimensions on Line chart.mp4	28.0 MB
173 - Adding marks in scatterplot.mp4	25.7 MB
/46 - Other important charts/
174 - Text tables heat map and highlight tables.mp4	49.9 MB
175 - Pie charts.mp4	48.8 MB
176 - Area charts.mp4	77.9 MB
177 - Creating custom hierarchy.mp4	27.3 MB
178 - Tree map.mp4	36.4 MB
179 - Dual combination charts.mp4	52.8 MB
180 - Creating Bins.mp4	32.2 MB
181 - Histogram.mp4	28.1 MB
/47 - Grouping and Filtering data/
182 - Grouping Data.mp4	55.1 MB
183 - Filtering data.mp4	59.0 MB
184 - Dimension filters.mp4	65.7 MB
185 - Measure filters.mp4	24.0 MB
186 - DateTime filters.mp4	53.2 MB
187 - Filter options.mp4	52.0 MB
188 - Types of filters and order of operation.mp4	74.8 MB
189 - Customizing visual filters.mp4	63.6 MB
190 - Sorting options.mp4	92.1 MB
/48 - Map chart in Tableau/
191 - How to make a map chart.mp4	52.2 MB
192 - Considerations before making a Map chart.mp4	25.4 MB
193 - Marks card for customizing maps.mp4	65.4 MB
194 - Customizing maps using map menu.mp4	99.9 MB
195 - Layers in a Map.mp4	73.3 MB
196 - Visual toolbar on a map.mp4	37.5 MB
197 - Custom background images.mp4	81.7 MB
198 - Territories in maps.mp4	46.1 MB
199 - Data blending for missing geocoding.mp4	87.7 MB
/49 - Calculations and Analytics/
200 - Calculated fields in Tableau.mp4	87.9 MB
201 - Functions in Tableau.mp4	12.6 MB
202 - Table calculations theory.mp4	39.1 MB
203 - Table calculations in Tableau.mp4	75.8 MB
204 - Understanding LOD expressions.mp4	163.1 MB
205 - LOD expressions examples.mp4	87.7 MB
206 - Analytics pane.mp4	131.5 MB
/5 - Formatting data and tables/
21 - Formatting data and tables.mp4	174.7 MB
/50 - Sets and Parameters/
207 - Understanding sets in Tableau.mp4	18.2 MB
208 - Creating Sets in Tableau.mp4	65.8 MB
209 - Parameters.mp4	102.9 MB
/51 - Dashboard and Story/
210 - Dashboard part 1.mp4	109.6 MB
211 - Dashboard part 2.mp4	86.2 MB
212 - Story.mp4	26.7 MB
/52 - Appendix/
213 - Connecting to SQL data source.mp4	38.2 MB
214 - Connecting to cloud storage services.mp4	20.0 MB
/53 - Congratulations and about your certificate/
215 - The final milestone.mp4	13.3 MB
216 - Bonus lecture.html	2.4 KB
/6 - Pivot Tables/
22 - Pivot Tables.mp4	77.3 MB
/7 - Excel Charts/
23 - Excel Charts Categories of messages that can be conveyed.mp4	17.7 MB
24 - Elements of charts.mp4	28.9 MB
25 - The Easy way of creating charts.mp4	24.6 MB
26 - Bar and column charts.mp4	96.0 MB
27 - Formatting charts Part 1.mp4	73.2 MB
28 - Formatting charts Part 2.mp4	33.5 MB
29 - Line Charts.mp4	91.4 MB
30 - Area Charts.mp4	50.7 MB
31 - Pie and Doughnut Charts.mp4	109.5 MB
32 - Why we should avoid Pie charts.mp4	20.5 MB
33 - Scatter plot or XY chart.mp4	140.0 MB
34 - Frequency Distribution and Histograms.mp4	95.9 MB
35 - Waterfall Charts.mp4	81.3 MB
36 - Hierarchy Charts Sunburst and Treemap.mp4	74.2 MB
37 - Combination charts.mp4	64.7 MB
38 - Sparklines.mp4	44.5 MB
/.../0. Websites you may like/
[CourseClub.Me].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/8 - Pivot Charts/
39 - Pivot Charts.mp4	49.4 MB
/9 - Special purpose charts/
40 - Stock charts.mp4	99.2 MB
41 - Radar charts.mp4	36.4 MB
42 - Surface charts.mp4	52.1 MB
43 - Heatmaps.mp4	42.5 MB
Total files 228