Alper Halabi
Tableau: Customer Analysis Dashboard
The dashboard was created using Tableau to identify revenue streams in an easy-to-understand way to improve sales strategies. The dashboard contains various types of charts including a butterfly chart, a donut chart, a scatter plot, and more
Tableau: Financial Reporting & Analysis
Prepared P&L, BS, CF, and SCOE statements to perform financial analysis and developed dashboards using Tableau to reduce review time by 60%.
Created a visual collection and representation of the key financial metrics & KPIs needed to monitor the financial health of the business
Prepared cash flow statements for 3 years to measure business performance and make long-term business plans.
Calculated key ratios to measure the risk of the company and improve the risk management strategies
Excel: Stock Portfolio Tracker
An interactive stock portfolio dashboard on Excel that updates in real-time to successfully manage your stock portfolio for data-based decision-making.
SQL: COVID-19 Data Analysis
Prepared, manipulated, and analyzed 2020-2021-2022 COVID 19 Data using SQL by Joining tables on shared key columns, using Common Table Expressions (CTE) to simplify complex queries, employing window functions to calculate metrics such as moving averages and percent change, aggregating data with GROUP clause, creating views to store query results, and converting data types as necessary.
SQL: Housing Data Cleaning
Modified incomplete data in order to improve the quality of the data. Removed irrelevant and duplicated rows in order to reduce the size of the data set and improve the efficiency of the analysis. Split addresses and modified improperly formatted data in order to improve the accuracy of the analysis.
Welcome to Alper's Portfolio.
Take a look to get an idea about how I implement my skills and my approach from concept to execution.
