KPI AND MANUAL DATA REPORTING
Capture data and information from the front-line using Power BI
You can't manage what you can't measure!
There are many scenarios where you need to fast collect data and information from the organization for planning or reporting purposes.
The data you have in your ERP system, and other systems, are simply not enough. You need to enrich your data in your Power BI models and warehouse with manually entered data from end-users.
Aimplan can play an important role in enabling data entry within Power BI. And you always have access to your data from Power BI or other tools.
Drive strategy with KPIs and OKR
Measure what matters!
You must be able to measure also the data you can't find in your existing ERP system and other data sources. Enable your organization to define objectives and goals and measure these goals. Even if the measures are not available in your existing data sources.
Continuously capture important key performance indicators and result data to measure progress and goal fulfillment. And have this data live at your fingertips direct in Power BI reports, dashboards and apps.
Production reporting without spreadsheets
Many companies run much of their day-to-day production reporting using spreadsheets. Collecting data from different departments, teams and machines are a cumbersome manual process when users in the factory or production plant enter data into spreadsheets.
The data are then often copied-and-pasted to some reporting database for reporting. With Aimplan in Power BI you instead get a fully automated solution where end-users direct in Power BI can enter their data. And they where everyone immediately can see the result. You have all your production data in one central database that is always up-to-date.
Features highlights
Highly configurable Power BI data entry grid
The key to a great user experience is the Aimplan Power BI custom visuals making it possible to truly configure data entry templates. The entry forms are feature-rich with live calculation formulas, supporting copy-and-paste, export to excel, print and much more.
Security and data access
Aimplan implements single sign-on with M365/Office365 and Azure AD to grant user access. Combine the data access rules maintained in Aimplan with the data access functionallity in Power BI. I.e. manage in Aimplan for example which user can access and plan which project, product, market or cost center.
Audit trail of updates
All updates to planning models and forecast data is logged and under control. You can see who has changed what data, and at what point in time. This also includes events such as user logging in, out etc.
Update the warehouse with manual data and input
Have you built an awsome data warehouse but you miss some key important data from end-users? It can be 'measure-data' such as quantities and volumes but also 'dimension-data' such as attributes or dimensional structures. Or you maybe need to delegate to users to perform manual cleansing of data to correct errors.
With Aimplan you can enable and grant access to end-users to maintain and update such data direct within Power BI.
Master data management
Most of your master data is probably managed and maintained within your ERP system. But there are normally key-important master data that cannot be updated and maintained directly in your systems. For example 'translation-tables' where article groups, or accounts, or customer segments etc are 'mapped' to some other structure or dimension.
You want to have this data in a central database and you want to have control of this data. Instead of using spreadsheets, you can with Aimplan and assign users to manage and maintain this kind of data directly in Power BI and their browser.
Features highlights
Embed in MS Teams and Sharepoint
Power BI, and therefore also Aimplan can easily be integrated into Sharepoint and Microsoft Teams. This provides a great user experience combining reporting and planning direct from within these collaboration tools.
Easy to get started
Aimplan is a Saas service in the cloud. No servers, no installations and you reuse your existing Power BI Datasets. You can get going within hours, not weeks or month.
Full access to your data
Independent of the deployment model you always have access to your data stored by Aimplan. We never lock your data in. You have full access and can easily get access from different tools and other systems in a secure way.