ARPITHA KANNAYYAGARI

Accenture

08.2023 - Current

Passionate Data Analyst with hands-on experience in Power BI dashboard development, Datasets optimization, KPI creation, and business reporting. Adept at converting complex datasets into clear, impactful insights used by business stakeholders.
Key Contributions:
Optimized two large datasets by removing redundant tables/columns and restructuring the data model using Snowflake schema for improved performance.
Enhanced query performance by migrating complex SQL logic to SQL Server views and using them as optimized sources in Power BI.
Worked on Anaplan migration project by modifying existing SQL-based reports to integrate Anaplan as a source, improving data refresh performance and simplifying dataset structure.
Developed multiple interactive Power BI reports using buttons, drill-through pages, tooltips, slicers, and custom KPIs aligned with business goals and client requirements.
Interacted with stakeholders to define and create KPIs, ensuring clarity, measurable outcomes, and alignment with business metrics.
Installed and configured Power BI Gateway and collaborated with server teams to add required connectors/drivers including MariaDB, Access Database Engine, and ODBC drivers, enabling seamless data refresh and connectivity.
Ensured high accuracy, data consistency, and performance by applying best practices in data modelling, KPI logic building, DAX optimization, and report validation.

Similar Profiles