Essential Guide to Migrating from Teradata to Azure SQL
Are you planning to migrate your data from Teradata to Azure SQL in the cloud? This comprehensive guide will walk you through the critical steps to ensure a smooth and successful migration process. Migrating from Teradata to Azure SQL is a complex, multifaceted process that requires meticulous preparation and strategic planning to ensure a seamless… Read More
Mastering Running Totals in Power BI Using Variables, CALCULATE, and FILTER
Following a recent private training session, I received an insightful question from one of the participants. He wanted to know how to calculate a running total for a column of values in Power BI. My initial recommendation was to use the DAX function TOTALYTD (Year To Date), which, when combined with a date column, continuously… Read More
Understanding Running Totals in Power BI Using DAX Variables, CALCULATE, and FILTER
After a recent private training session, one participant reached out with a great question: How can you create a running total for a column of values in Power BI? My first thought was to use the built-in DAX function TOTALYTD, which sums values over time within a calendar year based on a date column. This… Read More
Introduction to Azure Analysis Services: Unlocking Scalable Data Modeling in the Cloud
If you’re leveraging the Azure ecosystem, Azure Analysis Services should be an essential part of your data strategy. This powerful service offers scalable resources tailored to your business needs, seamless integration with popular visualization tools like Power BI, and robust governance and deployment options to confidently deliver your BI solutions. Azure Analysis Services stands out… Read More
Everything You Should Know About Power BI Licensing Costs and Options
Curious about how much Power BI will cost your business or organization? This is a common question I receive, and I’m here to clarify the different licensing models and help you understand what fits your needs best. Power BI Desktop, developed by Microsoft, stands as one of the most robust and accessible tools in the… Read More
Mastering the Power BI Route Map Custom Visual for Dynamic Mapping
In this tutorial, you will discover how to effectively use the Route Map custom visual in Power BI. This visual allows you to display the movement path of an object using latitude, longitude, and time data, creating an animated trajectory on your map. Data visualization is a critical component in uncovering insights and patterns hidden… Read More
How to Publish and Share Your PowerApps Applications Effectively
One of the biggest advantages of building apps with PowerApps is the ease of publishing and sharing your creations across your organization. In this guide, I’ll walk you through the process of deploying your PowerApps app so it’s accessible on mobile devices, the web, SharePoint, and Dynamics 365. Additionally, we’ll cover version management and environment… Read More
Understanding Cosmos DB Request Units (RUs) and Their Importance
In this article, we’ll explore Cosmos DB Request Units (RUs) and what it means to work with them within Azure Cosmos DB. Request Units provide a unified metric that combines CPU, memory, and IOPS usage, allowing you to easily measure and manage the throughput capacity of your Cosmos DB resources. Azure Cosmos DB is a… Read More
Simplifying Navigation in Power BI with Drill Through Buttons
Drill through functionality in Power BI is incredibly powerful for in-depth data exploration. However, many users find the traditional right-click method to access drill through pages unintuitive or inconvenient. Fortunately, with the introduction of the drill through buttons preview feature, you can now offer a much smoother navigation experience by replacing the need to right-click… Read More
Unlocking the Power of PolyBase in SQL Server 2016
One of the standout innovations introduced in SQL Server 2016 is PolyBase, a game-changing technology that bridges the gap between relational and non-relational data sources. Previously available on Analytics Platform System (APS) and Azure SQL Data Warehouse (SQL DW), PolyBase now brings its powerful capabilities directly into SQL Server, enabling seamless querying across diverse data… Read More