In this exercise, I analyze the purchases of automobile options and infer association rules to provide better recommendations for future purchases. Association Rule Mining is a rule based machine learning method that looks to uncover associations and/or correlations within the available data. This type of analysis is also sometimes called affinity analysis or market basket […]
Business Analytics Projects
This Category will hold all my Business Analytics Certificate Projects
Credit Risk Classification Analysis (Data Mining)
In this post, I examine credit risk data and create a classification model using the K-Nearest Neighbor Algorithm (K-NN) to predict credit risk rating. In this exercise, the client had several new loan applicants and needed to asses the credit risk of the applicants. They provided historical data that included customers’ purchases, financial and demographic information […]
Sales Data Exploration and Reduction (Data Mining)
In this post, I examine Sales data and apply descriptive data mining techniques to analyze the data set and describe patterns. The main reason for conducting such an analysis is to help business leaders predict the future by informing their decision making process. I imagined that our client came to us with this question: Question: […]
Startup Venture Funding Visualizations with Tableau
In this post, I examined the data provided as training data on the Tableau under the technology section. I used the Startup Venture Funding Data which includes information about companies, investments, and acquisitions from 1960 till 2014 via Crunchbase . Tableau actually has several incredible data sets for training in their resources section, ranging from Government to […]
University Fundraising Data Visualization with Tableau
This data is fictitious data and was generated using random names and numbers that are commonly found on the internet. Any semblance to reality is only coincidental. However, this data set is very interesting and the questions that were posed provided an excellent practice round for analyzing university fundraising numbers. Here are the questions: 1. […]
Music Sales in Europe and Asia Visualization with Tableau
In this post, we examine data from a Music sale business. The owner provided us with their data and had several questions regarding music sales in Europe and Asia. Our client in particular has requested several visualizations. Which Genre sells the most? Who are the top 20 artists and do they produce music only in […]
2017 Manhattan Rolling Sales Data Visualization with Microsoft Power BI
In this post, we explore data from New York City’s Department of Finance. This data set includes the rolling sales of all New York City properties sold in the past 12 month period for all tax classes. I conducted this analysis in 2017, so the data in the link above may have been updated. This data […]
Exploring Aircraft Hardware Supplier Data for Key Insights
This post looks at some key business questions that can truly bring to light very interesting insights. Know thy business… In this exercise our client, an aircraft hardware suppliers, wanted to know key information about their business. they presented us with a spreadsheet database, containing several tables related to purchase orders and sales transactions. Here is […]