By: Mason Prewett When creating a Power BI report, the number of measures can add up and become difficult to organize and manage. Having measures in a table with other fields can become confusing. A measure table can help, but this too begins to get cluttered....
By: Ken Adams The Problem I recently ran across an issue on a project that required a large amount of data to be removed from a table, specifically an issue with the loading of the table causing duplication of data. All non-clustered indexes had been removed...
By: Phillip Sharpless The need to export data from a database to some other format is a pretty common scenario for many data professionals. SQL Server Management Studio provides several different ways to accomplish this, some more complicated than others. If...
By: Shannon Nagy When transitioning from on-premise ETL processes with SQL Server to the cloud with Azure, you may be used to dealing with large numbers of SSIS packages in order to perform data movement operations on many tables at once. You may have even...
By: Mason Prewett What are Power BI Streaming Datasets? Power BI Streaming Datasets allow developers to create reports and dashboards that refresh in real time as a Power BI dataset is updated. These datasets can be updated by various methods, such as using...
By: Ken Adams Power BI Desktop is a free and powerful analytics tool that puts data visualization and data transformation right at your fingertips. As we all know, 2020 was a contentious election year, especially here in Georgia, where we had runoff...
