Course / Course Details

DATA ANALYTICS

  • Adeola Oluwaseun Oluwatobi image

    By - Adeola Oluwaseun Oluwatobi

  • N/A
  • (10)

Course Requirements

A Desktop or Laptop Computer

Openness to learning.

Course Description

This course is your ultimate ticket to becoming a data professional wizard. We're diving deep into the world of data analytics, where you'll master advanced Excel tricks, build interactive dashboards with Power BI and Tableau, and wield SQL like a boss to manage and extract data. Forget boring lectures—this course is all about hands-on, real-world challenges that turn raw numbers into powerful insights.

Course Outcomes

Become a Data Professional

Course Curriculum

  • 2 chapters
  • 126 lectures
  • 0 quizzes
  • N/A total length
Toggle all chapters
1 WEEK ONE: Day 1 - Welcome Address
4 Min


2 Day 1 - INTRODUCTION TO DATA ANALYTICS
27 Min


3 Day 1 - IMPORTANCE OF DATA ANALYTICS
5 Min


4 Day 1 - INTRODUCTION TO MICROSOFT EXCEL
9 Min


5 Day 1 - COMMONLY USED EXCEL FUNCTIONS
8 Min


6 Day 1 - INTRODUCTION TO PASTE SPECIAL
3 Min


7 Day 1 - PASTE SPECIAL 1
22 Min


8 Day 1 - PASTE SPECIAL 2
4 Min


9 Day 1 - PASTE SPECIAL 3
5 Min


10 Day 1 (Wrap Up) - PASTE SPECIAL 4
13 Min


11 Day 2 - INTRODUCTION TO CELL REFERENCING
12 Min


12 Day 2 - ABSOLUTE CELL REFERENCING
13 Min


13 Day 2 - MIXED CELL REFERENCING
11 Min


14 Day 2 - INTRODUCTION TO DATA (OR DATASET)
11 Min


15 Day 2 - NAMED RANGES
18 Min


16 Day 2 - DATA CLEANING (Clean Function)
6 Min


17 Day 2 - Data Cleaning - CLEAN Function II (Text-To-Column)
10 Min


18 Day 2 - DATA CLEANING (TRIM FUNCTION)
7 Min


19 Day 2 - DATA CLEANING (SUBSTITUTE)
13 Min


20 Day 2 - DATA CLEANIING (VALUE FUNCTION)
10 Min


21 Day 2 - DATA CLEANIING (VALUE FUNCTION)
10 Min


22 Day 2 - DATA CLEANING (REMOVING DUPLICATES)
12 Min


23 Day 2 - Wrap Up
5 Min


24 Day 3 - DATA MANIPULATION (SORTING & FILTERING)
11 Min


25 Day 3 - DATE COLUMN EXTRACTION USING TEXT FUNCTION
11 Min


26 Day 3 - INTRODUCTION TO TABLES IN EXCEL
3 Min


27 Day 3 - VLOOKUP
16 Min


28 Day 3 - SETTING UNIQUE ID TO SALES CHANNEL COLUMN
15 Min


29 Day 3 - NESTING IFERROR WITH VLOOKUP
17 Min


30 Day 3 - INDEX Function
18 Min


31 Day 3 - MATCH Function
9 Min


32 Day 3 (Wrap Up) - INDEX MATCH
14 Min


33 Day 4 - LOGICAL FUNCTIONS (COUNTIF)
28 Min


34 Day 4 - LOGICAL FUNCTIONS (COUNTIFS)
14 Min


35 Day 4 - LOGICAL FUNCTIONS (SUMIF)
20 Min


36 Day 4 - LOGICAL FUNCTIONS (SUMIFS)
17 Min


37 Day 4 - LOGICAL FUNCTIONS (IF Function)
10 Min


38 Day 4 - LOGICAL FUNCTIONS (IF + AND Function)
16 Min


39 Day 4 - LOGICAL FUNCTIONS (IF + OR Function)
16 Min


40 Day 4 (Wrap UP) - LOGICAL FUNCTIONS (IFS & NESTED IFS)
23 Min


41 Day 5 - INTRODUCTION TO PIVOTING IN EXCEL (PIVOT TABLES & PIVOT CHARTS)
5 Min


42 Day 5 - DATA PREPROCESSING FOR PIVOT TABLES
15 Min


43 Day 5 - PIVOT TABLES (Case Scenario 1)
19 Min


44 Day 5 - PIVOT TABLE (Case Scenario 2)
13 Min


45 Day 5 - PIVOT TABLE (Case Scenario 3)
5 Min


46 Day 5 - PIVOT TABLE (Case Scenario 4)
5 Min


47 Day 5 - PIVOT TABLE (Case Scenario 5 - CREATING A CUSTOMER AGE GROUP COLUMN)
12 Min


48 Day 5 - PIVOT TABLE (Case Scenario 6 & 7 - EXTRACTING QUARTER COLUMN FROM DATE COLUMN)
20 Min


49 Day 5 (Wrap Up) - PIVOT TABLE (Case Scenario 8 & 9)
14 Min


50 Day 6 - PIVOT CHART (Case Scenario 1 & 2)
30 Min


51 Day 6 - PIVOT CHART (Case Scenario 3 - 5)
18 Min


52 Day 6 - PIVOT CHART (Case Scenario 6)
7 Min


53 Day 6 - CREATING A DASHBOARD IN EXCEL - 1
30 Min


54 Day 6 - CREATING A DASHBOARD IN EXCEL - 2
16 Min


55 Day 6 (Wrap Up) - CONVERTING YOUR REPORT ANALYSIS TO A PDF FILE
13 Min


56 Day 7 - INTRODUCTION TO EXCEL MACROS
5 Min


57 Day 7 - RECORDING AND RUNNING MACROS IN EXCEL
20 Min


58 Day 7 - AUTOMATING TASKS ON EXCEL USING MACROS
10 Min


59 WEEK TWO: Day 8 (SQL) - INTRODUCTION TO SQL
4 Min


60 Day 8 - CATEGORIES OF SQL
2 Min


61 Day 8 - WHY SQL & WHO USES SQL?
4 Min


62 Day 8 (Wrap Up Video) - DIFFERENT VARIANTS OF SQL
7 Min


63 Day 9 - CREATING A SQL DATABASE
12 Min


64 Day 9 - CREATING A TABLE ON A DATABASE
19 Min


65 Day 9 - CREATING A TABLE ON A DATABASE II
9 Min


66 Day 10 - DATA MANIPULATION LANGUAGE (INSERT QUERY)
20 Min


67 Day 10 - DATA MANIPULATION LANGUAGE (INSERT QUERY - II)
6 Min


68 Day 10 (Wrap Up Video) - COPYING & IMPORTING A TABLE TO DATABASE
16 Min


69 Day 11 - SELECT & DISTINCT STATEMENTS
11 Min


70 Day 11 - WHERE Condition
14 Min


71 Day 11 - AND & OR OPERATOR
15 Min


72 Day 11 (Wrap Up Video) - UPDATE & DELETE STATEMENT
23 Min


73 Day 12 - ALTER STATEMENT
14 Min


74 Day 12 - BETWEEN Condition
5 Min


75 Day 12 - LIKE STATEMENT (Wildcards 1)
9 Min


76 Day 12 (Wrap Up video) - LIKE STATEMENT (Wildcards 2)
2 Min


77 Day 13 - ORDERY BY Clause
9 Min


78 Day 13 - LIMIT Clause
6 Min


79 Day 13 - AS (ALIASING)
7 Min


80 Day 13 (Wrap Up video) - AGGREGATE FUNCTIONS (COUNT, SUM, AVERAGE, MIN & MAX)
27 Min


81 Day 14 - GROUP BY Function
19 Min


82 Day 14 (Wrap Up Video) - HAVING Condition
6 Min


83 WEEK THREE: Day 15 - JOINS IN SQL - INNER JOIN
23 Min


84 Day 15 - JOINS IN SQL - LEFT JOIN
12 Min


85 Day 15 - JOINS IN SQL - RIGHT JOIN
7 Min


86 Day 15 - JOINS IN SQL - FULL JOIN
4 Min


87 Day 15 - JOINS IN SQL - EXCEPT CONDITION
8 Min


88 Day 15 (Wrap Up Video) - JOINS IN SQL - UNION
10 Min


89 Day 16 - SUBQUERIES IN SQL
31 Min


90 Day 17 - VIEWS IN SQL
26 Min


91 Day 17 - INDEX IN SQL
14 Min


92 Day 17 (Wrap Up Video) - TRIGGERS IN SQL
22 Min


93 Day 18 - DATE & TIME FUNCTIONS IN SQL
19 Min


94 Day 19 - MATHS FUNCTIONS IN SQL
37 Min


95 Day 20 - STRING FUNCTIONS IN SQL
49 Min


96 Day 20 (Wrap Up Video) - CONVERSION TO STRING FUNCTION IN SQL
33 Min


97 WEEK FOUR: Day 21 -
8 Min


1 WEEK FIVE: Day 1 - POWER BI WELCOME ADDRESS
5 Min


2 Day 1 - INTRODUCTION TO MICROSOFT POWER BI
10 Min


3 Day 1 - MICROSOFT POWER BI INSTALLATION
6 Min


4 Day 1 - MICROSFT POWER BI ARCHITECHTURE AND DATA SOURCES
7 Min


5 Day 1 - MICROSOFT POWER BI INTERFACE
15 Min


6 Day 2 - IMPORTING DATA FROM SQL DATABASE TO MICROSOFT POWER BI
15 Min


7 Day 2 - IMPORTING DATA FROM EXCEL WORKSHEET TO MICROSOFT POWER BI
12 Min


8 Day 3 - ETL IN MICROSOFT POWER BI (EXTRACT, TRANSFORM & LOAD)
36 Min


9 Day 4 - DATA MODELLING (Relationships in Power BI)
17 Min


10 Day 4 - DATA MODELLING (Creating & Managing Relationships)
14 Min


11 Day 4 - DATA MODELLING (FACTS AND DIMENSION TABLES)
15 Min


12 Day 5 - CREATING A CALENDAR OR DATE TABLE USING DAX (Data Analysis Xpressions)
6 Min


13 Day 5 - CREATING A CALENDAR OR DATE TABLE USING DAX (Data Analysis Xpressions) - PART II
26 Min


14 Day 5 - CREATING MEASURES USING DAX (Calculated Columns & Calculated Measures)
22 Min


15 Day 6 - INTRODUCTION TO DATA VISUALIZATION IN POWER BI
17 Min


16 Day 6 - SETTING UP YOUR POWER BI PAGE (Dashboard Report Area)
10 Min


17 Day 6 - CREATING A SIMPLE VISUALIZATION (Chart)
7 Min


18 Day 7 - CHART (OR VISUALIZATION) FORMATTING
19 Min


19 Day 7 - Creating and Formatting a Sales & Profit Chart
33 Min


20 Day 8 - Formatting a PIE or DOUGHNUT Chart
1 Hour 1 Min


21 Day 9 - FORECASTING (Making Sales Forecast)
23 Min


22 Day 9 - FORECASTING (Profits, Quantity Forecasts)
11 Min


23 Day 10 - CREATING AND FORMATTING A SLICER IN POWER BI
15 Min


24 Day 10 - TABLE VISUALS IN POWER BI
19 Min


25 Day 11 - BUILDING A DASHBOARD - 1
54 Min


26 Day 11 - BUILDING A DASHBOARD - II
35 Min


27 Day 12 - Adding Slicer to your Power BI Dashboard and Exporting your Analysis
22 Min


28 Day 12 - (WRAP UP VIDEO) - PUBLISHING YOUR ANALYSIS TO POWER BI SERVICE
12 Min


29 Day 13 - INTRODUCTION AND OVERVIEW OF TABLEAU
18 Min


1. Course Dataset (Exercise Files)
2. PRACTICE ASSIGNMENTS
3. Microsoft Excel Course Materials
4. SQL Course Materials (PDFs)
5. SQL Course Dataset (CSV files)
6. Microsoft Power BI Course Materials (Dataset, PDFs and .PBIX files)
7. POWER BI CAPSTONE PROJECT
8. MICROSOFT EXCEL CAPSTONE PROJECT

Instructor

5 Rating
2 Reviews
59 Students
1 Courses

Course Full Rating

10

Course Rating
(1)
(0)
(0)
(0)
(0)

Sign In or Sign Up as student to post a review

Student Feedback

Course you might like

You must be enrolled to ask a question

Students also bought

More Courses by Author

Discover Additional Learning Opportunities