Our services

Organizations often use SQL Server Analysis Services to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. We can integrate this online analytical and data mining tool to discover your data at the most granular level.

DB Best has helped hundreds of customers deliver Business Intelligence solutions across their entire organization. With our solutions, based on Microsoft SQL Server Analysis Services, you can get valuable data insights to keep up with your business growth and empower executives, managers, and other corporate end users across your organization to make faster, more informed business decisions.

What We Do

Having a great experience in crafting BI systems for various companies worldwide, we can discover the very best BI solution that fits your requirements. Particularly, we can:

  • Provide technical expertise in mapping multiple data sources to Microsoft SQL Server Analysis Services
  • Ensure credible and consistent data without the need to change data sources
  • Accelerate and improve decision-making solutions to increase operational efficiency
  • Deliver a familiar user experience while gaining a competitive advantage over business rivals
  • Help you with a Proof of Value project to identify market trends

Getting started with SQL Server Analysis Services

We’ve got a number of basic offerings to get started with Microsoft SQL Server Analysis Services.

Global Retailer Tunes up OLAP Performance Ten-fold

When a company grows, it’s no surprise that their database stored data grows as well. This is the case for all companies, and our customer, a global retailer in the beauty industry, was no exception. While working on this project, we managed to increase the average speed of query execution by 30x, saved up to 190 GB of memory, freed up 28 GB of disk storage space, and improved the overall performance of the OLAP Cube by 3x. Prior to these great results, there was a hard optimization process performed on the customer’s system based on the OLAP cubes technology.

We optimized the cubes’ multidimensional structures, in addition to building some new OLAP cubes as well. 

We removed the unused dimensions’ hierarchies, deleted unused links in tables and databases, and optimized the processing logic of the data calculation system inside the OLAP cubes. As a result, the calculation time for the cubes decreased Three-fold. We also made some qualitative improvements to increase the performance of the complex ETL processes that resulted in working about 2.5 times faster than before. We implemented MDX code audits. Upon reviewing the code, we optimized the MDX queries and increased the speed of their execution by up to 30 times.

We managed to reach these fabulous results during a complex Big Data Management Project. Watch the following video to see how we did it!

 

Contact us today to help you with SQL Server Analysis Services
Contact us

Learn more

Blog posts

Global Retailer Tunes up OLAP Performance Ten-fold
15 December 2016 Bill Ramos

When a company grows, it's no surprise that their database stored data grows as well. This is the case for all companies, and our customer, a global retailer in the beauty industry, wa...

Building an Ultimate Cloud-based Business Intelligence Solution for Agriculture
5 June 2017 Andrei Ivanov

One of the largest North American agricultural enterprises has been envisioning and designing a new cloud-based Business Intelligence and Data Warehousing architecture. They were using...

DB Best Case Study: Faster reporting and flexibility using SSIS and SQL Server to offload Excel reports from SSAS cubes
3 November 2016 Bill Ramos

DB Best recently completed a complex development project for one of the largest banks in the Middle East. Faced with non-customizable and slow-to-generate reporting, the customer conta...

Data warehouse integration to embrace data analytics
27 June 2017 Stanislav Andrenko

Our customer has been supporting Oracle based online transaction processing (OLTP) system. They decided to take advantage of the modern data analysis capabilities of SQL Server's data ...

Reference data sheet

BI & AA Offering for Microsoft
8 November 2016 Bill Ramos

In combination with Microsoft SQL Server, Office, SharePoint and Cortana Analytics suite, DB Best has helped hundreds of customers deliver Business Intelligence solutions across their ...

Business Intelligence and Advanced Analytics Datasheet
3 September 2019 Bill Ramos

Read our Business Intelligence and Advanced Analytics datasheet to learn more about the expertise we're ready to share with you. Over the years, DB Best helped hundreds of customers de...

Let us help you with your project!
Contact us for a FREE quote today.
Request a quote