Shubham Sharma

A proactive and quick learning individual looking for a chance to work as a dynamic analyst using analytical skills to enable the organization to accomplish business objectives. An M.S. in Business Analytics coupled with experience will make me a positive asset to your organization.

PowerBi Masterclass Data models & DAX formulas

SUV Purchase Prediction February’20

• Predicted buyers of SUV cars depending upon their age and salary and visualized information to extract insights
• Used Logistic Regression with 83.33% accuracy

Cairns Well Management Project March’20

• Used various measures and time intelligent functions to show data insight
• Made use of imported visuals such as chicklet slicer and scroller to make dynamic dashboards

Covid-19 Death Ratio Anlaysis November’20

• Made total death by country analysis on date basis
• Designed a Dashboard which shows total death in various countries in past week and also showing total deaths that took place before and after the selected date

NBA Player Analysis using Power Bi November’20

• Performed data wrangling techniques to improve data quality and made use of time intelligent DAX functions such as YTD,MTD,QTD,TotalQTD,TotalYTD,TotalMTD to find monthly average points scored over years 2010-2018 by Steph Curry
• Made use of calculated column to introduce a new column which helps in determining the accuracy (field goals attempted to field goals scored ratio) of Steph curry in each season
• Determined that Steph Curry had his best years between 2010-2018 in 2012 when he had a total 3 pointer field goal accuracy of 45%

Nordstorm Database May’21

• Created Entity-Relation diagrams and multi-dimensional models,reports for analyzing organizations throughput.
• Developed physical and Logical Design of the database and made physical design using DDL
• Extensively used joins and subqueries to simplify complex sql queries involving multiple tables Created views and stored procedures that were used in the report
• Performed data visualization using Tableau and developed a dashboard to present sales profit and revenue across different

• Taught Mathematics and Computers to the underprivileged students for 1 month.
• Spread awareness about the National Pension System of India in economically weaker sections and successfully assisted 9 6 people in enrolling in the scheme over a span of 3 months.

• Done volunteer work for the TVF pitch off.
• Done volunteer work in blood donation camp held in college.