| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 00:00:00 | Brian Boenk | Business Intelligence - Business Track | Dynamic Partitioning Cubes |
| 00:00:00 | n/a n/a | Business Intelligence – Technical Track | Session Details not available |
| 00:00:00 | Ian Macdonald | Microsoft SQL Server 2014 Applied | Basket Analysis using BI Office and Analysis Services Tabular Edition |
| 00:00:00 | Niko Neugebauer | Microsoft SQL Server 2014 Applied | Clustered Columnstore Deep Dive |
| 00:00:00 | Jen Stirrup | Business Intelligence - Business Track | Fusion-io: Unleashing the full performance of SQL |
| 00:00:00 | Jen Stirrup | Business Intelligence - Business Track | Fusion-io: A whole new level of performance |
| 00:00:00 | Jen Stirrup | Business Intelligence – Technical Track | PDW Q A |
| 00:00:00 | Jen Stirrup | Microsoft SQL Server 2014 Applied | Keynote and Introduction: SQL Server 2014 and BI overview |
| 00:00:00 | Jen Stirrup | Business Intelligence – Technical Track | A One Hour Data Analysts Toolkit: using R and Power View |
| 00:00:00 | Jon Woodward | Microsoft SQL Server 2014 Applied | Big data. Small data. All Data. |
| 00:00:00 | James Rowland Jones | Microsoft SQL Server 2014 Applied | Migrating to PDW? Lessons from the Field |
| 00:00:00 | Kennie Pontoppidan | Business Intelligence – Technical Track | Autogenerating a process data warehouse |
| 00:00:00 | Kennie Pontoppidan | Business Intelligence - Business Track | Partitioning as a design pattern |
| 00:00:00 | Mihail Mateev | Business Intelligence - Business Track | The Good, Bad and Ugly of Cloud Reporting |
| 00:00:00 | Neil Hambly | Business Intelligence – Technical Track | MDS and DQS - Beyond the TLAs to Data Quality |
| 00:00:00 | Paul Bunting | Microsoft SQL Server 2014 Applied | Case Study: Self Service BI within Manufacturing |
| 00:00:00 | Regis Baccaro | Business Intelligence - Business Track | Power View and the Cube |
| 00:00:00 | Rasmus Reinholdt | Business Intelligence – Technical Track | Optimizing BI with SQL2014 In-Memory tables |
| 00:00:00 | Tillmann Eitelberg | Business Intelligence - Business Track | Web Analytics with Microsoft BI |
| 00:00:00 | André Kamman | Business Intelligence – Technical Track | Automate your SSIS development with BIML |
| 00:00:00 | Allan Mitchell | Microsoft SQL Server 2014 Applied | SQOOP - Taking relational data to Hadoop and back again |
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Business Intelligence - Business Track
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!
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Business Intelligence – Technical Track
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Microsoft SQL Server 2014 Applied
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Microsoft SQL Server 2014 Applied
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Business Intelligence - Business Track
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Business Intelligence - Business Track
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Business Intelligence – Technical Track
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Microsoft SQL Server 2014 Applied
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.
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Business Intelligence – Technical Track
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Microsoft SQL Server 2014 Applied
How will the latest developments and future thinking, from Hadoop to Machine Learning and beyond shape the world of analytics?
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Microsoft SQL Server 2014 Applied
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!
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Business Intelligence – Technical Track
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.
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Business Intelligence - Business Track
The talk is relevant for DBA's, (BI) developers and BI architects.
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Business Intelligence - Business Track
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.
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Business Intelligence – Technical Track
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.
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Microsoft SQL Server 2014 Applied
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Business Intelligence - Business Track
The session we'll present
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Business Intelligence – Technical Track
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.
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Business Intelligence - Business Track
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.
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Business Intelligence – Technical Track
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.
Event Date: 14-06-2014 - Session time: 00:00:00 - Track: Microsoft SQL Server 2014 Applied
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.