Results 1 to 4 of 4

Thread: Usefulness of the PivotTable

  1. #1
    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. ....

  2. #2
    Join Date
    Oct 2005
    Posts
    2,394

    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)

  3. #3
    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

  4. #4
    Join Date
    Oct 2005
    Posts
    2,394

    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.

Similar Threads

  1. Replies: 2
    Last Post: 06-08-2012, 07:00 PM
  2. How to achieve Excel PivotTable in ASP.NET
    By Sharanya in forum Software Development
    Replies: 5
    Last Post: 13-02-2010, 11:01 PM
  3. Formatting a PivotTable
    By Chrisch in forum Windows Software
    Replies: 3
    Last Post: 05-05-2009, 05:02 PM
  4. Add RAM on a ASUS, what compatibility and usefulness?
    By Taipai in forum Motherboard Processor & RAM
    Replies: 3
    Last Post: 08-01-2009, 02:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •