Learning Goal: I’m working on a databases project and need an explanation and answer to help me learn.
Scenario: You work in a consulting company, and your client is a human resource, payroll, and benefits outsourcing services company. They have shared the website data from Dec 2021 to May 2022 which is attached by folder name: “Assessment Data” (link below).
You are required to complete the below task and present the report to client POC who is senior marketing manager in the company.
1. Analyze the data shared by the client team and create a dynamic dashboard visualization showing the overall website performance from Dec’21 to May’22.
2. Compare the Dec’21 v/s Mar’22 month performance, and share key actionable Insights from the dashboard.
Note: Kindly use any one of the visualization tools like Power BI/Tableau/Google Data Studio/any other similar tool for the below assignment (Please don’t use excel sheets for the same).
Instructions for the Assignment
1. In Visualization create a Date filter, further ensure that all date columns in the data sets are made in MM/DD/YYYY format.
2. Create a suitable visualization based on “Landing Page” sheet and share key insights of Landing Page performance using the below metrics.
=> Bounce Rate
=> New users
=> Unique events
=> Total Events
3. Using a “Demographic” sheet, create a visualization by using the New User metric and share insights on the basis of Geo Location (country).
4. Create a suitable composition chart from the “Demographic” sheet showcasing which age group is better in terms of session count and average session duration.
5. Use a suitable visualization from “Active User” sheet to showcase monthly average of 1 day Active user, 7 day Active user , 14 day Active User and 28 day Active User as a percentage of 28 day Active User
6. Create a suitable visualization from the “New User” sheet to showcasing target vs actual users (Kindly use visualization other than line chart visualization)
Answer these questions please based on this data.
1. Kindly share insights on the website performance form the period of Dec’21 and May’22.
2. What is the New Users count from the “New User” sheet for the Month of March 2022.
3. What are the Top 3 Best performing Landing Pages for the Month of March 2022 in terms of Total Event counts select from blow.
4.What are the Top 3 Best performing Landing Pages for the Month of Jan 2022 in terms of new users count.
5. Which is the Top performing channel in the month of Jan Feb and Mar 2022 in terms of Sessions Count.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more