SQLSaturday #281 - Edinburgh - BI Edition 2014

Event Date: 06/14/2014 00:00:00

Event Location:

University of Edinburgh
18 Holyrood Park Road
Edinburgh, , United Kingdom

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: Keynote and Introduction: SQL Server 2014 and BI overview

Abstract: We are entering a time of a paradigm shift in the world of data platform and business intelligence. As data platform technologists and community members, we are at the heart of this opportunity. Come hear how Azure, Power BI, SQL 2014 are just the front of a wave of technologies that are going to change how we design, build and manage a new world of solutions. A graduate of the University of Glasgow and the University of Aberdeen, and the key organiser of SQLSaturday Edinburgh, Jen has nearly twenty years experience delivering artificial intelligence and business intelligence solutions. Jen has been through a number of industry changes, and is excited to be a part of the most recent one moving to the cloud. This session will help to orient you for the rest of SQLSaturday Edinburgh, and we hope you enjoy your day.

Speaker(s):

Jen Stirrup

Track and Room: Microsoft SQL Server 2014 Applied - N/A

Title: A One Hour Data Analysts Toolkit: using R and Power View

Abstract: If you want to conduct advanced Business Intelligence development and Business Analysis, then it is useful to understand data visualisation and have R as a tool in your toolset. In this intensive one hour session, we will look at the latest suite of Microsoft Business Intelligence tools - Microsoft Power BI in conjunction with R. The demos will be implemented in both tools in an end-to-end hour long session so that delegates can see when to use each technology in order to determine ‘what to use’ and ‘when to use it’, as well as seeing where the technologies complement each other. We will visualise the data according to data visualisation principles set out by Stephen Few amongst others.

Speaker(s):

Jen Stirrup

Track and Room: Business Intelligence – Technical Track - N/A

Title: SQOOP - Taking relational data to Hadoop and back again

Abstract: SQOOP or SQL to Hadoop is a tool in the Hadoop ecosystem that lets you take your “SQL” data and put it into Hadoop or vice versa. The use cases are numerous. You can have Hadoop perform the heavy lifting using Map Reduce and then use SQOOP to take the results and put them in “SQL”. You can have Hadoop act as your Data Warehouse and use SQOOP to do your daily loads from your relational DB into Hadoop. SQOOP is a command line tool but don’t let that put you off.
This session will look at SQOOP and the plethora of options available to you on the command line. If you want to learn about SQOOP then this is the session for you.

Speaker(s):

Allan Mitchell

Track and Room: Microsoft SQL Server 2014 Applied - N/A

Title: Migrating to PDW? Lessons from the Field

Abstract: Parallel Data Warehouse (PDW) isn’t SQL Server - it’s different. It’s bigger than that. It’s a massively parallel-processing, distributed-database platform that leverages SQL Server as part of its architecture. But it has so much more to offer…

In this 1-hour session, you will learn how to “embrace the change” and accelerate your migration to the data warehouse storage engine for the Microsoft Data Platform. This session will be packed with advice and recommendations from actual customer deployments and real-world experiences. Get on board the PDW train, and transform your data warehouse with the Microsoft Big Data Analytics Appliance!

Speaker(s):

James Rowland Jones

Track and Room: Microsoft SQL Server 2014 Applied - N/A

Title: Autogenerating a process data warehouse

Abstract: In many data warehouses we model fact tables with measures based on attributes which we can count and do arithmetic upon. It is more difficult to handle fact tables with measures based on length of intervals of events happening in the source systems. So questions like “What are the typical waiting times in our order process?” are seldomly modelled in the data warehouse. Especially if the event data comes from different source systems.

In this talk I will show you how Rehfeld has overcome this difficult problem using an autogenerated datawarehouse based on metadata on the objects in the EDW/DM layers. In this approach you can autogenerate the process data warehouse if only you have the timestamps present in the EDW layer and are able to correlate them. The talk will consist of slides and demos.

Speaker(s):

Kennie Pontoppidan

Track and Room: Business Intelligence – Technical Track - N/A

Title: MDS and DQS - Beyond the TLAs to Data Quality

Abstract: Many three-letter acronyms (TLAs) adorn our database world. This session focuses on two recent additions – MDS (Master Data Services) and DQS (Data Quality Services) – explaining what the new features are and exploring how to leverage them to improve your data quality.

High data quality is fundamental to any business analytics system. In this session, we’ll begin with an overview of data quality and the latest Microsoft tools available, and then demonstrate MDS and DQS and how to use them together for continuously improving data quality. We’ll also look at how to integrate them into your existing data-quality strategies. Data quality is everyone’s responsibility – but we can still lead the way forward. Join this session to see how.

Speaker(s):

Neil Hambly

Track and Room: Business Intelligence – Technical Track - N/A

Title: Automate your SSIS development with BIML

Abstract: Ever tried to import a file with the Import/Export wizard? Or created a bunch of SSIS packages to process a data warehouse load? Then you know how much work it is to specify the metadata correctly just to create a package that actually works. Wouldn’t it be cool if you had a descriptive language which looks at your metadata and just created the packages for you? This is what BIML is all about. In this session I explain what BIML is, how it works and I’ll show you how you can generate your packages and quickly respond to changes. You can expect a demo rich session with lots of notes from the field and practical examples. This is not just for BI developers, DBA’s or SQL dev’s who need to import or export data occasionally will learn some quick and easy tricks as well.

Speaker(s):

André Kamman

Track and Room: Business Intelligence – Technical Track - N/A

Title: Optimizing BI with SQL2014 In-Memory tables

Abstract: Well - they named it SQL2014 In-Memory OLTP tables - BUT that does not mean we can’t optimize our BI solutions with this new feature.
This demo intensiv session is build around a number of hypothesis that are testet and show what we can - and cannot optimize with In-Memeory tables covering both the ETL and (R)OLAP angels of the BI process.

Speaker(s):

Rasmus Reinholdt

Track and Room: Business Intelligence – Technical Track - N/A

Title: Fusion-io: Unleashing the full performance of SQL

Abstract: Fusion-io address the data supply problem by allowing server CPU and DRAM to perform to their maximum. Now, with the advent of in-memory processing, providing the lowest latency, highest IOPS and greatest throughput has become an absolute must have in order to unleash the performance of your SQL solution. Join Fusion-io where they will discuss how their Flash memory tier can provide the highest, most consistent performance for your SQL infrastructure

Speaker(s):

Jen Stirrup

Track and Room: Business Intelligence - Business Track - N/A

Title: Basket Analysis using BI Office and Analysis Services Tabular Edition

Abstract: There are several articles available on the web showing how to perform associative analysis (or Basket Analysis or who bought what products with what!) using Analysis Services that rely on special configuration of dimensions to perform the required queries, using custom MDX to work around limitations in Microsoft’s own tool set. In this session Pyramid analytics will show how to use BI Office to easily build an adhoc Analysis Services Tabular Edition analytic data set and perform associative analysis using the unique features of BI Office.

Speaker(s):

Ian Macdonald

Track and Room: Microsoft SQL Server 2014 Applied - N/A

Title: Power View and the Cube

Abstract: Did you know that Power View is not any longer limited to getting data from Tabular models ? Now that Power View users can connect to multidimensional BI Semantic Model (Cubes) we will have a look at how to get the best out of this interactive data exploration, visualization and presentation for multidimensional models. The session we’ll present

An understanding of the Multidimensional Model Objects in Power View
How to create a Shared Report Data Source Connection to a Multidimensional Model
How to create a Power View Report with a Multidimensional Model Data Source
An visual exploration of a Multidimensional Model by using Power View

Speaker(s):

Regis Baccaro

Track and Room: Business Intelligence - Business Track - N/A

Title: Partitioning as a design pattern

Abstract: How do you design a data warehouse for the handling of management information in seven subject areas for all 98 municipalities in Denmark? Especially when there exists up to five different IT systems per field, and that the municipalities can use the systems differently. Add to this a requirement to change the business rules for each municipality, and the ability to report on one municipality, while data for another municipality is updated.

The talk is relevant for DBA’s, (BI) developers and BI architects.

Speaker(s):

Kennie Pontoppidan

Track and Room: Business Intelligence - Business Track - N/A

Title: PDW Q A

Abstract: Your questions answered by MVP, author and PDW expert James Rowland-Jones of the Big Bang Data Company

Speaker(s):

Jen Stirrup

Track and Room: Business Intelligence – Technical Track - N/A

Title: Big data. Small data. All Data.

Abstract: The shift to leveraging all your data to make fast decisions and gaining insight is becoming the new norm.

How will the latest developments and future thinking, from Hadoop to Machine Learning and beyond shape the world of analytics?

Speaker(s):

Jon Woodward

Track and Room: Microsoft SQL Server 2014 Applied - N/A

Title: Clustered Columnstore Deep Dive

Abstract: When it comes to clustered columnstore indexes, you may already understand row groups, delta stores, and compression methods, but come see how clustered columnstore indexes work with locking and blocking and when using different compression methods and techniques.We will also dive deep into Dictionaries creation and different methods for ETL processes.

Speaker(s):

Niko Neugebauer

Track and Room: Microsoft SQL Server 2014 Applied - N/A

Title: Fusion-io: A whole new level of performance

Abstract: Fusion-io will be unveiling their new product range at a gala evening on June 10th. Following on from this exciting announcement, we would like to extend an invite to hear more of the latest generation of the Fusion-io PCI-E Flash Memory tier at SQLSaturday Edinburgh

Speaker(s):

Jen Stirrup

Track and Room: Business Intelligence - Business Track - N/A

Title: Web Analytics with Microsoft BI

Abstract: Google Analytics is the most popular web analytics system. Almost every webpage, whether it’s a private blog or large e-commerce site, uses Google Analytics. This session will cover essential information about Google Analytics and its API guidelines, competitors, and most important, how you can use the data from such offerings together with your ERP, CRM, and other OLTP systems.

You will see how to load Google Analytics data using SQL Server Integration Services, for example, and merge that data with your local data. In addition, we will walk through a demonstration of important web analytics KPIs and how you can analyze them using Microsoft Business Intelligence tools.

Speaker(s):

Tillmann Eitelberg

Track and Room: Business Intelligence - Business Track - N/A

Title: Dynamic Partitioning Cubes

Abstract: In every project on Business Intelligence there comes a time when the code needs to be deplyed to the production environment. No more development, no more manual work. But what about the partitions on the cube? Do we really need to tell and learn the DBA how to handle that on a periodic plan? The answer is simple: No!

Speaker(s):

Brian Boenk

Track and Room: Business Intelligence - Business Track - N/A

Title: Case Study: Self Service BI within Manufacturing

Abstract: Jabil is a global manufacturing and supply chain management company servicing hundreds of electronics manufacturers. The manufacture of our customer products produces astounding volumes of data every day. Self Service Business Intelligence is essential for turning the data into consumable information, empowering our users to make key business decisions.

Speaker(s):

Paul Bunting

Track and Room: Microsoft SQL Server 2014 Applied - N/A

Title: The Good, Bad and Ugly of Cloud Reporting

Abstract: Microsoft Windows Azure SQL Reporting is a cloud-based reporting service for the Windows Azure Platform built on SQL Server Reporting Services technologies. SQL Reporting provides many benefits, including rapid provisioning, cost-effective scalability, high availability, reduced management overhead and secure access for viewing and managing reports. VM SSRS provides SQL Reporting service under IaaS model which will be consumed by client application or service. This SSRS is hosted on the Azure VM. This presentation compares SQL Azure reporting with IaaS VM reporting.

Speaker(s):

Mihail Mateev

Track and Room: Business Intelligence - Business Track - N/A

Title: Session Details not available

Abstract: Session Details not available

Speaker(s):

n/a n/a

Track and Room: Business Intelligence – Technical Track - N/A

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Mihail Mateev

Twitter: - mihailmateev

LinkedIn: Mihail Mateev

Contact: https://mmateev.wordpress.com/

Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.

Jen Stirrup

Twitter: - @jenstirrup

LinkedIn: Jen Stirrup

Contact: http://www.jenstirrup.com

Jen Stirrup, Microsoft Regional Director and MVP is a well-known Business Intelligence and Data Visualization expert, author, data strategist, and Master of Business Administration (MBA) student in London. Jen leads a boutique analytics consultancy, delivering strategic advice to companies large and small.

Jen has presented in Africa, India, Europe and North America. Jen has presented at Ignite, Techorama, TechEd, PASS Summit, SQLBits, and SQLSaturday events in Europe and the US. She also delivers the MAPA Azure Architects course worldwide with Microsoft team members. Jen was also featured on the Best of PASS Summit 2015 DVD as one of the top 10 speakers. Jen also was awarded PASS prestigious PASSion Award in 2012

Allan Mitchell

Twitter: - @allanSQLIS

Contact: https://onlysearch.wordpress.com/

Allan Mitchell is a SQL Server MVP and runs elastio, a small consultancy helping customers to make informed decisions about their data storage and integration. His focus is on enterprise search as well as real-time data integration.

Jen Stirrup

Twitter: - @jenstirrup

LinkedIn: Jen Stirrup

Contact: http://www.jenstirrup.com

Kennie Pontoppidan

Twitter: - @KennieNP

LinkedIn: Kennie Pontoppidan

Contact: http://www.pontop.dk/

Kennie Nybo Pontoppidan is a senior program manager in Microsoft working in the Dynamics NAV server backend team. He has worked in the dangerous field between developers, dbas, customers and project managers for many years and done his part of mistakes as a developer before that in his 15+ years in the it industry. He enjoys working with databases and really, really enjoys his daily dose of sql. Kennie has no humor.

Brian Boenk

Twitter: - @brianbonk

LinkedIn: Brian Boenk

Contact: http://www.bonk.dk

Brian is a BI consultant born in 1979, certified MCSE: BI and MCSE: Data Platform from Denmark with around 10 years experience of BI. His knowledge is broad around the whole spectrum of a BI project. Brians main interest is SSIS and cubes. The few spare hours besides work is being used on a spiritual approach to life and the familiy.

James Rowland Jones

Contact: http://www.bigbangdata.co.uk

James Rowland-Jones is a Principal Consultant for The Big Bang Data Company. His focus and passion is to architect and deliver highly scalable analytical platforms that are creative, simple, and elegant in their design. James specializes in big data warehouse solutions that leverage both SQL Server Parallel Data Warehouse and Hadoop ecosystems. James is a keen advocate for the SQL Server community; both internationally and in the UK. He currently serves on the Board of Directors for PASS.

Ian Macdonald

LinkedIn: Ian Macdonald

Contact: http://uk.linkedin.com/pub/ian-macdonald/1/381/2a1

Ian is a data wizard, who has nearly 30 years’ experience in the Enterprise Business Intelligence market. Starting in Technical Support, training and consulting with Information Builders in 1986, he subsequently developed a career in presales, product marketing and marketing , holding senior VP positions with companies such as Microsoft, Hyperion Solutions and HP. Ian has been working with Pyramid Analytics for five years, initiating their UK presence in 2011.

Jen Stirrup

Twitter: - @jenstirrup

LinkedIn: Jen Stirrup

Contact: http://www.jenstirrup.com

Niko Neugebauer

Twitter: - NikoNeugebauer

LinkedIn: Niko Neugebauer

Contact: http://www.nikoport.com

Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.

Paul Bunting

Twitter: - http://twitter.com/PaulBunting

LinkedIn: Paul Bunting

Contact: http://www.paulbunting.com/

Developer by day, developer by night, dad at all times… well a Lead Developer/Architect for Jabil production systems - working heavily with advanced BI Solutions in Manufacturing.

Jon Woodward

Twitter: - @jlwoodward

LinkedIn: Jon Woodward

Jonathan Woodward is the UK Business Lead at Microsoft focused on the Data Platform covering:

Business Intelligence
Analytics
Big Data
Data Science

n/a n/a

Tillmann Eitelberg

Twitter: - @_Tillmann

LinkedIn: Tillmann Eitelberg

Contact: http://www.ssis-components.net

Tillmann Eitelberg is CEO and co-founder of oh22information services GmbH, which specializes in data integration and data management. Tillmann is an active blogger at www.ssis-components.net, writing regularly about data quality topics and his passion: spatial data. In addition, he has published several SSIS components on Codeplex and GitHub. Tillmann is a Data Platform MVP, a board member of PASS Germany e.V., a PASS CL for the Cologne/Bonn region, and a PASS RM.

André Kamman

Contact: http://andrekamman.com

André is a freelance SQL Server specialist. In previous roles he’s done a lot of DBA work on 100’s of servers where he discovered his love for Powershell and automating processes in general. Today the better part of his day he’s building and tuning ETL processes. André is a SQL Server MPV, Dutch PASS Chapter Leader and organiser of SQL Rally Amsterdam and SQLSaturday Holland

Jen Stirrup

Twitter: - @jenstirrup

LinkedIn: Jen Stirrup

Contact: http://www.jenstirrup.com

Kennie Pontoppidan

Twitter: - @KennieNP

LinkedIn: Kennie Pontoppidan

Contact: http://www.pontop.dk/

Regis Baccaro

Twitter: - @regbac

LinkedIn: Regis Baccaro

Contact: http://theblobfarm.wordpress.com

Regis has more than 15 years of experience with SQL Server, SharePoint and .Net as an architect and developer. R#233;gis is a SQL Server MVP since 2014 and a frequent speaker at SQL conferences, a PASS Regional Mentor and the founder of SQLSaturday Denmark community event. He is also a certified industry trainer on the APS/PDW platform. In his freetime he is an avid runner, cook and farmer.

Rasmus Reinholdt

Twitter: - @RasmusReinholdt

LinkedIn: Rasmus Reinholdt

Contact: http://rasmusreinholdt.wordpress.com

Rasmus is the Data Warehouse architect at UNOPS, the implementation arm of the UN, based in Copenhagen, Denmark. He has worked with Microsoft BI since 2005 both as a developer and architect, building large solutions on every release from sql2005 and onwards. Rasmus is certified is MSCE SQLServer (Data platform amp; BI), a long time speaker at various SQLSaturdays, PASS SQLRally Nordic and SQLBits. He also co-organizes SQLSaturday Copenhagen and blogs at http://rasmusreinholdt.wordpress.com.

Jen Stirrup

Twitter: - @jenstirrup

LinkedIn: Jen Stirrup

Contact: http://www.jenstirrup.com

Neil Hambly

Twitter: - Neil_Hambly

LinkedIn: Neil Hambly

Contact: http://dataidol.com/NeilHambly

Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.

SQLSaturday #281 - Edinburgh - BI Edition 2014

Sessions

Title: Keynote and Introduction: SQL Server 2014 and BI overview

Title: A One Hour Data Analysts Toolkit: using R and Power View

Title: SQOOP - Taking relational data to Hadoop and back again

Title: Migrating to PDW? Lessons from the Field

Title: Autogenerating a process data warehouse

Title: MDS and DQS - Beyond the TLAs to Data Quality

Title: Automate your SSIS development with BIML

Title: Optimizing BI with SQL2014 In-Memory tables

Title: Fusion-io: Unleashing the full performance of SQL

Title: Basket Analysis using BI Office and Analysis Services Tabular Edition

Title: Power View and the Cube

Title: Partitioning as a design pattern

Title: PDW Q A

Title: Big data. Small data. All Data.

Title: Clustered Columnstore Deep Dive

Title: Fusion-io: A whole new level of performance

Title: Web Analytics with Microsoft BI

Title: Dynamic Partitioning Cubes

Title: Case Study: Self Service BI within Manufacturing

Title: The Good, Bad and Ugly of Cloud Reporting

Title: Session Details not available

Speakers

Sponsors