Google Data Analytics #11_Data Types

tpgk21·2022년 6월 27일

[Google] Data Analytics

목록 보기

Data Types

  • a specific kind of data attribute that tells what kind of value the data is

Data Types In Spreadsheets

  • Number

  • Text (or String)

  • Boolean

  • Tabular

    • Rows(spreadsheet) == Records(any kind)
    • Columns(spreadsheet) == Fields(any kind)
  • Wide Data

    • data in which every data subject has a single row with multiple columns to hold the values of various attribtues of the subject

    • lets you easily identify and quickly compare different columns

    • makes it easy to find and compare the data at different periods of time

    • is preferred when creating tables and charts with a few variables about each subject

    • is preferred when comparing straightforward line graphs

  • Long Data

    • data in which each row is one time point per subject, so each sbject will have data in multiple rows

    • can store and analyze all of this data using fewer columns

    • easy to add new variables

    • is preferred when storing a lot of variables about each subject

    • is preferred when performing advanced statistical analysis or graphing

Data Transformation

  • the process of changing the data's format, structure, or values
    • adding, copying, replicating, deleting etc.
    • joining, standardizing, renaming etc.

Why Transform?

  • Organization Purposes
  • Compatibility : different system can use the same data
  • Migration : data with matching formats can be moved from one system to another
  • Merging : data with the same organization can be merged together
  • Enhancement : data can be displayed with more detailed fields
  • Data Comparison : apples-to-apples comparison of the data can then be made
데이터 분석가

0개의 댓글