Exploring Power BI Custom Visuals: The Radar Chart

In a previous post, we covered the Hebxbin Scatterplot visual. Now, let’s dive into another powerful Power BI custom visual — the Radar Chart. Also known as a web chart, spider chart, or star chart, the Radar Chart is an excellent tool to visualize multiple categories of data arranged along spokes, similar to the spokes… Read More

Understanding Azure Active Directory and Resource Groups

Resource groups play a crucial role in organizing and managing workloads within your Azure subscriptions. When working on Azure data warehousing projects, we’ve seen how an effective resource group strategy can streamline access management and improve overall governance. Azure Resource Groups serve as a fundamental organizational construct within Microsoft Azure, designed to logically group related… Read More

What Is Microsoft Graph and Why It Matters

In today’s article, let’s explore Microsoft Graph—an essential API designed to unify access to various Office 365 services. Microsoft Graph serves as a single endpoint that enables developers and IT professionals to interact seamlessly with key Microsoft tools such as Exchange, OneDrive, Teams, and many others. In today’s fast-evolving digital landscape, developers and organizations constantly… Read More

Understanding the Relationship Between IoT Hub, Event Hub, and Event Grid

Azure offers several messaging and event-processing services that can sometimes be confusing due to similar naming conventions. In this article, we clarify how Azure IoT Hub, Event Hub, and Event Grid are connected, what sets them apart, and how each plays a unique role in your cloud solutions. In the expansive realm of cloud data… Read More

Introduction to Azure Storage Explorer: Your Cloud Storage Management Tool

Managing Azure storage efficiently is a priority for many professionals working in the cloud. Azure Storage Explorer is a powerful, user-friendly tool designed to simplify your cloud storage management tasks and enhance your productivity. Comprehensive Overview of Azure Storage Explorer’s Core Features Azure Storage Explorer is an indispensable tool designed to simplify the management of… Read More

Step-by-Step Guide to Building a Tabular Model in SSAS

With the release of SQL Server 2012, Microsoft introduced the powerful SQL Server Analysis Services (SSAS) Tabular model. This in-memory or Direct Query mode database works with relational data sources, providing a fast and efficient solution for delivering self-service Business Intelligence to tools like Microsoft Power View and Excel. Understanding how to build a Tabular… Read More

Leveraging Azure DevOps for Effective Project Management

Azure DevOps offers a comprehensive suite of developer services designed to help teams plan, collaborate on code development, and manage the build and deployment of applications. Whether you prefer working in the cloud with Azure DevOps Services or on-premises using Azure DevOps Server, this platform integrates seamlessly with tools like Dev Hub for source control… Read More

Comparing Azure Data Lake and Azure Blob Storage for Data Warehousing

In this article, we explore key considerations when deciding between Azure Data Lake Storage and Azure Blob Storage for your data warehousing needs. Using Microsoft’s reference architecture as a foundation, we’ll break down the differences and help you make an informed choice. Understanding Microsoft’s Data Warehousing Reference Architecture In the realm of modern data management,… Read More

Getting Started with OneNote: Creating Notebooks, Sections, and Pages

If you’re new to OneNote or aiming to improve your skills, join Matt Peterson, senior trainer as he breaks down the essentials of Microsoft OneNote in this introductory series. Matt begins by explaining the core features that make OneNote a versatile digital note-taking tool. Microsoft OneNote has transformed the way people capture and organize their… Read More

How to Configure Parameters for Power BI Reports: A Step-by-Step Demo

Parameters in Power BI act like dynamic variables that you can adjust anytime to control what data is loaded and displayed in your reports. By setting parameters, you empower yourself and your end-users to filter data efficiently and customize report content based on specific needs. When building Power BI reports and dashboards, optimizing data load… Read More

Introduction to DAX VALUES Function in Power BI Virtual Tables

Jeremiah Hersey kicks off his insightful 6-part series on Virtual Table functions in Power BI Desktop with an in-depth exploration of the DAX VALUES function. This video tutorial explains how the VALUES function operates in different contexts, making it a foundational concept for effective DAX programming. The VALUES function in DAX is a versatile tool… Read More

Mastering the PL-300 Power BI Data Analyst Certification

Join Angelica Domenech in this comprehensive free session designed to help you successfully conquer the PL-300 Power BI Data Analyst Certification exam. Gain valuable insights into the exam structure, question formats, study strategies, and essential tips to boost your confidence and performance. The Microsoft PL-300 Certification Exam, formally known as “Microsoft Power BI Data Analyst,”… Read More

Mastering SQL Set Operators: A Comprehensive Guide by Austin Libal

In this article, SQL expert Austin Libal takes you on a deep dive into SQL set operators. Learn how to effectively use set operators like INTERSECT, EXCEPT, and UNION to combine and filter your data more efficiently. Whether you’re managing customer records or analyzing product sales, these techniques will optimize your SQL queries and improve… Read More

Implementing Dynamic Row-Level Security in Power BI

Are you looking to configure dynamic row-level security (RLS) in Power BI for users with different access levels? In this guide, Steve Wise walks you through setting up dynamic RLS where each user has customized permissions. For instance, one user may access the Northeast and Midwest regions, while others have access to the Southeast or… Read More

How to Calculate Working Days in Power BI Using DAX

In this tutorial, Mitchell Pearson demonstrates how to accurately calculate the number of working days within Power BI using DAX formulas. He walks through using a date table to count workdays, including how to incorporate holidays and customize weekend settings for precise business day calculations. Counting days accurately in Power BI is a foundational skill… Read More