Artificial Intelligence mentoring with Teens in AI on 2-3 June
Jun
2
to Jun 3

Artificial Intelligence mentoring with Teens in AI on 2-3 June

Excited to be a #mentor at @TeensInAI's #AI Bootcamp & Hackathon. Still places left at the #Hackathon with code ACORNFSM free for kids on free school meals and ACORN80@ gives 80% off - come learn about AI with top industry mentors @MSFTReactor 2-3 June: teensinai.splashthat.com

View Event →
Data Analytics with Azure Cosmos Schema-less Data and Power BI
Apr
26
3:00 PM15:00

Data Analytics with Azure Cosmos Schema-less Data and Power BI

Good news for Developers and Data Analysts; it’s possible to have rapid application development and analytics with the same data source, using Azure Cosmos DB and Power BI. 
Azure Cosmos DB is a schemaless database, so how is it possible to analyse and create reports of the data for analytics and Business Intelligence tools? A single Azure Cosmos DB database is great for rapid application development because it can contain JSON documents of various structures, but this needs careful data visualization. In this session, we will analyze and create reports of Azure Cosmos data using Power BI, looking at data from both developer and data analyst aspects. 
In this demo-rich session, you will learn about Azure Cosmos, understand its use cases, and see how to work with data in a schemaless Azure Cosmos database for Power BI. 

View Event →
R in Power BI for Absolute Beginners
Apr
24
4:00 PM16:00

R in Power BI for Absolute Beginners

In this session, we will start R right from the beginning, from installing R through to data transformation and integration, through to visualizing data by using R in Power BI. Then, we will move towards powerful but simple to use datatypes in R such as data frames. We will also upgrade our data analysis skills by looking at R data transformation using a powerful set of tools to make things simple: the tidyverse. 

View Event →
Data and BI Summit #PowerBI event in Dublin
Apr
24
to Apr 26

Data and BI Summit #PowerBI event in Dublin

I'll be speaking but I will release details of my session when it's made public.

What to expect at the Data & BI Summit:

  • Exceptional, quality content: Learn how to bring your company through the digital transformation by gaining new understandings of your data and deepening your knowledge of the Microsoft Business Intelligence tools. Products will include: Power BI, PowerApps, Flow, SQL Server, Excel, Azure, D365 and more! 
  • Answers to your questions: Network with the Microsoft Power BI team, dig-in onsite to find immediate answers with industry experts, Data MVPs, and User Group Leaders while taking advantage of the opportunity to engage in interactive sessions, workshops and labs.
  • Network with your peers: Enjoy countless opportunities to create lasting relationships by connecting and networking with user group peers, partners and Microsoft team members.
  • Stretch your skill set: Advance your career by learning the latest updates and how they can help you and your business.

 

 

 

 

View Event →
Working with Business Data for Executives in #PowerBI
Mar
23
8:30 AM08:30

Working with Business Data for Executives in #PowerBI

ata can help Executives understand the internal and external pressures on the organisation, and use numbers to help you move past the tipping point and grow out and forward into the next phase of your business. Your data will help you to see the ‘blanks’ as well as what really matters to the organization

This workshop is not a technical session in disguise as a session that talks to business people. It is a business-oriented session for business people who want to make data-driven decisions and understand their business better, using their data. This session will help you to be your own Data Shaman – or empower one of your team to give you the data that you really need, with the C-suite in mind.

It is difficult for busy Executives to allocate time to the collection, cultivation and analysis of data. Ideally, it should be done by a team member who gives the Executive the data that they need, in the way that they need it. Executives need to focus on strategic decisions, and they need good data to run their business and support the right decisions..

Your data may even surprise you, which is why our vision is to help you to ‘Relish your Data’.

Power BI can help to bring clarity and predictability to the Executive, and this session is aimed at CEOs, and those who support them with data, in order to see how they can be empowered by Power BI, and see data as a key asset within the organisations short and long term future. You will also learn about new functionality in Excel that you probably didn’t know was there, to help you to work with dirty data better.

The C-Suite compass by numbers

We will also look at the business-oriented metrics and numbers that the C-suite need to run their business.This will help the business to know whether their strategies are working, or to know more about the health and direction of the business.

Who is this session for?

Join this session if you are an Executive now, or if you support an Executive in the organisation, and you need to understand better how to manage, clean, integrate and create reports from your data. Join us to learn tips, tricks and little known features to do it quickly and well. It’s possible you’ve been using Excel for years, but perhaps not in the best way and that’s why it is so hard.

Agenda:

8:45 Check-in

9:00 Overview
– The Microsoft Suite: Power Pivot, Power BI and Excel

9:30 Loading Data
– Various Methods
– Tradeoffs
– Best Practices

10:30 1st Break

10:45 Calculations, Formulas and DAX using Power Pivot for Excel
– Working with multiple data sources
– Table Overview: Data Tables, Lookup Tables
– Measuring your Business: Measuring efficiently
– Doing better than VLOOKUP
– Compare and Contrast – basics of analytics
– What If Analysis – examples of what you can do

12:30 Lunch

1:00 Power BI Data Visualisation
– What does Power BI Give you?
– The Power BI Service – cloud for small companies: sharing, analysis, mobilising your solution.

3:00 Break

3:15 Metrics to Measure your Business
– Revenue Growth: Linear and exponential
– KPIs – show your actuals and targets
– Employee Engagement
– Time Intelligence
– Profit measurements
– Expenses

4:45 Q and A

Jen Stirrup, Data Whisperer and lead of Data Relish Ltd

Jen has been in the IT industry for 20 years, successfully delivering global projects in Artificial Intelligence and Business Intelligence. Jen has settled in Hertfordshire, and as well as leading Data Relish Ltd, Jen is doing the Executive MBA at the University of Hertfordshire Business School, Jen has also been a NED (Non Executive Director) for PASS, who are based in the United States. As Jen has been spending time leading organisations, she is keen to share her knowledge and expertise with the community from a data-driven, data leader perspective.

Jen Stirrup, recently named as one of the top 9 most influential Business Intelligence female experts in the world by Solutions Review, is a Microsoft Data Platform MVP, and PASS Director-At-Large, is a well-known Business Intelligence and Data Visualization expert, author, data strategist, and community advocate who has been peer-recognized as one of the top 100 most global influential tweeters on Big Data and Analytics topics. Jen has featured as a role model MVP by the Microsoft MVP Program, featured on a dedicated page of the MVP website.

Jen has presented worldwide, who was honoured with her career highlight in delivering a demo as part of the PASS 2016 keynotewith Joseph Sirosh, with a demo on mapping Pokemon using AzureML, R, PowerBI and Azure SQL Database!

As the sole owner of a boutique Data Science and Business Intelligence consultancy, Jen has delivered varied projects which including leading organisations such as the NHS Trustsand private companies to the cloud, whilst also spearheading a Data Science Program from soup-to-nuts for a Government department.

View Event →
SQLBits Advanced Techniques for Cleaning Data using SQL Server 2017
Feb
24
8:15 AM08:15

SQLBits Advanced Techniques for Cleaning Data using SQL Server 2017

If your organisation doesn't have dirty data, it's because you are not looking hard enough. how do you tackle dirty data for your business intelligence projects, data warehousing projects, or your data science projects?

In this session, we will examine ways of cleaning up dirty customer data using the following technologies in SQL Server 2017 such as:
 

  • R
  • Python
  • AzureML and Machine Learning
  • SSIS


We will also examine techniques for cleaning data with artificial intelligence and advanced computing such as knowledge-based systems and using algorithms such as Levenshtein distance and its various implementations.

Join this session to examine your options regarding what you can do to clean up your data properly.

View Event →
#Live360 Orlando Lighting up #BigData #Analytics with #ApacheSpark in Azure
Nov
16
1:00 PM13:00

#Live360 Orlando Lighting up #BigData #Analytics with #ApacheSpark in Azure

Today, CIOs and other business decision-makers are increasingly recognizing the value of open source software and Azure cloud computing for the enterprise, as a way of driving down costs whilst delivering enterprise capabilities.
For the Business Intelligence professional, how can you introduce Open Source for analytics into the Enterprise in a robust way, whilst also creating an architecture that accommodates cloud, on-premise and hybrid architectures?

We will examine strategies for using open source technologies to improve existing common Business Intelligence issues, using Apache Spark as our backdrop to delivering open source Big Data analytics.

- incorporating Apache Spark into your existing projects
- looking at your choices to parallelize Apache Spark your computations across nodes of a Hadoop cluster
- how ScaleR works with Spark
- Using Sparkly and SparkR within a ScaleR workflow

Join this session to learn more about open source with Apache Spark in Azure for Business Intelligence. Open Source does not mean on premise.
Demos will provide practical takeaways in your Business Intelligence Enterprise architecture with open source in mind.
 

View Event →
SQW11 - Big Data Smorgasbord with R in Hadoop and SQL Server - Jen Stirrup
Nov
15
4:00 PM16:00

SQW11 - Big Data Smorgasbord with R in Hadoop and SQL Server - Jen Stirrup

Join this session for advanced expertise in R options for SQL Server for Big Data. We will look at:

  • Intro to R in SQL Server and Hadoop
  • Choosing and deploying predictive modelling for SQL Server
  • Using Microsoft R Server as a Hadoop Client
  • HDFS operations with rxHadoop helper functions
  • Compute Contexts in SQL Server and Hadoop for delivering faster analytics
  • Using ScaleR functions with Hadoop on a Map/Reduce cluster for analytics
View Event →
Fast Focus: Python Essentials for C# Devs
Nov
14
5:10 PM17:10

Fast Focus: Python Essentials for C# Devs

Python has become extremely popular in the broader technology community, and it is a great way to get started in the world of data. If you are already a C# programmer, whether beginner or expert, Python is an easy-to-learn language that makes use of your existing skill set.              

In this demo-led session, we will look at Python in Visual Studio with some examples that will help you on your way to success with Python.  You’ll see how it hangs together, and we will look at some of the similarities and differences in both languages.

Why not join this session to get started in learning this increasingly popular language?

View Event →
Lighting up Big Data Analytics with Apache Spark in Azure
Oct
30
to Nov 3

Lighting up Big Data Analytics with Apache Spark in Azure

  • Washington State Convention Center (map)
  • Google Calendar ICS

We will examine strategies for using open source technologies to improve existing common Business Intelligence issues, using Apache Spark as our backdrop to delivering open source Big Data analytics.

- incorporating Apache Spark into your existing projects
- looking at your choices to parallelize Apache Spark your computations across nodes of a Hadoop cluster
- how ScaleR works with Spark
- Using Sparkly and SparkR within a ScaleR workflow

Join this session to learn more about open source with Azure for Business Intelligence.

View Event →
Open Source Cybersecurity with Power BI at #PowerBIWorldTourLondon
Aug
23
2:15 PM14:15

Open Source Cybersecurity with Power BI at #PowerBIWorldTourLondon

There are a range of open source, hybrid and proprietary Machine Learning projects that focus specifically on cybersecurity. There are open source packages in handling threat intelligence indicators such as the Combine package for Python, for example, and the TIQ Test for R.

In this topic, we will examine some of the metrics involved in cybersecurity, and visualize them using Power BI according to best practice principles for data visualisation.

View Event →
Jun
17
9:00 AM09:00

Taming the Open Source Beast with Azure for Business Intelligence

  • Trinity College, College Green, Dublin 2, (map)
  • Google Calendar ICS

Location: Trinity College, College Green, Dublin 2, Dublin, County Dublin, Dublin 2, Ireland

Register: https://www.sqlsaturday.com/620/registernow.aspx

Today, CIOs and other business decision-makers are increasingly recognizing the value of open source software and Azure cloud computing for the enterprise, as a way of driving down costs whilst delivering enterprise capabilities.

For the Business Intelligence professional, how can you introduce Open Source into the Enterprise in a robust way, whilst also creating an architecture that accommodates cloud, on-premise and hybrid architectures?

We will examine strategies for using open source technologies to improve existing common Business Intelligence issues, using Azure as our backdrop. These include:

- incorporating Apache projects, such as Apache Tika, for your BI solution
- using Redis Cache in Azure in as a engine as part of your SSIS toolkit

Join this session to learn more about open source in Azure for Business Intelligence. Open Source does not mean on premise.
Demos will provide practical takeaways in your Business Intelligence Enterprise architecture.

View Event →
Jun
12
to Jun 14

Microsoft Data Insights Summit - Digital Transformation using Power BI for your CEO

Update: the event is sold out, but you can join online here

Digital Transformation is a hot topic with CEOs and the C-level suite, renewing their interest in data and what it can do to empower the organization. With the right metrics and data visualization, Power BI can help to bring clarity and predictability to the CEO to make strategic decisions, understand how their customers behave, and measure what really matters to the organization. This session is aimed at helping your CEO with insightful dashboards in Power BI using visualization and metrics. Join this session to set up your organization in the short and long term success using Power BI and the right metrics.

View Event →
May
22
to May 24

Data Visualisation Lies and How to Spot them Techorama

Register: Buy Tickets

 

During the acrimonious US election, both sides used a combination of cherry-picked polls and misleading data visualization to paint different pictures with data. In this session, we will use a range of Microsoft Power BI and SSRS technologies in order to examine how people can mislead with data and how to fix it. We will also look at best practices with data visualisation. We will examine the data with Microsoft SSRS and Power BI so that you can see the differences and similarities in these reporting tools when selecting your own Data Visualisation toolkit. Whether you are a Trump supporter, a Clinton supporter or you don't really care, join this session to spot data lies better in order to make up your own mind.

View Event →
Apr
6
to Apr 8

Power BI for the CEO

  • The International Centre (map)
  • Google Calendar ICS

Date: Saturday 8th April, time to be determined

Location: The International Centre, St Quentin Gate, Telford, Shropshire, TF3 4JH

Register: http://sqlbits.com/information/registration.aspx

Digital Transformation is much more than just sticking a few Virtual Machines in the cloud; it is real, transformative, long-term change that benefits and impacts the whole organisation. 
Digital Transformation is a hot topic with CEOs and the C-level suite, renewing their interest in data and what it can do to empower the organisation.
With the right metrics and data visualisation, Power BI can help to bring clarity and predictability to the CEO to make strategic decisions, understand how their customers behave, and measure what really matters to the organization. This session is aimed at helping you to please your CEO with insightful dashboards in Power BI that are relevant to the CxO in your organisation, or your customers’ organisations.
Using data visualisation principles in Power BI, we will demonstrate how you can help the CEO by giving her the metrics she needs to develop a guiding philosophy based on data-driven leadership. Join this session to get practical advice on how you can help drive your organisation’s short and long term future, using data and Power BI.
As an MBA student and external consultant who delivers solutions worldwide, Jen has experience in advising CEO and C-level executives in terms of strategic and technical direction. 
Join this session to learn how to speak their language in order to meet their needs, and impress your CEO with proving it, using Power BI.

View Event →
Feb
9
6:30 PM18:30

UK Azure Group, SQL Midlands edition

 

To Register: https://www.eventbrite.co.uk/o/sql-midlands-6264475503

Implementing NHS Azure Hybrid Architectures

The NHS is undergoing a time of unprecedented change, as well as increasing financial pressure under a public microscope. In order to meet these challenging requirements, NHS South London and Maudsley is undergoing a Digital Transformation program which is fundamentally ultimately altering delivery of its healthcare services. The Digital Transformation is crucial to the success of the Trust, and it affects everything from the physical layer right up to self-service reporting. It is also an important balancing act between highly sensitive patient privacy in a world that expects data on-demand in mobile and external environments.

In this technical session, join us to learn from the expert team who architected, designed, and delivered the hybrid Azure cloud and SQL Server solution for NHS South London and Maudsley Trust. Learn about the technical constraints and challenges and how we overcame those challenges, particularly through a healthcare lens of highly-sensitive patient privacy issues in a world of data. You will also learn about the technical benefits that were gleaned from this hybrid implementation. In order to bring the achievements to life, you will see real-life insights into healthcare in a Power BI demo, in use by hospital team members.

Using Azure, SQL Server and Power BI means that the NHS is empowered to create enriched opportunities for research to improve patient outcomes, both now and in the future, as well as directly improved patient outcomes now. Join us for this technically-oriented session to see how Azure, SQL Server and Power BI joined forces to fundamentally deliver improved patient healthcare, research and insights in London.

To Register, visit http://www.sqlmidlands.com/events/48-9th-feb-2017-nhs-in-azure-data-factory-custom-activity.html 

 

View Event →