Inventory management your business
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.
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.
Check out the video below to see me build an Excel Dashboard in under a minute.
In this video I show you how to build a Dashboard in Excel in under a minute. If you have any questions about Dashboards, especially how to build Dashboards in Excel, please do not hesitate to write them in the comments below.
In a previous post I show how you can build a really cool dashboard in Excel in under a minute.
If you have the time (and patience) to put a bit more effort in you can end up with something like this ...
The One Page Report is an example of an Excel Dashboard that we can help you learn how to build yourself.
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.
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 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 moreThe 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% 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).
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.
Today was an exciting day. We released an online training course to help people turn a simple spreadsheet into an Excel Dashboard and an iPhone app without writing a single line of code. You can check it out with a free preview and get over 20% off if you are one of the first 100 people to enrol (offer ends 31st August 2015).
I'm in the final stages of completing an online on-demand course for non-programmers who want to create iPhone dashboard apps. It is due for release any day now. I'll keep you posted.
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.