Discover Everything About SQL Server 2016: Free Training Series

We have eagerly anticipated the launch of SQL Server 2016. To help you explore all the groundbreaking features in this release, we’re hosting an entire month dedicated to free SQL Server 2016 training sessions. These webinars are presented by industry leaders and Microsoft MVPs who have hands-on experience with SQL Server 2016 previews. They’re excited… Read More

Laying the Foundation for DP-100 Certification: Understanding the Role and Relevance

In today’s technology-driven world, the relevance of cloud-based data science roles has expanded rapidly. Among the many certifications that provide credibility in this space, the Azure DP-100 certification stands out. This certification is formally titled Designing and Implementing a Data Science Solution on Azure, and it serves as a benchmark for professionals seeking to demonstrate… Read More

How to Handle Nested ForEach Loops in Azure Data Factory Pipelines

If you’re working with Azure Data Factory (ADF) or just beginning to explore its pipeline orchestration capabilities, understanding how to implement loops effectively is crucial. One common question arises when trying to nest one ForEach activity inside another within the same pipeline—something that ADF does not natively support. Understanding the Inability to Nest ForEach Loops… Read More

Simplify Power BI Filter Reset with Bookmarks for End Users

Slicers in Power BI reports provide powerful flexibility, allowing end-users to filter data according to their preferences. However, resetting all slicers back to their default, unfiltered state can be frustrating—often requiring multiple clicks to clear each filter individually. Simplify Power BI Navigation with Smart Bookmark Reset Buttons Creating effective and user-friendly dashboards in Power BI… Read More

Discover the New Lasso Select Feature in Power BI

Power BI now offers an exciting preview feature called Lasso Select, also known as the “rectangle data” selector. This new functionality dramatically enhances the way you interact with your Power BI reports by allowing you to select multiple visuals quickly and easily. Elevating Data Exploration with Lasso Select in Power BI Modern data analytics requires… Read More

Everything You Need to Know About Power BI Premium

Microsoft recently made some exciting updates regarding Power BI Premium. Our Consulting President, Adam Jorgensen, who is currently at Microsoft headquarters, has shared valuable insights into what Power BI Premium offers and how it can benefit your organization. Enhance Business Intelligence with On-Premises Power BI Report Server As organizations continue to adopt hybrid data strategies,… Read More

Introduction to Azure Databricks Delta Lake

If you are familiar with Azure Databricks or already using it, then you’ll be excited to learn about Databricks Delta Lake. Built on the powerful foundation of Apache Spark, which forms about 75-80% of Databricks’ underlying code, Databricks offers blazing-fast in-memory processing for both streaming and batch data workloads. Databricks was developed by some of… Read More

Understanding Disaster Recovery for Azure SQL Data Warehouse

Do you have a disaster recovery strategy in place for your Azure SQL Data Warehouse? In this article, we’ll explore the disaster recovery capabilities of Azure SQL Data Warehouse, focusing specifically on a critical feature introduced with Azure SQL Data Warehouse Gen2 — the Geo-backup policy. How Geo-Backup Policy Fortifies Disaster Recovery in Azure SQL… Read More

How to Use Power Apps Solution Packager to Transfer Apps Between Environments

Did you know that Power Apps Solution Packager enables you to efficiently move Power Apps solutions across different environments or even share them with external customers? There are two primary methods for transferring apps: exporting and importing individual applications, or using a Power Apps solution for a more comprehensive approach. This tutorial explains how to… Read More

How to Use PowerShell Directly Within the Azure Portal

Did you know that Azure Cloud Shell allows you to run PowerShell commands directly within the Azure Portal—without needing to install anything locally? This feature is a huge time-saver for administrators and developers, offering a fully managed, browser-based command-line experience. In this guide, we’ll walk you through how to launch and use PowerShell in Azure… Read More

How to Build a Timecard App with Nested Galleries and Office 365 in PowerApps

Are you looking to create a dynamic timecard application using PowerApps? In this tutorial, we’ll walk you through building a fully functional timecard app from scratch. You’ll learn how to use nested galleries and integrate Office 365 functions to capture user-specific information like email addresses. This step-by-step guide helps you understand how to filter user… Read More

How to Use CALENDARAUTO: A Powerful DAX Function for Power BI Date Tables

Working with dates in Power BI can make your dashboards shine—or cause unexpected headaches if not handled correctly. During one of my recent projects, I discovered the true power of the DAX CALENDARAUTO function, and it completely changed the way I handle Power BI Date Tables. If you’re using the CALENDAR function to manually build… Read More

Top Power BI DAX Interview Questions and Expert Answers

Welcome to another edition of our Power BI Interview Prep Series! Whether you’re preparing for a Power BI developer interview or conducting one, this guide will help you navigate through key DAX (Data Analysis Expressions) questions with clear, structured answers. Understanding these concepts is essential for anyone looking to work with Power BI, Power Pivot,… Read More

Boost Power BI Reports with Dynamic Tooltips by MAQ Software

In this guide, we’ll explore how to effectively use the Dynamic Tooltip custom visual developed by MAQ Software in Power BI. This visual enables report creators to display interactive popups that provide users with real-time contextual insights when they hover over data points. Unlocking Enhanced Data Storytelling with the Dynamic Tooltip Visual in Power BI… Read More

Enhance Power BI Filtering with the Attribute Slicer Custom Visual

In this tutorial, we’ll explore how to utilize the Attribute Slicer, a powerful custom visual in Power BI that enhances filtering capabilities and boosts interactivity in your reports. The Attribute Slicer allows users to filter datasets based on attributes while simultaneously displaying associated measure values in a visually intuitive format. Exploring the Power and Versatility… Read More