Published on

#data #tech #technology #womenintech #dataanalytics #dataanalysis #datavisualization #tiktok #viral

#data #tech #technology #womenintech #dataanalytics #dataanalysis #datavisualization #tiktok #viral

Introduction

Hi, I'm a data analyst, and today marks the fifth day since I started this channel. From the very beginning, I've been diligently recording data. This includes information such as the date, time, number of views within every 24 hours, and the number of likes received in that timeframe. This dataset may be small right now, but I plan to update it daily as I post more content and gain more engagement.

Data Collection Process

From day one, I ensured to capture the essential metrics that would help me analyze my channel's growth. The key data points are:

  • Date
  • Time
  • Number of Views in 24 hours
  • Number of Likes in 24 Hours

Analysis with Excel

Using Excel, I created a pivot table to organize the data effectively. This helped me in visualizing the trends through pivot charts. Here are the steps I followed:

  1. Created Pivot Table: This allowed for a structured way to look at the metrics.
  2. Generated Pivot Charts: These charts provided a visual representation of the data points.
  3. Developed a Dashboard: The dashboard consolidates all the insights, although I am still in the process of refining it.

Insights Gained

One of the key insights I've gained from this data so far is that I experienced the highest number of views on Saturday. I started the channel on Thursday, and it was intriguing to see that Saturday had the peak engagement.

Keywords

  • Data analytics
  • Data analysis
  • Data visualization
  • Views
  • Likes
  • Engagement
  • Excel
  • Pivot table
  • Pivot charts
  • Dashboard

FAQ

  1. What kind of data are you recording?

    • I am recording the date, time, number of views within every 24 hours, and the number of likes within that period.

  2. How are you analyzing the data?

    • I am using Excel to create pivot tables and pivot charts to visualize the trends, and I am developing a dashboard to consolidate the insights.

  3. What is one key insight you've gained so far?

    • The highest number of views occurred on Saturday, even though the channel was started on Thursday.

  4. Are you planning to update this dataset?

    • Yes, I plan to update it daily as I post more content and receive more engagement.

  5. Why did you choose Excel for this analysis?

    • Excel provides robust functionality for creating pivot tables and charts, which are essential for structured data analysis and visualization.

Read More