Chris IJ Hwang

I am a Quantitative Analyst/Developer and Data Scientist with backgroud of Finance, Education, and IT industry. This site contains some exercises, projects, and studies that I have worked on. If you have any questions, feel free to contact me at ih138 at columbia dot edu.

View My GitHub Profile



Contents

Tableau Getting Started

from tableausoftware.com

Connect to Excel file

conncect

Tuturial uses just one table “Orders”.

file

First worksheet: Sales Seasonality

first wsh

Second worksheet: Crosstab

cross
We can get the data as the above,
Or
We can “duplicate as crosstab”

dup

Then,

fin

Finally,

finn

Third worksheet: Regional sales and profits

Using “Show Me”

show

Investigate “Furniture” category sales and profit

funrn

Add “Show quick filter”

quik

Finally,

finn

Fourth worksheet: Sales by Category

What types of furniture in problem?

fi

Finally,

finn

Fifth worksheet: Customer Breakdown

fif

Dashboard: Sales Dashboard

dash

Story: Profitablity: The Whole Story

story