How debopriya-ai/ibm-hr-analytics works
Project type and purpose
• This is a BI/data-visualization project built in Tableau. Its purpose is to ingest HR data, run simple preprocessing (Excel/CSV), and surface interactive dashboards for attrition, job satisfaction, and demographics.
File structure
• Top-level files:
• ASSIGNMENT 2 DATA 1205_Final (1).pptx – a presentation export of key findings
• HR Data.zip – raw HR dataset (Excel or CSV)
• HR_Analytics_Dashboard_Tableau (1).twbx – the packaged Tableau workbook containing data extracts, dashboards, and visuals
• LICENSE, README.md – documentation
• There is no multi-tier codebase; it follows a simple data pipeline: raw data → preprocessing → Tableau workbook → presentation.
README for additional insights
• Confirms:
• Data volume: 1,470 employee records
• Key analyses: attrition, satisfaction, education
• Tools: Tableau for visualization; Excel/CSV for preprocessing
• Business impact metrics
Main components
a. Data Sources
– Excel/CSV files in HR Data.zip
b. Data Preprocessing Layer
– Ad-hoc transforms in Excel (cleanup, pivoting)
c. Tableau Desktop/Engine
– Connects to extracts, builds visualizations
– Twbx packaged workbook holds data extract + dashboard definitions
d. Tableau Server (optional) or File Distribution
– .twbx published to Server or shared directly
e. Presentation Layer
– PPTX slide deck for stakeholders
f. Consumers
– HR analysts, managers viewing dashboards in Tableau Reader/Server or PPT
Architectural patterns and design principles
• Simple ETL pipeline pattern (Extract→Transform→Load)
• Single-source of truth via packaged Twbx extract
• Separation of concerns:
• Data layer (raw files)
• Processing layer (Excel)
• Visualization layer (Tableau)
• Delivery layer (Server/Slides)
Relevant technologies
• Data: CSV/Excel
• ETL: Excel manual transforms or lightweight scripts (if any)
• BI tool: Tableau Desktop / Server / Reader
• Presentation: PowerPoint