Rohan Dastidar

Business Intelligence Engineer

Piramal Finance

Bengaluru

06.2022 - Current

Designed and deployed 25+ interactive Power BI dashboards and reports using DAX, Power Query, and data modeling techniques, enabling faster executive decision-making, and reducing reporting time by approximately 35%.
Developed complex DAX measures and calculated columns to support advanced KPI tracking (sales forecasting, YoY growth, cohort analysis), resulting in 20–40% more accurate business insights for finance and operations teams.
Integrated data from multiple sources (SQL Server, Excel, APIs, SharePoint) via Power BI Service and gateways, creating unified data models that improved cross-departmental visibility and data accuracy by 25%.
Optimized slow-performing reports and data models by refactoring queries, removing unused tables and relationships, and implementing incremental refresh, cutting dashboard load times by 40–60%, and enhancing user adoption.
Collaborated with business stakeholders, data engineers, and analysts to translate requirements into technical specifications, delivering self-service BI solutions that reduced ad-hoc report requests by 50%.
Automated monthly and quarterly reporting pipelines using Power BI Service schedules, dataflows, and gateways, eliminating manual Excel work, and saving teams 15 to 25 hours per cycle.
Implemented row-level security (RLS), data governance best practices, and workspace management in Power BI Service, ensuring compliance and secure self-service access for over 100 users.
Built and maintained semantic data models (star schema) supporting large datasets (>10M rows), incorporating incremental loading, and aggregations to handle high-volume refreshes efficiently.