FINAL GROUP ASSIGNMENT - AI & Data Analytics
You are the new Data Analyst team for your company. You work in a consultancy
company that gives advice about marketing strategies for brands and other companies.
You have been hired to be the consultants for a movie production company, with the objective
to improve future marketing strategies within new blockbuster productions. They are planning to
produce a new trilogy of movies. Hence, they want to understand the reception their past
blockbusters had from customers and fans, in order to improve and avoid issues.
TASK #1: Gather data using ParseHub
You need to choose from one saga your three favorite blockbuster movies. Here you have some
movie sagas options:
- The Lord of the rings
- Harry potter
- Star Wars
- MCU (Marvel)
- Etc.
Gather data from any movie websites sources using ParseHub. The data gathered should include,
at least, the following variables:
• Username
• Review
• Date of review
• Rating
You need to get at least 500 reviews for each movie.
TASK #2: Creating Reports using Power BI
Using PowerBI and PowerBI Desktop, you need to prepare a customized report for each film,
including, at least, the following visuals:
- Count of users and/or reviews
- KPI Circle Gauge to show the average sentiment score
- Word cloud plot of the reviews
- Table with review details for the fields: username, title review, review, rating, sentiment score
(color the background of the sentiment depending on the score sentiment of the review),
- A filter by user, date, and review language
- A graph with the users that have more reviews (including the number)
- Scatter plot representing the sentiment and the number of reviews
- A timeline showing the number of reviews
NOTES:
You can use more than 1 page to place the visuals, and you can create other visuals that you consider
necessary to understand your data.
FINAL GROUP ASSIGNMENT - AI & Data Analytics
TASK #3: Business Analysis using Power BI
Together with social listening, sentiment analysis is very beneficial for brands, since it allows them
to know how consumers feel about them and with what intensity. In this regard, your work will
consist in perform a deep comparison among the three selected movies from a saga. To such end,
you will:
- Create a report on Power BI showing the highlights/differences between the three movies
analyzed. You can compare, among others, the number of reviews, the sentiment, the dates,
etc.
- You will need to import the three datasets to Power BI Desktop order to use them in the
same report.
Once displayed all the visuals in the report, you will do a data analysis that will help improving future
marketing strategies and prevent future issues. This analysis could refer either to the brand of the
movie/company itself or purely to the content of the movie (script or direction decisions) that could
benefit the customer’s opinions or revenue of the movies.
This analysis should include a detailed answer to the following business topics/questions:
(1) Information about the feelings that the brand and/or the content of your selected
movies awaken in consumers.
Users are writing bad or good reviews lately about their movies.
TO DO: Data extraction and analysis of the sentiment/word cloud obtained.
(2) Possibility of improving strategies.
Strategies that could improve the image of the brand, attacking the specific negative points/issues
that have been analyzed in the previous point.
TO DO: Proposal for improvements using strategies (marketing or business level) based on the
previous obtained results/insights.
(3) Prevent future reputation crises.
Explain how to avoid damaging the image of the brand further with problem such as the of low-
quality of the movies, bad workers conditions, which would worsen the image of the brand, etc.
TO DO: Proposals for general improvement in order to avoid future reputation crises (which might
worsen the feelings towards the brand or product among social networks).
These points could refer either to the brand of the movie/company itself or referring to the pure
content of the movies, like suggesting improvements for the script or direction decisions that could
benefit the customer’s opinion or revenue of the movies.
Final Report
You have to create a full report in PDF or PowerPoint including all graphs and explanations for
the three previous tasks. You should include all visuals and screenshots required to complement
your work.
It is also important that you explain which kind of data you gathered and from where you took it,
why you gathered such data and why is that important for your analysis.
You have to perform your analysis using the tools that you have learned/used during the course
(PowerBI, ParseHub, etc.).
The PowerPoint/PDF presentation/report must contain 25 pages maximum including graphs and
explanations (you can also include links to the interactive dashboard reports on Power BI).
FINAL GROUP ASSIGNMENT - AI & Data Analytics
WORK UPLOAD INSTRUCTIONS
WHERE?
On K2 (only 1 file per group)
HOW?
File name as:
TD1-2-3-4-5-Group1-2-3-4-5-FinalWork.pdf-ppt
For example:
TD2-Group3-FinalWork.ppt
WHEN? (Deadline)
30th of October at 13:00
WARNING: If you do not follow this upload instructions, you will be penalized with -3 points.
EXTRA POINTS:
+2 points if you enrich your data from different sources (webpages), also detailing such difference
in the results among these different data sources.
