Vincent is a data warehouse & BI architect, specialising in SQL Server, MSBI, banking and asset management. He wrote a book
on SQL Server data warehousing & BI, and many articles on www.datawarehouse.org.uk
Vincent Rainardi has submitted 7 sessions for SQLBits XV, although the agenda hasn't been chosen yet. See all submitted sessions
In this session I will be doing a demo on my article "Populating a Fact Table using SSIS": https://dwbi1.wordpress.com/2012/05/26/how-to-populate-a-fact-table-using-ssis-part1/
by going through it step by step on the screen.
A demo of 3 approaches for testing SQL Server-based data warehouses: using manual comparison, using Excel and using SSIS - SQL Server - SSAS
The principles in indexing fact tables, applicable specifically to SQL Server data warehouses
A data warehouse is not only for BI. It can also be used from Customer Relationship Management (CRM). In fact, a DW is the best platform for doing CRM. I will show how to use a SQL Server data warehouse for doing core CRM activities.
BPM = Business Performance Management. A Data Warehouse is not only used for BI. It is also used for CRM and BPM. In this session I will show how to use a Data Warehouse for BPM using Balanced Scorecard.
We can load a dimension table in SSIS using a) SCD Transformation, b) Merge Join + Conditional Split, c) Change Data Capture, d) Merge command, and e) Upsert using Execute SQL. In this session I will be showing these 5 approaches and compare them.
A refresher session on T-SQL basics covering a) creating database objects, b) database development, c) database administration; based on my article: https://dwbi1.wordpress.com/2014/12/27/sql-server-scripts/
Designing dimensional and fact tables using a case study to understand data modelling
A step-by-step demo on BIDS of how to build an SSAS cube (DB) from an operational system (normalized database) such as Operational Data Store (ODS) or directly from the transactional business system, without building a star/snowflake schema Data Warehouse/Mart first.
Many of us know what dimensions and fact tables are. But dimensional modelling is more than just dimensions and fact tables. This session is about advanced dimensional modelling topics, which are useful for anybody involved in the design of a DW.