Microsoft Data Platform Group - Birmingham

Name: Birmingham Data Platform - T-SQL, Power BI and Formula 1
Start: 2019-12-05T18:15+00:00
End: 2019-12-05T21:15+00:00
Location: Ricoh Digital Services

Birmingham, United Kingdom

1,044 members
Public group

Organized by Alex W.

and 2 others

Join this group

What we're about

Microsoft Data Platform Group - Bringing the West Midlands Microsoft data platform community together.

WHAT?

We normally hold meetings every other month, usually on a Thursday after work in the centre of Birmingham. It's an informal gathering of like minded people, with a couple of speakers presenting hour long sessions including 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. Each meetup consists of two speakers presenting topics for an hour each, with a break in the middle for some food and networking.

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

Kindly sponsored by RP Analytics (https://www.rattrayparkin.com/divisions/business-intelligence.aspx) Ricoh Digital Services, and Purple Frog Systems (https://www.PurpleFrogSystems.com)

WHERE?

We're delighted to have a new venue sponsor; Ricoh, who are kindly providing their offices. thanks Ricoh!

Ricoh Digital Services, 54 Hagley Rd, Birmingham, B16 8PE

Google Map of Ricoh location (https://www.google.co.uk/maps/place/Ricoh+Digital+Services/@52.4716842,-1.9264494,17z/data=!3m1!4b1!4m5!3m4!1s0x4870bcf1134e78f9:0xf73505c26be365ff!8m2!3d52.471681!4d-1.9242554)

There's no parking on site, but there is a car park at Broadway Plaza (https://broadway-plaza.co.uk/Parking) down the road.

WHEN?

The 2nd or 3rd Thursday of the month.

Door open at 6:15pm to meet and greet.

The first session starts at 6:30pm, second session finishes at 9pm with a break for refreshments in between.

ANYTHING ELSE?

Dress code: Casual

Size: Usually between 20 and 30 people

Upcoming events (1)

See all

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

Thu, Dec 5, 6:15 PM

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

Ricoh Digital Services

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: 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.