+233 54 123 9290
support@festman.io
English flag
English
Select a Language
English flag
English
GH₵
GHS
Select a Currency
Ghanaian cedi
GH₵
Euro Member Countries
Nigeria Naira
United States Dollar
$
0
Analyze World Shippers Data in SQL

Analyze World Shippers Data in SQL

Analyze World Shippers Data in SQL
138 Students
13 Lectures

About This Course

Thomas Festus Cudjoe
Thomas Festus Cudjoe
(20)
35 Courses
2187 Students
Festus is a Senior Data Analyst, Finance Professional, and Chartered Accountant (CIMA & ICAG) with 7+ years of experience in analytics and business intelligence. He specializes in Power BI, SQL, Python, financial modeling, and AI-driven analytics. At FestMan, he delivers practical, project-based training in Excel, Power BI, Python, SQL, and Applied AI for work. Festus is a Microsoft Certified Trainer, Power BI Certified Analyst, Microsoft Excel Expert, and a 4x Microsoft Data Platform MVP.
Curriculum Overview

This course includes 2 modules, 13 lessons, and 0:29 hours of materials.

Project Scenario
5 Parts | 0:29 Hours
Project Overview

Overview of the guided project

Study Duration 9 Minutes
Attachments 0
SQL Query

Download this file and open. You will need this to run the SQL that will create the tables.

Volume 72.41 KB MB
Creating the SQL tables
Volume 87.20 MB
Explore the data and ERD
Volume 19.65 MB
Business Questions and submission

Analyze the data to answer the questions.

Study Duration 20 Minutes
Attachments 0
Guided Solution
8 Parts
Tutorial 1: Retrieve top selling products based total orders?
Volume 16.20 MB
Tutorial 2: Retrieve the Top 10 most profitable products
Volume 25.67 MB
Question 3: retrieve the products that are loss-making
Volume 21.76 MB
Tutorial 4: Retrieve the top 10 customers by orders
Volume 18.09 MB
Tutorial 5: Retrieve the customers with no orders
Volume 28.54 MB
Tutorial 6: Retrieve the days with the highest sales volume
Volume 21.03 MB
Tutorial 7: Retrieve the months with the highest sales volume
Volume 14.93 MB
Tutorial 8: Retrieve the products with no orders
Volume 17.60 MB
Certificates
1 Parts
Course Certificate
Course Certificate
If you pass all the lessons in this course, you will receive this certificate.
Type Course Certificate
Reply to Comment
Comments Approval

Your comment will be visible after admin approval.

0
0 Reviews
Content Quality (0)
Instructor Skills (0)
Value for Money (0)
Support Quality (0)
Reply to Review
Submit Reply

Your reply to this review will be visible to all users.

Analyze World Shippers Data in SQL
GH₵99
Enroll with Pro Account

This Course Includes

Downloadable Content
Official Certificate
Instructor Support
Course Forum

Course Specifications

Sections
2
Lessons
13
Capacity
Unlimited
Duration
1:00 Hours
Students
138
Created Date
8 Sep 2023
Updated Date
13 Dec 2025
Thomas Festus Cudjoe
Thomas Festus Cudjoe

Founder & Lead Instructor

(20)
Microsoft Certified Trainer
Microsoft Certified Excel Expert
Microsoft Certified Power BI Analyst
Google Certified Data Analyst
Microsoft Office Specialist: Excel 2013
Microsoft MVP
10 courses launched
Microsoft Certified Excel Expert

Send Course as Gift

Send as a gift to friends
Analyze World Shippers Data in SQL
You are viewing
Analyze World Shippers Data in SQL