Dashboard created in Power BI Desktop to track sales by product,
segment/industry sector, as well as profit by month & year
as well as by country where the company is active in its economy.
(currently working to publish in Power BI service)
Dashboard created for executive-level KPIs to track year-over-year sales progress for differetn store locations, storetypes, as well as departments within each store.
Dashboard created for executive-level KPIs to track year-over-year points of interest for different store regions and departments within each store.
Provided analysis & recommendations for a real estate investment firm to provide the greatest potential for appreciation of asset value, current income, & preservation of capital without increased risk.
Hypothesis test to compare average sale price of "small homes" (2000 square feet & under) vs "big homes" (2001 square feet & over).
Provided analysis & recommendations to make this car rental company more profitable moving forward by removing liabilities (decreasing inventory), cutting costs, & investing more into assets that provide the greatest return.
Pivot table & chart showing total revenue, costs, and profits; as well as average price per day & total days rented for the top 10 revenue-generating vehicles in the inventory.
Pivot table & chart showing total revenue and average price per day for the top 10 revenue-generating car brands in the inventory.
Provided analysis & recommendations to marketing firm to increase revenue to over $1 billion dollars by slightly increasing total employees and average account workload per employee, which yielded a 59.64% increase in total gross revenue, and 66% increase in net revenue (after payroll).
Analyzed 5 years of migration data & real estate transactions in Houston, TX to conclude if Californians relocating to Texas are the reason for the rise in housing prices in Houston.
Distribution plot showing the spread of the median listing price of home listings in the top 5 Metro areas in Texas.
Box plot showing the spread of the median listing price of home listings in the top 5 Metro areas in Texas.
Tableau rendition of average listing prices in top 5 metro areas in Texas.
Line chart showing the change in the average listing price of home listings in the Houston metro area from February 2017 to January 2021.