Data Analysis Masterclass (4 courses in 1)
Data Analysis Masterclass (4 courses in 1)

Learn how to build your Data Analysis and Data Visualization skills using Excel, Python, SQL and Tableau with exercises.

Created by Data Is Good Academy
Language English

Data Analysis Masterclass (4 courses in 1)

Data Analysis Masterclass (4 courses in 1)
Data Analysis Masterclass (4 courses in 1)

Learn how to build your Data Analysis and Data Visualization skills using Excel, Python, SQL and Tableau with exercises.

Created by Data Is Good Academy
Language English
01 Excel Fundamentals
  • 001 How is Excel important to businesses 00:02:34
  • 001 S01- Excel Basics .zip
  • 002 Understanding the excel interface 00:02:21
  • 003 Basic Formatting in Excel 00:02:08
  • 004 Insertion and Deletion in Excel 00:02:07
  • 005 Data Types in Excel 00:06:15
  • 006 Quiz Solution 00:03:01
  • 007 Applying the sort function 00:02:09
  • 007 S02- Sort and Filter .zip
  • 008 Applying the filter function 00:01:38
  • 009 Applying the advanced filter function 00:02:48
  • 010 Quiz Solution 00:03:04
  • 011 S03- Text functions .zip
  • 011 Using the UPPER LOWER and PROPER functions 00:03:16
  • 012 Using the LEFT RIGHT and SEARCH functions 00:03:20
  • 013 Using the TRIM CONCAT and LEN functions 00:02:46
  • 014 Quiz Solution 00:04:37
  • 015 S05- Logical functions .zip
  • 015 Using the MIN MAX AVERAGE functions 00:02:13
  • 016 Finding the Standard deviations 00:03:03
  • 017 Find the percentiles of data 00:02:58
  • 018 Finding the Outliers present in data 00:03:38
  • 019 Finding the Missing values in data 00:01:49
  • 020 Quiz Solution 00:04:32
  • 021 S07- Lookup functions .zip
  • 021 Using the IF function 00:01:38
  • 022 Using the IF ERROR function 00:02:12
  • 023 Applying the COUNTIF function 00:02:10
  • 024 Applying the SUNIF function 00:01:55
  • 025 Applying the AVERAGEIF function 00:01:56
  • 026 Quiz Solution 00:03:29
  • 027 Using Colorbars for formatting 00:01:47
  • 028 Using Colorscales for formatting 00:01:39
  • 029 Quiz Solution 00:03:59
02 Excel for Data Analysis
  • 001 Applying VLOOKUP function 00:03:32
  • 002 Applying HLOOKUP function 00:02:03
  • 003 Quiz Solution 00:03:10
  • 004 Why to use Index and Match 00:02:29
  • 005 Applying Index and Match 00:02:37
  • 006 Quiz Solution 00:03:10
  • 007 Making Pivot Tables 00:03:40
  • 008 Making Pivot Charts 00:01:58
  • 009 Quiz Solution 00:03:02
  • 010 Basics of Data Visualizations 00:02:09
  • 011 Making Charts in Excel 00:03:44
  • 012 Making Dashboards 00:02:31
  • 013 Adding Slicers in Dashboards 00:02:33
  • 014 Formatting dashboards 00:01:55
  • 015 Quiz Solution 00:02:51
  • 016 Goal Seek Analysis 00:02:54
  • 017 Data Tables 00:02:45
  • 018 Scenario Management 00:03:17
  • 019 Quiz Solution 00:04:00
  • 020 Understanding Regression 00:01:58
  • 021 Performing Linear Regression 00:02:19
  • 022 Quiz Solution 00:04:58
  • 030 S07- Lookup functions .zip
  • 033 S08- Index and Match .zip
  • 036 S09- Pivot Tables .zip
  • 039 S10- Dashboards .zip
  • 045 S11- What if Analysis .zip
  • 049 S12- Regression .zip
03 SQL Introduction
  • 001 Introduction to SQL 00:03:49
  • 002 Build your first SQL query 00:05:15
  • 003 Basic SQL queries Part - 1 00:07:27
  • 004 Basic SQL queries Part - 2 00:06:36
  • 005 Brain Buster Exercise 00:02:29
  • 006 Brain Buster Solution 00:04:44
  • 007 Quiz Solution 00:04:00
  • 008 Installation 00:04:27
  • 009 Interface walkthrough 00:04:00
  • 010 Creating Required Databases 00:02:16
  • 011 Quiz Solution 00:02:42
  • 012 Type of SQL Commands 00:04:38
  • 013 The SELECT Command 00:03:44
  • 014 Numerical Functions 00:05:43
  • 015 String Functions 00:05:57
  • 016 Exercises on String Functions 00:06:52
  • 017 The Having Clause 00:04:09
  • 018 Filtering using the Like Operator 00:06:48
  • 019 Quiz Solution 00:06:07
  • 052 SQL-Fundamentals-PPTs .zip
  • 059 2.-Installation-and-Set-up .zip
  • 063 3.-Introduction-to-DQL .zip
04 SQL Deep Dive
  • 001 Numerical Datatypes 00:08:50
  • 002 String Datatypes 00:08:04
  • 003 Constraints 00:06:59
  • 004 Quiz Solution 00:05:52
  • 005 Creating Databases and Tables 00:09:00
  • 006 Alter Drop and Truncate 00:03:30
  • 007 Insert Update and Delete 00:04:48
  • 008 Quiz Solution 00:03:24
  • 009 Foreign Key 00:05:58
  • 010 Joins 00:06:00
  • 011 Left Right and Outer Join 00:06:59
  • 012 Compound Joins and Multiple Joins 00:04:14
  • 013 Star Schema 00:03:45
  • 014 Sub Queries Part 1 00:05:08
  • 015 Sub Queries Part 2 00:07:02
  • 016 Quiz Solution 00:04:29
  • 017 Connecting MySQL through Python 00:06:23
  • 018 Loading Tables into a Pandas DataFrame 00:04:12
  • 019 Quiz Solution 00:03:59
  • 071 4.-Introduction-to-DDL-and-DML .zip
  • 071 SQL-Deep-Dive-PPTs .zip
  • 079 5.-Joins-Sub-queries-and-set-operations .zip
  • 087 6.-Accessing-Databases-using-Python .zip
05 Python Fundamentals
  • 001 Why should you learn Python 00:06:19
  • 002 Installing Python and Jupyter Notebook 00:06:27
  • 003 Understanding the Interface of Jupyter Notebook 00:06:41
  • 004 Naming Convention for variables 00:07:37
  • 005 Built in Data Types and Type Casting 00:07:19
  • 006 Scope of Variables 00:05:18
  • 007 Quiz Solution 00:04:35
  • 008 Exercise on Variables and Data Types 00:02:43
  • 009 Solution on Variables and Data Types 00:02:37
  • 010 Exercise on Scope of Variables 00:03:57
  • 011 Solution on Scope of Variables 00:02:39
  • 012 Arithmetic and Assignment Operators 00:08:42
  • 013 Comparison Logical and Bitwise Operators 00:07:49
  • 014 Identity and Membership Operators 00:03:17
  • 015 Quiz Solution 00:03:36
  • 016 Exercise on Arithmetic and Assignment Operators 00:03:50
  • 017 Solution on Arithmetic and Assignment Operators 00:03:21
  • 018 Exercise on Comparison Logical and Bitwise Operators 00:04:06
  • 019 Solution on Comparison Logical and Bitwise Operators 00:03:33
  • 020 Exercise on Identity and Membership Operators 00:03:26
  • 021 Solution on Identity and Membership Operators 00:02:36
  • 022 String Formatting 00:04:48
  • 023 String Methods 00:05:53
  • 024 User Input 00:03:07
  • 025 Quiz Solution 00:03:42
  • 026 Exercise on Strings 00:02:39
  • 027 Solution on Strings 00:03:20
  • 028 If elif and else 00:04:09
  • 029 For and While 00:05:41
  • 030 Break and Continue 00:03:15
  • 031 Quiz Solution 00:03:48
  • 032 Exercise on Loops and Conditionals 00:03:52
  • 033 Solution on Loops and Conditionals 00:04:32
  • 090 WhyshouldwelearnPython .pptx
  • 093 02.Variables .ipynb
  • 093 NamingConventionforvariables .pptx
  • 094 BuiltinDataTypesandTypeCasting .pptx
  • 094 DataTypesandTypeCasting .ipynb
  • 095 ScopeofVariables .pptx
  • 101 ArithematicandAssignmentOperators .ipynb
  • 102 ComparisonLogicalandBitwiseOperators .ipynb
  • 103 IdentityandMembershipOperators .ipynb
  • 111 StringFormatting .ipynb
  • 112 StringMethods .ipynb
  • 113 UserInput .ipynb
  • 117 ifelifandelse .ipynb
  • 118 forandwhileloop .ipynb
  • 119 Breakandcontinue .ipynb
06 Python for Data Science
  • 001 Introduction to datetime 00:02:17
  • 002 The date and time class 00:03:12
  • 003 The datetime class 00:01:44
  • 004 The timedelta class 00:01:15
  • 005 Quiz Solution 00:03:16
  • 006 Exercise on Date and Time 00:03:32
  • 007 Solution on Date and Time 00:03:37
  • 008 Meta Characters for Regular Expressions 00:05:17
  • 009 Built-in Functions for Regular Expressions 00:02:28
  • 010 Special Characters for Regular Expressions 00:02:50
  • 011 Sets for Regular Expressions 00:04:19
  • 012 Quiz Solution 00:02:49
  • 013 Exercise on Regular Expressions 00:03:17
  • 014 Solution on Regular Expressions 00:03:31
  • 015 Array Creation using Numpy 00:03:35
  • 016 Mathematical Operations using Numpy 00:02:53
  • 017 Built-in Functions in Numpy 00:02:56
  • 018 Quiz Solution 00:03:50
  • 019 Exercise on Built-in Functions in Numpy 00:03:28
  • 020 Solution on Built-in Functions in Numpy 00:03:16
  • 021 Reading Datasets using Pandas 00:03:46
  • 022 Plotting Data in Pandas 00:02:21
  • 023 Indexing Selecting and Filtering Data using Pandas 00:04:46
  • 024 Merging and Concatenating DataFrames 00:04:59
  • 025 Lambda Map and Apply Functions 00:02:22
  • 026 Quiz Solution 00:04:08
  • 027 Exercise on Pandas Plotting 00:02:38
  • 028 Solution on Pandas Plotting 00:03:55
  • 029 Exercise on Indexing and Selecting 00:02:52
  • 030 Solution on Indexing and Selecting 00:03:07
  • 031 Exercise on Apply Functions 00:03:29
  • 032 Solution on Apply Functions 00:03:25
  • 123 1.Introductiontodatetime .ipynb
  • 124 2.ThedateandtimeClass .ipynb
  • 125 3.Thedatetimeclass .ipynb
  • 126 4.Thetimedeltaclass .ipynb
  • 130 1.MetaCharactersforRegularExpressions .ipynb
  • 131 2.Built-infunctionsforRegularExpressions .ipynb
  • 132 3.SpecialCharactersforRegularExpressions .ipynb
  • 133 4.SetsforRegularExpressions .ipynb
  • 137 1.ArrayCreationusingNumpy .ipynb
  • 138 2.MathematicalfunctionsusingNumpy .ipynb
  • 139 3.Built-infunctionsinNumpy .ipynb
  • 143 1.ReadingDatasetsusingPandas .ipynb
  • 143 Iris .csv
  • 144 2.PlottingDatainPandas .ipynb
  • 145 3.IndexingSlicingandFiltering .ipynb
  • 146 4.MergingandConcatenating .ipynb
  • 146 Merging .pptx
  • 147 5.LambdaMapandApplyfunctions .ipynb
  • 147 employee .csv
07 Tableau Fundamentals
  • 001 Getting Started with Tableau 00:07:15
  • 002 Navigating Tableau 00:08:37
  • 003 Creating Your First Visualization 00:09:03
  • 004 Building Your First Dashboard 00:05:28
  • 005 Introduction 00:01:45
  • 006 Dimensions and Measures 00:08:25
  • 007 Green Blue Pills 00:07:55
  • 008 Measures Names Values 00:02:27
  • 009 Working with Time Series Data 00:09:43
  • 010 Aggregation and Granularity 00:08:43
  • 011 Aggregation Options 00:03:08
  • 012 Show Me Toolbar 00:04:47
  • 013 Marks cards Level of Detail 00:13:08
  • 014 Custom Shapes 00:04:19
  • 015 Filtering Data 00:10:54
  • 016 Pages Shelf 00:04:42
  • 017 Exercise on Building Blocks of Data Visualization 00:01:43
  • 018 Solution on Building Blocks of Data Visualization 00:14:37
  • 019 Highlight Table 00:08:02
  • 020 Highlight Table Bar Charts Sorting 00:06:14
  • 021 Bar-in-Bar 00:04:25
  • 022 Histogram 00:07:46
  • 023 Pie Charts 00:05:01
  • 024 Pie Chart Exercise Solution 00:04:21
  • 025 Tree Map 00:04:29
  • 026 Bubble Chart 00:04:06
  • 027 Line Charts 00:07:36
  • 028 Area Chart 00:07:26
  • 029 Heat Map 00:05:34
  • 030 Exercise on Tableau Basic Visualization (Vietnam War Dataset) 00:10:33
  • 031 Solution on Tableau Basic Visualization 00:22:34
  • 032 Overview 00:03:28
  • 033 Theme Workbook Level Formatting 00:04:41
  • 034 Axis Lines and Formatting 00:08:30
  • 035 Parts of the View 00:03:41
  • 036 Formatting Pane - Part 1 00:02:57
  • 037 Formatting Pane - Part 2 (Fonts Alignment Shading) 00:08:58
  • 038 Formatting Pane - Part 3 (Borders Lines) 00:05:41
  • 039 Number Format 00:05:22
  • 040 Titles Captions 00:07:35
  • 041 Mark Labels 00:05:18
  • 042 Styling and Customizing a Tooltip 00:04:48
  • 043 Visualization in Tooltip 00:04:03
  • 044 Editing Axis 00:10:06
  • 045 Annotating the Viz 00:06:34
  • 046 Section Exercise - Data Ink Ratio 00:02:16
  • 047 Section Exercise Solution - Data Ink Ratio 00:07:38
  • 155 CreatingYourFirstVisualizationsandDashboard .zip
  • 159 BuildingBlocksofDataVisualization .zip
  • 173 TableauBasicVisualization .zip
  • 186 FormattinginTableau .zip
08 Outro Section
  • 001 Conclusion 00:02:11
  • 002 How to Get Your Certificate of Completion .html
09 Bonus Section
  • 001 Bonus Lecture .html