liveBook · Manning

Data infrastructure

As explained in Effective Data Analysis

Data infrastructure is the collection of systems, tools, and processes that gathers, stores, processes, retrieves, and presents organizational data for analysis.

Data infrastructure is the collection of systems, tools, and processes that gathers, stores, processes, retrieves, and presents organizational data for analysis. Its scale ranges from a shared drive with daily exports to many tools processing billions of records. section 11.2 section 11.5

A functioning infrastructure typically supports these connected activities:

  • Gather information from multiple sources on a regular cadence. section 11.2
  • Store structured, semistructured, or unstructured data in suitable repositories, including data warehouses, document databases, or data lakes. section 11.5
  • Process and structure data through ETL or ELT before analysis or within the target warehouse. section 11.5
  • Retrieve accessible, coherent data so analysts can generate insights for stakeholders and support decisions. section 11.5

Renewable-energy startup proposal

Recommend gathering, storage, and processing tools for utility usage, website activity, advertising interactions, customer tiers, and renewable-energy purchases. Compare Snowflake, MongoDB, Redshift, BigQuery, and Azure, then justify whether a data lake fits the company’s needs over the next one to two years. section 11.2.4

Figure 11.4 When data reaches your doorstep, it often looks nothing like it did at the source.
figure

Use the figure to see how source data can change substantially before becoming an analytics resource. section 11.2

How Effective Data Analysis covers it

How deep it goes
Explains collection, storage, processing, retrieval, ETL, and ELT at overview level, while deferring detailed tool implementation to documentation.
Examples
Uses transformed source data, renewable-energy customer data, technology comparisons, and a data-lake recommendation exercise.
What you can do after
Evaluate and recommend storage, collection, processing, and data-lake options for an organization’s anticipated analytical needs.
How it connects
Connects data warehouses, document databases, ETL, ELT, data lakes, big data, and distributed computing frameworks.

Also explained in

Compare how 2 books explain data infrastructure →

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Effective Data Analysis. The section links point to the parts of the book it draws on.