PyCon India 2025

Breaking Down Data Silos: Enterprise Data Automation with Python on Azure
2025-09-13 , Track 3

Tired of data silos and manual Excel reports? Discover how we leveraged Python and Azure Data Lake to build a central data platform, integrating 20+ systems and automating 500+ reports. Learn practical strategies for achieving a single source of truth and empowering data-driven decisions across your enterprise.


  • The Pain Point: Life Before Centralization

Illustrating the challenges of data silos and manual reporting.
Highlighting the inefficiencies and inconsistencies of relying on disparate Excel reports.
Emphasizing the lack of a single source of truth and its impact on decision-making.

  • The Azure and Python Solution: Our Journey

Introducing the strategic decision to adopt Azure Data Lake.
Explaining the rationale behind choosing Python as the primary application language.
Showcasing the initial architecture and key components of the data platform.

  • Building the Central Nervous System: Integrating 20+ Systems

Discussing the challenges and solutions involved in connecting diverse enterprise systems.
Highlighting the role of Python libraries and Azure services in data ingestion and transformation.
Providing examples of the types of systems integrated (e.g., ERP, Internal Applications, other tools).

  • Democratizing Data: Automating 500+ Reports

Explaining the process of building automated reporting pipelines with Python.
Showcasing the tools and techniques used for data visualization and delivery.
Illustrating the impact of centralizing and automating report generation across departments.

  • The Tangible Benefits: A Data-Driven Transformation

Quantifying the impact of the centralized data platform (e.g., time savings, improved accuracy, faster decision-making).
Discussing the cultural shift towards data-driven decision-making within the company.
Sharing lessons learned and best practices for implementing similar solutions.

  • Looking Ahead: Future Scalability and Innovation

Briefly outlining future plans for the data platform on Azure.
Discussing potential advancements and new use cases leveraging Python.
Open Q&A.


Prerequisites

None. Interests around enterprise data, central reporting, and Business Intelligence

Target Audience

Intermediate

Hi I`m Aakash. A seasoned Analytics Lead and Data Professional with over 8 years at Nagarro, currently a Staff Consultant. Proven expertise in building and leading data initiatives, particularly in enterprise data integration on Microsoft Azure Data Lake and leveraging Python for automation. Successfully transitioned organizations from data silos to centralized, data-driven environments, managing large-scale reporting and contributing to strategic decision-making with CXOs.