DATA ANALYTICS MUST KNOWS

Project information

A notebook showcasing essential analytics questions and data manipulation techniques for a business (HR) scenario from JSON data. All questions are solved using the most popularly used languages and tools: Python-Pandas, PostgreSQL, and PySpark. Concepts used include merging/joining tables, ranking, window functions, aggregations, pivot tables, and dynamic row generation.