When dealing with a client that has Excel 2010, 2013 or 2016, the Sensdat team builds and formats the dashboard with Excel of course, using Pivot Tables, slicers, hyperlinks and conditional formatting. This blog post is about visuals only, what we call the “window” that we create and set on the very messy and dark “data-Mordor” 🙂 . The “back-end stuff” (data modelling, Kpis, etc…) is of course made with our favorite tools: Power Pivot and Power Query but does not interest us here. The following process will help you save a lot of time and repetitive tasks while creating an awesome cockpit that will make all of your colleagues admire your skills! 🙂
In our last post, we looked at “adding some insightful content” to our already very sexy cockpit. Yeah! It was a long post. So, this one will be a short one, promised!