Data Analytics
How Aggregation Tables Improve Performance for Power BI Reports
This dive into aggregation tables will help you decide when to use them in Power
May 25, 2021
Search Results
Search results for
Data Analytics
Power BI Tips for Star Schema and Dimensional Data Modeling
This blog covers the advantages of using dimensional data models in your Power BI datasets
February 16, 2021
Security
6 Practical Data Protection Features in SQL Server (Pros & Cons)
Here’s how we use the data protection features within SQL Server to protect confidential data
August 25, 2020
Data & Applications
Machine Monitoring IoT Solution with Azure Services and Power BI
We custom-made an IoT framework with Azure components and Power BI to implement a scalable
June 11, 2019
Data & Applications
How to Dynamically Scale an Azure SQL Database
By designing and implementing a dynamic scaling plan for your Azure solution, you can get
August 24, 2017
Data Analytics
7 Things to Remember When Setting Up Fuzzy Lookups
In my last post, I explained why I would want to use Fuzzy Lookups for
June 8, 2017
Data Analytics
3 Steps to Implement AD Security for an On-Premises Data Gateway
The idea to implement AD groups was first realized when trying to dynamically populate O365
April 28, 2017