Skip to main content
LeanMIS Reporting und BI logo

Advantages for Users

  • Can work with Excel as usual and continue to use proven formatting, print formats, cell formulas and macros
  • Consistent, familiar user interface
  • Reliable data is available in real time or automatically via email
  • High quality, graphically rich, interactive reports
  • Automatic, print-ready management journals
  • Requests for customization or new reports can be fulfilled quickly
  • Interactive explanations of individual reports
  • Self-service: If interested, everyone can participate directly in the development of the system by creating Excel templates, adding help texts or recording macros. This reduces frictional losses between the specialist department and IT, and increases acceptance of the system which quickly reaches a high level of maturity.
LeanMIS Arbeitsplatz

Advantages for Managers

  • Trustworthy basis for decision-making
  • Data security and compliance: LeanMIS works without the cloud
  • Efficient collaboration between the specialist department and IT thanks to a clear user interface: Microsoft Excel
  • Reuse of investments already made in PCs, the database, Excel and staff training


LeanMIS offers low, controllable costs because

  •         existing Excel solutions, which have cost money, can be recycled in LeanMIS
  •         no new hardware or software needs to be purchased
  •         no one needs to be trained
  •         dependence on external service providers is reduced to a minimum
  •         power users with the necessary IT skills (SQL, Excel) are easy to find
  •         updates to the database and Excel are also free updates to LeanMIS

Advantages for Power Users

Power users create reports for users and mediate between the business and IT departments.

  • Tried and tested Excel files can be integrated
  • Transparency: data origin is documented in the report
  • Macro recorder helps with customization
  • Simplicity: more flexibility and fewer sources of error
  • Proven SELECT statements already used by IT can serve as the basis for new reports
  • Knowledge of SQL and Excel can be used directly: good for professional development (keywords "MS Office Professional", "Data Scientist")
  • Work can be divided among several specialists depending on their qualifications (cell formulas, SQL, VBA, graphics)
  • Long-running and regular reports can be generated in batch at night and sent by e-mail or printed
  • Unique selling point: reports can be derived from each other, which facilitates the maintenance of large systems and increases the quality of the reports.
LeanRE EDV

Advantages for IT

  • IT is relieved of the burden of report design, as this is done by the specialist department. No more reporting backlog!
  • Existing IT landscape does not need to be adapted - LeanMIS adapts. No need to upgrade hardware or software
  • Excel and the database are familiar: No uncertainty about the reliability and compatibility of new software modules
  • LeanMIS increases the complexity of the entire IT landscape only marginally
  • Deployment is very simple. Client installations are not necessary. LeanMIS synchronizes against a central repository at startup
  • No Windows registration required
  • Highest security requirements and centralization can be achieved using .NET
  • LeanMIS scales easily and copes with rapidly increasing user numbers and data volumes, as there are no additional bottlenecks on the server side