1.According to county code whoch is the highest dividend before exclusion?
Attributes county FIPS code
Metrics dividend before exclusion



This graph shows that which code number has highest dividend before exclusion.category 6 is having highest wags and salaries 1338989975

2. Different county showing highest Interesr Recieved.
Attributes: county name
Metrics: Interest recieved


Above graph shows which county recieved highest interest. category 6 is reciving highest interest 68265246

3. Who gets the highest salaries and wages?
Attributes: county name
Metrics: Wages and salaries income





The above graph shows the comparison of different countries through wages and salaries of its population.


4. Which state postal code has the highest number of return?
Attributes: State postal code
Metrics: Number of returns




The above graph shows number of returns in different postal code. category 6 is having highest return i.e 30292334
5. Adjusted gross income, dividend before exclusion in different state
Attributes: State FIPS code
Metrics:  Adjusted Gross income and dividend before exclusion





The above graph shows adjusted gross income and dividend before exclusion in each country. category 6 is having highest gross income and dividends before exclusion i.e dividend 39484986 and gross income 1827239886

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