MS BI
作者:Timo Riikonen
1. SSAS
1.1. Tabular
1.2. Interdimensional
2. SSDT
3. SSRS
4. SSIS
5. Power Query
5.1. Privacy and security
5.2. Tables
5.2.1. Filtering
5.2.1.1. Reading and filtering XML
5.2.2. Columns
5.2.2.1. Automated changes to column headers
5.2.2.2. Automated data /column type detection
5.2.2.3. Renaming columns using a table
5.3. GUI and graphs
5.4. Import, reading content
5.4.1. SQL Import
5.5. Automation, monitoring, emails
5.6. Programming
5.7. AI, ML and translations
5.8. Localization, time zones
5.9. Errors, debugging
5.10. Performance
5.11. Power Query - Excel
5.11.1. Using cube functions in Excel with dynamic data
5.11.2. Combine several Excel tabs as one
6. MS Power BI
6.1. Desktop
6.2. Server
7. Excel
7.1. Installation
7.1.1. Dev
7.1.2. Clients