Banner Image

All Services

Other

Data analyst and reporting analyst

$5/hr Starting at $25

• 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.

About

$5/hr Ongoing

Download Resume

• 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.

Skills & Expertise

AnalyticsCustomer ServiceData AnalysisData ManagementData VisualizationDatabase DevelopmentExcelGraphsIndexMatchMicrosoftMicrosoft ExcelMicrosoft Excel DashboardsMicrosoft Excel Pivot TablesModelingPackaging DesignReport WritingReportsSpotfireSQLSSRSTable DesignTableauVBAVLOOKUP

0 Reviews

This Freelancer has not received any feedback.