This interactive sales dashboard is designed in Excel for B2C type of Businesses like Dmart, Walmart, Amazon, Shops & Supermarkets, etc. using Slicers, Pivot Tables & Pivot Chart.

Dashboard Overview

1. Sales dashboard ==> basically, it is designed for the B2C type of business. like Dmart, Walmart, Amazon, Shops & supermarkets, etc.
2. Slices ==> slices are used to drill down the data, on the basis of yearly, monthly, by sales type, and by mode of payment.
3. Total Sales/Total Profits ==> here is, the total sales, total profit, and profit percentage these all are combined into a monthly format and we can hide or unhide it to view it as individually or comparative.
4. Product Visual ==> the visual indicates product-wise sales for the selected period. Only 10 products are visualized at a glance, and you can scroll up & down to view other products in the list.
5. Daily Sales ==> It shows day-wise sales. (Area Chart)
6. Sales Type/Payment Mode ==> It shows sales percentage contribution based on the type of selling and mode of payment.
7. Top Product & Category ==> this is for the top-selling product and product category.
8. Category ==> the final one is the category-wise sales contribution.

Datasheets Overview

1. The dataset has the master data sheet or you can call it a catalog. It is added in the table form.
2. The first column is the product ID the list of items in this column is unique.
3. Then we have the product column instead of these two columns, we can manage with only one also but I kept it separate because sometimes product names can be the same, but some parameters will be different, like price, supplier, etc.
4. The next column is the category column, which is the product category. like cosmetics, foods, drinks, electronics, etc.
5. Then we have 4th column which is the unit of measure (UOM) you can update it also, based on the products you have.
6. And the last two columns are buying price and selling price, which means unit purchasing price and unit selling price.

Input Sheet

The first column is the date of Selling. The second column is the product ID. The third column is quantity. The fourth column is sales types, like direct selling, are purchased by a wholesaler or ordered online. The fifth column is a mode of payment, which is online or in cash. You can update these two as per requirements. The last one is a discount percentage. if you want to offer any discount, you can add it here.

Analysis Sheet: where all backend calculations are performed.

So, basically these are the four sheets mentioned above with different tasks.

However, a sales dashboard enables organizations to visualize their real-time sales data and boost productivity.

A dashboard is a very useful tool that brings together all the data in the forms of charts, graphs, statistics and many more visualizations which lead to data-driven and decision making.

Questions & Answers

1. What percentage of profit ratio of sales are displayed in the year 2021 and year 2022? ==> Total profit ratio of sales in the year 2021 is 19% with large sales of PRODUCT42, whereas profit ratio of sales for 2022 is 22% with large sales of PRODUCT30.
2. Which is the top product that have large number of sales in year 2021-2022? ==> The top product in the year 2021 is PRODUCT42 with the total sales of $12,798 whereas in the year 2022 the top product is PRODUCT30 with the total sales of $13,888.
3. In Area Chart which product is highly sold on 28th April 2022? ==> The large number of sales on 28th April 2022 is for PRODUCT14 with a 24% of profit ratio.
4. What is the sales type and payment mode present? ==> The sale type and payment modes show the sales percentage contribution based on the type of selling and mode of payment. Here, the sale types are Direct Sales with 52%, Online Sales with 33% and Wholesaler with 15%. Also, the payment modes are Online mode and Cash equally distributed with 50%.
5. In which month the direct sales are highest in the year 2022? ==> The highest direct sales can be easily identified which is designed by monthly format and it’s the November month where direct sales are highest with 28% as compared with other months.
6. Which payment mode is highly received in the year 2021 and year 2022? ==> The payments received in the year 2021 are the cash payments with 52% as compared with online transactions which are 48%. Also, the cash payment highly received is in the month of March, July and October with direct sales of 42%, Online with 45% and wholesaler with 13% with large sales of PRODUCT24. ==> The payments received in the year 2022 are the Online payments with 52% as compared with cash payments which are 48%. Also, the online payment highly received is in the month of Jan, Sept and December with direct sales of 45%, Online with 37% and whole...

Sheet 1 (Raw-Data): The raw data of the study is provided, presenting the tagging results for the used measures described in the paper. For each subject, it includes multiple columns: A. a sequential student ID B an ID that defines a random group label and the notation C. the used notation: user Story or use Cases D. the case they were assigned to: IFA, Sim, or Hos E. the subject's exam grade (total points out of 100). Empty cells mean that the subject did not take the first exam F. a categorical representation of the grade L/M/H, where H is greater or equal to 80, M is between 65 included and 80 excluded, L otherwise G. the total number of classes in the student's conceptual model H. the total number of relationships in the student's conceptual model I. the total number of classes in the expert's conceptual model J. the total number of relationships in the expert's conceptual model K-O. the total number of encountered situations of alignment, wrong representation, system-oriented, omitted, missing (see tagging scheme below) P. the researchers' judgement on how well the derivation process explanation was explained by the student: well explained (a systematic mapping that can be easily reproduced), partially explained (vague indication of the mapping ), or not present.

Tagging scheme:
Aligned (AL) - A concept is represented as a class in both models, either

with the same name or using synonyms or clearly linkable names; Wrongly represented (WR) - A class in the domain expert model is incorrectly represented in the student model, either (i) via an attribute, method, or relationship rather than class, or (ii) using a generic term (e.g., user'' instead ofurban planner''); System-oriented (SO) - A class in CM-Stud that denotes a technical implementation aspect, e.g., access control. Classes that represent legacy system or the system under design (portal, simulator) are legitimate; Omitted (OM) - A class in CM-Expert that does not appear in any way in CM-Stud; Missing (MI) - A class in CM-Stud that does not appear in any way in CM-Expert.

All the calculations and information provided in the following sheets

originate from that raw data.

Sheet 2 (Descriptive-Stats): Shows a summary of statistics from the data collection,

including the number of subjects per case, per notation, per process derivation rigor category, and per exam grade category.

Sheet 3 (Size-Ratio):

The number of classes within the student model divided by the number of classes within the expert model is calculated (describing the size ratio). We provide box plots to allow a visual comparison of the shape of the distribution, its central value, and its variability for each group (by case, notation, process, and exam grade) . The primary focus in this study is on the number of classes. However, we also provided the size ratio for the number of relationships between student and expert model.

Sheet 4 (Overall):

Provides an overview of all subjects regarding the encountered situations, completeness, and correctness, respectively. Correctness is defined as the ratio of classes in a student model that is fully aligned with the classes in the corresponding expert model. It is calculated by dividing the number of aligned concepts (AL) by the sum of the number of aligned concepts (AL), omitted concepts (OM), system-oriented concepts (SO), and wrong representations (WR). Completeness on the other hand, is defined as the ratio of classes in a student model that are correctly or incorrectly represented over the number of classes in the expert model. Completeness is calculated by dividing the sum of aligned concepts (AL) and wrong representations (WR) by the sum of the number of aligned concepts (AL), wrong representations (WR) and omitted concepts (OM). The overview is complemented with general diverging stacked bar charts that illustrate correctness and completeness.

For sheet 4 as well as for the following four sheets, diverging stacked bar

charts are provided to visualize the effect of each of the independent and mediated variables. The charts are based on the relative numbers of encountered situations for each student. In addition, a "Buffer" is calculated witch solely serves the purpose of constructing the diverging stacked bar charts in Excel. Finally, at the bottom of each sheet, the significance (T-test) and effect size (Hedges' g) for both completeness and correctness are provided. Hedges' g was calculated with an online tool: https://www.psychometrica.de/effect_size.html. The independent and moderating variables can be found as follows:

Sheet 5 (By-Notation):

Model correctness and model completeness is compared by notation - UC, US.

Sheet 6 (By-Case):

Model correctness and model completeness is compared by case - SIM, HOS, IFA.

Sheet 7 (By-Process):

Model correctness and model completeness is compared by how well the derivation process is explained - well explained, partially explained, not present.

Sheet 8 (By-Grade):

Model correctness and model completeness is compared by the exam grades, converted to categorical values High, Low , and Medium.

IPPS DRG Provider Summary

Average Discharges, Charges, and Medicare Payments

By Health [source]

About this dataset

This dataset is a valuable resource for gaining insight into Inpatient Prospective Payment System (IPPS) utilization, average charges and average Medicare payments across the top 100 Diagnosis-Related Groups (DRG). With column categories such as DRG Definition, Hospital Referral Region Description, Total Discharges, Average Covered Charges, Average Medicare Payments and Average Medicare Payments 2 this dataset enables researchers to discover and assess healthcare trends in areas such as provider payment comparsons by geographic location or compare service cost across hospital. Visualize the data using various methods to uncover unique information and drive further hospital research

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset provides a provider level summary of Inpatient Prospective Payment System (IPPS) discharges, average charges and average Medicare payments for the Top 100 Diagnosis-Related Groups (DRG). This data can be used to analyze cost and utilization trends across hospital DRGs.

To make the most use of this dataset, here are some steps to consider:

• Understand what each column means in the table: Each column provides different information from the DRG Definition to Hospital Referral Region Description and Average Medicare Payments.
• Analyze the data by looking for patterns amongst the relevant columns: Compare different aspects such as total discharges or average Medicare payments by hospital referral region or DRG Definition. This can help identify any potential trends amongst different categories within your analysis.
• Generate visualizations: Create charts, graphs, or maps that display your data in an easy-to-understand format using tools such as Microsoft Excel or Tableau. Such visuals may reveal more insights into patterns within your data than simply reading numerical values on a spreadsheet could provide alone.

Research Ideas

• Identifying potential areas of cost savings by drilling down to particular DRGs and hospital regions with the highest average covered charges compared to average Medicare payments.
• Establishing benchmarks for typical charges and payments across different DRGs and hospital regions to help providers set market-appropriate prices.
• Analyzing trends in total discharges, charges and Medicare payments over time, allowing healthcare organizations to measure their performance against regional peers

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

License: Open Database License (ODbL) v1.0 - You are free to: - Share - copy and redistribute the material in any medium or format. - Adapt - remix, transform, and build upon the material for any purpose, even commercially. - You must: - Give appropriate credit - Provide a link to the license, and indicate if changes were made. - ShareAlike - You must distribute your contributions under the same license as the original. - Keep intact - all notices that refer to this license, including copyright notices. - No Derivatives - If you remix, transform, or build upon the material, you may not distribute the modified material. - No additional restrictions - You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.

Columns

File: 97k6-zzx3.csv | Column name | Description | |:-----------------------------------------|:------------------------------------------------------| | drg_definition | Diagnosis-Related Group (DRG) definition. (String) | | average_medicare_payments | Average Medicare payments for each DRG. (Numeric) | | hospital_referral_region_description | Description of the hospital referral region. (String) | | total_discharges | Total number of discharges for each DRG. (Numeric) | | average_covered_charges | Average covered charges for each DRG. (Numeric) | | average_medicare_payments_2 | Average Medicare payments for each DRG. (Numeric) |

**File: Inpatient_Prospective_Payment_System_IPPS_Provider_Summary_for_the_Top_100_Diagnosis-Related_Groups_DRG...

"The Statistical Abstract of the United States, published since 1878, is the standard summary of statistics on the social, political, and economic organization of the United States. It is designed to serve as a convenient volume for statistical reference and as a guide to other statistical publications and sources. The latter function is served by the introductory text to each section, the source note appearing below each table, and Appendix I, which comprises the Guide to Sources of Statisti cs, the Guide to State Statistical Abstracts, and the Guide to Foreign Statistical Abstracts. The Statistical Abstract sections and tables are compiled into one Adobe PDF named StatAbstract2009.pdf. This PDF is bookmarked by section and by table and can be searched using the Acrobat Search feature. The Statistical Abstract on CD-ROM is best viewed using Adobe Acrobat 5, or any subsequent version of Acrobat or Acrobat Reader. The Statistical Abstract tables and the metropolitan areas tables from Appendix II are available as Excel(.xls or .xlw) spreadsheets. In most cases, these spreadsheet files offer the user direct access to more data than are shown either in the publication or Adobe Acrobat. These files usually contain more years of data, more geographic areas, and/or more categories of subjects than those shown in the Acrobat version. The extensive selection of statistics is provided for the United States, with selected data for regions, divisions, states, metropolitan areas, cities, and foreign countries from reports and records of government and private agencies. Software on the disc can be used to perform full-text searches, view official statistics, open tables as Lotus worksheets or Excel workbooks, and link directly to source agencies and organizations for supporting information. Except as indicated, figures are for the United States as presently constituted. Although emphasis in the Statistical Abstract is primarily given to national data, many tables present data for regions and individual states and a smaller number for metropolitan areas and cities.Statistics for the Commonwealth of Puerto Rico and for island areas of the United States are included in many state tables and are supplemented by information in Section 29. Additional information for states, cities, counties, metropolitan areas, and other small units, as well as more historical data are available in various supplements to the Abstract. Statistics in this edition are generally for the most recent year or period available by summer 2006. Each year over 1,400 tables and charts are reviewed and evaluated; new tables and charts of current interest are added, continuing series are updated, and less timely data are condensed or eliminated. Text notes and appendices are revised as appropriate. This year we have introduced 72 new tables covering a wide range of subject areas. These cover a variety of topics including: learning disability for children, people impacted by the hurricanes in the Gulf Coast area, employees with alternative work arrangements, adult computer and Internet users by selected characteristics, North America cruise industry, women- and minority-owned businesses, and the percentage of the adult population considered to be obese. Some of the annually surveyed topics are population; vital statistics; health and nutrition; education; law enforcement, courts and prison; geography and environment; elections; state and local government; federal government finances and employment; national defense and veterans affairs; social insurance and human services; labor force, employment, and earnings; income, expenditures, and wealth; prices; business enterprise; science and technology; agriculture; natural resources; energy; construction and housing; manufactures; domestic trade and services; transportation; information and communication; banking, finance, and insurance; arts, entertainment, and recreation; accommodation, food services, and other services; foreign commerce and aid; outlying areas; and comparative international statistics." Note to Users: This CD is part of a collection located in the Data Archive of the Odum Institute for Research in Social Science, at the University of North Carolina at Chapel Hill. The collection is located in Room 10, Manning Hall. Users may check the CDs out subscribing to the honor system. Items can be checked out for a period of two weeks. Loan forms are located adjacent to the collection.

These charts provide a snapshot of the domestic and global market for rice, the primary staple for more than half the world's population. Excel files are available from the monthly Outlook reports.

Analyzing Coffee Shop Sales: Excel Insights 📈

In my first Data Analytics Project, I Discover the secrets of a fictional coffee shop's success with my data-driven analysis. By Analyzing a 5-sheet Excel dataset, I've uncovered valuable sales trends, customer preferences, and insights that can guide future business decisions. 📊☕

DATA CLEANING 🧹

• REMOVED DUPLICATES OR IRRELEVANT ENTRIES: Thoroughly eliminated duplicate records and irrelevant data to refine the dataset for analysis.

• FIXED STRUCTURAL ERRORS: Rectified any inconsistencies or structural issues within the data to ensure uniformity and accuracy.

• CHECKED FOR DATA CONSISTENCY: Verified the integrity and coherence of the dataset by identifying and resolving any inconsistencies or discrepancies.

DATA MANIPULATION 🛠️

• UTILIZED LOOKUPS: Used Excel's lookup functions for efficient data retrieval and analysis.

• IMPLEMENTED INDEX MATCH: Leveraged the Index Match function to perform advanced data searches and matches.

• APPLIED SUMIFS FUNCTIONS: Utilized SumIFs to calculate totals based on specified criteria.

• CALCULATED PROFITS: Used relevant formulas and techniques to determine profit margins and insights from the data.

PIVOTING THE DATA 𝄜

• CREATED PIVOT TABLES: Utilized Excel's PivotTable feature to pivot the data for in-depth analysis.

• FILTERED DATA: Utilized pivot tables to filter and analyze specific subsets of data, enabling focused insights. Specially used in “PEAK HOURS” and “TOP 3 PRODUCTS” charts.

VISUALIZATION 📊

• KEY INSIGHTS: Unveiled the grand total sales revenue while also analyzing the average bill per person, offering comprehensive insights into the coffee shop's performance and customer spending habits.

• SALES TREND ANALYSIS: Used Line chart to compute total sales across various time intervals, revealing valuable insights into evolving sales trends.

• PEAK HOUR ANALYSIS: Leveraged Clustered Column chart to identify peak sales hours, shedding light on optimal operating times and potential staffing needs.

• TOP 3 PRODUCTS IDENTIFICATION: Utilized Clustered Bar chart to determine the top three coffee types, facilitating strategic decisions regarding inventory management and marketing focus.

*I also used a Timeline to visualize chronological data trends and identify key patterns over specific times.

While it's a significant milestone for me, I recognize that there's always room for growth and improvement. Your feedback and insights are invaluable to me as I continue to refine my skills and tackle future projects. I'm eager to hear your thoughts and suggestions on how I can make my next endeavor even more impactful and insightful.

THANKS TO: WsCube Tech Mo Chen Alex Freberg

TOOLS USED: Microsoft Excel

DataAnalytics #DataAnalyst #ExcelProject #DataVisualization #BusinessIntelligence #SalesAnalysis #DataAnalysis #DataDrivenDecisions

The Statistical Abstract is the Nation's best known and most popular single source of statistics on the social, political, and economic organization of the country. The print version of this reference source has been published since 1878 while the compact disc version first appeared in 1993. This disc is designed to serve as a convenient, easy-to-use statistical reference source and guide to statistical publications and sources. The disc contains over 1,400 tables from over 250 different gove rnmental, private, and international organizations. The 1998 Statistical Abstract on CD-ROM, like the book, is a statistical reference and guide to over 250 statistical publications and sources from government and private organizations. This compact disc (CD) has 1,500 tables and charts from over 250 sources. Text and tables can be viewed or searched with the software. Tables and charts cover these subjects in 31 sections and 2 appendices: Population, Vital Statistics, Health and Nutrition, Education, Law Enforcement, Courts and Prisons, Geography and Environment, Parks, Recreation and Travel, Elections, State and Local Government, Finances and Employment, Federal Government, Finances and Employment, National Defense and Veterans Affairs, Social Insurance and Human Services, Labor Force, Employment and Earnings, Income, Expenditure and Wealth, Prices, Banking, Finance and Insurance, Business Enterprise, Communications, Energy, Science, Transportation -- Land, Transportation -- Air and Water, Agriculture, Forests and Fisheries, Mining and Mineral Products, Construction and Housing, Manufactures, Domestic Trade and Services, Foreign Commerce and Aid, Outlying Areas, Comparative International Statistics, State Rankings, Population of MSAs, Congressional District Profiles. There are changes this year in both the content of the information on the disc and software used for accessing and installing the information. As usual, updates have been made to most of the more than 1,500 tables and charts that were on the previous disc with new or more recent data. The spreadsheet files which are available in both the Excel or Lotus formats for these ta bles will usually have more information than displayed in the book or Adobe Acrobat files. There are also 93 new tables on such subjects as family planning, women's health, persons with disabilities, health insurance coverage, ambulatory surgery, school violence, household use of public libraries, public library of the Internet, toxic chemical releases, leisure activity, NCAA sports and high school athletic programs, voter registration, licensed child care centers, foster care, home-based businesses, employee benefits, home equity debt, use of debit credit cards, alcohol-related fatal accidents, computer shipments, and foreign stock market indices. See Appendix V on the disc for a complete list of the new tables presented. In the software area, a new opening screen using the DemoShield software has been added. This provide better access to the electronic version of the booklet which is available from the opening screen, the new tutorial step the user through the principal ways to search for information on this disc and other related helpful information. It will also facilitate the installation process for the Adobe Acrobat Reader, the new Microsoft Excel Viewer, and QuickTime for viewing movies. The Adobe Acrobat Reader and Search engine, version 3.01, is on the disc. The Acrobat Reader allows users to view, navigate, search, and print on demand any of the pages from the book. Note to Users: This CD is part of a collection located in the Data Archive of the Odum Institute for Research in Social Science, at the University of North Carolina at Chapel Hill. The collection is located in Room 10, Manning Hall. Users may check the CDs out subscribing to the honor system. Items can be checked out for a period of two weeks. Loan forms are located adjacent to the collection.

The National Diabetes Audit (NDA) continues to provide a comprehensive view of Diabetes Care in England and Wales and measures the effectiveness of diabetes healthcare against NICE Clinical Guidelines and NICE Quality Standards, in England and Wales. This national report presents the key findings and recommendations on care processes and treatment target achievement rates from 2015-2016 in all age groups in England and Wales along with information on offers and attendance for structured education places. This year, for the first time information is reported on the number of people with diabetes who also have a learning disability and completion of care processes and treatment target achievement. A separate national report presents the key findings and recommendations; The Learning Disability - Supplementary Information report has also been developed as a power point presentation. As with last year's publication the main report contains information on the national key findings and recommendations and has also been developed as a power point presentation, along with slides highlighting the national findings there is also space to allow the incorporation of locally produced slides using the tables and charts from the interactive spreadsheets. We hope that users will find this beneficial to help disseminate the results of the audit locally. Supplementary data for England and Wales are contained in the excel spreadsheets. There are 6 excel spreadsheets; two spreadsheets contains the tables and charts in the national report and learning disability report along with some supplementary national figures, a further spreadsheet provides all 8 care process completion and all 3 treatment target achievement for CCGs/LHBs by age group. There are also 3 interactive excel spreadsheets which allow users to select the CCG/GP practice (England only), Local Health Board (Wales only) or Secondary Care Service (England only) of choice, information for the chosen site is then displayed in tables and charts. Please note that the interactive excel spreadsheets are large files (approximately 12MB) and may take some time to open. This report was updated on 09/02/17. The following amendments have been made to the report: The CCG/GP spreadsheet was updated as some of the CCGs/general practices were not available in the interactive aspect. We have also added a reference table for practice codes and names. All the data for care processes and treatment targets was correct in the supporting data tables. The spreadsheet report for Wales and LHBs has been amended. A practice wrongly appeared in a LHB, this practice has now been assigned to the correct LHB which has changed the results for LHB 7A2 and 7A3. The specialist service spreadsheet has been updated as the interactive aspect was not working for all hospitals. This does not change the results for specialist services. Both the CCG/GP and LHB spreadsheets have been updated for structured education offered and attendance. This has changed the results for individual CCGs/Practices and LHBs but not the national results. We have updated the methodology documentation for structured education to explain more fully how we have analysed and reported on the structured education data for the 2015-16 audit report. We have also added a link, which can be found below in resources, to our interactive dashboard for the 2015-16 report. This dashboard provides CCGs, LHBs and GPs (England only) with an alternative way to view their data for completion of all 8 care process and achievement of all 3 treatment targets as well their data on registrations by age, sex, deprivation and ethnicity.

The EPR is an annual rating which generates a rating from zero to four stars for grant holders based upon a provider’s performance in three Key Performance Areas (KPAs): delivery performance, quality and contract compliance. For each KPA, performance is assessed through one or more performance indicators. The weighting each indicator contributes towards a KPA score has been developed in consultation with providers and the Performance Ratings should place a high emphasis on performance (i.e. outputs and results).

Key Performance Area (KPA) Weighting Indicators (KPI) Weighting of indicator within KPA Contract Performance 60% 1. Delivery against grant targets 48% 2. Delivery against grant diversity targets 12% Quality 30% 3. Conversion Factor 12% 4. Self assessment of quality 9% 5. Client Satisfaction 9% Contract Compliance 10% 6. Contract compliance and contractor pro-activity in delivery 10%

The idea behind the ratings is to identify good performance and also highlight where projects may need to improve to deliver better results. The ratings also allows the funding bodies to identify the top performing organisations more easily and make more informed funding decisions. “The Employability Performance Rating tool is a great way of both demonstrating and measuring the value of European Social Fund funded programmes in London, and we are delighted that London’s ESF co-financing organisations have adopted it.” Alex Conway, London European Programmes Director.

The 2017/18 ratings are now published. Please see the below document to view the different ratings providers have received. The briefing for the 2017/18 ratings is also available to download. Last year's ratings are still available to download below. Full Employability Performance Rating details can be found in the charts and tables below: In chart form, this will be available for this year's ratings soon - http://data.london.gov.uk/employability-performance-rating-charts/

Or in an excel spreadsheet below:

UPDATED EVERY WEEK Last Update - 26th July 2025

Disclaimer!!! Data uploaded here are collected from the internet and some google drive. The sole purposes of uploading these data are to provide this Kaggle community with a good source of data for analysis and research. I don't own these datasets and am also not responsible for them legally by any means. I am not charging anything (either money or any favor) for this dataset. RESEARCH PURPOSE ONLY

Context

• The NIFTY 50 is a well-diversified 50 stock index and it represents 13 important sectors of the economy.
• It is used for a variety of purposes such as benchmarking fund portfolios, index-based derivatives, and index funds.
• NIFTY 50 is owned and managed by NSE Indices Limited.
• The NIFTY 50 index has shaped up to be the largest single financial product in India.

This data contains all the indices of NSE. NIFTY 50, NIFTY BANK, NIFTY 100, NIFTY COMMODITIES, NIFTY CONSUMPTION, NIFTY FIN SERVICE, NIFTY IT, NIFTY INFRA, NIFTY ENERGY, NIFTY FMCG, NIFTY AUTO, NIFTY 200, NIFTY ALPHA 50, NIFTY 500, NIFTY CPSE, NIFTY GS COMPSITE, NIFTY HEALTHCARE, NIFTY CONSR DURBL, NIFTY LARGEMID250, NIFTY INDIA MFG, NIFTY IND DIGITAL, INDIA VIX

File Information and Column Descriptions.

Nifty 50 index data with 1 minute data. The dataset contains OHLC (Open, High, Low, and Close) prices from Jan 2015 to Aug 2024. - This dataset can be used for time series analysis, regression problems, and time series forecasting both for one step and multi-step ahead in the future. - Options data can be integrated with this minute data, to get more insight about this data. - Different backtesting strategies can be built on this data.

File Information

• This dataset contains 6 files, each file contains nifty 50 data with different intervals.
• Different intervals are - 1 min, 3 min, 5 min, 15 min, and 1 hour, Daily data from intervals of 2015 Jan to 2024 August.

Column Descriptors

• Each file contains OHLC (Open, High, Low, and Close) prices and Data time information. Since these are Nifty 50 index data, so volume is not present.

Inspiration

Time series forecasting - Predict stock price

• Predict future stock price one step ahead and multi-step ahead in time.
• Use different time series forecasting techniques for forecasting the future stock price. ### Machine learning and Deep learning techniques
• Possible ML and DL models include Neural networks, RNNs, LSTMs, Transformers, Attention networks, etc.
• Different error functions can be considered like RMSE, MAE, RMSEP etc. ### Feature engineering
• Different augmented features can be created and that can be used for forecasting.
• Correlation analysis, Feature importance to justify the important features.

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