Saturday, April 11, 2015

Bookstore Dashboard

Bookstore Dashboard 

Q1: Which supplier has the most revenue?

*Attribute: Supplier.             *Metric: Revenue.

 Based on graph 1 the supplier with the highest revenue is Virgin Records with  $16,249,975
Q2: which book category had the most revenue?

*Attribute: Book category.    *Metric: Revenue.

     Based on graph 2, Action Movies has the highest revenue recorded $15,897,317
Q3: Which book is most expensive?

*Attribute: Book category.     *Metric: Unit price.

      According to graph 3, Comedy Movies are the most expensive recorded at $61,798.30
Q4: Which city sold most books?

*Attribute: City.                      *Metric: Unit sold.

 According to graph 4, New York city has the most unit sold recorded 574,392 
Q5: In which month(s) is the bookstore showing high productivity?

*Attribute: Month.                   Metric: Revenue.


     Based on graph 5, December has the highest revenue recorded at $23,545,674


Friday, April 3, 2015

Dashboards. Data, metrics for Bookstore.

What is Dashboard and the role of it in Business intelligence


Dashboard is a business intelligence tool that provide visual presentation for the current status of metrics and the performance indicators for an enterprise. The main benefit of dashboard use is to arrange metrics and sometimes score performance in one single monitor. By the use of dashboards, users can access a real time data from multiple sources. Dashboards are software products that helps to support business intelligence process and it could be customized depends on the need. It is not an easy steps that require to gather all the data needed from various departments, therefore, dashboard became the best solution to transform BI process. 

How can dashboard help with big data?
  1. Helps to simplify the data sets. For examples CEOs may face difficulties in understanding the row data that are received from customers, market research survey, and finance data. However, dashboard will make it simple and easy to analyse by gathering all the data and show them in graph.
  2. Dashboard can provide an easy access to useful information that is available online and social media website without reviewing each site manually and is considered as a method that dashboard could help to reduce time consuming.
  3. Dashboard has the ability of managing the data and turn it into graphical presentation rather than going through all details which it could be not useful and waste of time.
  4. When managers make decisions, they need to be aware of every single activity and that fact might take time to look for necessary data.
  5. By the use of dashboard, you can track and compare market research studies visually without going back to the official reports which probably could take a while, also some of those data could be lost. 




How could the dashboard be useful to business?


  •          Recognize negative trends:

      By analyzing dashboard graphs, managers will be able to find out about the       business weaknesses and work on maintaining the negative trends
  •       Correct the negative trends:

By the use of dashboard, managers will be able to identify, locate, and analyse negative trends and improve the business overall performance
  •       Improve efficiency:

Dashboards has the ability to collect data that could be helpful to take future  investments and improve company capital
  •      Measure the company performance:

By the use of dashboards, managers can apply deep analysis which helps the to  take acts against inefficient productivity
  •       Determine the company objectives and strategy:

When using dashboards, managers can determine the future decisions and track  the company condition.
  •       Dashboard improve employees productivity:

Managers will be able to identify employees with poor performance when using  dashboards quickly and then work on increasing it before it becomes too late.
  •      Dashboard could save employees time:

The use of dashboard eliminate reports, since reports reduce companies’  time  and money. 

The Data and Questions for a Bookstore


Q1: Which supplier has the most revenue?

*Attribute: Supplier.             *Metric: Revenue.

Q2: which book category had the most revenue?

*Attribute: Book category.    *Metric: Revenue.

Q3: Which book is most expensive?

*Attribute: Book category.     *Metric: Unit price.

Q4: Which city sold most books?

*Attribute: City.                      *Metric: Unit sold.

Q5: In which month(s) is the bookstore showing high productivity?

*Attribute: Month.                   Metric: Revenue.
The following video will give you a better understanding on what are dashboards and how does it work: