Power Pivot

This category offers detailed tutorials on using Power Pivot to build powerful data models and perform complex data analysis tasks in Excel. From importing and organizing data to creating relationships between tables and writing advanced DAX, our tutorials cover a range of topics to help you work more efficiently with large datasets. Each tutorial comes with a free practice file for download and tutorial videos to help you understand the concepts better. Start exploring this category now and take your Excel skills to the next level. Impress your colleagues and boss with your proficiency in Power Pivot by exploring this category today.

Power Pivot Charts and Visualization Templates

Power Gantt Chart (Project Planner) for Project Management

October 11, 2020February 20, 2025 PKComments Off

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

Power Pivot Charts and Visualization

Smart Chart with Laptop Shape in Excel

May 3, 2020March 3, 2025 PKComments Off

In this article, we have created a beautiful and smart chart with Conditional formatting in Microsoft Excel. We have create a laptop shape also using Excel shapes. We have placed

Power Pivot VBA

Email Data Consolidation Tool in Excel

April 26, 2020February 25, 2025 PKComments Off

Now a days businesses rely more heavily on email communication. Managing data from multiple sources can become a real challenge. Fortunately, there is a solution: an email data consolidation tool

Power Pivot Dashboard

Fully Automated Excel dashboard with multiple source files

April 12, 2020February 18, 2025 PKComments Off

In this article, we have create a full automatic excel dashboard with multiple excel source files. Each source file can have multiple worksheets. For data consolidation we have used Power

Power Pivot VBA

User level security in Excel Workbook for different worksheets

April 5, 2020October 8, 2024 PKComments Off

In this article, we have created User level security in Excel workbook. If you have multiple worksheets in your excel file and you want to protect/hide the data according to

Power Pivot

KPI in Power Pivot for dashboard and report

January 15, 2020October 7, 2024 PKComments Off

Key performance indicators (KPIs) are visual measures of performance. Based on a specific calculated field, a KPI in Power Pivot for dashboard is designed to help users quickly evaluate the

Power Pivot

SUMX Function in Power Pivot

January 13, 2020October 6, 2024 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, 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