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’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

  • In a world of ever increasing options for service vendors, my ongoing relationship with Endless Mountain Solutions shouts to their consistent high standards, top quality deliverables, transparent communication, very fair rates, and amazing customer service and support. In other vendor relationships (supplier, etc) we have grown to be wary. We have seen trusted relationships turn into price gouging when we fail to shop-around.

    I have been impressed with Endless Mountain Solutions proactive approach that lets us know the relative monetary value they provide. Rare is the service provider that truly looks out for your business as much as their own. I've been around long enough to see and feel the difference that type of leadership mentality makes. If we had to find another "good" web-development/tech support company, there would be a massive hole left where we have come to rely on Endless Mountain Solutions. I could not possibly recommend a company more highly than Endless Mountain Solutions.

    Mat Dewing, PT, ATC - Owner and President of ProCare Physical Therapy

    See ProCare Physical Therapy Profile

See more Client Comments