Excel VBA Tools from Andrew
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Methodology Choice for Building Pivot Tables with PowerPivot

  1. #1
    New Member
    Join Date
    Mar 2011
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Methodology Choice for Building Pivot Tables with PowerPivot


    Methodology Choice for Building Pivot Tables with PowerPivot
    I have a report with 4 data tables that I have included in the data model. There are a few other Reference tables to map the data tables together. The data tables are about 100 columns (in total) of data and another 25 Columns (in total) of logical and reference formulas.

    What are the pros and cons of rebuilding the report with all the formulas in the data model rather than the worksheets?

    questions that come to mind:
    Will the report use less memory?
    Will it calculate faster?

    thanks a bunch

  2. #2
    Board Regular
    Join Date
    Apr 2015
    Posts
    345
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Methodology Choice for Building Pivot Tables with PowerPivot

    https://exceleratorbi.com.au/calcula...-measures-dax/

    Assuming you are using measures and not calculated columns then power pivot will be faster for sure. How materially depends on the calc and type of data.

    Can you improve your schema at all over not a better star schema?

  3. #3
    New Member
    Join Date
    Mar 2011
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Methodology Choice for Building Pivot Tables with PowerPivot

    Thanks for your feedback, gazpage.
    This particular project is now going in another direction, so I won't be immediately applying your tips.
    I will be looking deeper into the resource that you provided for future use.

    thanks again.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

DMCA.com