Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Usefulness of the PivotTable

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 25-11-2009
Member
 
Join Date: Nov 2009
Posts: 36
Usefulness of the PivotTable
  

As most of the details in computer, which are easy, but it takes no time in understanding my thing is that the PivotTable that I managed to apply on data:

- 3 Columns
- 35 lines

(duplicate rows)

My question is: Is the pivot table useful to display the number data by attribute:

Name: 35 John
45 Sameer
etc. ....

Reply With Quote
  #2  
Old 25-11-2009
Member
 
Join Date: Oct 2005
Posts: 2,387
Re: Usefulness of the PivotTable

It can be used among others. It is usually a group of data to be presented differently. Suppose I have a client in column A, a date in column B (the date of the invoice) and the amount in column C (the amount of the invoice) with a PivotTable, I can easily find
-how many invoices for each customer
-how many invoices for each customer per year, or month
-total purchases of that customer
-the amount of purchases of that customer by year or month
-what customers bought something during such month

all with filters that automatically added the ability to make totals and subtotals and can obtain very easily the relevant data (imagine that I filtered a particular client and a particular month in the table, If I double click in the table, he'll create a tab or it will only Show me the data)
Reply With Quote
  #3  
Old 25-11-2009
Member
 
Join Date: Nov 2009
Posts: 36
Re: Usefulness of the PivotTable

So it is one of the forefathers BI of reporting and navigation CUBE? According to Microsoft, Business Intelligence (BI) solutions can help everyone in your organization quickly access the timely, relevant, and accurate information that drives better decision making and impacts your bottom line.

Microsoft business intelligence solutions can help your organization:

- Find inefficiencies
- Save money
- Get real-time information
- Find profitable customers
- Pivot on a dime
Reply With Quote
  #4  
Old 25-11-2009
Member
 
Join Date: Oct 2005
Posts: 2,387
Re: Usefulness of the PivotTable

I do not know very well the historicity of thing but I would say it was rather builds upon a way to make small requests on a mini database than BI.

After, of course, both (TCD and BI) are ways of making requests on the database without having to dip their hands in the code but it's probably their only common point.

The BI will ask general real database, and to enable analysis of complex
The TBC will not allow duty builds upon a database to make a quick analysis of anything. It responds to the fact that not many people store data in Excel, they often have no knowledge of database, but they would like to summarize the data even when. But for example, can not easily do a join in excel, missing lots of things you would find in a true database.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Usefulness of the PivotTable"
Thread Thread Starter Forum Replies Last Post
MS Office Excel 2010: Unable to print PivotTables with non-PivotTable data at bottom of table. Girl Geek 2012 Windows Software 2 06-08-2012 07:00 PM
How to achieve Excel PivotTable in ASP.NET Sharanya Software Development 5 13-02-2010 11:01 PM
Formatting a PivotTable Chrisch Windows Software 3 05-05-2009 05:02 PM
Add RAM on a ASUS, what compatibility and usefulness? Taipai Motherboard Processor & RAM 3 08-01-2009 02:17 PM


All times are GMT +5.5. The time now is 04:05 AM.