ML in construction blog post cover image
Eliminate safety breaches in construction with ML algorithms
11 Feb 2020

In this blog post, we describe how we developed a solution to prevent the most common safety breaches in construction. The solution combines machine learning algorithms and computer vision technologies to detect workers not wearing helmets analyzing video materials. Our algorithms reached 98% accuracy, and we’re proud that the solution actively used by our customers.

anomaly detection
How we improved customer analytics with machine learning algorithms
08 Jan 2020

Using multiple data sources often causes data to be out of sync. This results in data mess or conflicts and significantly affects your analytic reports. To make informed decisions, you need a proven automated solution that allows for discovering data anomalies. Especially when you operate with tons of data. The DB Best team utilized machine learning to build the anomaly detection tool for one of our customers. Our sophisticated solution improves the quality of data and helps take deliberate business decisions. In this blog post, we will show you how to make use of time series-based algorithms and the sequence of the steps for training a neural network.

migration from SAS to Hadoop
Migrating an On-Premises SAS System to Microsoft Azure HDInsight
22 Oct 2019

A global retailer in the beauty industry contacted DB Best looking for the right modernization path for their SAS based BI solution. They were hitting the boundaries of SAS with their large data sets and wanted to look at alternative solutions using big data technologies like Apache Hadoop with Azure HDInsight to modernize the way they process their data. In addition, the wanted to control their SAS license costs. In this blog post, we’ll walk through how we helped our […]

Power BI Premium limit
Reaching the limit with Power BI Premium resources
10 Jul 2019

One of our enterprise-level customers reached the Power BI capacity limit on dedicated cloud computing and storage resources. They already owned the Power BI Premium licensing package and didn’t want to spend more money to buy additional resources.
Reaching the resource capacity limit in Power BI may lead to serious consequences. Data models using this service will fail when refreshing through the gateway. The business will not get new data, causing all teams to fall behind on analysis of information.
See how you can address this issue.

Power BI Set Filters
Power BI — Set Visual, Page, and Report Level Filters — Episode 13
28 Jun 2019

Welcome to the last episode of my Power BI Best Practices Series. In today’s episode, I will show you how to filter your report based on visual level, report level, or page level filters.
Visual level filters allow for filtering only the selected visual. Likewise, page level filters allow for filtering the entire page. And report level filters allow for filtering all tabs together in your entire report.
Read more on our blog and be sure to watch the related video.

Power BI — Edit Interactions — Episode 12
21 Jun 2019

Welcome to Episode 12 of my Power BI Best Practices Series. In today’s episode, I will show you how and why you should edit your interactions in your visuals. Editing interactions allows for you to apply the filter directly on a visual. Also, you can change the way the filter interacts with different visuals on your page.
Please note that you can not edit interactions if the report was shared with you. Also, by default, drilling one visualization has no impact on the other visualizations on the report page.
Find more details from this blog post.

Power BI Cut Unnecessary Visuals
Power BI — Cut Unnecessary Visuals — Episode 11
14 Jun 2019

Welcome to Episode 11 of my Power BI Best Practices Series. In today’s episode, I will show you how and why you should cut unnecessary visuals in your dashboard to allow for better user experience.
Clean reports have a better look and feel. Moreover, they make it easier for the user to understand the information and navigate through the dashboard.
Read the blog post to learn how you can determine, which of the visuals you should remove.

Report Support Tab
Power BI — Include a Report Support Tab — Episode 10
07 Jun 2019

Welcome to Episode 10 of my Power BI Best Practices Series. In today’s episode, I will show you how to include a report support tab in your Power BI report. This tab helps your users see where the data comes from. Also, here you can include your contact information, so the users of your report will know how to reach you if they have questions.
A report support tab is not mandatory. However, this is one of the developers’ best practices and the way to show some respect to the other users working with your report.

Power BI Themes
Power BI — Themes Are Your Best Friend — Episode 9
31 May 2019

Welcome to Episode 9 of my Power BI Best Practices Series. In today’s episode, I will show you how you can create themes in your Power BI report and allow for more branding experience.
Power BI themes allow for brighter visualizations, as well as customizing and standardizing your reports. You can select one of the predefined themes, import an existing theme, pick up a theme from the gallery or even create a new theme.

Create Drillthrough Pages
Power BI — Create Drillthrough Pages with Detail — Episode 8
24 May 2019

Welcome to Episode 8 of my Power BI Best Practices Series. In today’s episode, I will show you how you can create drillthrough pages in your report.
Drillthrough pages allow for your users to navigate to different pages within your report to expore the details of the visuals that they choose. For example, you can create a drillthrough filter in Power BI based on the specific entity.