Developing a worldwide lost and found platform
06 Jun 2019

PerdidoOnline, a Puerto Rico based startup came up with an idea to help the unfortunate among us who lose our belongings wherever we go. Our client wanted to develop a locator and tracking solution t that will substitute the lost and found offices all over the world and save the users from worrying about losing their property. Read more to learn how DB Best turned this idea into reality.

mapping Oracle data types
Use Caution When Mapping Oracle Data Types for Procedures and Function Parameters in SSMA
05 Jun 2019

When converting Oracle database code to Microsoft SQL Server, I often face the problem of correctly mapping Oracle data types to SQL Server data types. I regularly use SQL Server Migration Assistant (SSMA) to automate Oracle database code conversion to SQL Server. However, SSMA’s default data type mapping for Oracle procedure and function parameters uses the maximum possible size for each specific data type to prevent data loss. This approach causes unintended consequences with application code.

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.

The DB Best Quality Assurance Strategy
28 May 2019

Software development is a complex process that consists of multiple stages. Progressing through these stages transforms the software from concept and a basic visualization to the actual product with a state-of-the-art interface and competitive functionality. At DB Best we utilize 7 application development stages described on our dedicated landing page. The purpose of this post is to stress the importance of the testing stage as an essential element for product quality. So here we will share the fundamentals of our quality assurance […]

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.

create or alter sql server
Using Create or Alter Statement in Microsoft SQL Server
23 May 2019

Managing customer’s SQL Server applications, we discovered a significant performance decrease related to query execution time. We figured out that the reason for that was the execution of a script, which checks the existence of database objects before updating them. Initially, the developers created this script to emulate the behavior of the CREATE OR REPLACE statement from many other database platforms.
We solved the performance issue by replacing the original script with a new code snippet.

Amazon QuickSight basic steps
Amazon QuickSight Introduction — Part 2
20 May 2019

In our second Amazon QuickSight introduction blog post we will go through the basic steps in building a dashboard. These steps include importing a CSV data set, creating calculated fields and data analysis. The data being analyzed is in regards to non–local employee travel which is a public access data set and the source of the data is data.gov. We utilized the data set of employee travel data (non-local) of Montgomery County of Maryland. This data set gives insights into […]

Power BI — Align Your Visuals
Power BI — Align Your Visuals — Episode 7
17 May 2019

Welcome to Episode 7 of my Power BI Best Practices Series. In today’s episode, I will show you how to align your visuals to make users happy with the content they see.

create a waterfall chart
Create a waterfall chart when the data differs by several orders of magnitude
16 May 2019

With a starting value of $288,222,000.21 USD and a final total of $285,769,892.75 USD, the middle values used to calculate the total in the initial dataset contained extremely large variances in values. The scale and degree of variance created a challenge for creating a waterfall chart in Power BI.

Power BI Relate tables
Power BI — Relate Tables Using Your Data Model — Episode 6
10 May 2019

Welcome to Episode 6 of my Power BI Best Practices Series. In today’s episode, I will show you how to relate tables and your data model to allow for cross filtering and relationships. Here we go! Power BI — Relate tables and your data model By default, Power BI relationships are not active. So, you need to set the relationships in your dashboard. You can also set the type of cardinality of the selected relationship from one of the following […]