Dashboard Gallery
In this dashboard I am analysing data for a fictitious coffee shop. I have used a time series line plot to show the sales trend over the period, with a description of the sales peak in June. In the bar & column chart - I am utilising a sort and highlight max value technique to draw the readers attention to the highest value.. this allows insights to be seen easily.
In this dashboard I am analysing data for a fictitious corner shop. Using the same techniques as previously I am drawing the reader to the most important values for the dashboard. All charts are sorted from largest to smallest - including the pie chart.. this is an important factor to decrease the work the user has to do in deciphering the data!
In this final dashboard I am analysing data for a fictitious supermarket store. Using a vibrant colour palette on this report, I am emphasising the brand image of quality discounts. On the left hand side are two slicers, these allow the user to interact with the dashboard and change the displays based on the criteria they prefer.
Excel Formulas Examples
=SUMIF(Table1[Product line],"Health and beauty",Table1[Total])
=XLOOKUP([@[Invoice ID]],invoice_detail!A:A,invoice_detail!B:B,"NO MATCH",0)
=XLOOKUP([@[Invoice ID]],invoice_detail!A:A,invoice_detail!B:B,"NO MATCH",0)
In this example I am summing the total values in the total column where the product line is health and beauty.
=XLOOKUP([@[Invoice ID]],invoice_detail!A:A,invoice_detail!B:B,"NO MATCH",0)
=XLOOKUP([@[Invoice ID]],invoice_detail!A:A,invoice_detail!B:B,"NO MATCH",0)
=XLOOKUP([@[Invoice ID]],invoice_detail!A:A,invoice_detail!B:B,"NO MATCH",0)
In this example I am using XLOOKUP to return the payment type for the invoice-id from a separate table. Using this function, I can dictate to return "NO MATCH" if the value is not present in the lookup table.