Excel – Large Data

Spread the love

As we know pivot table is high efficient in “data summarize” with flexibility to organize data on column and rows level , even you can filter and group your data.Below is the some uses which users must consider.

Note – Need to remember all the point of pivot table, these basics can save your lot of time to do analysis and accomplish your data plotting strategy.Because data analysis takes a lot time to organize the data.

Strategy to handle large volume data with the help of Pivot Table :-

Strategy – work with high volume data  in excel – Click on link Examples

  • Data to data ( summarize your data and choose repeat option in design tab, grouped data is prepared re-use this data for analysis or reports)
    • .set off the Grand total , total and subtotal then re-use this data
    • Actually it is excellent use if data is large, you can avoid the waiting time of slow calculation formulas.
  • Pivot summary to pivot summary for high efficiency use (Dynamic Range/Pivot).
    • You need to set dynamic range for raw data as well as for pivot table, you will have to use two and more pivot table.Each table’s source will be last table summary.
    • Need to refresh pivot table with sequence for final output
  • Try to avoid use of array function if data set is large, you can use these function after grouping the data so excel will keep working smoothly.

Pivot Table specialty

 

Advance Pivot Table – Click here for Example 

  • Attribute grouping options to create a group in row label and column label
  • Attribute grouping options to create a group in row label and column label
  • Data grouping
  • Data crunching and number crunching just on your finger tips.
  • Quick add total , sub total and grand total on rows and columns
  • Slice and Dice options ( quick filter option in data tab)
  • Aggregate values options – Sum , count, Max,Average, min, var (variance) ,varp, std (standard deviation), stdp
  • Flexibility to add % on parent group data (Row wise and column wise) , option to add running total , ranking , difference and index ( parent row % feature add in Excel 2010 ).
  • Error hide option or show as 0 or Blank
  • Merge cells option
  • Drill Down / up functionality ( click on row label – use hot keys – Alt+J+T+P/X )
  • Calculated field options ( quick option to do calculation basis on columns) without affecting to raw data,
  • Attribute calculate option (when click on field name then it appears just down to the Calculated field option)
  • Option to present data – Tabular , Classic and Outline form.
  • You can add chart with it
  • Relationship model added – multi dimension pivot ( feature added in 2013 , office 365) , need to relate a primary in each table / data set
    • It is same as  join functionality in SQL
  • You can use directly – server data source to pivot table ( option in data tab)
  • Report filter option at every field
  • Top and Bottom values selection basis on values
  • Option change data integer form to Cumulative %.

Comments

  1. Free Online Classifieds

    Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically tweet my newest twitter updates. I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would have some experience with something like this. Please let me know if you run into anything. I truly enjoy reading your blog and I look forward to your new updates.

    Take a look at my web blog: http://www.ukclassads.com

  2. loshi

    Link exchange is nothing else however it is only placing the other person’s blog link on your
    page at proper place and other person will also do similar in favor of
    you.