Google Data Analytics #13_Data Soruces

Andy Oh Sae Ha·2022년 6월 29일
0

[Google] Data Analytics

목록 보기
13/15
post-thumbnail

Metadata

  • data about data
  • used in database management to help data analysis interpret the contents of the data within the database

3 common types of metada

  • descriptive
    • metadata that describes a piece of data an can be used to identify it at a later point in time (ex. Student ID)
  • structural
    • metadata that indicates how a piece of data is organized and whether it is part of one, or more than one, data collection
  • administrative
    • metadata that indicates the technical source of a digital asset (ex. time and date of a photo)

Using Metadata

  • metadata creates a single source of truth by keeping things consistent and uniform

  • metadata also makes data more reliable by making sure it is accurate, precise, relevant, and timely

Metadata Repository

  • a database specifically created to store metadata

  • can be stored in physical or virtual location

  • makes it easier and faster to bring together multiple sources for data analysis

    • describe the state and location of the metadata
    • describe the structures of the tables inside
    • describe how the data flows through the repository
    • keep track of who accesses the metadata and when

Data Sources

  • CSV : Comma-separated values (table format)
profile
데이터 분석가

0개의 댓글