Sales & Operations Planning / Integrated Business Planning
What you'll learn
- Create great looking Excel Dashboards from scratch and transform them into iPhone and iPad Apps without writing a single line of code.
- This course is designed specifically for non-programmers and as such students do not have to have any programming experience whatsoever. In fact you do not even have to have the intention to ever want to program. This course is not about "code cutting". It is helpful however to have at least a basic understanding of spreadsheets and we will be using MS Excel 2010 in the demonstrations, so it is a benefit to have Excel 2010 (or a later version) already loaded before you start.
Build an S&OP/IBP dashboards using only Excel
Build Dashboards & Business Apps without writing a single line of code, all you need is Excel.
In a world first we have designed a training course that helps the average Excel user create an Excel dashboard and an iPhone app without having to write a single line of code.
When we build the dashboards we only use tools that come standard with Excel – like Pivot Tables, Pivot Charts, Icons and Sparklines (and don't worry there isn't any visual basic or even a single macro in our solution).
And here's the best bit … Claris FileMaker (an Apple subsidiary) has released a free database for iOS called "FileMaker Go". It works natively (i.e. online or off-line) on iPhones and iPads.
The program you download from the resource section will automatically convert a simple spreadsheet into a sophisticated Business App that works with FileMaker Go. Therefore you will be able to distribute your own apps to as many people and iOS devices as you like.
More advanced users can even host an online version which will work with most browsers including Android. The advanced version can integrate with everything from SQL to SAP and Claris has just released Claris Connect, which can connect your app to API's via a simple workflow. These advanced (multi-user) techniques are beyond the scope of this training course however advanced users, BI specialists, data analysts, data scientists, programmers and app developers may still want to take this course to refine core skills in multidimensional modelling and analysis.
However, this training course is squarely aimed at the typical Excel user who wants a simple method for building their own Dashboards and Business Apps.
Sign up today to start creating your own Dashboards and iPhone apps without learning a single line of code.
Who this course is for:
- This course is designed for Excel users; Managers, executives, all types of business people, office workers, scientists, engineers, doctors, teachers, students ... basically anyone who "thinks for a living" (i.e. Knowledge Workers) and knows how to use Excel.
- Advanced users and developers may like to take this course to give them a foundational grounding on Dashboards and Business Intelligence before they embark on the technical aspects of deploying a larger scale Information Dashboard.
Luke has an Honours degree in Engineering (winner of the University Prize), a Grad Dip in Psychology and Advanced Certificates in relational and multidimensional databases.
He works with companies of all sizes - ranging from small family businesses to Fortune 500 companies.
He regularly presents sessions across the globe on business intelligence and more recently on artificial intelligence.