Upcoming Events

UK Azure Group, SQL Midlands edition

  • Thursday, February 9, 2017
  • 6:30pm 7:30pm
  • Aston Manor Academy

 

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

 

Power BI for the CEO

  • Thu, Apr 6, 20179:00am Sun, Jun 4, 201712:59am
  • The International Centre

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.

Data Visualisation Lies and How to Spot them Techorama

  • Mon, May 22, 20179:00am Wed, May 24, 20175:00pm
  • Kinepolis

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.

Taming the Open Source Beast with Azure for Business Intelligence

  • Saturday, June 17, 2017
  • 9:00am 5:00pm
  • Trinity College, College Green, Dublin 2,

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.

Data Acumen – Analytics Literacy in a Data-Driven world

I am sharing this blog by Richard Lee The video of his interview is below. I agree that data literacy has to be part of any leadership conversation.

We talk about data in terms of technology, and this is usually how customers approach me. I agree with Richard’s insight that it has to be recast as a business problem solving venture with an emphasis on data acumen as well as business acumen.

In this era of ‘alternate facts’, ‘post-truth’ our need for data acumen will become a necessary part of business acumen.

Enough of my thoughts; I will let Richard speak, and you can read his insightful blog post below.

Preface: I did not write a formal posting on the Data for Policy confab this past September, but wanted to at least share the materials that I presented and discussed during the conference. Abstract: The notion of Data-driven Policy making and its associated Governance, is often challenged by the fact that the vast majority of Politicians, […]

via You can’t have Data-driven Policy if your Leaders are Analytics Illiterate” — infomgmtexec

Why UK Power BI Summit? Derive business value from your data

I’ve created UK Power BI Summit in response to an industry need for Power BI to have its own event, and I hope to produce a repeatable model for other Power BI groups globally. I am working with Microsoft in Redmond at the moment, in the hope that I can spread the world globally about the power of enabling businesses through data, via easily-accessible tools.

What’s the rationale? Personally, the next step in my career is to continue my trajectory from the data center towards boardroom level leadership and consultancy, in order to help organisations become 21st century, data-driven organisations. Data is at the foundation of businesses. Data, in turn, leads to insights and better decisions that improve the business. Ideally, businesses should have data as part of their DNA. This does not mean that there is not a place for context or for ‘gut instinct’. Data gives businesses new insights, and, in turn, it gives them new options.

tumblr_lxrqzlzskr1qdo62to1_500

My favourite bookshop in the world: The Strand Bookstore, New York, on the corner of Broadway and E 12th Street.

With my business and technical skills in mind, I am doing my MBA at this stage in my career to focus on building businesses as data-driven organisations. The MBA will help me to combine my technical and business expertise within an established framework that will help me to be more effective in a leadership role. I believe that the MBA will help me to articulate and achieve a strategic viewpoint, which, in turn, will help businesses to use their data more effectively.

I am not alone in this data-driven journey. My industry experience tells me that many organisations suffer from one thing: hype about the possibilities and opportunities in data, and, particularly Big Data, but they don’t know how to get started in terms of technology, people, and enabling business processes that would consume these services.

Organisations can find it difficult to know where to start, or even how to start. Very often, businesses simply store all of their data, rather than think proactively about the data that they have, and how they could use it. As businesses continue to get excited about the opportunities of Big Data, they will also need Data Thought Leadership in order to guide them effectively towards success.

Digital Transformation is a much bandied about term. It isn’t simply whacking a few Virtual Machines in Azure, moving data to the cloud and – yay – digital transformation. It’s about transforming the business through the use of technology, and it has the business at the front-and-center of the activity.

Now is the time for businesses to bring their data and their strategy together, using the latest technologies – but they can’t do that, until they see their data. This is where Power BI come in.

Processed with VSCOcam with hb2 preset

The Power BI event is aimed at those people in the organisation who are aware of business needs, user needs, and have winning ideas and who are willing to learn about user-oriented technology to make that happen. The event is aimed at helping these people to learn about the technology from beginner to advanced, according to their needs.

Although the event is about technology, it’s also about the business, and deriving business value from your data. It’s not a straightforward technology event. It’s about the business as well as the technology, and how it’s used. It’s about bringing you along the journey, further.

I thought that the difference between UK Power BI Summit and other events such as PASS SQLSaturday events, SQLBits were fairly clear, but it would seem from my email traffic that my assumption wasn’t correct.

Just to be clear:

  • I am not part of the SQLBits committee and I have nothing to do with their leadership. I don’t represent them and I’m not featured on their promotional video. I’ve been speaking there since SQLBits 7 through to SQLBits XV. You can look for my SQLBits 7 – 15 sessions here.
  • I am part of PASS and a non executive Director, and I sit on the PASS Board as an elected Director. I don’t represent PASS here. If you want a PASS-validated blog, then please head over to their site. This isn’t a PASS event.

Let’s look at the SQLBits mission statement, taken from their site:

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite. There is a breadth of knowledge in the SQL Community that will benefit everyone in the community. We want to spread that knowledge. We all work with the SQL community, some of us for many years and have all been given the MVP award by Microsoft.

Let’s look at the PASS Mission Statement, taken from their site:

PASS is an independent, not-for-profit organization run by and for the community. With a growing membership of more than 100K, PASS supports data professionals throughout the world who use the Microsoft data platform.

PASS strives to fulfill its mission by:

  • Facilitating member networking and the exchange of information through our local and virtual chapters, online events, local and regional events, and international conferences
  • Delivering high-quality, timely, technical content for in-depth learning and professional development

PASS was co-founded by CA Technologies and Microsoft Corporation in 1999 to promote and educate SQL Server users around the world. Since its founding, PASS has expanded globally and diversified its membership to embrace professionals using any Microsoft data technology.

So, the UK Power BI Summit is ultimately looking at using Power BI to transform businesses, through expertise in the technology, embedded in business-oriented discussions. The technology should support the business in its mission to adapt to the new world of data.

If you’d like to register, click below:

Eventbrite - UK Power BI Summit

UK Power BI Summit

I’m very proud to say that I’m the lead organiser for the UK Power BI Summit, held on 16th and 17th February! I’d like to thank Microsoft and Pyramid Analytic for their support of the event; it wouldn’t happen without them.

Need help on Power BI, or just to know how to get started throughout the organisation? What about Cortana – how can it be useful for your organisation?

Come and join Siva Harinath and Will Thompson, flying in from Microsoft’s Power BI Team in Redmond, to join us in the UK for the inaugural UK Power BI Summit! Siva and Will are delivering the keynote and also delivering a workshop on Advanced Power BI with Data Modelling.

When: 16th and 17th February 2017 

Where: Shendish Manor, Hemel Hempstead.

Cost: of the event is £120 inclusive of VAT. Click here to register and pay for UK Power BI Summit

 

A choice of hands-on workshop on Thursday 16th February:

  • AzureML and Cortana OR
  • Advanced Power BI with Data Modelling

AND

  • A choice of general conference sessions on Friday 17th February
  • Birds of a Feather roundtable discussions on Friday 17th February

See you there!

Click here to register and pay for UK Power BI Summit

Review: Mathenauts: Tales of Mathematical Wonder

Mathenauts: Tales of Mathematical Wonder
Mathenauts: Tales of Mathematical Wonder by Rudy Rucker

My rating: 5 of 5 stars

I read this book years ago, and it has stayed with me. I was lucky enough to find a copy for 50p in a bookshop close to the University of Glasgow, and it’s stayed with me for about twenty years. It’s been part of my life.
Although it has topics like Goedel’s Theorem, fourth dimension, the liar paradox (“This sentence is false.”) and even fun wordplays, you don’t have to be a maths genius to read, understand and enjoy this book. You’ll read accessible and intriguing fiction stories which will ignite your imagination, and your interest in maths. You’ll absorb these topics better.
Since the book has a series of short stories, you’ll find, naturally, that some speak to you more than others. Isaac Asimov’s story has stayed with me, in particular – I won’t spoil it for you.

View all my reviews

PASS Business Analytics Day, Jan 11, Chicago

pass-ba-day

PASS’ first Business Analytics Day, which will be held in Chicago on January 11, 2017. You can choose one of two full-day, in-depth sessions for $595: In-Database Analytics with R and SQL Server 2016 and Mastering Power BI Solutions.

These are unique learning opportunities to get more advanced in R or data visualization with Power BI. And as with other PASS events, the goal is to allow you to walk away with real-world analytics knowledge that you can use immediately!

PASS Business Analytics Day

You have two great choices: In-Database Analytics with R and SQL Server 2016 and Mastering Power BI Solutions.

In-Database Analytics with R and SQL Server 2016

With Microsoft SQL Server 2016, data scientists can run in-database analytics using R. This is a “best of both worlds” scenario: delegate database management to SQL Server whilst you create analytics and visualisations in R and Power BI. In this session, we will cover the overall architecture of SQL R Services and go over some best practices. We will look at best practices in analytics and visualisations with a focus on R, and then we delve more in-depth into some practical common use-cases.

Speakers:
David Smith, R Community Lead at Revolution Analytics, a Microsoft Company
Seth Mottaghinejad, Data Scientist, Microsoft

Mastering Power BI Solutions

In this Power BI hands-on Workshop, you will master the “power” of Power BI. Learn to use self-service and enterprise-scale Power BI capabilities; gain valuable skills to integrate, wrangle, shape and visualize data for analysis. Beginning and intermediate level users will learn to address data and reporting challenges with advanced design techniques.

Speaker:
Paul Turley, Mentor with SolidQ, BI Architect, and Microsoft Data Platform MVP

Date: January 11, 2017

Location: Microsoft Technology Center, #200 – 200 East Randolph Drive, Chicago, IL.

We hope you’ll join us!

Business Analytics Webinar Marathon announced!

31060117291_46e25da6d4_kJoin PASS on 14th December for our next bumper edition of the Business Analytics (BA) Marathon on Wednesday, December 14. We have six back-to-back sessions, all about analytics. Why not challenge yourself to attend all six?

If you want to learn R, predictive analytics, or learn about business analytics generally, then join our industry experts for six back-to-back webinars.

Each webinar lasts for an hour, and they start at 17:00 GMT. Check the time in your own timezone here

Webinar Date: Wed December 14, 2016

Start time: 17:00 GMT ¦ Check the time in your own timezone here

Session 1: Analyzing Healthcare Open Data with Power BI
Dan English, Senior Data Warehouse Architect, Constellation

Session 2: Big Data Analytics with SparkR
Jen Underwood, Founder of Impact Analytix, LLC

Session 3: Disrupt the Static Nature of BI with Predictive Anomaly Detection
Uri Maoz, Vice President of US business, Anodot

Session 4: Using R to Clean and Transform Small Data
Mark Wilcock, Technical Delivery Manager, ‎Credit Suisse

Session 5: Visualizing Multiple Time Series with R in Power BI
Bill McLellan, BI Team Lead and Sr. BI Solutions Specialist, TKC Holdings

Session 6: Real-World Predictive Analytics
Miguel Molina-Cosculluela, Managing Partner & Analytics Evangelist, Analytikus
Diwakar Rajagopal, Senior Director of Partnerships, Pyramid Analytics

See you there!