HomeBig DataHow an MPP appliance solution can improve your future

Comments

How an MPP appliance solution can improve your future — 4 Comments

  1. Remember that old saying: “pay me know or pay me later”!

    Should be “now” not “know” 🙂 (reminds me of the joke where the neighbor is apologizing profusely for using my wife (where his auto-correct keeps replacing wifi 🙂

    How does PowerBI make use of the MPP environment?

    Rob

  2. Thanks for the catch Rob, I have corrected my misspelling. The various Power BI products will make use of the MPP environment. For example, using Power View the SQL query it runs behind the scenes will run on the APS so it uses the power of the MPP appliance, with the results of the query returned to Power View.

  3. Hi James,

    Thanks for all the good stuff you’ve been publishing. Quick question about your “band aid” comment – do you really see a star schema that way? Do you see customers doing less dimensional modeling even for traditional datasets?

    Thanks!
    Melissa

    P.S. I think you need a girl on your Favorite Blogs list. Hint hint.

    • Hi Melissa!

      The two biggest benefits of a star schema are 1) performance, 2) provide an abstract layer for self-service reporting. Benefit #1 goes away with a MPP solution, but benefit #2 can still be very helpful, so I still see a lot of customers doing dimensional modeling. One negative is that you have to have another copy of the data and create/maintain additional ETL, but it is almost always worth it.

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>