Sales & Operations Planning / Integrated Business Planning

Sales & Operations Planning / Integrated Business Planning, available at $89.99, has an average rating of 4.05, with 36 lectures, 1 quizzes, based on 75 reviews, and has 461 subscribers.

You will learn about 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 ideal for individuals who are 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. or 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. It is particularly useful 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. or 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.

Enroll now: Sales & Operations Planning / Integrated Business Planning

Summary

Title: Sales & Operations Planning / Integrated Business Planning

Price: $89.99

Average Rating: 4.05

Number of Lectures: 36

Number of Quizzes: 1

Number of Published Lectures: 36

Number of Published Quizzes: 1

Number of Curriculum Items: 37

Number of Published Curriculum Objects: 37

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

Create great looking Excel Dashboards from scratch and transform them into iPhone and iPad Apps without writing a single line of code.

Who Should Attend

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.

Target Audiences

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.

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.

Course Curriculum

Chapter 1: A FREE preview of the entire course curriculum, kept short for busy people.

Lecture 1: DIY Dashboards for Excel and iPhones: An overview of the whole course

Chapter 2: Building your first Excel Dashboard

Lecture 1: Your First Excel Dashboard: Data

Lecture 2: Your First Pivot Table

Lecture 3: Your First Pivot Chart

Lecture 4: Your First Excel Dashboard: Slicers

Lecture 5: Your First Excel Dashboard: Formatting

Lecture 6: Your First Excel Dashboard in Action

Chapter 3: The One Page Report – A more sophisticated Excel Dashboard

Lecture 1: The One Page Report: Creating multiple pivot tables

Lecture 2: The One Page Report: Calculating Dimensions and Elements

Lecture 3: The One Page Report: The Time Dimension

Lecture 4: The One Page Report: Summary Calculations and the GetPivotData function

Lecture 5: The One Page Report: Sparklines

Lecture 6: The One Page Report: Calculated KPIs (Key Performance Indicators)

Lecture 7: The One Page Report: Chart and Slicers

Lecture 8: The One Page Report: Formatting

Lecture 9: The One Page Report: Testing and error capture

Lecture 10: The One Page Report in Action

Chapter 4: Supply and demand dashboard, great for Sales & Operations Planning

Lecture 1: Unlocked dashboard file attached

Lecture 2: Overview of the supply and demand dashboard

Lecture 3: Raw data for supply and demand / S&OP dashoard

Lecture 4: Start building the dashboard – the main pivot table.

Lecture 5: Create multidimensional calculations (AKA GetPivotData calcs)

Lecture 6: The S&OP Chart

Lecture 7: Dashboard slicers and formatting

Chapter 5: One Business App

Lecture 1: One Business App: Overview & demo of this section of the training course.

Lecture 2: One Business App: Setting up a Key Performance Indicator Table

Lecture 3: One Business App: Adding Dimensions and Elements to the KPI Table

Lecture 4: One Business App: Creating KPI Aggregations

Lecture 5: One Business App: Creating a KPI Hierarchy

Lecture 6: One Business App: Navigation

Lecture 7: One Business App: Multi-level Navigation

Lecture 8: One Business App: Importing final KPIs into the app.

Lecture 9: One Business App: Conclusion

Chapter 6: Deep Dive

Lecture 1: The Business Intelligence Roadmap

Lecture 2: Using FileMaker as a Business Intelligence Tool

Lecture 3: Working with Tableau and FileMaker

Instructors

Luke Rochester
Management Consultant

Rating Distribution

1 stars: 1 votes
2 stars: 3 votes
3 stars: 3 votes
4 stars: 23 votes
5 stars: 45 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu