Cleaning Data
with SQL
This project focuses on converting unorganized data regarding housing sales into
presentable information using Microsoft SQL Server Management Studio (SSMS)
Cleaning Data
Potion Calculator
with Excel
This project is designed to create a calculator for making potions in the video game "Mortal Online 2". Potions can provide additional health points to a player's character. Different potions with various ingredients provide a wide range of health points. By utilizing ingredient drop-down menus, conditional formatting, and quantitative analysis, we can compare potions with different ingredients by their healing, cost, and heal-to-cost ratio.
Alchemical Ingredients
with SQL
In this project, I recorded raw data about alchemical, or potion-making, ingredients in the video game "Mortal Online 2". By utilizing SELECT and JOIN statements and several stored procedures, we can efficiently organize ingredients into related tables by criteria such as cost, tier of effectiveness, and location in game and perform various calculations. These results are then exported to Tableau, in which a dashboard was created. See "Alchemical Ingredients with Tableau" for more.
Alchemical Ingredients
with Tableau
This dashboard was created in Tableau and is based on queries created in "Alchemical Ingredients with SQL". We can see which towns and regions in game has the most ingredients by a stacked bar graph as well as a density graph based on a map representing the in game world. There is also another chart demonstrating dilution of potions.
Employee Database
with Tableau
This dashboard was created in Tableau based on the queries presented in "Employee Database with SQL". These charts focus on the breakdown of employees into gender, departments, and salary.
Employee Records
with SQL
This project is a list of 10 example problems regarding an employee database. Some of these examples include SELECT, GROUP BY, ORDER BY, and WHERE statements, JOINS, and aggregate functions.
Employee Database
with SQL
This project entails 4 tasks based on an alternative employee database. Some queries include CASE statements, JOINS, and aggregate functions. The results are then exported to Tableau for visualization presented in "Employee Database with Tableau".