Sanket Kalugade

Sanket Kalugade

Data Analyst
India
Marathi, English, Hindi

نبذة عني

Data professional with a strong background in data cleaning, analysis, and visualization. Proficient in using Pandas and SQL for data cleaning, transformation, and extraction. Experienced in Power BI for creating interac…

الخبرة

Analyst

Hudl
Oct 2023 - حتى الآن · 2 سنوات 8 أشهر

Develop and maintain interactive, visually appealing dashboards in Power BI.
Utilize Power BI's data modeling features to structure and model data effectively.
Clean and transform data using Power Query Editor before importing into Power BI.
Establish relationships between tables and define hierarchies for optimal data representation.
Expertise in DAX for creating custom calculations and aggregations.
Write complex DAX expressions for measures, calculated columns, and tables.
Incorporate advanced analytics features such as forecasting, clustering, and trend analysis.
Transform raw data into meaningful visualizations for business stakeholders.
Provide end-user training and support on Power BI functionalities."

Jr. Data Analyst

Maxgen Technologies Pvt.Ltd
Feb 2023 - حتى الآن · 3 سنوات 5 أشهر

Leveraged SQL to extract data from relational databases, employing various window functions and advanced SQL queries to obtain valuable insights.
Collaborated with cross-functional teams to understand data requirements, translating business needs into actionable data solutions.
Created interactive and informative dashboards in Power BI, using DAX functions to calculate key metrics and implement advanced calculations.
Developed and maintained a library of reusable Power BI reports and templates, streamlining reporting processes and improving efficiency.
Utilized Excel for data analysis, applying VLOOKUP, pivot tables, and aggregate functions to extract meaningful insights from complex datasets.
Implemented advanced Excel functions to automate repetitive tasks, increasing productivity by 20%.
Collaborated with stakeholders to define data visualization requirements and created visually appealing reports and dashboards in Power BI to facilitate data-driven decision-making.
Designed and implemented Row-Level Security (RLS) in Power BI, ensuring secure and role-based access to sensitive data.
Created interactive and informative dashboards in Power BI, utilizing DAX functions for calculated measures and columns.
Published reports to Power BI workspaces, configured gateways, and scheduled data refreshes for up-to-date insights.
Implemented data subscriptions and alerts in Power BI, enabling stakeholders to stay informed on key metrics.

Design Engineer

SACPL Mumbai
Jun 2022 - Jan 2023 · 7 أشهر

Worked on modelling of Superstructure for Residential and Commercial project using CSI Etabs.
Flat Slab modelling and Design.
Controlling Time Period of structure within limit.
Performing various stablity checks against Wind and Seismic.
Worked on Substructure using CSI Safe.
Calculating and application of loads as per Indian Standard Code.
Issuing Approval of construction drawings.

المهارات

إكسل بايثون (لغة برمجة) مهارات التحليل جمع التبرعات باور بي آي قواعد البيانات العلائقية NumPy Pandas Matplotlib Microsoft Power BI SQL Advanced Excel DAX VLOOKUP Pivot Tables Window Functions Row-Level Security Data Visualization Data Cleaning Data Transformation Data Extraction Report Development Dashboard Development Gateway Configuration Scheduled Data Refreshes Data Subscriptions Alerts
الإبلاغ عن هذا الملف الشخصي؟