SQLSaturday #224 - Sydney 2013
Event Date: 05/25/2013 00:00:00
Event Location:
- Epping Boys High School (EBHS)
- 213 Vimiera Road
- Eastwood, NSW, Australia
This event has completed. All data shown below is from the historical XML public data available.
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: 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 SQLSaturday. 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!
Speaker(s):
- Grant Paisley
Track and Room: Track 1 - N/A
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.
Speaker(s):
- Craig Bryden
Track and Room: Track 1 - N/A
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.
Speaker(s):
- Warwick Rudd
Track and Room: Track 2 - N/A
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.
Speaker(s):
- Victor Isakov
Track and Room: Track 2 - N/A
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.
Speaker(s):
- Peter Myers
Track and Room: Track 1 - N/A
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.
Speaker(s):
- Geoff Orr
Track and Room: Track 2 - N/A
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.
Speaker(s):
- Peter Myers
Track and Room: Track 1 - N/A
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.
Speaker(s):
- Mohamed Kabiruddin
Track and Room: Track 2 - 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.
Warwick Rudd
Contact: http://www.jnrit.com.au/Blog.aspx
Warwick Rudd is currently employed as a SQL Server Consultant and Certified Trainer for WARDY IT Solutions, Australia’s leading SQL Server consultants, trainers and Business Intelligence specialists. Warwick is a frequent speaker at local SQL Server user groups and SQLSaturday events in Australia. When not playing with the SQL stack, Warwick likes to get away to the cold and spend time snowboarding.
Grant Paisley
Twitter: - @angrykoala
Grant Paisley is a Data Platform MVP and founder of Angry Koala, a Microsoft Business Intelligence partner based in Sydney, Australia. Grant is president of the SQL Server Usergroup Sydney and created http://reportsurfer.com, a community built around reporting, where you can also run the reports. He was contributing author for quot;SQL Server 2008 Analysis Services with MDXquot; and quot;Microsoft SQL Server Reporting Services Recipesquot;.
Craig Bryden
Twitter: - @cbryden
LinkedIn: Craig Bryden
Craig has been working with SQL Server for over 20 years and currently holds several SQL Server based certifications. He has also previously held an MCT certification. Craig’s contribution to the SQL Server community was recognised in 2018 with a Microsoft MVP award. He was involved with Microsoft Learning to set some of the current SQL server Exams. Craig is the Chief Data Strategist at BiTQ. Craig is an organiser of the QLD Power BI User Group
Geoff Orr
Geoff Orr MCT is a BI consultant and trainer working with some of the leading BI companies in the Australia, on government and commercial systems. He finds collaborating and mentoring is key to any project, in the end it’s all about building professionals.
Peter Myers
LinkedIn: Peter Myers
Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.
He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.
Victor Isakov
Twitter: - @victorisakov
LinkedIn: Victor Isakov
Contact: http://www.victorisakov.com
Victor Isakov (MCA, MCM, MCSM, MCT, MVP) is a Database Architect and trainer who provides consulting and training services to various organizations in the public, private, and NGO sectors globally. He regularly speaks at international conferences such as Microsoft TechEd/Ignite, PASS Summit, IT/Dev Connections, and SQLSaturdays. Victor has written a number of books on SQL Server and has worked with Microsoft to develop the SQL Server exams and certification. In 2017 he authored “Exam Ref 70-764 Administering a SQL Database Infrastructure (1st Edition)”. He is one of only three non-Microsoft, Microsoft Certified Architects in the world.
Peter Myers
LinkedIn: Peter Myers
Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.
He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.
Mohamed Kabiruddin
Twitter: - mdkabir
LinkedIn: Mohamed Kabiruddin
Contact: http://www.nobrainerlab.com
Mohamed is a Cloud Solutions Architect with extensive experience in designing BI / Data Analytics solutions with expertise in analysis, design, modelling and implementation. He is a keen data enthusiast with a flair for managing and consolidating data.
Sponsors
The following is a list of sponsors that helped fund the event: