Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 26 views

    Choosing The Right Tool For The Job - Coursera

    Uploaded by

    amr ahmed
    As a data analyst, you need to choose the right tool for each phase of the data analysis process. For data visualization, visualization tools are best, while spreadsheets and databases using queries are better for organizing, cleaning, and analyzing data. Spreadsheets and databases both store and manage data, but databases can handle much larger amounts of data and are accessed through queries. A data analyst will typically use a combination of tools, such as storing data in a database and exporting it to a spreadsheet for analysis.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Choosing The Right Tool For The Job - Coursera

    Uploaded by

    amr ahmed
    26 views1 page
    As a data analyst, you need to choose the right tool for each phase of the data analysis process. For data visualization, visualization tools are best, while spreadsheets and databases using queries are better for organizing, cleaning, and analyzing data. Spreadsheets and databases both store and manage data, but databases can handle much larger amounts of data and are accessed through queries. A data analyst will typically use a combination of tools, such as storing data in a database and exporting it to a spreadsheet for analysis.

    Original Description:

    Original Title

    Choosing the right tool for the job _ Coursera

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    As a data analyst, you need to choose the right tool for each phase of the data analysis process. For data visualization, visualization tools are best, while spreadsheets and databases using queries are better for organizing, cleaning, and analyzing data. Spreadsheets and databases both store and manage data, but databases can handle much larger amounts of data and are accessed through queries. A data analyst will typically use a combination of tools, such as storing data in a database and exporting it to a spreadsheet for analysis.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    26 views1 page

    Choosing The Right Tool For The Job - Coursera

    Uploaded by

    amr ahmed
    As a data analyst, you need to choose the right tool for each phase of the data analysis process. For data visualization, visualization tools are best, while spreadsheets and databases using queries are better for organizing, cleaning, and analyzing data. Spreadsheets and databases both store and manage data, but databases can handle much larger amounts of data and are accessed through queries. A data analyst will typically use a combination of tools, such as storing data in a database and exporting it to a spreadsheet for analysis.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    8/24/22, 6:07 PM Choosing the right tool for the job | Coursera

    Item Navigation

    Choosing the right tool for the job


    As a data analyst, you will usually have to decide which program or solution is right for the particular
    project you are working on. In this reading, you will learn more about how to choose which tool you need
    and when.

    Depending on which phase of the data analysis process you’re in, you will need to use different tools. For
    example, if you are focusing on creating complex and eye-catching visualizations, then the visualization
    tools we discussed earlier are the best choice. But if you are focusing on organizing, cleaning, and
    analyzing data, then you will probably be choosing between spreadsheets and databases using queries.
    Spreadsheets and databases both offer ways to store, manage, and use data. The basic content for both
    tools are sets of values. Yet, there are some key differences, too:

    Spreadsheets Databases

    Data stores - accessed using a query language (e.g.


    Software applications
    SQL)

    Structure data in a row and column


    Structure data using rules and relationships
    format

    Organize information in cells Organize information in complex collections

    Provide access to a limited amount of


    Provide access to huge amounts of data
    data

    Manual data entry Strict and consistent data entry

    Generally one user at a time Multiple users

    Controlled by the user Controlled by a database management system

    You don’t have to choose one or the other because each serves its own purpose. Generally, data analysts
    work with a combination of the two, as both tools are very useful in data analytics. For example, you can
    store data in a database, then export it to a spreadsheet for analysis. Or, if you are collecting information in
    a spreadsheet, and it becomes too much for that particular platform, you can import it into a database.
    https://www.coursera.org/learn/foundations-data/supplement/VFYRO/choosing-the-right-tool-for-the-job 1/1

    You might also like