Understanding Azure Data Factory’s If Condition Activity for Dynamic Pipelines
In this detailed guide, we explore how to effectively use the If Condition activity in Azure Data Factory (ADF) to control the execution flow based on dynamic conditions. Previously, in part one of this series, you learned to retrieve the last modified date of a file using the Get Metadata activity, and in part three,… Read More
Mastering the Sum Function and Collections in Power Apps: From Basic to Advanced Techniques
As a former Algebra and Algebra 2 instructor, I frequently worked with summing numbers—something we often overlook in Power Apps. Summing numerical values isn’t just essential for math teachers, Power BI analysts, or Excel users; it’s equally powerful within Power Apps to enhance your app’s data handling and interactivity. Step-by-Step Guide to Summing a Column… Read More
Essential Guide to Building a Date Table for Data Models and Warehouses
Creating a date table is a common need when designing data warehouses or building data models in tools like Excel’s Power Pivot or SQL Server Analysis Services. A well-structured date table allows you to efficiently analyze and aggregate data across various time periods. We recommend a method using a Common Table Expression (CTE) to generate… Read More
Mastering Advanced Filtering Techniques in Power Apps with Multiple Dropdowns
In my previous blog and video tutorial, I showed how to filter gallery records using a single dropdown control linked to a distinct column in your data source. This simple yet effective method helps users narrow down the displayed data easily. If you missed it, check out the video below. Mastering Advanced Filtering in Power… Read More
How to Save Multiple Attachments from Microsoft Forms to a SharePoint List Using Power Automate
In this step-by-step tutorial, Jonathan Silva from explains how to save multiple file attachments submitted through Microsoft Forms directly into a SharePoint list by leveraging Power Automate. This guide expands on the single-attachment process, detailing the necessary workflow adjustments to efficiently manage and store multiple uploaded files. How to Efficiently Manage Single and Multiple Attachments… Read More
Exploring the Future of Data Transformation: Dynamic Unpivoting Using PySpark in Databricks
In this comprehensive tutorial, Mitchell Pearson from demonstrates how to efficiently perform dynamic unpivoting in PySpark within the Databricks environment. The focus is on transforming data from a wide format with multiple columns into a streamlined, relational format that enhances analysis and reporting capabilities. Mitchell guides viewers through handling datasets with varying column counts, ensuring… Read More
Simplifying Record Filtering in Power Apps
During numerous Power Apps training sessions, one of the most frequently asked questions is whether Power Apps supports filtering the records that end-users can see. The straightforward answer is yes! However, the filtering options are extensive and varied. You can implement security filters to restrict data access, allow users to select their own filters within… Read More
How to Save a Single Microsoft Form Attachment to a SharePoint List Using Power Automate
In this tutorial, Jonathan Silva from guides you step-by-step on how to automatically save a single attachment submitted via Microsoft Forms directly into a SharePoint list using Power Automate. This automated workflow simplifies managing form responses and attachments by centralizing everything within SharePoint. Benefits of Storing Microsoft Forms Attachments Directly in SharePoint Microsoft Forms offers… Read More
Comprehensive Guide to Power BI Custom Visuals: Power KPI Explained
In this detailed tutorial, you will learn how to effectively use the Power KPI Custom Visual in Power BI. The Power KPI visual provides a dynamic way to display your key performance indicator values on a multi-line chart, complemented by informative labels to enhance your data storytelling. Comprehensive Insight into the Power KPI Visual in… Read More
Mastering Data Cleansing and Shaping in Power BI: Beginner to Pro
In a recent comprehensive training session hosted by our site, Angelica Choo Quan delivered an insightful exploration into the critical processes of data cleansing and shaping within Power BI. This session focused on the often underestimated but essential phase of data preparation that precedes report development. Proper data cleansing is fundamental to creating accurate, meaningful,… Read More
Understanding Essential Terms in Azure Databricks
Azure Databricks is a powerful analytics platform designed to streamline big data processing, data science, and machine learning workflows. Built as a fully managed Apache Spark environment on Microsoft Azure, it provides scalability, ease of use, and seamless integration with a wide range of Azure services. Unlike traditional Spark clusters that require complex infrastructure management,… Read More
How to Send SMS Messages Using Power Apps
Text messaging continues to be one of the most reliable and engaging forms of communication for businesses. For nearly a decade, SMS has delivered higher open and response rates compared to other digital channels. In today’s fast-paced mobile-first world, organizations are now seeking ways to leverage text communication within their existing Microsoft Power Platform solutions.… Read More
Comprehensive Guide to Mastering Microsoft OneNote
Microsoft OneNote has become an essential productivity tool for students, educators, professionals, and anyone looking to streamline their note-taking process. In this comprehensive tutorial, Matt Peterson—Senior Trainer and former educator—shares practical insights on how to maximize the full potential of OneNote in both personal and collaborative settings. Whether you’re brand new to OneNote or seeking… Read More
Understanding Azure Data Box and Data Box Disk: A Smarter Way to Transfer Large Data to the Cloud
When it comes to migrating massive volumes of on-premises data into Microsoft Azure, the process can often feel overwhelming. Traditional methods can be slow, complicated, or require significant bandwidth that isn’t always available. That’s where Azure Data Box and Azure Data Box Disk step in—Microsoft’s purpose-built solutions to make bulk data migration fast, secure, and… Read More
How to Access Your Power BI Report in the Embedded Playground
Are you familiar with the Power BI Embedded Playground? For those new to it, Power BI Embedded is a Microsoft Azure service designed for developers to seamlessly embed Power BI visuals, reports, and dashboards directly into their applications. The Embedded Playground acts as an interactive environment where developers can explore and experiment with these embedded… Read More