Tableau(Financial Analysis)

Project Description

Developed an interactive business intelligence dashboard in Tableau to analyze personal financial performance across income, expenses, savings, and investments. The solution transformed raw transactional data into actionable insights that support informed financial decision-making and improved financial management.

Business Problem

The client, a professional managing multiple income streams and investments, lacked clear visibility into overall financial performance because transaction data was fragmented across categories, payment methods, and investment types. This made it difficult to:

1. Track income growth over time
2. Identify high-impact spending categories
3. Monitor spending behavior and savings trends
4. Evaluate investment allocation
5. Analyze payment method utilization
6. Understand quarterly and seasonal financial patterns

As a result, financial decisions were largely reactive rather than data-driven.

About the Dataset

The dataset contained personal financial transaction records and included key attributes such as:

• Transaction Date
• Description
• Category and Subcategory
• Transaction Amount
• Transaction Type (Income, Expense, Investment)
• Payment Method
• Recurring Transaction Indicator
• Year and Month fields derived from transaction dates

The dataset was designed to enable analysis of income performance, spending behavior, investment allocation, and transaction trends.

Data Cleaning

To prepare the data for analysis and visualization, the following data-cleaning techniques were applied:

Get Bill Uchealor’s stories in your inbox

Join Medium for free to get updates from this writer.

Remember me for faster sign in
• Validated data quality and checked for inconsistencies across records.
• Standardized category and subcategory fields for accurate grouping and comparison.
• Verified and formatted date fields for time-series analysis.
• Created derived fields including Year and Month from transaction dates.
• Reviewed transaction classifications to ensure proper separation of Income, Expenses, and Investments.

Data Analysis

The dashboard was designed to answer key business questions including:

• Total income and expenditure performance
• Year-over-year financial trends
• Monthly income and expense fluctuations
• Category contribution to total income
• Payment method utilization
• Investment allocation across asset classes
• Quarterly transaction distribution

Finance Data — Daniel | Tableau Public

Key Insights

The analysis provided visibility into:

• Income and expense trends over time.
• Spending categories contributing most to total expenditure.
• The most frequently utilized payment methods.
• Distribution of investment capital across investment classes.
• Seasonal and quarterly transaction patterns.
• Relationships between income growth, spending behavior, and savings performance.

Recommendation

• Continuously monitor high-spend categories and establish spending limits where necessary.
• Track monthly income and expense trends to improve budgeting accuracy.
• Reassess investment allocation periodically to ensure alignment with financial goals.
• Use transaction and payment method analysis to optimize financial management practices.
• Leverage dashboard-driven insights for proactive rather than reactive financial decision-making.
• Monitor recurring expenses regularly to identify opportunities for cost reduction.