Udemy - Data Analysis Masterclass (4 courses in 1) [FCS]

Files:

• [CourseClub.ME].url (0.1 KB)
• [FCS Forum].url (0.1 KB)
• [FreeCourseSite.com].url (0.1 KB)
• [GigaCourse.Com].url (0.0 KB)

• 001 How is Excel important to businesses.mp4 (49.3 MB)
• 002 Understanding the excel interface.mp4 (26.7 MB)
• 003 Basic Formatting in Excel.mp4 (35.9 MB)
• 004 Insertion and Deletion in Excel.mp4 (37.1 MB)
• 005 Data Types in Excel.mp4 (68.8 MB)
• 006 Q and A.mp4 (32.0 MB)
• 007 Thanks for your Support.mp4 (34.0 MB)
• 008 Quiz Solution.mp4 (37.0 MB)
• 009 Applying the sort function.mp4 (29.4 MB)
• 010 Applying the filter function.mp4 (26.9 MB)
• 011 Applying the advanced filter function.mp4 (42.5 MB)
• 012 Quiz Solution.mp4 (44.2 MB)
• 013 Using the UPPER, LOWER and PROPER functions.mp4 (54.9 MB)
• 014 Using the LEFT, RIGHT and SEARCH functions.mp4 (57.8 MB)
• 015 Using the TRIM, CONCAT and LEN functions.mp4 (48.2 MB)
• 016 Quiz Solution.mp4 (69.9 MB)
• 017 Using the MIN, MAX AVERAGE functions.mp4 (36.6 MB)
• 018 Finding the Standard deviations.mp4 (49.6 MB)
• 019 Find the percentiles of data.mp4 (48.5 MB)
• 020 Finding the Outliers present in data.mp4 (57.4 MB)
• 021 Finding the Missing values in data.mp4 (35.0 MB)
• 022 Quiz Solution.mp4 (57.7 MB)
• 023 Using the IF function.mp4 (28.2 MB)
• 024 Using the IF ERROR function.mp4 (33.5 MB)
• 025 Applying the COUNTIF function.mp4 (34.2 MB)
• 026 Applying the SUMIF function.mp4 (30.6 MB)
• 027 Applying the AVERAGEIF function.mp4 (32.1 MB)
• 028 Quiz Solution.mp4 (43.8 MB)
• 029 Using Colorbars for formatting.mp4 (31.0 MB)
• 030 Using Colorscales for formatting.mp4 (30.8 MB)
• 031 Quiz Solution.mp4 (50.5 MB)
S01- Excel Basics
• Excel_Example.xls (157.0 KB)
S02- Sort and Filter
• Excel_Example.xls (157.0 KB)
S03- Text functions
• Excel_Example.xls (157.0 KB)
S04- Statistical functions
• Excel_Example.xls (157.0 KB)
• market_fact.csv (605.3 KB)
S05- Logical functions
• market_fact.csv (605.3 KB)
02 Excel for Data Analysis
• 001 Applying VLOOKUP function.mp4 (58.4 MB)
• 002 Applying HLOOKUP function.mp4 (25.6 MB)
• 003 Quiz Solution.mp4 (43.3 MB)
• 004 Why to use Index and Match_.mp4 (52.1 MB)
• 005 Applying Index and Match.mp4 (38.4 MB)
• 006 Quiz Solution.mp4 (40.2 MB)
• 007 Making Pivot Tables.mp4 (44.3 MB)
• 008 Making Pivot Charts.mp4 (28.5 MB)
• 009 Quiz Solution.mp4 (40.6 MB)
• 010 Basics of Data Visualizations.mp4 (41.9 MB)
• 011 Making Charts in Excel.mp4 (50.4 MB)
• 012 Making Dashboards.mp4 (38.8 MB)
• 013 Adding Slicers in Dashboards.mp4 (33.0 MB)
• 014 Formatting dashboards.mp4 (28.0 MB)
• 015 Quiz Solution.mp4 (39.2 MB)
• 016 Goal Seek Analysis.mp4 (42.8 MB)
• 017 Data Tables.mp4 (32.8 MB)
• 018 Scenario Management.mp4 (46.1 MB)
• 019 Quiz Solution.mp4 (53.4 MB)
• 020 Understanding Regression.mp4 (39.0 MB)
• 021 Performing Linear Regression.mp4 (33.6 MB)
• 022 Quiz Solution.mp4 (72.6 MB)
S07- Lookup functions
• MOCK_DATA.xlsx (11.0 KB)
S08- Index and MAtch
• MOCK_DATA.xlsx (9.1 KB)
S09- Pivot Tables
• MOCK_DATA.xlsx (25.5 KB)
S10- Dashboards
• Orders_data.xlsx (1.5 MB)
S11- What if Analysis
• What if Analysis.xlsx (15.1 KB)
S12- Regression
• Salary_Data.xls (20.5 KB)
03 SQL Introduction
• 001 Introduction to SQL.mp4 (75.5 MB)
• 002 Build your first SQL query.mp4 (90.8 MB)
• 003 Basic SQL queries Part - 1.mp4 (103.5 MB)
• 004 Basic SQL queries Part - 2.mp4 (105.2 MB)
• 005 Brain Buster Exercise.mp4 (20.4 MB)
• 006 Brain Buster Solution.mp4 (31.2 MB)
• 007 Quiz Solution.mp4 (50.7 MB)
• 008 Installation.mp4 (68.0 MB)
• 009 Interface walkthrough.mp4 (47.5 MB)
• 010 Creating Required Databases.mp4 (34.9 MB)
• 011 Quiz Solution.mp4 (43.9 MB)
• 012 Type of SQL Commands.mp4 (92.2 MB)
• 013 The SELECT Command.mp4 (67.9 MB)
• 014 Numerical Functions.mp4 (75.2 MB)
• 015 String Functions.mp4 (60.7 MB)
• 016 Exercises on String Functions.mp4 (84.8 MB)
• 017 The Having Clause.mp4 (66.2 MB)
• 018 Filtering using the Like Operator.mp4 (95.7 MB)
• 019 Quiz Solution.mp4 (58.2 MB)
2. Installation and Set up
• database.sql (86.0 KB)
3. Introduction to DQL
• HavingClause.sql (0.9 KB)
• LIKE_operator.sql (2.0 KB)
• NumericFunctions.sql (2.1 KB)
• Select.sql (1.0 KB)
• StringFunctions.sql (2.1 KB)
• StringFunctionsExercise.sql (1.4 KB)
SQL Fundamentals PPTs Section 1
• 2. Build your first SQL query.pptx (1.0 MB)
• 4. Basic SQL Queries.pptx (700.2 KB)
• 5. Basic SQL Queries Part-2.pptx (697.6 KB)
• DGD Slide Master.pptx (897.8 KB)
Section 3
• 1. Types of SQL commands.pptx (712.5 KB)
04 SQL Deep Dive
• 001 Numerical Datatypes.mp4 (165.4 MB)
• 002 String Datatypes.mp4 (145.5 MB)
• 003 Constraints.mp4 (122.3 MB)
• 004 Quiz Solution.mp4 (61.9 MB)
• 005 Creating Databases and Tables.mp4 (156.7 MB)
• 006 Alter, Drop, and Truncate.mp4 (44.8 MB)
• 007 Insert, Update, and Delete.mp4 (46.6 MB)
• 008 Quiz Solution.mp4 (42.6 MB)
• 009 Foreign Key.mp4 (93.9 MB)
• 010 Joins.mp4 (77.2 MB)
• 011 Left, Right, and Outer Join.mp4 (106.3 MB)
• 012 Compound Joins, and Multiple Joins.mp4 (59.3 MB)
• 013 Star Schema.mp4 (73.9 MB)
• 014 Sub Queries Part 1.mp4 (72.8 MB)
• 015 Sub Queries Part 2.mp4 (76.3 MB)
• 016 Quiz Solution.mp4 (55.3 MB)
• 017 Connecting MySQL through Python.mp4 (94.0 MB)
• 018 Loading Tables into a Pandas DataFrame.mp4 (64.3 MB)
• 019 Quiz Solution.mp4 (49.0 MB)
4. Introduction to DDL and DML
• alter_drop_truncate.sql (1.4 KB)
• creating_databases_and_tables.sql (0.5 KB)
• insert_update_delete.sql (1.3 KB)
5. Joins, Sub queries and set operations
• Delete_Subquery.sql (1.1 KB)
• ForeignKey.sql (0.8 KB)
• Joins.sql (1.9 KB)
• Subqueries_p1.sql (0.9 KB)
• Subqueries_p2.sql (1.1 KB)
• compound_joins.sql (1.4 KB)
• left_right_outer.sql (1.5 KB)
6. Accessing Databases using Python
• connecting_mysql_python.py (0.4 KB)
• load_data_into_pandas_dataframe.py (0.6 KB)
SQL Deep Dive Section 4
• 1. Numerical Datatypes.pptx (931.8 KB)
• 2. String Datatypes.pptx (1,019.7 KB)
• 3. Constraints.pptx (883.8 KB)
Section 5
• 1. Foreign Key.pptx (555.7 KB)
• 2. Joins.pptx (565.2 KB)
• 3. Left , Right and Full Outer Join.pptx (615.0 KB)
• 4. Compound Join.pptx (539.8 KB)
• 5. Introduction to Star Schema.pptx (593.5 KB)
05 Python Fundamentals
• 001 Why should you learn Python_.mp4 (129.0 MB)
• 002 Installing Python and Jupyter Notebook.mp4 (95.2 MB)
• 003 Understanding the Interface of Jupyter Notebook.mp4 (70.3 MB)
• 004 Naming Convention for variables.mp4 (94.9 MB)
• 005 Built in Data Types and Type Casting.mp4 (137.5 MB)
• 006 Scope of Variables.mp4 (66.5 MB)
• 007 Quiz Solution.mp4 (46.5 MB)
• 008 Exercise on Variables and Data Types.mp4 (54.0 MB)
• 009 Solution on Variables and Data Types.mp4 (34.8 MB)
• 010 Exercise on Scope of Variables.mp4 (74.0 MB)
• 011 Solution on Scope of Variables.mp4 (33.8 MB)
• 012 Arithmetic and Assignment Operators.mp4 (78.0 MB)
• 013 Comparison, Logical, and Bitwise Operators.mp4 (62.4 MB)
• 014 Identity and Membership Operators.mp4 (39.2 MB)
• 015 Quiz Solution.mp4 (34.2 MB)
• 016 Exercise on Arithmetic and Assignment Operators.mp4 (72.4 MB)
• 017 Solution on Arithmetic and Assignment Operators.mp4 (41.5 MB)
• 018 Exercise on Comparison, Logical, and Bitwise Operators.mp4 (77.3 MB)
• 019 Solution on Comparison, Logical, and Bitwise Operators.mp4 (39.4 MB)
• 020 Exercise on Identity and Membership Operators.mp4 (65.2 MB)
• 021 Solution on Identity and Membership Operators.mp4 (34.6 MB)
• 022 String Formatting.mp4 (51.3 MB)
• 023 String Methods.mp4 (43.3 MB)
• 024 User Input.mp4 (41.0 MB)
• 025 Quiz Solution.mp4 (53.1 MB)
• 026 Exercise on Strings.mp4 (52.9 MB)
• 027 Solution on Strings.mp4 (42.7 MB)
• 028 If, elif, and else.mp4 (65.9 MB)
• 029 For and While.mp4 (53.1 MB)
• 030 Break and Continue.mp4 (40.7 MB)
• 031 Quiz Solution.mp4 (49.0 MB)
• 032 Exercise on Loops and Conditionals.mp4 (74.5 MB)
• 033 Solution on Loops and Conditionals.mp4 (50.0 MB)
• 092 Why+should+we+learn+Python.pptx (1.8 MB)
• 095 02.+Variables.ipynb (9.7 KB)
• 095 Naming+Convention+for+variables.pptx (600.4 KB)
• 096 Built+in+Data+Types+and+Type+Casting.pptx (811.4 KB)
• 096 Data+Types+and+Type+Casting.ipynb (1.6 KB)
• 097 Scope+of+Variables.pptx (839.9 KB)
• 103 Arithematic+and+Assignment+Operators.ipynb (11.8 KB)
• 104 Comparison,+Logical+and+Bitwise+Operators.ipynb (11.0 KB)
• 105 Identity+and+Membership+Operators.ipynb (3.7 KB)
• 113 String+Formatting.ipynb (2.8 KB)
• 114 String+Methods.ipynb (4.8 KB)
• 115 User+Input.ipynb (1.7 KB)
• 119 if,+elif+and+else.ipynb (1.5 KB)
• 120 for+and+while+loop.ipynb (2.7 KB)
• 121 Break+and+continue.ipynb (1.5 KB)
06 Python for Data Science
• 001 Introduction to datetime.mp4 (37.5 MB)
• 002 The date and time class.mp4 (33.6 MB)
• 003 The datetime class.mp4 (22.6 MB)
• 004 The timedelta class.mp4 (19.3 MB)
• 005 Quiz Solution.mp4 (44.0 MB)
• 006 Exercise on Date and Time.mp4 (66.0 MB)
• 007 Solution on Date and Time.mp4 (39.3 MB)
• 008 Meta Characters for Regular Expressions.mp4 (74.1 MB)
• 009 Built-in Functions for Regular Expressions.mp4 (37.6 MB)
• 010 Special Characters for Regular Expressions.mp4 (40.9 MB)
• 011 Sets for Regular Expressions.mp4 (56.1 MB)
• 012 Quiz Solution.mp4 (32.9 MB)
• 013 Exercise on Regular Expressions.mp4 (62.1 MB)
• 014 Solution on Regular Expressions.mp4 (33.7 MB)
• 015 Array Creation using Numpy.mp4 (51.0 MB)
• 016 Mathematical Operations using Numpy.mp4 (36.4 MB)
• 017 Built-in Functions in Numpy.mp4 (40.0 MB)
• 018 Quiz Solution.mp4 (57.6 MB)
• 019 Exercise on Built-in Functions in Numpy.mp4 (64.3 MB)
• 020 Solution on Built-in Functions in Numpy.mp4 (37.4 MB)
• 021 Reading Datasets using Pandas.mp4 (65.7 MB)
• 022 Plotting Data in Pandas.mp4 (35.7 MB)
• 023 Indexing, Selecting, and Filtering Data using Pandas.mp4 (68.9 MB)
• 024 Merging and Concatenating DataFrames.mp4 (76.7 MB)
• 025 Lambda, Map, and Apply Functions.mp4 (37.2 MB)
• 026 Quiz Solution.mp4 (54.7 MB)
• 027 Exercise on Pandas Plotting.mp4 (50.8 MB)
• 028 Solution on Pandas Plotting.mp4 (39.1 MB)
• 029 Exercise on Indexing and Selecting.mp4 (55.5 MB)
• 030 Solution on Indexing and Selecting.mp4 (40.1 MB)
• 031 Exercise on Apply Functions.mp4 (64.9 MB)
• 032 Solution on Apply Functions.mp4 (38.5 MB)
• 125 1.+Introduction+to+datetime.ipynb (1.0 KB)
• 126 2.+The+date+and+time+Class.ipynb (3.5 KB)
• 127 3.+The+datetime+class.ipynb (2.1 KB)
• 128 4.+The+timedelta+class.ipynb (2.4 KB)
• 132 1.+Meta+Characters+for+Regular+Expressions.ipynb (4.4 KB)
• 133 2.+Built-in+functions+for+Regular+Expressions.ipynb (2.0 KB)
• 134 3.+Special+Characters+for+Regular+Expressions.ipynb (2.5 KB)
• 135 4.+Sets+for+Regular+Expressions.ipynb (2.8 KB)
• 139 1.+Array+Creation+using+Numpy.ipynb (3.3 KB)
• 140 2.+Mathematical+functions+using+Numpy.ipynb (4.3 KB)
• 141 3.+Built-in+functions+in+Numpy.ipynb (3.3 KB)
• 145 1.+Reading+Datasets+using+Pandas.ipynb (7.6 KB)
• 145 Iris.csv (5.0 KB)
• 146 2.+Plotting+Data+in+Pandas.ipynb (36.1 KB)
• 147 3.+Indexing,+Slicing+and+Filtering.ipynb (29.6 KB)
• 148 4.+Merging+and+Concatenating.ipynb (29.0 KB)
• 148 Merging.pptx (1,010.0 KB)
• 149 5.+Lambda,+Map+and+Apply+functions.ipynb (16.4 KB)
• 149 employee.csv (222.6 KB)
07 Tableau Fundamentals
• 001 Getting Started with Tableau.mp4 (141.9 MB)
• 002 Navigating Tableau.mp4 (159.0 MB)
• 003 Creating Your First Visualization.mp4 (134.5 MB)
• 004 Building Your First Dashboard.mp4 (81.7 MB)
• 005 Introduction.mp4 (35.2 MB)
• 006 Dimensions and Measures.mp4 (127.3 MB)
• 007 Green & Blue Pills.mp4 (118.8 MB)
• 008 Measures Names & Values.mp4 (35.0 MB)
• 009 Working with Time Series Data.mp4 (134.9 MB)
• 010 Aggregation and Granularity.mp4 (118.4 MB)
• 011 Aggregation Options.mp4 (44.4 MB)
• 012 Show Me Toolbar.mp4 (59.9 MB)
• 013 Marks cards & Level of Detail.mp4 (167.8 MB)
• 014 Custom Shapes.mp4 (56.1 MB)
• 015 Filtering Data.mp4 (136.4 MB)
• 016 Pages Shelf.mp4 (48.9 MB)
• 017 Exercise on Building Blocks of Data Visualization.mp4 (32.8 MB)
• 018 Solution on Building Blocks of Data Visualization.mp4 (184.3 MB)
• 019 Highlight Table.mp4 (116.5 MB)
• 020 Highlight Table Bar Charts & Sorting.mp4 (85.9 MB)
• 021 Bar-in-Bar.mp4 (60.3 MB)
• 022 Histogram.mp4 (118.1 MB)
• 023 Pie Charts.mp4 (62.8 MB)
• 024 Pie Chart Exercise Solution.mp4 (63.8 MB)
• 025 Tree Map.mp4 (63.1 MB)
• 026 Bubble Chart.mp4 (64.1 MB)
• 027 Line Charts.mp4 (123.3 MB)
• 028 Area Chart.mp4 (111.8 MB)
• 029 Heat Map.mp4 (86.1 MB)
• 030 Exercise on Tableau Basic Visualization (Vietnam War Dataset).mp4 (191.7 MB)
• 031 Solution on Tableau Basic Visualization.mp4 (260.0 MB)
• 032 Overview.mp4 (70.1 MB)
• 033 Theme & Workbook Level Formatting.mp4 (65.9 MB)
• 034 Axis Lines and Formatting.mp4 (114.4 MB)
• 035 Parts of the View.mp4 (72.8 MB)
• 036 Formatting Pane - Part 1.mp4 (47.7 MB)
• 037 Formatting Pane - Part 2 (Fonts, Alignment & Shading).mp4 (97.0 MB)
• 038 Formatting Pane - Part 3 (Borders & Lines).mp4 (76.8 MB)
• 039 Number Format.mp4 (68.6 MB)
• 040 Titles & Captions.mp4 (88.6 MB)
• 041 Mark Labels.mp4 (61.1 MB)
• 042 Styling and Customizing a Tooltip.mp4 (61.2 MB)
• 043 Visualization in Tooltip.mp4 (55.6 MB)
• 044 Editing Axis.mp4 (91.5 MB)
• 045 Annotating the Viz.mp4 (70.8 MB)
• 046 Section Exercise - Data Ink Ratio.mp4 (44.1 MB)
• 047 Section Exercise Solution - Data Ink Ratio.mp4 (75.1 MB)
• Building Blocks of Data Visualization Workbook.twbx (871.1 KB)
• CoffeeChain-SimplifiedData.csv (379.7 KB)
• Everest-Fatalities.csv (42.0 KB)
• Everest-Fatalities.twb (115.8 KB)
Formatting Full Material
• Data-Ink Ratio.twb (53.6 KB)
• Formatting.twbx (698.2 KB)
• Paintings.xls (43.5 KB)
• S01. Creating Your First Visualizations and Dashboard.twbx (250.9 KB)
• SuperStoreSalesData.csv (1.7 MB)
• Titanic Workbook.twb (223.5 KB)
• TitanicDataSet.csv (1,019.9 KB)
• Vietnam War Civilian Deaths.csv (0.9 KB)
• Vietnam War Timeline Stats.csv (0.7 KB)
• Vietnam War US Casualties.csv (9.4 MB)
• [Section Exercise] Vietnam War.twbx (81.8 KB)
08 Outro Section
• 001 Conclusion.mp4 (49.2 MB)
• 002 How to Get Your Certificate of Completion.html (1.4 KB)
09 Bonus Section
• 001 Bonus Lecture.html (4.6 KB)