Projects
Microsoft Power BI
HR ANALYTICS
We have developed an HR Analytics Intelligence Solution capable of performing real-time data analysis based on your employee data. This solution consolidates & automates all HR reporting and analysis needs in one place, showcasing insights such as 9-box Grid, Employee Turnover/Attrition, Survey & Satisfaction Score, Budget, Increment & Salary Distributions, Resource Utilization, and Leave Management. Leveraging Statistical Methods, Data Science, Machine Learning & AI, this Solution generates insightful Self-explanatory Analytics which are updated automatically and easy to share with the Stakeholders at different levels with different levels of access. With this Smart HR Analytics Solution you can make valuable decisions—from tracking employee performance and managing increments to optimizing budgets.
​
With this Smart HR Analytics Solution you can make valuable decisions—from tracking employee performance and managing increments to optimizing budgets.
Microsoft Power BI
Retail Customer Analysis
Thrilled to share the results of my latest project in Power BI, where I dove deep into understanding customer behavior and trends in the online retail industry.
It was really exciting to visualize-
🎯Monthly Cohort Performance
🎯Retention Rate
🎯Churn Customers
🎯Churn Rate
Trends and many more. Eager to continue leveraging data-driven approaches like these to drive meaningful impact in the retail sector!
Microsoft Power BI
FINANCIAL REPORT
We have developed a Financial Analytics Intelligence Solution capable of performing real-time data analysis based on your organization’s financial and operational data. This solution consolidates & automates all financial reporting and analysis needs in one place, showcasing insights such as income and expense tracking, cash flow management, budget optimization, revenue and profitability analysis, aged accounts and receivables management, turnover and financial health summaries, and resource allocation and utilization. Leveraging Statistical Methods, Data Science, Machine Learning & AI, this Solution generates insightful Self-explanatory Analytics that are updated automatically and easy to share with the Stakeholders at different level with tailored access controls.
​
With this Smart Financial Analytics Solution, you can make data-driven decisions, from optimizing cash flow and forecasting revenues to managing budgets and enhancing overall financial health.
Microsoft Power BI
HEALTHCARE ANALYTICS
We have developed a Healthcare Analytics Intelligence Solution capable of performing real-time data analysis based on patients and operational dummy data. This solution consolidates & automates all Healthcare reporting and analysis needs in one place, showcasing insights such as Bed Management, Financial Tracking, Patient flow Management, Discharge & Readmission Rates, Survey & Satisfaction Score, Resource Utilizations, Staff Management. Leveraging Statistical Methods, Data Science, Machine Learning & AI, this Solution generates insightful Self-explanatory Analytics which are updated automatically and easy to share with the Stakeholders at different level with different level of access.
​
With this Smart Healthcare Analytics Solution, you can make valuable decisions—from tracking patients’ outcomes and managing resource allocations to optimizing budgets and enhancing patient care.
Microsoft Power BI
Patients Dashboard
An in-depth Dashboard Guided by "@datalab365" to identify,
​
-
Average Wait Time
-
Patient Satisfaction
-
Total Patient Visits Monthly
-
Administrative vs. Non-Administrative Appointments
-
Referrals and Walk-In Patients
-
Patient Visits by Age Group and Race
to find out business problems and help out to make inform decision.
Microsoft Power BI
Maven Market Analysis
I undertook a comprehensive data analysis project, working with Maven Market data. To effectively manage and visualize the data, I utilized the power of Power BI. Firstly, I connected to the Maven Market data using Power Query to modify it to ensure its accuracy and consistency and prepare it for analysis.
​
Secondly, I made the relationship between the fact table and dimension table as a snowflake schema. Thirdly, I built 20+ DEX which allowed me to derive key metrics, perform advanced calculations, and generate meaningful insights from the data. Finally, I built an Interactive and Dynamic dashboard. I added additional pages to drill down Product Brand to Product Brand Details.
Google Looker Studio
Google Flood-It! Analysis
This dashboard is built by using Looker Studio, leveraging data from GA4 Google. By connecting Looker Studio to GA4 Google, I accessed and integrated key metrics, user behavior, and website performance data into the dashboard.
A total of 2 pages are on this dashboard which shows the overall summary Dashboard and Customer Details.
​
You can explore by clicking the link below-
​
Microsoft Excel
Super Store Sales Dashboard
The CSV file contained 4 years of data. Firstly, I imported the raw data into Excel using Power Query, allowing me to connect to multiple data sources, clean the data, and transform it into a structured format. Next, I employed Pivot Tables to summarize and aggregate the sales data. With Pivot Tables, I could quickly slice and dice the data, examine sales trends, identify top-performing products, analyze regional performance, and gain valuable insights into customer behavior. To enhance data visualization and create an intuitive representation of the analysis, I designed a dynamic dashboard in Excel. I crafted interactive charts, graphs, and visualizations that portrayed key performance indicators, sales trends over time, and product category breakdowns.
The dashboard not only provided a comprehensive overview of the Super store's sales performance but also allowed stakeholders to drill down into specific metrics and explore the data interactively.