---
title: "Discussion on \"Case Study: HR Analytics\" | Hashnode"
description: "Discussion on \"Case Study: HR Analytics\". Summary:\nLeveraging 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"
url: "https://hashnode.com/posts/case-study-hr-analytics/69b5321f210c74252fdc1e83"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [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

Mar 14 · 5 min read · power-bi-projects.hashnode.dev  
Updated Mar 16  
Read the article

## Written by

[Jogleen Calipon](https://hashnode.com/@Jworkz)

@Jworkz · Calabarzon, Philippines

  
[View profile](https://hashnode.com/@Jworkz)

Power Query and Power Pivot Specialist

📊 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 | 𝗣𝗼𝘄𝗲𝗿 𝗦𝘂𝗶𝘁𝗲 𝗦𝗽𝗲𝗰𝗶𝗮𝗹𝗶𝘀𝘁 𝗧𝗿𝗮𝗻𝘀𝗳𝗼𝗿𝗺𝗶𝗻𝗴 𝗿𝗮𝘄 𝗱𝗮𝘁𝗮 𝗶𝗻𝘁𝗼 𝗮𝘂𝘁𝗼𝗺𝗮𝘁𝗲𝗱 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗶𝗻𝘁𝗲𝗹𝗹𝗶𝗴𝗲𝗻𝗰𝗲. I am a Data Analyst with 4+ years of experience specializing in the Microsoft ecosystem. I bridge the gap between messy data and executive decisions. ────────────── 💎 𝗖𝗼𝗿𝗲 𝗦𝗽𝗲𝗰𝗶𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻𝘀 ➤ 1. Advanced Power Query (ETL) Expert at cleaning &amp; enriching datasets in Excel &amp; Power BI. Building "one-click" refresh workflows. ➤ 2. Modeling &amp; DAX (Power Pivot) Designing robust data models and applying DAX for KPIs &amp; Time-Intelligence. ➤ 3. Strategic Visualization Developing interactive Power BI dashboards with actionable storytelling for decision-makers. ────────────── 🛠️ 𝗧𝗲𝗰𝗵𝗻𝗶𝗰𝗮𝗹 𝗧𝗼𝗼𝗹𝗸𝗶𝘁 (Foundational) • Databases: SQL Server (SSMS), MySQL, BigQuery, MS Access. • Coding: Python (Pandas/NumPy), R (ggplot2).

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
