Power BI Custom Visuals: How to Use the Scroller Visual for Dynamic Reporting

In this tutorial, you’ll discover how to enhance your Power BI reports using the Scroller custom visual. Developed to mimic the look and feel of a real-time stock ticker, the Scroller is ideal for showcasing continuously updating metrics such as stock prices, sales figures, and deviation values in a sleek, animated format. Introduction to Scroller… Read More

Are Professional Certifications a Scam or Truly Worth the Investment?

In today’s competitive job market, many professionals question the value of certifications. Are they simply a money-making scheme, or do they actually lead to career growth and real-world success? In this insightful video from Greg Trzeciak explores the true worth of professional certifications, featuring expert insights from HR leader Megan Richardson and testimonials from successful… Read More

Power Query: Using User-Driven Parameters to Control M Query Functions

Have you ever had users pull massive datasets from your database only to immediately filter down to a small subset in Excel? This inefficient process wastes bandwidth and slows performance, especially when dealing with large tables. Power Query offers a dynamic solution by allowing you to create queries that filter data based on user-supplied parameters—so… Read More

Mastering Excel 2013 for Business Intelligence: How to Optimize Your Slicers

Welcome back to the Excel at Excel blog series with Steve Hughes! In his previous post, Steve demonstrated how to add slicers to your Excel worksheets. In this article, we’ll focus on how to clean up and customize slicers to enhance user experience and improve your BI dashboards. The Importance of Refining Slicers for Optimal… Read More

How to Download Emails and Attachments Using SSIS

Have you ever needed to download emails and their attachments directly through SQL Server Integration Services (SSIS)? If so, you’ve come to the right place. Task Factory, a powerful suite of custom SSIS components developed by offers an Email Source component that enables you to extract email content directly into your SSIS data flow. This… Read More

Exploring Power BI Embedded in Azure: What You Need to Know

In a previous discussion, I covered two methods to embed Power BI into your applications or websites via Azure and Office platforms. Today, I’m focusing on Power BI Embedded specifically within Azure and what makes this solution distinct and advantageous. Comprehensive Guide to Deploying Power BI Embedded through Azure Power BI Embedded is a powerful… 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 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

Understanding Azure Subscriptions: How They Work

Steve Hughes breaks down the essential structure behind Azure subscriptions in this Azure Every Day feature. Navigating through tenants, subscriptions, and user accounts in Microsoft Azure can be confusing, but grasping the organizational hierarchy is key to managing your cloud resources effectively. Foundational Framework: Understanding Your Azure Hierarchy In the intricate world of cloud architecture,… Read More