Data Analytics FULL Course for Beginners to Pro in 29 HOURS - 2024 Edition

To learn Data Analytics Course online with regular LIVE CLASSES, enroll now: https://www.wscubetech.com/landing-pages/online-data-analytics-course.html?utm_source=YouTube&utm_medium=JAN2024_04&utm_campaign=RV

GitHub Link: https://github.com/Ayushi0214/Datasets

00:00:00 - 02:15:26: Python Basics
- Introduction to Python for Data Analytics
- Python Installation in Windows
- Python IDE (Pycharm)
- First Program in Python
- Comments, Variables, Datatypes, User-Inputs
- TypeCasting, Subtypes, Problem-Solving
- Operators and Operands
- Conditional Statements

02:40:22 - 06:36:18: Python - Loops and Lists
- Introduction to Loops
- For Loop, While Loop, Nested Loops
- For Loop with Conditional Statements
- Break and Continue Statement
- Loops Problem Solving
- Introduction to Lists
- Lists Slicing, Iteration, Functions
- List Comprehension, Problem Solving

06:47:43 - 07:36:16: Tuples, Dictionaries, and Sets in Python
- Introduction to Tuples
- Tuples Slicing, Iteration, Functions, Problem Solving
- Introduction to Dictionaries
- Iteration, Functions, Nested Dictionaries, Problem Solving
- Introduction to Sets
- Set Methods, Problem Solving

08:16:10 - 09:14:20: Python Functions and Modules
- Introduction to Functions
- Parameters, Arguments, Return Statement, Recursion
- Lambda Function, Local and Global Variables
- Functions Problem Solving
- Introduction to Modules, In-built Modules
- Creation of Modules, Project Random Module

09:15:59 - 15:57:26: Numpy and Data Manipulation
- Introduction to Numpy
- Installation of Jupyter Notebook
- Creation, Indexing, and Slicing of Numpy Arrays
- Mathematical Operations, Combining and Splitting Arrays
- Search, Sort, Filter Arrays, Aggregating Functions
- Statistical Functions in Arrays

12:01:26 - 13:45:36: Pandas for Data Analysis
- Introduction to Pandas
- Creation of Data Frames, Exploring Data
- Dealing with Duplicate values, Missing Data
- Column Transformation in Pandas, GroupBy
- Merge, Concatenate, Join in Pandas
- Pivoting and Melting Dataframes

13:43:51 - 15:57:26: Matplotlib for Data Visualization
- Introduction to Matplotlib
- Bar, Line, Scatter, Pie, Box, Histogram, Violin, Stem plots
- Stack Plot, Step Chart, Legends, Subplot
- Save a Chart Using Matplotlib
- Data Visualization in Seaborn
- Seaborn Project

18:38:09 - 21:02:52: MySQL for Data Analytics
- Introduction to MySQL
- Installation, Importing Data
- Select Query, Where Clause
- AND, OR, NOT Operators, Like Operator
- Order By, Limit, Between
- IN, NOT IN operator, String Functions
- Data Aggregation, Numeric Functions
- Date Functions, Case Operator
- Group By, Having Clause
- Joins, Set Operators, Subqueries, Views
- Stored Procedure, Window Functions

21:14:31 - 24:45:52: Excel for Data Analytics
- Introduction to MS Excel
- Basic Functions, Data Validation
- Data Connectors, Conditional Formatting
- Basics of Formatting, Sorting, Filtering Data
- Dealing with Null Values, Duplicate Values
- Trimming Whitespaces, Text Functions
- IF, AND, OR Functions, Date & Time Functions
- COUNTIF, SUMIF Functions, Xlookup
- Power Query, Cleaning and Transformation
- Creating a Dashboard in Excel, myExcel Project

25:38:35 - 29:09:56: Power BI Essentials
- Introduction to Power Bi
- Installation of Power Bi Desktop
- Data Connectors, Basic Transformations
- Format Tool, Pivoting, Unpivoting of data
- Adding Conditional Columns, Merge queries
- Data model, Relationship Management
- Introduction to DAX, Calculated Columns, Measures
- DAX Functions, Visualizations, Filters
- Creating Reports, Custom Visuals
- Designing for Phone vs Desktop Report Viewers
- Publishing Reports to Power BI Services

Want to learn and acquire skills in English? Visit WsCube Tech English channel: https://bit.ly/2M3oYOs

𝗩𝗼𝘁𝗲 𝗳𝗼𝗿 𝗼𝘂𝗿 𝗻𝗲𝘅𝘁 𝘃𝗶𝗱𝗲𝗼: https://bit.ly/share-topic-ideas

For any queries, call us on: +91-7878985501

CONNECT WITH THE FOUNDER (Mr. Kushagra Bhatia) -
Instagram - https://www.instagram.com/kushagrabhatiaofficial
LinkedIn - https://www.linkedin.com/in/kushagra-bhatia
Facebook - https://www.facebook.com/kushagrawscubetech

Connect with WsCube Tech on social media for the latest offers, promos, job vacancies, and much more:

Facebook: https://www.facebook.com/wscubetech.india
Twitter: https://twitter.com/wscubetechindia
Instagram: https://www.instagram.com/wscubetechindia/
‍ LinkedIn: https://www.linkedin.com/company/wscubetechindia/
Youtube: http://bit.ly/wscubechannel
Website: http://wscubetech.com
--------------------------------------| Thanks |---------------------------
#dataanalysis #analyticscourse #dataanalytics #dataanalytics2024