Friday, 4 April 2014

Visualizations



All the graphs are embedded in the visual table below.



Here we gave the individual descriptions for each graph along with the specific graphs.

Let's recall the attributes and metrics that we used for our five questions

Attributes:
  • Slot Machine (The individual Slot Machine unit)
  • Weather (The weather outside during business hours)
  • Slot Machine Make(Each slot machine is created by an unique company)
  • Slot  Machine Model (The design of the slot machine)
  • Slot Machine Game (The are various types of different games associated with each slot machine)
  • Slot Machine Zone (Area within the casino where the slot machine is located)
 Metric:
  • Pay Out Amount (The amount that the machine pays out to the winner)
  • Coin In (The amount of revenue that each slot machine generates)
  • Jackpot Amount (The amount that the player wins if they win a jackpot)
  • Slot Win
     

    The Key Performance Indicator Chart expresses the profitability of each Slot Machine. The darker the circle to more profit that machine makes. As you could see in the chart as the Jackpot amount increases the less profitable the slot machines seem to become. This could be due to the fact that the gamblers at this particular casino are either professionals, cheaters  or they realize that chances of you winning decreases as the jackpot increases and stick to the lesser machines. 




     The slot hold by machine type chart expresses the profitability of each machine based on how much money they accept in order to play. In the chart we can see that the 0.25 cent machine is by far the most profitable followed by the $1. The least profitable machine was the $25 machine. As much as we had expected the $100 machine to be the most profitable it was the 3rd least profitable machine out of all of them bringing less than $250,000.






    This chart is the daily analysis of coin in of the selected slot machines. From this graph we see the revenue from each particular date. We see that the coin in maxes out at 1.3 million at December 25th, 2012 (Christmas Day) and minimizes at 600,000 at November 12, 2012.







Saturday, 29 March 2014

What is a dashboard?

A dashboard is a real-time user interface that depicts a graphical representation of the contemporary as well as historical trends of a company. It presents the information in a way that is easy to read and understand.It provides the  visual display of the most important information,  that is needed to achieve  the goals and is strengthened  and arranged on a single screen for quick access . It presents the information the way you think and work. The main role of a dashboard is it makes it easy for managers to monitor, examine, and sometimes add notes and make a quick decision. It converts the huge database into concise form. Dashboards indicates signs regarding  a business allowing  the users to know if something is wrong. Dashboards commonly execute summaries, comparisons, key trends and exceptions.
http://searchcio.techtarget.com/definition/dashboard


Mission Statement:

The Mission statement for our dashboard is  developing an accurate and complete understanding of how gambling helps make money.

What is role of dashboards in business intelligence?

 Business Intelligence features to convert the raw data into useful information.Dashboards are popular and important BI tools. A business intelligence dashboard is a data visualization tool that displays the current status of metrics and key performance indicators (KPIs)  important to a particular target or business process (e.g. sales, marketing, human resources, or production) at one look. Dashboards enhance and arrange numbers,metrics and sometimes performance scorecards on a single screen. They may be modified for a specific role and exhibits the metrics that are aimed for a single point of view or department. The essential features of a BI dashboard product include a customizable interface and the ability to pull real-time data from multiple sources.
http://searchbusinessanalytics.techtarget.com/definition/business-intelligence-dashboard
 
How can dashboards help with big data?
Many businesses have a large volume of data that needs to be processed and kept in stock for years. In such  cases  many users can benefit from the use of strong powerful dashboard applications, which allows saving and processing larger number of data.Dashboard presents the data to larger audiences.Dashboards distribute large amount of data to myriad users at one time.It is effective in managing large amounts of data.
How are dashboards useful in business?
A dashboard  is a business tool that plays a vital role in many different sectors of different businesses. It provides an overview of the vital information that the business users need to understand and improve the performance of company.  It can save the employees time and the money of business.  It classify the events correctly and add up the right numbers and produce important facts. It is  both  efficient as well as effective way to access the data and information.Executives need to know the return they are getting on their marketing cost.In CRM(customer relationship management) dashboards are an easy way to monitor business performance.
What enterprise and activity does your dataset represent?
The Enterprise is Legalized Gambling and the activity is gambling money on the slot machines. The industry that deals with the casinos is called the gaming industry.  The data set  represents  a game of chance in gambling and in some cases with skilled elements like blackjack and video poker.It also shows the revenue earned from different slot machine games using different slot machine models at different periods in years 2010 and 2011.

Five Questions related to the Data set are :

Which Slot Machine Type pays out the most?

Attributes: 

Slot Machine Type

Metric: 
Pay Amount
Which Weather is ideal for revenue growth (coin in)?


Attribute: 
Weather

Metric: 
Coin In Amount

Which Slot Machine Make has the most coin in?

Attribute:
Slot Machine Make
Metric:
Coin in Amount

Which Slot Machine Game has the highest Jackpot Amount?

Attribute: 
Slot Machine Game

Metric:
Jackpot Amount

Which Slot Machine Make generated the most revenue?

Attribute:
Slot Machine Make

Metric:
Coin In Amount

Total Attributes and Metrics Characteristics:

Attributes:
  • Slot Machine Type
  • Weather
  • Slot Machine Make
  • Slot  Machine Model
  • Slot Machine Game
  • Slot Machine Zone
 Metric:
  • Pay Out Amount
  • Coin In
  • Jackpot Amount
  • Slot Win
Group Members:
Rawinder Kaur
Troy Mason
Alexander Saglaev
Andrew
Manjot Angi