Aarushi Pandey

WORK HISTORY

EDUCATION

ABOUT AARUSHI PANDEY

2+ years of professional experience in the IT industry, an expert in Power BI and its various components, including Power Query, Power Pivot, Power View, and Power Map, with a deep understanding of data modeling and visualization techniques.• Skilled in utilizing various tools and technologies such as Excel, Advanced Excel, VBA, DBMS, SQL, Power BI, DAX, Tableau, SSRS, R, Python, and Azure• Adept at interpreting complex data sets, extracting meaningful insights that can be used in identifying key data relationships, trends & patterns to make data-driven decisions• Expertise in Advanced Excel techniques for presenting data findings and trends, including proficiency in DATE-TIME, SUMIF, COUNTIF, VLOOKUP, FILTER functions, pivot tables, charts and more• Expertise in VBA for automating repetitive tasks, creating custom functions and macros, and developing complex solutions to improve data management and analysis efficiency• In-depth understanding of DBMS for data management, integration, and analysis, including experience in designing and implementing relational databases, and proficiency in working with various DBMS• Strong knowledge of SQL for querying, manipulating, and managing relational databases, including proficiency in writing complex queries, optimizing performance, and utilizing DQL, DDL, and DML statements for data management and integration• Expertise in using Power BI for data visualization and analysis, including proficiency in creating interactive dashboards, reports, and charts, and having knowledge in utilizing advanced features such as Power Query, DAX, and advanced DAX functions to perform complex data analysis and modeling• Skilled in identifying, defining, and tracking KPIs to measure the performance and success of business operations, utilizing data analysis techniques and tools to monitor performance, and providing insights and recommendations to improve performance and drive growth• Strong knowledge of statistical methods and techniques, including proficiency in using statistical tools such as R and Python to perform data analysis, hypothesis testing, and modeling, and ability to interpret and communicate statistical results to non-technical stakeholders• Experienced in implementing data security measures to protect sensitive information. Knowledge of best practices for data encryption, access control, and data governance, and proficiency in working with security tools and technologies to ensure compliance with industry regulations and standards