Facebook
TwitterAttribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This project focuses on data mapping, integration, and analysis to support the development and enhancement of six UNCDF operational applications: OrgTraveler, Comms Central, Internal Support Hub, Partnership 360, SmartHR, and TimeTrack. These apps streamline workflows for travel claims, internal support, partnership management, and time tracking within UNCDF.Key Features and Tools:Data Mapping for Salesforce CRM Migration: Structured and mapped data flows to ensure compatibility and seamless migration to Salesforce CRM.Python for Data Cleaning and Transformation: Utilized pandas, numpy, and APIs to clean, preprocess, and transform raw datasets into standardized formats.Power BI Dashboards: Designed interactive dashboards to visualize workflows and monitor performance metrics for decision-making.Collaboration Across Platforms: Integrated Google Collab for code collaboration and Microsoft Excel for data validation and analysis.
Facebook
Twitterhttps://creativecommons.org/publicdomain/zero/1.0/https://creativecommons.org/publicdomain/zero/1.0/
This data set is perfect for practicing your analytical skills for Power BI, Tableau, Excel, or transform it into a CSV to practice SQL.
This use case mimics transactions for a fictional eCommerce website named EverMart Online. The 3 tables in this data set are all logically connected together with IDs.
My Power BI Use Case Explanation - Using Microsoft Power BI, I made dynamic data visualizations for revenue reporting and customer behavior reporting.
Revenue Reporting Visuals - Data Card Visual that dynamically shows Total Products Listed, Total Unique Customers, Total Transactions, and Total Revenue by Total Sales, Product Sales, or Categorical Sales. - Line Graph Visual that shows Total Revenue by Month of the entire year. This graph also changes to calculate Total Revenue by Month for the Total Sales by Product and Total Sales by Category if selected. - Bar Graph Visual showcasing Total Sales by Product. - Donut Chart Visual showcasing Total Sales by Category of Product.
Customer Behavior Reporting Visuals - Data Card Visual that dynamically shows Total Products Listed, Total Unique Customers, Total Transactions, and Total Revenue by Total or by continent selected on the map. - Interactive Map Visual showing key statistics for the continent selected. - The key statistics are presented on the tool tip when you select a continent, and the following statistics show for that continent: - Continent Name - Customer Total - Percentage of Products Sold - Percentage of Total Customers - Percentage of Total Transactions - Percentage of Total Revenue
Facebook
TwitterAttribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This dataset contains 100 days of historical stock market data for three major technology companies: Apple (AAPL), Microsoft (MSFT), and Google (GOOGL). It was created as part of a Power BI dashboard project focused on financial analytics and data visualization.
The dataset includes the following fields:
Date – Trading date Open – Opening stock price Close – Closing stock price Volume – Number of shares traded Daily Return (%) – Calculated as the percentage change in closing price from the previous day 7-day Moving Average – Short-term trend indicator 30-day Moving Average – Long-term trend indicator This dataset is ideal for:
Building interactive dashboards in Power BI or Tableau Practicing time series analysis and financial KPIs Comparing stock performance across multiple companies Learning how to clean, transform, and visualize financial data The data has been pre-processed and enriched with calculated metrics to support business insights and decision-making. It is suitable for students, analysts, and data science enthusiasts interested in stock market analytics.
Facebook
TwitterAttribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Change-To-Liabilities Time Series for Microsoft Corporation. Microsoft Corporation develops and supports software, services, devices, and solutions worldwide. The company's Productivity and Business Processes segment offers Microsoft 365 Commercial, Enterprise Mobility + Security, Windows Commercial, Power BI, Exchange, SharePoint, Microsoft Teams, Security and Compliance, and Copilot; Microsoft 365 Commercial products, such as Windows Commercial on-premises and Office licensed services; Microsoft 365 Consumer products and cloud services, such as Microsoft 365 Consumer subscriptions, Office licensed on-premises, and other consumer services; LinkedIn; Dynamics products and cloud services, such as Dynamics 365, cloud-based applications, and on-premises ERP and CRM applications. Its Intelligent Cloud segment provides Server products and cloud services, such as Azure and other cloud services, GitHub, Nuance Healthcare, virtual desktop offerings, and other cloud services; Server products, including SQL and Windows Server, Visual Studio and System Center related Client Access Licenses, and other on-premises offerings; Enterprise and partner services, including Enterprise Support and Nuance professional Services, Industry Solutions, Microsoft Partner Network, and Learning Experience. The company's Personal Computing segment provides Windows and Devices, such as Windows OEM licensing and Devices and Surface and PC accessories; Gaming services and solutions, such as Xbox hardware, content, and services, first- and third-party content Xbox Game Pass, subscriptions, and Cloud Gaming, advertising, and other cloud services; search and news advertising services, such as Bing and Copilot, Microsoft News and Edge, and third-party affiliates. It sells its products through OEMs, distributors, and resellers; and online and retail stores. The company was founded in 1975 and is headquartered in Redmond, Washington.
Facebook
TwitterAnalyzing 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:
2- Data Quality Assessment:
3- Calculating COGS:
4- Discount Analysis:
5- Sales Metrics:
6- Visualization:
7- Report Generation:
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.
Facebook
Twitterhttps://www.archivemarketresearch.com/privacy-policyhttps://www.archivemarketresearch.com/privacy-policy
The Data Visualization Tools Market size was valued at USD 10.39 billion in 2023 and is projected to reach USD 22.12 billion by 2032, exhibiting a CAGR of 11.4 % during the forecasts period. This unprecedented growth is attributed to the increasing demand for real-time data analysis, the need for effective decision-making, and the rising adoption of cloud-based data visualization tools. Additionally, government initiatives aimed at improving data literacy and the implementation of data visualization solutions in various industry verticals are further fueling market growth. Data visualization tools enable businesses and individuals to transform complex data into insightful visual representations. Tools like Tableau, Power BI, and Google Data Studio offer user-friendly interfaces to create interactive charts, graphs, and dashboards. They help analyze trends, patterns, and correlations, aiding decision-making processes. Advanced features include real-time data updates, collaboration capabilities, and integration with various data sources like databases and cloud services.
Facebook
Twitterhttps://www.cognitivemarketresearch.com/privacy-policyhttps://www.cognitivemarketresearch.com/privacy-policy
According to Cognitive Market Research, the global Business Intelligence market size is USD 16.9 million in 2023 and will expand at a compound annual growth rate (CAGR) of 9.50% from 2023 to 2030.
The demand for Business Intelligence s is rising due to the increasing data complexity and rising focus on data-driven decision-making.
Demand for adults remains higher in the Business Intelligence market.
The Business intelligence platform category held the highest Business intelligence market revenue share in 2023.
North American Business Intelligence will continue to lead, whereas the Asia-Pacific Business Intelligence market will experience the most substantial growth until 2030.
Growing Emphasis on Data-Driven Decision-Making to Provide Viable Market Output
In the Business Intelligence Tools market, the increasing recognition of the strategic importance of data-driven decision-making serves as a primary driver. Organizations across various industries are realizing the transformative power of insights derived from BI tools. As the volume of data generated continues to soar, businesses seek sophisticated tools that can efficiently analyze and interpret this information. The ability of BI tools to convert raw data into actionable insights empowers decision-makers to formulate informed strategies, enhance operational efficiency, and gain a competitive edge in a data-centric business landscape.
In June 2020, SAS and Microsoft established a comprehensive technology and go-to-market strategic alliance. As part of the collaboration, SAS's industry solutions and analytical products will be moved to Microsoft Azure, SAS Cloud's preferred cloud provider.
Source-news.microsoft.com/2020/06/15/sas-and-microsoft-partner-to-further-shape-the-future-of-analytics-and-ai/#:~:text=and%20SAS%20today%20announced%20an,from%20their%20digital%20transformation%20initiatives.
Rise in Adoption of Advanced Analytics and Artificial Intelligence to Propel Market Growth
Another significant driver in the Business Intelligence Tools market is the escalating adoption of advanced analytics and artificial intelligence (AI) capabilities. Modern BI tools are incorporating AI-driven functionalities such as machine learning algorithms, natural language processing, and predictive analytics. These technologies enable users to uncover deeper insights, identify patterns, and predict future trends. The integration of AI not only enhances the analytical capabilities of BI tools but also automates processes, reducing manual efforts and improving the overall efficiency of data analysis. This trend aligns with the industry's pursuit of more intelligent and automated BI solutions to derive maximum value from data assets.
In March 2020, IBM created a new, dynamic global dashboard to display the global spread of COVID-19 with the assistance of IBM Cognos Analytics. The World Health Organization (WHO) and state and municipal governments provide the COVID-19 data displayed in this dashboard.
Source-www.ibm.com/blog/creating-trusted-covid-19-data-for-communities/
Market Dynamics of the Business Intelligence tool Market
Key Drivers for Business Intelligence tool Market
Increasing Demand for Data-Driven Decision Making Across Various Sectors: As companies produce vast amounts of data, there is an escalating requirement for tools that can analyze and convert raw data into actionable insights. Business Intelligence (BI) tools facilitate quicker and more precise strategic decisions in areas such as sales, finance, operations, and customer service.
Transition to Cloud-Based BI Solutions for Enhanced Scalability and Accessibility: Organizations are progressively shifting from on-premise BI systems to cloud-based solutions, which provide real-time access, foster collaboration, and reduce infrastructure expenses. This transition enhances scalability and accommodates hybrid or remote work settings.
Incorporation of AI and Machine Learning for Enhanced Predictive Analytics: Sophisticated BI tools are incorporating artificial intelligence and machine learning technologies to deliver predictive forecasting, anomaly detection, and natural language querying—thereby improving the accuracy of business forecasts and enhancing user accessibility.
Key Restraints for Business Intelligence tool Market
High Initial Setup and Customization Costs for SMEs: Small and medium-sized...
Facebook
TwitterGraded Power BI Mini Project - Sales Analysis Using Power BI | Data Science Course
🎓 Data Science & Business Analytics Program – IIT Guwahati (via Emeritus)
Design and develop an interactive dashboard using Power BI to analyze customer order data. This includes deriving insights related to:
Captures demographic & regional attributes:
- CustomerID, Name, Age, Gender, Region, CustomerSince, Email
Captures purchase activity:
- OrderID, CustomerID, ProductID, OrderDate, Quantity, TotalSales
Provides product and pricing metadata:
- ProductID, ProductName, Category, UnitPrice, Supplier
| Metric | Chart Type |
|---|---|
| Total Orders | Card |
| Total Sales | Card |
| Sales by Product Category | Donut / Pie Chart |
| Monthly Sales Trends | Line Chart |
| Customer Segmentation | Stacked Bar by Region |
Average Order Value Monthly Sales Growth (%) = (Current - Previous) / Previous Sales_Analysis_Dashboard.pbix| Tool | Usage |
|---|---|
| Power BI | Visualization, Modeling, DAX |
| DAX | Measure calculation & KPIs |
| Data Modeling | Star schema design |
| Storytelling | Structuring insights by audience |
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:
“Data becomes meaningful when it tells a story that leads to better decisions.”
Crafted with ♥ by Kanak Baghel | LinkedIn
Facebook
TwitterApache License, v2.0https://www.apache.org/licenses/LICENSE-2.0
License information was derived automatically
Data Import and Table Selection: Import Excel data into Power BI. Select specific tables (Calendar, Customer, Product, Sales, Terriority). Data Modeling: Design star schema architecture in Model view. Establish relationships between tables. Data Transformation: Filter Calendar table for years 2017 and 2018. Remove unnecessary columns from the Calendar table. Utilize Power Query Editor for data manipulation. DAX Measures: Create measures for analyzing sales data. Use DAX functions to calculate total sales, tax amount, total orders, distinct product count, etc. Add comments to DAX measures for clarity. Visualization: Create matrices to display summarized data. Format measures (e.g., change to currency). Utilize visual elements like icons and tooltips for better understanding. Drill-Down Analysis: Implement drill-down functionality to explore data hierarchically. Additional Measures: Calculate total customers and percentage of distinct customers. Analyze product-related metrics (e.g., max price, weight values). Data Quality Analysis: Identify and analyze empty cells in specific columns. Multiple Sheets and Visuals: Create multiple sheets with different matrix tables. Utilize slicers for interactive filtering. Implement visual filters for dynamic data exploration. Advanced DAX Functions: Utilize SUMX function for calculating total sales including tax. Calculate dealer margin using SUMX function. Conclusion: Summarize the project and its focus on measures, matrix tables, and advanced DAX functions. Overall, your project plan covers various aspects of data analysis and visualization in Power BI, from data import to advanced calculations and visualization techniques, providing a comprehensive guide for analysis and decision-making.
Facebook
TwitterThe contoso_TR.accdb dataset is a Microsoft Access relational database representing a localized version of the well-known Contoso retail business scenario, tailored for the Turkish market (TR). It provides a rich, realistic sample of sales, product, customer, and financial data that can be used for learning, reporting, and analytics purposes.
🧾 Dataset Description This dataset simulates the operations of Contoso Ltd., a fictitious retail company that sells electronic products and accessories through various sales channels across Turkey. The database is designed to support a wide range of data-driven tasks such as:
Data modeling and relationship design
SQL querying and data transformation
Business intelligence and reporting
Dashboard creation using Power BI or Excel
Training in Access VBA and macros
🌍 Localization Language: Turkish (column names and values are adapted)
Currency: Turkish Lira (₺)
Region: Turkey-specific location data (e.g., cities, regions, and stores)
Date format: gg.aa.yyyy (Turkish date format)
✅ Use Cases Practicing Access SQL queries
Creating forms and reports in Microsoft Access
Developing ETL pipelines using sample business data
Preparing Power BI dashboards with Turkish-language data
Learning how to normalize and relate data in a business context
📌 Notes The dataset is static and does not reflect real-time data.
No real customer information is included; all data is synthetic.
It is ideal for educational and demonstration purposes.
If you'd like, I can help you:
Design a Power BI report using this dataset
Convert it to SQL Server or another format
Write SQL queries to extract business insights
Facebook
TwitterApache License, v2.0https://www.apache.org/licenses/LICENSE-2.0
License information was derived automatically
The Electric Vehicle (EV) Sales Analysis & Forecasting project explores India’s EV adoption trends from 2014 to 2024, combining BigQuery for data analytics and Power BI for visualization. This end-to-end data project demonstrates expertise in SQL-based data analysis, time-series forecasting using BigQuery ML (ARIMA+), and interactive dashboard design. This repository presents an in-depth data analysis and visualization of Electric Vehicle (EV) sales trends across India using Microsoft Excel, SQL, Python and Power BI.
The Electric Vehicle Sales Dashboard is an interactive and visual analytics solution built using Power BI, focused on analyzing EV adoption trends across India. It includes KPIs, comparative charts, and advanced metrics to assist stakeholders in understanding EV sales performance from 2014 to 2024.
⚙️ Tech Stack
Google BigQuery → Data storage, cleaning, and analysis using SQL
BigQuery ML (ARIMA_PLUS) → Time series forecasting for future EV sales prediction
Power BI → Interactive dashboard for visualization and storytelling
Pyhton → For eda and visualization
Excel / CSV → Initial dataset preparation and transformation
🔹 Key Features: ✅ Total EV Sales Trends: Year-over-year and month-over-month change
✅ State-wise EV Performance: Compare EV adoption across Indian states
✅ Vehicle Category Breakdown: 2W, 3W, 4W, Buses, Others
✅ Dynamic Filtering: Use slicers to filter by Year, Month, State.
✅ KPI Cards: Total Sales, Average Sales
📊 Dashboard Overview Components:
Section Description 🔹 KPI Cards Highlight key performance indicators like Total Sales, Average Sales. 📈 Trend Charts Year-wise and month-wise sales volume (bar/line charts) 🗺️ Geo Analysis State-wise sales with ranking and contribution 🚗 Vehicle Type Pie Distribution of sales by 2W, 3W, 4W, Bus, Others 📅 Time Series Filtering and Interactive slicers for Year, Month, and State. 📊 YOY / MOM Change Dedicated visual section with % growth/dip over time
Dashboard using Power BI
https://github.com/user-attachments/assets/eca3b9c3-b446-4447-a38a-d61f5572a712" alt="DashBoards">
Dashboard using Excel
https://github.com/user-attachments/assets/f7cc0949-4581-4cb3-b3ab-ea9242bce803" alt="Dashboard excel">
🗓️ Year-on-Year EV Sales (2014–2024)
- EV sales have grown from 2.4K in 2014 to 1.5M in 2023.
- Peak growth observed in:
- 2021 → 2022: +209% YoY growth
- 2020 → 2021: +165% YoY growth
- 2024 saw a drop (as of current data): -90.61%
https://github.com/user-attachments/assets/02965465-d6cf-45bf-b127-40feb6fe9963" alt="yoy">
📆 Month-on-Month (MoM) Analysis
- Highest sales months: November, December, and January
- Noticeable drop in February followed by recovery in March
https://github.com/user-attachments/assets/83bce2dd-b2ae-43b9-bdb2-def5b9dbe37d" alt="mom">
📍 State-wise Performance
- Top Performing States:
- 🥇 Uttar Pradesh: ~730K units
- 🥈 Maharashtra: ~400K units
- 🥉 Karnataka: ~320K units
- Lower adoption in northeastern and union territory regions
- https://github.com/user-attachments/assets/1ee491b5-9016-4a1e-850f-34e8b9a9aab3" alt="state wise ev">
EV State wise Sale correlation
https://github.com/user-attachments/assets/4c5fc55d-389d-4bed-a9bb-eebe8ce31a11" alt="EV corr">
Top 5 State KDE Plot
https://github.com/user-attachments/assets/1b9e2f69-9ea0-4ac4-8c26-0350fb75bd75" alt="EV kde plot">
🚗 EV Sales by Vehicle Type
- 2-Wheelers: 50.3% of total sales
- 3-Wheelers: 45.1%
- 4-Wheelers and Buses: Small but growing segment
https://github.com/user-attachments/assets/2fc64426-4e3d-4a14-b058-f7c67040663b" alt="vtype wise ev">
📅 Year-wise EV Sales Trend EV adoption has grown significantly from 2,392 units in 2014 to over 1.5 million units in 2023
Fastest growth period: 2020–2022, with YoY gains of 165% and 209%
2024 shows a decline (-90.6%) due to possible data incompleteness
https://github.com/user-attachments/assets/d60567fb-fc61-463f-b0e8-34ddd14f1b8d" alt="Year wise ev">
------------------------------...
Facebook
Twitterhttps://creativecommons.org/publicdomain/zero/1.0/https://creativecommons.org/publicdomain/zero/1.0/
Dive into the ultimate treasure trove for football enthusiasts, data analysts, and gaming aficionados! The Football Manager Players Dataset is a comprehensive collection of player data extracted from a popular football management simulation game, offering an unparalleled look into the virtual world of football talent. This dataset includes detailed attributes for thousands of players across multiple leagues worldwide, making it a goldmine for analyzing player profiles, scouting virtual stars, and building predictive models for football strategies.
Whether you're a data scientist exploring sports analytics, a football fan curious about your favorite virtual players, or a game developer seeking inspiration, this dataset is your ticket to unlocking endless possibilities!
This dataset is a meticulously curated compilation of player statistics from five CSV files, merged into a single, unified dataset (merged_players.csv). It captures a diverse range of attributes for players from various clubs, nations, and leagues, including top-tier competitions like the English Premier Division, Argentina's Premier Division, and lower divisions across the globe.
merged_players.csv (UTF-8 encoded for compatibility with special characters).merged_players.csv and load it into your favorite tool (Python/pandas, R, Excel, etc.).Transfer Value, Position, and Media Description to start your analysis.
Facebook
TwitterAttribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This comprehensive dataset provides a wealth of information about all countries worldwide, covering a wide range of indicators and attributes. It encompasses demographic statistics, economic indicators, environmental factors, healthcare metrics, education statistics, and much more. With every country represented, this dataset offers a complete global perspective on various aspects of nations, enabling in-depth analyses and cross-country comparisons.
- Country: Name of the country.
- Density (P/Km2): Population density measured in persons per square kilometer.
- Abbreviation: Abbreviation or code representing the country.
- Agricultural Land (%): Percentage of land area used for agricultural purposes.
- Land Area (Km2): Total land area of the country in square kilometers.
- Armed Forces Size: Size of the armed forces in the country.
- Birth Rate: Number of births per 1,000 population per year.
- Calling Code: International calling code for the country.
- Capital/Major City: Name of the capital or major city.
- CO2 Emissions: Carbon dioxide emissions in tons.
- CPI: Consumer Price Index, a measure of inflation and purchasing power.
- CPI Change (%): Percentage change in the Consumer Price Index compared to the previous year.
- Currency_Code: Currency code used in the country.
- Fertility Rate: Average number of children born to a woman during her lifetime.
- Forested Area (%): Percentage of land area covered by forests.
- Gasoline_Price: Price of gasoline per liter in local currency.
- GDP: Gross Domestic Product, the total value of goods and services produced in the country.
- Gross Primary Education Enrollment (%): Gross enrollment ratio for primary education.
- Gross Tertiary Education Enrollment (%): Gross enrollment ratio for tertiary education.
- Infant Mortality: Number of deaths per 1,000 live births before reaching one year of age.
- Largest City: Name of the country's largest city.
- Life Expectancy: Average number of years a newborn is expected to live.
- Maternal Mortality Ratio: Number of maternal deaths per 100,000 live births.
- Minimum Wage: Minimum wage level in local currency.
- Official Language: Official language(s) spoken in the country.
- Out of Pocket Health Expenditure (%): Percentage of total health expenditure paid out-of-pocket by individuals.
- Physicians per Thousand: Number of physicians per thousand people.
- Population: Total population of the country.
- Population: Labor Force Participation (%): Percentage of the population that is part of the labor force.
- Tax Revenue (%): Tax revenue as a percentage of GDP.
- Total Tax Rate: Overall tax burden as a percentage of commercial profits.
- Unemployment Rate: Percentage of the labor force that is unemployed.
- Urban Population: Percentage of the population living in urban areas.
- Latitude: Latitude coordinate of the country's location.
- Longitude: Longitude coordinate of the country's location.
- Analyze population density and land area to study spatial distribution patterns.
- Investigate the relationship between agricultural land and food security.
- Examine carbon dioxide emissions and their impact on climate change.
- Explore correlations between economic indicators such as GDP and various socio-economic factors.
- Investigate educational enrollment rates and their implications for human capital development.
- Analyze healthcare metrics such as infant mortality and life expectancy to assess overall well-being.
- Study labor market dynamics through indicators such as labor force participation and unemployment rates.
- Investigate the role of taxation and its impact on economic development.
- Explore urbanization trends and their social and environmental consequences.
Data Source: This dataset was compiled from multiple data sources
If this was helpful, a vote is appreciated ❤️ Thank you 🙂
Not seeing a result you expected?
Learn how you can add new datasets to our index.
Facebook
TwitterAttribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This project focuses on data mapping, integration, and analysis to support the development and enhancement of six UNCDF operational applications: OrgTraveler, Comms Central, Internal Support Hub, Partnership 360, SmartHR, and TimeTrack. These apps streamline workflows for travel claims, internal support, partnership management, and time tracking within UNCDF.Key Features and Tools:Data Mapping for Salesforce CRM Migration: Structured and mapped data flows to ensure compatibility and seamless migration to Salesforce CRM.Python for Data Cleaning and Transformation: Utilized pandas, numpy, and APIs to clean, preprocess, and transform raw datasets into standardized formats.Power BI Dashboards: Designed interactive dashboards to visualize workflows and monitor performance metrics for decision-making.Collaboration Across Platforms: Integrated Google Collab for code collaboration and Microsoft Excel for data validation and analysis.