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

Description

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 review, Sebastian Taylor & Pavel Nacev – CFI Education – SQL Case Study – WOWI Sales Analysis free
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