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