FreeCourseSite com Udemy Complete Data Analyst Bootcamp From Basics To Advanced

FreeCourseSite com Udemy Complete Data Analyst Bootcamp From Basics To Advanced

Name	[FreeCourseSite.com] Udemy - Complete Data Analyst Bootcamp From Basics To Advanced	DOWNLOAD Copy Link
Total Size	26.2 GB
Total Files	1141
Last Seen	2025-02-20 00:29
Hash	C6AA48FFF22211FEAC719E2FB38A280838D84754

/0. Websites you may like/
[CourseClub.Me].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
/01. Introduction To The Course/
01. What Does A Data Analyst Do and Its Roadmap.mp4	29.2 MB
01. What Does A Data Analyst Do and Its Roadmap.vtt	25.3 KB
/assets/
01. roadmap.pdf	1.4 MB
/02. Getting Started With Python/
01. Getting Started With Google Colab.mp4	10.9 MB
01. Getting Started With Google Colab.vtt	10.9 KB
02. Installation Of Anaconda And Visual Studio Code.mp4	109.2 MB
02. Installation Of Anaconda And Visual Studio Code.vtt	17.8 KB
/03. Complete Python With Important Libraries/
01. Getting Started With VS Code With Environments.mp4	47.7 MB
01. Getting Started With VS Code With Environments.vtt	16.3 KB
02. Python Basics-Syntax And Semantics.mp4	143.8 MB
02. Python Basics-Syntax And Semantics.vtt	28.9 KB
03. Variables In Python.mp4	92.6 MB
03. Variables In Python.vtt	29.2 KB
04. Basic Data Types In Python.mp4	27.3 MB
04. Basic Data Types In Python.vtt	15.3 KB
05. Operators In Python.mp4	43.2 MB
05. Operators In Python.vtt	23.5 KB
06. Coding Excercise And Assignments.html	0.2 KB
07. Conditional Statements(if,elif,else).mp4	326.6 MB
07. Conditional Statements(if,elif,else).vtt	29.7 KB
08. Loops In Python.mp4	321.5 MB
08. Loops In Python.vtt	42.6 KB
09. Coding Excercise And Assignments.html	0.2 KB
10. List And List Comprehrension In Python.mp4	208.2 MB
10. List And List Comprehrension In Python.vtt	53.7 KB
11. List Practise Code And assignments.html	0.2 KB
12. Tuples In Python.mp4	82.7 MB
12. Tuples In Python.vtt	33.9 KB
13. Tuple Assignment And Practise Code.html	0.2 KB
14. Sets In Python.mp4	207.6 MB
14. Sets In Python.vtt	32.9 KB
15. Sets Assignment and Practise Code.html	0.2 KB
16. Dictionaries In Python.mp4	217.3 MB
16. Dictionaries In Python.vtt	51.9 KB
17. Dictionaries Assignments and PRactise Questions.html	0.2 KB
18. REal World Usecases Of List.mp4	39.7 MB
18. REal World Usecases Of List.vtt	15.1 KB
19. Getting Started With Functions.mp4	88.0 MB
19. Getting Started With Functions.vtt	35.1 KB
20. More Coding Examples With Functions.mp4	160.3 MB
20. More Coding Examples With Functions.vtt	41.4 KB
21. Lambda functions.mp4	60.9 MB
21. Lambda functions.vtt	15.4 KB
22. Map functions In Python.mp4	60.5 MB
22. Map functions In Python.vtt	16.7 KB
23. Filter Function In Python.mp4	51.0 MB
23. Filter Function In Python.vtt	13.3 KB
24. Function Assignments With Solution.html	0.0 KB
25. Import Modules And Packages In Python.mp4	55.7 MB
25. Import Modules And Packages In Python.vtt	26.5 KB
26. Standard Library Overview.mp4	146.9 MB
26. Standard Library Overview.vtt	26.5 KB
27. File Operation In Python.mp4	137.7 MB
27. File Operation In Python.vtt	25.8 KB
28. Working With File Paths.mp4	52.8 MB
28. Working With File Paths.vtt	11.7 KB
29. Exception Handling With Try Except else finally blocks.mp4	147.1 MB
29. Exception Handling With Try Except else finally blocks.vtt	38.3 KB
/assets/
02. 1.0-basic.ipynb	7.0 KB
03. 1.1-Variables.ipynb	9.2 KB
04. 1.2-Datatypes.ipynb	4.9 KB
05. 1.3-operators.ipynb	8.7 KB
06. assignment-solution.zip	3.3 KB
07. Conditionalstatements.ipynb	8.8 KB
08. Loops.ipynb	8.2 KB
09. assignment-solutions.zip	2.7 KB
10. 3.1-Lists.ipynb	14.1 KB
11. list-assignment-solution.zip	3.6 KB
12. 3.2-Tuples.ipynb	11.4 KB
13. tuple-assignment-solution.zip	2.9 KB
14. 3.3-Sets.ipynb	9.8 KB
15. set-assignments-solution.zip	2.9 KB
16. 3.4-Dictionaries.ipynb	12.7 KB
17. dictionaries-assignment-solution.ipynb	9.1 KB
18. 3.1.1-ListExamples.ipynb	5.5 KB
19. 4.1-functions.ipynb	7.3 KB
20. 4.2-examplesfunctions.ipynb	6.6 KB
21. 4.3-Lambda.ipynb	4.3 KB
22. 4.4-Mapsfunction.ipynb	4.3 KB
23. 4.5-filterfunction.ipynb	4.2 KB
24. functionsassignmentsoln.ipynb	10.6 KB
25. 5.1-import.ipynb	3.2 KB
26. 5.2-Standardlibrary.ipynb	6.0 KB
27. 6.1-fileoperation.ipynb	6.0 KB
28. 6.2-filepath.ipynb	4.5 KB
29. 7.1-exception.ipynb	7.6 KB
/04. Data Analysis With Python/
01. Numpy In Python.mp4	417.7 MB
01. Numpy In Python.vtt	43.3 KB
02. Pandas-DataFrame And Series.mp4	580.6 MB
02. Pandas-DataFrame And Series.vtt	44.0 KB
03. Data Manipulation With Pandas And Numpy.mp4	238.0 MB
03. Data Manipulation With Pandas And Numpy.vtt	38.8 KB
04. Numpy Assignments With solution.html	0.0 KB
05. Reading Data From Various Data Source Using Pandas.mp4	221.3 MB
05. Reading Data From Various Data Source Using Pandas.vtt	22.7 KB
06. Data Visulaization With Matplotlib.mp4	292.6 MB
06. Data Visulaization With Matplotlib.vtt	46.9 KB
07. Data Visualization With Seaborn.mp4	189.9 MB
07. Data Visualization With Seaborn.vtt	29.2 KB
/assets/
01. 10.1-numpy.ipynb	11.5 KB
02. 10.2-pandas.ipynb	39.7 KB
02. data.csv	1.9 KB
03. 10.3-datamanipulation.ipynb	62.9 KB
04. numpypandasassignments.zip	8.7 KB
05. 10.4-readdata.ipynb	31.5 KB
06. 10.5-matplotlib.ipynb	257.3 KB
07. 10.6-seaborn.ipynb	364.1 KB
/05. Getting Started With Statistics/
01. Introduction To Statistics.mp4	84.7 MB
01. Introduction To Statistics.vtt	12.8 KB
02. Types Of Statistics.mp4	134.6 MB
02. Types Of Statistics.vtt	16.7 KB
03. Population And Sample Data.mp4	218.4 MB
03. Population And Sample Data.vtt	18.1 KB
04. Types Of Sampling Techniques.mp4	211.0 MB
04. Types Of Sampling Techniques.vtt	25.0 KB
05. Types Of Data.mp4	73.0 MB
05. Types Of Data.vtt	12.9 KB
06. Scales Of Measurement Of Data.mp4	260.2 MB
06. Scales Of Measurement Of Data.vtt	28.0 KB
/assets/
01. 1-6-Stats.pdf	7.2 MB
/06. Descriptive Statistics/
01. Measure Of Central Tendency(Mean,Median And Mode).mp4	285.0 MB
01. Measure Of Central Tendency(Mean,Median And Mode).vtt	30.7 KB
02. Measures Of Dispersion(Range,Variance,Standard Deviation).mp4	267.4 MB
02. Measures Of Dispersion(Range,Variance,Standard Deviation).vtt	27.3 KB
03. Why Sample Variance is divided by n-1.mp4	48.3 MB
03. Why Sample Variance is divided by n-1.vtt	11.6 KB
04. Random Variables.mp4	85.8 MB
04. Random Variables.vtt	10.8 KB
05. Percentiles And Quartiles.mp4	110.6 MB
05. Percentiles And Quartiles.vtt	12.0 KB
06. 5 Number Summary.mp4	297.8 MB
06. 5 Number Summary.vtt	23.4 KB
07. Histogram And Skewness.mp4	244.2 MB
07. Histogram And Skewness.vtt	35.0 KB
08. Covariance And Correlation.mp4	451.2 MB
08. Covariance And Correlation.vtt	52.3 KB
/assets/
01. 1-Measure-Of-Central-Tendency.pdf	2.1 MB
02. 2-Measure-Of-Dispersion.pdf	2.2 MB
03. 3-Sample-Varianhce.png	673.3 KB
04. 4-Random-variable.pdf	1.1 MB
05. 5-Percentiles-And-Quartiles.pdf	1.1 MB
06. 6-5-number-summary.pdf	734.7 KB
07. 7-Histogram-And-skewness.pdf	1.4 MB
08. 8-Correlation-And-Coefficient.pdf	2.8 MB
/07. Probability Distribution Function And Types OF Distribution/
01. Pdf, PMF, CDF.mp4	388.4 MB
01. Pdf, PMF, CDF.vtt	41.6 KB
02. Types OF Probability Distribution.mp4	89.6 MB
02. Types OF Probability Distribution.vtt	11.4 KB
03. Bernoulli Distribution.mp4	287.7 MB
03. Bernoulli Distribution.vtt	33.5 KB
04. Binomial Distribution.mp4	143.1 MB
04. Binomial Distribution.vtt	20.5 KB
05. Poisson Distribution.mp4	160.8 MB
05. Poisson Distribution.vtt	19.4 KB
06. Normal or Gaussian Distribution.mp4	155.7 MB
06. Normal or Gaussian Distribution.vtt	19.5 KB
07. Standard Normal Distribution.mp4	249.8 MB
07. Standard Normal Distribution.vtt	20.5 KB
08. Uniform Distribution.mp4	145.1 MB
08. Uniform Distribution.vtt	19.4 KB
09. Log Normal Distribution.mp4	172.7 MB
09. Log Normal Distribution.vtt	13.9 KB
10. 10-Power Law Distribution.mp4	86.6 MB
10. 10-Power Law Distribution.vtt	10.4 KB
11. 11-Pareto Distribution.mp4	34.0 MB
11. 11-Pareto Distribution.vtt	8.1 KB
12. Central Limit Theorem.mp4	113.5 MB
12. Central Limit Theorem.vtt	16.0 KB
13. Estimates.mp4	41.1 MB
13. Estimates.vtt	8.2 KB
/assets/
01. 2-finalpdf-pmf-cdf.pdf	2.4 MB
03. 3-Bernoulli-Distribution.pdf	1.9 MB
04. 4-Binomial-Distribution.pdf	1.9 MB
05. 5-Poisson-Distribution.pdf	1.2 MB
06. 6-Normal-Guassian-Distribution.pdf	1.4 MB
07. 7-Standard-Normal-Distribution-And-Z-score.pdf	1.2 MB
08. 8-Uniform-Distribution.pdf	2.0 MB
09. 9-Log-Normal-Distribution.pdf	1.4 MB
10. 10-Power-Law-Distribution.pdf	1.3 MB
11. 11-Pareto-Distribution.pdf	1.3 MB
12. 12-Central-Limit-Theorem.pdf	1.4 MB
13. 13-Estimates.pdf	720.1 KB
/08. Inferential Stats And Hypothesis Testing/
01. Hypothesis Testing And Mechanism.mp4	79.4 MB
01. Hypothesis Testing And Mechanism.vtt	9.3 KB
02. P value And Hypothesis Testing.mp4	139.4 MB
02. P value And Hypothesis Testing.vtt	17.0 KB
03. Z test Hypothesis Testing.mp4	415.5 MB
03. Z test Hypothesis Testing.vtt	36.3 KB
04. Student t Distribution.mp4	58.3 MB
04. Student t Distribution.vtt	6.8 KB
05. T stats With T Test and Hypothesis Testing.mp4	160.9 MB
05. T stats With T Test and Hypothesis Testing.vtt	14.8 KB
06. Z test vs T test.mp4	17.3 MB
06. Z test vs T test.vtt	4.3 KB
07. Type1 And Type 2 Error.mp4	54.4 MB
07. Type1 And Type 2 Error.vtt	6.6 KB
08. Baye's Theorem.mp4	107.7 MB
08. Baye's Theorem.vtt	13.4 KB
09. Confidence Interval And Margin Of Error.mp4	94.3 MB
09. Confidence Interval And Margin Of Error.vtt	10.7 KB
10. What is Chi Square Test.mp4	89.1 MB
10. What is Chi Square Test.vtt	10.1 KB
11. Chi Square Goodness Of Fitness.mp4	133.3 MB
11. Chi Square Goodness Of Fitness.vtt	15.2 KB
12. What is Anova.mp4	23.8 MB
12. What is Anova.vtt	6.8 KB
13. Assumptions Of Anova.mp4	29.6 MB
13. Assumptions Of Anova.vtt	6.1 KB
14. Types Of Annova.mp4	83.5 MB
14. Types Of Annova.vtt	10.0 KB
15. Partioning OF Annova.mp4	492.1 MB
15. Partioning OF Annova.vtt	32.0 KB
/assets/
01. 1.0-Hypothesis-Testing-And-Mechanism.pdf	1.4 MB
02. 2.0-P-value.pdf	1.3 MB
03. 3-Z-test.pdf	2.8 MB
04. 4.0-sstudent-t-distribution.pdf	682.5 KB
05. 5.0-T-stats-t-test.pdf	1.4 MB
06. 6.0-ztestvsttest.pdf	575.7 KB
07. 7.0-type1-and-type-2-error.pdf	674.0 KB
08. 8.0-Bayes-theorem.pdf	1.4 MB
/09. Feature Engineering With Python/
01. Feature Engineering-Handling Missing Data.mp4	311.8 MB
01. Feature Engineering-Handling Missing Data.vtt	29.4 KB
02. Feature Engineering-Handling Imbalanced Dataset.mp4	141.1 MB
02. Feature Engineering-Handling Imbalanced Dataset.vtt	17.6 KB
03. Feature Engineering-SMOTE.mp4	289.1 MB
03. Feature Engineering-SMOTE.vtt	19.2 KB
04. Handling Outliers With Python.mp4	26.3 MB
04. Handling Outliers With Python.vtt	12.0 KB
05. Data Encoding-NominalOne Hot Encoding.mp4	76.6 MB
05. Data Encoding-NominalOne Hot Encoding.vtt	18.2 KB
06. Label And Ordinal Encoding.mp4	103.5 MB
06. Label And Ordinal Encoding.vtt	13.7 KB
07. Target Guided Ordinal Encoding.mp4	56.8 MB
07. Target Guided Ordinal Encoding.vtt	7.8 KB
/assets/
01. 1.0-Handling-Missing-values-1.ipynb	66.6 KB
02. 2.0-Handling-Imbalance-Dataset.ipynb	11.7 KB
03. 3.0-SMOTE.ipynb	174.6 KB
04. 4.0-Handling-Outliers.ipynb	27.4 KB
05. 5.0-Nominal-or-OHE.ipynb	26.4 KB
06. 7.0-Label-and-Ordinal.ipynb	26.4 KB
07. 8.0-Target-Guided-Ordinal-Encoding.ipynb	12.6 KB
/10. Exploratory Data Analysis/
01. Red Wine Dataset EDA.mp4	465.2 MB
01. Red Wine Dataset EDA.vtt	34.4 KB
02. EDA Flight Price Dataset.mp4	317.5 MB
02. EDA Flight Price Dataset.vtt	44.8 KB
03. Part 1-Data Cleaning Google Playstore Dataset.mp4	112.4 MB
03. Part 1-Data Cleaning Google Playstore Dataset.vtt	39.9 KB
04. Part 2-EDA Google Play Store Dataset.mp4	291.9 MB
04. Part 2-EDA Google Play Store Dataset.vtt	26.8 KB
/assets/
01. 1.0-WinequalityEDA.ipynb	429.8 KB
02. 2.0-EDA-And-FE-Flight-Price.ipynb	78.2 KB
02. flight-price.xlsx	530.4 KB
03. 3.0-EDA-And-FE-Google-Playstore.ipynb	942.4 KB
/11. SQL Course Introduction & Overview/
01. SQL Course Introduction.mp4	7.3 MB
01. SQL Course Introduction.vtt	4.2 KB
02. SQL Overview.mp4	93.2 MB
02. SQL Overview.vtt	14.4 KB
03. SQL Server Download & Install.mp4	51.3 MB
03. SQL Server Download & Install.vtt	5.1 KB
/assets/
02. Lec-62-SQL-Overview.txt	3.5 KB
03. Lec-63-SQL-Server-Download-Link.xlsx	9.4 KB
/12. Microsoft SQL Server basics/
01. SQL Select Statement.mp4	34.7 MB
01. SQL Select Statement.vtt	19.7 KB
02. SQL Select Distinct.mp4	17.2 MB
02. SQL Select Distinct.vtt	9.1 KB
03. SQL Temporary Tables.mp4	42.0 MB
03. SQL Temporary Tables.vtt	12.7 KB
04. SQL Where Clause.mp4	21.8 MB
04. SQL Where Clause.vtt	9.7 KB
05. SQL Order By Clause.mp4	20.6 MB
05. SQL Order By Clause.vtt	10.0 KB
06. SQL AND & OR Operator.mp4	31.3 MB
06. SQL AND & OR Operator.vtt	14.5 KB
07. SQL NOT, BETWEEN & IN Operators.mp4	42.5 MB
07. SQL NOT, BETWEEN & IN Operators.vtt	16.3 KB
08. SQL Insert Into.mp4	37.0 MB
08. SQL Insert Into.vtt	18.4 KB
09. SQL Null Operator.mp4	19.7 MB
09. SQL Null Operator.vtt	9.3 KB
10. SQL Update Statement.mp4	29.5 MB
10. SQL Update Statement.vtt	14.9 KB
11. Delete, Drop & Truncate.mp4	31.0 MB
11. Delete, Drop & Truncate.vtt	14.8 KB
12. SQL Comments & TOP N.mp4	20.1 MB
12. SQL Comments & TOP N.vtt	10.8 KB
13. SQL MAX & Group BY.mp4	74.6 MB
13. SQL MAX & Group BY.vtt	19.3 KB
14. SQL MIN Function & Group BY.mp4	24.7 MB
14. SQL MIN Function & Group BY.vtt	9.2 KB
15. SUM, AVG, COUNT & Group BY.mp4	97.2 MB
15. SUM, AVG, COUNT & Group BY.vtt	34.1 KB
16. Group BY Concept.mp4	31.0 MB
16. Group BY Concept.vtt	14.3 KB
17. Group BY Example SQL Server.mp4	17.9 MB
17. Group BY Example SQL Server.vtt	9.4 KB
18. SQL Having Clause.mp4	38.8 MB
18. SQL Having Clause.vtt	11.4 KB
19. SQL Where & Having Clause Difference.mp4	24.3 MB
19. SQL Where & Having Clause Difference.vtt	11.8 KB
20. Inner Join Concept.mp4	35.2 MB
20. Inner Join Concept.vtt	18.3 KB
21. Inner Join Eample.mp4	55.9 MB
21. Inner Join Eample.vtt	15.2 KB
22. Left Join Concept.mp4	46.3 MB
22. Left Join Concept.vtt	10.5 KB
23. Left Join Eample.mp4	47.5 MB
23. Left Join Eample.vtt	11.0 KB
24. Right Join Concept.mp4	24.9 MB
24. Right Join Concept.vtt	8.7 KB
25. Right Join Example.mp4	55.6 MB
25. Right Join Example.vtt	11.0 KB
26. Left & Right Anti Join.mp4	101.8 MB
26. Left & Right Anti Join.vtt	20.8 KB
27. Left & Right Anti Join Example.mp4	9.2 MB
27. Left & Right Anti Join Example.vtt	3.8 KB
28. Full Outer Join.mp4	84.7 MB
28. Full Outer Join.vtt	16.7 KB
29. Self Join.mp4	36.6 MB
29. Self Join.vtt	11.7 KB
30. Union & Union All.mp4	30.7 MB
30. Union & Union All.vtt	14.5 KB
31. SQL Like Operator.mp4	112.7 MB
31. SQL Like Operator.vtt	30.7 KB
32. SQL Case in Select statement & Order BY Clause.mp4	48.9 MB
32. SQL Case in Select statement & Order BY Clause.vtt	17.8 KB
33. Nested CASE statement.mp4	30.3 MB
33. Nested CASE statement.vtt	11.9 KB
34. SQL Data Types.mp4	29.1 MB
34. SQL Data Types.vtt	11.6 KB
35. SQL Create Table.mp4	30.9 MB
35. SQL Create Table.vtt	16.1 KB
36. Inserting Records into All Columns of the Table.mp4	27.9 MB
36. Inserting Records into All Columns of the Table.vtt	9.4 KB
37. Inserting Records into Certain Columns in a Table.mp4	22.2 MB
37. Inserting Records into Certain Columns in a Table.vtt	7.9 KB
38. Copying Data From One Table to Another.mp4	55.1 MB
38. Copying Data From One Table to Another.vtt	18.5 KB
39. Sub Queries.mp4	44.0 MB
39. Sub Queries.vtt	14.3 KB
40. Not Null Constraint.mp4	35.9 MB
40. Not Null Constraint.vtt	16.2 KB
41. Unique Constraint.mp4	32.3 MB
41. Unique Constraint.vtt	14.1 KB
42. Check Constraint.mp4	26.9 MB
42. Check Constraint.vtt	11.0 KB
43. Default Constraint.mp4	28.9 MB
43. Default Constraint.vtt	13.3 KB
44. Primary & Foreign Key Concept.mp4	19.8 MB
44. Primary & Foreign Key Concept.vtt	8.7 KB
45. Primary Key Constraint.mp4	33.5 MB
45. Primary Key Constraint.vtt	15.3 KB
46. Foreign Key Constraint.mp4	29.5 MB
46. Foreign Key Constraint.vtt	12.7 KB
47. SQL Order of Execution.mp4	22.6 MB
47. SQL Order of Execution.vtt	11.1 KB
/assets/
01. Lec-1-Create-Table-Query.txt	0.6 KB
01. Lec-1-SQL-Practice.txt	0.4 KB
02. Lec-2-Create-Table-Query.txt	0.5 KB
02. Lec-2-SQL-Practice.txt	0.2 KB
03. Lec-3-SQL-Practice.txt	0.3 KB
04. Lec-4-SQL-Practice.txt	0.4 KB
05. Lec-5-SQL-Practice.txt	0.2 KB
06. Lec-6-SQL-Practice.txt	0.4 KB
07. Lec-7-SQL-Practice.txt	0.8 KB
08. Lec-8-SQL-Practice.txt	0.5 KB
09. Lec-9-SQL-Practice.txt	0.4 KB
10. Lec-10-SQL-Practice.txt	0.4 KB
11. Lec-11-SQL-Practice.txt	0.7 KB
12. Lec-12-SQL-Practice.txt	0.3 KB
13. Lec-13-Create-Table.txt	1.2 KB
13. Lec-13-SQL-Practice.txt	0.5 KB
14. Lec-14-SQL-Practice.txt	0.3 KB
15. Lec-15-SQL-Practice.txt	1.5 KB
16. Lec-16-Group-By-Clause-Example.pptx	969.2 KB
17. Lec-17-SQL-Practice.txt	0.3 KB
18. Lec-18-SQL-Practice.txt	0.4 KB
19. Lec-19-SQL-Practice.txt	0.5 KB
20. Lec-20-Inner-Join-Concept.pptx	588.1 KB
21. Lec-21-Create-Table.txt	0.4 KB
21. Lec-21-SQL-Prcatice.txt	0.4 KB
22. Lec-22-Left-Outer-Join.pptx	796.9 KB
23. Lec-23-SQL-Practice.txt	0.3 KB
24. Lec-24-Right-Outer-Join.pptx	626.1 KB
25. Lec-25-Right-Outer-Join.txt	0.3 KB
26. Lec-26-Left-Right-Anti-Join.pptx	1.1 MB
27. Lec-27-Left-Right-Anti-Join-Example.txt	0.3 KB
28. Lec-28-Full-Outer-Join.pptx	573.1 KB
29. Lec-29-SQL-Practice.txt	0.2 KB
29. Lec-29-Self-Join.pptx	398.0 KB
30. Lec-30-Create-Table.txt	0.2 KB
30. Lec-30-SQL-Practice.txt	0.7 KB
31. Lec-31-Create-Table.txt	0.6 KB
31. Lec-31-SQL-Practice.txt	2.1 KB
32. Lec-32-Create-Table.txt	1.1 KB
32. Lec-32-SQL-Practice.txt	0.9 KB
33. Lec-33-SQL-Practice.txt	1.0 KB
34. Lec-34-SQL-Practice.txt	0.5 KB
34. SQL-Data-Types.xlsx	9.1 KB
35. Lec-35-SQL-Practice.txt	0.4 KB
36. Lec-36-SQL-Practice.txt	0.3 KB
37. Lec-37-SQL-Practice.txt	0.4 KB
38. Lec-38-SQL-Practice.txt	1.1 KB
39. Lec-39-SQL-Create-Table.txt	0.8 KB
39. Lec-39-SQL-Practice.txt	0.6 KB
40. Lec-48-SQL-Practice.txt	1.0 KB
41. Lec-49-SQL-Practice.txt	0.7 KB
42. Lec-50-SQL-Practice.txt	0.7 KB
43. Lec-51-SQL-Practice.txt	0.6 KB
44. Lec-52-Primary-Foreign-Key.pptx	669.0 KB
45. Lec-53-SQL-Practice.txt	0.7 KB
46. Lec-54-SQL-Practice.txt	0.7 KB
47. Lec-69-Create-Table.txt	0.5 KB
47. Lec-69-SQL-Practice.txt	0.5 KB
/13. SQL Basics Questions/
01. Questions Set - 1.mp4	46.4 MB
01. Questions Set - 1.vtt	15.7 KB
02. Questions Set - 2.mp4	72.2 MB
02. Questions Set - 2.vtt	20.6 KB
03. Questions Set - 3 (Joins).mp4	178.1 MB
03. Questions Set - 3 (Joins).vtt	28.4 KB
04. Questions Set - 4 (Joins).mp4	121.6 MB
04. Questions Set - 4 (Joins).vtt	34.6 KB
/assets/
01. Lec-42-Create-Table.txt	0.8 KB
01. Lec-42-SQL-Practice.txt	1.5 KB
02. Lec-43-Create-Table.txt	0.8 KB
02. Lec-43-SQL-Practice.txt	2.1 KB
03. Lec-70-Create-Table.txt	1.3 KB
03. Lec-70-SQL-Practice.txt	1.7 KB
/14. SQL Assignments/
1.1 Assignment-SQL Assignment 1 Create Table.txt	1.2 KB
1.1 Assignment-SQL Assignment 1.html	5.2 KB
1.2 Assignment-Assignment 2 Create Table.txt	0.7 KB
1.2 Assignment-SQL Assignment 2.html	5.5 KB
1.3 Assignment-Assignment 3 Create Table.txt	0.7 KB
1.3 Assignment-SQL Assignment 3.html	5.1 KB
1.4 Assignment-Assignment 4 Create Table.txt	1.1 KB
1.4 Assignment-SQL Assignment 4.html	5.6 KB
1.5 Assignment-Assignment 5 Create Table.txt	0.7 KB
1.5 Assignment-SQL Assignment 5.html	4.9 KB
/15. SQL Functions/
01. Rank, Dense Rank & Row Number Window Functions - 1.mp4	31.2 MB
01. Rank, Dense Rank & Row Number Window Functions - 1.vtt	13.1 KB
02. Rank, Dense Rank & Row Number Window Functions - 2.mp4	33.3 MB
02. Rank, Dense Rank & Row Number Window Functions - 2.vtt	14.9 KB
03. Window Functions - Lead Function.mp4	48.9 MB
03. Window Functions - Lead Function.vtt	18.9 KB
04. Window Functions - Lag Function.mp4	56.0 MB
04. Window Functions - Lag Function.vtt	12.6 KB
05. ISNULL & Coalesce Functions.mp4	29.8 MB
05. ISNULL & Coalesce Functions.vtt	13.6 KB
06. First_Value() Window Function.mp4	31.0 MB
06. First_Value() Window Function.vtt	15.7 KB
07. Last_Value() Window Function.mp4	50.2 MB
07. Last_Value() Window Function.vtt	18.0 KB
/assets/
01. Lec-40-Create-Table.txt	0.9 KB
01. Lec-40-SQL-Practice.txt	1.4 KB
03. Lec-44-Create-Table.txt	0.8 KB
03. Lec-44-SQL-Practice.txt	0.6 KB
04. Lec-45-SQL-Practice.txt	0.6 KB
05. Lec-60-Create-Table.txt	0.6 KB
05. Lec-60-SQL-Practice.txt	0.5 KB
06. Lec-67-Create-Table.txt	0.5 KB
06. Lec-67-SQL-Practice.txt	0.7 KB
07. LEC-68-SQL-Practice.txt	1.7 KB
07. Lec-68-Create-Table.txt	0.5 KB
/16. Advanced SQL/
01. Common Table Expressions - 1.mp4	55.1 MB
01. Common Table Expressions - 1.vtt	23.8 KB
02. Common Table Expressions - 2.mp4	55.7 MB
02. Common Table Expressions - 2.vtt	18.5 KB
03. Recursive Common Table Expressions.mp4	39.3 MB
03. Recursive Common Table Expressions.vtt	18.5 KB
04. Stored Procedure in MS SQL Server.mp4	30.6 MB
04. Stored Procedure in MS SQL Server.vtt	13.8 KB
05. Views in MS SQL Server.mp4	31.6 MB
05. Views in MS SQL Server.vtt	16.5 KB
06. Indexes in MS SQL Server.mp4	22.9 MB
06. Indexes in MS SQL Server.vtt	11.0 KB
07. Clustered Index.mp4	21.3 MB
07. Clustered Index.vtt	11.8 KB
08. Non Clustered Index.mp4	14.0 MB
08. Non Clustered Index.vtt	6.6 KB
/assets/
01. Lec-46-SQL-Practice.txt	1.3 KB
02. Lec-47-SQL-Practice.txt	1.4 KB
03. Lec-55-SQL-Practice.txt	0.5 KB
04. Lec-64-Create-Table.txt	0.8 KB
04. Lec-64-SQL-Practice.txt	0.4 KB
05. Lec-65-SQL-Practice.txt	0.5 KB
06. Lec-66-SQL-Practice.txt	0.2 KB
07. Clustered-Index.txt	0.7 KB
08. Non-Clustered-Index.txt	0.6 KB
/17. SQL Important Interview Questions/
01. Nth Highest Salary.mp4	55.4 MB
01. Nth Highest Salary.vtt	19.2 KB
02. Reportee & Manager Question.mp4	37.1 MB
02. Reportee & Manager Question.vtt	15.3 KB
03. Deleting Duplicates Q1.mp4	33.9 MB
03. Deleting Duplicates Q1.vtt	13.2 KB
04. Deleting Duplicates Q2.mp4	48.3 MB
04. Deleting Duplicates Q2.vtt	16.5 KB
/assets/
01. Lec-56-Create-Table.txt	0.5 KB
01. Lec-56-SQL-Practice.txt	1.3 KB
02. Lec-57-Create-Table.txt	0.7 KB
02. Lec-57-SQL-Practice.txt	0.3 KB
03. Lec-58-Create-Table.txt	0.5 KB
03. Lec-58-SQL-Practice.txt	0.6 KB
04. Lec-59-Create-Table.txt	0.7 KB
04. Lec-59-SQL-Practice.txt	0.9 KB
/18. Power BI Course Introduction/
01. Microsoft Power BI Course Introduction.mp4	37.5 MB
01. Microsoft Power BI Course Introduction.vtt	16.5 KB
/assets/
01. Power-BI-Interview-Questions-Set-1.pdf	60.1 KB
01. Power-BI-Interview-Questions-Set-2.pdf	76.9 KB
/19. Introduction to Power BI/
01. General Workflow Power BI.mp4	9.9 MB
01. General Workflow Power BI.vtt	6.3 KB
02. Downloading & Installing Power BI Desktop.mp4	23.2 MB
02. Downloading & Installing Power BI Desktop.vtt	5.5 KB
03. Creating a Free Power BI Account.mp4	56.6 MB
03. Creating a Free Power BI Account.vtt	7.7 KB
/assets/
01. Power-BI-Overview.txt	0.4 KB
02. Power-BI-Desktop-Service-Link.xlsx	10.7 KB
03. Power-BI-Desktop-Service-Link.xlsx	10.7 KB
/20. Data Visualization/
01. Creating a Bar Chart.mp4	52.2 MB
01. Creating a Bar Chart.vtt	11.3 KB
02. Creating a Column Chart.mp4	15.7 MB
02. Creating a Column Chart.vtt	7.9 KB
03. Creating a Pie & a Donut Chart.mp4	32.4 MB
03. Creating a Pie & a Donut Chart.vtt	12.1 KB
04. Creating a Clustered Column & Bar Chart.mp4	20.5 MB
04. Creating a Clustered Column & Bar Chart.vtt	9.5 KB
05. Creating a Line & Area Chart.mp4	28.2 MB
05. Creating a Line & Area Chart.vtt	14.1 KB
06. Creating a Ribbon Chart.mp4	23.3 MB
06. Creating a Ribbon Chart.vtt	11.1 KB
07. Creating a line & stacked column chart.mp4	47.2 MB
07. Creating a line & stacked column chart.vtt	21.1 KB
08. Creating a Line & Clustered Column Chart.mp4	24.8 MB
08. Creating a Line & Clustered Column Chart.vtt	10.8 KB
09. Creating a Scatter Plot.mp4	23.7 MB
09. Creating a Scatter Plot.vtt	11.8 KB
10. Creating a Bubble Map Visual.mp4	53.2 MB
10. Creating a Bubble Map Visual.vtt	9.9 KB
11. Creating a Table & Matrix Visual.mp4	75.7 MB
11. Creating a Table & Matrix Visual.vtt	14.9 KB
12. Formatting Table & Matrix Visual.mp4	51.6 MB
12. Formatting Table & Matrix Visual.vtt	14.4 KB
13. Creating a Funnel Chart.mp4	24.5 MB
13. Creating a Funnel Chart.vtt	14.1 KB
14. Gauge chart & KPI Visual.mp4	53.7 MB
14. Gauge chart & KPI Visual.vtt	19.4 KB
15. AI Visuals in Power BI.mp4	90.1 MB
15. AI Visuals in Power BI.vtt	18.9 KB
/assets/
01. DV-Sales-Data.xlsx	1.3 MB
02. DV-Sales-Data.xlsx	1.3 MB
03. DV-Sales-Data.xlsx	1.3 MB
04. DV-Sales-Data.xlsx	1.3 MB
05. DV-Sales-Data.xlsx	1.3 MB
06. DV-Sales-Data.xlsx	1.3 MB
07. DV-Sales-Data.xlsx	1.3 MB
08. DV-Sales-Data.xlsx	1.3 MB
09. DV-Sales-Data.xlsx	1.3 MB
10. DV-Sales-Data.xlsx	1.3 MB
12. DV-Sales-Data.xlsx	1.3 MB
13. DV-Leads-Data.xlsx	8.7 KB
14. DV-Sales-Data.xlsx	1.3 MB
15. DV-Sales-Data.xlsx	1.3 MB
/21. Power Query Editor/
01. Detecting Data Types in Power BI Desktop.mp4	70.2 MB
01. Detecting Data Types in Power BI Desktop.vtt	20.9 KB
02. Data Profiling.mp4	46.4 MB
02. Data Profiling.vtt	14.4 KB
03. Column Distribution Example.mp4	12.2 MB
03. Column Distribution Example.vtt	6.7 KB
04. Appending Queries.mp4	30.1 MB
04. Appending Queries.vtt	10.9 KB
05. Merge Inner Join.mp4	78.1 MB
05. Merge Inner Join.vtt	19.0 KB
06. Left Outer Join.mp4	49.7 MB
06. Left Outer Join.vtt	15.1 KB
07. Right Outer Join.mp4	61.9 MB
07. Right Outer Join.vtt	12.2 KB
08. Left & Right Anti Join.mp4	37.5 MB
08. Left & Right Anti Join.vtt	18.1 KB
09. Full Outer Join.mp4	79.2 MB
09. Full Outer Join.vtt	15.1 KB
10. Group By in Power Query Editor.mp4	32.9 MB
10. Group By in Power Query Editor.vtt	10.0 KB
11. Pivot, Unpivot & Transpose.mp4	66.5 MB
11. Pivot, Unpivot & Transpose.vtt	14.1 KB
12. AddTransform Columns.mp4	66.6 MB
12. AddTransform Columns.vtt	14.1 KB
/assets/
01. PQE-UPI-Data.xlsx	287.6 KB
02. PQE-UPI-Data.xlsx	287.6 KB
03. PQE-Column-Distribution.xlsx	8.7 KB
04. PQE-Student-Details-1.xlsx	8.8 KB
04. PQE-Student-Details-2.xlsx	8.7 KB
05. PQE-All-Student-Details.xlsx	8.9 KB
05. PQE-Power-BI-Course.pdf	3.8 MB
05. PQE-Student-Marks.xlsx	8.8 KB
06. PQE-All-Student-Details.xlsx	8.9 KB
06. PQE-Left-Outer-Join.xlsx	9.2 KB
06. PQE-Power-BI-Course.pdf	3.8 MB
06. PQE-Student-Marks-New.xlsx	8.9 KB
07. PQE-All-Student-Details.xlsx	8.9 KB
07. PQE-Power-BI-Course.pdf	3.8 MB
07. PQE-Right-Outer-Join.xlsx	9.2 KB
07. PQE-Student-Marks-New.xlsx	8.9 KB
08. PQE-Left-Anti-Join.xlsx	8.8 KB
08. PQE-Power-BI-Course.pdf	3.8 MB
08. PQE-Right-Anti-Join.xlsx	8.7 KB
09. PQE-Full-Outer-Join.xlsx	9.3 KB
09. PQE-Power-BI-Course.pdf	3.8 MB
10. PQE-UPI-Data.xlsx	287.6 KB
11. Pivot.xlsx	8.9 KB
11. Transpose.xlsx	8.7 KB
11. Unpivot.xlsx	8.8 KB
12. PQE-Add-Transfor-Columns.xlsx	9.0 KB
/22. DAX/
01. DAX Lecture 1.mp4	169.5 MB
01. DAX Lecture 1.vtt	35.1 KB
02. DAX Lecture 2.mp4	122.9 MB
02. DAX Lecture 2.vtt	34.8 KB
03. DAX Lecture 3.mp4	141.6 MB
03. DAX Lecture 3.vtt	45.1 KB
04. DAX Lecture 4.mp4	44.2 MB
04. DAX Lecture 4.vtt	16.6 KB
05. DAX Lecture 5.mp4	60.5 MB
05. DAX Lecture 5.vtt	21.8 KB
06. DAX Lecture 6.mp4	38.6 MB
06. DAX Lecture 6.vtt	17.3 KB
/22. DAX/assets/
01. DAX-Functions-PBI-Course.pbix	99.7 KB
02. DAX-Functions-PBI-Course.pbix	99.7 KB
03. DAX-Functions-PBI-Course.pbix	99.7 KB
04. DAX-Functions-PBI-Course.pbix	99.7 KB
05. DAX-Time-Intelligence-Functions.pbix	50.9 KB
/23. Power BI Project 1, Sales Data Analysis/
01. Business Requirements.mp4	18.4 MB
01. Business Requirements.vtt	8.7 KB
02. Loading Data to PBI Desktop.mp4	34.8 MB
02. Loading Data to PBI Desktop.vtt	11.2 KB
03. Data Profiling & Data Transformations Part 1.mp4	46.6 MB
03. Data Profiling & Data Transformations Part 1.vtt	24.7 KB
04. Data Transformations Part 2.mp4	125.3 MB
04. Data Transformations Part 2.vtt	25.4 KB
05. Primary & Foreign Key.mp4	18.1 MB
05. Primary & Foreign Key.vtt	9.7 KB
06. Cardinality.mp4	30.0 MB
06. Cardinality.vtt	13.2 KB
07. Star Schema.mp4	81.3 MB
07. Star Schema.vtt	17.7 KB
08. Data Model Overview.mp4	32.6 MB
08. Data Model Overview.vtt	14.8 KB
09. Different Types of Filters in Filters Pane.mp4	22.1 MB
09. Different Types of Filters in Filters Pane.vtt	10.1 KB
10. Top Bottom 5 Products By Sales, Quantity and Profit.mp4	133.6 MB
10. Top Bottom 5 Products By Sales, Quantity and Profit.vtt	24.9 KB
11. Sales Trends Over Time.mp4	40.4 MB
11. Sales Trends Over Time.vtt	12.2 KB
12. Other Requirements.mp4	205.3 MB
12. Other Requirements.vtt	33.0 KB
13. Requirement 4 DAX.mp4	158.2 MB
13. Requirement 4 DAX.vtt	38.2 KB
14. Requirement 4 Edit Interactions.mp4	64.5 MB
14. Requirement 4 Edit Interactions.vtt	15.6 KB
15. Other Remaining Requirements.mp4	45.3 MB
15. Other Remaining Requirements.vtt	14.2 KB
16. Changing Filter Behaviour for Dimension Table Slicers.mp4	84.4 MB
16. Changing Filter Behaviour for Dimension Table Slicers.vtt	16.6 KB
/assets/
01. Power-BI-Project-1-Requirements.pptx	628.0 KB
02. Store-Data.xlsx	118.3 KB
05. PK-FK-Cardinality-Schema-Notes.pptx	1.9 MB
06. PK-FK-Cardinality-Schema-Notes.pptx	1.9 MB
07. PK-FK-Cardinality-Schema-Notes.pptx	1.9 MB
/24. Power BI Project 2, Insurance Data Analysis/
01. Downloading & Installing MSSQL Server.mp4	50.7 MB
01. Downloading & Installing MSSQL Server.vtt	5.6 KB
02. Importing Data to MSSQL Server.mp4	17.1 MB
02. Importing Data to MSSQL Server.vtt	7.7 KB
03. Loading Data to Power BI Desktop.mp4	53.8 MB
03. Loading Data to Power BI Desktop.vtt	12.3 KB
04. Table View & Data Profiling.mp4	54.6 MB
04. Table View & Data Profiling.vtt	15.1 KB
05. Adding Slicers & Text.mp4	23.4 MB
05. Adding Slicers & Text.vtt	6.3 KB
06. Adding New Card Visuals.mp4	19.5 MB
06. Adding New Card Visuals.vtt	9.4 KB
07. Adding a Multi Row Card & a Ribbon Chart.mp4	21.1 MB
07. Adding a Multi Row Card & a Ribbon Chart.vtt	10.5 KB
08. Adding a Bar & a Line Chart.mp4	89.8 MB
08. Adding a Bar & a Line Chart.vtt	20.5 KB
09. Adding a Donut Chart & Matrix Visual.mp4	51.4 MB
09. Adding a Donut Chart & Matrix Visual.vtt	14.5 KB
10. Publishing the Report to Power BI Service.mp4	52.7 MB
10. Publishing the Report to Power BI Service.vtt	11.2 KB
11. Scheduling Refresh.mp4	36.0 MB
11. Scheduling Refresh.vtt	8.1 KB
12. Drill Through Filter.mp4	68.1 MB
12. Drill Through Filter.vtt	8.2 KB
13. Testing Scheduled Refresh & Publishing the updated report.mp4	31.1 MB
13. Testing Scheduled Refresh & Publishing the updated report.vtt	6.6 KB
14. Creating & Testing Roles in PBI Desktop.mp4	13.2 MB
14. Creating & Testing Roles in PBI Desktop.vtt	6.5 KB
15. Testing & Implementing RLS in Power BI Service.mp4	16.3 MB
15. Testing & Implementing RLS in Power BI Service.vtt	6.4 KB
16. Power BI Reports & Dashboards.mp4	47.0 MB
16. Power BI Reports & Dashboards.vtt	8.6 KB
17. Sentiment Analysis Power Query.mp4	37.3 MB
17. Sentiment Analysis Power Query.vtt	8.9 KB
18. Sentiment Analysis Adding Visuals to the Report.mp4	58.4 MB
18. Sentiment Analysis Adding Visuals to the Report.vtt	17.5 KB
/assets/
01. SQL-Server-Download.xlsx	9.1 KB
02. InsuranceData.csv	939.9 KB
03. InsuranceData.csv	939.9 KB
17. Insurance-Customer-Feedback.xlsx	12.2 KB
/25. Power BI Project 3, UPI Transactions Data Analysis/
01. Loading Data into Power BI Desktop.mp4	93.7 MB
01. Loading Data into Power BI Desktop.vtt	17.7 KB
02. Data Profiling.mp4	25.3 MB
02. Data Profiling.vtt	8.2 KB
03. Size & Position of slicers.mp4	7.2 MB
03. Size & Position of slicers.vtt	6.4 KB
04. Formatting the Slicers.mp4	37.8 MB
04. Formatting the Slicers.vtt	20.7 KB
05. Adding a Page & Age Group Column.mp4	30.4 MB
05. Adding a Page & Age Group Column.vtt	11.0 KB
06. Adding a Line Chart.mp4	34.3 MB
06. Adding a Line Chart.vtt	12.2 KB
07. Adding a Matrix Visual.mp4	35.2 MB
07. Adding a Matrix Visual.vtt	12.2 KB
08. Syncing Slicers & Applying Conditional Formatting.mp4	21.4 MB
08. Syncing Slicers & Applying Conditional Formatting.vtt	9.2 KB
09. Adding Bookmarks for Transactions.mp4	20.2 MB
09. Adding Bookmarks for Transactions.vtt	10.4 KB
10. Adding Bookmarks for Remaining Balance.mp4	32.2 MB
10. Adding Bookmarks for Remaining Balance.vtt	15.7 KB
11. Publishing the Report to Power BI Service.mp4	9.8 MB
11. Publishing the Report to Power BI Service.vtt	3.8 KB
/assets/
01. UPI-Transactions.xlsx	2.4 MB
03. Size-Position-Slicers.pptx	74.9 KB
/26. Miscellaneous Section Power BI/
01. SQL + Power BI Scenario based question - 1.mp4	66.5 MB
01. SQL + Power BI Scenario based question - 1.vtt	14.4 KB
02. Power BI Scenario Based Question - 2.mp4	30.3 MB
02. Power BI Scenario Based Question - 2.vtt	14.4 KB
/assets/
01. Scenario-Based-Questio-1.xlsx	10.6 KB
02. Sales-Data-Scenario-Based-Question.xlsx	1.2 MB
/27. Getting Started with Microsoft Excel/
01. Home Tab Font Group.mp4	76.3 MB
01. Home Tab Font Group.vtt	21.2 KB
02. Home Tab Alignment Group.mp4	34.0 MB
02. Home Tab Alignment Group.vtt	13.4 KB
03. Home Tab Number Group Part 1.mp4	48.6 MB
03. Home Tab Number Group Part 1.vtt	17.7 KB
04. Home Tab Number Group Part 2.mp4	38.0 MB
04. Home Tab Number Group Part 2.vtt	13.9 KB
05. Home Tab Styles Group Conditional Formatting 1.mp4	37.8 MB
05. Home Tab Styles Group Conditional Formatting 1.vtt	12.6 KB
06. Home Tab Styles Group Conditional Formatting 2.mp4	20.7 MB
06. Home Tab Styles Group Conditional Formatting 2.vtt	10.0 KB
07. Draw Tab & Cell Styles.mp4	27.4 MB
07. Draw Tab & Cell Styles.vtt	9.5 KB
08. Excel Functions Video 1.mp4	23.0 MB
08. Excel Functions Video 1.vtt	10.1 KB
09. Excel Functions Video 2.mp4	35.9 MB
09. Excel Functions Video 2.vtt	10.6 KB
10. Excel Functions Video 3.mp4	68.5 MB
10. Excel Functions Video 3.vtt	19.7 KB
11. Excel Functions Video 4.mp4	53.5 MB
11. Excel Functions Video 4.vtt	15.7 KB
12. Excel Functions Video 5.mp4	25.5 MB
12. Excel Functions Video 5.vtt	8.5 KB
13. Excel Functions Video 6.mp4	30.9 MB
13. Excel Functions Video 6.vtt	9.1 KB
14. Excel Functions Video 7.mp4	35.1 MB
14. Excel Functions Video 7.vtt	11.3 KB
15. Excel Functions Video 8.mp4	22.5 MB
15. Excel Functions Video 8.vtt	7.9 KB
16. Excel Functions Video 9 VLookUp Function.mp4	73.6 MB
17. Excel Functions Video 10 XLookUp Function.mp4	44.4 MB
17. Excel Functions Video 10 XLookUp Function.vtt	13.8 KB
/assets/
01. Test-Original-Vid-1.xlsx	559.5 KB
01. Test-Updated-Vid-1.xlsx	118.3 KB
02. Test-Original-Vid-1.xlsx	559.5 KB
02. Test-Updated-Vid-1.xlsx	118.3 KB
03. Part-1-Home-Tab-Number-Group.xlsx	18.8 KB
04. Home-Tab-Number-Group-Part-2.xlsx	16.0 KB
05. Video-5-Excel.xlsx	10.0 KB
06. Video-6-Excel.xlsx	10.0 KB
08. video-8-excel.xlsx	10.6 KB
09. video-9-excel.xlsx	10.6 KB
10. Video-10-Excel-Functions.xlsx	10.5 KB
11. Video-11-Excel-Functions.xlsx	10.3 KB
12. Video-12-Excel-Functions.xlsx	11.7 KB
13. Video-13-Excel-Functions.xlsx	9.9 KB
14. Video-14-Excel-Functions.xlsx	10.2 KB
15. Video-15-Excel-Functions.xlsx	9.6 KB
16. Video-16-17-VlookUP-XlookuP-Resp.xlsx	14.3 KB
17. Video-16-17-VlookUP-XlookuP-Resp.xlsx	14.3 KB
/28. Excel Dashboard 1/
01. Pivot Tables Lecture 1.mp4	59.6 MB
01. Pivot Tables Lecture 1.vtt	17.6 KB
02. Pivot Tables Lecture 2.mp4	91.0 MB
02. Pivot Tables Lecture 2.vtt	17.4 KB
03. Creating & Formatting the Column Chart.mp4	68.7 MB
03. Creating & Formatting the Column Chart.vtt	17.2 KB
04. Creating & Formatting the Bar Chart.mp4	59.8 MB
04. Creating & Formatting the Bar Chart.vtt	13.8 KB
05. Creating & Formatting a Line Chart.mp4	81.7 MB
05. Creating & Formatting a Line Chart.vtt	13.8 KB
06. Creating & Formatting an Area Chart.mp4	83.2 MB
06. Creating & Formatting an Area Chart.vtt	15.3 KB
07. Creating & Formatting a Pie Chart.mp4	60.7 MB
07. Creating & Formatting a Pie Chart.vtt	15.1 KB
08. Creating the Dashboard.mp4	36.6 MB
08. Creating the Dashboard.vtt	8.6 KB
/assets/
01. Excel-Report-1-Data.xlsx	227.6 KB
03. Excel-Report-1-Data.xlsx	253.1 KB
04. Excel-Report-1-Data.xlsx	253.1 KB
05. Excel-Report-1-Data.xlsx	262.2 KB
06. Excel-Report-1-Data.xlsx	270.7 KB
07. Excel-Report-1-Data.xlsx	270.7 KB
08. Excel-Report-1-Data.xlsx	299.4 KB
/29. Excel Dashboard 2/
01. Data Understanding & Cleansing.mp4	70.2 MB
01. Data Understanding & Cleansing.vtt	12.9 KB
02. Data Transformation (Removing Data Quality Issues using VLookUp Function).mp4	163.4 MB
02. Data Transformation (Removing Data Quality Issues using VLookUp Function).vtt	21.4 KB
03. Adding Age Group & Production Cost Per Unit Column.mp4	74.1 MB
03. Adding Age Group & Production Cost Per Unit Column.vtt	15.2 KB
04. Adding a 3D Column Chart.mp4	52.5 MB
04. Adding a 3D Column Chart.vtt	12.7 KB
05. Adding a 3D Bar Chart.mp4	39.7 MB
05. Adding a 3D Bar Chart.vtt	14.3 KB
06. Adding a 3D Line Chart.mp4	70.9 MB
06. Adding a 3D Line Chart.vtt	13.4 KB
07. Adding a 3D Pie Chart.mp4	52.0 MB
07. Adding a 3D Pie Chart.vtt	10.9 KB
08. Creating the Dashboard.mp4	67.0 MB
08. Creating the Dashboard.vtt	13.0 KB
/assets/
01. Excel-Report-2.xlsx	15.0 KB
02. Excel-Report-2.xlsx	15.0 KB
03. Excel-Dashboard-2-Copy.xlsx	19.0 KB
04. Excel-Dashboard-2-Adding-3D-Column-Chart.xlsx	34.0 KB
05. Excel-Dashboard-2.xlsx	42.9 KB
06. Excel-Dashboard-2.xlsx	89.7 KB
07. Excel-Dashboard-2.xlsx	89.6 KB
08. Excel-Dashboard-2.xlsx	89.6 KB
/30. Power Query Editor (MS Excel)/
01. Data Profiling (Column Distribution).mp4	41.3 MB
01. Data Profiling (Column Distribution).vtt	15.8 KB
02. Data Profiling (Column Profile & Column Quality).mp4	30.1 MB
02. Data Profiling (Column Profile & Column Quality).vtt	11.0 KB
03. Combining Queries.mp4	6.2 MB
03. Combining Queries.vtt	4.5 KB
04. Inner Join Concept.mp4	21.6 MB
04. Inner Join Concept.vtt	11.2 KB
05. Inner Join Example.mp4	26.2 MB
05. Inner Join Example.vtt	7.7 KB
06. Left Join Concept.mp4	17.3 MB
06. Left Join Concept.vtt	7.4 KB
07. Left Join Example.mp4	19.9 MB
07. Left Join Example.vtt	5.2 KB
08. Right Join Concept.mp4	15.2 MB
08. Right Join Concept.vtt	6.1 KB
09. Right Join Example.mp4	21.2 MB
09. Right Join Example.vtt	5.5 KB
10. Full Outer Join Concept.mp4	28.6 MB
10. Full Outer Join Concept.vtt	6.9 KB
11. Full Outer Join Example.mp4	20.6 MB
11. Full Outer Join Example.vtt	5.3 KB
12. Left & Right Anti Join Concept.mp4	17.0 MB
12. Left & Right Anti Join Concept.vtt	7.7 KB
13. Right & Left Anti Join Example.mp4	9.0 MB
13. Right & Left Anti Join Example.vtt	4.1 KB
14. Nulls in SQL Server & Power Query Editor.mp4	17.7 MB
14. Nulls in SQL Server & Power Query Editor.vtt	7.2 KB
15. Appending two tables.mp4	15.7 MB
15. Appending two tables.vtt	9.6 KB
16. Appending three tables.mp4	4.9 MB
16. Appending three tables.vtt	3.4 KB
17. Power Query Editor Exercise 1.mp4	30.1 MB
17. Power Query Editor Exercise 1.vtt	11.4 KB
18. Power Query Editor Exercise 2.mp4	36.2 MB
18. Power Query Editor Exercise 2.vtt	9.5 KB
19. Power Query Editor Exercise 3.mp4	51.2 MB
19. Power Query Editor Exercise 3.vtt	12.7 KB
20. Power Query Editor Exercise 4.mp4	22.0 MB
20. Power Query Editor Exercise 4.vtt	11.0 KB
21. Power Query Editor Exercise 5.mp4	27.9 MB
21. Power Query Editor Exercise 5.vtt	6.7 KB
/assets/
01. Data-Profiling-PQE-Excel-Lec-1.xlsx	8.9 KB
02. Data-Profiling-PQE-Excel-Lec-2.xlsx	18.5 KB
04. Joins-Excel-ppt.pptx	2.6 MB
04. Joins.xlsx	18.5 KB
05. Joins-Excel-ppt.pptx	2.6 MB
05. Joins.xlsx	18.5 KB
06. Joins-Excel-ppt.pptx	2.6 MB
06. Joins.xlsx	18.5 KB
07. Joins-Excel-ppt.pptx	2.6 MB
07. Joins.xlsx	18.5 KB
08. Joins-Excel-ppt.pptx	2.6 MB
08. Joins.xlsx	18.5 KB
09. Joins-Excel-ppt.pptx	2.6 MB
09. Joins.xlsx	18.5 KB
10. Joins-Excel-ppt.pptx	2.6 MB
10. Joins.xlsx	18.5 KB
11. Joins-Excel-ppt.pptx	2.6 MB
11. Joins.xlsx	18.5 KB
12. Joins-Excel-ppt.pptx	2.6 MB
12. Joins.xlsx	18.5 KB
13. Joins-Excel-ppt.pptx	2.6 MB
13. Joins.xlsx	18.5 KB
15. Append-Queries.xlsx	15.0 KB
16. Append-Queries.xlsx	15.0 KB
17. PQE-Exercise-1.xlsx	20.2 KB
18. PQE-Exercise-2.xlsx	19.5 KB
19. PQE-Exercise-3.xlsx	21.4 KB
20. PQE-Exercise-4.xlsx	20.2 KB
21. PQE-Exercise-5.xlsx	19.7 KB
/31. Excel Activity (Importing Data From SQL Server)/
01. Importing Data to SQL Server.mp4	14.1 MB
01. Importing Data to SQL Server.vtt	7.0 KB
02. Importing Data to Excel From SQL Server.mp4	36.0 MB
02. Importing Data to Excel From SQL Server.vtt	7.2 KB
03. Data Understanding & Creating the Pivot Table.mp4	26.4 MB
03. Data Understanding & Creating the Pivot Table.vtt	7.5 KB
04. Adding Category Slicer.mp4	36.0 MB
04. Adding Category Slicer.vtt	6.1 KB
05. Adding Other Slicers & Formatting Slicers & Pivot Table.mp4	86.8 MB
05. Adding Other Slicers & Formatting Slicers & Pivot Table.vtt	13.6 KB
06. Refreshing the Report.mp4	26.8 MB
06. Refreshing the Report.vtt	7.1 KB
/assets/
01. Excel-Activity.xlsx	73.7 KB
01. Textile-Dataset.csv	205.2 KB
/32. Tableau/
01. Work of a Data Analyst (Story Telling).mp4	37.9 MB
01. Work of a Data Analyst (Story Telling).vtt	22.6 KB
02. Downloading & Installing Tableau Public.mp4	15.0 MB
02. Downloading & Installing Tableau Public.vtt	4.4 KB
03. Loading Data into Tableau Public.mp4	25.3 MB
03. Loading Data into Tableau Public.vtt	10.7 KB
04. Creating Column & Bar Chart.mp4	18.7 MB
04. Creating Column & Bar Chart.vtt	12.9 KB
05. Saving Your Work to Tableau Public.mp4	28.9 MB
05. Saving Your Work to Tableau Public.vtt	6.3 KB
06. Horizontal & Vertical Axis.mp4	9.7 MB
07. Stacked & 100% Stacked Column Chart.mp4	21.4 MB
08. Stacked & 100 % Stacked Bar Chart.mp4	36.1 MB
08. Stacked & 100 % Stacked Bar Chart.vtt	9.4 KB
09. Creating an Area Chart.mp4	26.7 MB
09. Creating an Area Chart.vtt	10.7 KB
10. Creating a Line Chart.mp4	37.2 MB
10. Creating a Line Chart.vtt	10.4 KB
11. Creating a Scatter Plot.mp4	17.7 MB
11. Creating a Scatter Plot.vtt	8.1 KB
12. Creating Pie Chart & Tree Map.mp4	20.8 MB
12. Creating Pie Chart & Tree Map.vtt	12.1 KB
13. Creating a Donut Chart.mp4	32.3 MB
13. Creating a Donut Chart.vtt	12.5 KB
14. Creating a Lollipop Chart.mp4	34.7 MB
14. Creating a Lollipop Chart.vtt	11.7 KB
15. Filters Shelf in Tableau 1.mp4	15.8 MB
15. Filters Shelf in Tableau 1.vtt	7.9 KB
16. Filters Shelf in Tableau 2.mp4	25.3 MB
16. Filters Shelf in Tableau 2.vtt	11.8 KB
17. Symbol & Filled Map.mp4	46.4 MB
17. Symbol & Filled Map.vtt	12.8 KB
18. Funnel & Packed Bubble Chart.mp4	40.0 MB
18. Funnel & Packed Bubble Chart.vtt	11.4 KB
19. Sets in Tableau.mp4	20.9 MB
19. Sets in Tableau.vtt	10.3 KB
20. Parameters in Tableau.mp4	15.7 MB
20. Parameters in Tableau.vtt	9.2 KB
21. Sets & Parameters.mp4	21.2 MB
21. Sets & Parameters.vtt	5.9 KB
/32. Tableau/assets/
01. Presentation1.pptx	787.3 KB
02. Tableau-Link.xlsx	9.1 KB
03. Sample-Superstore-Sales-Excel.xls	3.3 MB
04. Sample-Superstore-Sales-Excel.xls	3.3 MB
17. Maps-in-Tableau.twbx	487.4 KB
17. Sample-Superstore-Sales-Excel.xls	3.3 MB
19. Sets.twbx	350.7 KB
/33. Tableau Dashboard 1/
01. Importing Data.mp4	18.1 MB
01. Importing Data.vtt	4.5 KB
02. Creating & Formatting a Bar Chart.mp4	42.4 MB
02. Creating & Formatting a Bar Chart.vtt	12.2 KB
03. Creating & Formatting a Pie Chart.mp4	15.4 MB
03. Creating & Formatting a Pie Chart.vtt	8.9 KB
04. Creating & Formatting a Line Chart.mp4	13.2 MB
04. Creating & Formatting a Line Chart.vtt	7.6 KB
05. Creating & Formatting a Scatter Plot.mp4	8.9 MB
05. Creating & Formatting a Scatter Plot.vtt	4.1 KB
06. Creating the Dashboard.mp4	31.6 MB
06. Creating the Dashboard.vtt	12.8 KB
/assets/
01. Sample-Superstore-Sales-Excel.xls	3.3 MB
01. Tableau-Dashboard-1.twbx	400.3 KB
/34. Tableau Dashboard 2/
01. Importing Data.mp4	22.3 MB
01. Importing Data.vtt	8.4 KB
02. Transactions by City.mp4	22.4 MB
02. Transactions by City.vtt	7.8 KB
03. Number of Transactions by Age Group.mp4	16.6 MB
03. Number of Transactions by Age Group.vtt	5.6 KB
04. Transactions by Payment Method & Merchant Name.mp4	16.5 MB
04. Transactions by Payment Method & Merchant Name.vtt	7.3 KB
05. Adding Filters.mp4	10.8 MB
05. Adding Filters.vtt	5.2 KB
06. Creating the Dashboard.mp4	37.5 MB
06. Creating the Dashboard.vtt	12.6 KB
/assets/
01. UPI-Transactions.xlsx	2.2 MB
06. Tableau-Dashboard-2.twbx	418.3 KB
/35. Tableau Prep Builder/
01. Downloading & Installing Tableau Prep Builder.mp4	16.9 MB
01. Downloading & Installing Tableau Prep Builder.vtt	6.1 KB
02. Understanding the Dataset.mp4	43.6 MB
02. Understanding the Dataset.vtt	7.3 KB
03. Connecting to Text File & Microsoft Excel.mp4	16.2 MB
03. Connecting to Text File & Microsoft Excel.vtt	8.3 KB
04. Removing Additional Columns.mp4	57.5 MB
04. Removing Additional Columns.vtt	8.3 KB
05. Cleaning Orders Central Table.mp4	51.8 MB
05. Cleaning Orders Central Table.vtt	24.0 KB
06. Cleaning Orders East Table.mp4	11.2 MB
07. Cleaning Orders West Table.mp4	20.7 MB
08. Assigning Data Roles to Geographical Fields.mp4	25.3 MB
09. Combining Different Tables.mp4	10.2 MB
09. Combining Different Tables.vtt	6.1 KB
10. Cleaning Returns Table.mp4	63.9 MB
10. Cleaning Returns Table.vtt	11.6 KB
11. Joining Tables.mp4	21.1 MB
11. Joining Tables.vtt	10.6 KB
12. Cleaning Combined Table.mp4	21.6 MB
12. Cleaning Combined Table.vtt	8.9 KB
/assets/
07. New-Microsoft-Excel-Worksheet.xlsx	9.1 KB
/36. SQL + Tableau Project (Student Depression Data Analysis)/
01. Importing Data to SQL Server.mp4	10.4 MB
01. Importing Data to SQL Server.vtt	4.6 KB
02. Modifying Gender Column.mp4	16.4 MB
02. Modifying Gender Column.vtt	6.6 KB
03. Adding the Age Group Column.mp4	21.8 MB
03. Adding the Age Group Column.vtt	8.3 KB
04. Column Distribution remaining columns.mp4	47.7 MB
04. Column Distribution remaining columns.vtt	12.4 KB
05. Adding Index Column & Updating depression column.mp4	26.9 MB
05. Adding Index Column & Updating depression column.vtt	8.1 KB
06. Downloading & Installing Tableau Desktop.mp4	25.2 MB
06. Downloading & Installing Tableau Desktop.vtt	3.8 KB
07. Bringing Data from SQL Server to Tableau Desktop.mp4	16.6 MB
07. Bringing Data from SQL Server to Tableau Desktop.vtt	5.4 KB
08. Academic Pressure & Student Count.mp4	31.1 MB
08. Academic Pressure & Student Count.vtt	11.8 KB
09. Financial Stress & Student Count.mp4	11.9 MB
09. Financial Stress & Student Count.vtt	7.1 KB
10. Study Satisfaction & Student Count.mp4	13.0 MB
10. Study Satisfaction & Student Count.vtt	7.7 KB
11. Sleep Duration & Student Count.mp4	10.0 MB
11. Sleep Duration & Student Count.vtt	6.1 KB
12. Study Hours & Student Count.mp4	13.1 MB
12. Study Hours & Student Count.vtt	7.4 KB
13. Creating the Student Count Analysis Dashboard.mp4	20.6 MB
13. Creating the Student Count Analysis Dashboard.vtt	11.0 KB
14. Publishing the report to Tableau Cloud.mp4	27.7 MB
14. Publishing the report to Tableau Cloud.vtt	7.6 KB
/assets/
01. Depression-Student-Dataset.csv	28.2 KB
01. Vid-1.txt	0.1 KB
02. Vid-2.txt	0.4 KB
03. Vid-3.txt	0.5 KB
04. Vid-4.txt	1.1 KB
05. Vid-5.txt	0.6 KB
06. Tableau-Desktop-Link.xlsx	9.1 KB
/37. Snowflake/
01. Creating Snowflake Free Trial Account.mp4	25.8 MB
01. Creating Snowflake Free Trial Account.vtt	3.8 KB
02. Creating a SQL Worksheet.mp4	15.3 MB
02. Creating a SQL Worksheet.vtt	5.7 KB
03. Snowflake Architecture.mp4	11.7 MB
03. Snowflake Architecture.vtt	6.6 KB
04. Setting up a Warehouse in Snowflake.mp4	18.8 MB
04. Setting up a Warehouse in Snowflake.vtt	7.7 KB
05. Signing up for an AWS Account.mp4	41.5 MB
05. Signing up for an AWS Account.vtt	5.0 KB
06. Creating S3 Bucket.mp4	17.1 MB
06. Creating S3 Bucket.vtt	2.6 KB
07. Uploading Data to Amazon S3 Bucket.mp4	12.2 MB
07. Uploading Data to Amazon S3 Bucket.vtt	2.6 KB
08. Creating Roles using IAM.mp4	14.9 MB
08. Creating Roles using IAM.vtt	4.1 KB
09. Creating Integration Object.mp4	16.6 MB
09. Creating Integration Object.vtt	5.8 KB
10. Loading Data.mp4	22.7 MB
10. Loading Data.vtt	7.6 KB
11. Creating Free Azure Account.mp4	60.4 MB
11. Creating Free Azure Account.vtt	4.4 KB
12. Creating Storage Account in Azure.mp4	12.4 MB
12. Creating Storage Account in Azure.vtt	5.1 KB
13. Creating Containers in Azure & Loading Data in Containers.mp4	10.7 MB
13. Creating Containers in Azure & Loading Data in Containers.vtt	3.9 KB
14. Creating Integration Object to Connect to Azure.mp4	32.6 MB
14. Creating Integration Object to Connect to Azure.vtt	7.3 KB
15. Creating the stage area & loading data in table in snowflake.mp4	15.0 MB
15. Creating the stage area & loading data in table in snowflake.vtt	7.5 KB
/37. Snowflake/assets/
01. Snowflake-Sign-up-Link.xlsx	9.1 KB
07. Walmart.json	30.9 MB
07. YOUTUBE-CHANNELS-DATASET.csv	4.3 KB
11. Azure-Account-Link.xlsx	9.3 KB
/38. Connecting Snowflake to Power BI & Tableau/
01. Connecting Snowflake to Power BI.mp4	24.7 MB
01. Connecting Snowflake to Power BI.vtt	5.9 KB
02. Connecting Snowflake to Tableau.mp4	21.5 MB
02. Connecting Snowflake to Tableau.vtt	6.4 KB
/39. AWS + Snowflake + Power BI Project/
01. Creating Amazon S3 Bucket & Loading Data into it.mp4	19.4 MB
01. Creating Amazon S3 Bucket & Loading Data into it.vtt	3.9 KB
02. Creating the Role.mp4	8.8 MB
02. Creating the Role.vtt	2.1 KB
03. Creating the Integration Object & Updating the Trust Policy.mp4	31.9 MB
03. Creating the Integration Object & Updating the Trust Policy.vtt	5.2 KB
04. Loading Data into Snowflake.mp4	9.8 MB
04. Loading Data into Snowflake.vtt	5.0 KB
05. Understanding the Data.mp4	26.0 MB
05. Understanding the Data.vtt	13.7 KB
06. Data Transformation using Snowflake SQL.mp4	36.2 MB
06. Data Transformation using Snowflake SQL.vtt	14.2 KB
07. Adding Rainfall Groups Column.mp4	21.1 MB
07. Adding Rainfall Groups Column.vtt	7.2 KB
08. Importing Data into Power BI from Snowflake.mp4	16.6 MB
08. Importing Data into Power BI from Snowflake.vtt	5.6 KB
09. Adding Rainfall Analysis page in the Power BI report.mp4	36.7 MB
09. Adding Rainfall Analysis page in the Power BI report.vtt	19.0 KB
10. Adding Other Pages to the Power BI report.mp4	36.1 MB
10. Adding Other Pages to the Power BI report.vtt	11.5 KB
11. Publishing the report to Power BI Service.mp4	3.4 MB
11. Publishing the report to Power BI Service.vtt	2.0 KB
/assets/
03. Lec-3.txt	0.4 KB
04. Lec-4.txt	1.1 KB
04. data-season.csv	224.0 KB
06. Lec-6.txt	0.7 KB
07. Lec-7.txt	0.5 KB
/40. AWS + Snowflake + Tableau Project/
01. Creating & Loading Data to S3 Bucket.mp4	14.8 MB
01. Creating & Loading Data to S3 Bucket.vtt	3.6 KB
02. Creating the Role.mp4	18.9 MB
02. Creating the Role.vtt	2.5 KB
03. Creating the Integration Object & updating the trust policy.mp4	29.1 MB
03. Creating the Integration Object & updating the trust policy.vtt	4.9 KB
04. Loading Data into Snowflake.mp4	13.2 MB
04. Loading Data into Snowflake.vtt	5.5 KB
05. Data Understanding.mp4	25.0 MB
05. Data Understanding.vtt	11.9 KB
06. Data Transformation using Snowflake SQL.mp4	39.9 MB
06. Data Transformation using Snowflake SQL.vtt	11.0 KB
07. Connecting Snowflake to Tableau.mp4	7.3 MB
07. Connecting Snowflake to Tableau.vtt	3.8 KB
08. Creating Charts for Monthly Usage Consumption.mp4	21.1 MB
08. Creating Charts for Monthly Usage Consumption.vtt	11.7 KB
09. Creating Charts for Cost Savings.mp4	14.8 MB
09. Creating Charts for Cost Savings.vtt	6.8 KB
10. Creating the Dashboard.mp4	32.0 MB
10. Creating the Dashboard.vtt	11.0 KB
11. Publishing the workbook to Tableau Cloud.mp4	14.1 MB
11. Publishing the workbook to Tableau Cloud.vtt	5.0 KB
/assets/
01. Renewable-Energy-Usage-Sampled.csv	72.2 KB
03. Lec-3.txt	0.4 KB
04. Lec-4.txt	1.1 KB
Total files 1141