Rohit Thapliyal

Power BI Developer with 3+ Years of experience in designing, developing, and optimizing Power BI dashboards, data models, and ETL pipelines. Expert in Advanced DAX, SQL Query Optimization, Power Query, and Data Modeling, with a focus on business intelligence and analytics. Skilled in Analytical and Business Modeling to derive actionable insights and supports strategic decision-making.

Adept at translating complex business requirements into scalable and insightful Power BI dashboards and data solutions.

Power BI Developer - Independent Power BI Projects (Self-Initiated) - Dehradun, India

(2024-11 - 2025-07)

• Designed and developed end-to-end Power BI dashboards using real-world and public datasets.
• Performed data cleaning and transformation using Power Query.
• Built data models and created advanced DAX measures for KPI tracking.
• Delivered insights on sales trends, customer behavior, and financial performance.
• Published and tested dashboards using Power BI Service.

Power BI Developer - Accelerant

(2021-11 - 2024-10)

• Designed interactive Power BI dashboards with Advanced DAX, Power Query, and custom visuals for better user experience.
• Integrated Power BI into cloud platforms such as Azure, APIs, SharePoint and AWS Data Lake for seamless integration.
• Implemented Power BI Service report scheduling and automated dataset refresh using Power Automate.
• Maintained and monitored Power BI Gateway, ensuring seamless data connectivity and performance.
• Optimized SQL queries and performed query tuning, reducing dashboard load times by 30%.
• Implemented Row-Level Security (RLS) and configured user and group security roles for restricted data access.
• Automated report refreshes and user access through Power BI Service API and Power Automate workflows.
• Translated business requirements into robust data models and intuitive Power BI dashboards to enable data-driven decision-making.
• Documented DAX measures, Power BI models, and SQL logic for long-term maintainability and cross-functional understanding.
• Utilized trend analysis, forecasting models, and KPI definitions to uncover performance insights across sales and operations.

Data Analytics Intern - Brillica Services Pvt Ltd, Dehradun - Dehradun

(2021-03 - 2021-09)

• Processed large datasets from SQL Server into Power BI, improving report efficiency by 30%.
• Worked with Direct Query and Composite Models for real-time reporting.
• Formulated DAX measures and Power Query transformations to optimize report calculations.
• Competent in Power BI Desktop, Power BI Service, Power BI Gateway, and Report Server.
• Analysed business data trends to provide actionable insights using Power BI and SQL.
• Migrated SSRS reports to Power BI Paginated Reports, improving report efficiency by 40%.
• Optimized paginated reports, migrating SSRS to Power BI for better performance and visualization.

B.Tech - Computer Science Engineering - Uttarakhand Technical University, Dehradun

Senior Secondary Education - SGRR Public School, Dehradun