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. Here we go! Create Power BI Themes 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. Basically, a Power BI theme is a JSON file with specific structure. Of course, you can edit any of the existing themes as well.   Check out our prior episodes to see where we are going ...

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 strategy. Regardless of how simple or advanced your solution is, you will want to test it before demonstrating...

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. Here we go! Create Drillthrough Pages with Detail 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. After you create the drillthrough pages, be sure to mark them as hidden. In this case, the users will not see these pages in your dashboard. However, they will navigate through these drillthrough pages by sim...

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. The Problem The original script looked as follows: 123456789101112IF OBJECT_ID('dbo.data_xxxx') IS NULL BEGIN CREATE VIEW dbo.data_xxxx AS SELECT VCV.item1, VCV.item2 AS item2, VCV.item3 AS item3 FROM TABLE_A VCV END ELSE BEGIN ALTER VIEW dbo.data_xxxx AS SELECT VCV.item1, VCV.item2 AS item2, VCV.item3 AS item3 FROM TABLE_A VCV END Apparently, the developers created ...

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 the total approved actual expense incurred by Montgomery County Government employees traveling non-locally. The data set comprises of 7 columns and 1412 rows. This data se...

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. Here we go! Power BI — Align Your Visuals Misaligned visuals on a messy dashboard may look confusing for the users. As they don’t understand where to look at, the users can’t find the information they need. So, you’d like to create a solid and elegant dashboard. The latest version of Microsoft Power BI brings a very intelligent and handy interface to align the visuals and make them user-friendly. Be sure to align your visuals to allow for a better view...

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. Item Price, $ Start value 288,222,000.21 A (60,311.00) B (333,111.00) C 64,444.00 D (187,856.00) E 108,886.00 F (268,806.00) G 41,961.00 H 1,803,265.00 I (12,606.00) J (380,246.00) K 1,650,164.00 L (1,863,598.00) Final value 285,769,892.75 With the highest value being $288,222,000.21 million and the lowest value being negative $1,863,598.00, the ...

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 options: many to one, one to one, one to many, many to many. Also, you can opt for changing the cross filter direction. After you add the required settings to the dashboard, you can see that Power ...

Backup Restore Azure SQL DBMI
Migrate Azure SQL Database Manage Instances to Azure VMs using Backup and Restore
08 May 2019

I recently needed to migrate an Azure SQL Database Managed Instance to an Azure VM running SQL Server. There were several reasons for this which included: Machine Learning Services was not available for processing R language libraries close to the database. Bulk loading CSV files were slower than expected because Managed Instances only supports the Full Recovery Model. PolyBase was not available for data mining data files located in Azure Data Lake Gen2 storage. The challenge that I faced was that when you create a database on a SQL Server Managed Instance, the database is encrypted with Transparent Data Encryption (TDE). It also uses a servi...

Power BI - Prepare Report
Power BI — Prepare Report Requirements — Episode 5
03 May 2019

Welcome to Episode 5 of my Power BI Best Practices Series. In today’s episode, I will show you how to prepare report requirements documentation. Here we go! Power BI — Prepare Report Requirements When building out your Power BI Dashboards, how do you make sure your visualizations address all the points your client wants? This is where a Reports Requirement Document comes into play. By creating a Reports Requirement Document, you will have a record of what’s expected, and can use it as a general outline for building your dashboard. This document can also clarify any potential misunderstandings in the future regarding the scope of...