Birmingham Data Platform - T-SQL, Power BI and Formula 1

Microsoft Data Platform Group Birmingham - Thu 5th Dec 2019, 6.15pm

*** Registration on MeetUp required for venue security ***

Session 1: T-SQL: Building on the Basics (Jeet Kainth)

Session 2: Build a Formula 1 Power BI dashboard from one web address (Laura Graham-Brown)

Agenda

6.15pm – 6:30pm Meet & Greet

6:30pm - 7:30pm: T-SQL: Building on the Basics (Jeet Kainth)

This session will provide a number of tips that can improve your SQL basics, both in terms of performance and streamlining your code. The demo will cover various querying techniques as well as error handling in T-SQL.

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

8:00pm – 9:00pm Build a Formula 1 Power BI dashboard from one web address (Laura Graham-Brown)

The internet is full of data that often is split across pages and presented in pretty pages. How can we drag this data into a Power BI report only using one web address?

In this demo based session we will cover fetching web data using examples, add some parameters, create functions and then beat the data into shape ready for a report to analyze just how Hamilton keeps winning. Fun filled fast demos to race through the data.

Venue

This session will be held at Ricoh Digital Services.

Address: 54 Hagley Rd, Birmingham, B16 8PE

Parking:
On site at Ricoh, request a space through the following link:
https://forms.office.com/Pages/ResponsePage.aspx?id=8vZHlwAaiUSKx4NfZSy0TNJVR03iASNOuy8bfsrC_nRUQ0RHT1Q5VjRDMzQ3WTRETkM0WEVBOFNHTi4u

Over the road at Broadway Plaza:
https://broadway-plaza.co.uk/Parking

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

Event Organiser Contact Details

If you need any further details or have any requests for this or future Data Platform Group events, please contact get in touch.

Alex Whittles
Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex)
Email: [masked]

Reiss McSporran
Twitter: @McReiss (https://twitter.com/McReiss)
Email: [masked]

Microsoft Data Platform Group - Birmingham
Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum)

Speaker Profiles

Jeet is a Business Intelligence developer at Purple Frog, delivering solutions in data warehousing and data analytics, and has several years experience working with data, SQL and reporting solutions.

Laura has worked with data in Microsoft products for over 20 years showing business users how to make Excel, Power Query and more recently Power Platform products do what is needed. Passionate speaker who loves sharing knowledge and is always up for a challenge.

Sponsors
We're delighted to yet again have the awesome RP Analytics recruitment sponsoring the pizza for the event, thanks!

Ricoh are generously providing the venue for us, thanks Ricoh!

Purple Frog handle the organisation.