Jorge Velázquez Portfolio

This report consists of two pages, in the first we find the relevant data of the restaurant, sales, sales by platform, investment, profit, number of customers, earnings, payroll and more, all visualizations are dynamic and adapt to the results generals.

Platform: Looker Studio

DataSet: Google Sheets

Queries: Azure Data Studio

Data Clean: Python

The objective of this report is to keep the fuel consumption information of a fleet of transport units clear and clean, with clear and specific views of hydrocarbon consumption by unit, segment and loading stations.

Platform: Power Bi

DataSet: Google Sheets

Queries: Azure Data Studio

Data Clean: Python

In this strategic level report, we can globally observe hydrocarbon consumption, in addition to the services performed by supervisors in order to compare fuel consumption and logistics services performed by each unit. On the first page of the report, the fuel totals are observed, on the second and third pages the services performed by each supervisor, with their respective comparisons.

Platform: Looker Studio

DataSet: Google Sheets

Queries: Azure Data Studio

Data Clean: Python

In this report we can identify the road accidents in Mexico City from 2017 to 2019, with a heat map that allows us to identify where the incidents were, on the left side we can find the CDMX delegations with the number of reported cases , and at the bottom the days of accidents by day of the week, by scrolling on the heat map we can zoom in to review the areas of the city in detail.

Platform: Power Bi

DataSet: Google Sheets

Queries: Azure Data Studio

Data Clean: Python

In this Dashboard we can observe the number of people infected, vaccinated and deceased in the world, through a global heat map we can visualize each country with their respective Covid statistics.

Platform: Looker Studio

DataSet: Github

Data Process: Python

How to maintain control of fluids and oils consumed by your fleet of transport units? Easy, with this report you can view the consumption and acquisition of different oils, whether for motor, antifreeze or adblue. The report shows the liters consumed by transportation segments, liters consumed per month, per unit by type of fluid, along with the existence and consumption of the fluids.

Platform: Looker Studio

Data Collect: Web App

Data Clean: Python

This report has a design that emulates the controls of a control tower at an airport, and shows the income, profits and profits of some airlines, in addition to showing the total fuel consumed, the data corresponds to the period from 2016 to 2019.

Platform: Power Bi

DataSet: GitHub

Queries: Azure Data Studio

Data Extract: Python

In my latest project, I’ve utilized World Bank data from 2015 to create a Dashboard that visually presents a range of relevant insights about the global population. Some of the highlighted indicators in this Dashboard include:

• Total population

• Percentage of adult female literacy

• Internet usage by country

• Life expectancy in 2015

• Export of goods and services

• Distribution of the population in urban areas

• Percentage of Gross Domestic Product (GDP) by region

Platform: Looker Studio

DataSet: Excel

Queries: Azure Data Studio

Data Clean: Python

In my latest project, I’ve utilized World The Market Place supermarket chain is a company based in the United States that opened 3 branches in Burma, which shares the sales data for the first quarter of 2024. We were entrusted with the development of a predictive model to be able to estimate the qualification (A, B or C) of the consumer according to the type of client.

Platform: Looker Studio

DataSet: Kaggle

Queries: MySql

Data Extract: Python

In this project, we have developed a data analysis system focused on the telemetry of transport units. Using advanced data analytics and visualization technologies, we aim to provide detailed and actionable insights into transportation fleet performance and operating costs.

• Project Objectives
  Performance Monitoring
  Cost Control
  Idle Analysis
  Data Visualization

Platform: Power Bi

DataSet: OBD