Mike Allen's Blog

Doing Smarter Things With IT

Bell and Whistle V2.0 – bigger and better

I was reasonably happy with my first Bell and Whistle data set, but I felt it needed more data, a lot more. I’ve just done a course on using R for simulations, so I thought I would generate some test transactions with ‘days’ stretching over 10 years and a variety of customer and product numbers. I settled on 113 Customers and 50 Products and used a randomized section of a normal distribution to give me around 50,0000 transactions that became denser over time. That’s a complicated way of saying sales increased over time.

What’s it for? Primarily for demonstrating data visualizations in products like Excel, PowerBI and whatever takes you fancy. I’ve been using the previous version to produce some training videos https://www.youtube.com/channel/UCtvirMVp8r8j6jGbWE8SqIA

I’ve decided to distribute Bell and Whistle V2.0 as an Access Database and as a Excel workbook that uses the data in a Data Model. You’ll need Excel Pro to fully realize the work book. The Access database is just data, with the table relationships. The Excel data model has some DAX and Measures.

These file are available on Google Drive try, https://drive.google.com/open?id=0B9nJpvPnppwldm9tWU9GbV9CT2s for the Access Database and https://drive.google.com/open?id=0B9nJpvPnppwlcy1WRW9hRDZRUG8 for the Excel Workbook.

Have a play, let me know if you like it.

Comments are closed