Project Details

📌 Project Overview:
In "Business Insights 360," we aimed to create an all-encompassing data analysis tool for AtliQ Hardware, integrating data from diverse sources including Excel/CSV files and a SQL database. The result? A dynamic Power BI dashboard offering comprehensive insights into global sales trends.
🛠️ Key Achievements:
1️⃣ Seamless Data Integration: Integrated data from Excel/CSV files and a SQL database to ensure a unified and dependable dataset.
2️⃣ Advanced Data Modeling: Developed a sophisticated data model in Power BI to facilitate efficient analysis and reporting. (STAR & SnowFlake Schema)
3️⃣ Performance Optimization with DAX Studio: Leveraged DAX Studio to enhance the dashboard's performance, achieving a notable 5% increase in speed and responsiveness.
4️⃣ Insightful Visualizations: Crafted compelling visualizations in Power BI, empowering AtliQ Hardware with actionable insights across various departments.

Live Interactive Dashboard

Project Details

The hospital charges dataset has 1000 plus ailments, 3000 plus healthcare providers from 50 states and 200 cities across the USA and it describes the cost of treatment for approx. 7 million patients. The dataset has very much useful information about the patients' providers, treatments and charges. we applied analysis and we got solutions to the business problems we defined.

Project Details

SP_500 is a stock market index tracking the stock performance of 500 large companies listed on the stock exchange in the United States including (Microsoft, Apple, Tesla, etc). According to the Capital Asset Pricing Model, the slope coefficient Beta in a simple regression of the excess return on the stock vs. the stock return on the market is a measure of the relative risk of the stock. Stocks with higher Betas are more risky and therefore should have higher returns in the market.
We analyse this data and find trends from this data to provide a visualised solution to the problems.
find descriptive statistics of stock values for each company which can provide more details like mean, median and mode values and more.
find trends for stock values of open, high, low and close and visualize it on chart for each company.
find the percentage change over 5 years and visualize it on scatter chart.
find market risk through the regression analysis and visualize it on chart.

Project Details

The problem is centred around a consumer finance company that specializes in lending loans to urban customers. The company struggles to make accurate loan approval decisions due to insufficient or non-existent credit histories of applicants. This leads to both missed business opportunities and potential financial losses if loans are approved for applicants likely to default. The goal is to use Exploratory Data Analysis (EDA) to identify patterns and attributes that indicate an applicant's likelihood of facing difficulty in repaying loans. By understanding the driving factors behind loan defaults, the company aims to optimize its decision-making process and mitigate risks associated with loan approvals.

Project Details

This project is based on Tableau so we will use the Tableau public for this throughout.
• We create a visualization of each problem and make dashboards for match, player and team for this project.
• At last, we give the conclusion for this project.
The Indian Premier League,or IPL,is a T20cricketleague, which was founded in 2008 and is held every year. It sees participation from both national and international players, and eight teams representing eight Indian cities compete with each other in a double round-robin format in the league stages, which are followed by playoffs.
• Over the years, IPL has become one of the most-watched and most attended live sporting events all over the world.
• For this project, in some cases, we will use the visual representations as we have created in Tableau directly for their infographic, and in a few other cases, we will use important statistics after trying out the different filters and customisations that we have provided for interactivity.

Project Details

I designed and implemented a comprehensive Power BI Dashboard providing insights into customer trends, revenue growth, and segment analysis tailored to meet business requirements. Key features include:

Total Customers & Revenue Growth Rates: Displays essential metrics for an instant overview of performance.
Trend Analysis: Interactive graphs with toggles for Revenue and Customer Trends, making data exploration intuitive.
Segment Analysis: Visualized revenue and customer data by city and age group for targeted insights.
Month-over-Month Analysis: Tracked policy changes to highlight trends and opportunities.
Sales Mode Analysis: Identified customer demographics and preferences across sales channels.
Age Group Analysis: Evaluated the impact of various age groups on key business metrics.
This dashboard enabled data-driven decision-making and strategic growth.

Live Interactive Dashboard