Marie Vrablic

Learn About My Projects

Healthcare Analysis

| MySQL | JOINS |

This analysis was completed using MYSQL to perform ad-hoc queries for various healthcare workers. This article goes through how I approached each query and the recommendations given to stakeholders based upon the results. I have also shown how I worked around the database not containing a primary key when trying to find results after an inner join.

Massachusetts Education Analysis

| Excel | Tableau |

Using an Excel file, I uploaded data into Tableau Public to create a dashboard on the state of the Massachusetts Education system. In creating the dashboard, my analysis led to further investigation of whether class size affects college admissions, how economically disadvantaged districts and schools affect graduation rates, and how math scores contribute to poor school performance. I invite you to take a look at the analysis and follow my Tableau Public profile for my dashboard creation.

Food Service Marketing Analysis

| Excel | Pivot Tables | VLookup |

This is an analysis of a food service company, similar to DoorDash. In this analysis, I look at different campaigns to find the most effective campaign and what demographics the clients have during that campaign. I used Excel to do my exploration and used pivot tables and charts to visualize the data.

AEMR Case Study

| ProsgreSQL | Microsoft PowerPoint | Tableau |

The American Energy Market Regulator is in place to ensure America’s energy network is reliable and has limited disruptions, known as outages. There are four types of outages.

Consequential
Forced
Opportunistic
Planned

Forced outages are the types of disruptions that the AEMR fines companies for. Forced outages puts a strain on the network and creates an unreliable energy network.

For this case study, I used SQL to produce a series of queries that answer two major issues for management:

How is the stability of the market and who are the providers with the most Forced outages?
Which providers produces the highest energy losses and how does this contribute the the reliability of the network?

Finally, I imported a CSV file into Tableau, where I created visualizations to use for my presenation. You can find the SQL queries at the end of the presentation.

Southern Water Corp Case Study

| Excel | Pivot Tables | Microsoft PowerPoint |

Southern Water Corp. is an Israeli water desalination company that sells freshwater for three customer segments: Residential, Public, and Private. In this case study, the demand for agricultural and residential water use is rising. While the increased revenue from this demand is great, Southern Water Corp. wants to make sure they do not have an unsustainable rise in costs.

Costs between the various plants vary due to the type of water they produce. While Residential only requires soft water, Public and Private consumers need a mix of hard and soft water. By looking at the revenue, operational costs, and EBIT, we can understand the sustainability of the business. For this case study, I used Excel formulas to clean and explore the data, while using pivot tables and charts for visualizations.