SQLSaturday #224 - Sydney 2013 5/25/2013 12:00:00 AM (GMT+10:00) Canberra, Melbourne, Sydney SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat224 Epping Boys High School (EBHS) 213 Vimiera Road, Eastwood NSW, Australia 2122 http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 3136 Angry Koala Gold Sponsor http://www.angrykoala.com.au http://www.angrykoala.com.au/images/AKGraphics/ak_logo_250.jpg 60 170 3137 WARDY IT Solutions Gold Sponsor http://www.wardyit.com http://www.wardyit.com/img/SQLSaturdayLogo.jpg 60 170 3351 Fusion-io Silver Sponsor http://www.fusionio.com http://www.fusionio.com/load/-media-/1vt0i0/imagesMisc/thumb.580x145.fusionio-logo-wide-1341599667.jpg 60 170 14021 SQLSaturday 224 Track 1 Room 1 5/25/2013 10:15:00 AM 5/25/2013 10:45:00 AM 14021 SQLSaturday 224 Track 1 Room 1 5/25/2013 2:30:00 PM 5/25/2013 2:45:00 PM 14021 SQLSaturday 224 Track 2 Room 2 5/25/2013 10:15:00 AM 5/25/2013 10:45:00 AM 14021 SQLSaturday 224 Track 2 Room 2 5/25/2013 2:30:00 PM 5/25/2013 2:45:00 PM 14022 SQLSaturday 224 Track 2 Room 2 5/25/2013 12:00:00 PM 5/25/2013 1:15:00 PM 14022 SQLSaturday 224 Track 1 Room 1 5/25/2013 12:00:00 PM 5/25/2013 1:15:00 PM 14023 SQLSaturday 224 Track 1 Room 1 5/25/2013 8:30:00 AM 5/25/2013 9:00:00 AM 14023 SQLSaturday 224 Track 2 Room 2 5/25/2013 8:30:00 AM 5/25/2013 9:00:00 AM 14024 SQLSaturday 224 Track 2 Room 2 5/25/2013 4:00:00 PM 5/25/2013 4:30:00 PM 14024 SQLSaturday 224 Track 1 Room 1 5/25/2013 4:00:00 PM 5/25/2013 4:30:00 PM 14099 Warwick Rudd Track 2 Room 2 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. 5/25/2013 10:45:00 AM 5/25/2013 12:00:00 PM 14384 Victor Isakov Track 2 Room 2 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. 5/25/2013 1:15:00 PM 5/25/2013 2:30:00 PM 14555 Mohamed Kabiruddin Track 2 Room 2 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. 5/25/2013 2:45:00 PM 5/25/2013 4:00:00 PM 14639 Peter Myers Track 1 Room 1 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. 5/25/2013 9:00:00 AM 5/25/2013 10:15:00 AM 14641 Peter Myers Track 1 Room 1 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. 5/25/2013 2:45:00 PM 5/25/2013 4:00:00 PM 14933 Grant Paisley Track 1 Room 1 Last year we had 'Killer real-world powerpivot examples', this year we have a new set of PowerPivot and now PowerView report example. This is *the* session to attend if you want to get the most out of Powerpivot/Powerview visualizations. Essentially you will see real world PowerPivot/Powerview reports from clients in Higher Education, Insurance, Retail and Banking and learn a variety of visualization techniques including sparklines, slicers, and charts. You will also learn what measures give the best impact with Powerview. You will leave this fun session armed with plenty of ideas for your next BI project. Oh and watch out for flying Koala's 5/25/2013 10:45:00 AM 5/25/2013 12:00:00 PM 15238 Craig Bryden Track 1 Room 1 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. 5/25/2013 1:15:00 PM 5/25/2013 2:30:00 PM 15642 Geoff Orr Track 2 Room 2 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. 5/25/2013 9:00:00 AM 5/25/2013 10:15:00 AM