Data Modeling Archives - PK: An Excel Expert

KANBAN Board with Power Pivot and VBA for Project Management

May 2, 2023April 14, 2024 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 6, 2024 PKComments Off

In this article, we have explained how to use calculated column in Power Pivot Data Model. We have taken the example of Orders data wherein we have product level Unit

Power Pivot Charts and Visualization

Drill Down/Drill Up Feature in Pivot Chart

January 6, 2020October 5, 2024 PKComments Off

In this article, we have created a Drill Down/Drill Up Feature functionality in a Pivot chart. We have created a hierarchy in Power Pivot data model to create this. Below are

Power Pivot

Create Relationship in Power Pivot

January 3, 2020October 5, 2024 PKComments Off

In this article, we have explained, how to create relationship in Power Pivot data model. We have taken 2 dimension table and once fact table. What is Power Pivot? Power