38 - Transforming data for improved analysis.mp4 (63.73 MB)
MP4
39 - Techniques for data transformation Part 1.mp4 (32.72 MB)
MP4
40 - Techniques for data transformation Part 2.mp4 (49.57 MB)
MP4
41 - Consideration for effective data transformation.mp4 (15.63 MB)
MP4
42 - ML for data analysis and decisionmaking.mp4 (32.37 MB)
MP4
43 - Widely used ML methods in the data analytics.mp4 (67.86 MB)
MP4
44 - Steps in developing machine learning model.mp4 (41.55 MB)
MP4
45 - Visualizing data for the best insight delivery.mp4 (20.1 MB)
MP4
46 - Several methods of data visualization Part 1.mp4 (13.97 MB)
MP4
47 - Several methods of data visualization Part 2.mp4 (27.24 MB)
MP4
48 - Several methods of data visualization Part 3.mp4 (34.63 MB)
MP4
49 - Considerations for effective data visualization.mp4 (18.98 MB)
MP4
52 - Identifying and removing duplicates.mp4 (57.78 MB)
MP4
53 - Dealing with missing values.mp4 (143.8 MB)
MP4
54 - Dealing with outliers.mp4 (117.38 MB)
MP4
55 - Finding and imputing inconsistent values.mp4 (79.68 MB)
MP4
56 - Texttocolumns for data separation.mp4 (39.28 MB)
MP4
57 - Applying sorts filters to narrow down data.mp4 (98.87 MB)
MP4
58 - Advanced filtering with custom criteria.mp4 (69.23 MB)
MP4
59 - Highlighting cells based on criteria.mp4 (116.39 MB)
MP4
60 - Findings top and bottom insights.mp4 (64.02 MB)
MP4
61 - Creating color scales and color bars.mp4 (107.01 MB)
MP4
62 - SUM AVERAGE MIN and MAX functions.mp4 (176.83 MB)
MP4
63 - SUMIF and AVERAGEIF functions.mp4 (112.2 MB)
MP4
64 - COUNT COUNTA and COUNTIF functions.mp4 (107.88 MB)
MP4
65 - YEAR MONTH and DAY for date manipulation.mp4 (70.18 MB)
MP4
66 - IF STATEMENTs for conditional operation.mp4 (166.31 MB)
MP4
67 - VLOOKUP for columnwise insight search.mp4 (77.92 MB)
MP4
68 - HLOOKUP for rowwise insight search.mp4 (64.2 MB)
MP4
69 - XLOOKUP for robust complex insight search.mp4 (89.81 MB)
MP4
70 - Analyze data with Stacked and cluster bar charts.mp4 (192.93 MB)
MP4
71 - Analyze data with Pie chart and line chart.mp4 (82.07 MB)
MP4
72 - Analyze data with Area chart and TreeMap.mp4 (100.31 MB)
MP4
73 - Analyze data with Boxplot and Histogram.mp4 (42.54 MB)
MP4
74 - Analyze data with Scatter plot and Combo chart.mp4 (49.21 MB)
MP4
75 - Adjusting and decorating graphs and charts.mp4 (59.44 MB)
MP4
76 - PivotTables for GROUP data analysis PART 1.mp4 (123.98 MB)
MP4
77 - PivotTables for CROSSTAB data analysis PART 2.mp4 (52.25 MB)
MP4
78 - PivotCharts and Slicers for interactivity.mp4 (77.19 MB)
MP4
3 - Data analysis definition types and examples.mp4 (46.72 MB)
MP4
4 - Key components of data analysis.mp4 (60.97 MB)
MP4
5 - Tools and technologies for data analysis.mp4 (106.05 MB)
MP4
6 - Realworld application of data analysis.mp4 (39.22 MB)
MP4
79 - Descriptive statistics and analysis.mp4 (65.13 MB)
MP4
80 - Independent sample ttest for two samples.mp4 (87.7 MB)
MP4
81 - Paired sample ttest for two samples.mp4 (53.98 MB)
MP4
82 - Analysis of variance One way ANOVA.mp4 (93.33 MB)
MP4
83 - Correlation analysis for relationship.mp4 (90 MB)
MP4
84 - Multiple linear regression analysis.mp4 (144.65 MB)
MP4
85 - Accumulating relevant information.mp4 (112.41 MB)
MP4
86 - Creating a canvas for dashboard.mp4 (53.85 MB)
MP4
87 - Developing the complete dashboard.mp4 (72.61 MB)
MP4
88 - Final touch up for dashboard decoration.mp4 (72.05 MB)
MP4
91 - RDBMS example and importance.mp4 (37.07 MB)
MP4
92 - Key features of RDBMS.mp4 (19.63 MB)
MP4
93 - Primary key vs Foreign key.mp4 (21.33 MB)
MP4
94 - Types of relationship in RDBMS.mp4 (16.95 MB)
MP4
95 - Data types in RDBMS.mp4 (21.19 MB)
MP4
96 - Introduction to SQL language.mp4 (13.47 MB)
MP4
97 - Various platforms of SQL.mp4 (18.48 MB)
MP4
99 - Loading CSV dataset in MySQL.mp4 (74.25 MB)
MP4
100 - Creating database.mp4 (10.27 MB)
MP4
101 - Selecting database.mp4 (5.04 MB)
MP4
102 - Modifying database.mp4 (36.48 MB)
MP4
103 - Deleting database.mp4 (20.42 MB)
MP4
105 - SELECTFROM select data from table.mp4 (24.57 MB)
MP4
106 - DISTINCT selecting unique values for column.mp4 (25.72 MB)
MP4
107 - AS selecting columns based on aliases.mp4 (41.99 MB)
MP4
108 - WHERE selecting data based on condition.mp4 (28.84 MB)
MP4
110 - CREATE creating table.mp4 (19.11 MB)
MP4
111 - NOT NULL limiting null values.mp4 (16.03 MB)
MP4
112 - UNIQUE limiting duplicates.mp4 (17.48 MB)
MP4
113 - INSERT INTO adding values in columns.mp4 (23.26 MB)
MP4
114 - UPDATE updating values based on condition.mp4 (21.99 MB)
MP4
115 - DELETE deleting values based on condition.mp4 (16.97 MB)
MP4
116 - TRUNCATE deleting all the values except table.mp4 (10.63 MB)
MP4
117 - DROP removing entire table.mp4 (10.7 MB)
MP4
118 - CHECK limiting specific values in columns.mp4 (33.56 MB)
MP4
7 - Various sources of collecting data.mp4 (43.08 MB)
MP4
8 - Population vs sample and its methods.mp4 (87.67 MB)
MP4
9 - Consideration for effective data collection.mp4 (23.13 MB)
MP4
120 - ADD COLUMN adding new column.mp4 (16.37 MB)
MP4
121 - MODIFY COLUMN replacing data types.mp4 (14.97 MB)
MP4
122 - RENAME COLUMN changing column names.mp4 (22.16 MB)
MP4
123 - DROP COLUMN deleting columns.mp4 (11.95 MB)
MP4
124 - ADD CONSTRAINT adding primary key.mp4 (30.89 MB)
MP4
125 - ADD CONSTRAINTREFERENCES adding foreign key.mp4 (43.95 MB)
MP4
126 - DROP CONSTRAINT deleting keys.mp4 (9.67 MB)
MP4
128 - CREATE INDEX creating new index.mp4 (19.25 MB)
MP4
129 - CREATE UNIQUE INDEX creating index without duplicates.mp4 (16.58 MB)
MP4
130 - DROP INDEX deleting existing index.mp4 (7.92 MB)
MP4
132 - IS NULL filtering the actual values out.mp4 (22.96 MB)
MP4
133 - IS NOT NULL filtering the missing values out.mp4 (16.01 MB)
MP4
135 - AND combining two or more conditions.mp4 (23.34 MB)
MP4
136 - OR flexible logical operator.mp4 (14.48 MB)
MP4
137 - NOT excluding values from filteration.mp4 (24.73 MB)
MP4
138 - BETWEENAND filtering ranges of values.mp4 (31.19 MB)
MP4
139 - LIKE filtering based on pattern.mp4 (44.26 MB)
MP4
140 - IN precise logic for multiple conditions.mp4 (20.04 MB)
MP4
141 - LIMIT filtering with limited data.mp4 (19.52 MB)
MP4
143 - CHARLENGTH finding the length of text.mp4 (24.37 MB)
MP4
144 - CONCAT adding different strings together.mp4 (25.78 MB)
MP4
145 - LOWER converting into lowercase.mp4 (19.56 MB)
MP4
146 - UPPER converting into uppercase.mp4 (10.96 MB)
MP4
147 - TRIM removing unnecessary gaps.mp4 (19.73 MB)
MP4
148 - REPLACE replacing old value by new value.mp4 (20.86 MB)
MP4
150 - ABS negative to positive value.mp4 (25.71 MB)
MP4
151 - SUM calculating the total value.mp4 (10.49 MB)
MP4
152 - AVG calculating the average value.mp4 (7.56 MB)
MP4
153 - COUNT counting total items.mp4 (14.7 MB)
MP4
154 - DIV dividing numeric data.mp4 (24.37 MB)
MP4
155 - MIN finding the lowest value.mp4 (6.17 MB)
MP4
156 - MAX finding the highest value.mp4 (6.62 MB)
MP4
158 - POWER multiple multiplications.mp4 (19.06 MB)
MP4
159 - ROUND decreasing the decimals.mp4 (30.06 MB)
MP4
160 - SQRT and LOG transformation functions.mp4 (20.27 MB)
MP4
162 - DATEFORMAT formatting the date shape.mp4 (33.42 MB)
MP4
163 - DATEDIFF finding the date difference.mp4 (14.6 MB)
MP4
164 - DAYMONTHYEAR extracting parts of dates.mp4 (17.12 MB)
MP4
166 - ORDER BY sorting data based on a column.mp4 (22.77 MB)
MP4
167 - GROUP BY group data analysis with functions.mp4 (65.39 MB)
MP4
169 - INNER JOIN joining on common values.mp4 (53.46 MB)
MP4
170 - LEFT JOIN joining on left table values.mp4 (34.26 MB)
MP4
171 - RIGHT JOIN joining on right table values.mp4 (29.46 MB)
MP4
172 - CROSS JOIN joining all values from tables.mp4 (32.53 MB)
MP4
10 - Why you cannot ignore cleaning your data.mp4 (31.71 MB)
MP4
11 - Various aspects of data cleaning.mp4 (168.49 MB)
MP4
12 - Consideration for effective data cleaning.mp4 (29.16 MB)
MP4
174 - HAVING advanced conditional format.mp4 (53.1 MB)
MP4
175 - EXISTS nested filtering between tables.mp4 (41.39 MB)
MP4
176 - ANY nested filtering between tables.mp4 (42.14 MB)
MP4
177 - CASE finding the conditional outcomes.mp4 (31.88 MB)
MP4
179 - SQL comments systems.mp4 (10.89 MB)
MP4
180 - Storing and executing procedures.mp4 (27.01 MB)
MP4
188 - Getting started with first python code.mp4 (11.28 MB)
MP4
189 - Assigning variable names correctly.mp4 (28.76 MB)
MP4
190 - Various data types and data structures.mp4 (29.81 MB)
MP4
191 - Converting and casting data types.mp4 (36.47 MB)
MP4
193 - Arithmetic operators.mp4 (32.26 MB)
MP4
194 - Comparison operators.mp4 (37 MB)
MP4
195 - Logical operators and or not.mp4 (39.92 MB)
MP4
197 - Lists creation indexing slicing modifying.mp4 (83.55 MB)
MP4
198 - Sets unique elements operations.mp4 (28.88 MB)
MP4
199 - Dictionaries keyvalue pairs methods.mp4 (45.16 MB)
MP4
201 - Conditional statements if elif else.mp4 (19.89 MB)
MP4
202 - Nested logical expressions in conditions.mp4 (47.44 MB)
MP4
203 - Looping structures for loops while loops.mp4 (33.96 MB)
MP4
204 - Defining creating and calling functions.mp4 (16.37 MB)
MP4
206 - Preparing notebook and loading data.mp4 (43.13 MB)
MP4
207 - Identifying missing or null values.mp4 (22.21 MB)
MP4
208 - Method of missing value imputation.mp4 (60.17 MB)
MP4
209 - Exploring data types in a dataframe.mp4 (36.7 MB)
MP4
210 - Dealing with inconsistent values.mp4 (36.44 MB)
MP4
211 - Assigning correct data types.mp4 (23.26 MB)
MP4
212 - Dealing with duplicated values.mp4 (20.6 MB)
MP4
214 - Sorting data by column and order.mp4 (26.54 MB)
MP4
215 - Filtering data with boolean indexing.mp4 (42.5 MB)
MP4
216 - Query method for precise filtering.mp4 (36.25 MB)
MP4
217 - Filtering data with isin method.mp4 (29.5 MB)
MP4
218 - Slicing dataframe with loc and iloc.mp4 (52.85 MB)
MP4
219 - Filtering data for many conditions.mp4 (30.06 MB)
MP4
13 - Various aspects of Joining datasets.mp4 (71.76 MB)
MP4
14 - Adding extra data with concatenation.mp4 (46.46 MB)
MP4
221 - Joining dataframes horizontally.mp4 (32.96 MB)
MP4
222 - Concatenate dataframes vertically.mp4 (58.75 MB)
MP4
224 - Frequency and percentage analysis.mp4 (25.13 MB)
MP4
225 - Descriptive statistics and analysis.mp4 (58.19 MB)
MP4
226 - Group by data analysis method.mp4 (36.93 MB)
MP4
227 - Pivot table analysis all in one.mp4 (51.91 MB)
MP4
228 - Crosstabulation analysis method.mp4 (23.98 MB)
MP4
229 - Correlation analysis for numeric data.mp4 (50.74 MB)
MP4
231 - Understanding visualisation tools.mp4 (11.7 MB)
MP4
232 - Getting started with bar charts.mp4 (67.44 MB)
MP4
233 - Stacked and clustered bar charts.mp4 (37.09 MB)
MP4
234 - Pie chart for percentage analysis.mp4 (22.75 MB)
MP4
235 - Line chart for grouping data analysis.mp4 (41.14 MB)
MP4
236 - Exploring distribution with histogram.mp4 (42.18 MB)
MP4
237 - Correlation analysis via scatterplot.mp4 (40.74 MB)
MP4
238 - Matrix visualisation with heatmap.mp4 (36.96 MB)
MP4
239 - Boxplot statistical visualisation method.mp4 (34.15 MB)
MP4
241 - Investigating distribution of numeric data.mp4 (92 MB)
MP4
242 - Shapiro Wilk test of normality.mp4 (31.63 MB)
MP4
243 - Starting with square root transformation.mp4 (61.71 MB)
MP4
244 - Logarithmic transformation method.mp4 (45.62 MB)
MP4
245 - Boxcox power transformation method.mp4 (45.24 MB)
MP4
246 - YeoJohnson power transformation method.mp4 (61.86 MB)
MP4
248 - One sample ttest.mp4 (42.52 MB)
MP4
249 - Independent sample ttest.mp4 (59.56 MB)
MP4
250 - One way Analysis of Variance.mp4 (89.46 MB)
MP4
251 - Chi square test for independence.mp4 (29.96 MB)
MP4
252 - Pearson correlation analysis.mp4 (61.89 MB)
MP4
253 - Linear regression analysis.mp4 (80.1 MB)
MP4
255 - Generating new features.mp4 (25.05 MB)
MP4
256 - Extracting day month and year.mp4 (54.92 MB)
MP4
257 - Encoding features LabelEncoder.mp4 (21.12 MB)
MP4
258 - Categorizing numeric feature.mp4 (45.26 MB)
MP4
259 - Manual feature encoding.mp4 (37.35 MB)
MP4
260 - Converting features into dummy.mp4 (28.44 MB)
MP4
262 - Selecting features and target.mp4 (64.18 MB)
MP4
263 - Scaling features StandardScaler.mp4 (22.03 MB)
MP4
264 - Scaling features MinMaxScaler.mp4 (22.38 MB)
MP4
265 - Dimensionality reduction with PCA.mp4 (61.18 MB)
MP4
266 - Splitting into train and test set.mp4 (43.5 MB)
MP4
268 - Linear regression ML model.mp4 (35.42 MB)
MP4
269 - Decision tree regressor ML model.mp4 (29.55 MB)
MP4
270 - Random forest regressor ML model.mp4 (35.99 MB)
MP4
272 - Logistic regression ML model.mp4 (46.94 MB)
MP4
273 - Decision tree classification ML model.mp4 (39.7 MB)
MP4
274 - Random forest classification ML model.mp4 (24.45 MB)
MP4
276 - Calculating within cluster sum of squares.mp4 (24.14 MB)
MP4
277 - Selecting optimal number of clusters.mp4 (13.71 MB)
MP4
278 - Application of KMeans machine learning.mp4 (39.46 MB)
MP4
15 - EDA for generating significant insights.mp4 (31.75 MB)
MP4
16 - Methods of exploratory data analysis Part 1.mp4 (124.69 MB)
MP4
17 - Methods of exploratory data analysis Part 2.mp4 (129.48 MB)
MP4
18 - Methods of exploratory data analysis Part 3.mp4 (67.38 MB)
MP4
19 - Consideration for effective EDA.mp4 (33.33 MB)
MP4
282 - ModuleNotFound error.mp4 (8.62 MB)
MP4
283 - Syntax error.mp4 (6.33 MB)
MP4
284 - Key error.mp4 (4.93 MB)
MP4
285 - Index error.mp4 (4.47 MB)
MP4
286 - Attribute error.mp4 (5.33 MB)
MP4
287 - Value error.mp4 (8.28 MB)
MP4
288 - Type error.mp4 (5.38 MB)
MP4
290 - Diagnosing errors.mp4 (39.05 MB)
MP4
291 - Debugging errors.mp4 (23.95 MB)
MP4
292 - Enhancing codes.mp4 (27.67 MB)
MP4
20 - The application of statistical test.mp4 (46.61 MB)
MP4
21 - Types of statistical data analysis.mp4 (32.01 MB)
MP4
22 - Statistical test vs Exploratory data analysis.mp4 (15.69 MB)
MP4
23 - A Recap on descriptive statistics methods.mp4 (11.22 MB)
MP4
24 - Inferential statistics Part 1 Ttests and ANOVA.mp4 (23.95 MB)
MP4
25 - Inferential statistics Part 2 Relationships measures.mp4 (16.63 MB)
MP4
26 - Inferential statistics Part 3 Linear regression.mp4 (142.65 MB)
MP4
27 - Consideration for effective statistical analysis.mp4 (20.73 MB)
MP4
28 - Probability in data analysis.mp4 (72.86 MB)
MP4
29 - Classical probability.mp4 (26.39 MB)
MP4
30 - Empirical probability.mp4 (23.65 MB)
MP4
31 - Conditional probability.mp4 (37.16 MB)
MP4
32 - Joint probability.mp4 (39.4 MB)
MP4
33 - Hypothesis testing for inferential statistics.mp4 (33.33 MB)
MP4
34 - Selecting statistical test and assumption testing.mp4 (59.7 MB)
MP4
35 - Confidence level significance level pvalue.mp4 (10.5 MB)
MP4
36 - Making decision and conclusion on findings.mp4 (9.8 MB)
MP4
37 - Complete statistical analysis and hypothesis testing.mp4 (36.95 MB)
MP4