Dataset

This dataset was created by alejo1308

Contents

Dataset

This dataset was created by Yogesh_Royal

Contents

Dataset

This dataset was created by Aasim Parwez

Contents

Dataset

This dataset was created by Social.joker

Contents

Dataset

This dataset was created by mohannad wathik

Released under Apache 2.0

Contents

Power BI Dashboard : https://www.mavenanalytics.io/project/3776

The IPL (Indian Premier League) is one of the most popular and widely followed cricket leagues in the world. It features top cricket players from around the world playing for various franchise teams in India. The league is known for its high-scoring matches, intense rivalries, and innovative marketing strategies.

If you are a data enthusiast or a cricket fan, you will be excited to know that there is a dataset available on Kaggle that contains comprehensive information about the IPL matches played over the years. This dataset is a valuable resource for anyone interested in analyzing the performance of players and teams in the league.

The IPL dataset on Kaggle contains information on over 800 IPL matches played from 2008 to 2020. It includes details on the date, time, venue, teams, players, and various statistics such as runs scored, wickets taken, and more. The dataset also contains information on the individual performances of players and teams, as well as the overall performance of the league over the years.

The IPL dataset is a goldmine for data analysts and cricket enthusiasts alike. It provides a wealth of information that can be used to uncover insights about the league and its players. For example, you can use the dataset to analyze the performance of a particular player or team over the years, or to identify trends in the league such as changes in team strategies or the emergence of new players.

If you are new to data analysis, the IPL dataset is a great place to start. You can use it to learn how to use tools such as Excel or Power BI to create visualizations and gain insights from data. With the right skills and tools, you can use the IPL dataset to create interactive dashboards and reports that provide valuable insights into the world of cricket.

Overall, the IPL dataset on Kaggle is an excellent resource for anyone interested in cricket or data analysis. It contains a wealth of information that can be used to analyze and gain insights into the performance of players and teams in one of the most exciting cricket leagues in the world.

This dataset contains points table and player Information. To view more data such as Match stats, Ball_by_ball data & Player innings data, Please visit the below links:

Match stats, Ball_by_ball data: https://www.kaggle.com/datasets/biswajitbrahmma/ipl-complete-dataset-2008-2022

Player innings data: https://www.kaggle.com/datasets/paritosh712/cricket-every-single-ipl-inning-20082022

Thanks to Biswajit Brahmma & Paritosh Anand for their dataset.

Dataset Overview: Contains sales data from Blinkit, including product details, order quantities, revenue, and timestamps. Useful for demand forecasting, price optimization, trend analysis, and business insights. Helps in understanding customer behavior and seasonal variations in online grocery shopping. Potential Use Cases: - Time Series Analysis: Analyze sales trends over different periods. - Demand Forecasting: Predict future product demand based on historical data. - Price Optimization: Identify the impact of pricing on sales and revenue. - Customer Behavior Analysis: Understand buying patterns and preferences. - Market Trends: Explore how different factors affect grocery sales performance. This dataset can be beneficial for data scientists, business analysts, and researchers looking to explore e-commerce and retail trends. Feel free to use it for analysis, machine learning models, and business intelligence projects. https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F16299142%2Fa633fb36dc370263696b5d2ec940c74f%2FScreenshot%202025-06-16%20082824.png?generation=1750086765806732&alt=media" alt=""> https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F16299142%2F8843129c88c2f57d66006a3ac9d37dc7%2FScreenshot%202025-06-16%20084001.png?generation=1750086777975125&alt=media" alt=""> https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F16299142%2Ffa4f29a8f4cc763a1cc66c7913c077e8%2FScreenshot%202025-06-16%20084007.png?generation=1750086787100561&alt=media" alt="">

𝗢𝗻𝗹𝗶𝗻𝗲 𝗦𝘂𝗽𝗲𝗿 𝗦𝘁𝗼𝗿𝗲 𝗦𝗮𝗹𝗲𝘀 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 📊

Hello Kaggle Community!👋 Check out my new Unguided Power BI End-to-End Practice Project. The objective is to conduct a complete analysis of historical online sales data to identify trends, patterns, and anomalies impacting revenue growth. Quantify the impact of key performance indicators (KPIs) on overall sales performance and provide data-driven recommendations. Deliver a detailed report outlining findings, insights, and strategic recommendations to stimulate revenue growth and enhance business performance. 📈📊

I decided to try something new this time by recording myself and giving an overview of the entire project as if I were presenting to senior stakeholders. I thought it would help me improve my storytelling skills, according to the current industry. There's definitely a lot of room for improvement and your invaluable feedback will be instrumental in identifying those areas.

DataAnalytics #DataAnalysis #DataAnalyst #OnlineStoreSales #PowerBI #DataStoryTelling #BusinessIntelligence #DataVisualization #DataDrivenInsights

An interactive dashboard to visualize sales performance, product categories, regional performance, and key business KPIs.

📌 Description This project analyzes online sales data using Power BI, focusing on performance metrics such as Total Sales Amount, Profit, Quantity Sold, and Payment Modes. The dashboard provides detailed visualizations to identify top-performing categories, sub-categories, and locations. It aims to deliver actionable insights for business strategy, marketing decisions, and operational improvements.

The dataset is split across two CSV files:

• Orders.csv – contains customer and order metadata (date, name, location)

• Details.csv – contains order-level details (profit, quantity, payment mode, category)

🧩 Key Features - KPI Cards: Total Amount, Total Profit, Total Quantity, Profit Margin

• Pie Charts: Sales by Category, Sales by Payment Mode

• Donut Chart: Sales by State

• Bar Chart: Sales by Sub-Category

• Map: Quantity sold across Indian States

• Interactive Slicers and Filters

⚒️ Tools & Techniques Power BI Desktop

DAX Calculations

Custom Visual Design for Clean UI/UX

This dataset is part of my portfolio project and is shared here to encourage exploration and further analysis. Feel free to use it as-is, build upon it, or integrate it into your own projects. Whether you're practicing data analysis, testing models, or just need a clean dataset to work with—this resource is available for you.

In this project, I conducted a comprehensive analysis of customer data using Power BI. The objective was to visualize and gain insights from the data, focusing on customer demographics and product categories.

📈The analysis includes the following key visualizations:

Customer Distribution by Age: illustrates the number of customers across different age groups, providing insights into the demographic distribution.

Customer Distribution by Time: This visualization shows the count of customers segmented by year, quarter, month, and day, helping identify trends over time.

Customer Distribution by Gender: displays the distribution of customers by gender, highlighting any significant differences.

Total Amount by Product Category: depicts the total revenue generated by each product category, allowing for easy comparison.

Quantity by Product Category: shows the total quantity of products sold in each category, helping to identify popular items.

The cards display key metrics:

Average Age: 41.39 Total Customers: 1000 Total Quantity Sold: 2514 Total Amount Sold: 465 000$ Total Transactions: 1000 Additionally, I implemented filters for product category, date, gender, quantity, and age, providing users with the ability to refine their analysis.

Findings:

The analysis of customer distribution by age reveals no specific relationship between age and the quantity of products sold. This indicates that purchasing behavior may not be strongly influenced by the customer’s age. There are notable peaks in the quantity sold on May 20, 2023, and again in July, suggesting higher purchasing activity during these periods. The customer distribution by gender shows that 49% of customers are female, while 51% are male. In terms of total amount sold by product category, electronics is the top category, generating the highest revenue, followed by clothing, with beauty ranking last. Similarly, when looking at quantity sold by product category, electronics makes up 33.77%, clothing is slightly higher at 35.56%, and beauty is the smallest category at 3.67%. This project demonstrates the power of Power BI in analyzing customer data and deriving actionable insights. The visualizations created provide a clear understanding of customer behavior and preferences, which can help businesses make informed decisions.

Global Revenue & Customer Insights with Power BI

Just wrapped up an interactive Power BI Dashboard analyzing 2011 retail data! This project highlights key trends in global revenue, demand, and customer behavior.

🔎 Key Insights: ✅ Monthly Revenue Trends 📉 ✅ Country-Wise Demand 🌍 ✅ Customer Revenue Segmentation 🛒 ✅ Seasonal Analysis with Filters 🌸❄

💡 Skills Applied: 🔹 Power BI for Data Visualization 🔹 DAX for Advanced Calculations 🔹 Data Transformation with Power Query 🔹 Data Storytelling for Business Insights

🚀 Business Impact: ✔ Identify growth opportunities ✔ Understand customer preferences ✔ Optimize sales strategies

Analyzing sales data is essential for any business looking to make informed decisions and optimize its operations. In this project, we will utilize Microsoft Excel and Power Query to conduct a comprehensive analysis of Superstore sales data. Our primary objectives will be to establish meaningful connections between various data sheets, ensure data quality, and calculate critical metrics such as the Cost of Goods Sold (COGS) and discount values. Below are the key steps and elements of this analysis:

1- Data Import and Transformation:

• Gather and import relevant sales data from various sources into Excel.
• Utilize Power Query to clean, transform, and structure the data for analysis.
• Merge and link different data sheets to create a cohesive dataset, ensuring that all data fields are connected logically.

2- Data Quality Assessment:

• Perform data quality checks to identify and address issues like missing values, duplicates, outliers, and data inconsistencies.
• Standardize data formats and ensure that all data is in a consistent, usable state.

3- Calculating COGS:

• Determine the Cost of Goods Sold (COGS) for each product sold by considering factors like purchase price, shipping costs, and any additional expenses.
• Apply appropriate formulas and calculations to determine COGS accurately.

4- Discount Analysis:

• Analyze the discount values offered on products to understand their impact on sales and profitability.
• Calculate the average discount percentage, identify trends, and visualize the data using charts or graphs.

5- Sales Metrics:

• Calculate and analyze various sales metrics, such as total revenue, profit margins, and sales growth.
• Utilize Excel functions to compute these metrics and create visuals for better insights.

6- Visualization:

• Create visualizations, such as charts, graphs, and pivot tables, to present the data in an understandable and actionable format.
• Visual representations can help identify trends, outliers, and patterns in the data.

7- Report Generation:

• Compile the findings and insights into a well-structured report or dashboard, making it easy for stakeholders to understand and make informed decisions.

Throughout this analysis, the goal is to provide a clear and comprehensive understanding of the Superstore's sales performance. By using Excel and Power Query, we can efficiently manage and analyze the data, ensuring that the insights gained contribute to the store's growth and success.

In the beginning, the case was just data for a company that did not indicate any useful information that would help decision-makers. In this case, I had to ask questions that could help extract and explore information that would help decision-makers improve and evaluate performance. But before that, I did some operations in the data to help me to analyze it accurately: 1- Understand the data. 2- Clean the data “By power query”. 3- insert some calculation and columns like “COGS” cost of goods sold by power query. 4- Modeling the data and adding some measures and other columns to help me in analysis. Then I asked these questions: To Enhance Customer Loyalty What is the most used ship mode by our customer? Who are our top 5 customers in terms of sales and order frequency? To monitor our strength and weak points Which segment of clients generates the most sales? Which city has the most sales value? Which state generates the most sales value? Performance measurement What are the top performing product categories in terms of sales and profit? What is the most profitable product that we sell? What is the lowest profitable product that we sell? Customer Experience On Average how long does it take the orders to reach our clients? Based on each Shipping Mode

Then started extracting her summaries and answers from the pivot tables and designing the data graphics in a dashboard for easy communication and reading of the information as well. And after completing these operations, I made some calculations related to the KPI to calculate the extent to which sales officials achieved and the extent to which they achieved the target.

This project involves analyzing a dataset of 2,240 customers from Maven Marketing to improve marketing strategies. By segmenting customers based on demographics and behavior, evaluating the success of past campaigns, and assessing channel performance, the goal is to uncover actionable insights that can drive future marketing efforts. The analysis will focus on identifying customer preferences, optimizing campaign strategies, and maximizing ROI. Using tools like Excel and Power BI, the project aims to create data-driven solutions for better customer engagement and business growth.

This dataset represents simulated sales data for an electronics shop operating in the United States from 2024 (January to November). It is designed for individuals who want to practice data analysis, visualization, and machine learning techniques. The dataset reflects real-world sales scenarios, including various products, customer information, order statuses, and sales channels. It is ideal for learning and experimenting with data analytics, business insights, and visualization tools like Power BI, Tableau, or Python libraries.

Dataset Features ProductID: Unique identifier for each product. ProductName: Name of the electronic product (e.g., Phone, Laptop, Drone). ProductPrice: The price of the product is in USD. OrderedQuantity: Number of units ordered by the customer. OrderStatus: Status of the order (e.g., Delivered, In Process, On Hold, Canceled). CustomerName: Name of the customer who placed the order. State: State of the customer in the United States (e.g., California, Texas). City: City of the customer within the state. Latitude & Longitude: Geographic coordinates of the customer's location for mapping purposes. OrderChannel: Channel through which the order was placed (e.g., Website, Phone, Physical Store, Social Media). OrderDate: Date of the order (range: January 1, 2024, to November 30, 2024).

Potential Use Cases

Exploratory Data Analysis (EDA): Analyze sales trends across months, states, or product categories. Identify the most popular sales channels or products. Examine the distribution of order statuses.

Data Visualization: Create dashboards to visualize sales performance, customer demographics, and geographic distribution. Plot order locations on a map using latitude and longitude.

Machine Learning: Predict future sales trends using historical data. Classify order statuses based on product and order details. Cluster customers based on purchase behavior or location.

Business Insights: Analyze revenue contributions from different states or cities. Understand customer preferences across product categories.

Technical Details File Format: Excel (with a .xlsx extension) Number of Rows: 11000 Period: January 1, 2024, to November 30, 2024 Simulated Data: The data is entirely synthetic and does not represent real customers or transactions.

Why Use This Dataset? This dataset is tailored for individuals and students interested in: Building their data analysis and visualization skills. Learning how to work with real-world-like business datasets. Practicing machine learning with structured data. Acknowledgment This dataset was generated to mimic real-world sales data scenarios for educational and research purposes. Feel free to use it for learning and projects, and share your insights with the community!

This dataset contains 10,000 synthetic records simulating the migratory behavior of various bird species across global regions. Each entry represents a single bird tagged with a tracking device and includes detailed information such as flight distance, speed, altitude, weather conditions, tagging information, and migration outcomes.

The data was entirely synthetically generated using randomized yet realistic values based on known ranges from ornithological studies. It is ideal for practicing data analysis and visualization techniques without privacy concerns or real-world data access restrictions. Because it’s artificial, the dataset can be freely used in education, portfolio projects, demo dashboards, machine learning pipelines, or business intelligence training.

With over 40 columns, this dataset supports a wide array of analysis types. Analysts can explore questions like “Do certain species migrate in larger flocks?”, “How does weather impact nesting success?”, or “What conditions lead to migration interruptions?”. Users can also perform geospatial mapping of start and end locations, cluster birds by behavior, or build time series models based on migration months and environmental factors.

For data visualization, tools like Power BI, Python (Matplotlib/Seaborn/Plotly), or Excel can be used to create insightful dashboards and interactive charts.

Join the Fabric Community DataViz Contest | May 2025: https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/%EF%B8%8F-Fabric-Community-DataViz-Contest-May-2025/ba-p/4668560

🌿 Green Tea Sales Analysis Dashboard I’m excited to share my latest Power BI project — a dynamic and interactive dashboard designed to analyze Green Tea sales data. This comprehensive solution offers actionable insights into key metrics such as revenue, product performance, customer behavior, and geographical distribution. With this dashboard, stakeholders can easily monitor sales trends, compare year-over-year performance, and make data-driven decisions.

🖥️ Key Dashboard Features Net Revenue & Total Bills Generated: Provides a clear view of overall financial performance.

Salesman Experience Analysis: Visualizes the average experience of sales representatives and its impact on sales.

Geographical Sales Distribution: An interactive map highlights sales performance across different regions.

Customer Type Breakdown: A detailed pie chart categorizes customers into Retail, Institutional, and Online segments.

Product Performance: A combination of treemap and bar chart visualizations showcase top-selling and underperforming products.

Revenue Trend & Discount Analysis: Year-over-year revenue and discount trends are analyzed to identify patterns and anomalies.

Date & Quarter Filters: Users can filter data using interactive controls for year, month, or quarter-based analysis.

📊 Dataset Overview The dataset used for this analysis contains essential information, including:

Sales Date

Total Sales Revenue

Product Category

Sales Volume (Tons)

Customer Type

Region & Country

Salesman Experience (Years)

🛠️ Tools Used Power BI – For data visualization and dashboard development

DAX (Data Analysis Expressions) – For complex calculations and dynamic data representation

Data Science Dashboard

** Exciting Data Science Dashboard Project Overview **

I'm thrilled to share my latest Power BI dashboard project focusing on the salaries and employment trends of Data Science professionals from 2020 to 2022. Dive into the details of this insightful dashboard that sheds light on various aspects of employee demographics, compensation, and work trends.

** Detailed Visualizations: **

Total Employee Count: Track the growth of the Data Science team over the three-year period. Average Salary Analysis: Explore the average salaries for each year (2020, 2021, and 2022) to identify trends and fluctuations. Company Size Distribution: Visualize the distribution of employees across small, medium, and largesized companies where Data Science professionals worked. Salary Distribution by Job Titles: Gain insights into salary distribution across different job titles through a clustered bar chart. Experience Level and Employment Type: Analyze the distribution of employees based on experience levels and employment types through an informative table. Remote Work Ratio: Understand the proportion of remote work over time through a stacked area chart, correlated with salary levels in USD. Interactive Slicers: Use drop-down slicers for job titles and work years to customize your data exploration experience. **Key Takeaways and Insights: **

Identify hiring trends and patterns in the Data Science field over the three-year period. Understand salary distributions based on job titles and experience levels. Gain insights into the prevalence of remote work and its correlation with salary levels. Explore the impact of company size on employment opportunities and compensation. ** Unlocking Insights for Decision-Making: **

This Power BI dashboard provides valuable insights for HR professionals, hiring managers, and Data Science enthusiasts alike. Use the interactive features to drill down into specific segments and extract actionable insights for strategic decision-making. Leverage the visualizations to inform recruitment strategies, salary negotiations, and workforce planning initiatives. **Ready to Explore the Future of Data Science Employment? **

Dive into this comprehensive dashboard to uncover trends, patterns, and insights that drive the Data Science industry forward. Let's connect to discuss how these insights can inform your business strategies and propel your organization towards success.

A high-quality, clean dataset simulating global cosmetics and skincare product sales between January and August 2022. This dataset mirrors real-world transactional data, making it perfect for data analysis, Excel training, visualization projects, and machine learning prototypes.

📁 Dataset Overview

🧾 Sample Products

• Hydrating Face Serum
• Vitamin C Cream
• Aloe Vera Gel
• Charcoal Face Wash
• SPF 50 Sunscreen
• Niacinamide Toner
• Anti-Aging Serum
• Face Sheet Masks
• Hair Repair Oil
• Lip Balm Pack
• Body Butter Cream
• Salicylic Acid Cleanser

🌏 Countries Covered

• India
• USA
• UK
• Canada
• Australia
• New Zealand

📊 Quick Stats

• Total Rows: 374
• Date Range: Jan 1, 2022 – Aug 31, 2022
• Revenue Range: Varies from ~$100 to ~$20,000 per order
• Box Quantity Range: 10 – 500 boxes

🎯 Ideal For

• Excel Practice (VLOOKUP, IF, AVERAGEIFS, INDEX-MATCH, etc.)
• Pivot tables & data cleaning tasks
• Power BI / Tableau dashboards
• Sales trend forecasting
• Exploratory Data Analysis (EDA)
• Retail analytics & product demand modeling

📌 Suggested Projects & Questions

• Which salesperson generated the highest revenue overall?
• What’s the average amount per order in each country?
• Which product was most frequently sold?
• What month had the highest total boxes shipped?
• Create a dashboard comparing revenue across countries.

✅ Clean Data Guarantee

• ✅ No missing/null values
• ✅ No duplicates
• ✅ Realistic values
• ✅ Globally relatable product categories
• ✅ Ready for ML, BI, and teaching use cases