Building a beautiful non-Excel-looking Dashboard using…Excel (part 3)

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!

Continue reading “Building a beautiful non-Excel-looking Dashboard using…Excel (part 3)”



Building a beautiful non-Excel-looking Dashboard using…Excel (part 2)

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 “how to prepare the tabs formatting” of our future very sexy cockpit. Now, it is time to add some content:

Continue reading “Building a beautiful non-Excel-looking Dashboard using…Excel (part 2)”



Sensdat Joins the Microsoft Power BI “Red Carpet” Program

Today we want to share a great piece of news with our clients, friends, and followers: Sensdat has officially joined the Microsoft Power BI “Red Carpet” Program. After achieving Microsoft Partner status last month (…did we forget to mention that? Well, now you know 🙂 !), this is another big milestone for us.

The Power BI Red Carpet Program is an exclusive group of Microsoft Partners who are selected for demonstrating an exceptional level of expertise in Microsoft’s Power BI platform and delivering first-class business intelligence solutions to their clients. This distinction enables us to be featured on the Power BI Partner webpage as one of the UK-based partners, alongside other, (slightly) bigger companies like IBM.

This also means our Retail Analysis demo is featured on the Power BI Showcase portal. Click “View Report” and you’ll be able to interact with our dashboard.

Showcase

How quickly can you spot which Asian country has had the highest Year-over-Year growth in sales?

Continue reading “Sensdat Joins the Microsoft Power BI “Red Carpet” Program”