![](/images/Result_of_trigger.jpg)
View
The result of a trigger using the ORIGINAL_LOGIN() function to track the server under which the data is inputted.
I graduated from the University of Houston in 2017 with a Bachelor's degree in Mathematics and started my career in data analytics with an internship for a political campaign. Since then, I have been in pursuit of tackling some of the most interesting – and convicting – problems within this ever-growing field.
The work I've done in the past mostly consists of researching relevant datasets and then cleaning the data in Excel before importing it to Microsoft SQL SSMS or Microsoft Access to filter or summarize relevant information that stakeholders expect.
This part contains a seperate repository of Tableau visualizations involving county data in the field of politics which are available on Tableau Public. Some of this work was performed on request for various campaigns. (details).
This link presents the use Exploratory Data Analysis on a dataset for Waze, a well-known app for driving directions and traffic updates
Enjoy, and don't forget to ask for feedback!
I've had the chance to create or be a part of strategy in the projects that I've been involved. The most recent being the data migration of multiple customer interfaces into Salesforce. This was accomplished using Microsoft SQL to backup the database from a cloud server and querying the interface to export into a spreadsheet for cleaning criteria. This was loaded into Salesforce under our organization's cloud.
My first tenure as a data analyst was an internship with a political campaign. While there, I constructed a strategy for canvassing using Excel and provided a form template created in Access so that voter responses would be recorded to manage data more efficently. The result is saved time and reduced dependence on outside resources.
This is a Gallery of my previous work using various software and analytical methods.
The result of a trigger using the ORIGINAL_LOGIN() function to track the server under which the data is inputted.
Using an aggreggate CASE function to group precincts for each county and in order to get the county sum for each candidate. Joined with this table is a table containing Census data for income by county.
Connecting a SQL Database to an Excel spreadsheet for interactive control.
Detailed form with questions for each customer that purchased a product.
This form uses a macro to find the name of a precinct chair from a joined query of election data.