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

  • I really enjoyed working with Jeff and his crew at Endless Mountains Solutions. They developed an application for us that was user friendly, had some of the extra bells and whistles that we wanted and has proved to work great. They provided excellent service from the initial planning meetings right through training and answering follow up questions. You would want to work with these guys.

    Nathan Dewing - Bradford County Conservation District

  • 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