Awesome Microsoft Business Intelligence Resources
The purpose of Business Intelligence is to support better decision making.
- Official Websites
- BI Heroes at YouTube
- Blogs
- Groups and Communities
- Summits and Conferences
- Essential Concepts
- Big Data
- Parallel Data Warehouse
- Enterprise Data Warehouse (EDW)
- Enterprise Information Management (EIM))
- Business Intelligence Semantic Model (BISM)
- BI Tools and Utilities
- Sample Databases and Datasets
- The Beauty of Data
- Data Security and Protection
- Exams and Certificates
- Third-party Resources
- Data Platform - Microsoft
- Search product lifecycle
- SQL Server Video Archive
- Microsoft White Papers
- SQL Server Customer Advisory Team (SQLCAT)
sorted alphabetically ❤️
- Big Data Analytics with HDInsight: Hadoop on Azure - ~5 hours
- Statistics for Data Science (Beginner) ~8 hour
- SQL Server BI - Paul Turley
- Microsoft SQL Server Versions List - This unofficial build chart lists all of the known Service Packs (SP), Cumulative Updates (CU), patches, hotfixes and other builds of MS SQL Server.
- What is business intelligence? Transforming data into business insights - cio.com
- Business intelligence: A complete overview - tableau.com
- Glossary
- Business Intelligence Maturity Model
- Data governance and the death of schema on read
- What’s Your Data Strategy? (June 2017) - by Leandro DalleMule and Thomas H. Davenport
- What is an Entity Relationship Diagram (ERD)? - lucidchart.com
- Crow’s Foot Notation - vertabelo.com
- Lucidchart - lucid.app
- SqlDBM - sqldbm.com
- Nine Laws of Data Mining - Tom Khabaza
- CRISP-DM - Cross-Industry Standard Process for Data Mining
- CRISP-DM 1.0 (PDF) - Step-by-step data mining guide
- What is CRISP DM?
- The Four Stages of the Data Maturity Model - A trusting partnership between IT and the business builds data maturity and accelerates the journey from data to decision.
- Self-service BI best practices: 5 dos and don'ts - Mekhala Roy (August 2017)
- Self-Service BI (Qlik) - qlik.com
- Parallel Data Warehouse components - Microsoft
- Are you building a BI house of cards? (July 2019) - Matthew Roche
- Data Warehouse Guide - panoply.io
- What is BI architecture? - itransition.com | Business intelligence (BI) architecture is the infrastructure a company deploys to support all the stages of the BI process
- Star Schema - In the data warehouse database, data is arranged into hierarchal groups called dimensions and into facts and aggregate facts. The combination of facts and dimensions is called a star schema.
- Additive
- Semi-additive
- Non-additive
- Transaction Fact Table
- Snapshot Fact Table
- Accumulated Fact Sheet
- Fact less Facts
Enterprise Information Management (EIM) can best be defined as a set of technologies, processes, disciplines and practices used to manage an organization’s data and content as an enterprise asset. Managing information in an enterprise typically involves integrating data from across the enterprise and beyond, cleansing the data, matching the data to remove any duplicates, standardizing the data, enriching the data, making the data conform to legal and compliance requirements, and then storing the data in a centralized location with all the necessary security settings.
- Enterprise Information Management (EIM): Bringing Together SSIS, DQS, and MDS (Video) - Matthew Roche (Channel9)
- Enterprise Information Management - University of Washington
- The Hidden Secret to Peak Business Performance (Whitepaper) - Vincent Lam and JT Taylor (University of Missouri)
- SSIS - SQL Server Integration Services - Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.
- We Loaded 1TB in 30 Minutes with SSIS, and So Can You - Len Wyatt, Tim Shea, David Powell (March 2009)
- Videos
- Installation
- Master Data Services – The Basics - Hari Yadav (Red Gate)
- Master Data Management (MDM) Using SQL Server - Hari Yadav (Red Gate)
- Master Data Services Add-in for Microsoft Excel
- Videos
- Installation
- Install Data Quality Services - Microsoft
- Introduction to Data Quality Services - Microsoft
- Videos
- What is Semantic Layer? - A semantic layer acts as an intermediary between the business user and corporate data. Data is represented as objects named as common business terms for business users to navigate. This allows business users to work with corporate data without needing to know all the finer technical details. Many reporting tools use a semantic layer to allow business users to create their own ad hoc reports
- Making Sense of the Semantic Layer
- Understanding the SQL Server 2012 BI Semantic Model (BISM)
- Analysis Services What is the Difference between Tabular and Multidimensional Models
- Optimizing multi-billion row tables in Tabular - SQLBI
- DirectQuery in Analysis Services - Best practices, performance, use cases - DirectQuery is a feature of Analysis Services that transforms a Tabular model in a semantic layer on top of a relational database, transforming any MDX or DAX query in a real-time request to the underlying relational engine using the SQL language.
- Analysis Services tutorials - Microsoft
- SqlQueryStress
- SQL-Load-Generator
- SSASDiag - Collect and analyse information to troubleshoot on-premises SSAS issues.
- Tabular Editor - A lightweight editor for SSAS Tabular Models built in .NET/WinForms
- BISM Normalizer
- How the Recession Reshaped the Economy, in 255 Charts - Jermy Ashkenas and Alicia parlapiano
- Information is Beautiful
- Cyber Security Hub - Data - Data misuse or mismanagement is a top cause of today's breaches. Cyber Security Hub regularly touches upon data-driven stories
- World's Biggest Data Breaches & Hacks - informationisbeautiful.net
- Querying Data with Transact-SQL (70-761)
- Developing SQL Databases (70-762)
- Administering a SQL Database Infrastructure (70-764)
- Provisioning SQL Databases (70-765)
- Implementing a Data Warehouse using SQL (70-767)
- Developing SQL Data Models (70-768)
- MCSA: SQL Server 2012/2014
- MCSA: SQL 2016 Database Administration
- MCSA: SQL 2016 Database Development
- MCSA: BI Reporting
- MCSA: SQL 2016 BI Development
- MCSE: Data Management and Analytics
- Presto - Distributed SQL Query Engine for Big Data - Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.