2024Experience
Data Analyst Intern
Trianz
Built practical tools for construction industry and business intelligence dashboards for data-driven decision making.
- Company
- Trianz
- Type
- Data Analytics
- Duration
- 2 months
- Location
- Bangalore, India
01Impact
By the numbers.
1000+
App Downloads
10+
Dashboards
80%
Time Saved
4.7★
User Rating
02Responsibilities
What I owned.
01
Developed Flutter mobile application for construction calculations
02
Created Power BI dashboards with DAX measures
03
Implemented data modeling with star schema
04
Built PDF report generation system
05
Designed interactive visualizations and drill-down capabilities
06
Optimized dashboard performance with aggregations
07
Created automated reporting schedules
03Projects
What I shipped.
Concrete Material Calculator
Mobile app for construction material calculations
- Downloaded by 1000+ construction professionals
- Achieved 98% calculation accuracy
- Reduced calculation time to 5 minutes average
- Maintained 4.7-star user rating
- Generated professional PDF reports
- Flutter
- Dart
- PDF Generation
- SQLite
Power BI Analytics Dashboard
Business intelligence dashboards for KPI tracking
- Built 10+ interactive dashboards
- Tracked 50+ KPIs with automated calculations
- Reduced reporting time by 80%
- Maintained 100% data accuracy
- Implemented drill-down and cross-filtering
- Power BI
- DAX
- Power Query
- SQL Server
04Engineering
Technical depth.
Mobile Development
- Built intuitive UI with Material Design
- Implemented complex calculation engine
- Created PDF generation with branding
- Developed unit conversion system
Business Intelligence
- Designed star schema data models
- Created complex DAX measures and calculations
- Implemented incremental refresh for performance
- Built reusable measure library
Data Visualization
- Interactive dashboards with drill-down
- Custom visuals for specific use cases
- Automated report scheduling
- Cross-filtering across multiple visuals
05Stack
Tools used.
mobile
- Flutter
- Dart
- SQLite
- PDF Generation
analytics
- Power BI
- DAX
- Power Query
- M Language
data
- SQL Server
- Excel
- SharePoint
tools
- Git
- VS Code
- Power BI Desktop
Key learnings
- Mobile app development with Flutter
- Business intelligence with Power BI
- DAX for complex calculations
- Data modeling and optimization
- PDF generation and reporting
- User-centered design principles
- Performance optimization techniques