Portfolio - Projects

Ebenezer V

MIS Data Analyst

Chennai, India

About Me

  • Hii Iโ€™m experienced data professional from Chennai with 3.5 years of hands-on experience in different domains like Banking Operations and E-commerce (Online Retail)

  • Tools and technology that I've worked on Advance Excel,SQL,Tableau

  • Here I've done personal projects under different domains

Contact me:

Technical Skills

  • Advance Excel

  • Tableau

  • SQL

Project List

  • Restuarant Sales and Customer Behavior Analysis Using SQL

  • Global super store sales KPI dashboard by Advance Excel

  • Credit Card Spend Analysis by Tableau

  • PhonePe Pulse Data 2018-2022

Certification

  • Data Analytics by Tableau & Oracle SQL

  • HackerRanker SQL (Basics)

PhonePe Pulse Data 2019-2022

About Data๐ŸŒŽ
The dataset you contain PhonePe Pulse 2018-2022 transaction-related data for different states and districts in India.
Tableau dashboard provide visualize and analyze transaction trends across time and geography. The rich combination of temporal, geographic, and transactional data insights such as identifying top-performing regions, tracking growth in transactions over time, and mapping transaction distribution geographically.Dataset provides detailed followings columns
State, District, District Amount, State Amount, Region Amount

Insights๐Ÿš€
Key Performance Indicators (KPIs)
โ€ข Avg Value: Displays the average transaction value, shown as โ‚น8,295,021,051.23.
โ€ข Total Transactions: Shows the total value of transactions, displayed as โ‚น121,405,928,105,735.30.
โ€ข Top-performing: Highlights the top-performing state, Telangana, with transactions totalling โ‚น16,522,924,338,545.29.
Charts and Visuals
โ€ข Total Transactions Over Time:
o A bar and line chart combination is used to display the total transaction count over time, with bars representing the years from 2018 to 2022.
o The line in green shows the growth trajectory, indicating an increasing trend in transaction volumes.
โ€ข Regional Performance:
o A tree map visualizes the transaction performance by region, with each region represented as a different section. The Southern Region is the largest, indicating it has the highest transaction value, followed by the Western, Central, Eastern, and Northern Regions.
โ€ข Transaction Type:
o A horizontal bar chart categorizes the types of transactions, with the following categories:
Merchant payments (highest volume)
Recharge & bill payments
Peer-to-peer payments
Financial Services
Others
Map Section
โ€ข There is a placeholder for a map visualization, currently represented by a green "Map" button. This likely allows for interactive mapping of transaction data by state or district.
Concept covered
Lod (fixed)
Dual axis charts
Dashboards actions
Dashboards objects
Filters

Credit Card Spend Analysis by Tableau

๐—–๐—ฎ๐˜€๐—ฒ ๐—ฆ๐˜๐˜‚๐—ฑ๐˜† ๐—ผ๐—ป ๐—–๐—ฟ๐—ฒ๐—ฑ๐—ถ๐˜ ๐—–๐—ฎ๐—ฟ๐—ฑ๐˜€ ๐—ฆ๐—ฝ๐—ฒ๐—ป๐—ฑ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐—ถ๐˜€ ๐Ÿ’ณ
with Tableau
๐Ÿ“… ๐—”๐—ฏ๐—ผ๐˜‚๐˜ ๐——๐—ฎ๐˜๐—ฎ:
We have the data of the transactions made by credit cards in each city of India specifying the amount spent in each transaction.
The Credit Cards are of type Silver, Signature, Gold and Platinum.
The spends are usually done on expenses that includes Entertainment, Food, Bills, Fuel, Travel and Grocery

๐Ÿ›  ๐—ง๐—ผ๐—ผ๐—น๐˜€ ๐—จ๐˜€๐—ฒ๐—ฑ:
Tableau Desktop (version 2021.3)
๐Ÿ“š Data Source:
Oracle SQL Database (version 18c)
๐Ÿ”ง ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐—ถ๐˜€ ๐—ฆ๐—ฐ๐—ฒ๐—ป๐—ฎ๐—ฟ๐—ถ๐—ผ๐˜€:
KPI metrics:
*Total amount Spend
*Average Transaction Amount
*Totals spend by male
*Totals spend by female
*Total transactions made
*Get the city with top and bottom total spend.
*Get the cards type and their contribution percentage in the overall spends.
*Get the spend percentage breakup by each expense.
*Get the transaction trends over the time.
๐—–๐—ผ๐—ป๐—ฐ๐—ฒ๐—ฝ๐˜๐˜€ ๐—–๐—ผ๐˜ƒ๐—ฒ๐—ฟ๐—ฒ๐—ฑ:
*Table Calculations
*Parameters
*Sets & combined sets
*Charts (bars, line, Donut, Text table)
*Marks card (colors, legends, Tools tip, Labels)
*Formats (Axis, Work Sheet, Texts, Numbers)
*Dashboard (containers, actions, Text box)
*Filters (Dimension and measures)

Restuarant Sales and Customer Behavior Analysis Using SQL

๐Ÿ“… ๐—”๐—ฏ๐—ผ๐˜‚๐˜ ๐——๐—ฎ๐˜๐—ฎ:1. Menu Items Table
The menuitems dataset contains information about the items available on the menu. Each row represents a unique menu item, with the following columns:
โ€ข menu
itemid: Unique identifier for each menu item.
โ€ข item
name: The name of the menu item.
โ€ข category: The category or type of cuisine the item belongs to (e.g., American, Italian).
โ€ข price: The price of the menu item in dollars.
2. Order Details Table
The orderdetails dataset contains information about individual orders placed by customers. Each row represents a unique order detail, with the following columns:
โ€ข order
detailsid: Unique identifier for each order detail record.
โ€ข order
id: Unique identifier for each order.
โ€ข orderdate: The date when the order was placed, formatted as MM/DD/YY.
โ€ข order
time: The time when the order was placed.
โ€ข itemid: The identifier of the menu item ordered, corresponding to menuitemid in the menuitems dataset.

๐Ÿ›  ๐—ง๐—ผ๐—ผ๐—น๐˜€ ๐—จ๐˜€๐—ฒ๐—ฑ:
Oracle SQL Database (version 18c)
๐Ÿ”ง๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐—ถ๐˜€ ๐—ฆ๐—ฐ๐—ฒ๐—ป๐—ฎ๐—ฟ๐—ถ๐—ผ๐˜€:Customer Behavior InsightsRepeat Orders: Track repeat orders of certain items or categories over time.
Popular Item Combinations: Identify frequently ordered item combinations.
Top-Selling Items by quantity highlight with case function
Sales Performance AnalysisTotal Sales: Calculate the total sales revenue generated by each menu item and overall.
Best-Selling Items: Identify the top-selling items and their contribution to total sales
Category Analysis: Analyze sales performance by different categories (e.g., American, Italian).
๐—–๐—ผ๐—ป๐—ฐ๐—ฒ๐—ฝ๐˜๐˜€ ๐—–๐—ผ๐˜ƒ๐—ฒ๐—ฟ๐—ฒ๐—ฑ:
Usage of Joins (left, right, self, cross joins two or more tables)
Usage of Single Row functions, character conversions
Usage of Grouping and Aggregation Functions.
Usage of CTE's and Subqueries
Usage of Window Functions like RANK, DENSE RANK, LEAD and LAG