Retail Trade Index by Region - RS Data Analysis
Track retail commerce index trends across Rio Grande do Sul regions from raw government data.
This template organizes raw data from the Rio Grande do Sul State Treasury (Secretaria da Fazenda do RS) to analyze retail trade indices across different regions. It structures monthly index data from January 1999 to June 2003, broken down by Porto Alegre (POA), Metropolitan Region (RMPA), Non-Metropolitan Region (RNMPA), and the overall RS state level.
Ideal for economists, regional analysts, and government researchers studying historical retail trends and regional economic performance. The template removes the burden of manual data organization, allowing focus on trend analysis and regional comparisons.
What's inside
- Multi-region index comparison (POA, RMPA, RNMPA, RS)
- Monthly time-series data organization
- 5-year historical dataset (1999-2003)
- Government source data integration
- Regional breakdown structure
Download this template
.xlsx · 1 sheet · included with lifetime access
More in Data Analysis & Visualization
21st Century Asset Allocation Pie Chart
Visualize your net worth distribution across asset types with an interactive pie chart.
- Automatic pie chart generation
- Asset type and amount input fields
- Dynamic percentage calculations
21st Century Pie Chart - Asset Breakdown
Visualize your asset allocation across savings, investments, and retirement accounts with an interactive pie chart.
- Pie chart visualization of asset distribution
- Asset type categorization
- Amount tracking by asset class
Analysis Report Template
A comprehensive analysis report template for tracking and visualizing business metrics like revenue and profit.
- Revenue tracking
- Profit calculation
- Error handling with IFERROR
Analytics Data Dashboard
Comprehensive business analytics dashboard tracking customer satisfaction, sales performance, social media engagement, email campaigns, and lead generation metrics with interactive charts and KPI visualizations.
- Pre-built KPI calculations with formulas
- Multi-sheet analytics for different channels
- Social media engagement tracking