Data Science Course, Zidio Learning, Learn Data Science, Python for Data Science, Machine Learning, AI, Data Analytics, Big Data, Deep Learning, Data Visualization, Online Data Science Traini ;

Course / Course Details

Data Science

Data

By - Super admin
266 students
N/A
(0)

Course Requirements

To enroll in this course, you should have:

Basic Programming Skills: Familiarity with Python is recommended but not mandatory.
Mathematical Knowledge: A foundational understanding of linear algebra, statistics, and probability is beneficial.
Access to a Computer: A laptop or desktop with internet access and the ability to run Python-based tools.
Curiosity and Dedication: A strong desire to work with data and solve challenging problems.

This course caters to beginners looking to step into the world of data science as well as professionals aiming to enhance their data-driven decision-making skills.

Course Description

This course is designed to provide a deep understanding of data science concepts, tools, and techniques. You will explore the entire data science lifecycle, from data collection and preprocessing to model building, evaluation, and deployment. Leveraging Python and popular libraries like Pandas, NumPy, Matplotlib, and Scikit-learn, this course emphasizes practical, hands-on experience with real-world datasets and applications.

Course Outcomes

Upon completing this course, you will be able to:

Understand the fundamentals of data science and its applications across industries.
Work with structured and unstructured data for analysis and modeling.
Utilize data visualization techniques to derive actionable insights.
Build predictive and classification models using machine learning algorithms.
Apply statistical methods to analyze and interpret data.
Master tools like Python, Jupyter Notebook, Pandas, and Matplotlib for efficient data handling.
Develop skills to solve real-world business problems using data-driven approaches.

Course Curriculum

8 chapters
325 lectures
0 quizzes
N/A total length

Toggle all chapters

1 Welcome to Intro to Data and Data Science

2 Business and data science buzzwords

5.21 Min

3 Analysis vs Analytics

3.5 Min

4 Intro to Business Analytics, Data Analytics, and Data Science

8.26 Min

5 An Overview of our Data Science Infographic

4.03 Min

6 Why do we need each of these disciplines

3.46 Min

7 Traditional Data - Techniques

8.13 Min

8 Traditional Data - Real-life Examples

1.44 Min

9 Big Data - Techniques

4.26 Min

10 Big Data - Real-life Examples

1.32 Min

11 Business Intelligence (BI) - Techniques

6.45 Min

12 Business Intelligence (BI) - Real-life Examples

1.42 Min

13 Traditional Methods - Techniques

9.08 Min

14 Traditional Methods - Real-life Examples

2.45 Min

15 Machine Learning (ML) - Techniques

6.55 Min

16 Machine Learning (ML) - Types of Machine Learning

8.13 Min

17 Machine Learning (ML) - Real-life Examples

2.11 Min

18 Programming Languages & Software Employed in Data Science - All the Tools You Need

5.51 Min

19 Data Science Job Positions - What do they Involve and What to Look out for

3.29 Min

20 Dispelling Common Misconceptions

4.1 Min

1 Excel Made Easy - A Beginner's Guide to Excel Spreadsheets

3.32 Min

2 Data Entry Techniques in Excel

3 Min

3 How to Make Your Spreadsheets Look Professional

5.49 Min

4 Inserting, Deleting, and Modifying Rows & Columns

1.44 Min

5 Excel Formulas for Beginners

2.54 Min

6 Excel Functions

3.41 Min

7 Work Efficiently by Using Cut, Copy, and Paste

2.1 Min

8 Pasting Values, Formulas and Formats with Paste Special

1.16 Min

9 Inserting a Line Break with Alt + Enter

10 Do More with Your Sales Data with Excel's Text to Columns Feature

1.52 Min

11 Create Easily Printable Excel Documents

1.11 Min

12 How to Wrap Text in Excel and Adjust a Cell's Size

13 Insert Hyperlinks into Excel Spreadsheets

1.16 Min

14 Using Excel's Freeze Panes to Handle Large Datasets

1.12 Min

15 Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do

16 A Quick Introduction to Excel's Pivot Tables

2.17 Min

17 Initial Formatting Is Key for Creating Professional-looking Spreadsheets

1.53 Min

18 How to Use the Same Macro On Multiple Workbooks

1.34 Min

19 The Secret to Faster Scrolling in Excel

1.36 Min

20 Be even quicker - F5 + Enter

1.51 Min

21 Using Absolute and Relative Cell References

2.15 Min

22 Find and Select Cells That Meet Specific Conditions

1.3 Min

23 How to Create Dynamic Names in Excel Spreadsheets

1.22 Min

24 Using Named Ranges to Make Formulas More Readable

1.34 Min

25 Custom Number Formatting

1.34 Min

26 How to Add a Drop-down List in Excel

1.49 Min

27 Using Custom-sort to Sort Multiple Columns Within a Table

1.23 Min

28 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts

4.15 Min

29 Multiply by 1

1.34 Min

30 Find and Replace - References

3.03 Min

31 Find and Replace - Formatting

1.53 Min

32 Green References

1.31 Min

33 Beauty Saving - The Professional Way of Saving Files

2.13 Min

34 The Power of F2

N/A

35 Conditional Formatting

N/A

36 Key Excel Functions - If

2.35 Min

37 Enlarge the formula bar

1.03 Min

38 Key Excel Functions - Sum, Sumif, Sumifs

4.2 Min

39 Key Excel Functions - Count, Counta, Countif, Countifs

3.58 Min

40 Key Excel Functions - Average & Averageif

1.54 Min

41 Key Excel Functions - Left, Right, Mid, Upper, Lower, Proper, Concatenate .

4.25 Min

42 Working with text in Excel

2.4 Min

43 Find the Highest and Lowest Values in a Range - Max & Min

44 = and + are interchangeable when you start typing a formula

45 Use Round in Your Financial Models

1.01 Min

46 Excel's Lookup Functions - Vlookup & Hlookup Made Easy

7.42 Min

47 Index, Match, and Their Combination - The Perfect Substitute for Vlookup

7.27 Min

48 Using Excel's Iferror Function to Trap Spreadsheet Errors

1.43 Min

49 A Useful Tool for Financial Analysis - The Rank Function

2.36 Min

50 Create Flexible Financial Models with Choose

2.24 Min

51 Goal Seek Will Help You Find the Result You Are Looking For

2.17 Min

52 Perform Sensitivity Analysis with Excel's Data Tables Functionality

4.05 Min

53 Introduction to Excel Charts

54 Beginner's Guide to Inserting Charts in Excel

2.05 Min

55 Modifying Excel Charts - The Easy Way

2.24 Min

56 Making Your Excel Charts Sexier - Proven Tips

3.05 Min

57 Creating a Bridge Chart in Excel 2016 - As Easy as It Gets

1.37 Min

58 New Ways to Visualize Your Data - Treemap Charts

1.26 Min

59 How to Represent Trends with Sparklines

3.47 Min

60 Stacked Column Chart with a Secondary Axis

5.3 Min

61 Doughnut Chart

4.58 Min

62 Area Chart

3.33 Min

63 Bridge Chart

6.51 Min

64 Intro to Pivot tables

1.3 Min

65 Editing a Pivot table

3.43 Min

66 Formatting a Pivot table

2.09 Min

67 Adjusting a Pivot table

4.28 Min

68 GETPIVOTDATA

3.4 Min

69 Slicers

4.15 Min

70 Introduction to the case study

1.55 Min

71 Working with an SAP data extraction

3.18 Min

72 Preliminary mapping of the data extraction

2.05 Min

73 Creating an output structure of the FMCG model

2.24 Min

74 Inserting formulas and automating calculations

2.26 Min

75 Creating a Master Pivot Table - The main data source for the FMCG report

1.5 Min

76 Combining Slicers and GetPivotData - The key to our success

3.15 Min

77 Getting fancy with Excel slicers

3.07 Min

78 This is how the report can be used in practice by high-level executives

3.54 Min

1 Why Excel and why modeling

2.14 Min

2 Let's start from scratch and create a P&L sheet

7.14 Min

3 Cell styles allows you to be faster

6.33 Min

4 Pasting values, formulas, and formats with Paste Special

2.3 Min

5 Formatting Cells Part I - Working with data in Excel

4.47 Min

6 Formatting Cells Part II - Customize numbers the way you like

5.12 Min

7 Highlight key data with Excel Conditional Formatting

5.4 Min

8 Filter by color

1.43 Min

9 Use multiple screens simultaneously

3.41 Min

10 F1 to F12 - Using Excel's function keys

5.3 Min

11 How to select visible cells only

2.3 Min

12 Grouping Excel rows and columns - The correct way to do it!

4.48 Min

13 Working on multiple sheets at the same time

2.06 Min

14 Find & Replace - Our favourite Excel tool

4 Min

15 A great way to apply Find & Replace

3.56 Min

16 What Are Circular References in Excel

5.05 Min

17 Circular References - An example

2.22 Min

18 Trace precedents - Display the relationship between formulas and cells

4.5 Min

19 What is a nested function

3.09 Min

20 Advanced Excel functions Index; Match; Index & Match

7.26 Min

21 Advanced Excel functions Index, Match, Match

4.59 Min

22 Advanced Excel functions Indirect; Vlookup & Indirect

5.52 Min

23 Advanced Excel functions Rows; Columns; Vlookup & Columns

5.21 Min

24 Advanced Excel functions Vlookup & Match

2.31 Min

25 Advanced Excel functions Choose; Vlookup & Choose

3.29 Min

26 Advanced Excel functions Offset; Offset & Match

7.11 Min

27 Date functions

5.39 Min

28 Excel tips & tricks Part 1

6.01 Min

29 Excel tips & tricks Part 2

5.46 Min

30 Excel tips & tricks Part 3

6.35 Min

31 Excel tips & tricks Part 4

5.55 Min

1 Probability Distributions - A Practical Example

15.03 Min

2 Probability in Finance

7.46 Min

3 Probability in Statistics

6.18 Min

4 Probability in Data Science

4.47 Min

5 What is the probability formula

7.09 Min

6 Computing Expected Values

5.29 Min

7 The Probability Frequency Distribution

5 Min

8 Complements

5.26 Min

9 Fundamentals of Combinatorics

1.04 Min

10 Computing Permutations

3.21 Min

11 Solving Factorials

3.35 Min

12 Computing Variations with Repetition

2.59 Min

13 Computing Variations without Repetition

3.48 Min

14 Computing Combinations

4.51 Min

15 Symmetry of Combinations

3.26 Min

16 Combinations with Separate Sample Spaces

2.52 Min

17 Winning the Lottery

3.12 Min

18 A Summary of Combinatorics

2.55 Min

19 Combinatorics - Practical Example

10.53 Min

20 Sets and Events

4.28 Min

21 The Different Ways Events Can Interact

3.45 Min

22 The Intersection of Two Sets

2.06 Min

23 The Union of Two Sets

4.51 Min

24 Mutually Exclusive Sets

2.09 Min

25 Dependent and Independent Events

3.01 Min

26 Conditional Probability

4.16 Min

27 Law of Total Probability

3.03 Min

28 Additive Law

2.21 Min

29 Multiplication Rule

4.05 Min

30 Bayes Rule

5.44 Min

31 Bayesian - Practical Example

14.52 Min

32 An overview of distributions

6.29 Min

33 Types of Distributions

7.32 Min

34 Discrete Distributions

2 Min

35 Discrete Uniform Distributions

2.13 Min

36 Bernoulli Distributions

3.26 Min

37 Binomial Distributions

7.04 Min

38 Poisson Distributions

5.27 Min

39 Normal Distributions

4.08 Min

40 Standardizing Normal Distributions

4.25 Min

41 Students' T Distributions

2.29 Min

42 Chi Squared Distributions

2.22 Min

43 Exponential Distributions

3.15 Min

44 Logistic Distributions

4.07 Min

1 Welcome to Statistics

2 Population vs sample

4.02 Min

3 Types of data

4.33 Min

4 Levels of measurement

3.43 Min

5 Categorical variables. Visualization techniques

4.52 Min

6 Numerical variables. Frequency distribution table

3.09 Min

7 The histogram

2.14 Min

8 Cross table and scatter plot

4.44 Min

9 Mean, median, mode

N/A

10 Skewness

2.37 Min

11 Variance

5.55 Min

12 Standard deviation and coefficient of variation

4.4 Min

13 Covariance

3.23 Min

14 Correlation

3.17 Min

15 Practical Example - Descriptive Statistics

16.08 Min

16 Introduction to Inferential Statistics

1 Min

17 What is a distribution

4.33 Min

18 The Normal Distribution

3.54 Min

19 The Standard Normal Distribution

3.3 Min

20 Central limit theorem

4.2 Min

21 Standard error

1.26 Min

22 Estimators and estimates

3.07 Min

23 Definition of confidence intervals

2.41 Min

24 Population variance known, z-score

8.01 Min

25 Confidence Interval Clarifications

4.38 Min

26 Student's T Distribution

3.22 Min

27 Population variance unknown, t-score

4.36 Min

28 Margin of error

4.52 Min

29 Confidence intervals. Two means. Dependent samples

6.04 Min

30 Confidence intervals. Two means. Independent samples (Part1)

4.31 Min

31 Confidence intervals. Two means. Independent samples (Part2)

3.57 Min

32 Confidence intervals. Two means. Independent samples (Part 3)

1.27 Min

33 Practical Example - Confidence Intervals

10.05 Min

34 Null vs Alternative

5.51 Min

35 Rejection region and significance level

7.05 Min

36 Type I error vs type II error

4.14 Min

37 Test for the mean. Population variance known

6.34 Min

38 p-value

4.13 Min

39 Test for the mean. Population variance unknown

4.48 Min

40 Test for the mean. Dependent samples

5.18 Min

41 Test for the mean. Independent samples (Part1)

4.22 Min

42 Test for the mean. Independent samples (Part2)

4.26 Min

43 Practical Example - Hypothesis Testing

7.16 Min

1 What is a Matrix

3.37 Min

2 Scalars and Vectors

2.58 Min

3 Linear Algebra and Geometry

3.06 Min

4 Scalars, Vectors, and Matrices as Python Arrays

5.09 Min

5 What is a Tensor

3 Min

6 Addition and Subtraction

3.36 Min

7 Errors when Adding Matrices

2.01 Min

8 Transpose of a Matrix

5.13 Min

9 Dot Product

3.48 Min

10 Dot Product of Matrices

8.23 Min

11 Why is Linear Algebra Useful

10.1 Min

1 Welcome to Tableau

2 Why Use Tableau - Make Your Data Make an Impact

4.23 Min

3 Let's Download Tableau Public

2.03 Min

4 Connecting Data in Tableau

2.19 Min

5 Exploring Tableau's Interface

9.26 Min

6 Let's Create our first Chart in Tableau!

7.12 Min

7 Duplicating a sheet

2.49 Min

8 Creating a Table

4.49 Min

9 Creating Custom Fields

2.28 Min

10 Creating a Custom Field and Adding Calculations to a Table

3.41 Min

11 Adding Totals and Subtotals

2.03 Min

12 Adding a Custom Calculation

3.12 Min

13 Inserting a Filter

2.21 Min

14 Working with Joins in Tableau

4.33 Min

15 Introduction to the exercise

2.05 Min

16 Let's Create a Dashboard - Visualizing the Three Charts We Want to Create

1.56 Min

17 Using Joins in Tableau

5.16 Min

18 Performing a Numbers Check - Attempt #1

3.48 Min

19 Blending Data in Tableau

5.49 Min

20 Performing a Numbers Check - Attempt #2

3.41 Min

21 First chart

4.05 Min

22 Second chart

3.07 Min

23 Third Chart

2.39 Min

24 Creating and Formatting a Dashboard

4.26 Min

25 Adding Interactive Filters for Improved Analysis

3.54 Min

26 Interactive filters - fix

1.38 Min

1 What Does the Course Cover

3.22 Min

2 Introduction to Power BI

1.48 Min

3 Power BI Desktop vs Power BI Pro

1.4 Min

4 Power BI Data Sources

2.15 Min

5 Power BI for MAC

5.4 Min

6 Power BI for Mac Part 2

6.45 Min

7 How to Install Power BI

2.57 Min

8 Introduction to Data Sources

9 The Query Editor

3.26 Min

10 Import vs DirectQuery

4.21 Min

11 Importing Data from Excel Files

8.56 Min

12 First Data Model

5.57 Min

13 Active vs Inactive Relationships

9.14 Min

14 Entering Data Manually

3.21 Min

15 Roles

2.35 Min

16 Refreshing Data

5.46 Min

17 Hierarchies

9.09 Min

18 Ask a Question

4.15 Min

19 Task Three, Part 1

10.33 Min

20 Task Three, Part 2

7.14 Min

21 Introduction to Data Modelling

22 DAX

23 Calculated Columns

2.07 Min

24 Measures

5.46 Min

25 The Star Schema

5.06 Min

26 The Snowflake Schema

2.52 Min

27 Investigating the Filter Flow

3.23 Min

28 Related vs Relatedtable

5.45 Min

29 Bi-directional Cross-filtering

5.52 Min

30 Calculate

4.27 Min

31 Time Intelligence, Part 1

8.42 Min

32 Time Intelligence, Part 2

10.47 Min

33 All

4 Min

34 Filter

6.5 Min

35 Iterators

7.53 Min

36 Logical operators

7.46 Min

37 Switch

9.09 Min

38 Text Functions

10.31 Min

39 Task Four, Part 1

8.38 Min

40 Task Four, Part 2

10.08 Min

41 Task Four, Part 3

7.15 Min

42 Introduction

43 Report View

4.27 Min

44 Slicers

10.44 Min

45 Bar Chart

10.38 Min

46 Bookmarks

8.54 Min

47 Conditional Formatting

7.04 Min

48 Field Formating

4.38 Min

49 Gauge Chart

5.53 Min

50 Card Visuals Part 1

9.24 Min

51 Card Visuals Part 2

13.24 Min

52 Drillthrough

6.35 Min

53 Filters

4.2 Min

54 Map vizuals

5.42 Min

55 Custom Colors

4.36 Min

56 Task Five, Part 1

2.55 Min

57 Task Five, Part 2

2.35 Min

58 Task Five, Part 3

6.21 Min

59 Task Five, Part 4

7.43 Min

60 Final project part 1

2.16 Min

61 Final Project, Part 2

5.3 Min

62 Final Project, Part 3

5.54 Min

63 Final Project, Part 3

5.54 Min

64 2. Final Project, Part 4

7.26 Min

65 Final Project, Part 5

8.02 Min

66 Final Project, Part 6

6.12 Min

67 Final Project, Part 7

5.47 Min

68 Final Project, Part 8

14.33 Min

69 Final Project, Part 9

3.28 Min

70 Final Project, Part 10

7.18 Min

71 Final Project, Part 11

8.19 Min

72 Final Project, Part 12

8.15 Min

Instructor

Super admin

As the Super Admin of our platform, I bring over a decade of experience in managing and leading digital transformation initiatives. My journey began in the tech industry as a developer, and I have since evolved into a strategic leader with a focus on innovation and operational excellence. I am passionate about leveraging technology to solve complex problems and drive organizational growth. Outside of work, I enjoy mentoring aspiring tech professionals and staying updated with the latest industry trends.

5 Rating