SQL Server BI (Microsoft BI)

https://trello.com/b/Xh5GF6kY/microsoft-bi

• Microsoft Business Intelligence – our reporting roadmap

• ​Microsoft Business Intelligence edureka:

  • Playlist

  • Slide

• Power BI vs SSRS

• SSIS (SQL Server Integration Services)

• ODS (Operational Data, DW, OLTP)->ETL->RDBMS->OLAP CUBE->Report

  • Operational data: Something that loaded everyday

  • What is ETL

  • Database vs Data Warehouse

  • OLTP vs. OLAP

  • Gartner Magic Quadrant for Data Integration Tools

• 5 Differences between Cloud and Dedicated Servers