Anurag Kaushik

Senior Consultant @EY

Noida, IN

Project: National Grid Stream (USA)Design, develop, and maintain Power BI reports and dashboards to support business intelligence needs. Ensure best practices in data visualization, usability, and report performance. Implement Power BI features including calculated measures, KPIs, and custom visuals. Creating Hierarchies, Drilldown Reports, and sorting the Data in Visualizations, Grouping and Binning the Data. Creating Gateway to connect data sources, perform data transformation using ETL, handle real-time data, applying different types of filters and implementing Row-Level Security using Power BI Desktop & Services.Experience in setting up necessary connections. Developed and reviewed simultaneous SQL queries with join clause to validate static and dynamic data for data validation. Creating the SQL objects like tables, temp tables, variables and usage of SQL commands (DDL, DML). Implemented set operators like Union, Union all. Creating Constraints like not null, check and work on stored procedures, triggers, views & indexes using DDL, DML command and user-defined functions. Take regular database backup, data migration using Snowflake.

Indira Gandhi National Open University

Master's degree

Dr. A.P.J. Abdul Kalam Technical University

Bachelor of Technology - BTech