6 SQL for Data Analysis Case Study

Join our book community on Discord

https://packt.link/EarlyAccessCommunity

Qr code Description automatically generated

At this point, you’re finally prepared with the necessary tools to deal with a more complex project from scratch. And that’s exactly what we’re going to be doing in this chapter. In a nutshell, we’ll:

  • Set up our database
  • Familiarize ourselves with the data
  • Write queries to analyze the sales of EcommerceHub store

ECommerceHub is an (imaginary) international e-commerce store run by the (imaginary) famous Umar Ali with a wide variety of inventory and a diverse customer base. He needs our help analyzing his data. No need to keep him waiting ...

Get Becoming a Data Analyst now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.