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.

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
=> Sessions

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.

www.xyz.com/corporate/terms

www.xyz.com/index.aspx

www.xyz.com/retirement-services

4.What are the Top 3 Best performing Landing Pages for the Month of Jan 2022 in terms of new users count.

go.xyz.com/hcm-abc

www.xyz.com/corporate/terms

www.xyz.com/index.aspx

5. Which is the Top performing channel in the month of Jan Feb and Mar 2022 in terms of Sessions Count.

6. Which is the best performing month for 1 Day active Users in terms of user count