4.50
(2 Ratings)
Data Analysis & Business Intelligence
Categories: Data Analysis & Business Intelligence
Course Content
Module 1: Introduction to Data Analysis & Excel Fundamentals
-
1.1 Introduction to Data Analysis
22:35 -
1.2 Introduction to Microsoft Excel – Excel interface and navigation essentials
22:24 -
1.3 Data Types in MS Excel
08:24 -
1.4 Data Entry in Ms Excel
09:07 -
1.5 Formatting I
10:03 -
1.6 Formatting II
09:29 -
1.7 Formatting III – Conditional Formatting I
08:03 -
1.8 Formatting III – Conditional Formatting II
07:08 -
1.9 Structured Datasets
02:47 -
1.10 Unstructured Datasets
03:59 -
1.11 Protecting a Sheet
08:09 -
1.12 Protecting a Document
04:01 -
1.13 Printing an Excel Document
11:12 -
Download Learning Resources
Module 2: Essential Excel Functions for Analysis
-
2.1 Number Functions I
19:06 -
2.2 Number Functions II
17:08 -
2.3 Consolidation
09:29 -
2.4 Logical Functions I – IF, SUMIF, COUNTIF
16:45 -
2.5 Logical Functions II – IFS, SUMIFS, COUNTIFS, MAXIFS, AND, OR
18:30 -
2.6 TEXT Functions
14:52 -
2.7 Time and Date Functions I
09:25 -
2.8 Time and Date Functions II
12:05 -
2.9 Time Intelligence Functions
17:19 -
2.10 Lookup Functions – HLOOKUP, VLOOKUP XLOOKUP
10:27 -
2.11 Lookup Functions – INDEX AND MATCH
08:25 -
2.12 Lookup Functions – WILDCARDS
06:26 -
2.13 Error Handling Functions
07:49 -
2.14 Lookup Functions – Multiple VLOOKUP
06:13 -
2.15 Other Data Analysis Functions
13:46
Module 3: Data Cleaning & Preparation (ETL in Excel)
-
3.1 Removing Duplicates
04:51 -
3.2 Removing Blank Rows
08:17 -
3.3 Removing Blank Columns
06:53 -
3.4 Text to Columns
05:19 -
3.5 Find and Replace
02:59 -
3.6 Data Validation I
16:52 -
3.7 Data Validation – Custom Formula
19:03 -
3.8 Searchable Dropdown List
09:10 -
3.9 Handling Missing and Inconsistent Records
06:19 -
3.10 Introduction to Power Query
24:14
Module 4: Exploratory Data Analysis (EDA)
-
4.1 EDA – Sorting
08:16 -
4.2 EDA – Filtering
08:23 -
4.3 Table – Slicers
06:03 -
4.4 Advance Filters
08:37 -
4.5 Pivot table for Data Analysis I
22:01 -
4.6 Pivot table for Data Analysis II
21:53
Module 5: Advanced Excel Tools for Data Analysis
-
5.1 Power Query – Data Cleaning
07:32 -
5.2 Power Query – Transformation
06:00 -
5.3 Power Query – Transpose
01:35 -
5.4 Power Query – Unpivot
02:43 -
5.5 Data Scraping with Power Query
07:22 -
5.6 Multiple Files Combination – Append
13:18 -
5.7 Multiple Files Combination – Merge
07:19 -
5.8 Group and Aggregate
00:00 -
5.9 M Language in Power Query
05:17 -
5.10 Data Normalization I
06:20 -
5.11 Data Normalization II
14:06 -
5.12 Data Modeling
08:49 -
5.13 What IF Analysis – Scenario Manager
10:36 -
5.14 What IF Analysis – Goal Seek and Solver
13:18 -
5.15 What IF Analysis – Data Table
00:00
Module 6: Data Visualization & Dashboards
-
6.1 Introduction to Visualizations
10:41 -
6.2 Visualization – Pie Charts and Donought Chart
14:44 -
6.3 Visualization – Column Chart and Bar Chart
05:48 -
6.4 Visualization – Funnel Chart
-
6.5 Visualization – Waterfall Chart
-
6.6 Visualization – Line Chart
08:12 -
6.7 Visualization – Cards
14:42 -
6.8 Interactive Dashboard
00:00 -
6.9 Executive Summary
08:30
Module 7: Excel Automation with Macros & AI
-
7.1 Introduction to Macros and VBA
00:00 -
7.2 Recording a Macro
13:47 -
7.3 Automating Repetitive Task
11:10 -
7.4 Generating Excel Macros with AI – I
13:55 -
7.5 Generating Excel Macros with AI – II
10:01
Module 8: Real-World Business Applications
-
8.1 Sales Performance – Descriptive Analysis
30:25 -
8.2 Sales Analysis – Diagnostic and Performance Monitoring
34:19 -
8.3 Sales Analysis – Predictive and Prescriptive Insights
18:02
Module 9: Capstone Project and Certification
-
9.1 Capstone Project
03:33
Data Analysis Internship with Microsoft Excel
An End-to-end Project based internship with Microsoft Excel
-
Introduction
04:33 -
Project Resources
-
1. The Bosh Sales Agency – Data Cleanup
10:17 -
2. Customer Contact Details – Data Cleaning
24:19 -
3. Friend Request Data Cleaning Task
09:46 -
4. Dataset Reconciliation Request
19:42 -
5. Late Submission Analysis
18:25 -
6. Population Data Extraction and Analysis – Nigerian States
27:22 -
7. Sales Data Analysis for Rocry Shopping Company
34:30 -
8. Bank Reconciliation Exercise
16:13 -
9. Employee Data Adjustment – Madox Cooperation
32:43 -
10. Mini Super Store Data Analysis
42:37 -
11. Student Performance Analysis Report – School XYZ
01:17:36 -
12. Sales Transaction Data Analysis
00:00 -
13. Supplier Transaction Record Template Design
01:10:27 -
14. Sales Data Executive Reporting
54:13 -
15. Kracks Consultant & Infrastructure
24:20 -
16. Quick Job Applicant Data Cleaning
13:51 -
17. McSmith Recruiting Services – Candidate Selection Analysis
00:00 -
18. UK Excel Assessment for Data Analyst Role
32:52 -
19. Kace Communications – Mast Code Extraction
10:30 -
20. Credit Card Spending Habits in India
51:03 -
21. RushTech Financials
48:41 -
22. LayKon Designs & Research Institute
32:28 -
23. Flourish Fish Farms – Sales Automation & Dashboard
59:13 -
24. Tunia Technologies – Sales & Performance Dashboard
52:04 -
25. GreenBrew Ltd Financial Analysis
58:23 -
26. Creating your Data Analysis Portfolio
01:16:24 -
27. Professional CV and Cover Letter
08:21 -
28. LinkedIn Optimization
22:30
Business Intelligence with Power BI
A complete Data Analysis & Business Intelligence mastery course with Power BI Desktop
-
1. Introduction, Download & Installation of Power BI Desktop
06:40 -
2. File Upload & Background Formatting
14:18 -
3. Formatting & Exporting a Chart
14:42 -
4. Formatting, Measures & Units
00:00 -
5. Power BI Charts 1
14:56 -
6. Power BI Cards
05:51 -
7. Power BI Slicer
04:06 -
8. International Distilleries Limited Business Report 1
14:24 -
9. International Distilleries Limited Business Report 2
06:29 -
10. Building a Business Report with DAX
14:56 -
11. Building a Business Report with DAX 2
00:00 -
12. Building a Business Report with DAX 3
14:24 -
13. Building a Report (Data Modeling & DAX)
09:49 -
14. Building a Report (Data Modeling & DAX) 2
14:25 -
15. Building a Report (Data Modeling & DAX) 3
12:23 -
16. Data Cleaning; Rocry Business Report 1
14:57 -
17. Data Cleaning; Rocry Business Report 2
14:53 -
18. Creating a Power BI Corporate Account
00:00 -
19. Publishing Report
05:02 -
20. Advance Chart & Publishing Report
09:02 -
21. Power BI Microsoft Authenticator
00:00
Power BI DAX & Projects
A complete Power BI DAX training
-
1.1 Introduction to Power BI DAX
12:37 -
1.2 Basic Date Functions in Power BI DAX 1
06:52 -
1.3 Basic Date Functions in Power BI DAX 2
04:06 -
1.4 Basic Date Functions in Power BI DAX 3
13:11 -
1.5 Basic Date Functions in Power BI DAX 4
17:12 -
1.6 Basic Date Functions in Power BI DAX 5
06:20 -
2.7 Aggregate Functions I
19:12 -
2.8 Aggregate Functions II
06:08 -
3.9 Logical Function (IF)
06:46 -
3.10 Logical Function (IFERROR)
06:58 -
3.11 Logical Functions (AND OR)
08:42 -
4.12 Data Cleaning 1
11:21 -
4.13 Data Cleaning 2
09:37 -
4.14 Data Cleaning 3
12:05 -
5.15 Data Cleaning With Power BI Power Query 1
12:48 -
5.16 Data Cleaning With Power BI Power Query 2
06:36 -
5.17 Data Cleaning With Power BI Power Query 3
15:15 -
5.18 Data Cleaning With Power BI Power Query 4
06:49 -
6.19 Calculate 1(Count & Sum)
13:51 -
6.20 Calculate 2( Count & Profit)
12:31 -
6.21 Calculate 3 (Date Difference)
13:38 -
6.22 Calculate 4 ( Qtrs, Not Equal)
08:23 -
6.23 Time Intelligence Function 1(Between Dates & MTD)
13:18 -
6.24 Time Intelligence Function 2 ( QTD & YTD)
12:19 -
6.25 Time Intelligence Function 3(Checking answers)
11:21 -
7.26 Data Modeling 1
13:04 -
7.27 Data Modeling 2
08:07 -
7.28 Data Modeling 3
00:00
Power BI Internship
End-to-end project internship with Power BI
-
Project 1Krest Recruitment I
14:28 -
Project 1 Krest Recruitment II
14:45 -
Project 1 Krest Recruitment III
13:03 -
Project 2 The London Metal Exchange I
13:26 -
Project 2 The London Metal Exchange II
14:31 -
Project 3 – AK Technology I
13:52 -
Project 3 – AK Technology II
07:29 -
Project 4 – Presh Technology I
14:44 -
Project 4 – Presh Technology II
15:01 -
Project 5 Sales Transaction Data Analysis 1
13:53 -
Project 5 Sales Transaction Data Analysis 2
15:00 -
Project 6 Norlands e-Commerce Store 1
14:49 -
Project 6 Norlands e-Commerce Store 2
09:28 -
Project 7 Sales Data Executive Reporting 1
14:31 -
Project 7 Sales Data Executive Reporting 2
11:37 -
Project 8 Shopping Analysis of Istanbul 1
15:03 -
Project 8 Shopping Analysis of Istanbul 2
14:05 -
Project 8 Shopping Analysis of Istanbul 3
08:47 -
Project 9 RushTech Financials 1
15:03 -
Project 9 RushTech Financials 2
07:18 -
Project 10 African Population by Sub Region 1
09:38 -
Project 10 African Population by Sub Region 2
14:16 -
Project 10 African Population by Sub Region 3
11:42 -
Project 20 – Skibs Enterprise
-
Project 21 – Freelance Gig (4 Projects)
Business Intelligence with Tableau Desktop
A complete course on Business intelligence with Tableau Desktop
-
1. Tableau Desktop Intro
15:01 -
2. Tableau Desktop Public Installations
11:05 -
3. Tableau Data Types & Interface
07:48 -
4. Formatting Measures
12:51 -
5. Formatting Measures 2
10:10 -
6. Tableau Filters
13:23 -
7. Tableau Charts 1
10:57 -
8. Tableau Charts 2
14:54 -
9. Tableau Charts 3
15:02 -
10. Tableau Mark Cards
14:13 -
11. Tableau Formatting
13:06 -
12. If Statement
14:14 -
13. Tableau Calculation (Count, CountD, CountIF)
13:27 -
14. Tableau Calculation – SumIF, SumIFS
10:05 -
15. Tableau Calculation – Date Yr, Mnt, Qtr
11:25 -
16. Tableau Calculation – Date Functions
10:20 -
17. Tableau Calculation – String
14:50 -
18. Tableau Calculation – String Split
11:53 -
19. Tableau Dashboard 1
14:12 -
20. Tableau Dashboard 2
14:51 -
21. Tableau Dashboard 3
15:03 -
22. AK Dashboard 1
14:43 -
23. AK Dashboard 2
15:02 -
24. AK Dashboard 3
14:25 -
25. Global Sales Dashboard 1
14:46 -
26. Global Sales Dashboard 2
14:56 -
27. Global Sales Dashboard 3
14:53
Database Management with MySQL
A complete beginner to advance mastery course on database analysis and management with MySQL
-
1.1 Course Introduction
04:23 -
1.2 Download & Installation of MySQL
15:37 -
1.3 The Workbench Overview
09:47 -
1.4 The SELECT Statement
08:48 -
1.5 The Select Clause
10:38 -
1.6 The WHERE Clause
07:08 -
1.7 The ORDER BY Clause
06:16 -
1.8 The LIMIT Clause
03:32 -
1.9 The AND, OR and NOT Operator
06:25 -
1.10 The IN Operators
04:51 -
1.11 The BETWEEN Operator
02:55 -
1.12 The LIKE Operator
12:12 -
1.13 The REGEXP Operator
14:04 -
1.14 The NULL Operator
03:48 -
1.15 Inner Join
14:03 -
1.16 Joining Across Database
06:36 -
1.17 Self Join
06:19 -
1.18 Joining Multiple Tables
14:25 -
1.19 Outer joins
09:10 -
1.20 Outer Joins Between Multiple Tables
00:00 -
1.21 Self Outer Join
02:21 -
1.22 The USING Clause
09:55 -
1.23 Natural and Cross Joins
07:44 -
1.24 Unions
13:05 -
1.25 Inserting a Single Row(Column Attributes)
16:42 -
1.26 Inserting a Multiple Rows
06:01 -
1.27 Create a Copy of a Table
08:45 -
1.28 Updating a Single Row
07:15 -
1.29 Updating a Multiple Rows
05:44 -
1.30 Exporting Query Output
11:27 -
2.31 Creating a Database and Table
15:20 -
2.32 Importing Excel file to MySQL Database
10:24 -
2.33 SubQueries in MySQL
00:00 -
2.34 SubQuery across tables
00:00 -
2.35 VIEWS in MySQL Part 1
11:13 -
2.36 VIEWS in MySQL Part 2
11:32 -
2.37 Stored Procedure 1
06:43 -
2.38 Stored Procedure 2
05:01 -
2.39 Stored Procedure 3
07:34 -
2.40 Trigger in MySQL
09:12 -
2.41 Introduction to Function in MySQL
06:56 -
2.42 String Functions in MySQL
13:56 -
2.43 The Number Function in MySQL
05:53 -
2.44 The Date Functions in MySQL
09:35 -
2.45 Aggregate Function in MySQL
04:46
Database Management Internship with MySQL
An end-to-end project based internship in database management with MySQL
-
1. Create a Schema
23:36 -
2. Database Administrator Quick Test
27:05 -
3. Google Form Form Response
22:46 -
4. HR Records
30:32 -
5. Customer Details Task 1
18:45 -
6. Customer Details Task 2
20:34 -
7. Employee Data Task 1
21:19 -
8. Employee Data Task 2
23:33 -
9. Employee Data Task 3
21:15 -
Interview Questions
-
11. Combining Tables
17:03 -
12. Sales Transaction Analysis – Loses
29:40 -
13. Transaction Details – Manager Analysis
35:01 -
14. Transaction Details – Returned Analysis
00:00 -
15. Rush Tech Financials
00:00 -
16. Credit Card Analysis
32:21 -
17. Skibs Enterprise
34:52
Data Analysis with Python Programming
A complete data analysis mastery course with Python Programming
-
1. Download and Installation (Python & PyCharm)
05:00 -
2. Introduction to python programming
12:15 -
3. Getting Inputs
12:33 -
4. Download and Installation of Anaconda
07:11 -
5. Working with Jupyter Notebook
06:58 -
6. Data Types
08:01 -
7. Variables
11:56 -
8. List
14:16 -
9. Sorting a List
04:50 -
10. Intro to Data Analysis with Pandas(Loading Data)
09:11 -
11. Basic Tips on Dataset with Pandas
14:07 -
12. Creating Columns and Saving Worked File
07:33 -
13. Result Analysis with Python
13:52 -
14. Percentages
18:04 -
15. Date Functions
11:15 -
16. Filters
14:17 -
17. Multiple Condition Filtering
20:39 -
18. Pivot Table
13:33 -
19. Sorting the Index (Month) Column
06:58 -
20. Introduction to Charts (Bar Chart)
09:53 -
21. Introduction to Charts(Pie)
05:21 -
22. Charts from Pivot Table
08:28 -
23. Line and Area Chart _ Saving
03:14 -
24. Project Work A24. Project Work A
13:40 -
25. Project Work B
16:59 -
26. Project Work C
11:19
Student Ratings & Reviews
4.5
Total 2 Ratings
5
1 Rating
4
1 Rating
3
0 Rating
2
0 Rating
1
0 Rating
The goal to become a Data Analyst and Business Intelligence specialist is gradually becoming a reality. Thanks TecSkills for this holistic training.
I'm glad I enrolled for this training.
The lessons are well simplified and Mr Awesome is doing a great job.
Perfectly fits my work schedules
The lessons are well simplified and Mr Awesome is doing a great job.
Perfectly fits my work schedules