Project Details

I completed a comprehensive Sales and Finance Report for the years 2019 to 2021, employing Excel to manage and analyze extensive datasets. This project allowed me to master advanced data analysis techniques, including the star schema with its critical fact and dimension tables. I honed my skills in creating and manipulating Pivot Tables and developed a strong proficiency in DAX formulas for dynamic data analysis. A key focus of my work was on designing user-empathetic reports, ensuring the findings were not only informative but also actionable and easy to understand, facilitating effective decision-making. This experience reinforced my capability to translate complex data into clear insights and deepened my passion for data analytics and visual storytelling. Moving forward, I am eager to apply these skills to new challenges and continue my growth in the field of Business Analytics.

Project Details

This project focused on developing a comprehensive PowerBI dashboard that provides in-depth insights into business operations across Finance, Sales, Marketing, Supply Chain, and Executive functions. Key achievements include securing a top-three industry ranking, a 353% increase in net sales, and effective market penetration strategies. The dashboard leverages advanced analytics techniques such as OLTP vs. OLAP, ETL processes, Power Query, and DAX, enhancing its capability to support strategic business decisions. These tools helped streamline data analysis, improving accuracy and efficiency in reporting and decision-making processes.

Live Interactive Dashboard

Project Details

Bank of America is enhancing customer service by introducing 24/7 online banking. This initiative addresses limited banking hours and long call center wait times, improving customer satisfaction while reducing operational costs. The project includes features such as digital profile management, account summaries, fund transfers, bill payments, and check orders. These capabilities allow customers to manage accounts conveniently, minimizing reliance on call centers and ensuring seamless banking experiences anytime, anywhere.

Project Details

This project simulates working as a Junior Data Analyst at Atliq Hardware, a fictional global tech company. I tackled 10 ad-hoc business queries using SQL to uncover meaningful insights such as sales trends, product performance, customer discounts, and market growth. The project demonstrates my ability to write efficient SQL queries, apply analytical thinking, and turn raw data into decision-making insights. Key SQL concepts used include CTEs, joins, subqueries, and aggregation functions. To complement the analysis, I created a PDF report and visual dashboard (Power BI) for easy interpretation. This project reflects my strength in solving real-world business problems through data storytelling and technical skill.