Understanding PowerApps Canvas vs. Model-Driven Applications: Key Differences Explained
Are you familiar with the distinctions between PowerApps Canvas and Model-driven applications? Whether you’re a seasoned PowerApps user or just starting out, understanding these two app types is crucial for selecting the right approach for your project. In this article, Brian Knight breaks down the differences and helps you decide when to build a canvas… Read More
Mastering the PL-300 Certification Exam: Understanding Merging vs. Appending Queries in Power BI
Welcome back to our ongoing PL-300 Power BI certification exam prep series brought to you. In this installment, Angelica Domenech focuses on the critical “Prepare the Data” functional area, which is a key part of the Microsoft Power BI Data Analyst Associate certification. If you haven’t yet, make sure to check out the first episode… Read More
Comprehensive Guide to Data Discovery and Classification with SQL Server 2019
Are you interested in mastering data discovery and classification using SQL Server 2019? In a recent webinar, Steve Hughes, Director of Consulting provides an in-depth tutorial on how to perform data discovery and audit sensitive information within your SQL Server databases effectively. The Strategic Value of Data Classification and Security in SQL Server 2019 In… Read More
How to Move Files Between Folders on Your FTP Server Efficiently
Downloading files from an FTP server is straightforward. Uploading files? Even easier. But what about moving files between folders on the server, especially as part of an automated ETL process? For many SSIS developers, this can be a tricky task. Fortunately, with recent updates in Task Factory, managing file movements on your FTP server has… Read More
How to Build a Salesforce-Integrated Application Using PowerApps
Are you looking to boost sales by integrating PowerApps with Salesforce? Gina Ostrowsky, one of our Sales Managers, wanted an app that allows her to access leads and contacts on the go, right from her phone, wherever she travels. She needed a solution that pulls relevant sales data based on her location and demographics. In… Read More
Mastering Data Validation in Dynamics 365 and Power Apps
Maintaining high-quality data is essential in any system—after all, the old saying “garbage in, garbage out” still rings true. In this insightful video, Brian Knight from demonstrates how to prevent inaccurate or incomplete data from entering your Dynamics 365 or Power Apps environment by leveraging effective data validation techniques. Let’s explore how to keep your… Read More
Azure Data Week: Exploring Modern Data Warehouse Design Patterns
During Azure Data Week, Bob Rubocki presented an insightful session on Modern Data Warehouse Design Patterns, highlighting cloud-based data warehousing and data flow strategies using Azure services such as Azure Data Factory, Azure Logic Apps, Azure Data Lake Store, and Azure SQL Database. Due to time constraints, some attendee questions remained unanswered during the live… Read More
Understanding Paginated Reports in Power BI
Have you explored the benefits of implementing paginated reports within Power BI? Recently, clients have asked about options for operational reporting optimized for printing, alongside their interactive, self-service Power BI dashboards. Some were hesitant about adopting new tools for their critical reporting needs. Understanding the Power of Paginated Reports in Modern Business Intelligence Paginated reports… Read More
Comparing Azure Data Factory Copy: Folder-Level vs File-Level Loading
In this article, I’ll share insights gained from recent projects involving Azure Data Factory (ADF) performance when transferring data from Azure Data Lake to a database, focusing specifically on the Copy Activity. The key topic here is understanding the performance differences between loading data one file at a time versus loading an entire folder of… Read More
Discover the Power of Power BI Custom Visuals
Welcome to an exciting, completely free training series launching today! Over the next year, I will release one detailed module each week, guiding you through how to maximize all the amazing Power BI visuals available in the Custom Visuals Gallery. You may wonder why I’m dedicating so much time to this. Well, Microsoft’s Power BI… Read More