Allen The Analyst Portfolio

Claimed "2nd Place" in the Power BI Desktop Dashboard Hackathon with This Dynamic Dashboard!

• View Project

This Power BI dashboard visualizes the company's financial story (2016-2019), combining P&L and balance sheet data to track performance and financial health.

• View Project

Empowered decision-makers with a data-driven Power BI dashboard to proactively manage loan portfolio health and mitigate risks.

• View Project

As part of the Datasense Certificate project in June 2023, I was tasked with developing a financial dashboard using Power BI

• View Project

Unveiling Insights and Driving Success with Comprehensive Data Analysis and Visualization.

• View Project

My task was to gain insights into customer behavior and ATM usage patterns by analyzing the transaction data. The goal was to identify opportunities for optimization and improvement to enhance customer satisfaction.

• View Project

My task was to analyze customer retention rates, behavior, and market trends to gain insights into customer cohorts.

• View Project

Conducted data mining techniques and exploratory data analysis on various datasets to uncover patterns, correlations, and insights for salary expectations, automobile factors, and diabetes risk factors.

• View Project

In this project, I meticulously clean and organize housing data in SQL Server.

• View Project

Data exploration in SQL Server enables efficient analysis of Covid-19 trends and patterns for better understanding of the pandemic's impact.

• View Project

SQL Server and Tableau's combination allows for efficient analysis and effective visualization of Covid-19 data, providing a powerful tool for understanding the pandemic's impact.

• View Project

In this project we look at what variables effect the gross revenue from movies.

• View Project

In this project, we utilize Python to develop a web scraper for Amazon, allowing us to extract product data.

• View Project

In this project we make automated file sorter to sort files in a designated folder.

• View Project

In this project, we automate the retrieval of cryptocurrency data from various APIs to analyze and track real-time price and market data for different cryptocurrencies.

• View Project

Tableau's visualization enhances data analysis of Airbnb, providing valuable insights into the vacation rental market.

• View Project

Power BI enhances data analysis of professional survey data, providing valuable insights and clear visual representation.

• View Project

Showing different variation of Visualization in Power BI using Apocalypse Store data.

• View Project

Creating data-driven sales campaigns for ecommerce. Tracking of sales trends to optimize inventory and increase profits.

• View Project

Creating comprehensive personal money manager empowers you to take control of your finances with a range of tools and resources, including goal-setting capabilities, a dynamic budget dashboard, detailed budget planning and tracking worksheets, automated calculation formulas, and user-friendly drop-down menus for easy data entry.

• View Project

Built a SMART financial dashboard with envelope budgeting, transaction tracking, expense insights, and proprietary algorithm for one-year budgeting.

• View Project

Interactive Dashboard with a theme Dark & Light.

Key Insights:

• Which month and year had the most profit?
• Where is the company seeing the most success (by country/region)?
• Which product and segment should the company continue to invest in?

• View Project

A financial statistics dashboard in Excel provides comprehensive and dynamic analytics, enabling users to analyze and interpret key financial indicators.

• View Project

I perform Amazon web scraping to collect and analyze multiple datasets, extracting valuable information and importing it into CSV format for further analysis.

• View Project

Highly motivated professional with a strong background in data analysis and visualization. Proficient in leveraging Tableau to create impactful dashboards and uncover valuable insights. Skilled in analyzing sales metrics, identifying trends, and implementing strategies to improve performance.

• View Project

In the fast-paced world of business data analysis, participants in the course 'SP201: Essential Excel Skills for Data Preparation and Analysis' harnessed the power of Excel to unlock valuable insights and craft an interactive financial dashboard for Aling Lala, the savvy business owner.

• View Project