Skip Main Navigation
Page Content

Save This Event

Event Saved

Looks like this event has already ended.

Check out upcoming events by this organiser, or organise your very own event.

View upcoming events Create an event

Birmingham SQL Server User Group - SQL Tips Tricks and Querying Tabular Models in Excel

SQL Midlands

Thursday, 19 November 2015 from 18:30 to 21:00 (GMT)

Birmingham SQL Server User Group - SQL Tips Tricks and...

Ticket Information

Type Remaining End Quantity
SQL Midlands Attendee 14 Tickets Ended Free  

Share Birmingham SQL Server User Group - SQL Tips Tricks and Querying Tabular Models in Excel

Event Details

Midlands SQL Server User Group - 19th November 2015, 6.30pm

Session 1: Peter Moore - SQL Server Tips & Tricks

Session 2: Kieran Wood - Comparing and Contrasting Difference methods of querying PowerPivot / Tabular Model within an Excel worksheet.  [SESSION CHANGE]


 

Agenda

6.15pm – 6:30pm Meet & Greet

6:30pm - 7:30pm Peter Moore - SQL Server Tips & Tricks

Hostage to the Software House: for some time, some years back; I worked in “tandem” with a software house. I say, in tandem, I worked they, erm, didn't. This meant that any change I needed to make had to be done in SQL alone. This is difficult but not impossible (if you're SQL Sneaky). Here, then, I present (a handful of) the SQL survival tricks I used.

7:30pm - 8:00pm Break & Food

8:00pm – 9:00pm Kieran Wood - Comparing and Contrasting Difference methods of querying PowerPivot / Tabular Model within an Excel worksheet.  [SESSION CHANGE]

Different methods I intended to cover are; - Pivot Table, DAX Query and Cube Values.
Advantages / Disadvantages of the above in terms of; -  Performance, skills required, maintainability, readability, stability.
Advantages / Disadvantages of above elements including Power BI Desktop.

Getting There

We'll be at the Midlands Art Centre (MAC Birmingham), B12 9QH.

It's directly opposite Edgebaston Cricket Ground in Birmingham

Parking: Lots or free parking, entrance is via Queens Ride, opposite the cricket ground

Public Transport: It's about 2 miles from New Street Station. Short taxi ride, or buses 1, 35, 45, 47, 62 & 63.

The 45 & 47 are the best options, which depart from outside Boots in the Bullring, opposite where the main entrance to New Street station was, on Smallbrook Queensway.

http://www.networkwestmidlands.com/bus/bus-maps.aspx

Room: When you get there, we're in the 'Pincent Masons 1' room. On the 1st floor, above the main entrance.

 

Other Details

We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know.

Dress code: relaxed

If you need any further details or have any requests for this or future Midlands SSUG events, please let me (Alex Whittles) know, either on Twitter (@PurpleFrogSys or @SQLMidlands) or email Alex@SQLMidlands.com

 

Speaker profiles

Pete Moore

My specialism is Data.  I like bringing order to it. Typically I will approach a data source by: first looking at it, then making sense of it, and finally utilising it. The goal is (usually) to form a robust system that supports repeat interrogation.
Although my specialism is SQLServer, the passion burns for the data itself. I sometimes share the love at www.databackwriter.com or @factgasm

 

Do you have questions about Birmingham SQL Server User Group - SQL Tips Tricks and Querying Tabular Models in Excel? Contact SQL Midlands

When & Where


MAC Birmingham (Midlands Arts Centre)
Cannon Hill Park
B12 9QH Birmingham
United Kingdom

Thursday, 19 November 2015 from 18:30 to 21:00 (GMT)


  Add to my calendar

Organiser

SQL Midlands

SQLMidlands - Bringing the West Midlands SQL Server community together

!!!! NOW MOVED TO MEETUP !!!!!

meetup.com/MicrosoftDataPlatformBirmingham

All future events will be promoted on Meetup, not here. Head over to the link above to sign up!

 


We normally hold meetings every other month, usually on a Thursday after work at in the centre of Birmingham. It's an informal gathering of like minded people, with a couple of speakers presenting tips, techniques and information on old, new and upcoming technology. We like to get a mixture of world leading speakers as well as providing an opportunity for our members to present.

We tailor the speakers and sessions to your requests so if you have any specific topics that you want to go through, then come along and let us know.

We're part of the UK SQL Server community at www.sqlserverfaq.com and we're an official PASS chapter (the Professional Association for SQL Server) covering the Midlands in the UK.

 

If you've registered for an event and can no longer make it, please do unregister so that we don't over order the food! To unregister just view your tickets in your EventBrite account, and then cancel the relevant ticket. Thanks!

 

This event is kindly sponsored by Purple Frog Systems, if you need any Microsoft Business Intelligence help (Data Warehouses, ETL, Cubes, Azure, IoT, etc.), give them a call!

 

  Contact the Organiser

Interested in hosting your own event?

Join millions of people on Eventbrite.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.