Loading
  • Birmingham Data Platform - AUGUST ONLINE - Query Store Fundamentals

    Microsoft Data Platform Group Birmingham - Thu 6th August 2020, 7:00pm *** Registration on MeetUp required to gain access to remote link! *** *** This is using GoToWebinar so a small download will be needed *** Session: Query Store Fundamentals (Erin Stellato) Agenda 6:30pm – 7:00pm Setup and Join 7:00pm - 8:30pm Query Store Fundamentals (Erin Stellato) One of the most highly anticipated new features in the SQL Server 2016 release was Query Store. If you've ever had to drop everything to troubleshoot a sudden drop in performance, then this is a feature you want in your environment. In this session we will discuss configuration options and best practices, step through using the built-in reports, and review plan forcing in Query Store. Get ready to make troubleshooting easier with this feature that’s included in Azure SQL and all editions of SQL Server 2016 and higher! Venue Wherever you have access to Computer or Smart Device to access a GoToWebinar! This session will be online only! Other Details The link to the GoToWebinar will be made available prior to the event and will be open from 6:30pm. You MUST RSVP to this event to gain access to the link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help. 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 get in touch. Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] Reiss McSporran Twitter: @PurpleFrogReiss (https://twitter.com/PurpleFrogReiss) Email: [masked] Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles ERIN STELLATO SQLskills Principal Consultant Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has over 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Extended Events, Query Store, and helping accidental/involuntary DBAs figure out how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences like SQLintersection, the PASS Summit, and SQLBits. Outside of time with family and friends, she enjoys movies, working out, good food, and all things chocolate. Email: [masked] Website: http://www.SQLskills.com Blog: http://www.SQLskills.com/blogs/Erin Twitter: http://twitter.com/ErinStellato Data Platform MVP since 2012 Sponsors RP Analytics recruitment Ricoh Purple Frog handle the organisation.

  • Birmingham Data Platform - JULY ONLINE EVENT - Machine Learning in Power BI

    Microsoft Data Platform Group Birmingham - Thu 2nd July 2020, 7:00pm *** Registration on MeetUp required to gain access to remote link! *** *** This is using GoToWebinar so a small download will be needed *** Session 1: Machine Learning in Power BI (Alex Whittles) Agenda 6:30pm – 7:00pm Setup and Join 7:00pm - 8:30pm Machine Learning in Power BI (Alex Whittles) Two of the hottest topics in data are Machine Learning and Power BI, but how to the work together? In this session we’ll look at what ML tools and features are available in the Power BI world, and how you go about using these in your data and reports. This will include using both built in and 3rd party Power BI visuals, consuming Azure Cognitive Services, as well as the new ML features available in data flows. Venue Wherever you have access to Computer or Smart Device to access a GoToWebinar! This session will be online only! Other Details The link to the GoToWebinar will be made available prior to the event and will be open from 6:30pm. You MUST RSVP to this event to gain access to the link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help. 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 get in touch. Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] Reiss McSporran Twitter: @McReiss (https://twitter.com/PurpleFrogReiss) Email: [masked] Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles Alex Whittles Alex is a Data Platform MVP, and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specializes in Data Warehouse modelling, ETL, Cubes, MDX & DAX. He’s a chartered engineer and has an MSc in Business Intelligence. He runs the Birmingham (UK) SQL Pass chapter and Azure user groups, and is on the SQLBits and SQL Relay committees in the UK. Alex is a regular speaker at global events including SQLBits, PASS Summit, SQL Relay, SQL Saturdays as well as numerous SQL Pass chapters around Europe. Sponsors RP Analytics recruitment Ricoh Purple Frog handle the organisation.

  • Birmingham Data Platform - JUNE ONLINE EVENT - SSRS, PowerApps and PowerBI

    Microsoft Data Platform Group Birmingham - Thu 4th June 2020, 7:00pm *** Registration on MeetUp required to gain access to remote link! *** *** This is using GoToWebinar so a small download will be needed *** Session 1: Supercharge your Reporting Services: An essential toolkit (Craig Porteous) Session 2: Exploring how Power Apps and Power BI can work together (Laura Graham-Brown) Agenda 6:30pm – 7:00pm Setup and Join 7:00pm - 8:00pm Supercharge your Reporting Services: An essential toolkit (Craig Porteous) Get the most out of your Reporting Services (SSRS) environments with this arsenal of PowerShell, SQL and admin tools. You'll leave this session knowing and controlling more about your SSRS environments than you thought possible covering monitoring, security, administration and deployment. 8:00pm - 8:05pm Comfort Break 8:05pm – 9:05pm Exploring how Power Apps and Power BI can work together (Laura Graham-Brown) (Matt Weston session breakdown) In the previous session we had an introduction to Power Apps and we briefly mentioned how Power Apps and Power BI have a close working relationship. Within this session we will investigate the ways in which the two technologies go hand in hand, providing multiple ways to consume the data and also multiple ways to interact with it. Venue Wherever you have access to Computer or Smart Device to access a GoToWebinar! This session will be online only! Other Details The link to the GoToWebinar will be made available prior to the event and will be open from 6:00pm. You MUST RSVP to this event to gain access to the link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help. 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 get in touch. Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] Reiss McSporran Twitter: @McReiss (https://twitter.com/PurpleFrogReiss) Email: [masked] Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles Craig Porteous Craig is a Microsoft Data Platform MVP working with Incremental Group as a Senior Data Engineer. He has more than 10 years working with data and related technologies, supporting global BI Environments, automating processes with PowerShell and implementing data platform solutions. Craig is actively involved in the data community as a co-leader of the Glasgow data user group & founder of the DATA:Scotland Conference in Scotland. Laura Graham-Brown "A data scientist before most people knew the term" I am passionate about technical problem solving. I get a huge buzz from taking a clients’ problems and creating a solution that works and can be maintained easily long term. I am even more passionate about training others to problem solve. If I can get another person to taste the buzz of technical problem solving, then I have achieved my goal. I enjoy learning new technical methods from new programming languages to applying older skills in new ways. Data presentation can be beautiful, showing the hidden trends, allowing management to explore data with a mouse click or 2. Networking with technical people is the best networking and the UK Power Platform community is superb. Sponsors RP Analytics recruitment Ricoh Purple Frog handle the organisation.

    3
  • Birmingham Data Platform - ONLINE EVENT on Microsoft Power Platform

    Microsoft Data Platform Group Birmingham - Thu 7th May 2020, 6:30pm *** Registration on MeetUp required to gain access to remote link! *** *** This is using GoToWebinar so a small download will be needed *** Session 1: Rebooting your Data Strategy with the Power Platform & Office365 (Mark Hayes) Session 2: Power Apps with a hint of Power BI (Matt Weston) Agenda 6.00pm – 6:30pm Setup and Join 6:30pm - 7:30pm Rebooting your Data Strategy with the Power Platform & Office365 (Mark Hayes) For many businesses setting up a data analysis platform can be expensive. If you have relatively small numbers of users, the costs can appear prohibitive. This is no longer the case with the Power Platform. This session is based on real-life customer implementations where they migrated from their Excel and custom line of business based reporting solutions towards the Power Platform. We show how we started with Power BI and evolved into a comprehensive solution that combines SharePoint Online, Team and Power Automate with PowerBI to provide an end to end reporting solution. Format - PowerPoint with plenty of demonstrations of how this system was built and how you can start approaching this type of project. Technologies covered • Power BI • Power Automate • Teams • Sharepoint Online • Excel 7:30pm - 7:35pm Comfort Break 7:35pm – 8:35pm Power Apps with a hint of Power BI (Matt Weston) In this session we will look at the capabilities of Power Apps as an introduction. From there we will investigate the relationship and co-working between Power Apps and Power BI. Venue Wherever you have access to Computer or Smart Device to access a GoToWebinar! This session will be online only! Other Details The link to the GoToWebinar will be made available prior to the event and will be open from 6:00pm. You MUST RSVP to this event to gain access to the link! Please contact us on Twitter or via email if you are having any issues joining and we'll do everything we can to help. 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 get in touch. Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] Reiss McSporran Twitter: @McReiss (https://twitter.com/PurpleFrogReiss) Email: [masked] Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles Mark (Certified Business Intelligence Professional (CBIP), MPP - Data Science, MPP - Big Data) is a Microsoft Data Platform consultant and has worked with Microsoft data technologies since 2000. He has worked on hundreds of projects working with the MS SQL DB Engine, Analysis Services, SSIS, SSRS, PowerBI. Tabular, Flow and more. He is a regular speaker on Microsoft Data Platform topics and co-leader of the Cork SQL User Group, Cork PowerBI User Group, the Cork SQL Saturday and Data Céilí 2020. Matt Weston I have been working with SharePoint since 2007 following a baptism of fire which converted me from a .NET web developer to a SharePoint Developer. Since then I have continued to specialise in SharePoint, working with all versions back to 2003, and have now become completely immersed within the Office 365 platform. I have worked on a massive variety of projects from small SharePoint farm implementations to large scale highly available farms with disaster recovery strategies, as well as SharePoint Online, Teams, Flow and PowerApps projects to showcase the latest and greatest technologies offered by Microsoft. I am one of two regional leaders for the Office 365 and SharePoint User Group in the West Midlands, UK, and love nothing more than to present myself at user groups, or SharePoint Saturdays. Sponsors RP Analytics recruitment Ricoh Purple Frog handle the organisation.

  • Birmingham Data Platform - Azure Synapse Analytics and Azure Databricks

    Microsoft Data Platform Group Birmingham - Thu 5th Mar 2020, 6.15pm *** Registration on MeetUp required for venue security *** Session 1: Azure Synapse Analytics : Evolving Azure SQL Data Warehouse (Mark Pryce-Maher) Session 2: Streaming data pipelines using Azure Databricks (Jon Lunn) Agenda 6.15pm – 6:30pm Meet & Greet 6:30pm - 7:30pm: Azure Synapse Analytics : Evolving Azure SQL Data Warehouse (Mark Pryce-Maher) Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless on-demand or provisioned resources—at scale. In this session we explore Azure Synapse Analytics, we will dive into this limitless analytics service and explore how it brings together enterprise data warehousing and Big Data analytics. We will explore; *Data ingestion *SQL Pools - Data Warehouses *Spark Pools *SQL-on-Demand *PowerBI 7:30pm - 8:00pm Break & Pizza 8:00pm – 9:00pm Streaming data pipelines using Azure Databricks (Jon Lunn) This session will show how you can set up a streaming data pipeline using Azure Event Hubs and Azure Databricks. We’ll look at some of the best practice on how to do it, and capabilities of the Azure services so you can get a quick insight on how it works. 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://bit.ly/2rZUYvp 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 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 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.

    2
  • Birmingham Data Platform - Intro to Python, and Azure Databricks

    Ricoh Digital Services

    Microsoft Data Platform Group Birmingham - Thu 6th Feb 2020, 6.15pm *** Registration on MeetUp required for venue security *** Session 1: Introduction to Python (Jon Fletcher) Session 2: Getting started with Azure Databricks (Alex Whittles) Agenda 6.15pm – 6:30pm Meet & Greet 6:30pm - 7:30pm: Introduction to Python (Jon Fletcher) Interested in learning Python but unsure where to start? This session is for complete beginners with no prior Python knowledge. The session introduces the basics of python, including: - Syntax - Functions - Control Flow - Lists - Loops 7:30pm - 8:00pm Break & Pizza 8:00pm – 9:00pm Getting started with Azure Databricks (Alex Whittles) (Abstract details to follow) 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://bit.ly/2rZUYvp 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 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 Jon is a Business Intelligence developer at Purple Frog, delivering solutions in data warehousing and data analytics, and has experience working with data, SQL and reporting solutions. Alex Whittles (@PurpleFrogAlex) is a Microsoft Data Platform MVP, and is Principle Consultant at Purple Frog Systems, a data warehousing, cube & analytics consultancy in the Midlands. 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.

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

    1
  • Birmingham Data Platform - Making Your Emergency Toolkit & Chatbots for the DBA

    Microsoft Data Platform Group Birmingham - Thu 14th Nov 2019, 6.15pm *** Registration on MeetUp required for venue security *** Session 1: Making Your Emergency Toolkit (Rich Benner) Session 2: Chatbots for the DBA (Stuart Moore) Agenda 6.15pm – 6:30pm Meet & Greet 6:30pm - 7:30pm: Making Your Emergency Toolkit (Rich Benner) You’ve just been given a server that is having problems and you need to diagnose it quickly. This session will take you through designing your own toolkit to help you quickly diagnose a wide array of problems. We will walk through scripts that will help you pinpoint various issues quickly and efficiently. This session will take you through; What’s on fire? – These scripts will help you diagnose what’s happening right now Specs – What hardware are you dealing with here (you’ll need to know this to make the appropriate decisions)? Settings – are the most important settings correct for your workload? Bottlenecks – We’ll see if there are any areas of the system that are throttling us. By the end of this session, you should have the knowledge of what you need to do in order to start on your own kit. This kit is designed to be your lifeline to fix servers quickly and get them working. All code we’ll go through is either provided as part of this presentation or are open source/community tools. 7:30pm - 8:00pm Break & Pizza 8:00pm – 9:00pm Chatbots for the DBA (Stuart Moore) Want a single place to see all your database alerts? Want to be able to respond to able to respond to them in the same tool even when away from your main computer? Want to let people self serve their database needs? We’ll be looking at using simple chatbots within Slack and Teams to let you achieve all of that and more. 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 Rich Benner is a performance tuning DBA who specialises in making SQL Servers and their queries run faster. Rich is a technical speaker and loves giving back to the community. Recent talks are at PASS East Midlands user group as well as at SQLBits (the largest SQL Server conference in the UK). Stuart Moore 20+ years as a professional data wrangler. Microsoft Data Platform MVP, Data Relay organiser, major contributor to the dbatools project, and runs 2 local usergroups in his spare time. 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.

    6
  • 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: [masked] Reiss McSporran Twitter: @McReiss (https://twitter.com/McReiss) Email: [masked] 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.

    10
  • Birmingham Data Platform - Using Python in SSMS, & other Machine Learning Demos

    Microsoft Data Platform Group Birmingham - 8th November 2018, 6.15pm *** Registration on MeetUp required for venue security *** Session 1: Using Python in SQL Server Management Studio (Pete Moore) Session 2: Machine Learning Demos (Alex Whittles, MVP) Agenda 6.15pm – 6:30pm Meet & Greet 6:30pm - 7:30pm: Using Python in SQL Server Management Studio (Pete Moore) The noise started far away: you need to learn Python, it whispered. We ignored it for a while because we could. Besides we were busy, busy architecting databases, busy writing T-SQL and busy learning all of the other stuff on the MS Data Platform. Real data. Then something happened: you could code Python from within SSMS. The whisper had become deafening. This was now part of T-SQL coding. This was us. The Python had infiltrated our world, but what did it mean for us, the SQL folk? Did we need to up-skill? What now? Did we need knew technology? Textbooks? New education? Or could we just ignore it? This decade’s LINQ (sorry LINQ folks)? This talk tackles these questions by coaxing Python out of its natural environment and debating the pros and cons of: SQL vs Python, Native Python vs Python in SSMS; and, ultimately, why we might just be able to have the best of both worlds - all from the comfort of your own SQL Server Management Studio. 7:30pm - 8:00pm Break & Pizza 8:00pm – 9:00pm Machine Learning Demos Alex Whittles (MVP) will be running through a number of hands-on demos of different ways of accessing and running Machine Learning code. Using a combination of drag and drop GUI through to Cognitive Services, and R & Python scripting, and using tools from Machine Learning Workbench, SQL Server, R-Studio, Python, Data Lake and Data Bricks. Lots of demos, not much theory! Venue This session will be held at Matthew Boulton College. Room: MB114 Address: Matthew Boulton College Jennens Road Birmingham B4 7PS https://www.bmet.ac.uk/our-locations/matthew-boulton/find-us/ On site parking is very limited and likely to already be taken by college staff/students. There are several car parks in the area, see Park-O-Pedia for more details: https://en.parkopedia.co.uk/parking/locations/jennens_road_birmingham_b4_7ps_united_kingdom_gcqdt422cgm/?arriving=201709071700&leaving=201709072130 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] ([masked]) Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles Pete Moore (@TheDataBloke) is a Data Scientist specialising in R, Python and SQL. He is founder of Look at your Data Ltd and available for freelance work, you can view his CV here: https://goo.gl/rvLhy1 Prior to Look at your Data, Pete was an IT Director. He is a present day student at the Data Science MSc at the University of Dundee. Alex Whittles (@PurpleFrogAlex) is a Microsoft Data Platform MVP, and is Principle Consultant at Purple Frog Systems, a data warehousing, cube & analytics consultancy in the Midlands.

    2