My objective is to be a part of the organization with professional work driven environment where I Can utilize & apply knowledge and skills to grow while fulfilling organizational goal. Strengths include, good communication, team handling an ability to focus on detail.
1. Googlesheets online retail store purchase analysis
Goal- To analyse the key performance indicators of LES retail store brand.
Solution- i) On the basis of countries, the RFM analysis of USA & UK is 22.5% and Australia, China and India is 18.4%.
ii) On the basis of Customer classification, Champions have the maximum RFM score of 544 and Hibernating has the minimum score of 222.
2. Power Bi Finance Department of ABC Company Analysis
Goal- To build a dashboard with some key metrics, that can be one source of truth for all regions.
Solutions- i) EMEA region has the highest amount by 12.87 million.
ii) On the basis of report, the highest amount is 248.89 M and the sum of payslips generated by month is 5.25 M.
3. SQL distribution of duration of trending videos analysis
Goal- To analyse the distribution of duration of videos on the basis of various categories.
Solutions- i) On the basis of country, Great Britain has the highest no of videos trended for 36 daysand Canada has the lowest no of videos trended for 1 day.
ii) On the basis of category, music has the highest average trending period for 13 days.
4. Power Bi invoice details of all vendors in Accounts Department analysis
Goal- To create a dashboard that can help procurement department make better supply chain strategic decisions.
Solutions-i) The highest RM grade is GI by 5.2k and the lowest RM grade is SG BY 3.9k.
ii) The strategic status of Go is 60% and NoGo is 40%.
iii) The highest casting source is AMA BY 5.4k and lowest casting source is FLO Enterprise by 1.9k
iv) In Part Family Tonnage, the Feed Pump Housing has the highest percentage of 22.67%