Deepthi

Data Analyst

Capgemini

Dec 2020 - Present

Having 4 years of end-to-end experience developing complex Power BI solutions, including advanced data modeling and sophisticated DAX measures to drive business insights. Significantly improved report performance by implementing Incremental Refresh, creating Aggregation Tables and optimizing data models to reduce refresh times and latency. Expert in utilizing both Import and Direct Query modes; established complex relationships across multi-table models sourced from diverse enterprise data systems. Strengthened data security and user access management by implementing Row-Level Security (RLS) ensuring secure report sharing and preventing data leaks while maintaining compliance with security protocols. Spearheaded the development of reusable Power BI templates, automating 40% of report development by providing standardized designs, best practices, and compliance adherence, significantly accelerating report generation. Authored Standard Operating Procedures (SOPs) for data processes, enhancing documentation, facilitating knowledge sharing across teams, and fostering a collaborative and informed work environment. Designed interactive dashboards using Drill-through, Tooltips, and Custom Visuals to deliver a superior user experience and meet specific business requirements. Proficient in managing Power BI Service, including gateway configuration, migration, and scheduling automated refreshes to ensure data accuracy. Leveraged Power Query for complex data transformations and utilized Time Intelligence functions to provide year-over-year and period-over-period trend analysis.