Business Intelligence project that focuses on analyzing the narratives in cinema with female leads. The goal is to understand better what authentic and engaging underrepresented stories are.
Dataset: Box Office Performance of Movies with Female Leads and part of Movie Bechdel Test Scores (extract the part between the years 1970 and 2013).
Day 1
Goal: Define the project scope and goals and begin data gathering and processing.
- Investigate the data and prepare a plan for data cleaning and organizing.
- Upload data sources for the Box Office Performance of Movies with Female Leads and the Movie Bechdel Test Scores data.
- Begin data cleaning process of both separate datasets
Deliverables: A project scope and goals document, and a data cleaning and organization plan.
Day 2
Goal: Finnish cleaning and organizing the data and a cleaned and organized Box Office Performance of Movies with Female Leads dataset.
-
Cleaning and organizing both separate datasets
-
Merge the cleaned Box Office Performance of Movies with Female Leads data with the Movie Bechdel Test Scores data.
-
Explore the data and identify patterns or trends, model the data, and if it's ready move it already to Tableau.
-
Conduct data analysis and prepare rough ideas for visualizations, such as bar charts, scatterplots, or histograms. (Tableau or using Pandas first)
-
Fine-tune the visualizations to ensure they are clear and accurate.
-
Prepare a summary of the findings and insights.
Deliverables: A merged dataset and a set of visualizations with a summary of findings document.
Day 3-4
Goal: Prepare a well-documented and organized presentation of the data analysis process and results in Tableau.
- Review the findings and ensure they align with the project goals.
- Complete the BI dashboard in Tableau
- Prepare the presentation structure and outline the main points to cover.
- Document the data analysis process and the results, including data sources, cleaning and organization steps, and analysis techniques used.
- Create a visually appealing and easy-to-follow presentation.
- Define further research ideas.
- Practice presenting the material to ensure a smooth delivery.
Deliverables: A well-documented and organized presentation of the data analysis process and results.