Fundamentals of Data Analytics: Beginner to Advanced
-
LevelBeginner
-
Last Updated15 November 2024
-
CertificateCertificate of completion
Course Curriculum
Introduction to Data Analytics
-
What is Data Analytics
03:02 -
Steps of Data Analytics
13:57 -
Importance of Data Analytics
11:14 -
Career Paths in Data Analytics
06:19 -
Processes involved in Data Analytics
03:36 -
Overview of Data Analytics Tools
04:45 -
Recap and Next Steps
01:44
Week 1: Microsoft Excel Basics
-
Basics of Excel
05:34 -
The Excel Interface
11:11 -
How to open an existing workbook
02:10 -
Data entry and formatting
11:10 -
Formatting cells
09:11 -
Formatting Numbers
13:22 -
Conditional formatting
05:46 -
Formulas and Functions
12:23 -
IF and IFS Statement
08:35 -
Trim
02:40 -
VLOOKUP
08:58 -
Sorting and Filtering
10:11 -
How to create a new workbook
05:12 -
Week 1: Instructor Live Session
01:13:53
Week 2: Advanced Microsoft Excel
-
Data cleansing
17:08 -
Power Query
11:48 -
Charts and Graphs
16:46 -
Analysis ToolPack
07:18 -
Pivot Table
29:36 -
Dashboards
09:43
Week 3: Power BI
-
Introduction to Power BI
02:35 -
Power BI Product Suite
07:02 -
Power BI Desktop
02:30 -
Advantages of Power BI
04:11 -
Getting started with Power BI
07:49 -
Main components of Power BI
04:47 -
Week 3: Instructor Live Session
02:18:08 -
Week 2 Assignment: Super Store Data Set
Week 4: Power BI Continued
-
Acquiring data in Power BI
06:48 -
Transforming data in Power BI
16:39
Week 5: MySQL
-
Introduction to SQL
11:50 -
Types of Databases
07:59 -
Creating tables and understanding how Data Types work in SQL
27:17 -
Unions and Joins
19:26 -
Aggregate Functions
20:12 -
Date and String Formats
11:11 -
Week 5: Instructor Live Session
02:14:48
Week 6: Intermediate SQL
-
Views, Stored Procedures and Triggers
10:32 -
Transactions and Concurrency
02:47 -
Indexing
02:54
Week 7: Python for Data Analytics
-
Getting started
01:30 -
Introduction to Python
06:31 -
Python Environment
05:38 -
Python arithmetic
07:29 -
Variables and Basic Data Types
33:57
Week 8: Python for Data Analytics
-
Python Libraries for Data Analytics
06:02 -
Other Python Libraries for Data Analytics
21:58 -
Pandas
30:50 -
Matplotlib
15:01
Week 9: Python for Data Analytics
-
Exploratory Data Analysis
15:38 -
Correlation Analysis
13:08 -
Data Modelling With Stats Models and Scikit-Learn
09:13
Week 10: Project Week
-
Data Analytics Project Week
00:00 -
Course Review Quiz
Week 12: Project Presentation
-
Project Presentations
Course Description
Meet Your Instructor
Frequently Asked Questions
Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos quiratione voluptatem sequi nesciunt.
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.Â
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.Â
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.Â
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.Â
Related Courses
Ace Your IELTS With Amara Oladele: Listening, Reading, Speaking and Writing (Academic Full Course)
Subscribe To our Newsletter
Be the first to know about our discounts offers, events and giveaways. Unsubscribe anytime with just one click.