Ankit Mehta
Data Analyst Intern @Mvp Studio
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst Intern @Mvp Studio
Project Contribution: Played a key role in the \'Property Analysis\' project, contributing to data analysis, report creation, and cross-platform integration to support decision-making within the company.Data Integration & ETL Process: Developed a star schema by implementing SSIS ETL processes to extract, transform, and load data from Excel into SQL Server. Utilized Conditional Split, Lookup, and Merge transformations to ensure accurate data flow and integration.Data Modeling: Designed and implemented a star schema to structure the data for efficient querying and analysis.Power BI Reporting: Created an interactive Power BI report incorporating slicers, hierarchies, and bookmarks to enhance data visualization and user experience.SSRS Reporting: Developed a detailed SSRS report to provide in-depth analysis and reporting capabilities.Cross-Platform Integration: Connected the SSRS report with Power BI through navigation links, enabling seamless access between reports and enhancing the overall reporting experience.
EDUCATION
Deakin University
Master's Degree
CGC College of Engineering, Landran, India
Bachelor of Technology - BTech
ABOUT ANKIT MEHTA
Graduated with a Master’s in Data Science from Deakin University in February 2024…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.