Designing MIS

Accounting Standards - Ind As

Designing MIS

“What gets measured, gets managed”– Peter Drucker

Introduction and Objective: 
But “what to measure”, “what about linkages of ‘measure’ to strategic objectives and value creation”, and “how to present it effectively” are the key differentiators of a good “performance dashboard”.

Following the performance dashboard through with “actionable” gets the desired performance delivered.

This course is designed for managers to:
• Understand the broad strategy of their organization,
• Drivers of value creation,
• Identifying relevant key performance indicators;
• To enable them to evolve a framework for a performance dashboard /mis for their organization, and
• A “follow through mechanism” to track the desired performance.
• Creation and presentation of dashboard through excel, the most popular desktop software for corporate.

Course Content

  1. Strategy Frameworks & Models
    1. Linked to maximizing shareholder’s value
    2. Newly evolving concept of double bottom line , triple bottom line
  2. Understanding / Developing corporate strategy
  3. Prerequisites for MIS & Dashboard
  4. Build Strategy Map
  5. Strategy to Action
  6. Critical Metrices and Key Performance Indicators (KPI)
    1. Identifying what matters the most
    2. Lead and Lag indicators
    3. Balanced Scorecard
  7. Develop Implementation Plan
  8. Roll out and Strategic Reviews
  9. Dashboard Design Principles
  10. Designing the Performance Dashboard in Excel
    • Pivot Tables
    • Sparklines, Slicers & Timelines
    • Linking & Hyperlinking
    • Custom Formatting
    • Conditional Formatting
    • Text to Column Wizard, Export and Import of Data
    • Additional Dashboard Components
    • Charts
    • Interactive Interface
    • PPT Update through Excel
    • Ten Questions to Ask Before Distributing Your Dashboard

While it will have real life examples of best of Indian/global businesses across few sectors, this will be an interactive workshop, where course participants get to discuss and evolve performance dashboard for their organizations.

  • Business Owners
  • Middle/senior functional managers (Operations, Marketing, Finance, HR)

Timings: 9:30 am – 5:30 pm , Registration begins at 9:00 am

  • Fees: Rs. 8,650/- +18 % GST per person.
  • Please write to Call -022 66976892/74
  • Provide Below Details for Registration :
    • Name of the participants:
    • Company Name and Address(For Invoicing):
    • Contact details of Participants (Email ID & Number):
    • GSTN Number:
  • Cheque favouring Princeton Academy Mumbai II Pvt. Ltd. payable at Mumbai.
  • Fees includes lunch, tea, course material etc.


Jul 22 2017


09:30 AM - 05:30 PM


Chennai - Courtyard by Marriott


Chennai - Courtyard by Marriott
Hotel Courtyard Marriott, Annasalai, Teynampet, Chennai- 600018
Princeton Academy


Princeton Academy
022 67256200