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

Description

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

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

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.

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

What our students say

It is good for analysis
Lydia Angolo Endjala

Awesome
I enjoyed every bit of the course. Thanks to the Instructor
Oluwafemi Ayelomi

Good refresher course on SQL. A little tough at the end but very informative. I enjoyed this a lot.
Onyedika Nwoji

Commonly Asked Questions:

1. Business Model Innovation: Acknowledge the reality of a legitimate enterprise! Our approach involves the coordination of a collective purchase, in which the costs are shared among the participants. We utilize this cash to acquire renowned courses from sale pages and make them accessible to individuals with restricted financial resources. Our clients appreciate the affordability and accessibility we provide, despite the authors’ concerns.
2. CFI Education – SQL Case Study – WOWI Sales Analysis Course

• There are no scheduled coaching calls or sessions with the author.
• Access to the author’s private Facebook group or web portal is not permitted.
• No access to the author’s private membership forum.
• There is no direct email support available from the author or their team.