Data Analytics Portfolio by Kirana Humaira

Hi! My name is Kirana Humaira Putri, just called me Kiran. Here is my Portfolio as Data Analyst, please check it out!

Spreadsheet/ Excel Skill sets:

• Data Cleaning;
• Query Table;
• Pivot Table;
• Vlookup;
• Descriptive Statistics;
• Data Visualization;
• Gathering Insights;
• A/B Testing

Deck :

Data Cleaning and Processing in Spreadsheet

SQL Skill sets:

• Standard Query Syntax;
• SQL Aggregate Functions;
• SQL Joins;
• SQL Data Type;
• SQL Date Format;
• SQL Window Function

Deck :

Structured Query Language

Code Example :

1. Create a query to get the number of unique users, number of orders, and total sale price status and month
2. Create a query to get frequencies, average, order values and total number of unique users where status is complete grouped by month
3. Find the user id, email, first and last name of users whose status is refunded on Aug 22
4. Get the top 5 least and most profitable product over all time
5. Create a query to get Month to Date of total profit in each product categories of past 3 months

Python Skill sets:

• Removing irrelevant values
• Handling missing data
• Removing duplicates
• Handling Outlier
• String manipulation
• Combine & merge datasets
• Data aggregation
• Descriptive statistic
• Analyzing using visualization
• Cluster Analysis

Code example:

1. Investment Products Segmentation

Dataviz using Tableau:

• Connect and combine/ join datasets
• Data formatting
• Visualization
• Calculated field
• Interactive Dashboard

Example:

1. Analysis of Airbnb in Singapore with Tableau
2. Analysis of Airbnb in Singapore with Looker Studio

Project Based Analytics

1. Mexico Maven Toys: Sales Analysis