As a data analyst, my role is primarily focused on utilizing Power BI to extract valuable and actionable insights from the data. My responsibilities included:•Integrating multiple data sources into Power BI using Power Query to create comprehensive datasets for analysis.•Performing robust data cleaning operations and data modeling.•Skilled in writing SQL queries to retrieve, filter, and manipulate data from relational databases.•Leveraging complex DAX functions to create calculated columns and measures.•Conducting data analysis to identify trends and patterns, providing actionable insights to stakeholders through a variety of visualizations available in Power BI.•Designing and developing dynamic reports and dashboards in Power BI to visualize key performance indicators (KPIs) and track business metrics in real-time.•Publishing the created dashboards to the Power BI service, enabling seamless sharing and collaboration with relevant team members and stakeholders.•Integrating Excel and SQL into my workflow as needed, leveraging their respective capabilities for data manipulation and analysis.•Weekly Performing ETL Process of Data into Power BI to check the data quality and its health and also by comparing it with previous extraction.Key Achievements•Spearheaded the transition from manual reporting methods to automated dashboards in Power BI, reducing report generation time by 50% and enhancing data accuracy.•Identified cost-saving opportunities by analyzing data using Power BI, resulting in a 15% reduction in Overall expenses.•Collaborated with cross-functional teams to gather requirements and develop custom Power BI solutions tailored to specific business needs.•Used time series forecasting and predictive analytics to forecast the future trends of all metrics based on historical data.•Implemented data governance best practices within Power BI, resulting in a 20% reduction in data errors and increased data reliability.

Along with my day to day activities of Civil Engineering, Implemented Power BI dashboards to track project progress, analyze budget, Resource allocation, optimization of labour management and enhance client communication, leading to a 15% reduction in project timelines and increase in client satisfaction.•Imported the data to power BI through simple data sources like Excel spreadsheets.•Cleaned and transformed raw data to make it suitable for analysis using Power Query.•Used data modelling concepts to develop relationship between different tables.•Used DAX to create Calculated Column and measures as per the requirement.•Analyzed the data through various visualization as per the requirement and delivered insights effectively.•Developed, maintained, and updated interactive Power BI reports and dashboards for associates.•Facilitated collaboration by sharing interactive dashboards with team members and clients, promoting data-driven decision-making.•Continuously learned and upskilled to stay updated with the latest data analysis technologies and trends.