Monday, 24 March 2014

Casino Revenues (Post 1)

Using BIS

Post 1

By:

Harnoor Singh

Baljeet Singh

Harjobanpreet Singh

Heer Niraj kaur





What is a Dashboard?

A Dashboard reports allow the managers to get large amount reviews of the business. Excel is a superb tool to make capable dashboards that can give analysis, understanding and alert directors in auspicious way.

What is the role of dashboards in business intelligence?

·         Users will have a single place to gain access to their dashboards and additionally reports, presentations, and online discourses, alongside different provisions.
·         Single sign-on is made conceivable (rather than looking after different passwords and needing to log into various requisitions).

·         Productivity is expanded as clients can go to a single location to gain access to an assortment of related and unrelated data.
·         An essential issue is secured for an association to convey numerous or every last bit of its Business Intelligence provisions.

How can dashboards help with Big Data?

Now it is conceivable to get constant, enormous information experiences in Excel from your Kognitio stage. As the Kognitio Analytical Platform is so compelling, there is no requirement for prebuilt totals or the formation of physical OLAP 3d squares. So no compelling reason to move information, oversee complex situations or sit tight for blocks to be fabricated, bringing about crisp experiences when information is stacked.
·         No size limits – multiple terabytes of data available on demand
·         No physical cubes
·         Real-time updating – no waiting for cube builds
·         Massively reduced time to insight
Local access to Kognitio from Excel utilizing MDX makes accessible numerous terabytes of data in the business client's Business Intelligence stage of decision. Yet Big Data presents tests to Excel so Kognitio, working with our accomplice Excel in Business, have brought Enterprise class BI capacities to Excel by means of A La Carte.

·         Simple dashboards can be built from any data residing in Excel
·         Huge extent handling/pagination implies physical Excel limits and system blockage from extensive questions are a thing of past times

·         Unpredictable and predictable designing alternatives. Big Data can look great too, with very arranged reports and investigates
·         Optimised big data performance
·         Enterprise distribution

How are dashboards useful in business?

Businesses use Dashboards as:
·         Dashboards can distill far reaching information into a single page of brief results. Dashboard reports can decrease the surge of paper to a trickle.

·         With dashboards, supervisors can measure up numerous outcomes to one another. This gives the administrators a more faultless perspective of their association and more rapidly. With accepted reports, supervisors have a tendency to look at numerous truths from numerous reports gained over many days; with dashboard reports, it is all there before them.

·         Dashboards effectively can underscore ranges of execution that business managers think about the most. This is on the grounds that dashboards are to a great degree particular. It's simple for Excel clients to reinstate a diagram or table that directors no more think about with an assumption that is basically important.
What enterprise and activity does you dataset represent?
The enterprise which is assigned to our group is a Casino. The dataset represents the Casino revenues over two years (2010-2011).

What are the five questions you have asked of your dataset?

1.       On What date highest slot coin in amount was measured?
2.       What is the highest slot jackpot amount and in which slot machine game?
3.       What were the highest and lowest slot winnings in 2010 and 2011?
4.       Which months have the highest and lowest jackpot amount?
5.       Which slot zones have the highest and lowest slot payout amount?
 For each of the five questions, what are the attributes and metrics you are relating to provide you –with insight?
1.       Attributes ­-Day
Metrics – Slot Coin in
2.       Attributes – Slot Machine Game
Metrics – Slot Jackpot Amount
3.       Attributes – Year
Metrics – Slot Wins
4.       Attributes – Month
Metrics – Slot Jackpot Amount
5.       Attributes – Slot Zone
Metrics – Slot Payout Amount