How to Maintain PivotTable Column Widths After Data Refresh in Excel 2013
Welcome back to our Excel at Excel series with Steve Hughes! In this article, Steve shares a valuable tip for business intelligence users: how to keep your PivotTable column widths consistent even after refreshing the data in Excel 2013. Troubleshooting PivotTable Column Resizing Issues in Excel Dashboards When creating dynamic dashboards in Excel, especially for… Read More
Step-by-Step Guide to Building an Inspection App in Power Apps
When creating custom applications, you often face unique challenges that require creative solutions. In this article, I’ll demonstrate how to build a versatile inspection app using Power Apps. This example focuses on an app tailored for fire department vehicle inspections but can easily adapt to various inspection types with dynamic features. Building a Flexible Vehicle… Read More
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
A trending topic in modern data engineering is how to integrate Azure Databricks with Azure Data Factory (ADF) to streamline and enhance ETL workflows. If you’re wondering why Databricks is a valuable addition to your Azure Data Factory pipelines, here are three key scenarios where it shines. Why Databricks is the Optimal Choice for ETL… 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
In today’s fast-paced world of data analytics, Microsoft Fabric stands out as an innovative, unified platform that combines analytics, data engineering, and data science capabilities. Austin Libal, a seasoned trainer at walks through the streamlined process of migrating Power BI reports to Microsoft Fabric Data Flow Gen 2. This article summarizes Libal’s insightful video tutorial,… 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