NEW FEATURES MORE

Search
Over 5 tutoring hours

Nathan F.

Provo, UT

$30/hour

Excel, SQL, R, Data Analytics, Statistics

Background check passed as of 9/12/16
5.0 average from 6 ratings

$30/Hour


Send a message explaining your needs and Nathan will reply soon.

Response time: 20 hours

Contact Nathan

Florida State University

Education

Florida State University

About Nathan

With over five years of experience in data-analytics using various statistical techniques and software, including program and project management, I have created thousands of reports using Excel that include workbooks-based dashboards, complex charts, macros with other workbooks, extensive data-cleaning, and in-workbook statistical analysis. With just Excel, I've been able to get two-week-long turn-around time reports down to less than a couple of hours.
From small less-than-ten line queries that return a few rows of information, to queries involving multiple "temp-tables," schemas, hundreds of lines of code that produce hundreds of thousands of records where each one required specific business rules, I have been able to create and produce such queries for stakeholders and other reports in both MySQl and SQL Server.
Using R (as well as SAS and STATA, though I am less proficient with those) I have run hundreds of analysis that include assumption checking, power analysis, transformations, outlier management, t-tests, multivariate regressions, and more.
Everyday I run statistical analysis ranging from descriptive statistics to multivariate regression discontinuities. After each data-cleaning phase, I routinely run normality assumption checks (applying transformations where appropriate), power-analysis, outlier management, and reviewing questions of validity. This is often followed by checks of heteroskedasticity, simple t-tests, and multivariate regressions.
Past pertinent formal coursework includes "Business Statistics", "Intro. to Econometrics," "Discrete Probability," "Analysis of Variance (which included experimental design)," and "Research Methods for Criminology."
Sometimes the customer or manager knows what they want and will give you specific criteria, a lot of times they may say "here's a bunch of data on a bunch of stuff about our product... can you give us any good or bad news?" I've been through either scenario and most in-between. Through defining scope, variables, goals, research questions, designing methods to be used, descriptive statistics, etc... I may be able to help you turn your "mushy" raw, unclean, data into a refined jewel.
Though my usage in these areas is a little dated, I may be able to help you in the areas of introductory Sociology or Economics as I have minors in both, each requiring fifteen or more credit hours. My undergraduate (Criminology) was also originally a branch of, and still uses much of, Sociology. My major GPA was 3.8 with an overall GPA of 3.46 by the end of FSU (the reason for the lower-than-major GPA can be attributed to required physics and biology courses).
Though most of my focus in sociology was the study of Symbolic Interactionism, Systems (a more modern Structural Functionalism), and the writings of C. W. Mills, I was made familiar with most sociological theories given pertinent coursework listed below.
Sociology courses include: "Sociological Theory (SYA 4010)," "Deviance and Social Control (SYP 4570)," "Social Problems (SYA 2010)," as well as a few others.
Economics courses include: "Introduction to Econometrics (ECO 4421)," "Principles of Macroeconomics (ECO 2013)," "Principles of Microeconomics (ECO 20213)," "Real Estate Economics (no longer offered at FSU)," as well as other courses.
From 2014 to Current I work full-time at Imagine Learning as a level-2 data-analyst and assistant psychometrician. From 2013 to 2015 I was working at Chatbooks / JustFamily as a data-analyst and quality-assurance tester (in 2014 I was working at both Chatbooks and Imagine Learning but only part-time at both). From 2008 to 2010 I worked at LieveTV as a data-analyst and assistant program manager (from 2010 to late 2012 I was serving abroad as a church volunteer / missionary in Kyushu & Okinawa Japan).
Currently, I am obtaining the pre-requisites required to enter the University of Utah's Biostatistics M.S. program where I hope to focus my studies on longevity and endocrinology. From 2006 to 2008 I attended Florida State University where I obtained my Bachelor of Science in Criminology Criminal Justice (with a major GPA of 3.8). I also obtained two minors at FSU, one in Economics, and another in Sociology. From 2004 to 2006 I attended Eastern Florida State College (known then as Brevard Community College) where I received my Associate of Arts with honors (Phi Theta Kappa).
I am engaged to a wonderful woman in which we plan to get married in early December 2016. Though I am not much into sports I love to exercise which includes high-intensity-interval-training, weightlifting, Krav Maga, and yoga. My favorite genre of music is "operatic-symphonic-heavy-metal" (i.e. Epica or original Nightwish). I am the kind of person who is "uncomfortable being too comfortable" and feel like I must always be doing something productive. If I am not spending time with my fiance', exercising, working, on engaged in a personal project, I enjoy playing a modded Skyrim or table-top games with friends. I am an active LDS ("Mormon") and try to avoid working on Sundays but if it is an emergency, perhaps we can make an arrangement.
With over five years of experience in data-analytics using various statistical techniques and software, including program and project management, I have created thousands of reports using Excel that include Read more

Policies
Cancellation
1 hour notice required
Travel Radius
Travels within 20 miles of Provo, UT 84604
Background Check: Passed
Math:
R,
Statistics
Science:
Sociology
Computer:
Microsoft Excel,
Microsoft PowerPoint, R,
SQL
Business:
Microsoft Excel,
Microsoft PowerPoint, Project Management

Approved subjects are in bold.

Approved subjects

In most cases, tutors gain approval in a subject by passing a proficiency exam. For some subject areas, like music and art, tutors submit written requests to demonstrate their proficiency to potential students. If a tutor is interested but not yet approved in a subject, the subject will appear in non-bold font. Tutors need to be approved in a subject prior to beginning lessons.

Microsoft Excel

I have nearly a decade using Excel for statistical/ data analysis, reporting, data-visualizations, dashboards, data-mining, data-cleaning, and other tasks. I am also experienced in VBA / Macros and importing data from databases into workbooks.

Project Management

For nearly the past nine years, I have either managed small to medium sized projects, or have helped in the planning process of medium to larger sized projects. Elements of this include but are not limited to: Scope analysis, Scheduling, Capital (including human resources and tools) allocation and planning, Critical Path planning and estimation, PM-systems management (i.e. Trello, Smartsheets, KanBan), Gantt Charts, KPI planning-measuring-reporting, Six Sigma methodologies (i.e. "5S," UCL's, LCL's, etc...), and more.

R

I use R at work daily for assumption checking, transformations, data-cleaning, power-analysis, and other statistical analysis. My coursework in R is included at Florida State University's Intro to Econometric course (ECO 4421) and my Analysis of Variance course at Brigham Young University (STAT 230). My usual code involves but is not limited to: installing libraries, reading in data, making data-frames, making functions (i.e. Cohen's D and Multivariate Regression Power estimates), a section on data cleaning (assumption checking, power analysis, etc...), and the main statistical analysis portion.

Sociology

I have a minor (fifteen plus credit hours) in Sociology from Florida State University. My GPA for Sociology coursework was greater than 3.5. Though I focused heavily on Symbolic Interactionism and Systems theory (a branch of Structural Functionalism) my coursework in Sociological Theory (SYA 4010 at FSU) has helped me to be rounded in many different areas kinds of sociological theory.

SQL

I have been working with SQL for nearly five years. Most of my experience comes from querying for data with some database management. Some of my experience includes extensive queries that involve manipulating data during the data-pull (i.e. partitioning into new row numbers based on groups), temporary tables, working in multiple schemas across multiple servers, and query optimization.

Statistics

For work, I use statistics nearly everyday which include but are not limited to t-tests, multivariate regressions, power-analysis, outlier management, assumption checking, transformations, descriptive statistics, ANOVA, ANCOVA, and experimental design. The software I often use is R, STATA, and Excel though I have some experience in SAS, Python, and VBA. My formal-educational experience in statistics include Econometrics, Business Statistics, Social-Science Statistics for Research Methods, Analysis of Variance (ANOVA), and Probability Theory.

Florida State University

Education

Florida State University

Hourly rate

Standard Hourly Rate: $30.00

Cancellation: 1 hour notice required

Travel policy

Nathan will travel within 20 miles of Provo, UT 84604.