Dynamic Comparison in Butterfly Chart
Dynamic Comparison in Butterfly Chart is useful when you want to compare the Sales or any other parameter for two employees or two Teams for multiple dates. We have used
Tag: Sales Dashboard
Excel Comparative Analysis Dashboard with Power Pivot
This Excel comparative analysis dashboard uses Power Pivot to compare current-year sales with the same period in the previous year, and actual sales with budget. Three tables supply the data:
Combine Tables into a Dynamic PivotTable with Power Query
Power Query consolidates the tables used in this Excel PivotTable example: four yearly Sales Tables and an Employee Master containing supervisor and employee names. The final report includes slicers and
Top/Bottom Analysis dashboard in Excel
The Top/Bottom Analysis dashboard in Excel ranks employees and locations using a sample sales dataset. It combines slicers, Form Control option buttons and a scrollbar to change the ranking view
Dynamic Dashboard with Tablet and Mobile shape in Excel
This dynamic Excel dashboard presents information inside tablet and mobile frames made with Excel Shapes. A Form Control scrollbar makes the compact worksheet display interactive. The tutorial explores a layout
Beautiful Power BI Dashboard with Northwind Database
This Northwind Power BI dashboard uses the Northwind sample database through an OData feed. Its three pages cover overall sales, product and category stock, and employee results. The tutorial also
Insert a Picture in Excel Comments (Notes): Show Image on Hover
To insert a picture in Excel comments, you fill the comment box with an image instead of text, so the picture pops up only when someone hovers over the cell.
Sales Dashboard in Power BI: Design, Publish and Share
A sales dashboard in Power BI turns three plain Excel tables into an interactive report your team can open in a browser. In this tutorial you build the full project