• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Created different KPI's using Table calculations and calculated key figures Manipulating strings, arithmetic calculations, aggregation options and Logical functions
• Provide segmentation analysis based on customers behavior, trends and profile attributes.
• Perform analyses on RFM (KPI) and assist in finding customers who has high probability of response using PROC FREQ, PROC MEANS, PROC SORT, PROC TABULATE.
• Designed customers searching models by applying V-lookup and advance filter in MS Excel.
• Converted and modified existing data to a more dynamic MS Excel dashboard and pivot tables report.
• Maintained SQL databases and responded to client and analyst requests using queries.
• Provided interpretive data analysis and identified changes in KPIs, causes of the change and impact to the business.
Reviews For This Service