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...
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
Learn more
Blog posts
Global Retailer Tunes up OLAP Performance Ten-fold
Building an Ultimate Cloud-based Business Intelligence Solution for Agriculture
5 June 2017 Andrey 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 ...
Request a quote