Kawal Kaur

Data Analyst Intern @Mvp Studio

Auckland, NZ

Business Intelligence Projects at MVP StudioSuccessfully completed a series of 9 end-to-end BI and Data Warehousing projects focused on Australian property data. Projects included:# Designed and implemented ETL pipelines using SSIS to integrate and transform data from diverse sources.# Built and maintained Star Schema data models following Kimball methodology.# Developed interactive dashboards in Power BI and paginated reports in SSRS.# Consolidated and analyzed datasets on Property, Schools, Crime, and Transport.# Delivered clean, insightful visualizations to support strategic decision-making.Tools: SQL Server, SSIS, Power BI, SSRS, MS Excel, Kimball MethodologyKey Outcomes:# Improved data reliability and reporting efficiency.# Enabled drill-through analytics by integrating SSRS reports with Power BI.# Gained strong hands-on experience across the full BI lifecycle.