Build Schedule

Advanced Filters:
  • Track

    clear all




  • Speaker


  • Level


  • Session Type

Sessions Found: 21
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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence – Technical Track

Level: Advanced

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
Business Intelligence – Technical Track

Level: Advanced

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence – Technical Track

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Microsoft SQL Server 2014 Applied

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Microsoft SQL Server 2014 Applied

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
Microsoft SQL Server 2014 Applied

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
Microsoft SQL Server 2014 Applied

Level: Advanced

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
Business Intelligence - Business Track

Level: Advanced

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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 SQL Saturday Edinburgh
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence - Business Track

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence - Business Track

Level: Advanced

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

PowerBI provides a cloud based collaborative platform to manage and share business insights anytime and anywhere. This session will explore how to access the PowerBI site, manage integration with on premise data and set the availability of data to individuals within the business. Finally exploring some of the cool capabilities that will enable users to quickly create and share business data in a highly visual way 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence – Technical Track

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Microsoft SQL Server 2014 Applied

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence – Technical Track

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Microsoft SQL Server 2014 Applied

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
Business Intelligence – Technical Track

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence - Business Track

Level: Advanced

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence – Technical Track

Level: Beginner

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
Business Intelligence - Business Track

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Microsoft SQL Server 2014 Applied

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
Business Intelligence - Business Track

Level: Intermedia

Session Code:

Date: June 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 21
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids