My name is

hailey Jones

& I am a Cal Poly student currently exploring GRC 404 Data Management, Estimating, and Visualization in Graphic Communication.

This data portfolio is designed to showcase the work I have completed in this course at Cal Poly.

Final Data Project

Beyond Consumption: Rethinking Happiness and National Prosperity. Does the consumption of a country affect the happiness of their people?

DAta cleaning

This spreadsheet started from thousands of record fields in the CVS file. I tackled the challenges and tequniques associated with cleaning data; techniques include:

Text to Columns
SUBSTITUE
Trim
Lists

See Excel file below

404_lab1_datacleaning_hjones26.xlsx

BASIC EXCEL

This spreadsheet demonstrates basic excel skills from Week 1 of this course.

Data Validation
Name ranges
IF ERROR handling
Calculations
Limiting values

See Excel file below

404_Lab2_paper_estimation_hjones26.xlsx

Contextual menus

The following concepts were demonstrated in this budget tracker file:

Contextual menus using INDIRECT
- - - Column C menu is dependent on Coulmn B value
Conditional formatting
- - - Red cells are debit and green cells are credit

See Excel file below

HaileyJonesBudgetTemplate (1).xlsx

sumif & Vlookups

This spreadsheet on ink cost estimating shows data lookups as well as Sumif. Challenges associated with Vlookups, like variable rows and columns, were also overcome.

VLOOKUP
Nested MATCH statements
Naming Table Arrays, Lookup Arrays and Menus
SUMIF

See Excel file below

Hailey Jones 2 D-36 Ink_Workbook_no_formulas1.xlsx

Lookup tables in cost estimating

This spreadsheet is used for estimating book graphic design. Techniques include:

VLOOKUP
HLOOKUP
MATCH
Conditional Formatting
NOT(ISNUMBER...

See Excel file below

HaileyJones 3 Book Graphic Design template1.xlsx

advanced lookups & Conditional Formatting

This spreadsheet uses Function Point Analysis to demonstrate multiple lookups. Vlookup as well as Hlookups based on table design, multiple columns and row variables, as well as nested MATCH statements were used.

VLOOKUP
HLOOKUP
MATCH
AND/OR/NOT logic in conditional formatting

See Excel file below

1 FPA_template.xlsx

tableau prep

clean, join, & pivot

This Tableau Prep file cleans and joins data for the purposes of creating the Postal Codes Dashboard.

Clean
Join

basic tableau desktop

This file demonstrates basic Tableau Desktop skills:

Tables & Sheets
Marks
Filters
Fundamentals
Treemapping

tableau analysis

of san mateo airbnb pricing

This Tableau file provides several samples of sophisticated visualizations including:

Cluster mapping
Geomapping using distance from Theresienwiese (km)
Line graph with image background
Treemap
Bar graph
Tableau story