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

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

source

cisco academie