18.00 – 18:30 Meet & Greet
18:30 - 19:20
TALK #1 (level 2) - The Modern Data Warehouse - Better, Faster, Cheaper
David Rice and Tom Bruce from Snap Analytics share their ideas on the innovations in Data Warehousing, and explain how the old adage "Fast, good or cheap. Pick two" can be broken.
They will discuss how Cloud Data Warehousing, Automated Data Pipelines and Agile Modelling are changing the equation.
The talk will include a look at Snowflake Data Warehouse (https://www.snowflake.com/).
David is the founder of Snap Analytics, a business designed to leverage modern data platforms to deliver better business insights, faster. With more than 15 years experience in data analytics - including data warehouse design, ETL (data integration) and delivering self service analytics - he’s worked with clients including ING Bank, Barclays Capital and Jaguar Land Rover. In life and in business David is inspired by his three children and believes we should all be more inquisitive and have more fun.". LinkedIn: https://www.linkedin.com/company/18507124
Tom is the Co-founder and Delivery Lead at Snap Analytics, a business designed to leverage modern data platforms to deliver better business insights, faster. He has extensive experience designing and delivering enterprise data warehouse and analytics solutions, with core functional expertise in Finance and Marketing. His previous clients include Jaguar Land Rover, Deutsche Bank and Carlsberg. A key focus for Tom is ensuring that functions across the business collaborate as a team to help foster innovation.
19.20 – 19:40 Break & Pizza
19:40 - 20:30
TALK #2 (level 1) – SQL Server Master Data Services
John Kirby takes a look at MDS in SQL Server and how it provides a robust solution for manual reference/seed master data, rather than error-prone shared network files.
If you don't know about MDS, and/or are frustrated with unreliable source files in your ETL process, this talk is for you.
MDS is a component of SQL Server 2008R2 to 2019 Developer, Enterprise and BI editions (64 bit only). It plugs in to Excel to provide data stewards a familiar, easy way to provide manual master data to the data warehouse. The data is validated and stored in a central database which your ETL can pull from.
It hasn't changed a lot along the SQL lifespan. The differences will be mentioned in the talk.
John is the organiser of the Subject Data: Bristol meetup (formerly Data Bristol). He is a Microsoft Data consultant with 8 years experience, mainly in finance, following 6 years as a web systems engineer.
20:30 - Pub
We would like to thank our generous sponsors for supporting us:
Just Eat (https://www.just-eat.co.uk/)
WHEN AND WHERE
The venue is: Just Eat, Broad Quay House, Broad Quay, Bristol BS1 4DJ. If for any reason, you cannot make it, please un-RSVP in good time.
Level 1: Introductory and overview material
Level 2: Intermediate material (background knowledge useful)
Level 3: Advanced (assumes prior subject matter knowledge)
Level 4: Expert (deep level of technical knowledge)