Power Pivot 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

Templates

Dynamic Attendance Sheet Using Power Pivot

February 20, 2023February 20, 2023 PKComments Off

Introduction In today's digital age, managing attendance in schools, colleges, or offices is a time-consuming task. This dynamic attendance sheet can help streamline this process by providing real-time attendance data

Data Transformation to create Comma Separated List automatically

Excel Tips and Tricks Power Pivot

Automatically Creating Employee-wise Skill Set Lists

December 12, 2022March 8, 2023 PKComments Off

Data transformation is an important aspect of data analysis and is often used to manipulate data in a way that suits our needs. One such manipulation is creating comma-separated lists

Dashboard Power Pivot

Comparative Analysis Dashboard in Excel

June 20, 2021June 20, 2021 PKComments Off

This is the Excel version of the Comparative Analysis Dashboard. We have used Power Pivot to create this dashboard. We have used Current Year Sales Vs Previous Year Same Period

Charts and Visualization Power Pivot Templates

Power Gantt Chart (Project Planner) for Project Management

October 11, 2020October 11, 2020 PKComments Off

In the article, we have created the Powerful Gantt Chart (Project Planner) for Project Management in Microsoft Excel with Power Pivot. You can use this template for your Project Management

Power Pivot

KPI in Power Pivot for dashboard and report

January 15, 2020January 15, 2020 PKComments Off

Key performance indicators (KPIs) are visual measures of performance. Based on a specific calculated field, a KPI is designed to help users quickly evaluate the current value and status of

Power Pivot

SUMX Function in Power Pivot

January 13, 2020January 13, 2020 PKComments Off

In this article, we have explained how to use Measure in Pivot Pivot data model. We have taken the example of SUMX function to calculate the revenue. On the base

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