SQLSaturday 382

Brisbane, Australia

SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. This event will be held on Mar 28 2015 at Australian Institute of Management, Cnr Boundary & Rosa Streets, Spring Hill, QLD, 4000, Australia

Register Now

Welcome to SQLSaturday #382

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Mar 28 2015 at the Australian Institute of Management (AIM), Cnr Boundary and Rosa Streets, Springhill, Australia. Admittance to this event is free, but we do charge a lunch fee of 10.00 so that we can provide a lunch - not pizza! Please register soon as seating is limited, and let friends and colleagues know about the event.

Pre-Con - Registration now open!

As part of the SQLSaturday event in Brisbane for 2015, we have 2 Pre-con sessions available and live for registrations. The Pre-con events will be held in Brisbane on Friday the 27th March, 2015 at the Australian Institute of Management (AIM).

Understanding SSIS Internals and Performance Tuning with David Peter Hansen

You have worked with SQL Server Integration Services (SSIS) for a few years, but more often than not, you see performance problems with your packages.  Some packages are running slow, while other are taking up more memory and CPU than before.

The first part of this full-day session will cover the internals of SSIS. Starting with an overview, we will move into the details of the control flow engine and the data flow engine. At the end of the internals section, you will have a deep understanding of the strengths and weaknesses of SSIS and what is the best way to design your packages.

The second part will cover the architecture of the SSIS Server, which came with SQL Server 2012. We will dive into the SSIS catalog and the host process used to execute the packages.

The third part will cover how we can use the knowledge about the internals of SSIS to gain better performance. This part will show practical examples of common performance problems, and how these can be solved. Furthermore we will look at how designing and tuning your data flows can increase performance significantly.

About David Peter Hansen

David Peter Hansen is a Microsoft Certified Master (MCM), Microsoft MVP, and has over a decade of experience with data development and administration on SQL Server and Microsoft Business Intelligence platform. Today he works as a Consulting Manager for Advectas Denmark. He specializes in scalable architecture and performance tuning on large-scale Data Warehouse and BI Solutions. He is a frequent speaker at conferences, and has given talks in Europe, USA and Africa. (PASS Summit, SQLBits, PASS SQLRally Nordic, PASS SQLRally Amsterdam as well as numerous SQLSturday events and User Groups)

Register Now


Actionable Visualisation in Power BI - Essentials with Julie Koesmarno

Historically, users have been constrained to consume data in fixed platforms, with one specific dimension for digital viewings and a couple of printed layouts. Nowadays, with the ubiquitous mobile devices available, Management expects to know key business indicators and day-to-day operation performance on the go. Using well-designed data models and visualization techniques, Power View can leverage timely and quick dashboards for analysis on the go. Meanwhile, Pivot Tables and Pivot Charts in Excel can also provide greater insights both in the desktop and online version. Power BI Q&A can visualise data based on a natural language question using advanced indexing technique of Power BI. Power Map can provide custom 3D as well as geographical analysis. 

This session will discuss how to design the appropriate data models to enable self-service data exploration and insightful analysis in Power BI, and how to create pixel perfect visualization for mobile devices. You will also learn how the techniques differ from traditional platforms. We will discuss fundamental data visualisation principles, business requirements gathering techniques and data modeling tips/tricks. Using live demo, we will walk through ways to channel users focus on actionable analytics on operational, strategy and analytical dashboard use cases. 

Featuring a full day workshop packed with demos, our aim is to introduce patterns as well as tips and tricks to build data visualisation solution using Power BI both for online and offline consumption. 

About Julie Koesmarno

Julie Koesmarno, SQL Server MVP, MCSE Data Platform, MCSE Business Intelligence, is a SQL Server and BI Consultant, with a Bachelor's degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her recent projects include delivering a SQL Server 2012 Data Warehouse and BI Solutions for a number of high profile clients in the US and Australia.

Register Now


Getting There

Parking

Free street parking is available on Saturday's on Boundary St.

There is no onsite parking.


Train

Central Station is just under one kilometer from AIM, which is about a 10 minute walk (uphill).

From Central Station, take Upper Edward St (runs into Little Edward St) and turn right onto Boundary St.


Where to Stay

The following accommodation options are all walking distance to AIM:

The Ridge on Leichhardt
Metropolitan Motor Inn
Oxygen Apartments


What's on in Brisbane in March?

Eat Street Markets
Kylie Minogue - Kiss Me Once Tour - Brisbane 21 March 2015
Brisbane Comedy Festival
Super Rugby - QLD Reds v Lions
Wicked - The Musical



Event Location

Event news

 Pre-con sessions are now live and open for registration. Early bird tickets are available until the 13th February, 2015. Read More

 SQLSaturday is coming to Brisbane on 28 March 2014 Read More

 Pre-Cons for SQLSaturday Brisbane will be run on Friday 27 March 2014 Read More

Contact

Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us


What is SQLSaturday?

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, and most costs are covered by donations and sponsorships. At some events you will have the option to pay for lunch at the time of registration. Please register soon as seating is limited, and let friends and colleagues know about the event.

Back to Top cage-aids
cage-aids
cage-aids
cage-aids