Search

generic image used

Analysis Services for Block Imaging International

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.

See Block Imaging International Profile

See More:

All Things Intelligence

What Clients are Saying

  • Endless Mountain Solutions has been an integral part in the success of our business.  They have been a major part of the development and maintenance of our website as well as helped create tools to increase our bottom line. We can rely on the EMS team because they are dependable, honest, and looking out for the best interest of our business.  We would not be in the situation we are today without the assistance of EMS.  I highly recommend their team of professionals.

    Adam Rubert - Compliance Associate at PT Compliance Group

    See PT Compliance Group Profile

  • I’ve been impressed with how you balance what’s available with what’s appropriate for our business situation.  We’ve had experience with people before who just want to install stuff for the sake of installing it, not realizing that it really didn’t have applicability to our situation and, us not being tech savvy enough to know the difference, we ended up with stuff we didn’t need.  I feel comfortable that you understand our business well enough to make good tech decisions on our behalf.  

    Jen Karelus - Chief Operations Officer at Miller Spraying

    See Miller Spraying Profile

See more Client Comments