Scribd
Upload
40 views2 pages

60 Day Data Analytics Roadmap

The document outlines a 60-day roadmap for HR professionals to enhance their data analytics skills using Excel, SQL, and Power BI. It includes a week-by-week checklist of topics, free learning resources, and project ideas to build practical experience. The final weeks focus on capstone projects and portfolio building, along with suggestions for certifications to complete.

Uploaded by

sunnyrock2107
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
40 views2 pages

60 Day Data Analytics Roadmap

The document outlines a 60-day roadmap for HR professionals to enhance their data analytics skills using Excel, SQL, and Power BI. It includes a week-by-week checklist of topics, free learning resources, and project ideas to build practical experience. The final weeks focus on capstone projects and portfolio building, along with suggestions for certifications to complete.

Uploaded by

sunnyrock2107
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

60-Day Data Analytics Roadmap (Checklist Format – HR-Focused)

Target Audience: HR professionals | Tools: Excel, SQL, Power BI | Goal: Become job-ready using free
resources

WEEK 1-2: Excel (Advanced + Power Query + Macros)

Topics to Cover: - [ ] Master XLOOKUP , INDEX-MATCH , TEXTJOIN , INDIRECT - [ ] Use Data


Validation, Conditional Formatting for HR use cases - [ ] Build Dashboards using Pivot Tables, Slicers,
Timelines - [ ] Learn Power Query for data cleaning & transformation - [ ] Automate tasks using VBA
Macros (Salary slip, Leave tracker)

📚 Free Learning: - [ ] Excel Exposure / ExcelJet / Chandoo.org / Leila Gharani (YT) - [ ] Great Learning
Excel Course - [ ] Coursera Excel Skills for Business (Audit)

Projects: - [ ] HR Attrition Dashboard - [ ] Salary Slip Automation with VBA - [ ] Leave Management &
Recruitment Tracker

WEEK 3-4: SQL (Intermediate to Advanced)

Topics to Cover: - [ ] Practice Joins, Subqueries, CTEs, Window Functions - [ ] Aggregate, Date
Functions, Data Cleaning - [ ] Create Views & Stored Procedures

📚 Free Learning: - [ ] Kaggle SQL - [ ] SQLZoo, LeetCode SQL - [ ] Mode SQL, HackerRank SQL

Projects: - [ ] HR Exit & Tenure SQL Report - [ ] Recruitment Funnel Dashboard in SQL - [ ] Finance
Expense Analysis with Queries - [ ] Retail Store Sales using Grouped Analysis

WEEK 5-6: Power BI (HR Analytics + Finance/Sales Dashboards)

Topics to Cover: - [ ] Connect to Excel/SQL via Power Query - [ ] Understand Model, Relationships, DAX
Measures - [ ] Time Intelligence: YoY, MoM, Cumulative Totals - [ ] Drillthrough, Bookmarks, UX features -
[ ] Publish via Power BI Service

📚 Free Learning: - [ ] Microsoft Learn - Power BI - [ ] Guy in a Cube (YouTube) - [ ] Great Learning –
Power BI

Projects: - [ ] HR Dashboard: Exit, Diversity, Headcount - [ ] Sales Dashboard: Actual vs Target - [ ]


Finance Dashboard: Expense & Budget - [ ] Employee Lifecycle Visual Report

1
WEEK 7-8: Capstone + Portfolio Building

Final Projects: - [ ] End-to-End HR Dashboard (Cost, Performance) - [ ] Retail Store Performance Report
- [ ] Employee Engagement Survey Analytics - [ ] Budget vs Actual (Finance BI Dashboard)

📦 Upload Portfolio To: - [ ] GitHub – Code/Excel Models - [ ] Power BI Service – Interactive Dashboards -
[ ] Tableau Public (optional)

🎓 Final Certifications (Free to Audit): - [ ] Google Data Analytics - [ ] IBM Data Analytics – edX

Would you also like this in printable calendar format or with daily study hour breakdown?

You might also like