Essential Guideline for Integrating Power Apps with SQL Server

Power Apps has emerged as a powerful platform for building low-code applications, particularly for organizations already using Microsoft 365. Whether you’re looking to simplify data entry, automate workflows, or build lightweight internal apps, Power Apps can connect seamlessly with various data sources—including Excel, SharePoint Lists, and SQL Server tables. Before you dive in, it’s important… Read More

How to Build a Basic PowerApp Using a SQL Server Table

If you’ve ever wanted to quickly build an internal app to communicate or write data back to a simple database—like tracking sales quotas or performance reviews—PowerApps makes it straightforward. In this first installment of our Power Platform Pro Series, we demonstrate how fast and easy it is to create a simple app by connecting PowerApps… Read More

Introduction to Azure Common Data Service (CDS)

Are you familiar with Azure Common Data Service? Today, I want to introduce you to this powerful platform recently enhanced by Microsoft to better support business app development. Azure Common Data Service (CDS) is a cloud-based application platform designed to help you build, manage, and extend business applications with ease using your organization’s data. How… Read More

Comprehensive Power Apps Licensing Guide: Choosing the Right Plan for You

Choosing the right Power Apps license is a common question among users and organizations adopting this powerful low-code platform. In this detailed video guide, I walk you through the various Power Apps licensing options to help you make an informed decision. Licensing terms and prices can change, so it’s always best to consult your Microsoft… Read More

Mastering Power BI Custom Visuals: The Percentile Chart

In this lesson, you will explore how to use the Percentile Chart, a powerful custom visual in Power BI. This chart type is designed to display the distribution of values across a range, helping answer vital business questions like, “What percentage of my customers purchased 4 or more items?” Comprehensive Guide to the Percentile Chart… Read More

Introduction to Power BI Custom Visuals: The Sunburst Chart

In this tutorial, you will discover how to effectively utilize the Power BI Custom Visual called Sunburst. The Sunburst chart expands upon the traditional donut chart by allowing the display of multiple hierarchical levels simultaneously. This makes it an excellent choice for visualizing data with nested categories. Discovering the Power of the Sunburst Chart in… Read More

Power BI Beginner to Pro Series Part 1: Effective Data Planning and Design

In a recent insightful “Learn with the Nerds” session, Devin Knight and the team took attendees on a comprehensive journey from Power BI beginner to expert. This latest session introduced new datasets and fresh content, making it valuable even for those familiar with prior training. Why Power BI is the Optimal Solution for Your Data… Read More

Understanding Grouping and Binning in Power BI: A Beginner’s Guide

When you start working with Power BI, one of the first challenges you’ll encounter is managing large datasets with numerous distinct values. Grouping and binning are two fundamental techniques that help transform raw data into meaningful categories, making it easier to identify patterns and trends. These methods allow you to organize your data in ways… Read More

Step-by-Step Guide to Setting Up PolyBase in SQL Server 2016

Thank you to everyone who joined my recent webinar! In that session, I walked through the entire process of installing SQL Server 2016 with PolyBase to enable Hadoop integration. To make it easier for you, I’ve summarized the key steps here so you can follow along without needing to watch the full video. How to… Read More

Mastering the Quadrant Chart Custom Visual in Power BI

In this training module, you’ll learn how to leverage the Quadrant Chart custom visual in Power BI. This chart type is perfect for illustrating data distribution across four distinct quadrants, helping you analyze and categorize complex datasets effectively. Comprehensive Introduction to Module 63 – Exploring the Quadrant Chart in Power BI Module 63 offers an… Read More

Unlocking Enterprise Potential with Power BI XMLA Endpoint

Power BI XMLA Endpoint is a revolutionary feature for Power BI Premium users that transforms how businesses can leverage the Power BI platform. This capability enables organizations to treat Power BI as a robust, enterprise-scale service rather than just a self-service analytics tool. Unlocking Enterprise Power with the Power BI XMLA Endpoint Power BI has… Read More

Understanding Parameter Passing Changes in Azure Data Factory v2

In mid-2018, Microsoft introduced important updates to parameter passing in Azure Data Factory v2 (ADFv2). These changes impacted how parameters are transferred between pipelines and datasets, enhancing clarity and flexibility. Before this update, it was possible to reference pipeline parameters directly within datasets without defining corresponding dataset parameters. This blog post will guide you through… Read More

Introduction to Azure Data Factory’s Get Metadata Activity

Welcome to the first installment in our Azure Data Factory blog series. In this post, we’ll explore the Get Metadata activity, a powerful tool within Azure Data Factory (ADF) that enables you to retrieve detailed information about files stored in Azure Blob Storage. You’ll learn how to configure this activity, interpret its outputs, and reference… Read More

Your Journey to Becoming a Certified Azure Data Engineer Begins with DP-203

The demand for skilled data engineers has never been higher. As organizations transition to data-driven models, the ability to design, build, and maintain data processing systems in the cloud is a critical business need. This is where the Data Engineering on Microsoft Azure certification, known as DP-203, becomes essential. It validates not just familiarity with… Read More

The Cybersecurity Architect Role Through SC-100 Certification

In today’s increasingly complex digital landscape, cybersecurity is no longer just a component of IT strategy—it has become its very foundation. As organizations adopt hybrid and multi-cloud architectures, the role of the cybersecurity architect has grown more strategic, intricate, and business-aligned. The SC-100 certification was created specifically to validate and recognize individuals who possess the… Read More