Data Modeling Archives - PK: An Excel Expert

KANBAN Board with Power Pivot and VBA for Project Management

May 2, 2023February 21, 2025 PKComments Off

In today's fast-paced business environment, effective project management is essential for achieving success. One tool that has gained significant popularity in recent years is the KANBAN board. In this comprehensive

Power Pivot

Calculated Column in Power Pivot: LOOKUPVALUE vs RELATED

January 9, 2020October 9, 2026 PKComments Off

A calculated column in Power Pivot adds a new field to a data model table, computed row by row with a DAX formula. In this tutorial you have an Orders

Power Pivot Charts and Visualization

Drill Down in Pivot Chart with Power Pivot Hierarchy in Excel

January 6, 2020October 9, 2026 PKComments Off

A drill down in a Pivot Chart lets you start with a big-picture chart and double-click any slice to see what is inside it, level by level. In this tutorial

Power Pivot

Create Relationship in Power Pivot: Build a 3-Table Data Model

January 3, 2020October 9, 2026 PKComments Off

To create a relationship in Power Pivot, you add each table to the Excel Data Model and then link a column in one table to the matching column in another,