Caitlin Carpenter

Fresno, California, United States Contact Info
2K followers 500+ connections

Join to view profile

About

Data analyst with with expertise in SQL, Tableau, and Excel. Skilled in extracting…

Activity

Join now to see all activity

Experience & Education

  • Tiny House Inc

View Caitlin’s full experience

See their title, tenure and more.

or

By clicking Continue to join or sign in, you agree to LinkedIn’s User Agreement, Privacy Policy, and Cookie Policy.

Licenses & Certifications

Projects

  • Business Questions

    • Utilized SQL to answer a variety of business questions by using CTE, Subquery, Window Functions and CASE statements.
    • Communicate findings and process through written communication on LinkedIn posts.

    See project
  • #66DaysofData

    -

    • Utilized Excel to analyze personal LinkedIn data and gain insights on engagement of content throughout the challenge.
    • Provided insights for how a business can use the data to increase their engagement on their posts.

    See project
  • Electronic Sales - February 2019

    -

    • Extracted the data, transformed the data by applying data cleaning techniques in Excel and loaded the data into Tableau.
    • Utilized Tableau to analyze a month's worth of sales data to Identify the KPIs for the store.
    • Provided business recommendations based on the results of the sales data.

    See project
  • S&P 500 Stock Prices Dashboard

    -

    • Created a dashboard with Tableau to analyze trends in the stock market such as trading volume per day, isolating the top selling stocks per day, aggregate data to find the best and worst performing days of the week and determined the percentage of gain.

    See project
  • World Happiness Data

    -

    Tableau - Visualized happiness on a world map. Quantified the happiness score and rank by country. Visualized the correlation between trust in government and the freedom to make choices. Quantified averages for dystopia, economy, freedom, generosity, happiness, health and corruption for each region of the world.

    See project
  • Customer & Order Analytics

    -

    SQL - In this project, I used a database with multiple tables containing data about a store. By using SQL, I queried the database to quantify statistics which represents the stores sales history.

    See project
  • Media Store Database and Stats

    -

    • Utilized SQL to extract data from 11 different related tables from a media store database using multiple JOIN statements.
    • Transformed and filtered data by using aggregating and filtering techniques to find business insights.

    See project
  • Spotify Analytics

    -

    SQL - For this project, I downloaded Spotify data from Kaggle. Then I created a table to insert Spotify data into Finally, I performed analytics on the data using SQL.

    See project
  • World Covid Data

    -

    Tableau - Quantified the vaccination rates of the top three North American countries, the vaccination rates for all countries and the rates for each income group.

    See project
  • Superstore Sales and Profitability Executive Dashboard

    -

    Tableau - Quantified Sales, profitability, profit ratio, and sales per customer. Visualized profit ratio by city on U.S. map. Quantified monthly sales by segment and category over time by profitable vs. unprofitable orders.

    See project

Honors & Awards

  • Best In Tech - Changemaker

    Pluralsight

    This year I was awarded the Best in Tech - Changemaker award by Pluralsight for my use of their Skills platform for upskilling and career transformation journey. Every year they select 5 business and one customer for their Platinum Best in Tech awards. This year I was the only B2C award winner.

    I currently have 200 hours of learning invested just in the courses. You can see my learning profile on Pluralsight here: https://app.pluralsight.com/profile/caitlin-carpenter

    From this…

    This year I was awarded the Best in Tech - Changemaker award by Pluralsight for my use of their Skills platform for upskilling and career transformation journey. Every year they select 5 business and one customer for their Platinum Best in Tech awards. This year I was the only B2C award winner.

    I currently have 200 hours of learning invested just in the courses. You can see my learning profile on Pluralsight here: https://app.pluralsight.com/profile/caitlin-carpenter

    From this learning I have produced many projects and skills. Most of which can be seen in my portfolio here: https://bit.ly/3TYTfir

More activity by Caitlin

View Caitlin’s full profile

  • See who you know in common
  • Get introduced
  • Contact Caitlin directly
Join to view full profile

Other similar profiles

Explore collaborative articles

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

Explore More

Others named Caitlin Carpenter in United States

Add new skills with these courses