search

siufai6 / TIL

0 stars 0 forks source link

Data analysts #6

Open siufai6 opened 8 months ago

siufai6 commented 8 months ago

What do data analysts do?

  1. Data preparation - profiling, cleaning, and transforming your data to get it ready to model and visualize. Privacy and security assurances and performance concern.
  2. defining and creating relationships between the tables
  3. Turn data into visualization to answer business problems
  4. Analysing, understanding and interpreting the information to ultimately drive better decisions
  5. Manage reports, dashboards, workspaces, semantic models, keeping them up-to-date. watch out for anomalies
siufai6 commented 8 months ago

Edward Tufte

  1. show comparisons, contrasts and differences
  2. show causality, mechanism, explanation, systematic structure.
  3. show data with more than 1 or 2 variables
  4. integrate words, numbers images and diagrams (a story!!)
  5. Describe the evidence
  6. Context Matters: Present data in deflated and standardized units (e.g., monetary measurements) rather than nominal units
siufai6 commented 8 months ago

image

descriptive - what is happening in the biz? e.g. sales figure trend..etc. diagnostic - show “why” and “how” something occurred.. why is the trend like this? find patterns anomalies. In some firewall, there are diagnostic tools to detect malicious attempts (e.g. a repeated ping from an IP to one of our hosts across different ports). predictive analytics - regression, machine learning prescriptive analytics (heuristics, machine learning and rule-based systems )