Vishal Pawar

Power BI Developer with over 4+ years of experience in developing robust data models and designing interactive dashboards. Expert in advanced DAX measures, SQL for ETL processes, and integrating Power BI with SharePoint and SQL databases. Proven track record in performance tuning and ensuring optimized end-to-end dashboard solutions. Committed to leveraging data insights to drive business decisions and enhance operational efficiency.

Project Name: Enowa Water
Domain: Smart City
Description: The client is ENOWA, which manages all the operations related to water for different projects under NEOM and is dedicated to the sustainable management and monetization of water resources, including both potable and recycled water. By utilizing advanced technologies and data analytics, ENOWA tracks water distribution, ensures quality monitoring, and optimizes financial operations. Its primary objective is to achieve efficient water resource management in line with NEOM's vision of building a sustainable, innovative, and technologically advanced city.
Roles and Responsibilities:

• Requirement Gathering: Collaborated with the Product Owner and key stakeholders to understand business needs, define objectives, and gather comprehensive requirements for dashboard development.
• Report Design and Development: Designed and developed dynamic, user-friendly Power BI reports and dashboards tailored to specific business requirements, ensuring clarity, usability, and actionable insights.
• Advanced Data Analysis: Utilized DAX functions and advanced formulas to perform complex calculations, create calculated columns and measures, and support in-depth data analysis for effective decision-making.
• Data Archival Process Implementation: Developed and implemented a streamlined archival process using dataflows to enhance data refresh speed, ensuring efficient processing of large datasets.
• Custom Visualizations: Integrated various custom visuals and charts, such as waterfall, heatmaps, and KPI indicators, to effectively communicate data insights as per the user’s requirements.
• Data Model Optimization: Optimized data schema, including relationships, table structures, and indexing, to ensure faster dashboard performance and seamless end-user experiences.
• ETL Operations: Conducted data extraction, transformation, and loading (ETL) processes using Power Query to prepare, clean, and structure raw data for accurate reporting.
• Performance Tuning: Regularly monitored dashboard performance metrics and applied best practices for performance optimization, including efficient query writing and minimizing data model size.
• End-to-End Ownership: Took end-to-end ownership of the dashboard development lifecycle, from gathering requirements to deployment, testing, and user training.
• Collaboration and Communication: Actively collaborated with cross-functional teams, including data engineers and analytics teams, to deliver data-driven solutions aligned with business goals.
• Documentation and Training: Prepared detailed documentation for dashboards, processes, and DAX calculations, and provided hands-on training to stakeholders on utilizing reports effectively.
• Compliance and Standards: Ensured all reports and dataflows adhered to ENOWA’s data governance and compliance standards, safeguarding data security and integrity.

Project Name: Customer And Product Analysis
Domain: Retail
Description: The client was a well-known Indian footwear and clothing manufacturer, marketer, and exporter with brand showrooms across India. They sell products under different categories such as footwear and clothing and manage multiple prominent brands in the market. The project aimed to analyze data by different brands, categories, subcategories, products, and locations to enable informed business decisions based on reports provided.
Roles and Responsibilities:

• Created advanced visualization reports using Power BI.
• Created calculated columns and measures using DAX.
• Developed, tested, and deployed standard reports and dashboards based on business requirement document specifications.
• Created parameterized reports based on client specifications.
• Updated weekly status and tracked overall development progress.
• Collected requirements from business analysts and analyzed use cases.
• Demonstrated proficiency in Power Query, Power Pivot, and DAX functions.
• Created drill-down and drill-through reports.
• Analyzed and tracked data to prepare forecasts and identify trends.
• Used a variety of charts, including lines, pies, bars, scatters, area, tree maps, maps, filled maps, gauges, funnels, single cards, multi-row cards, and slicers.
• Imported custom visuals from the Microsoft Power BI gallery based on client requirements.
• Implemented RLS (Row-Level Security) as part of data security.
• Worked on DAX functions like Date & Time, Time Intelligence, Filter & Aggregate, Logical, and Text.
• Scheduled data refreshes and worked with gateways for Power BI Desktop.
• Installed and configured gateway services for Power BI Desktop.

Project Name: Fortis Phase - 1
Domain: Healthcare
Description: The Hospital Data Analytics Project involves analyzing diverse datasets collected within a hospital to gain valuable insights and improve decision-making.
Roles and Responsibilities:

• Interacted with the client to gather and validate requirements.
• Used various data transformations like unpivot, column from examples, and blank queries to shape the data for creating reports.
• Modeled data using different cardinalities to build relationships between tables and develop a star schema.
• Used DAX functions like CALCULATE, ALL, and SWITCH to analyze data and build measures and calculated columns.
• Created visuals like bar charts, clustered column charts, KPIs, gauge charts, and line charts for trend analysis.
• Deployed reports to Power BI Service and scheduled refreshes.
• Conducted patient segmentation analysis, grouping patients based on characteristics such as demographics, diagnoses, or utilization patterns.