Shalom's Portfolio

I am an enthusiastic data analyst with proficiency in Excel, SQL, Power BI, R programming & Tableau.
Visit my LinkedIn profile.

January, 2024

Data Cleaning in SQL

we performed comprehensive data cleaning on a dataset containing Nashville house sales information which including handling missing values, standardizing formats, removing duplicates, and transforming the data utilizing SQL to ensure data quality and integrity for subsequent analysis.

June, 2024

Excel Stock Portfolio

Here, I developed a comprehensive stock portfolio dashboard using Excel to provide real-time data analysis and visualization for investment tracking and performance assessment.

January, 2024

Data Visualization in PowerBi

I utilized Power BI to visually explore and analyze a sales dataset, creating dynamic and insightful visualizations that provided actionable insights for stakeholders. Through interactive dashboards and intuitive data representations, I effectively communicated key trends and patterns, aiding in data-driven decision-making processes.

February, 2024

Data Cleaning And Visualization In Excel

Here we conducted end-to-end data processing on a bike sales dataset in Excel, encompassing meticulous data cleaning, in-depth analysis, and insightful visualization utilizing pivot tables. Through Excel's pivot table functionality, I uncovered valuable insights and trends, facilitating informed decision-making for stakeholders.

February, 2024

Data Exploration in SQL

I conducted data exploration and analysis on a COVID-19 dataset using SQL, uncovering valuable insights and trends. Through SQL queries and analytical techniques, I delved into the data's intricacies, revealing key patterns and informing strategic responses.