Engineering Ergonomics

Welcome to Engineering Ergonomics. Have you ever wondered why some software engineers seem to effortlessly outperform others? The secret often lies not just in their skills, but in the environment they work in. Just like an ergonomic chair supports your posture and boosts your comfort and productivity, an ergonomically designed data platform can transform the day-to-day experiences of software engineers.

Fact Tables Demystified: A Comprehensive Guide to Transactional, Periodic, and Accumulating Snapshots in Dimensional Modeling

Dimensional modelling is a powerful tool for organising and analysing data in data warehousing and business intelligence. At the heart of dimensional modelling are fact tables, which capture business processes’ measurable, quantitative aspects. This blog post will delve into the three fundamental types of fact tables: transactional, periodic snapshot, and accumulating snapshot. Let’s explore how each type contributes to effective data analysis and decision-making. Transactional Fact Tables: Granular Insights Transactional fact tables form the backbone of dimensional models, storing the most granular detail about business events....

March 10, 2024 · 6 min · Chimezie Ezirim

Creating Reusable PySpark UDFs: A Guide to Improving Code Readability and Reuse

Introduction Apache Spark has emerged as a preeminent force in big data processing, offering unparalleled speed, ease of use, and a robust analytics toolkit. PySpark, the Python API for Spark, harnesses the simplicity of Python and the power of Apache Spark to enable rapid data analysis and processing on a massive scale. It’s the tool of choice for data scientists and engineers who need to wrangle large datasets quickly and efficiently....

January 8, 2024 · 20 min · Chimezie Ezirim

Engineering Ergonomics

Engineering Ergonomics: Crafting a Developer’s Paradise Welcome, engineers and curious minds alike! Today, we’re diving into a concept reshaping how we think about the digital workspace: Engineering Ergonomics. This term might evoke images of comfy chairs and well-lit desks, but it has nothing to do with the physical realm. What is Engineering Ergonomics? Engineering Ergonomics is the art and science of designing digital environments that are a joy for data engineers to use, maintain, and extend....

January 4, 2024 · 3 min · Chimezie Ezirim