Skip to content

Dahel Consultant and Techies Internship: This is a project that entails the analysis of a Ted Talk event.

Notifications You must be signed in to change notification settings

RemedyData/Dahel_Techies_Ted_Talk_Analysis_Internship

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 

Repository files navigation

Dahel_Techies_Ted_Talk_Analysis_Internship

Dahel Consultant and Techies Internship: This is a project that entails the analysis of a Ted Talk event. (The picture below is gotten from The Hollywood Reporters Website).

image

Disclaimer: This is not a real company as we know this is a dataset compiled by Dahel Consultant Techies for Internship purposes.

Introduction

This is Ted Talk Show analysis. It is done by analyzing data from the TEDTALK table which comprises of TITLE, AUTHOR, DATE, VIEWS, LIKES, and LINK fields. I used Excel to get an overview of the dataset before importing it into Power BI where the actual analysis was carried out.

Problem Statement

The goal of this analysis is to know:

  • What is the total number of Authors?
  • What is the total number of likes and views?
  • What is the topic with the highest views and likes
  • What is the average likes per views?
  • Which of the authors hosted the most talk?
  • Trend of views across the year
  • What is the correlation between views and likes?

Skills and Concepts Demonstrated:

  • Power BI concepts like:

    • Creating key performance indicators (KPIs) and other business calculations
    • Data Modelling,
    • Measures,
    • Filters,
    • Tooltips,
    • Page buttons,
    • Data visualization

    Data Source:

The dataset for the work is gotten from Dahel Consultant Techies. It consists of 5,441 records and 6 fields of data. I studied the dataset well to gain proper insight into the dataset. You can find a link to download the dataset here:


Data Transformation:

Step 1:

  • After downloading the dataset, I imported it into POWERBI.

Step 2:

  • It loaded the dataset authomatically in Power Query Editor but there was no cleaning needed because it was already a cleaned data.

Step 3:

  • After checking the columns, it was loaded into POWERBI for visualization.

Data Analysis and Visualization:

Several expressions and functions were made to arrive at the desired KPI or Metrics. I arrived at a report with a single dashboard consisting of different visuals such as bar chart, line chart, slicer, and KPIs, giving the summary of the insights gained into the the talk-event performance.

Features of the Report:

The dashboard conveys information about the following key areas:

  • Total number of Authors
  • Total number of likes and views
  • Topic with the highest views and likes
  • The average likes per views
  • The authors that hosted the most talk
  • Trend of views across the year
  • Correlation between views and likes

Dahel_Ted_talk

Analysis

Summary of the insights gained into the chess Game performance:

  • Between January 1, 1970 to February 1 2022, a total number of 5540 Ted Talk was published.
  • It has a total of 341 million likes and 11 billion views.
  • The average likes per view is 3.04%
  • There’s 4443 Authors between those years with Alex Gendler being the author with the most topics (Authored 45 topics). Iseult Gillespie is the 2nd author with the most ted talk.
  • The topic “Do skills kill creativity?” has the highest number of likes and views followed by “your body language may shape who you are” having the second most liked and most viewed topic.
  • From the findings there’s a correlation between likes and views, the more the views, the higher the likes.
  • The lowest number of view was in the year 1970 this might be as a result of technology not being widespread then, the highest views happened in the year 2015.

Recommendation

  • More topics should be gotten by the authors that wrote the topics with the most likes and most views (Sir Ken Robinson).

  • Moreso, similar topics that is related to the topic that had the most likes and most views should be discussed in the Ted Talk.


Thank you for reading.

I am open for entry-level to mid_level data analyst role.

About

Dahel Consultant and Techies Internship: This is a project that entails the analysis of a Ted Talk event.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published