locked
power bi vs dw design. RRS feed

  • Question

  • Hi experts,

    I recently started using power BI...

    and I was wondering, isn't  power bi capabilities, and all in-memory technologies going to eventually kill the classic Data Warehouse Design?

    Isn't it more productive spending time in power bi, rather than in sql server creating the perfect design?

    Friday, May 25, 2018 10:29 AM

Answers

  • No, really , it does not kill at all. Use SQL Server database model/design and load it into a power bi. 

    In my opinion you shouldn't compare power bi and data warehouse. Data warehouse is an enterprise need that will store current and historical data for the enterprise while power bi is a visualization tool. You use power bi for visualizing, analyzing your data and share it with business users.
    However for smaller datasets, Power BI could theoretically be used as a data mart or data warehouse. The data model behind it is SQL Server Tabular after all, so the same basic technology that is in SQL Server Analysis Services.


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Marked as answer by maca128 Tuesday, May 29, 2018 1:25 PM
    Sunday, May 27, 2018 5:10 AM

All replies

  • No, really , it does not kill at all. Use SQL Server database model/design and load it into a power bi. 

    In my opinion you shouldn't compare power bi and data warehouse. Data warehouse is an enterprise need that will store current and historical data for the enterprise while power bi is a visualization tool. You use power bi for visualizing, analyzing your data and share it with business users.
    However for smaller datasets, Power BI could theoretically be used as a data mart or data warehouse. The data model behind it is SQL Server Tabular after all, so the same basic technology that is in SQL Server Analysis Services.


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    • Marked as answer by maca128 Tuesday, May 29, 2018 1:25 PM
    Sunday, May 27, 2018 5:10 AM
  • Hi maca128,

    Power BI and Data Warehouse are complementary. Essentially Data Warehouse is a storage database, and Power BI is a data visualizing tool. Power BI can work well with lots of data sources including Data Warehouse.

    Here are two relevant threads, which made a good discussion about this topic. I think you can find what you need in them.

    http://community.powerbi.com/t5/Desktop/Power-Bi-vs-Data-Warehouse/td-p/78205

    http://community.powerbi.com/t5/Desktop/Power-BI-vs-Data-Warehouse/td-p/125802

    Thanks,
    Xi Jin.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, May 28, 2018 7:19 AM