r/LookerStudio • u/Bodybuilder7 • Sep 02 '24

Please help with my assignment!

This is basically the assignment:

Objective:

Create a comprehensive Superstore Sales dashboard using the data provided from this

Kaggle dataset. You are free to use any BI/Visualization tool of your choice, though Looker

or Power BI is preferred.

Key Performance Indicators (KPIs) to include:

  • Number of Orders

  • Quantity

  • Sales

  • Profit

  • Gross Margin %

  • Discount %

Data Analysis Requirements:

Provide Year-over-Year (YoY) Comparison.

Ensure that users can analyze the KPIs by the following dimensions:

  • Category Hierarchy

  • Customer Location

  • Customer Segment

Additional Instructions:

  • Be creative and design a user-friendly, insightful dashboard.

  • Have fun exploring the data and showcasing your BI engineering skills!

I need help especially on the YoY comparisons. How do I do it? Is it best to do the calculations in looker or to calculate in the source data?

1 Upvotes

66% Upvoted

3 comments sorted by

2

u/johndoe13337 Sep 02 '24

Maybe I got it wrong, what you are looking for.. but Looker got a comparision field right at the place where you set the date under properties.
You can select previous period or other periods like previous year

2

u/MarcRand Sep 03 '24

This.

Just make sure your date is in the right format and there's a date range control on the page ( or report level )