VIKRAM SINGH

Aspiring Data Analyst from India. Passionate about gaining Profitable Insights from the Data to help Businesses succeed.

Skills

Python

Pandas

Numpy

Scikit-learn

Microsoft SQL Server

Microsoft Excel

Tableau

Projects

Analysis of IPL-2022 Datasets & Insights Visualization using Python Programming, Pandas, Numpy and Matplotlib

- Cleaned up and Organized the data for the processing stage.

- Analyzed the data and Visualized different Insights e.g. Top Batsmen, Top Bowlers, Highest Scorer team and Player, Number of Fours & Sixes, Highest Run Chased & Defended etc.

Analysis of Multiple Brands Cars Data & Dynamic Dashboard for the Insights using SQL and MS Excel

- Used different SQL Queries to retrieve the required data.

- Connected the retrieved Tables to MS Excel using Power Query and Visualized all the Insights in an Interactive Excel Dashboard.

Analysis of e-Commerce Data and Various KPIs using SQL

- Retrieved and Analyzed different Sets of Data using SQL Queries.

- Gained Insights about Various KPIs e.g. Sales by Product, Offer Effectiveness, Customer Acquisition etc.

Fully Automated Sales and Discounts Dashboard using MS Excel

- Developed an Interactive Dynamic Dashboard by providing the Folder Path for Multiple Source-Files with Multiple Worksheets.

- Used ::- Power Query, Calculated Fields, Sparklines, Pivot Tables, Slicers, Charts, Tabular View Navigation.

Tableau Dashboard For Generation-Wise Spendings

- Built an interactive dashboard which provides insights about generation-wise spending in each category.

- Used Dual-Axis, Calculated-Fields, Charts, Filters etc.

Tableau Dashboard For San-Fransisco Airport Flights Data

- Built an interactive dashboard which provides details about the flights to and from san-Fransisco Airport.

- Used Makeline, Makepoint, Map, Charts, Zero-Axis etc.

Let's connect