I’m very happy to announce that finally I submit the chapter for the next MVP Deep Dives Book that I’m a co-author with some other MVP professionals around the world. The book will be published next October and for sure I’ll give you here more news about it.
The chapter I wrote, explains the construction of an Excel Dashboard from an IT and Business perspective in a retail sector scenario. It was not intended to explain the best way to create a dashboard for the retail sector, but to describe some tips and tricks for a low-cost dashboard using a familiar tool commonly implemented across organizations: Excel.
Excel 2010 seems to be the strongest candidate to be chosen as preferable tool. It's certainly true that Excel 2010 doesn't yet have the design features of some BI Front-End competitors, but the low cost and welcome acceptance from end users are big advantages to it. Naturally, there are huge commercial interests in favour of more robust solutions that generally stand by their promises, but in turn, the return on the investment (ROI) is the question.
The dashboard created along the chapter is shown in the previous figure. I highlight the fact that beyond this dashboard, information is centralized inside an OLAP cube, and the dashboard was created without any line of code! At one hand, you make IT department satisfied (because they still control data quality, data governance…) and at another hand, business has the freedom to create their own dashboards and reports not only through Excel 2010, but also through Report Builder 3.0.
All the money from the book sales will be donated to charity. And the organization selected by almost co-authors of this book is the Operation Smile. I hope you buy this book to learn new things but also to help to make the difference for these children! For those interested in doing more charity work, check out Social Work Degree.
The chapter I wrote, explains the construction of an Excel Dashboard from an IT and Business perspective in a retail sector scenario. It was not intended to explain the best way to create a dashboard for the retail sector, but to describe some tips and tricks for a low-cost dashboard using a familiar tool commonly implemented across organizations: Excel.
Excel 2010 seems to be the strongest candidate to be chosen as preferable tool. It's certainly true that Excel 2010 doesn't yet have the design features of some BI Front-End competitors, but the low cost and welcome acceptance from end users are big advantages to it. Naturally, there are huge commercial interests in favour of more robust solutions that generally stand by their promises, but in turn, the return on the investment (ROI) is the question.
The dashboard created along the chapter is shown in the previous figure. I highlight the fact that beyond this dashboard, information is centralized inside an OLAP cube, and the dashboard was created without any line of code! At one hand, you make IT department satisfied (because they still control data quality, data governance…) and at another hand, business has the freedom to create their own dashboards and reports not only through Excel 2010, but also through Report Builder 3.0.
All the money from the book sales will be donated to charity. And the organization selected by almost co-authors of this book is the Operation Smile. I hope you buy this book to learn new things but also to help to make the difference for these children! For those interested in doing more charity work, check out Social Work Degree.
I'll keep you informed about book published date!
