Welcome to the London PASS Chapter

We are an established PASS Chapter covering London. 

We look forward to meeting you! To contact us, please visit the About Us page. 

Please find details of the next meeting below.

Registration for the event via following links

http://www.meetup.com/London-SQL-Server-User-Group/

SQL London PASS Chapter Team

Next Meeting

Monday,

March

07

PASS SQL London Chapter (7th Mar 2016)

  • In-Person @ CodeNode (Skillsmatter) London, Greater London, United Kingdom (map)
  • 18:00 - 20:30 UTC
  • Language: English

Hello Member

PASS London Chapter March 2016 Event 

IMPORTANT: Please ensure that you also DO REGISTER via the following link; as we need to provide the details of who's attending with skills matter team for security badges

https://skillsmatter.com/meetups/7812-visualising-financial-risk-using-power-bi-and-warehouse-of-the-future-lakes-vs-marts

Holding this @ the awesome Skillsmatter CodeNode venue again, experience their Escape Bar and breakout areas following the meeting sessions for some food, games and networking 

The evening programme starts  @ 6:15 PM but, come and socialize from 6:00 PM @ CodeNode and we’ll  have 2 hours of the quality session's for you to learn from the leading experts in the industry followed by food, drink and networking and maybe even some SWAG, Why not bring a friend or colleague as we will be having NEW members only raffle as well that evening

The session's at this meeting will be

Warehouse of the Future: Lakes Vs Marts

It's time to face the fact that Data Warehouses, as we know them, are changing. The increasing power of automatically scaling systems and the rapidly dropping cost of storage are challenging how we decide which data to keep and how we push it out to those who need it. In this session we'll run through the architecture of the modern warehouse, from our structured/unstructured Azure Data Lake architecture to our platform as a service Azure Data Warehouse and the various tools bringing the two together. Expect a general overview of these new Azure components, a little BI theory and practical demonstrations of setting up Data Lake, writing U-SQL, linking up Data Warehouse and exposing data to users, all from the ground up (demo gods permitting) 

Simon Whiteley

Principal BI Consultant with Adatis. Simon has been working with the Microsoft BI Stack for a decade, starting off building traditional warehouses with SSIS and SSAS but bringing in alternative technologies where needed. Simon is a strong advocate of the use of modern development practices in the SQL World (we actually are developers, whether we like it or not). Most recently, he has turned his head to the clouds, advocating new methods of getting insight to the right people. Whether it's getting to grips with Data Lakes, to shifting your current SSIS packages into the cloud, hopefully he can help.

Visualising Financial Risk Using Power BI

Banks trading and lending activities generates millions of valuations of trades and positions and risk measures, and prices of foreign exchange, shares and bonds. Managers need to make fast decisions every day on this data and they need powerful interactive dashboards to help them make sense of it This talk will show lots of examples of useful visualisations of financial risks. For example tree-maps show the composition of risk within the bank and across countries, asset classes. Bar charts coupled with slicers can drill down from the firm wide big picture to trading details. Bullet charts show usage against limits and daily changes. These examples will highlight some of the capabilities of Power BI and other visualisation tools including custom visualisations, integration with R, various ways of loading and editing data, calculations and tailoring the interactions between visual elements.

Mark Wilcock 

Mark Wilcock builds cubes, dashboards and reports of financial data. He is the organiser of a popular community data & analytics group called the London Business Analytics Group

We are looking forward to seeing you at the Chapter event

PASS London Chapter Team

Featured Presentation:

Warehouse of the Future: Lakes Vs Marts

Simon Whiteley, Chief Cloud Architect Adatis Consulting

It's time to face the fact that Data Warehouses, as we know them, are changing. The increasing power of automatically scaling systems and the rapidly dropping cost of storage are challenging how we decide which data to keep and how we push it out to those who need it. In this session we'll run through the architecture of the modern warehouse, from our structured/unstructured Azure Data Lake architecture to our platform as a service Azure Data Warehouse and the various tools bringing the two together. Expect a general overview of these new Azure components, a little BI theory and practical demonstrations of setting up Data Lake, writing U-SQL, linking up Data Warehouse and exposing data to users, all from the ground up (demo gods permitting)

About Simon:
Coming from a world of traditional BI structures, Simon is now obsessed with utilising cloud technologies to revolutionise these traditions. He will dive into any interesting BI problem, whether its ETL patterns, analysis models or building custom D3 visualisations. His main focus is harnessing Lambda patterns in modern cloud architectures!

Visualising Financial Risk Using Power BI

Mark Wilcock, Independent Consultant

Banks trading and lending activities generates millions of valuations of trades and positions and risk measures, and prices of foreign exchange, shares and bonds. Managers need to make fast decisions every day on this data and they need powerful interactive dashboards to help them make sense of it This talk will show lots of examples of useful visualisations of financial risks. For example tree-maps show the composition of risk within the bank and across countries, asset classes. Bar charts coupled with slicers can drill down from the firm wide big picture to trading details. Bullet charts show usage against limits and daily changes. These examples will highlight some of the capabilities of Power BI and other visualisation tools including custom visualisations, integration with R, various ways of loading and editing data, calculations and tailoring the interactions between visual elements.

About Mark:
Mark is an independent consultant specializing in the analysis, reporting and visualization of financial data. Over the last 20 years, he worked on many systems to measure and monitor financial performance and manage market risks that arise from banking and trading activities. He's the organizer of the London Business Analytics Group, a popular community group that holds monthly talks on topics ranging from Predictive Analytics to Power Query to Personalized Medicine. He blogs at zomalex.co.uk

cage-aids
cage-aids
cage-aids
cage-aids