data analyst
Overseas Marine Services
Total years of experience :1 years, 5 Months
• Implemented a data-driven approach to hotel accommodation management
using Power BI, tracking guest occupancy and room availability for each
company.
• Developed interactive dashboards in Power BI to monitor guest arrivals, room
bookings, and availability in real-time, ensuring timely updates for accurate
decision-making.
• Utilized Power BI's data modelling capabilities to integrate and analyse data
from various sources, including booking systems and guest databases.
• Created dynamic reports and visualizations to provide daily insights into guest
occupancy, room availability, and revenue performance for each company,
enabling proactive management and resource allocation.
• Automated the generation of daily and monthly reports summarizing guest
counts, total room occupancy, and revenue projections, facilitating data-driven
decision-making and strategic planning.
• Collaborated with hotel management teams to identify key performance
indicators (KPIs) and develop customized dashboards and reports tailored to
specific business needs and objective
• Translated business needs into technical specifications and expertly developed,
published, and scheduled Power BI reports as per the business requirements.
• Proficiently created calculated fields, slicers, filters, groups, hierarchies, dynamic
measures/titles, and bookmarks using Power BI.
• Project: ECF Payment Dashboard: Designed Expense Claim Form Payment
dashboard to track employee expenses.
• Project: Recruitment Analysis using Power BI: Created interactive dashboard
to analyze the candidates.
• Collaborated with various business units to identify new data requirements, analysis strategies, and reporting mechanisms.
• Conducted data analysis in relational databases using SQL queries.
• Demonstrated expertise in developing calculated measures using Data Analysis Expression language (DAX), including aggregate, text, date, and logical functions.
• Utilized time intelligence calculations and functions to create insightful reports.
• Project: HR Data Analysis using Power BI : Designed a Power BI dashboard to track employee data for HR team, including personal details, salary, and expenses.
• Project: Sales Insights - Brick & motor business \[Power BI SQL\]: Created interactive dashboards to visualize sales trends, revenue, and customer behavior. The final dashboard was effective at displaying trends, allowing users to understand the data and make informed decisions.
• Gathered and analyzed data on gold and diamonds target markets, customer
segments, and market dynamics to support marketing decision-making.
• Developed dashboards in Power BI to conduct in-depth analysis of gold and
diamonds marketing data, including campaign performance, customer behavior,
and market trends.
• Utilized DAX, calculated fields, slicers, filters, and power query for dashboard
preparation in Power BI using gold and diamonds sales and marketing data.