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