VIKRAM SINGH
Aspiring Data Analyst from India. Passionate about gaining Profitable Insights from the Data to help Businesses succeed.
Python
Pandas
Numpy
Scikit-learn
Microsoft SQL Server
Microsoft Excel
Tableau
- 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.
- 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.
- 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.
- 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.
- Built an interactive dashboard which provides insights about generation-wise spending in each category.
- Used Dual-Axis, Calculated-Fields, Charts, Filters etc.
- Built an interactive dashboard which provides details about the flights to and from san-Fransisco Airport.
- Used Makeline, Makepoint, Map, Charts, Zero-Axis etc.
Drop me a mail at ervikramsingh1995@gmail.com
Or call me at +91 8397959382
Built with ❤️ and dev.voyage