Ritika Agarwal
Data Analyst
Lucknow
Summary
PL 300 and DP 600 Certified Power BI Developer with 4+ years of IT experience, specializing in design, development, and deployment of interactive dashboards, reports, and data models. Proficient in DAX, Fabric, Power Query (M language), SQL, and advanced data transformation techniques. Experienced across the full Business Intelligence (BI) lifecycle, from requirements gathering and ETL processes to publishing optimized and user-friendly dashboards. Adept at building KPIs, slicers, drill-throughs, and delivering compelling data stories to enable informed, strategic decision-making.
Overview
4
4
years of professional experience
5
5
Certifications
Work History
Power BI Developer
Tata Consultancy Services
Lucknow
08.2021 - Current
- Designed, developed, and published interactive dashboards, paginated reports, and self-service datasets in Power BI, enabling data-driven decision-making for enterprise clients.
- Built scalable data models (star schema, snowflake, and data marts) with well-structured fact and dimension tables, supporting reusable reporting across 5+ departments and 100+ recurring consumers.
- Created advanced DAX measures, calculated columns, and semantic layers for time intelligence, budget variance, cost optimization, and automation impact tracking.
- Developed and maintained ETL/ELT pipelines using Power Query (M), SQL Server, and Fabric Dataflows (Gen2) to integrate structured, semi-structured, and unstructured data sources.
- Leveraged Azure Data Explorer (ADX) and wrote Kusto Query Language (KQL) scripts to retrieve and manipulate large volumes of telemetry and log data for reporting.
- Implemented Row-Level Security (RLS) to enforce access policies for 50+ leaders, ensuring secure and role-based access to sensitive data.
- Managed Power BI Workspaces, Apps, and governance frameworks, including access permissions, version control, role-based content visibility and optimized distribution of reports.
- Automated and monitored 6+ scheduled dataset refreshes daily in Power BI Service, reducing manual effort by ~8–10 hours weekly.
- Leveraged Microsoft Fabric Lakehouse for centralized storage, transformation, and integration of enterprise data, enabling unified analytics across teams.
- Utilized Fabric Dataflows and Pipelines for automated ingestion and transformation, improving reusability and reducing redundant ETL processes.
- Explored DirectLake mode in Fabric to enhance Power BI performance by enabling near real-time reporting on large datasets.
- Conducted data analysis and trend identification, detecting outliers and correlations to support strategic planning and process improvements.
- Enhanced report interactivity with advanced visualization techniques (drill-throughs, slicers, bookmarks, tool tips and conditional formatting).
Education
B.Tech - Electronics & Communication Engineering
SRMGPC
Lucknow08.2021
Skills
Microsoft Power Bi
Microsoft Fabric
SQL
Python
Data Modelling
DAX
undefinedCertification
Microsoft Certified: Power BI Data Analyst Associate
Timeline
Power BI Developer
Tata Consultancy Services
08.2021 - Current
B.Tech - Electronics & Communication Engineering
SRMGPC
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Anamika YadavAnamika Yadav
Intern at OCTAGATEIntern at OCTAGATE