business intelligence strategy
Building a new business intelligence strategy that really adds value
14 Mar 2019

What do you do when you’re one of the global leaders in the beauty industry and your growing data environment is getting out of control? You set up a call with DB Best and start to speak with one of our dedicated Project Managers. We began with just a single developer working with this customer but very soon it grew to include an additional 13. After 5 years, what started as a data environment analysis has grown to a full […]

Business Intelligence Solution For Marketing Automation
Building a Business Intelligence Solution for Marketing Automation
20 Dec 2018

The key to an effective marketing campaign lies in the ability to make timely adjustments based on results. When one of our customers came to us saying that it took one month to analyze campaign results, they asked us to work with them to build a new business intelligence solution for marketing automation. Our customer, a public Fortune 1000 services company, provides residential and commercial services. With nearly a century of experience, eight well-known brands, and over 7,000 company-owned and franchise […]

Power BI dashboard
Out of the Ring: Building a One-Day Power BI Dashboard that crushed Sumo Logic
25 Jul 2018

One of our customers, a major software provider in construction, agriculture, and geospatial industries, has one of the leading solutions for building design and building information modeling (BIM). Just think about the complexity of designing a building and the complexities of designing, fabricating, and installing air ducts, plumbing, electrical wiring, etc. In order to improve the software for their customers, their software product that we’ll call “BIM-APP” tracks all the user interactions and any system errors to log files. The […]

Integrating SQL Server data warehouse to improve operational efficiency
Data warehouse integration to embrace data analytics
27 Jun 2017

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 warehouse features including columnstore for greater value over an Oracle based data warehouse solution. We came up with a comprehensive solution on extracting and transforming their source data and loading it into the target database. As a result, our customer benefited from obtaining a highly standardized and easily manageable solution within a short […]

Building an Ultimate Cloud-based Business Intelligence Solution for Agriculture
05 Jun 2017

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 a fragmented system, based on Oracle database, while the reports were presented as a mix of SQL Server Reporting Services (SSRS) and Excel dashboards. We came up with a solution that allowed to consolidate all reports with Power BI dashboards. In addition, we proposed to migrate the original database to Azure Synapse Analytics (previously Azure […]

Power BI Reports
Embedding Power BI Reports in a WordPress blog
26 Dec 2016

Back in March of 2015, DB Best published a blog post on how to embed Power BI Power View interactive reports into your blogs and websites. Much has changed in Power BI since then and Microsoft has made it possible to easily embed reports into your blog articles. There are now two basic options for embedding reports. Power BI Embedded is a service on Azure for publishing Power BI visuals and uses authentication to make sure users can see the […]

Global Retailer Tunes up OLAP Performance Ten-fold
15 Dec 2016

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 and freed up 28 GB of disk storage space. Prior to these great results, there was a hard optimization process performed […]

Faster reporting and flexibility using SSIS and SQL Server
DB Best Case Study: Faster reporting and flexibility using SSIS and SQL Server to offload Excel reports from SSAS cubes
03 Nov 2016

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 contacted DB Best to develop a new and improved solution. The customer’s original system was built on two SQL Server Analysis Services systems, each containing large amounts of various aggregated data types with Excel workbooks directly accessing the two SSAS cubes. Not only did this system take a considerable amount of time to generate […]

5 essentials to learn about your data platform with DBMSys
28 Sep 2016

DBMSys is a lightweight tool designed by DB Best specifically around collecting data from multiple environments to help develop a business case for a modernization to upgrade path. The Microsoft MAP Toolkit is good for scanning systems and providing a snapshot of some system metrics, but doesn’t provide data over time to understand peak workload requirements and storage capacity needs. DBMSys turns monitoring on its head. Not only does DBMSys help with monitoring your environment for capacity needs, it provides […]

Database decisions for the Internet of Things
11 Mar 2016

The Internet of Things (IoT) is constantly expanding, and the data being transmitted through it grows immensely along with the network. This is why previous and regular methods of data management can’t cope with the growing needs.