WHAT IS DASHBOARD?

A database is an organised collection of data. The data are typically organised to model relevant  aspects of reality (for example, the availability of rooms in a hotel), in a way that supports processes requiring this information ( for example, finding a hotel with vacancies).

ROLE OF DASHBOARD IN BUSINESS INTELLIGENCE  :-

A business intelligence dashboard is a data visualization tool that displays the current status of metrics and key performance indicators (KPIs) for an enterprise. Dashboards consolidate and arrange numbers, metrics and sometimes performance scorecards on a single screen. They may be tailored for a specific role and display metrics targeted 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.Oracle and Microsoft are among the vendors of business intelligence dashboards. BI dashboards can also be created through other business applications, such as Excel. Business intelligence dashboards are sometimes referred to as enterprise dashboards.The business intelligence dashboard is often confused with the performance scorecard. The main difference between the two, traditionally, is that a business intelligence dashboard, like the dashboard of a car, indicates the status at a specific point in time. A scorecard, on the other hand, displays progress over time towards specific goals. Dashboard and scorecard designs are increasingly converging. For example, some commercial dashboard products also include the ability to track progress towards a goal. A product combining elements of both dashboards and scorecards is sometimes referred to as a scoreboard.


HOW CAN  DASHBOARD HELP WITH BIG DATA ?

Dashboards are one of the most popular BI tools, representing a front-end access point to more meaningful analysis and business visibility. But they are just one aspect and many organizations overlook the data requirements needed for any successful BI solution. Requirements include consolidating multiple data sources, maintaining a centralized data warehouse, and managing data quality over time. These contribute to creating an environment that can support end-user service level agreements (SLAs). This is a complicated and time-consuming process, but the reward is great in the end.Organizations that maintain a strong data infrastructure can plan more effectively, track their products through the supply chain, and manage relationships with their sales channels to proactively identify opportunities or potential problems. Dashboards and the application of data visualization techniques provide easy access to business information, which is derived from large volumes of data. But BI tools including dashboards without this data layer have limited value to companies.

HOW ARE DASHBOARDS USEFUL IN BUSINESS?

Business managers and owners use a number of different tools to track their progress and determine how well the business is performing. The business dashboard is one of these tools that provides a snapshot of most of the important numbers needed to conduct effective business analysis. Dashboards can be used in all levels of business management but are typically most important to higher level managers who need a quick glimpse at how the company is performing.

Questions 

 1.       Show the different state fipe code and the adjusted gross income, dividend before exclusion in each state?

2.       Name the different country showing the maximum interest received?

3.       Which of the state postal code has the highest no. of return?

4.       Show the wages and salary of the different country fip codes?
5. According to county code which is the highest divident before exclusion?

By  :-

        

        Chanvir Singh Cheema

        Rupinder Singh Bajwa
        Gurpreet Singh Deol

        Sukhpreet Singh

         Vishesh Gupta