Data Analytics Masters - From Basics To Advanced Published 9/2024 MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz Language: English | Size: 34.43 GB | Duration: 46h 12m
Master Data Analysis: Learn Python, EDA, Stats, MS Excel, SQL, Power BI, Tableau, Predictive Analytics & ETL Basics
What you'll learn
Discover how to effectively handle, analyze, and visualize data using Python and its robust libraries, including Pandas, NumPy, Matplotlib, and Seaborn.
Learn how to conduct Exploratory Data Analysis (EDA) to reveal insights, detect patterns, and prepare data for further analysis through effective visualization
Acquire the skills to extract, manipulate, and aggregate data using SQL. You will utilize MySQL to handle complex databases and execute sophisticated queri
Master the art of creating interactive and insightful dashboards using Power BI and Tableau. You'll apply DAX for complex calculations in Power BI and integrate
Explore the fundamentals of machine learning, including classification, regression, and time series analysis, to enhance your predictive analytics skills.
Learn the fundamentals of ETL processes to effectively extract, transform, and load data for analysis.
Requirements
No pre-requisites are required for this course
Description
Congrats on enrolling in the Data Analytics Masters Course!!Need of Data AnalyticsThe outburst of data is transforming businesses. Companies - big or small - are now expecting their business decisions to be based on data-led insight.Data specialists have a tremendous impact on business strategies and marketing tactics.The demand for data specialists is on the rise while the supply remains low, thus creating great job opportunities for individuals within this field.Today, it is almost impossible to find any brand that does not have a social media presence; soon, every company will need data analytics professionals.This makes it a wise career move that has a future in business.Job Roles after the courseThis course will help you to step forward in Data Analytics and choose the following rolesData AnalystBusiness AnalystBI AnalystBI DeveloperPower BI DeveloperTableau Developerand many more.Syllabus:Module 1: Python for Data AnalyticsModule 2: Exploratory Data AnalysisModule 3: Business StatisticsModule 4: SQLModule 5: Microsoft ExcelModule 6: Power BIModule 7: TableauModule 8: Predictive ModellingModule 9: Data Warehousing and ETLModule 10: Interview GuidesModule 11: Capstone ProjectsConclusion:By the end of this course, you'll have a strong foundation in data analysis and the confidence to tackle real-world data problems. You'll be ready to step into a data analyst role with a robust portfolio of projects to showcase your skills.Enroll now and start your journey to becoming a proficient Data Analyst!
Overview
Section 1: Introduction
Lecture 1 Welcome Page
Lecture 2 Welcome to the Course
Lecture 3 What is Data Analytics
Lecture 4 Importance of Data Analytics
Lecture 5 Types of Data
Lecture 6 Types of Statistical Analysis
Lecture 7 Steps to obtain a Data Analytics solution
Lecture 8 Business Understanding
Lecture 9 Data Understanding
Lecture 10 Data Collection
Lecture 11 Data Preparation
Lecture 12 Data Modelling
Lecture 13 Deployment
Lecture 14 Use Case
Section 2: Python
Lecture 15 Course Contents
Lecture 16 Introduction to Python
Lecture 17 Variables & Keywords
Lecture 18 Datatypes Operators
Lecture 19 Lists
Lecture 20 Tuples
Lecture 21 Sets
Lecture 22 Doctionary
Lecture 23 Loops & Iteration
Lecture 24 Functions
Lecture 25 Map Reduce Filter
Lecture 26 File Handling
Lecture 27 Control Structures
Lecture 28 OOPS
Lecture 29 NumPy
Lecture 30 Pandas
Lecture 31 Data Visualization
Lecture 32 Matplotlib
Lecture 33 Seaborn
Section 3: Business Statistics
Lecture 34 Course Contents
Lecture 35 Introduction
Lecture 36 Types of Data (Agenda)
Lecture 37 Descriptive Stats
Lecture 38 Inferential Stats
Lecture 39 Qualitative Data
Lecture 40 Quantitative Data
Lecture 41 Sampling Techniques (Agenda)
Lecture 42 Population vs Sample
Lecture 43 Why Sampling is important
Lecture 44 Types of Sampling
Lecture 45 Cluster Random Sampling
Lecture 46 Probability Sampling
Lecture 47 Non probability sampling
Lecture 48 Population Sampling
Lecture 49 Why n-1 and not n
Lecture 50 Descriptive Analytics (Agenda)
Lecture 51 Measures of Central Tendency
Lecture 52 Mean
Lecture 53 Median
Lecture 54 Mode
Lecture 55 Measures of Dispersion
Lecture 56 Range
Lecture 57 IQR
Lecture 58 Variance Standard Deviation
Lecture 59 Mean Deviation
Lecture 60 Probability (Agenda)
Lecture 61 Probability
Lecture 62 Addition Rule
Lecture 63 Independent Events
Lecture 64 Cumulative Probability
Lecture 65 Conditional Probability
Lecture 66 Bayes Theorem 1
Lecture 67 Bayes Theorem 2
Lecture 68 Probability Distrubution (Agenda)
Lecture 69 Uniform Distribution
Lecture 70 Binomial Distribution
Lecture 71 Poisson Distribution
Lecture 72 Normal Distribution Part 1
Lecture 73 Normal Distribution Part 2
Lecture 74 Skewness
Lecture 75 Kurtosis
Lecture 76 Calculating Probability with Z-score for Normal Distribution Part 1
Lecture 77 Calculating Probability with Z-score for Normal Distribution Part 2
Lecture 78 Calculating Probability with Z-score for Normal Distribution Part 3
Lecture 79 Covariance & Correlation (Agenda)
Lecture 80 Covariance
Lecture 81 Correlation
Lecture 82 Covariance VS Correlation
Lecture 83 ANOVA
Lecture 84 Hypothesis Testing
Lecture 85 Tailed Tests
Lecture 86 p-value
Lecture 87 Types of Test
Lecture 88 T Test
Lecture 89 Z Test
Lecture 90 Chi Square Test
Lecture 91 Correlation Test (Practicals)
Section 4: Exploratory Data Analysis
Lecture 92 Course Contents
Lecture 93 Agenda
Lecture 94 DA,DS Process
Lecture 95 What is EDA
Lecture 96 Visualization
Lecture 97 Steps involved in EDA (Data Sourcing)
Lecture 98 Steps involved in EDA (Data Cleaning)
Lecture 99 Handle Missing Values (Theory)
Lecture 100 Handle Missing Values (Practicals)
Lecture 101 Feature Scaling (Theory)
Lecture 102 Standardization Example
Lecture 103 Normalization Example
Lecture 104 Feature Scaling (Practicals)
Lecture 105 Outlier Treatment (Theory)
Lecture 106 Outlier Treatment (Practicals)
Lecture 107 Invalid Data
Lecture 108 Types of Data
Lecture 109 Types of Analysis
Lecture 110 Univariate Analysis
Lecture 111 Bivariate Analysis
Lecture 112 Multivariate Analysis
Lecture 113 Numerical Analysis
Lecture 114 Analysis Practicals
Lecture 115 Derived Metrics
Lecture 116 Feature Binning (Theory)
Lecture 117 Feature Binning (Practicals)
Lecture 118 Feature Encoding (Theory)
Lecture 119 Feature Encoding (Practicals)
Lecture 120 Case Study
Lecture 121 Data Exploration
Lecture 122 Data Cleaning
Lecture 123 Univariate Analysis
Lecture 124 Bivariate Analysis Part 1
Lecture 125 Bivariate Analysis Part 2
Lecture 126 EDA Report
Section 5: SQL
Lecture 127 Course Contents
Lecture 128 Installation
Lecture 129 Data Architecture - File server vs client server