HomeAzure Analysis ServicesThe need for having both a DW and cubes

Comments

The need for having both a DW and cubes — 10 Comments

  1. Pingback:#BI101: The need for having both a DW and cubes – Welcome to Ray Kim's 'blog

  2. Hi James, what would be the limitations of using normal Azure SQL (obviously without polybase) instead of DW?

    DW isn’t cost effective for smaller orgs.

    • Hi Simon,

      If you database is “small” (under 4TB) and you don’t need the power of a MPP solution, then go with Azure SQL Database. And with Managed Instance in public preview and near 100% SQL compatibility, it’s a great option with it’s biggest limitation is that SQL DW can be 20x-50x times faster.

      • Awesome, done! Preview request is pending.

        Azure SQL Database Managed Instance looks like it on parity with SQL Server 2017 but, once again, it excludes Polybase! Why does MS keep excluding it?

        They should just replace polybase with Power Query imho. It can federate equally to Hadoop, plus do a million more things.

  3. James, I’d like to see more exploration into the use of ROLAP, now that the backend databases are getting more sophisticated/faster. If your onsite DW can be supported using SSD drives, ROLAP may offer a faster SSAS cube build out, with only a single data update to the DW. Or online via Azure SQL data warehouse, with MPP, that may offer a great alternative. That provides both a traditional DW with a rapid SSAS build out. And I am thinking multi-dimensional, not tabular. I may be that last holdout, but multi-dimensional still seems far superior when the business needs get complex.

    • Hi Raghu,

      Those reasons where in the blog under “Why have a data warehouse if you can just use a cube?”. And I’ll add that if you are going against ADL, you will need to make sure the data is cleaned and transformed in the data lake before pushing it to a cube.

  4. Thanks for a great commentary. I now have a second source for some of the comments I have been espousing at work. Great graphic!! It clarifies a lot for many.
    colleagues.

  5. Pingback:Power BI: Dataflows | James Serra's Blog

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>