Q #1: What is the trend of cash inflow of each seat type over the years from 2009 to 2090?
Here in these dashboards, I analysed the pattern of cash inflow through various types of contributions and receipts, for each type of seat as well as party affiliations in different states. In these graphs I read the following figures:
Total Cash Inflow of Incumbent Seats was the highest i.e. $1,680,060,233/-
Total Cash Inflow of Challenger Seats was the second highest i.e. $911,595,331/-
Total Cash Inflow of Open Seats was the third highest i.e. $816,630,743/-
The term dashboard originates from the automobile dashboard
where drivers monitor the major functions at a glance via the instrument
cluster. Dashboards give signs about a business letting you know something is
wrong or something is right. The corporate world has tried for years to come up
with a solution that would tell them if their business needed maintenance or if
the temperature of their business was running above normal. So for businesses,
we can define dashboard as:
“A dashboard is a
visual display of the most important information needed to achieve one or more
objectives which fits entirely on a single computer screen so it can be monitored
at a glance.”
What is the Role of Dashboards in Business Intelligence?
Dashboard is an essential constituent of business
intelligence (BI). A dashboard is one of the vital ways that data is
represented visually. Dashboards show key performance indicators (KPIs) in one
place, so that you can see the trends, patterns and relationships that define
your business. A KPI can be visualized as a simple number, chart, meter, map or
other type of visual that shows you your situation of choice.
How can Dashboard help with Big Data?
There are zettabytes of data in the world today, and
companies are drowning in information. A dashboard places the data the
companies need in a visual, easy-to-understand format. The ability to see the
data that you need, when you need it, gives you the ability to quickly
understand your company’s situation at any given point in time. Rather than
digging through emails and Excel spreadsheet, you can consult your dashboard
for a quick insight.
How is Dashboard Useful in Business?
By using a dashboard, you can more easily process the
meaning of the information your BI system is giving you, and make better
decisions as a result. Everyone from the CEO to middle managers can use
dashboards to see information when they need it. As a result, these workers can
make changes in real time, rather than using guesswork or monthly reports.
Dashboards may be used by different users; such as
front-line workers to monitor inventory, by middle managers to analyze lagging
measures, and by executive managers to evaluate strategic performance against
objectives. So we can say that Dashboards in combination of visual and
functional features help improve understanding, awareness, and interpretation
of big business data.
Dataset
- “Campaign Finance Data”
Our dataset represents the raw information about
the finances of political parties of USA in relation to their election
campaign. The dataset includes candidates’ names; their parties’ affiliations
i.e. Democratic or Republic; their seats i.e. open, incumbent, or challenger;
their cities and states. It also tells us about various financial contributions,
loans/debt, expenditures, refunds, other disbursement, and cash on hand
position of parties’ committees; from 2004 to 2010.
Analytical
Questions on "Campaign Finance Dataset" along with the Attributes and
Metrics for each question:
NO.
QUESTIONS
ATTRIBUTES
METRICS
1.
What is the trend of cash
inflow for each type of seat over the years from 2009 to 2090?
Candidate Incumbent Challenger Open Seat
Total Contribution
Other Receipts
Coverage End Date
2.
What is the cash outflow
pattern of each party over the years from 2004 to 2010?
Candidate Party Affiliation
Operating Expenditure
Individual Refund
Total Contribution Refund
Other Disbursement
Coverage Start Date
Coverage end Date
3.
How will the financial
soundness be compared of each party, across all the states, every year?
Candidate Party Affiliation
Candidate State
(Total) Cash on Hand Beginning of Period
(Total) Cash on Hand Closing of Period
Debt Owed by Committee
Coverage Start Date
Coverage End Date
4.
What is the candidates’
total contribution of each party, across different cities of every state,
depending on seat type, each year?
Candidate Party Affiliation
Candidate Seat
Candidate City
Candidate State
(Total) Candidate Contributions
Coverage Start Date
Coverage End Date
5.
What is the total number
of candidates in both parties, for each type of seat, in each city of every
state?
