Scenario 1: No more Excel chaos!
Excel's uncontrolled growth and complexity make it a problem. Errors pile up and people often compare apples with oranges. It's time for a centralized system.
⇒ Our suggestion: We convert your tried-and-tested Excel files into a centralized reporting system which becomes productive quickly, with fewer errors and without the risk of a greenfield restart. Everyone is already familiar with the new Excel-based system, and your team remains productive.
Users can enter data into the database. Therefore, LeanMIS is also suitable for simulation and planning, see the success story.
Scenario 2: Get off the treadmill!
A controller, manager or analyst must regularly combine and evaluate data from SAP, Microsoft Dynamics, in-house databases and web sources in order to deliver weekly reports to superiors. But local data must also be included, such as Excel or CSV files.
The Excel files are becoming increasingly complex, the cell formulas less and less manageable. Errors accumulate and the maintainability of the system is dependent on individual people. As soon as a file has more than 100,000 rows, it becomes uncomfortable, and 1 million rows is the limit.
⇒ Our suggestion: LeanMIS offers a standardized evaluation of all these data sources. Error-free, transparent, maintainable, unlimited. Routine tasks lose their horror.
Scenario 3: Corporate reporting
A company uses an enterprise resource planning (ERP) system. Independent of this, there are other central IT systems: customer relationship management (CRM), accounting software, HR tools, production data acquisition (PDA), time recording, electronic archive, intranet, Microsoft SharePoint, mail system. Added to the mix are systems from the cloud and social media.
The complexity increases further when companies are acquired. In this heterogeneous IT landscape with hundreds or thousands of users, standardized reporting is a challenge.
⇒ Our suggestion: The company needs a data warehouse (DWH): relational, cleanly modeled and, if possible, avoiding redundant data. The DWH accesses data and business processes from SAP systems via standardized interfaces (exports, BAPI, IDoc, web service).
LeanMIS delivers Excel reports from this DWH to the entire company, including externally by e-mail. As Excel always serves as the basis, it is clear what you can expect from the system: print-ready, highly formatted reports that are understood by everyone. Interactive or read-only, as required. User privileges ensure that the right reports reach the right recipients.
Scenario 4: Teaching and research
A team of scientists generates a lot of measurement data, which is stored in a variety of ways: in databases on Unix and Windows machines, in XML files, in Excel files.
Now they are looking for a standardized, flexible and simple evaluation tool for all this data. The tool should also enable further statistical processing and embedding in publications. As well as the connection of further data sources on the Internet.
⇒ Our suggestion: LeanMIS does this. R and Python can be integrated for statistics. Mathematica or web services can also be integrated.
Scenario 5: OEM
An IT manufacturer (Own Equipment Manufacturer - OEM) sells a database application for which a flexible, powerful and inexpensive reporting module is required.
The manufacturer would like to deliver predefined standard reports and enable its customers to create and maintain their own reports.
⇒ Our suggestion: LeanMIS is easy to configure and is characterized by direct Excel integration, which can be adapted precisely to specific requirements using Visual Basic (VBA and/or .NET).
LeanMIS can be fully adapted to the manufacturer's corporate identity.