data imputation(showing the strategy)on excel,making regression model on excel, making tableau analysis(with a file) for the "companies" file attached and making a report based on the foundings. no powerpoint
Course Project - BUSI650 Business Analytics Course Project - BUSI650 Business Analytics Weightage: 25% of the final grade (Report 20% + Presentation 5%) PROJECT DETAILS This project may be done in groups of size 2-3. We will have higher standards for those working in groups of 3, but either way we expect it to be a substantial project on which you devote significant effort. It's difficult to quantify "significant effort" but there's a grading rubric that can clarify this. We are not looking for a perfect project, instead we are interested to see how you identify some of the challenges and come up with strategies to handle them. You may include your failed attempts in the report, what you learned from them, and how you improved your work to get into your final submission. Outline: • Dataset • Methods, Tools, And Techniques • Sample Business Questions • Presentation Guide • Report Guide • Assessment • Submission I. Dataset Datasets: We've identified the following sources of data (over 600 datasets to choose from) that we recommend using for your project. You are free to use any of these datasets; see discussion below. 1. UC Irvine Dataset Repository (there are over 600 standard datasets to choose from) Additional Options: 2. Poverty Statistics o Download link: Poverty Data o Source: World Bank Data o Description: For countries with an active poverty monitoring program, the World Bank -- in collaboration with national institutions, other development agencies, and civil society -- regularly conducts analytical work to assess the extent and causes of poverty and inequality, examine the impact of growth and public policy, and review household survey data and measurement methods. Data here includes poverty and inequality measures generated from analytical reports, from national poverty monitoring programs, and from the World Bank's Development Research Group which has been producing internationally comparable and global poverty estimates and lines since 1990. 3. Consumer Complaints o Download link: Consumer Complaints (zipped csv file) o Source: Consumer Complaint Database o Description: A database of complaints the Consumer Financial Protection Bureau has received about financial products and services. 4. USA's Consumer Price Index https://archive-beta.ics.uci.edu/ http://api.worldbank.org/v2/en/topic/11?downloadformat=csv http://data.worldbank.org/topic/poverty https://files.consumerfinance.gov/ccdb/complaints.csv.zip https://catalog.data.gov/dataset/consumer-complaint-database#topic=consumer_navigation Course Project - BUSI650 Business Analytics o Download link: historicalcpi.xls o Source: United States Department of Agriculture Economic Research Service o Description: The Consumer Price Index (CPI) for food is a component of the all-items CPI. The CPI measures the average change over time in the prices paid by urban consumers for a representative market basket of consumer goods and services. While the all-items CPI measures the price changes for all consumer goods and services, including food, the CPI for food measures the changes in the retail prices of food items only. 5. Indicators on Women and Men o Download links: ▪ Legal Age for Marriage ▪ Marriages ▪ Maternity leave benefits ▪ Part-time employment ▪ Teaching staff ▪ Women legislators and managers o Source: United Nations Statistics Division (UNSD) o Description: The Indicators on Women and Men provides the latest statistics and indicators on women and men in six specific fields of concern: population, women and men in families, health, education, work, and political decision making. The statistics and indicators refer to the latest year for which sex-disaggregated data are available. The data have been compiled from official national sources as well as international sources. 6. Startups: Funding and Acquisitions o Download link: Data on Startup Companies, Investments, and Acquisitions (zipped folder with many csv files included) o Source: Crunchbase o Description: Crunchbase data contains crowdsourced information on a large number of startups including who invested in them and how much. Data includes Companies across the world that have raised money, Investors (individual and institutional) that have invested in those companies, Funding rounds of investment, and records of all acquisitions of these startups. Other information about the companies (e.g., category, location) is also included. 7. Crime and Socioeconomic Indicators o Download links: ▪ Crimes - 2001 to present (Chicago) (Press "Export") ▪ Census Data - Selected socioeconomic indicators in Chicago, 2008 - 2012 ▪ Crime in the United States (USA) o Source: City of Chicago, census.gov (via Big Data for Social Good Challenge) o Description: ▪ Crimes - Reported incidents of crime (except murders) in the city of Chicago from 2001 to present, minus the most recent seven days. ▪ Small Area Income and Poverty Estimates - The files in the data directory contain estimates of poverty and income for 2013. There is one data file for each state and for the US, with data for all the 2013 statistics. Additionally, there is one file that includes data for the US and each state and county. ▪ Census Data - A selection of six socioeconomic indicators of public health significance, and a hardship index. (Example area to explore: Is there a relationship between the number of crimes in the city of Chicago and socioeconomic indicators such as median income, poverty, and education?) https://www.ers.usda.gov/webdocs/DataFiles/50673/historicalcpi.xlsx?v=5321.3 http://www.ers.usda.gov/data-products/food-price-outlook.aspx http://data.un.org/DocumentData.aspx?id=336 http://data.un.org/DocumentData.aspx?id=337 http://data.un.org/DocumentData.aspx?id=344 http://data.un.org/DocumentData.aspx?id=340 http://data.un.org/DocumentData.aspx?id=338 http://data.un.org/DocumentData.aspx?id=342 http://data.un.org/Explorer.aspx?d=16 https://github.com/notpeter/crunchbase-data/archive/master.zip https://github.com/notpeter/crunchbase-data https://data.cityofchicago.org/Public-Safety/Crimes-2001-to-present/ijzp-q8t2 https://data.cityofchicago.org/Health-Human-Services/Census-Data-Selected-socioeconomic-indicators-in-C/kn9c-c2s2 https://www.fbi.gov/about-us/cjis/ucr/crime-in-the-u.s/2013/crime-in-the-u.s.-2013/tables/1tabledatadecoverviewpdf/table_1_crime_in_the_united_states_by_volume_and_rate_per_100000_inhabitants_1994-2013.xls https://data.cityofchicago.org/ http://www.census.gov/ https://ibmhadoop.devpost.com/details/data Course Project - BUSI650 Business Analytics 8. New York City o Download links: ▪ New York City Open Data ▪ New York City Restaurant Inspection Results o Source: data.ny.gov o Description: New York City Open Data contains data on a wide variety of NYC aspects (e.g., education, safety, recreation, and many more). New York City Restaurant Inspection Results captures restaurant inspections, violations, grades, and adjudication information in NYC. 9. Walmart o Download links: ▪ stores.csv, features.csv, train.csv (download all button) o Source: Kaggle Competition o Description: Historical sales data for 45 Walmart stores in different regions. (Example area to explore: the effect on sales of weather, temperature, fuel consumption, the holiday season, and other factors.) 10. World Health o Download link: Indicators - we recommend any of the datasets in the Health section o Source: World Bank Data o Description: Worldwide health data covering factors such as fertility rates, HIV, immunization, population, life expectancy, birth rates, death rates and many more 11. European city temperatures o Download links: Cities.csv, Countries.csv o Join of two tables: CitiesExt.csv o Description: Average annual temperature (in degrees Celsius) and latitude / longitude information for 213 European cities (Cities.csv), along with additional information on coastal status, EU membership, and population (in millions) of each country in Europe (Countries.csv). o Note: Longitude is negative when West of the Prime Meridian 12. Shop o Download link: Shop.csv o Description: Data on some shopping items. 13. Titanic o Download link: Titanic.csv o Description: Data on passengers of the RMS Titanic. Entries include the name, age, class, fare, gender, and whether or not the passenger survived o Note: Blank ages are unknown, and fare can have more than two digits because money was not base-10 at that time Titanic Fare Data https://data.ny.gov/ https://data.cityofnewyork.us/Health/DOHMH-New-York-City-Restaurant-Inspection-Results/43nn-pn8j https://data.ny.gov/ https://www.kaggle.com/c/walmart-recruiting-store-sales-forecasting/data?test.csv.zip https://www.kaggle.com/c/walmart-recruiting-store-sales-forecasting/data?test.csv.zip http://data.worldbank.org/indicator http://data.worldbank.org/ http://web.stanford.edu/class/cs102/datasets/Cities.csv http://web.stanford.edu/class/cs102/datasets/Countries.csv http://web.stanford.edu/class/cs102/datasets/CitiesExt.csv http://web.stanford.edu/class/cs102/datasets/Shop.csv http://web.stanford.edu/class/cs102/datasets/Titanic.csv http://www.statisticalconsultants.co.nz/blog/titanic-fare-data.html Course Project - BUSI650 Business Analytics 14. World Cup o Download links: Players.csv, Teams.csv o Description: 2010 World Cup data including last name, team, position, minutes played, and game statistics for each player (Players.csv) as well as world ranking, games played in tournaments, and game statistics for each team (Teams.csv)The dataset includes all except the final game; it was published as part of a contest for data-driven predictions of the ultimate champion. o Note: Statistics, including yellowCards and RedCards, are for the entire tournament (excluding final game). Team ranking is the world ranking going into the tournament so may not be 1-32 even though there are only 32 teams. For the joined dataset (PlayersExt.csv), keep in mind that since the tables are joined, country data will show up for each player. 15. Coronavirus Datasets • Johns Hopkins dataset • Kaggle datasets (includes country datasets and links to useful sites like WHO and CDC) • EU CDC - publishes downloadable data daily • Downloadable versions of ALL data from EU CDC (collected when it is published daily on the EU CDC website) • State and county level data for coronavirus in the U.S. (compiled by The New York Times) • Tweets from COVID-19 Twitter Stream (Compiled by Georgia State University Panacea Lab) • EU Open Data Portal – latest publicly available data on COVID-19 in Europe and selected other countries The above datasets are all relatively easy to access and the data is relatively consistent and complete. Be warned: In data analysis projects, it's common for more than 80% of the overall effort to be in obtaining the data and getting it ready for analysis, with less than 20% going into the analysis itself. Considering the limited time 2-3 weeks for the project, we're trying to alleviate this imbalance and the attendant frustration by providing a menu of datasets we know are not difficult to work with. Data formats: Most of the data listed above is provided in .xlsx (Excel) or .csv format. http://web.stanford.edu/class/cs102/datasets/Players.csv http://web.stanford.edu/class/cs102/datasets/Teams.csv https://github.com/CSSEGISandData/COVID-19 https://www.kaggle.com/sudalairajkumar/novel-corona-virus-2019-dataset https://www.ecdc.europa.eu/en/geographical-distribution-2019-ncov-cases https://ourworldindata.org/coronavirus-source-data https://github.com/nytimes/covid-19-data https://github.com/thepanacealab/covid19_twitter https://data.europa.eu/euodp/en/data/dataset/covid-19-coronavirus-data Course Project - BUSI650