About
Before I started as a data analyst, I had worked for over ten years as a software developer, mainly building, hosting, and managing client websites and web applications. My sense of satisfaction of a job well done comes from being able to create tools that businesses and organizations could use towards solving problems and achieving their goals.
The General Process I Use
ETL Process
With each project I’ve worked on, I’ve always used a similar process of extracting the data from its source, transforming, cleaning, and merging where necessary, and then saving (loading) it in a format suitable for data exploration and analysis.
Data Exploration
During the data exploration stage I generally first build a data profile and use basic statistics to get a general feel for the data as it relates to the current hypothesis. I also look at the distribution, variance, standard deviation, correlation, and outliers.
Analysis
After exploring the data, I review the requirements and use my data exploration findings to analyze what the data has revealed. Finally, I build out any required reports or dashboards with a storyline, conclusions, and recommendations.