Speaker

Damien Jones

Damien Jones

UK Data Engineer | Creator at amazonwebshark.com | Fin Fan | Dog Dad | He/Him

Manchester, United Kingdom

I’m Damien, a Mancunian male with almost a decade of experience with technology and cloud. My current specialties are Data Engineering and AWS.

I started amazonwebshark in 2021. In the context of the Diátaxis framework, my posts tend to fall into the Tutorial and How-To Guide sections. I write about how I solve problems or understand concepts. How I apply learnings or reach goals. This way, I can test my skills and maybe help someone else along the way.

I like a good run on the roads, towpaths and dirt tracks of South Manchester. I’ve also been a dance music fan since the 2000s, and an Indie fan prior. I enjoy time in the garden, from planting and pruning in Summer to upkeep and clearing in Winter. I like the odd autobiography and psychology book, and I’m also Dog Dad to Havoc The Belgian Malinois and Wolfie the German Shepherd.

Qualifications:
3x AWS Certified
4x Azure Certified
2023 New Star Of Data

https://amazonwebshark.com/about/

Area of Expertise

  • Information & Communications Technology
  • Finance & Banking
  • Media & Information

Racing Towards Insights: Analysing the Sale Sizzler 5k Series with VSCode Data Wrangler And Power BI

In this session, I explore the capabilities of the Visual Studio Code Data Wrangler extension and Microsoft Power BI using real results from the Sale Sizzler 5k race series. I'll uncover valuable insights through engaging visualisations and user-friendly and low-code data transformations.

This session will cover the following key steps:

- Discovering the convenience of the Visual Studio Code Data Wrangler extension for effortlessly transforming and cleaning the race results

- Taking a closer look at the Python code generated by Data Wrangler to understand what's happening behind the scenes.

- Loading the transformed race results into Power BI to generate informative visualisations and analyse trends.

Join me if you're a data professional, a budding analyst or a sports enthusiast!

SELECT [AWS] FROM [SQL Server Management Studio]

The modern data professional navigates a diverse data landscape, dealing with object stores, serverful and serverless data and relational and non-relational databases.

Having this variety of cloud data services is great, but accessing them can be challenging. And what if these services are outside Azure?

In this 60 minute L300 session, I explore various AWS services and their integration with SQL Server Management Studio (SSMS).

Firstly, I'll examine some common AWS data services. Then we'll access my AWS account and I'll show the full process of linking Amazon Athena to SSMS.

This section includes:

- An introduction to Amazon Athena.
- Configuring the Athena ODBC driver.
- Handling authentication through AWS IAM.
- Setting up a Linked Server in SSMS.
- Running some queries!

Join me if you grapple with accessing data in AWS, are an SSMS user curious about its integration with AWS, or have limited experience with Linked Servers and want to see them in action!

Damien Jones

UK Data Engineer | Creator at amazonwebshark.com | Fin Fan | Dog Dad | He/Him

Manchester, United Kingdom