Please enable JavaScript.

Coggle requires JavaScript to display documents.

Google Analytics - Coggle Diagram

- - - - Sampling
        
        Interpretation
        
        Observer
  - - - Multipe time points
    - - Unique Time
  - - - Open Data
        
        data.gov
        
        census.gov
        
        opendatanetwork.com
        
        cloud.google.com/solutions/datasets
        
        datasetsearch.research.google.com
        
        who.int
        
        kaggle
  - - - Primary
      - Foreign
        
        Primary
        
        Other
        
        Table
    - - Descriptive
        
        ISBN
      - Structural
      - Administrative
        
        Technical
        
        Source
  - - - External
  - - - SQL Workspace
    - - SELECT DISTINCT start_station_name
      - ORDER BY
        
        label_name DESC
  - - - Version
- - - - Prepare
        
        Process
        
        Analyze
        
        Share
        
        Act
    - - Performance
      - Statistics
        
        Accurate
      - Analytics
        
        Explore
  - - - Understanding context
        
        Technical mindset
        
        Data design
        
        Data strategy
  - - - Strategy
        
        Problem Orientation
        
        Correlation
        
        Big Picture & Details
  - - - Target
  - - - Capture
        
        Manage
        
        Analyse
        
        Archive
        
        Destroy
  - - - Select
        
        From
        
        Where
- - - - ggplot2
        
        tidyr
        
        readr
        
        dplyr
    - - Date :calendar:
        
        Time :alarm_clock:
      - today()
        
        now()
        
        ymd()
        
        hms()
  - - - read_csv()
    - - View(ToothGrowth)
        
        filter(ToothGrowth,dose==0.5)
        
        arrange(filtered_tg,len)
    - - mutate()
        
        str()
        
        colsname()
  - - - c(x,y,z,...)
        
        1 type
      - typeof()
        
        length()
        
        is.logical()
        
        names()
    - - %>%
        
        pipe_name <- data_set_name %>%
        
        filter(dose==0.5) %>%
        
        groupby(supp) %>%
        
        arrange(len)
    - - list()
        
        Diversity
      - str()
    - - data.frame(x=c(x,y,...),y=c(...),z=c(...)...)
    - - file.create (“new_text_file.txt”)
        
        file.copy (“new_text_file.txt” , “destination_folder”)
    - - 1 Type
        
        matrix(c(3:8), nrow = 2)
  - - - here
        
        skimr
        
        janitor
        
        dplyr
    - - skim_without_charts
        
        glimpse()
        
        head()
        
        select(column_name)
        
        select(-column_name)
        
        rename(column_name=new_name)
      - drop_na()
        
        unite()
  - - - Facets
    - - library("palmerpenguins")
        
        ggplot(data=penguins)+geom_point(mapping=aes(x=flipper_length_mm,y=body_mass_g,color/shape/size=species))
    - - _point
      - _bar(...x...,color/size/alpha/fill)
      - _line
      - _smooth(...x,y...,line_type)
    - - +facet_wrap(~species)
      - +facet_grid(sex~species)
    - - +labs(title="YYY",subtitle="ZZZ",caption="AAA",)
      - +annotate("text",x=x_value,y=y_value,label="XXX")
    - - Export
        
        Plot
      - ggsave()
- - - - Definition
        
        Accuracy
        
        Completness
        
        Consistency
      - Replication :warning:
        
        Transfer :warning:
      - Issues
        
        Duplication
        
        Not enough
        
        Insufficient
        
        Only 1 source
        
        Keep updating
        
        Outdated
        
        Geographically limited :earth_americas:
    - - Bias
        
        Random Sampling
        
        Confidence Level
        
        99%
        
        Margin Error
    - - Not Chance
      - Over 80%
        
        Significance
  - - - Data Merging
        
        Concatenate
    - - Irrelevant
        
        Misspelling
        
        Typos
        
        Ponctuations
    - - Compatibility
  - - - FROM
        
        WHERE
        
        GROUP BY
        
        ORDER BY
    - - (value1,value2,...)
        
        VALUES
        
        (newvalue1,newvalue2,...)
    - - SET Field=new_value
        
        WHERE
    - - DISTINCT
        
        LENGTH
        
        SUBSTR
        
        TRIM
      - CAST(field_name AS FLOAT64)
        
        CONCAT
      - COALESCE()
        
        Non Null
  - - - Reliable
    - - Goal :goal_net:
        
        Data Origin
- - - - SORT
      - Order By
  - - - Data Validation
        
        Conditional Formating
    - - LEN
        
        RIGHT
        
        LEFT
- - - - Information
        
        Data
      - Story
        
        Concept
      - Goal
        
        Function
      - Visual Form
        
        Metaphor
    - - Position
        
        Size
        
        Shape
        
        Color
    - - Bar
        
        Line
        
        Pie
        
        Maps
  - - - Tableau Public
  - - - Only
        
        Needed
        
        Important
      - Layout
        
        Cohesive
      - Sharing
      - Data
        
        Static
        
        Live
        
        Filter
    - - Engage Audience
        
        Create Compelling
        
        Interesting Narrative
    - - Spotlighting
    - - 5 lines / 25 Words / Slide
    - - Characters
        
        Setting
        
        Plot
        
        Big Reveal
        
        Aha Moment
  - - - Business Metrics
        
        Hypothesis
        
        Data
        
        Business Impacts