📊 Module 4.1: Data Analysis & Portfolio Preview

🔄 AI HR Dojo Recap – Nov 24, 2025

Today’s session connected everything we’ve learned — automation, analysis, and strategy — into one unified flow. You discovered how to use AI-assisted data tools to turn raw HR data into clear insights and board-ready visuals, then previewed how to showcase it all in your AI portfolio.

What We Covered:

📈 AI-Powered Data Cleaning & Analysis

•⁠ ⁠Explored how to use Gemini (Google Sheets) and Copilot (Excel) for data cleaning and visualization.

•⁠ ⁠Learned to identify missing values, inconsistent formats, and case-sensitive data using natural-language prompts.

•⁠ ⁠Used AI to instantly clean, format, and standardize datasets (department names, termination dates, exit reasons).

•⁠ ⁠Discovered the power of prompting: “Identify before you modify.”

🧮 Hands-On Demo: Turnover Analysis Case Study

Scenario: Your Chief People Officer requests a one-page turnover summary for a board meeting.

You learned to:

1️⃣ Clean HR data (removing blanks, fixing inconsistencies).

2️⃣ Use AI to analyze turnover trends, tenure patterns, and exit reasons.

3️⃣ Auto-generate visuals like Turnover by Department and Tenure at Termination.

4️⃣ Extract key takeaways directly from Gemini or Copilot.

💬 Participant Insights:

Jessica: Learned the importance of testing one dataset at a time and using the “answer text,” not values.

Tiara: Built HR forms for onboarding, feedback, and offboarding; now finalizing routing connections.

Jess: Connected automation and coaching workflows — applying HR automation to client onboarding.

Marcus: Shared how data cleaning can be satisfying when combined with AI validation.

💡 Key Takeaway:

AI doesn’t replace HR analytics — it accelerates it. With tools like Gemini or Copilot, you can clean, analyze, and visualize HR data in minutes, freeing time to focus on the story behind the data.

🧠 Portfolio Preview: Bringing It All Together

•⁠ ⁠Introduced Gamma.app, the AI presentation and web builder tool.

•⁠ ⁠Next week, you’ll create your AI HR Portfolio Page — showcasing your chatbots, automations, and analytics dashboards.

•⁠ ⁠Your final deliverable: a shareable, interactive web portfolio that demonstrates your AI-HR mastery.

📎 All resources are available in the Classroom under Module 4.1

⏰ Office Hours:

No office hours this Friday (Thanksgiving week).

🚀 Next Session:

Monday, Dec 1, 2025 — Portfolio Building with Gamma.app

You’ve gone from building automations to interpreting insights! 🎯

0 comments