This comprehensive portfolio showcases my proficiency in modern business analytics tools and methodologies across multiple domains. Through 8 interconnected analytical projects, I demonstrate expertise in:
Technologies & Tools:
– Microsoft Excel (Pivot Tables, dynamic data analysis)
– SAP Analytics Cloud (data modeling, visualization, R-Algorithm, Smart Discovery)
– Tableau (interactive dashboards, geospatial analysis)
– Communalytic (text mining, sentiment analysis)
– SAP Analysis for Microsoft Excel (multi-dimensional enterprise data exploration)
Highlights:
– Applied multi-dimensional analysis to Global Bike Inc.’s sales data (130K+ records) to identify key performance drivers and product profitability patterns
– Conducted geospatial analysis of FAOSTAT sustainability data to uncover regional disparities in food security and emissions
– Created hierarchical data models for enterprise reporting and KPI monitoring
– Visualized historical CO₂ emission trends across countries using time-series and geographic mapping
– Performed sentiment analysis and text mining on wine reviews to extract consumer perception insights
– Implemented cluster analysis for retail store segmentation and association rule mining for categorical pattern discovery
Skills: Microsoft Excel · SAP Analytics Cloud · Tableau · Communalytic · SAP Analysis for Microsoft Excel
Author
shanghaizhangyijie@gmail.com
