From Aviation Hardware to Data Science: Why I’m Trading Excel for R and SQL

2026-02-17 · Source: Data Science on Medium · Field: Technology & Digital — Artificial Intelligence & Machine Learning, Data Science & Analytics · Depth: Novice, quick

Summary

The author transitioned from a Reclamation Engineer at an aviation plant, Krasny Oktyabr, to pursuing a Master's in Data Science at CUNY SPS. While managing approximately 1,000 failure reports annually, the author developed manual Excel systems to track part failures and improve efficiency in a predominantly manual data collection culture. This experience highlighted the critical need for automated reporting, instant visualization, and data integrity, which are core functionalities of tools like R, Python, and SQL. The author's background in hands-on quality control, directly inspecting and verifying physical parts, provides a unique perspective on data quality, emphasizing that data labels represent tangible components and real-world issues, aligning with Data-Centric AI principles.

Key takeaway

For Data Scientists or Engineers transitioning into data roles, your direct experience with physical processes or "the metal" is a significant asset. This background enables you to intuitively grasp data quality issues and their real-world implications, a perspective crucial for building robust, effective AI models. Embrace this unique understanding to drive better data-centric solutions.

Key insights

Hands-on experience with physical systems provides a critical advantage in understanding data quality for Data Science.

Principles

• Data quality limits model effectiveness.
• Automate reporting for efficiency and integrity.

In practice

• Transition from manual Excel to R, Python, SQL.
• Apply shop floor discipline to data engineering.

Topics

• Data Science Career Path
• Data Quality
• Data-Centric AI
• Manufacturing Analytics
• Data Management Challenges

Best for: Data Scientist, AI Student, General Interest

Related on AIssential

• What Data Modeling Is and Is Not — Effective data modeling is crucial for business operations, preventing data disasters, and enabling both human and machine decision-making.
• Software and ops skills for data scientists[D] — The data science industry increasingly demands software development and operations skills for career longevity and deeper AI engagement.
• Why Data Cleaning Takes Longer Than the Model In AI — High-quality data preparation is more critical for machine learning success than complex algorithms.
• Navigating Common Pitfalls in Data Science: Lessons from Pierpaolo Hipolito - ML 183 — Understanding data paradoxes and causal reasoning is crucial for building accurate and interpretable machine learning models.
• Data scientists: Powering the future of AI and analytics — The data scientist role spans the entire ML lifecycle, facing challenges mitigated by unified platforms and evolving with AI agents.
• Data Modeling is Dead (Again), 2026 Edition. Part 2 — AI-generated data models often lack critical operational context, leading to "leaky abstractions" and hidden complexity.

Open in AIssential →

Editorial summary, takeaway, and curation by AIssential. Original article published by Data Science on Medium.