Published on

What do data analysts DO! Here's a project walkthrough for an entry level data analyst! This goes b

What Do Data Analysts DO?! Here's a Project Walkthrough for an Entry Level Data Analyst!

If you're intrigued by data analytics and dreaming of working from home while earning a substantial income, but you don't quite know what data analysts actually do, this article is for you. We are going to walk through a practical example that will give you a clear understanding of a data analyst's tasks.

Step-by-Step Example:

Scenario:

Your boss asks, "What were our sales numbers like last year? What was our profit?"

Step 1: Locate the Data

The first step is to locate the necessary data. We need to find the sales numbers and profit from the previous year.

Step 2: Use SQL Software

To start this process, I open my SQL software called SQLite Studio. It's a free tool that you can download online.

Step 3: Explore the Database

I explore my databases within SQLite Studio, where I find a database named 'bitdb'. Inside 'bitdb', there's a table labeled 'sales2021'.

Step 4: Run a Query

To ensure this table has the relevant information, I run the following SQL query:

SELECT * FROM sales2021;

Step 5: Verify Data

The query result shows various columns such as sales price, cost, revenue, date of the sale, order ID, payment type, and order city. This data appears sufficient to answer the boss's question.

Keywords:

Keywords:

  • Data Analytics
  • Work from Home
  • SQL Software
  • SQLite Studio
  • Database
  • Sales Numbers
  • Profit
  • Query
  • Data Verification

FAQ:

FAQ:

  1. What is the first step for a data analyst in a project like this?

    • The first step is to locate the necessary data related to the project.

  2. Which software can be used for SQL queries?

    • SQLite Studio is an example of a free SQL software that can be used.

  3. What kind of data might you find in a sales database table?

    • You might find data columns like sales price, cost, revenue, date of the sale, order ID, payment type, and order city.

  4. What is the purpose of the query in this context?

    • The query is used to verify that the table contains all required information to answer the business question.

Read More