About
Hello! I’m Nikita, a recent graduate with a Bachelor’s degree in Computer Applications (BCA) and a Master’s degree in Computer Applications (MCA) from Gurugram University. With a strong academic background and a passion for data analysis, I am now seeking opportunities to apply my skills in a professional environment. I possess expertise in Excel, MySQL, Power BI, Data Analysis, and Data Cleaning. 1. Excel Excel is one of the most widely used tools for data analysis, and I have gained proficiency in utilizing its advanced features. These include: Data manipulation (sorting, filtering, and formatting data). Complex formulas (VLOOKUP, INDEX-MATCH, IF statements, SUMIFS, etc.). Pivot Tables and Pivot Charts for summarizing and analyzing large data sets. Data visualization through various chart types such as bar charts, line graphs, and scatter plots to represent trends and insights. 2. MySQL: Adept at writing complex SQL queries to extract, analyze, and manipulate data. Experienced in database design, managing relational databases, and ensuring data accuracy. Familiar with using joins, subqueries, and aggregate functions to answer business questions. 3. Power BI: Skilled in creating interactive and visually appealing dashboards to present insights effectively. Proficient in using DAX to create calculated measures and columns for advanced analysis. Experienced in connecting Power BI to various data sources like Excel and SQL databases. 4. Data Analysis: Expertise in analyzing trends, patterns, and insights to support business decisions. Skilled in applying statistical techniques to solve real-world problems. Ability to draw actionable insights from large datasets and present them to stakeholders. 5. Data Cleaning: Proficient in preparing datasets for analysis by handling missing values, removing duplicates, and standardizing data formats. Experienced in identifying and resolving inconsistencies to ensure high data quality. Familiar with tools like Excel, MySQL, and Power BI for cleaning and organizing data. I recently completed a certification in "Data Analytics with Microsoft Power BI from NASSCOM Foundation", where I gained hands-on experience in building dynamic dashboards and visualizations. I am currently seeking an entry-level role in data analytics where I can leverage my technical expertise and analytical mindset to solve business challenges and contribute to organizational success. If you're looking for someone who is dedicated, skilled, and eager to learn, feel free to connect with me!
Education
Master of Computer Applications - MCA, Computer/Information Technology Administration and Management, Gurugram university
Bachelor of computer applications - BCA, Computer/Information Technology Administration and Management, Gurugram university
