Movies Analysis With Sql And Ms Excel

For my recent project, I made use of SQL, MS Excel and MS PowerPoint. My tutor provided the dataset used. The dataset is about movie companies and movie genres from 1980 to 2020

DATASET

https://drive.google.com/file/d/1UtGFdX7jCJTiUW4Mya39KpHJ1kDBwGyd/view?usp=drive_link

BUSINESS REQUIREMENTS

https://drive.google.com/file/d/1dqkfQ6wL5ue2BCOR6dtdNZxtmSpTS1si/view?usp=drivesdk

With SQL, I was able to answer the business questions using SQL statements; FROM, WHERE, GROUP BY, ORDER BY, SELECT, WHERE and HAVING.

Most of the functions used were aggregate functions (MAX, MIN, COUNT, SUM, AVG), CONCAT, CASE etc. SUBSTRING and CHARINDEX functions which are similar to the MID and FIND functions respectively in MS Excel.

For each question answered, I used the “SELECT INTO” statement to convert them into tables.

VISUALIZATION

I imported each table into Excel for visualization. For the questions that had one answer, I used a scorecard for the visualization.

My tutor wanted a presentation on the project, with MS PowerPoint. I copied each query from SQL and pasted it carbon.now.sh site to have a beautiful image of my query. Copied and pasted as an image in PowerPoint, alongside the chart for each query.

Below is the link for the PowerPoint presentation.

https://drive.google.com/file/d/1RAnqBHL5JYqvU8MZVjZLrcf4_tmbQoZ2/view?usp=drivesdk

Thank you!