Data Modeling Archives

KANBAN Board with Power Pivot and VBA for Project Management

May 2, 2023May 2, 2023 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, 2020January 9, 2020 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

Charts and Visualization Power Pivot

Drill Down/Drill Up Feature in Pivot Chart

January 6, 2020January 6, 2020 PKComments Off

In this article, we have created a drill down/drill up 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, 2020January 3, 2020 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