CANDIDATES INFORMATION-GURINDER BENIPAL

TOTAL NO OF CANDIDATES-3478.IN THIS GRAPH VERTICAL LINE SHOWS THE NAME OF CANDIDATES PER STATE PER CITY

Work done by Ramninder hans

In this i choose  debt owned committee, Cash on the opening of period and cash on the closing of the period.

 

 In 2009 the highest debt owned committee by 9637961.32 by REP party in NY.
The  highest (Total) Cash on Hand Beginning of Period in 2009 is 18195223.34 by REP in AL.
THE highest  (Total) Cash on Hand end of Period in 2009 is1990367.24 by the DEM IN NY.

Total cash outflow by AMANDEEP HANS

chart1

In this chart Candidate total contribution up to 2009 peaks at the 3495.00

                                             
                                                             CHART 2

In this i choose operating expenses, other disbursement and Total contribution refund value.

In 2009 operating expenses were 6241334.36 which increase to 1634396162.93 in 2010.

The total refund value in 2010 is 24547251.56 and 10661029.07 for other disbursement.

So. from the data it is analyzed that cash outflow is maximum for operating expenditure followed by other disbursements and then contribution for refunds.

Data Visualization

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/-

By Anbreen Naz

Introduction to Dashboards

What is Dashboard?

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?	Candidate Name Candidate Party Affiliation Candidate Seat Candidate City Candidate State	Total Number of Candidates