Entries by Kapil Kapur

What is Management Reporting

What is Management Reporting Most people I know are keen sports fans of some kind or another. They regularly track the performance of their favourite team against their expectations or even their fantasy teams. Yet it is surprising how many business owners actually neglect to do the same. Over the years, I have spoken to […]

Database design for Dummies

I was reflecting on the number of times that I have heard the phrase “Well I will provide you with the data and it can’t be that hard to build a database”. In my mind (apart from the indignant rage that this causes) this the same as expecting a plumber to turn up with your […]

,

Dynamic Charts

Introduction to Dynamic Charts Most excel users know how to create Excel charts by selecting a group of cells and clicking on one of the chart designs at the top .   In this case, the chart is easy to produce because we only have one row of data covering just 10 months. However, what […]

Database design – 6 things to think about

Fingertips Intelligence have been doing database design for over 10 years and we like to give our clients plenty of advice before we start their project. If I could summarise all that knowledge into one page then it would be – 1. A database is a business tool and has to fit your business. It […]

10 Benefits of invoice automation

Ever wondered what benefits would happen, if you automated the production of your invoices (cf invoice automation). Here are 10 possible ones:- 1. Imagine the time you’d save Have you ever worked out the time you waste on generating invoices by hand ? I had a customer who gained an extra 15 working days a […]

How to design better Excel management reporting systems

Introduction One of most common uses for Microsoft Excel is to produce effective management reporting.  So I thought I would write a blog explaining how key features of Excel that can improve the way that this information can be generated. Inputs That old saying “Garbage In – Garbage out” seems highly relevant  for excel management […]