The most profitable month

In this exercise you’ll research what is the most profitable month of a company based on it’s financial data. This is a very important Marketing insight. Any Marketing is seasonal. Which means there’re months when a company is very conservative about investing marketing money and there’re really profitable months when a company is really aggressive (for example, during the New Year resolutions rush in January).

This data warehouse simply contains all company’s financial transactions.

If the company paid for something – there’s a debit transaction with negative amount. If someone paid the company – it’s a credit transaction with positive amount.

Hi, it’s Anatoli, the author of SQL Habit.

SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst and solve real-life challenges from Business, Marketing, and Product Management.

SQL Habit is also a collection of Practice exercises (you’re looking at one atm) based on various datasets (E-commerce, Finance, etc). They’re meant to deepen your SQL and Data Analysis knowledge , prepare you for any challenge at work or a job interview.