generic image used
Block Imaging International manages a lot of information, from the clients they work with to the equipment they move, there is an abundance of electronic data. With the migration of the business software onto SAP, the data became very structured and even more valuable. However, the dilemma was how to tap into this data source and be able to extract the business intelligence that could help Block Imaging International make strategic moves for the future.
SQL Server Analysis Services (SSAS) provides the ability to take your existing data structure and re-purpose it into a reporting data structure. By analyzing the needs of the business and determining what information was critical to operate successfully, Endless Mountain Solutions was able to prepare an Online Analytical Processing (OLAP) cube for advanced reporting. This technology allowed us to pre-define the business relationships in the data and to have it precompiled on a nightly basis.
With the backend OLAP cube available, the information stored in the cube can be exposed and manipulated through Microsoft Excel. This allowed everyone in the company to harness the wealth of data stored in the backend SAP system directly from the platform they were familiar with. In addition, by utilizing the slicer technology available in Excel 2010 and newer, we were able to set up key dashboards for different views into the company. A couple of clicks on the slicer filters provide the user insight into everything from sales process to inventory management.
We are proud to have worked with Block Imaging International in defining their Business Intelligence platform.