Enabling data tools & technologies

Data Fluency

Konstantinos Kattidis

Data Analytics Lead

Outcomes of data tools

  • The right tools enable employees to effectively analyze data and build data products
  • Modern tooling should be available for every group of users

List of tools for data fluency

Data Fluency

Data visualization tools

  • Otherwise called business intelligence (BI) tools
  • They transform datasets into compelling visuals, dashboards, and reports
  • Examples:
    • Tableau, Microsoft Power BI, and Looker

Data visualization tools example

Data Fluency

Spreadsheet tools

  • Spreadsheet tools includes Microsoft Excel and Google Sheets
  • Pivot tables, functions, and charting capabilities make it suitable for tasks ranging from basic data summarization to more complex analysis

Spreadsheet example

Data Fluency

Programming languages

  • For users with a deeper technical understanding, programming languages like Python and R are commonly used
  • Python's simplicity and versatility make it a preferred choice for data analysis and machine learning
  • R, is a specialized language designed specifically for statistical analysis and data visualization

Programming languages example

Data Fluency

SQL for data querying

  • When it comes to working with databases, the structured query language (SQL) is a fundamental tool
  • Users can extract, manipulate, and analyze data stored in relational databases
  • It is applicable across different databases like MySQL, PostgreSQL, and AWS Redshift

SQL example

Data Fluency

Command line tools

  • Command line tools serve to:

    • Automate file operations
    • Facilitate version control
    • Seamlessly integrate with cloud services
    • Efficiently execute data pipelines

  • For example: Git, is a version control system that is used to manage and track changes in code and data

Command line tools example

Data Fluency

Let's practice!

Data Fluency

Preparing Video For Download...