Move ahead of ERP !
This course explains on the concepts of Business Warehouse in a simple way. An elaborate discussion on the electronic-board is done on the practical aspects happening in corporate. Strategy Management concepts and applications are made simple for students to grasp.
The concepts and business flows have been explained using SAP as a reference and can be applied to any such similar systems and solutions. Simple flow in MS Excel with dashboards is shown at the end of the course.
This course is for MBA / Management students having ERP as an elective in their academic course curriculum.
Self-Assessments have been given as part of the course for students to practice on their own to apply their understandings from this course.
This section explains concepts, fundamentals, loading process and reporting aspects
Explains on the data loading process and reporting with different features like drag and drop, exceptional reporting etc.
Assessment of understanding on the section - Business warehouse
Provides explanation on the planning aspects as normally adopted by corporate in their annual planning exercise and on integrated planning & its utility.
Explains on the planning options with system and showcases a simple demo model on sales.
Assessment of understanding on 'Planning'
Explains how processes flow in an organization and how board & senior management drive the processes.
Assessment of understanding on planning
Explains on the concepts and elements of strategy management and derivation of scores & hence status indicators.
Assessment of understanding on strategy management
Recommendations points from the project team to the management in the chosen scenario
This section is a guidance towards self-practicing session. Data from MS Access is taken to Excel. Analytical reports and dashboards creation steps are shown. Creation of KPIs Dashboard with traffic-signal as status indicators are shown in example.
Self-Practice by students:
Design a simple planning scenario on Industry of your choice. You can use the Design & Application on the understanding from this course.
Choose a simple data structure for planning for the design you have now. Choose a simple solution of your choice to which you have access (or) a trial version of some solution that you know (or) MS Excel with Access as shown under this lecture. You can use ETL functionality If the system you choose has that feature. Identify some of the Automated Function you could use for Planning as part of the solution you have Identified. Perform Planning for different scenarios and compare with your Actual Data and do analysis. Students to try and perform outside this course as a practice.
Teaching is my passion and I love teaching to bring in value addition to students based on expertise gained in different dimensions over 25 years.
I have gained expertise in consulting Senior Management, Business Analytics, Corporate Performance Management, ERP, with over 25 years of consulting experience through projects participation across geographies - India, Europe, Scandinavian countries,Middle East, Australia and other APAC countries.