Birmingham Data Platform - Intro to Azure Data Factory, and Power BI Tips

Microsoft Data Platform Group Birmingham - Thu 19th Sept 2019, 6.15pm

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

Session 1: Getting Started with Azure Data Factory (Reiss McSporran)

Session 2: Power BI Tips and Tricks (Jon Lunn)

Agenda

6.15pm – 6:30pm Meet & Greet

6:30pm - 7:30pm: Getting Started with Azure Data Factory (Reiss McSporran)

This interactive session will give you the baseline knowledge you need, to start exploring how Azure Data Factory (ADFv2) can be used to move and transform data in the cloud.

We will start by creating a Data Factory, then connect to a data source, extract a few columns from a table, filter these down and insert them into an Azure SQL DB.

Then we’ll explore how we can make this more flexible, by using metadata to drive the extract statements, the tables to extract, the data sources and the destinations.

We will then take a look at Mapping Data Flows and how these can be used to replace your existing SSIS packages completely at a basic level.
By the end of the session you’ll have seen how to build this from nothing to a fully working solution that can then be expanded upon to bring to enterprise level.

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

8:00pm – 9:00pm Power BI Tips and Tricks (Jon Lunn)
Power BI Tips and Tricks: A variety of tips that have proved useful in the Power BI Desktop workflow, DAX and M. Subjects will include, the Selection Pane, Visual Headers and DAX optimisation quick wins.

Venue

This session will be held at a NEW VENUE - 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: Alex@MSDataGroupBrum.com

Reiss McSporran
Twitter: @McReiss (https://twitter.com/McReiss)
Email: Reiss@MSDataGroupBrum.com

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

Speaker Profiles

Reiss McSporran is the new co-organiser of this group, and will kick start his first event by speaking! He's a Business Intelligence developer at Purple Frog, specialising in Azure Data Factory.

Jon Lunn is Senior Consultant in Data and Analytics at Ricoh Digital Services. In his role he successfully delivers a wide range of data and analytical solutions, workshops and training across a variety of industry verticals. In his spare time, he can be found with his children building something in Lego.

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.