Tutorial: Sales analysis part 3 - create a dashboard

This is the fifth part of our series looking at new tools for working with accounting data in Excel 2010 and 2013 and the third of three articles looking at the analysis of transaction data. This time we will look at some of the features available to help us turn our data from a list of invoices into an interactive dashboard, including the incorporation of KPIs. 

As in the previous article, we will use the Invoices data from Microsoft’s sample database: Northwind. [Our thanks to Microsoft for permission to use it in this tutorial. If you are not able to locate a copy of the 434kb zipped you can to download a copy herethen extract Northwind.mdb].

Register with AccountingWEB for free and log in to read the full tutorial, which covers:

  • DAX
  • KPI
  • Dashboard 

Further reading and tutorials

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.