Hmm, in your data sample. I don't see any time segment. Typically speaking, unless dashboard is for fixed duration (i.e. Fiscal Year etc) for summary of the duration... you'd want that info included in raw data.
Also as I have mentioned...
Assume that we know nothing of your business (or data).
Oops, sorry forgot to mention what the abbreviations mean. But you are right TY, LY, GR is This Year, Last Year and Growth Rate. AUR is Average Unit Revenue and L2B is Look to Book (i suppose that means, sales to visits)
Many thanks for your help.
Here's bit of demo on how to set up dynamic ranges etc.
I was going to do comparison chart on 2 metrics, but decided against it as data did not flow well.
For now, I've just added picture tool to dynamic range. Just to show something.
Few notes on controls:
1. GR - Up/Down - This controls whether to rank ascending or descending based on Metric 1's GR.
2. Metric 1 - Primary metric (left side)
3. Metric 2 - Secondary metric. Shows corresponding stats for same item.
Interestingly, Some items show high Collection_View, but low Revenue.
Ex: Male - BOTTOMS - JEANS
This one may be due to significant decrease in AUR (-93%).
It's been a while since I did purely formula/built-in tool dashboard without use of Data Model.
This reminded me why
With wide range of data values, it's bit difficult to chart all data points in same chart while making it readable. You could... use panel chart with changing axis values... but I don't like them, as visualization will be misleading at a glance.
In these type of scenario, I like to dynamically group items into TopN + Other. Which I use DAX measure with pivot table to accomplish.
I suppose I could just show AUR & L2B in chart corresponding to Camera tool and dropdown selection.
You are right Chihiro; all data points in 1 / 2 chart will make it difficult to comprehend.
Maybe we could go in for a 5/6 chart dashboard, that are dynamically linked, so that change in 1 parameter, gets reflected in all the other charts too.
DAX measure is something that I am reading now (thanks to you) for the first time, will learn more about it.
From the view point of a manager, what would you like to see on the dashboard from the data that is available?
And also maybe we can add three master parameters, to see data based on 1) Male + Female 2) Only Male 3) Only Female.
What do you think? Will that make it more presentable? Awaiting you insights on how to make this more interesting.
Thanks & Regards, Tarak
It would be a report with overview / summary at the top and then on total visitors and revenue generated through sales across different product categories, comparing periods to understand growth pattern.
So basically an interactive dashboard with appropriate charts & graphs for senior management consumption that provides relevant insights from the data.
I'd suggest a small tweak in the report of @Chihiro in #19.
For the grouping change the settings (untick) "Summary rows below details".
It is not a big deal, I simply find it more intuitive that a "menu" drops open downwards.
some top of mind things that popped up...
This report contains so much info, the information drowns itself. "Whacking your brain..." indeed. I believe for a data analyst this is a great report though. You might find suggestions that some products are not successful. Shirts and swimming clothes might not be selling well, but perhaps you had 2 great summers or 2 warm seasons in a row, so people did not need to buy again or sales was more spread? Is there a correlation between visits and sales? You might be having more visits, but lesser or declining sales. => great website, but lousy products? Would you have loyal consumers (if that data is at hand)?
Those are the things a data cruncher can present to decision makers.
In the line of #15...
I'm not a great fan of simply comparing this year vs last year. At least a trend over several years might show a different story. As in "we did better then last year" versus "yes, we do better then last year, but in the overall trend our sales is slowing down".
MALE SEASONAL APPAREL only contains 1 sub item, you might group is in another way, like add it to MALE OTHER.