---
title: "Jogleen Calipon (@Jworkz) | Hashnode"
description: "Power Query and Power Pivot Specialist. Read the latest articles by Jogleen Calipon on Hashnode."
url: "https://hashnode.com/@Jworkz"
---

@Jworkz

# Jogleen Calipon

@Jworkz · Calabarzon, Philippines · Joined July 2024

Power Query and Power Pivot Specialist

### [Case Study: HR Analytics](https://power-bi-projects.hashnode.dev/case-study-hr-analytics?utm_source=hashnode&utm_medium=feed)

Summary: Leveraging Power BI, Power Query, and DAX, I developed an end-to-end HR reporting solution for Atlas Labs, a fictitious software firm. This project involved transforming raw HR datasets into

5 min read · [power-bi-projects.hashnode.dev](https://power-bi-projects.hashnode.dev/case-study-hr-analytics?utm_source=hashnode&utm_medium=feed)

[Mar 14](https://hashnode.com/posts/case-study-hr-analytics/69b5321f210c74252fdc1e83)

### [Actual vs Budget Report](https://financialreports.hashnode.dev/actual-vs-budget-report?utm_source=hashnode&utm_medium=feed)

A Dynamic Dashboard in Excel using Power Query, Power Pivot, DAX, and Cube Functions

16 min read · [financialreports.hashnode.dev](https://financialreports.hashnode.dev/actual-vs-budget-report?utm_source=hashnode&utm_medium=feed)

[Sep 13, 2025](https://hashnode.com/posts/actual-vs-budget-report/68c543716f9cbd810972dec9)

### [Enhanced Sales Insights with a Dashboard Built on Power Pivot and DAX](https://excel-analysis.hashnode.dev/enhanced-sales-insights-with-a-dashboard-built-on-power-pivot-and-dax?utm_source=hashnode&utm_medium=feed)

Discover how to enhance sales insights using Power Pivot and DAX for effective data modeling, dashboard creation, and KPI analysis

7 min read · [excel-analysis.hashnode.dev](https://excel-analysis.hashnode.dev/enhanced-sales-insights-with-a-dashboard-built-on-power-pivot-and-dax?utm_source=hashnode&utm_medium=feed)

[May 7, 2025](https://hashnode.com/posts/enhanced-sales-insights-with-a-dashboard-built-on-power-pivot-and-dax/681b0f620871568a9f76c64d)

### [Inventory Data Management Through Automation](https://excel-guides.hashnode.dev/inventory-data-management-through-automation?utm_source=hashnode&utm_medium=feed)

Automate inventory management in Excel for accurate data consolidation and streamlined processes with our guide

2 min read · [excel-guides.hashnode.dev](https://excel-guides.hashnode.dev/inventory-data-management-through-automation?utm_source=hashnode&utm_medium=feed)

[Mar 1, 2025](https://hashnode.com/posts/inventory-data-management-through-automation/67c30a1fb3477a09a142027d)

### [Adventure Works Bike Shop: Sales Performance Analysis](https://excel-analysis.hashnode.dev/adventure-works-bike-shop-sales-performance-case-study?utm_source=hashnode&utm_medium=feed)

Explore how Adventure Works Bike Shop boosts sales with end-to-end data analytics using Power Query and Power Pivot for insightful dashboards

6 min read · [excel-analysis.hashnode.dev](https://excel-analysis.hashnode.dev/adventure-works-bike-shop-sales-performance-case-study?utm_source=hashnode&utm_medium=feed)

[Nov 14, 2024](https://hashnode.com/posts/adventure-works-bike-shop-sales-performance-case-study/673600dbdb58625c80bf10be)
