Hi, it's Abi.

allocator / retail planning

Portfolio —

Sample Works

Coach New York —

Simulation —

Production Units

MarkStrat - Marketing

Harvard Everest

Kate Spade —

Joy Colours Life

Candy Collection

Cameron Tote Bag

Analytics —

From doing Visual Merchandising and analysing heaps of Excel file it sparked an interest to further study data.

Excel

Data Cleaning
● Formatting, Data Organisation
● Conditional Formatting
● Hiding and Grouping
● Formulas & Advanced Formulas
● Functions, Basic Math Functions,
Conditional Math Functions
● Logical Functions
● Reference and Text Functions
● Filling, Defined Name, PivotTables
● Chart, Trendline, Secondary Axis
● VLookups & HLookups
● Index/ Match

Power BI and Power Query

SQL

The data used is a publicly available data set from
Iowa Liquor Sales that has been loaded into AWS data
base.
Its is a PostgreSQL satabse connected to pgAdmin
● Understand SQL vocab, table, schema function
and JOINS
● Create basic SQL queries, Boolean logic,
sorting function and commenting
● Aggregate function [min,max,sum avg, count]
● CAST, change query type.
● GROUP BY, HAVING conditional operator
[=,!=,>,<,N,NOT IN, BETWEEN] to filter ata
● Apply string, date and math functions to
manipulate data,
● UNION to merge data
● JOINS to create relationships to table to create
data

RStudio and Data Wrangling

The data used is a publicly
available data set from NYC
Taxi and Limousine regarding
locations of pick up and drop
offs.
● Data Wrangling
● Understanding R Syntax
● Derive new data, from
existing data
● Reproduce code
● Join data, join types
● Aggregating and
summarizing data
● In the process of learning
GGPLOT.