Discover the Top 5 Must-Have Power BI Custom Visuals
Power BI Custom Visuals unlock incredible possibilities to elevate your reports, and best of all—they’re free to use! Devin Knight, our expert Training Director is widely recognized for his deep knowledge of Power BI Custom Visuals. In a recent detailed webinar, Devin showcased his top five favorite custom visuals, complete with live demonstrations. Understanding Power… Read More
Why Choose Azure SQL Data Warehouse for Your Cloud Data Needs
If your organization is still relying on an on-premises data warehouse, it’s time to consider the powerful benefits of migrating to the cloud with Azure SQL Data Warehouse. This Microsoft cloud-based solution offers a modern, scalable, and cost-effective platform for data warehousing that outperforms traditional onsite systems. Unleashing the Power of Azure SQL Data Warehouse… Read More
Getting Started with SQL Server Reporting Services (SSRS) 2012
If you’re new to reporting and feeling overwhelmed by SQL Server Reporting Services (SSRS), you’re not alone. Despite its complex reputation, SSRS is one of the most approachable tools in the Microsoft Business Intelligence (BI) stack. In this webinar, we explore the exciting enhancements introduced in SSRS 2012 that make report creation and management easier… Read More
Leveraging Azure Databricks Within Azure Data Factory for Efficient ETL
Modern data engineering teams operating within the Microsoft Azure ecosystem frequently find themselves working with two of the platform’s most powerful data services simultaneously, each contributing distinct capabilities to a unified data processing architecture. Azure Data Factory serves as the orchestration and pipeline management layer, providing scheduling, dependency management, monitoring, and connectivity to hundreds of… Read More
Mastering Excel 2013 for Business Intelligence: How to Add a Slicer
Welcome back to the Excel at Excel blog series with Steve Hughes! In previous posts, Steve has explored powerful features like Quick Explore, Show Details, and Flash Fill. In this article, Steve dives into the process of adding and using Slicers in Excel 2013 to enhance your data analysis experience. Understanding Slicers in Excel 2013… Read More
How to Use Stored Procedures as a Sink in Azure Data Factory Copy Activity
In recent posts, I’ve been focusing on Azure Data Factory (ADF) and today I want to explain how to use a Stored Procedure as a sink or target within ADF’s copy activity. Typically, copy activity moves data from a source to a destination table in SQL Server or another database. However, leveraging a stored procedure… Read More
How to Integrate Azure Active Directory Security Groups with Power Apps
Have you ever wondered how to build a Power App that dynamically shows or hides features based on a user’s membership in specific Azure Active Directory (Azure AD) or Office 365 security groups? This is a common requirement among businesses looking to secure app functionality, and in this guide, I’ll demonstrate exactly how to achieve… Read More
Effective Troubleshooting for SSIS and SSRS Without Getting Overwhelmed by Logs
Have you ever had your SSIS package fail unexpectedly in the middle of the night? Troubleshooting issues in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) can often be a complex and time-consuming task, especially when you’re drowning in endless log files. In a recent webinar, Brian Knight, Founder and CEO shared… Read More
Seamless Migration of Power BI Reports to Microsoft Fabric Data Flow Gen 2
Organizations worldwide are increasingly recognizing the strategic value of Microsoft Fabric as a unified analytics platform that consolidates data warehousing, data lakes, and business intelligence capabilities into a single integrated environment. Power BI reports currently deployed in legacy environments can leverage significant advantages by migrating to Fabric’s modern data architecture. Migration to Fabric Data Flow… Read More
How to Use the Enlighten World Flag Slicer Custom Visual in Power BI
In this guide, you will discover how to utilize the Enlighten World Flag Slicer—a powerful custom visual for Power BI. This slicer automatically converts text fields containing country names or abbreviations into corresponding country flags, allowing you to filter report elements visually and intuitively. Exploring Module 55: Enlighten World Flag Slicer for Power BI In… Read More
Power BI and Enterprise Data Security: Compliance and Encryption Overview
As Power BI continues to gain traction in enterprise data analytics and visualization, ensuring robust data security is paramount. Organizations leveraging cloud platforms like Microsoft Azure, AWS, Salesforce, and Office 365 must understand the compliance standards and security measures these services provide, particularly in the context of Power BI. Over the past several years, I’ve… Read More
Understanding Power BI Licensing: A Comprehensive Guide for Your Organization
Are you just starting with Power BI in your company and feeling overwhelmed by the licensing options? Power BI licensing can seem straightforward for small businesses but tends to get complex in larger organizations. This guide will help you navigate the key concepts and steps to manage Power BI licenses effectively. Comprehensive Guide to Power… Read More
How to Document Flow Logic in Power Automate: Best Practices and Quick Tips
Welcome to another edition of Power Platform Quick Tips! In this post, we’re diving into one of the most overlooked yet valuable practices in Power Automate—documenting your flow logic. Whether you’re building simple workflows or complex automation, adding clear documentation helps you and your team maintain, understand, and scale your solutions more effectively. The Importance… Read More
Mastering the Power Apps Canvas Code Editor: Complete Guide for Developers
Microsoft Power Apps has introduced a highly anticipated feature that’s changing the game for app creators—the Canvas Code Editor. This new addition allows developers to view, copy, and reuse the code behind app objects, significantly boosting efficiency, consistency, and scalability across Canvas apps. In this guide, we’ll walk you through how the Power Apps Code… Read More
Do You Really Need a Star Schema in Your Data Warehouse?
A star schema is a dimensional modeling technique used in data warehousing where a central fact table containing measurable business events is surrounded by dimension tables that provide descriptive context for those measurements. The name comes from the visual appearance of the resulting entity-relationship diagram, where the fact table sits at the center and dimension… Read More