WHY REINVENT THE WHEEL?

Business Intelligence tools unlock the data stored in complex ERP databases and provide visual dashboards and reports that drive you towards meeting the targets you have set for your business.

Perennial Software can work with you to develop a BI Performance Measurement and Reporting System that will enable you to:

• Extract the data locked away in your ERP databases, your CRM databases, any other sources of data that you use in your business;
• Load your data into an industry-standard data warehouse, either Microsoft SQL Server (on-premise) or Microsoft Azure SQL (in the Cloud);
• Cleanse and transform your data into a into a single source of truth, suitable for reporting using whatever reporting tools you prefer;
• Load the transformed data into Microsoft Power BI with an optimized data model;
• Create the dashboards and reports that make it easy to understand your data, and to gain insights into areas for improvement.

Perennial BI - Pre-Built Dashboards and Reports for Distributors of Durable Products - a great way to "quick-start" your Business Intelligence Experience

Using Microsoft Power BI, Perennial Software has already developed a substantial range of customizable Dashboards and Reports which we have called Perennial BI for Product Distributors. So rather than starting from scratch, use what we have already created, and save many hours of time and money.

ETL - Extract, Transform and Load - ETL

Before you can use the Dashboards and Reports provided in Perennial BI, you have to "Get Data" from your ERP databases, and any other data sources that you use and wish to report on, transform it into a form data is suitable for Busines Intelligence reporting, and load the transformed data into the Perennial BI data model we have created in Power BI.

To assist you in this ETL process, Perennial BI also includes the SQL procedures and scripts that we used to load our sample data from a non-SQL database into the SQL data warehouse - which can be the SQL Server database for on-premise or the Azure SQL database for cloud.
And we also include the SQL Server Integration Services (SSIS) package that we used to map the non-SQL database tables and fields to the SQL data warehouse.
All of which can be customized and automated.

Self-Service BI

Perennial BI includes Data Models optimized for Power BI that make it easy for your Business Users to create new dashboards and reports that they might need. The visualization tools in Power BI make it quite easy for Business Users experienced in other software reporting tools, such as Microsoft Excel, to develop their own dashboards and reports. In fact, one of the key reasons companies are implementing Power BI is to transform the reports they have created in Excel to Power BI.

You can preview all the Dashboards and Reports that we have created in Perennial BI from the links below.