MO-200 Microsoft Excel Certification: Preview of the Ultimate Prep Course
In today’s data-driven world, mastering Microsoft Excel is essential for professionals across industries. To meet this growing demand, Launched a comprehensive training course designed specifically to prepare learners for the MO-200 Microsoft Office Specialist Excel 2019 certification exam. Yasmine Brooks, an expert trainer, introduces this expertly crafted program aimed at helping students gain the skills… Read More
Power BI Custom Visuals Explained: Using the Mekko Chart
In this tutorial, you will discover how to effectively use the Mekko Chart, a powerful custom visual available in Power BI. The Mekko Chart is ideal for comparing two distinct dimensions within a single, intuitive chart. The Mekko Chart, also known as a Marimekko chart, is an advanced and visually compelling data visualization tool available… Read More
Understanding Direct Query Constraints in Power BI
Are you encountering challenges with Direct Query in Power BI due to its inherent limitations? In this post, I’ll share some practical tips to help you overcome these common obstacles and enhance your data reporting experience using Direct Query mode. Power BI’s Direct Query mode provides the advantage of real-time data access without the need… Read More
Moving from Traditional Data Architectures to Azure-Based Solutions
In this article, I’ll explore the shift from classic Microsoft data tools like SSIS, SSAS, and SSRS to the modern Azure data ecosystem. If you’re transitioning from on-premises SQL Server environments to Azure’s cloud-native services, this guide will serve as a valuable roadmap. In today’s rapidly evolving data landscape, organizations are increasingly considering the shift… Read More
How to Perform Data Merging Using Change Data Capture in Databricks
In this post from our Azure Every Day Databricks mini-series, we explore how to effectively use Change Data Capture (CDC) in Databricks. CDC is widely used to track and merge changes from multiple data sources into Databricks Delta tables. This process helps you seamlessly handle inserts, updates, and deletes in your data pipeline. In modern… Read More
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
The Power BI Free license provides individual users with access to Power BI Desktop and limited cloud service functionality, enabling personal data analysis and report creation without financial investment. This tier allows users to create sophisticated visualizations, perform data transformations, and build comprehensive dashboards using the full desktop application capabilities. However, the free license restricts… Read More