sqlsathistory

Nr: 224

Back to Main list

SQLSaturday #224 - Sydney 2013

Start Time (24h)	Speaker	Track	Title
00:00:00	Craig Bryden	Track 1	Introducing Microsoft Data Explorer for Excel
00:00:00	Geoff Orr	Track 2	Integration Services (SSIS) back to basics
00:00:00	Grant Paisley	Track 1	he godlike power of Excel 2013 with its disciples PowerPivot, PowerView and Geoflow
00:00:00	Mohamed Kabiruddin	Track 2	Agile BI with SQL Server 2012 and TFS 2012
00:00:00	Peter Myers	Track 1	Big Data Analytics with PowerPivot and Power View
00:00:00	Peter Myers	Track 1	Mastering the CUBE functions in Excel 2013
00:00:00	Victor Isakov	Track 2	Maximizing SQL Server Performance: Tuning the Processor, RAM, Disk and Network Subsystems
00:00:00	Warwick Rudd	Track 2	Pimp my Availability Groups

SessionID: 11987

Introducing Microsoft Data Explorer for Excel

Back to calendar

Event Date: 25-05-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Craig Bryden

Title: Introducing Microsoft Data Explorer for Excel

Abstract:

In this session, I will introduce the audience to Microsoft Data Explorer for Excel. "Data Explorer" is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access. It has often been referred to as the end-user ETL tool, but I believe that it will also be a valuable tool for all technical staff. This demo rich presentation will expose many great features of the newest addition to the Microsoft self-service offering.

SessionID: 14470

Integration Services (SSIS) back to basics

Back to calendar

Event Date: 25-05-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Geoff Orr

Title: Integration Services (SSIS) back to basics

Abstract:

Geoff Orr, a very experience consultant, is going to cover the practical techniques for best utilising the incredible power of Integration Services - SQL's tool for moving and cleaning data.

SessionID: 14723

he godlike power of Excel 2013 with its disciples PowerPivot, PowerView and Geoflow

Back to calendar

Event Date: 25-05-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Grant Paisley

Title: he godlike power of Excel 2013 with its disciples PowerPivot, PowerView and Geoflow

Abstract:

You will be converted to "Personal BI" (Business Intelligence)" when you see real client examples of Excel Add-in's PowerPivot (100million rows in Excel), PowerView (rich easy to use data exploration tool) and Geoflow (fully interactive data mapped on the globe) You may wonder why Excel is getting all the attention at a SQL Saturday. It's simple. Excel is the tool for "Personal BI" PowerPivot is an in mememory tabular storage model built by the Analysis Server (SSAS) team. It shares the same codebase with SSAS Tabular, the same technology running on a server. So you have on your desktop, in Excel, a serverlike godlike power... All SQL Professionals should know how to weild this power!

SessionID: 20014

Agile BI with SQL Server 2012 and TFS 2012

Back to calendar

Event Date: 25-05-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Mohamed Kabiruddin

Title: Agile BI with SQL Server 2012 and TFS 2012

Abstract:

In a world where executives/CXOs are keen to perform analytics and data consolidation with lightning speed, there is a strong push towards incorporating the principles of Agile manifesto in the BI world to deliver solutions faster than ever before. In this session, I will share techniques that will help a consultant deliver BI solutions with a rapid prototyping approach and how Agile features of TFS can be leveraged to run projects. The session will involve case studies and practical demos using Team Foundation Server and SQL Server 2012's BI tools - SSIS, SSRS, SSAS (tabular) and Excel PowerPivot.

SessionID: 21954

Big Data Analytics with PowerPivot and Power View

Back to calendar

Event Date: 25-05-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Peter Myers

Title: Big Data Analytics with PowerPivot and Power View

Abstract:

This presentation will introduce big data analytics for the business analyst with PowerPivot and Power View. It will be of interest to those new to the concept of big data, new to self-service data modelling with PowerPivot, and those interested to understand what is new for PowerPivot and Power View in Excel 2013.Demonstrations will include creating a big data solution by using HDInsight Server; producing a PowerPivot model based on the big data solution; using PowerPivot to integrate big data with local data; and, analyzing the PowerPivot model data by using Power View.

SessionID: 21956

Mastering the CUBE functions in Excel 2013

Back to calendar

Event Date: 25-05-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Peter Myers

Title: Mastering the CUBE functions in Excel 2013

Abstract:

This session explores the seven CUBE functions that are natively available in Excel 2013. Unknown to many business analysts, these useful functions can be used to retrieve data model members and values to create parameter-driven report designs.

The session topics will introduce each of the seven functions. Demonstrations will range from the simple, to the more sophisticated involving dynamic expressions, MDX expressions, integration of data from multiple data models, and macro-driven layouts.

This session is a must for those looking to drive more from Excel when reporting from the BI Semantic Model. Much of the content presented in this session is also applicable to Excel 2007 and Excel 2010.

SessionID: 27414

Maximizing SQL Server Performance: Tuning the Processor, RAM, Disk and Network Subsystems

Back to calendar

Event Date: 25-05-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Victor Isakov

Title: Maximizing SQL Server Performance: Tuning the Processor, RAM, Disk and Network Subsystems

Abstract:

You can't escape hardware or the laws of physics. Ultimately your SQL Server instance will be using the processor, memory, disk and network subsystems. In this session Victor Isakov (MCA, MCM, MCT, MVP) will go through the various subsystems and examine how the SQL Server database engine works with them and what configuration options exist. Along the way he will discuss how to tune the hardware, operating system and SQL Server for maximal performance.

SessionID: 27665

Pimp my Availability Groups

Back to calendar

Event Date: 25-05-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Warwick Rudd

Title: Pimp my Availability Groups

Abstract:

AlwaysOn Availability Groups became available in SQL Server 2012. They provide a more granular approach to providing High Availability for you databases. In this session Warwick will introduce you to how you can utilise your AGs with Replication, Change Tracking Change Data Capture.

This site is open source. Improve this page.