Edgar Guzman Cuevas

This Qlik report summarizes the repatriation events data of the US-Mexico border. It was created in partnership with the Mexican National Institute of Statistics and Geography (INEGI–Instituto Nacional de Estadística, Geografía e Informática).

A company organized a data visualization best practices conference and collected Twitter data using the hashtag #DATAVIZ.

They required assistance in organizing, cleaning, and analyzing the data to identify the most relevant candidates to host the conference based on retweets and favorites and build a Tableau dashboard that would show the conclusions at first glance.

STEPS TAKEN
1) Identifying user vs. bot
2) Grouping sentiment values
3) Validating location
4) Standardizing retweets and favorite scores.
5) Calculating weighted relevance
6) Creating a Tableau dashboard

The project aimed to provide sales management with dashboard analytics, focusing on:

1. Analyzing revenue and profit results for the last four quarters and comparing them with the previous year (general overview and breakdown by regions and item types).

2. Identifying the countries and regions with the best sales performance over the past five years by examining the number of sales and comparing revenue and profit.

3. Understanding global sales trends for different item types by tracking trends by country and region, identifying any changing order priorities, and analyzing order management for critical, high, normal, and low priority orders.

4. Examining the time period between order and ship date (breakdown by item type and region) and providing a comparison of the last five years in this regard.