Luke's Excel Dashboard with a Forecast

This is a dashboard built in Excel without any plug-ins, macros or visual basic. It's straight off-the-shelf Excel and an older version at that (Excel 2010). In this one I have included a forecast. If you want to learn how to build these dashboards yourself please go to www.OneBusinessApp.com.

In my meeting yesterday I showed the dashboard below but the customer was curious about forecasts.  So I redid the video with a forecast included.  Please feel free to leave questions and comments below.

Luke's Excel Dashboard

This is a dashboard built in Excel without any plug-ins, macros or visual basic. It's straight off-the-shelf Excel and an older version at that (Excel 2010). If you want to learn how to build these dashboards yourself please go to www.OneBusinessApp.com.

In the USA heading to a meeting with an Excel guru.

Thought it might be an idea to jump straight to the cool stuff about my excel dashboards.

What do you think?  Would you like to see more videos like this?

Leave your comments below.

 

Demand for business apps has already out grown supply

It's not hard to see find examples of the growth in demand for business apps.  Just a glance at people in the subway ought to do it for you.  But if you would like to see evidence you'll find it here.

The use case for business apps is entirely different to traditional business software.  It is not about data entry - at all.  It's about a few brief taps revealing insights that previously took days of emails and meetings to dredge up.

If you start to get your head around business apps now then you're in the early adopter stage. But not for long.

One Business App is EASY to set-up

We can create One Business App together in 3 simple steps:

Step 1: Create an Excel Dashboard based on your raw data
 - here's me building an excel dashboard in under a minute

Step 2: Use the dashboard to analyse the data and create Key Performance Indicators (KPI's)
 - here's an example

Step 3: Upload the KPI's into One Business App
 - the video above shows One Business App in action

One Business App Online

One Business App can be run from multiple devices: phones, tablets, laptops and desktops.  It can also be run in online mode (via a web browser) or offline mode (in a local app), it can even be run in offline mode and sync with the online version either manually or automatically.

Read more

December 2015 Webinar - SOLD OUT

The 15th December 2015 online seminar sponsored by FileMaker Inc (an Apple Subsidiary) was sold out within 48 hours of opening the registrations.  Sorry if you missed out but to soften the blow I pre-recorded my presentation and made it available here.

Of course we will run more seminars so if you want early notice next time simply contact us expressing your interest in attending the seminar.

80% will fail - without your help!

80% of companies fail when they try to implement a company wide dashboard.  The reason is that they focus too much on the technology and not enough on the people and the business itself.

If you like technology but you like people and business processes just as much, then you are what we call a Knowledge Worker … in other words you “think for a living”.

We’ve got good news and bad news.

First the bad news: The information revolution is coming to an end.  We used to think “information is power” well now it’s a given.  Today “knowledge is power” and we don’t need to tell you that information and knowledge are two completely different things.  Traditional office work is about to be automated out of existence.  One Agile Worker can do the work of ten Office Workers ... with the help of a competent Knowledge Worker!

Now here’s the good news: The information revolution is being replaced by a knowledge revolution.  However as the 80% failure rate shows … this time it won’t only be about the technology.  In fact in would be more correct to say there is a Knowledge Worker Revolution already taking place.  And this time around it is more about the people.  People that can augment technology to automatically provide insightful decision support to the right person at the right time … now that’s powerful.

One Business App has been designed, from the ground up, for non-programmers.  We wanted to empower Knowledge Workers.  People like you who like people, processes and systems.  To get you started we’ve developed a Knowledge Worker Training Program that shows you how to convert a simple spreadsheet into an insightful Dashboard and then a sophisticated business app.  You can complete the whole training program in just a few hours.  All you need are at least basic Excel skills (and a copy of Excel 2010 or above is recommended).

One Business App website launched

What a year!  Chatting to the CEO of Apple Sweden one minute, the next minute presenting to a capacity crowd in Las Vegas for FileMaker (an Apple subsidiary).

It looks like people are very curious about a single app that can store all of your critical business information.  Since the sell-out session in Vegas (July 2015) I have created this website and two on-line training programs (I have well over 100 students already - amazing).

More importantly I have brought a beautiful little girl into this world (OK my wife had a bit to do with it as well). After a little break to spend some quality time with my family I am now heading back into the office.

I have been consulting for almost 20 years so I have no shortage of reference sites but these are all related to management consulting.  I'm now looking for a new kind of reference site.  One that can help me demonstrate to the world that it is indeed possible to manage your business, or at least an important part of it, with just one business app.

If you are interested in becoming a reference site, or working with me to create one, then please contact me.

One Business App announced

In July 2015 we announced the pending release of One Business App at the FileMaker developer conference in Vegas.

FileMaker is a wholly owned subsidiary of Apple and at the time of writing their iOS app "FiileMaker Go" has the most number of downloads of any iOS database.  And it is totally FREE to download.

One Business App is an example of the kind of solutions you can build with FileMaker.