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 […]
Talks on Managing Data and Applications Anywhere
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.
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.
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 […]
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.
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 […]
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 […]
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 […]
During bulk data loads with an Azure SQL Database Managed Instance, we noticed a significant performance hit as we imported data into staging tables. It turns out a Managed Instance default file growth for data and files is 16 MB! Change your Managed Instance default file growth size now! With the database file growth set so low, SQL Server grinds to a snail’s pace when importing large amounts of data. In our case, I changed the file growth to something […]