Sebastian Taylor & Pavel Nacev – CFI Education – SQL Case Study – WOWI Sales Analysis

File Size: 228 MB.

---

Sebastian Taylor & Pavel Nacev – CFI Education – SQL Case Study – WOWI Sales Analysis

Take on the role of a sql focused business intelligence analyst, working with World Wide Importers to answer a series of business questions:

• explore a database from scratch using documentation and guided questions
• use SQL to respond to business questions with data-driven insights
• apply SQL to real-life scenarios

Overview

SQL Case Study – WOWI Sales Analysis Course Overview

You’ve recently joined World Wide Importers as a Business Intelligence Analyst. They are a novelty goods distributor and are keen to get you involved in helping make some key business decisions.

You’ll be exploring the database, responding to questions from the product and marketing teams, and using all the knowledge you gained in SQL fundamentals to test your skills on the job.

SQL Fundamentals Learning Objectives

Upon completing this course, you will be able to:

• Explore new data using documentation
• Apply SQL queries to respond to business questions
• Execute simple queries from single tables
• Execute complex queries using joins and subqueries
• Develop responses based on evolving requirements from the business

Who should take this course?

This SQL case study is perfect for those who want to put their knowledge about SQL into practice with selected, real-life scenarios. This makes the course a great follow-up to CFI’s SQL Fundamentals. As with any coding language, SQL can be daunting: while this course aims to present practice problems, you’ll also be able to walk through each problem with assistance where needed. Every concept and step is explained clearly and in non-technical language.

Prerequisite Courses

Recommended courses to complete before taking this course.

• SQL Fundamentals

What you’ll learn

Case Study Introduction

SQL Case Study Introduction

Learning Objectives

Case Overview

Downloadable Materials

SQL Login Credentials

Basic Queries

Chapter Introduction

Explore the Database

Basic Customer Data

Product Data

Marketing Data

Marketing Data Part 2

Delivery Efficiency

Other Data

Multi-table Queries

Chapter Introduction

Sales Over Time

Sales by Fiscal Period

Top Selling Products

Top Selling Chilled Products

Conclusion

Case Study Summary

Qualified Assessment

Qualified Assessment