Sales_Analysis_Project

Graded Power BI Mini Project - Sales Analysis Using Power BI | Data Science Course

🎓 Data Science & Business Analytics Program – IIT Guwahati (via Emeritus)

Objective

Design and develop an interactive dashboard using Power BI to analyze customer order data. This includes deriving insights related to:

• ✅ Total order volume
• ✅ Sales trends by product category
• ✅ Regional customer segmentation
• ✅ Monthly growth patterns
• ✅ Key customer behavior metrics

Learning Outcomes

• Translate complex datasets into engaging, data-driven stories
• Build structured, audience-focused narratives to support strategic decisions
• Apply visualization and DAX techniques to highlight business KPIs

🗂️ Dataset Components

🧑 Customers Table

Captures demographic & regional attributes: - CustomerID, Name, Age, Gender, Region, CustomerSince, Email

🛒 Orders Table

Captures purchase activity: - OrderID, CustomerID, ProductID, OrderDate, Quantity, TotalSales

📦 Products Table

Provides product and pricing metadata: - ProductID, ProductName, Category, UnitPrice, Supplier

Power BI Implementation

🔗 Data Modeling

• Built relationships between Customers, Orders, and Products
• Created a star schema for efficient filtering and aggregation

Visualizations Created

DAX Measures

• Average Order Value
• Monthly Sales Growth (%) = (Current - Previous) / Previous

Design & Formatting Strategy

• Used theme-consistent color palettes and data labels
• Structured layout to support intuitive storytelling
• Added headers, custom tooltips, and cleaned slicers
• Saved as: Sales_Analysis_Dashboard.pbix

Skills & Tools Applied

Reflections

This project deepened my ability to merge technical BI skills with business storytelling. By transforming raw sales and customer data into visual narratives, I learned how to:

• Identify drivers of revenue by product and region
• Segment and profile customers by behavior and demographics
• Present actionable insights to stakeholders in a concise format

“Data becomes meaningful when it tells a story that leads to better decisions.”

Crafted with ♥ by Kanak Baghel | LinkedIn

Changing Table Market Outlook

According to our latest research, the global changing table market size reached USD 1.72 billion in 2024, reflecting a robust industry driven by the increasing focus on infant care and convenience. The market is forecasted to grow at a steady CAGR of 5.4% from 2025 to 2033, with the total market value expected to reach USD 2.75 billion by 2033. This growth trajectory is largely propelled by rising birth rates in developing regions, evolving parental preferences, and the expanding range of innovative changing table designs and materials. As per our recent analysis, the changing table market is witnessing significant transformation due to the fusion of safety, aesthetics, and functionality, making it a dynamic sector within the broader juvenile products industry.

One of the primary growth factors for the changing table market is the increasing awareness among parents about the importance of safe and hygienic diaper changing solutions. Modern parents are more informed and proactive about their child’s health, leading to a preference for products that offer enhanced safety features, ergonomic designs, and easy-to-clean surfaces. The proliferation of parenting blogs, social media influencers, and online communities has also played a crucial role in educating consumers about the benefits of investing in high-quality changing tables. Additionally, the growing trend of dual-income households has resulted in higher disposable incomes, enabling families to spend more on premium childcare products. The shift towards nuclear families and urban living further amplifies the need for compact, space-saving furniture solutions, driving demand for portable and wall-mounted changing tables.

Another significant driver is the ongoing innovation in materials and product designs. Manufacturers are increasingly leveraging eco-friendly, durable, and lightweight materials such as sustainably sourced wood, high-grade plastics, and metals to cater to diverse consumer preferences. This focus on material innovation not only enhances the aesthetic appeal of changing tables but also aligns with the global push for sustainability and environmental responsibility. Additionally, the integration of multifunctional features—such as built-in storage, convertible designs, and adjustable heights—caters to the evolving needs of modern parents seeking value-added solutions. These advancements have contributed to a broader product range and greater customization, thereby expanding the market’s reach across varied demographic segments.

The commercial sector, particularly daycare centers, hospitals, and hospitality venues, is emerging as a key growth area for the changing table market. With increasing regulatory emphasis on child safety and hygiene in public and commercial environments, there is a growing demand for robust, easy-to-maintain changing solutions. This trend is further bolstered by the expansion of organized childcare facilities and family-friendly public spaces, especially in urban areas. Commercial buyers are prioritizing products that comply with international safety standards and offer long-term durability, thereby creating new opportunities for manufacturers and suppliers. As a result, the commercial application segment is expected to witness above-average growth rates over the forecast period.

From a regional perspective, Asia Pacific is poised to emerge as the fastest-growing market for changing tables, driven by rising birth rates, urbanization, and increasing consumer awareness. North America and Europe continue to dominate in terms of market share, owing to their well-established retail infrastructure, high purchasing power, and stringent safety standards. However, the Middle East & Africa and Latin America also present promising opportunities, supported by improving economic conditions and expanding retail networks. Regional players are increasingly focusing on product localization and affordability to cater to diverse consumer needs, further intensifying competition and innovation in the market.

Pr

Water Table with Accessories Market Outlook

According to our latest research, the global Water Table with Accessories market size reached USD 1.13 billion in 2024, demonstrating robust growth driven by the increasing demand for interactive and educational toys among young children. The market is projected to expand at a CAGR of 6.8% from 2025 to 2033, reaching an estimated value of USD 2.17 billion by 2033. This growth trajectory is fueled by heightened parental focus on early childhood development and the integration of innovative features in water tables and their accessories.

One of the primary growth factors for the Water Table with Accessories market is the evolving emphasis on experiential learning and sensory play in early childhood education. Parents and educators are increasingly recognizing the cognitive and motor skill benefits that water tables provide, leading to a surge in their adoption globally. Water tables, equipped with a variety of accessories such as buckets, cups, water wheels, and animal figures, offer children hands-on opportunities to explore concepts like buoyancy, cause-and-effect, and imaginative play. The growing body of research supporting play-based learning further strengthens the market’s appeal, with educational institutions and preschools incorporating these products into their curricula. This trend is expected to continue as awareness of the developmental advantages associated with water play expands across both developed and emerging economies.

Another significant driver is the ongoing innovation in product design and material usage. Manufacturers are leveraging advancements in plastics technology and sustainable materials to create water tables that are not only durable and safe but also environmentally friendly. The introduction of themed water tables, modular accessories, and interactive elements such as water wheels and boats has enhanced the play value, catering to a broader age range and diverse consumer preferences. Furthermore, the rise of customization options and the integration of educational content—such as numeracy and literacy games—into water table accessories have broadened the market’s appeal. These innovations, coupled with strategic marketing campaigns, have contributed to increased product visibility and consumer engagement, thus propelling market growth.

The expanding reach of e-commerce platforms and the omnichannel retail strategy adopted by leading players are also pivotal to market expansion. Online stores have become a preferred distribution channel, particularly in the wake of the COVID-19 pandemic, offering consumers convenience, a wide product selection, and competitive pricing. This shift has enabled manufacturers to tap into previously underserved regions and demographic segments. Additionally, collaborations with educational organizations and the proliferation of specialty toy stores have further strengthened market penetration. As a result, the Water Table with Accessories market is witnessing a robust distribution network that caters to the evolving purchasing behavior of modern consumers.

From a regional perspective, North America continues to dominate the Water Table with Accessories market, accounting for the largest share in 2024 due to high disposable incomes, widespread awareness of educational toys, and a well-established retail infrastructure. However, the Asia Pacific region is anticipated to exhibit the fastest growth during the forecast period, driven by rising urbanization, increasing birth rates, and growing investments in early childhood education. Europe also remains a significant market, supported by strong consumer emphasis on quality and safety standards. Emerging markets in Latin America and the Middle East & Africa are gradually gaining traction, aided by improving economic conditions and expanding retail networks. This global landscape underscores the market’s potential for sustained growth across diverse geographies.

Product Type Analysis

The Product Type segment in the Water Table with Accessories market is characterized by a diverse range of offerings, including Plastic Water Tables, Wooden Water Tables, Inflatable Water Tables, and Others. Plastic water tables remain the most popular choice among consumers due to their lightweight nature, durability, and ease of maintenance. Their affordability and the ability to mold them into various shapes and vibrant colors make them particularly attractive to both parents and children. Ma

Fire Table Market Outlook

According to our latest research, the global fire table market size reached USD 1.35 billion in 2024, reflecting a robust consumer demand for both residential and commercial outdoor heating solutions. The market is expected to expand at a CAGR of 7.2% from 2025 to 2033, propelled by evolving consumer lifestyles and the increasing adoption of outdoor living spaces. By 2033, the global fire table market is forecasted to attain a valuation of USD 2.52 billion. This healthy growth trajectory is attributed to the rising trend of outdoor entertaining, urbanization, and the integration of fire tables in hospitality and commercial settings, as per our latest analysis.

The increasing popularity of outdoor living and entertaining continues to be a primary growth driver for the fire table market. Homeowners are increasingly investing in outdoor spaces, transforming patios, gardens, and rooftops into functional extensions of their living areas. Fire tables, with their dual functionality as both heat sources and aesthetic focal points, have become a preferred choice for enhancing ambiance and comfort. The surge in home improvement activities, particularly post-pandemic, has further fueled demand, as consumers seek to create inviting outdoor environments suitable for gatherings, relaxation, and socialization. Moreover, advancements in design and fuel efficiency, coupled with the availability of customizable options, have broadened the appeal of fire tables across diverse demographic segments.

Another significant growth factor is the expanding commercial application of fire tables. The hospitality sector, including hotels, restaurants, and resorts, is increasingly incorporating fire tables to elevate guest experiences and differentiate their outdoor offerings. Fire tables are now a staple in alfresco dining areas, rooftop lounges, and poolside settings, where they serve both functional and decorative purposes. The commercial segmentÂ’s growth is further supported by the global tourism industryÂ’s recovery and the growing emphasis on experiential dining and leisure. Additionally, fire tables are being adopted in public spaces such as parks and community centers, driven by municipal investments in urban beautification and outdoor amenities. This widespread adoption across commercial and public domains significantly boosts the overall market demand.

Technological innovations and environmental considerations are also shaping the fire table marketÂ’s evolution. Manufacturers are increasingly focusing on developing eco-friendly and energy-efficient products, such as propane and natural gas fire tables that emit fewer pollutants compared to traditional wood-burning models. The integration of smart controls, safety features, and weather-resistant materials further enhances product appeal and longevity. Moreover, the rise of e-commerce and digital marketing has improved product accessibility, enabling consumers to explore a wide variety of fire table designs, materials, and fuel types online. This digital shift not only expands the marketÂ’s reach but also empowers consumers with information and customization options, thereby driving higher engagement and sales.

In recent years, the demand for eco-friendly and sustainable outdoor furniture has surged, leading to the popularity of products like the Recycled Iron Fire Pit Table. These fire pit tables are crafted using recycled materials, which not only reduces environmental impact but also offers a unique rustic charm that appeals to eco-conscious consumers. The use of recycled iron ensures durability and a distinctive aesthetic, making them a favored choice for both residential and commercial outdoor settings. As consumers become more environmentally aware, the integration of recycled materials in fire tables is expected to gain momentum, aligning with broader sustainability trends in the market. This shift towards sustainable products is also supported by advancements in manufacturing processes that enhance the quality and longevity of recycled iron fire pit tables.

From a regional perspective, North America remains the largest market for fire tables, accounting for over 40% of the global revenue in 2024. The regionÂ’s dominance is underpinned by a strong culture of outdoor living, high disposable incomes, and a mature home impro

This Synthetic dataset simulates customer behavior data for an online retail company and is designed to be useful for Exploratory Data Analysis (EDA) and various machine learning tasks such as:

Customer segmentation

Churn prediction

Recommendation systems

Customer lifetime value estimation

🔍 Dataset Overview: Each row represents a unique customer, and the columns provide information on their demographics, shopping habits, engagement with the website, and satisfaction.

✅ Use Cases: Churn Prediction: Predict if a customer will churn based on behavior and demographics.

Segmentation: Use clustering to segment customers by behavior (e.g., income, spending, satisfaction).

Classification/Regression: Predict customer satisfaction or spending score.

Recommendation Engines: Based on purchase history and behavior patterns.

Sales of Convenience Confectionery products in the United States are estimated at USD 17.1 billion in 2025, with projections indicating a rise to USD 21.9 billion by 2035, reflecting a CAGR of approximately 2.5% over the forecast period. This growth reflects both a stabilizing consumer base and steady per capita consumption across diverse demographic segments.

IntroductionThe transition to clean heating systems in rental housing is crucial for achieving net-zero emissions goals, yet current policy frameworks lack systematic understanding of how renter preferences vary across different market contexts. While existing research acknowledges split incentive barriers between landlords and tenants, analysis of their manifestation across diverse demographic groups and market conditions remains notably absent.MethodsThis study employs latent class analysis of discrete choice experiment data from the American Council for an Energy-Efficient Economy to identify distinct renter segments and their responses to energy-efficient rental options. Our study combines demographic analysis with market valuation techniques to examine how renter segments distribute across three diverse metropolitan areas—San Diego, Houston, and Durham.ResultsThe analysis identifies six differentiated renter classes, characterized by systematic variation in demographic factors, housing preferences, and economic indicators. We find that while initial return multipliers exhibit significant sensitivity to assumptions about rent and energy cost differentials, the financial burden for energy-inefficient rentals is considerably larger than the premium one might pay for efficient rentals (presenting a penalty-to-premium of 1.35–1.42). The proportion of housing costs captured by landlords versus utilities varies significantly by market, increasing from 78.4% to 87.1% in San Diego, 74.9%–89.1% in Houston, and 88.5%–94.1% in Durham as properties move from poor to high efficiency, highlighting how regional characteristics shape the distribution of improvement costs between landlords and tenants.DiscussionThe study demonstrates how demographic composition systematically influences clean heating transition opportunities across rental markets, provides empirical evidence of geographic variation in renter segment distribution, and quantifies market-specific responses to efficiency improvements. These findings also underscore a market asymmetry that can impede extensive energy retrofits and enable policymakers to develop targeted approaches for accelerating clean heating adoption while maintaining affordability across diverse renter populations.

The datasets contain RGB photos of Scots pine seedlings of three populations from two different ecotypes originating in the Czech Republic:Plasy - lowland ecotype,Trebon - lowland ecotype,Decin - upland ecotype.These photos were taken in three different periods (September 10th 2021, October 23rd 2021, January 22nd 2022).File dataset_for_YOLOv7_training.zip contains image data with annotations for training YOLOv7 segmentation model (training and validation sets)The dataset also contains a table with information on individual Scots pine seedlings:affiliation to parent tree (mum)affiliation to population (site)row and column in which the seedling was grown (row, col)affiliation to the planter in which the seedling was grown (box)mean RGB values of pine seedling in three different periods (B_september, G_september, R_september B_october, G_october, R_october, B_january, G_january, R_january)mean HSV values of pine seedling in three different periods (H_september, S_september, V_september, H_october, S_october, V_october, H_january, S_january, V_january)

The global market for coin-operated pool tables and jukeboxes is poised for significant expansion, driven by a robust Compound Annual Growth Rate (CAGR) of XX% over the forecast period of 2025-2033. Valued at XXX million in 2025, this market is projected to reach an impressive figure by the end of the forecast period, fueled by escalating consumer demand for leisure and entertainment options. Key growth drivers include the resurgence of social gaming experiences, increased disposable incomes in emerging economies, and the ongoing appeal of classic entertainment formats in modern venues. The market is segmented by type, with Coin Operated Pool Tables and Jukeboxes forming distinct yet often complementary offerings. Applications span from professional competition settings where precision and quality are paramount, to widespread leisure and entertainment venues such as bars, pubs, arcades, and entertainment centers, all seeking to enhance customer engagement and revenue streams. Further propelling this market's growth are evolving consumer preferences and technological integration. While traditional coin-operated models remain popular, there's a growing trend towards integrating smart features, digital payment options, and interactive game modes, particularly within the jukebox segment. This evolution caters to a younger demographic while retaining the nostalgic charm that attracts established patrons. Restraints, such as initial capital investment and the need for consistent maintenance, are being mitigated by innovative leasing models and advancements in durable, low-maintenance technology. Leading companies like Valley Dynamo and SoundLeisure are at the forefront, introducing innovative products and expanding their global reach. The Asia Pacific region, with its burgeoning middle class and increasing urbanization, is emerging as a significant growth hotspot, complementing the mature markets of North America and Europe.

Camping Chairs and Tables Market Outlook

The global market size for camping chairs and tables stood at approximately USD 2.5 billion in 2023 and is projected to reach USD 4.3 billion by 2032, growing at a compound annual growth rate (CAGR) of 5.9% during the forecast period. This substantial growth can be attributed to several factors, including the increasing popularity of outdoor recreational activities, a rise in disposable incomes, and a growing trend towards experiential travel and leisure activities.

One of the primary growth drivers of the camping chairs and tables market is the surge in outdoor recreational activities. With a growing awareness of the benefits of spending time outdoors, many people are increasingly participating in activities such as camping, hiking, and picnicking. Governments and private organizations are also promoting outdoor tourism, further boosting the demand for portable and convenient camping furniture. This trend is particularly noticeable in regions with easy access to natural landscapes, which act as prime locations for camping and related activities.

Another significant factor contributing to market growth is the increase in disposable incomes across various demographics. As people have more spending power, they are more willing to invest in leisure and recreational products, including camping furniture. The rise of the middle class in emerging economies also plays a crucial role in this aspect, as this segment of the population is more inclined towards spending on leisure activities, thus driving the demand for camping chairs and tables.

The ongoing trend towards experiential travel is also propelling the camping chairs and tables market. Consumers are increasingly looking for unique and immersive experiences rather than material possessions. This shift in consumer preferences has led to a rise in the number of people opting for camping and other outdoor activities as a form of vacation. Consequently, the demand for high-quality, durable, and portable camping furniture is on the rise, as campers seek to enhance their outdoor experience with convenient and comfortable solutions.

From a regional perspective, North America holds a significant share of the camping chairs and tables market, driven by a strong culture of outdoor activities and a well-established infrastructure for camping. Europe also represents a substantial market due to its numerous camping sites and a high level of awareness about outdoor recreation. The Asia Pacific region is expected to witness the highest growth rate during the forecast period, attributed to the rising popularity of camping among the younger population and increasing disposable incomes in countries like China and India. Latin America and the Middle East & Africa also present growth opportunities, albeit at a slower pace compared to other regions.

Product Type Analysis

Within the camping chairs and tables market, the product type segment includes camping chairs, camping tables, and combo sets. Camping chairs are the most widely used product due to their convenience, affordability, and variety of designs available. They are lightweight, portable, and can be easily folded, making them an essential item for campers. The demand for camping chairs is expected to remain robust, driven by the increasing number of people participating in camping and other outdoor activities.

Camping tables, while not as popular as chairs, are steadily gaining traction. These tables provide a convenient surface for dining, playing games, or preparing food, enhancing the overall camping experience. The growing emphasis on comfort and convenience during camping trips is likely to drive the demand for camping tables. Manufacturers are also innovating in terms of materials and designs, offering more compact and lightweight options that are easy to transport and set up.

Combo sets, which include both chairs and tables, are becoming increasingly popular among consumers looking for a complete outdoor furniture solution. These sets offer the advantage of convenience and coordinated design, making them an attractive option for campers who value aesthetics as well as functionality. The demand for combo sets is expected to grow, particularly among families and groups who require multiple seating and dining options for their camping trips.

Overall, the product type segment is characterized by a wide variety of options, catering to different preferences and needs. Manufacturers are focusing on innovation and quality to meet the evolving demands

Billiards Market Size And Forecast

Billiards Market size was valued at USD 475.8 Million in 2023 and is projected to reach USD 800 Million by 2031, growing at a CAGR of 5.13% during the forecast period 2024-2031.

Global Billiards Market Drivers

The market drivers for the Billiards Market can be influenced by various factors. These may include:

Economic Growth: The Billiards Market is significantly influenced by economic growth, as rising disposable incomes allow consumers to spend more on leisure activities. As economies improve, more individuals seek entertainment options that include billiards, leading to increased demand for pool tables, cues, and accessories. Additionally, the growth of recreational facilities and bars has simultaneously contributed to the market as establishments look to attract customers through diverse gaming options. This trend is evident in urban areas, where the establishment of billiards clubs becomes more feasible, further driving market expansion through consumer engagement and increased participation in billiards-related activities. Social Trends: Social trends play a pivotal role in the Billiards Market. As recreational experiences increasingly become a focal point for social interaction, billiards serves as a popular choice for gatherings, events, and competitive play. The rise of bar-based gaming and the increasing popularity of billiards among younger generations indicate a shifting social landscape where billiards is a recreational staple. Events such as leagues and tournaments also elevate the sport's visibility, fostering community and engagement. The influence of social media in promoting equipment and locations enhances its appeal, helping to cultivate a vibrant billiards culture that fuels market growth. Technological Advancements: Technological advancements are crucial in the Billiards Market, enhancing both player experience and product offerings. Innovations in materials for cues and tables have improved performance, longevity, and aesthetics, attracting both casual players and professionals. Additionally, advancements in digital gaming and augmented reality applications provide new avenues for engagement, creating immersive billiards experiences. These technologies facilitate remote competition and online participation, broadening the audience and encouraging new participants. Moreover, the rise of e-commerce platforms has made it easier for consumers to access high-quality billiards products and accessories, bolstering market growth and consumer choice. Demographic Shifts: Demographic shifts significantly influence the Billiards Market, as changing population dynamics reveal varying interests in recreational activities. Younger millennials and Gen Z consumers are increasingly drawn to billiards, exploring interactive and competitive environments. Additionally, demographic diversity contributes to a broader appeal, with women and various age groups seeking inclusivity in billiards spaces. This demographic expansion fosters unique marketing strategies aimed at different segments, thus enhancing engagement and participation. Furthermore, family-oriented recreational spaces often incorporate billiards, appealing to a broader audience and fostering intergenerational play, resulting in steady growth and interest within the Billiards Market landscape. Growing Popularity Of E-sports: The surge in e-sports popularity intersects with the Billiards Market, creating new opportunities for engagement and consumer interest. This growth encourages billiards events and tournaments to embrace e-sports strategies, bridging traditional leisure activities with modern gaming culture. By hosting innovative competitions and streaming events online, billiards can attract younger audiences familiar with digital platforms. This integration enhances visibility and appeal, leading to potential sponsorships and partnerships with gaming brands. As community engagement grows through both traditional gameplay and e-sport-like competitions, the Billiards Market stands to benefit significantly, capturing a wider range of participants.