---
title: Data Basics for Life-Long Software Engineers
description: "Having recently made the switch from software to data engineering, I learned\nthere are many new concepts and ideas that need to be picked up and understood\nquickly. Such concepts include things like Data Lakes, Data Warehouses, and Data\nModeling. In this blog, I will give a basic introduction to"
image: https://blog.ippon.tech/hubfs/Imported_Blog_Media/Data-Basics-for-Life-Long-Software-Engineers-3.png
---

[Skip to main content](https://blog.ippon.tech/data-basics-for-life-long-software-engineers#main)

[![IpponLogoKleinBlue](https://blog.ippon.tech/hs-fs/hubfs/IpponLogoKleinBlue.png?width=219&height=64&name=IpponLogoKleinBlue.png) ![IpponLogoKleinBlue](https://blog.ippon.tech/hs-fs/hubfs/IpponLogoKleinBlue.png?width=219&height=64&name=IpponLogoKleinBlue.png) ![IpponLogoKleinBlue](https://blog.ippon.tech/hs-fs/hubfs/IpponLogoKleinBlue.png?width=168&height=49&name=IpponLogoKleinBlue.png) ![IpponLogoKleinBlue](https://blog.ippon.tech/hs-fs/hubfs/IpponLogoKleinBlue.png?width=168&height=49&name=IpponLogoKleinBlue.png)](https://ipponusa.com/)

- [Home](https://ipponusa.com)
- [Show submenu for About About](https://ipponusa.com/about-us) 
    - [Who We Are](https://ipponusa.com/who-we-are)
    - [Careers](https://ipponusa.com/careers)
    - [Show submenu for Our Partners Our Partners](https://ipponusa.com/our-partners/) 
          - [AWS](https://ipponusa.com/our-partners/aws/)
          - [Snowflake](https://ipponusa.com/our-partners/snowflake/)
          - [Databricks](https://ipponusa.com/our-partners/databricks/)
          - [Microsoft](https://ipponusa.com/our-partners/microsoft/)
- [Show submenu for Services Services](https://ipponusa.com/services) 
    - [Snowflake](https://ipponusa.com/service/snowflake-concierge/)
    - [Artificial Intelligence](https://ipponusa.com/service/artificial-intelligence/)
    - [Data & Analytics](https://ipponusa.com/service/data-analytics/)
    - [Cloud Strategy](https://ipponusa.com/service/cloud-strategy/)
    - [Platform Modernization](https://ipponusa.com/service/platform-moderization/)
    - [Product Innovation](https://ipponusa.com/service/product-innovation/)
    - [Operating Model](https://ipponusa.com/service/operating-model/)
- [Blogs](https://blog.ippon.tech/)
- [Success Stories](https://ipponusa.com/success-stories/)
- [Show submenu for Resources Resources](https://ipponusa.com/resources/) 
    - [eBooks](https://ipponusa.com/ebooks/)
    - [The Data Pour](https://info.ippon.tech/the-data-pour)
    - [Videos & Webinars](https://info.ippon.tech/videos-and-webinars)
    - [Media Center](https://ipponusa.com/media-center/)

Search

Open main navigation

Close main navigation

- [Home](https://ipponusa.com)
- Show submenu for About About 
  
    - About
    - [About](https://ipponusa.com/about-us)
    - [Who We Are](https://ipponusa.com/who-we-are)
    - [Careers](https://ipponusa.com/careers)
    - Show submenu for Our Partners Our Partners 
      
          - Our Partners
          - [Our Partners](https://ipponusa.com/our-partners/)
          - [AWS](https://ipponusa.com/our-partners/aws/)
          - [Snowflake](https://ipponusa.com/our-partners/snowflake/)
          - [Databricks](https://ipponusa.com/our-partners/databricks/)
          - [Microsoft](https://ipponusa.com/our-partners/microsoft/)
- Show submenu for Services Services 
  
    - Services
    - [Services](https://ipponusa.com/services)
    - [Snowflake](https://ipponusa.com/service/snowflake-concierge/)
    - [Artificial Intelligence](https://ipponusa.com/service/artificial-intelligence/)
    - [Data & Analytics](https://ipponusa.com/service/data-analytics/)
    - [Cloud Strategy](https://ipponusa.com/service/cloud-strategy/)
    - [Platform Modernization](https://ipponusa.com/service/platform-moderization/)
    - [Product Innovation](https://ipponusa.com/service/product-innovation/)
    - [Operating Model](https://ipponusa.com/service/operating-model/)
- [Blogs](https://blog.ippon.tech/)
- [Success Stories](https://ipponusa.com/success-stories/)
- Show submenu for Resources Resources 
  
    - Resources
    - [Resources](https://ipponusa.com/resources/)
    - [eBooks](https://ipponusa.com/ebooks/)
    - [The Data Pour](https://info.ippon.tech/the-data-pour)
    - [Videos & Webinars](https://info.ippon.tech/videos-and-webinars)
    - [Media Center](https://ipponusa.com/media-center/)
- Search
- [Contact Us](https://ipponusa.com/contact/)

[Contact Us](https://ipponusa.com/contact/)

# Data Basics for Life-Long Software Engineers

![Hector Sanchez](https://app.hubspot.com/settings/avatar/d41d8cd98f00b204e9800998ecf8427e)

 by [Hector Sanchez](https://blog.ippon.tech/author/hector-sanchez)

January 6, 2022

![Data Basics for Life-Long Software Engineers](https://blog.ippon.tech/hubfs/Imported_Blog_Media/Data-Basics-for-Life-Long-Software-Engineers-3.png)

[Azure](https://blog.ippon.tech/tag/azure/) [Big Data](https://blog.ippon.tech/tag/big-data/) [Data Engineering](https://blog.ippon.tech/tag/data-engineering/) [Software Engineering](https://blog.ippon.tech/tag/software-engineering/) [Data](https://blog.ippon.tech/tag/data/)

*Published January 6, 2022*

 

Having recently made the switch from software to data engineering, I learned there are many new concepts and ideas that need to be picked up and understood quickly. Such concepts include things like Data Lakes, Data Warehouses, and Data Modeling. In this blog, I will give a basic introduction to each of these concepts from a high level, giving those new to the data world, like myself, a nice springboard into learning more about these topics.

### Data Lakes, Data Warehouses, and The Process

Now from a high level view, a Data Lake can be considered a repository for raw, unreformed data, whereas a Data Warehouse is a repository for processed, ready-for-production data. In the diagram below, we can see that the Data Lake can receive data from a number of sources. In this specific case, databases -- which will then be available for Data Engineers to study, analyze, and manipulate (more on that in a bit).

![model\_1](https://blog.ippon.tech/hubfs/Imported_Blog_Media/data_basics_1-2.png)

Near the tail end of the process, we see the Data Warehouse which houses data ready to be used by real world users, not just Data Engineers. As we can see, end users utilizing tools like Excel and Power BI can use this data in their work. But how do we get there? That’s where Data Modeling comes into play.

### Data Modeling

At its most basic, Data Modeling is the process we use to visualize and represent data that will be stored within our Data Warehouse. This will include studying and understanding the data we will be working with and discovering the relationships between this data, all while working towards creating data models that will be useful to the end user.

At this point, we can use a simple example to better illustrate the concept.

Suppose you have been tasked with analyzing school data with the end user wanting to run reports to see how students are doing with their assessments, among other things. One of the first steps would be to look at the available data and begin to understand what it represents and how it can be related to each other to help enrich it.

Within the database we find an 'Assessments' table that seems to have some information that will be useful to the end user:

![model\_2](https://blog.ippon.tech/hubfs/Imported_Blog_Media/data_basics_2-2.png)

In looking at this data, we notice there is a subject\_id which appears to correlate with the id within the 'Subjects' table:

![model\_3](https://blog.ippon.tech/hubfs/Imported_Blog_Media/data_basics_3-2.png)

We seem to have found a useful relationship between these individual tables! This association can be seen below:

![model\_4](https://blog.ippon.tech/hubfs/Imported_Blog_Media/data_basics_4-2.png)

Finding these relationships is at the heart of Data Modeling. What we have done is made the data more useful, valuable, and meaningful to the end user who will be using this in their daily reporting. We can use this same methodology to continue to find meaningful relationships within the data to further enhance it, but for the sake of simplicity, we will leave our Data Modeling here.

At the end of this process, we now have a new table that we can call ready-for-production and will live in our Data Warehouse.

![model\_5](https://blog.ippon.tech/hubfs/Imported_Blog_Media/data_basics_5-2.png)

### Conclusion

As mentioned before this is just the tip of the iceberg when it comes to each of these topics. Even so, as a long-time Software Engineer that has only recently made the jump to Data Engineering and now has a completed data project under his belt, this is high-level information that would have been invaluable to have known going into it. I would imagine that any other life-long Software Engineer's thinking about making the switch into the world of data would probably agree.

## Related Articles

##### [![RVATechData + AI Summit: My First Conference Experience](https://blog.ippon.tech/hs-fs/hubfs/undefined-Apr-16-2026-01-30-35-4343-PM.png?width=520&height=294&name=undefined-Apr-16-2026-01-30-35-4343-PM.png) Data • April 16, 2026 RVATechData + AI Summit: My First Conference Experience 4 min read](https://blog.ippon.tech/rvatechdata-ai-summit-my-first-conference-experience)

##### [![The Evolution of AI : Part Two](https://blog.ippon.tech/hs-fs/hubfs/Ippon%20copy.png?width=520&height=294&name=Ippon%20copy.png) Data • July 1, 2025 The Evolution of AI : Part Two 4 min read](https://blog.ippon.tech/the-evolution-of-ai-part-two)

##### [![Data Management in the Age of Generative AI](https://blog.ippon.tech/hs-fs/hubfs/Ippon-2.png?width=520&height=294&name=Ippon-2.png) Data • June 25, 2025 Data Management in the Age of Generative AI 7 min read](https://blog.ippon.tech/data-management-in-the-age-of-generative-ai)

### Comments

### Subscribe to Our Blog!

Stay informed with the latest insights and updates by signing up for our weekly blog newsletter – delivered straight to your inbox!

[Back to blog homepage »](https://blog.ippon.tech/)

![IpponLogoKleinBlue](https://blog.ippon.tech/hs-fs/hubfs/IpponLogoKleinBlue.png?width=247&height=73&name=IpponLogoKleinBlue.png "IpponLogoKleinBlue")

Ippon is a consulting and expertise firm, who is convinced that technology is a source of progress for society. We help our clients leverage their digital assets to design an appropriate strategy and deploy their transformation roadmap at scale.

#### Navigation

- [Home](https://ipponusa.com/)
- [About](https://ipponusa.com/about-us/)
- [Services](https://ipponusa.com/services/)
- [Blogs](https://blog.ippon.tech/?__hstc=223043268.1036d82247623b329dfefe4e92697801.1714729179243.1714729179243.1714729179243.1&__hssc=223043268.2.1714729179244&__hsfp=803678701)
- [eBooks](https://ipponusa.com/ebooks/)
- [The Data Pour](https://info.ippon.tech/the-data-pour?__hstc=223043268.1036d82247623b329dfefe4e92697801.1714729179243.1714729179243.1714729179243.1&__hssc=223043268.2.1714729179244&__hsfp=803678701)

[Contact Us](https://ipponusa.com/contact/)

[Join Us](https://ipponusa.com/careers/)

#### Services

- [Data & Analytics](https://ipponusa.com/service/data-analytics/)
- [Cloud Strategy](https://ipponusa.com/service/cloud-strategy/)
- [Artificial Intelligence](https://ipponusa.com/service/artificial-intelligence/)
- [Operating Model](https://ipponusa.com/service/operating-model/)
- [Platform Modernization](https://ipponusa.com/service/platform-moderization/)
- [Product Innovation](https://ipponusa.com/service/product-innovation/)

#### Ippon International

- [France](https://fr.ippon.tech/?__hstc=223043268.1036d82247623b329dfefe4e92697801.1714729179243.1714729179243.1714729179243.1&__hssc=223043268.2.1714729179244&__hsfp=803678701)
- [Australia](https://au.ippon.tech/?__hstc=223043268.1036d82247623b329dfefe4e92697801.1714729179243.1714729179243.1714729179243.1&__hssc=223043268.2.1714729179244&__hsfp=803678701)

- #### Contact
- Ippon Technologies  
  [3431 West Leigh Street Richmond, VA 23230, USA](https://maps.app.goo.gl/RySm6SAwZnsxeiLz9)
-  
- [(844) 477- 6687](tel:8444776687)
-  
- [Sales@ipponusa.com](mailto:Sales@ipponusa.com)

<https://www.facebook.com/IpponUSA/> <https://www.youtube.com/c/ipponusa> <https://www.linkedin.com/company/ippon-technology>

©Copyright 2024 Ippon USA. All Rights Reserved.   |   [Terms and Conditions](https://ipponusa.com/privacy-policy/)   |   [Privacy Policy](https://ipponusa.com/privacy-policy/)   |   [Website by Skol Marketing](https://skolmarketing.com/)

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Hector Sanchez",
    "url" : "https://blog.ippon.tech/author/hector-sanchez"
  },
  "dateModified" : "2024-01-25T18:20:25.916Z",
  "datePublished" : "2022-01-06T18:20:00.000Z",
  "headline" : "Data Basics for Life-Long Software Engineers",
  "image" : [ "https://blog.ippon.tech/hubfs/Imported_Blog_Media/Data-Basics-for-Life-Long-Software-Engineers-3.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.ippon.tech/data-basics-for-life-long-software-engineers",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://blog.ippon.tech/hubfs/logo_SVG.svg"
    },
    "name" : "Ippon Technologies"
  }
}
```