Unlocking the Power of Custom Labels in Power BI for Enhanced Reporting

In today’s fast-evolving data visualization landscape, mastering the use of data labels is essential for creating clear and impactful reports. Mitchell Pearson explores the concept of custom data labels in Power BI, sharing expert insights on how to build and implement them effectively. Enhancing Insight with Custom Data Labels in Power BI Visualizations In today’s… Read More

Essential Best Practices for Performance Tuning in SSAS

SQL Server Analysis Services, commonly referred to as SSAS, is Microsoft’s analytical processing engine that supports both multidimensional cube-based models and tabular in-memory models for business intelligence workloads. Performance tuning in SSAS differs fundamentally from performance tuning in relational database systems because the workload characteristics, storage mechanisms, and query processing architectures are entirely different. While… Read More

Mastering Data Quality in Azure Data Factory for Scalable Analytics

Are you looking to enhance your data quality projects within Azure Data Factory to support better analytics at scale? In a recent webinar, Mark Kromer, Sr. Program Manager on the Azure Data Factory team, demonstrates how to efficiently build data quality solutions using Azure Data Factory’s data flows—without the need to write any Spark code.… Read More

How to Build a Simple Approval Workflow Using Microsoft Power Automate

Have you ever wanted to monitor data sources like SQL Server tables, SharePoint lists, or other databases and automatically trigger actions based on new entries? Microsoft Power Automate (formerly Microsoft Flow) is the perfect tool for this. In this tutorial, Brian Knight demonstrates how to create a straightforward approval workflow that automates decision-making based on… Read More

Seamless Integration of SSIS with Microsoft Azure: An Essential Guide

As more organizations migrate their data infrastructures to the cloud, ETL developers often ask: How does SSIS fit into Azure? Is it necessary to switch entirely to Azure Data Factory, or can you still leverage your existing SSIS packages effectively within Azure environments? In this insightful webinar, Mitchell Pearson explains how to continue using SQL… Read More

Getting Started with PySpark in Microsoft Fabric: A Beginner’s Guide

In a recent step-by-step tutorial on the YouTube channel, Austin Libal introduces viewers to the powerful combination of PySpark and Microsoft Fabric. This session is ideal for beginners interested in big data analytics, engineering, and science, using the modern Lake House architecture within Microsoft’s Fabric platform. Austin covers everything from environment setup to writing and… Read More

Discover the Top 5 Power BI Visual Enhancements You Should Be Using Now

The December 2023 Power BI update rolled out several exciting visual improvements designed to make your reports more engaging and easier to interpret. Presented by Greg Trzeciak, these five visual upgrades not only enhance the aesthetics of your dashboards but also boost the clarity and storytelling power of your data. Let’s explore these must-try features… Read More

A Complete Overview of Microsoft Azure Sphere for IoT Security

As the number of connected consumer devices continues to grow—ranging from smart appliances and thermostats to baby monitors and other IoT-enabled gadgets—the need for secure, scalable device management becomes critical. Each year, nearly 9 billion microcontroller (MCU)-powered devices are manufactured. These tiny chips house the compute power, memory, and operating systems required to operate modern… Read More

Moving from SSIS to Azure Data Factory: A Complete Guide

Are you planning to shift your ETL workflows from SQL Server Integration Services (SSIS) to Azure Data Factory (ADF)? This transformation can seem complex, but with the right knowledge, tools, and guidance, the transition becomes straightforward. In a recent webinar by data expert Samuel Owusu breaks down the process and explains how to manage your… Read More

Integrating Azure DevOps with Azure Databricks: A Step‑by‑Step Guide

In this post from our Databricks mini-series, I’ll walk you through the process of integrating Azure DevOps with Azure Databricks. This integration gives you version control for your notebooks and the ability to deploy them across development environments seamlessly. Maximizing Databricks Efficiency Through Azure DevOps Integration In the evolving landscape of data engineering and analytics,… Read More

Getting Started with Azure Data Factory Data Flows

If you’re exploring how to build efficient data integration pipelines without writing complex code or managing infrastructure, Azure Data Factory (ADF) offers a powerful solution. In this introductory guide, you’ll learn the essentials of Mapping and Wrangling Data Flows in Azure Data Factory, based on a recent session by Sr. BI Consultant, Andie Letourneau. In… Read More

How to Filter Lookup Columns in Model-Driven App Forms with Ease

Are your lookup columns cluttered with irrelevant data in your model-driven Power Apps? You’re not alone. In this tutorial, Power Platform expert Matt Peterson walks us through a streamlined approach to filtering lookup columns in model-driven apps. Whether you’re a beginner or a seasoned app builder, this guide will help you improve user experience and… Read More

Unlock Real-Time ETL with Azure Data Factory Event Triggers

Still scheduling your ETL pipelines to run at fixed intervals? It’s time to modernize your approach. Azure Data Factory (ADF) Event Triggers allow your data workflows to be executed in real-time based on specific events, such as the creation or deletion of files in Azure Blob Storage. In this guide, we’ll explore how Event Triggers… Read More

Leveraging Informatica Enterprise Data Catalog on Azure for Enhanced Data Management

If your organization uses Azure and is searching for a comprehensive data catalog and data lineage solution, Informatica Enterprise Data Catalog is a powerful tool worth considering. This post explores how Informatica’s Data Catalog integrates with Azure to help you efficiently manage metadata and improve data governance. Informatica Enterprise Data Catalog stands as a pivotal… Read More

Exploring Power BI Custom Visuals: The Globe Map

In this tutorial, Devin Knight introduces you to the powerful Globe Map custom visual for Power BI. The Globe Map is a dynamic 3D globe visualization that supports both bar chart and heat map overlays, allowing you to represent complex geographical data with enhanced visual appeal. Power BI’s Globe Map visual offers a striking three-dimensional… Read More