Instagram user analytics - SQL

This is part of the Data Analytics-Trainee program conducted by Trainity. From schema, created a database, a table, and inserted a small sample data columns. From this project, I got an idea about how as a business or data analyst we work on real-time data to take any data-driven decision. One thing I infer about this project is the dataset provided was very limited and small in respect of rows and columns, But still, it was a very good experience working on such kind of project. It helped me a lot to understand the analysis process well and to provide insights for the best decision possible.

For this project, I have used My SQL & Db fiddle as well, to extract the required data from the given database using the Join function, subqueries, Aggregation, Where condition, Group by, Distinct, CTE, and other functions required. keeping the Primary key and foreign key in consideration provided all the reports asked by the marketing department and Investor metrics department.

I have used Canva for making this presentation as it contains the required Elements, Images that made this project more attractive.

For more details please visit -

https://drive.google.com/drive/folders/1Wtb-yy433v-_Ag9Xx2KNv_c8OgY7B6fh?usp=sharing