group member names-

• riya puri
• shreya malik
• duy bui
• jaspreet singh

INCOME TAX DATA
MISSION STATEMENT- our data set represents gross income an dividend before exclusion of east , west ,north and south. metrics are number of returns, number of exemptions, adjusted gross income, wages and salaries income, dividend before exclusion, interest received. Attributes are region, country code, postal code, country names.
POST #1

What is a dashboard?

Dashboard is a business tool that helps track metrics, key performance indicators (KPI) and other data points which may be significant to a specific department or its procedure. It is a tool that helps provide update and a visual cognizance with the aid of data visualizations to its users.

What is the role of dashboards in business intelligence?

In order to understand the role of dashboards in business intelligence one must first understand what business intelligence is. Business intelligence has 3 crucial influences; Information, knowledge and data. What business intelligence does is it helps convert data into information for its user and then further convert the information into knowledge for better understanding of the business. Business intelligence helps a company’s performance by collecting data, applying that data into knowledge which helps operate and analyze the business further.

The role of dashboard in business intelligence is significant. Dashboard and business intelligence depend on each other to obtain the results of analyzing data and make good use of it. In order for business intelligence to exist, the use of dashboard is necessary to track the metrics which is used as data by business intelligence and further converted into information and knowledge. They have a very co-dependent role in the business sector. Without the dashboard we would just have many separate tools trying to make sense of the data which might not fully be efficiently used with business intelligence hence extracting the right data for the business intelligence model harder. All in all Dashboard is the most important tool for business intelligence.

How can dashboards help with Big Data?

Dashboards have the ability to save and process large number of data for years in order to be used later. With big businesses these days there is a need to store large amount of data over the years and be processed with time so it can be available whenever needed in the future. For those purposes stronger and bigger dashboards are introduced. Dashboards help with the proliferation of data which in return makes tracking and visualize data easier for big companies to identify outlives or trends.

How are dashboards useful in business?

Dashboards in businesses are almost like dashboard on a car. It helps you identify key things about your car. Diferent gauges provide you with different indicators. Dashboard in business has a very similar role. Business owners and other managing parties like to use different tools to determine progress within the company and also to regulate business act. Dashboard is one of those important tools that help them keep track of such metrics and data all in one place. So the business dashboard helps identify key performance indictors which are used by owners or higher level managers to track profitability and success of the business. It can also make them aware about the failure within the business and specifically department wise. Dashboard can be used as forecast machine to predict the route the company is taking in its upcoming future. It helps keep business in check and make possible changes to avoid failures in the future. It is one of the most important tools of business intelligence. Dashboards depending on the business need can be customized to meet individual needs of every business. They help owners and managers run their company with minimum risk with future forecasts and the comfort of having all their data sorted in one place for them to make sense of it.

POST#2

question#1 Which city has the highest total gross income of the graph and its profit? What is the difference between Adventure and Action profit sales in Boston? Are there any significant changes if Walt Disney is not on the list?

a. Boston, 620 869 475 $

b. 304 722 611 $

c. Yes. Drama would increase and adventure will decrease drastically.

question#2. Which region has the highest profit income and which has the lowest? State the percentage difference between the two regions. What is the total percentage CA contributed to the country?

a. North Region has the lowest and South region has the highest.

b. 18.74% difference

c. 6.11% contribution

question#3. What is the average income of California? What percentage of tax did they contribute to the country? If California has 50% lower income, will it make a significant change towards the whole country?

a. 1 827 239 886.00

b. 43.60%

c. Yes, because they already contributed 43.60% towards the whole country

question#4.Is the change in dividends before exclusion rapid or slow?When is the adjusted gross income minimum and maximum?

A)The change in dividends before exclusion is rapid. As we can see the sharp fall in North and a following steep increase.

B)Minimum = North = 1,000,000,000.00

Maximum = South = 5,000,000,000.00 – 6,000,000,000.00

question#5 what are the values of dividend before exclusion and added gross income in east, north, south and west?

a) dividend before exclusion-    

EAST-93,194,037.00

NORTH-22,413,883.00(lowest)

SOUTH-111,788,641.00(highest)

WEST-85,350,145.00

b) added gross income-

EAST-4,190,585,170.00

NORTH-1,034,315,006.00(lowest)

SOUTH-5,520,720,966.00(highest)

WEST-3,708,075,670.00