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!

Top 5 Signposts to deep technical expertise at PASS Summit 2016

PASS_Joseph_blog

How do you find deep technical expertise at PASS Summit 2016?

cuf9aznw8aarklgSignpost Number 1: Watch Joseph Sirosh’s Day One keynote.

Attend in person if you can, or watch the live stream on PASS TV if you can’t. The world around us – every business and nearly every industry – is being transformed by technology today, and SQL Server 2016 was built for this new world and to help businesses get ahead of today’s disruptions.
I am very excited about Joseph Sirosh’s keynote at PASS Summit since he will be making announcements… can’t say what… but you can be sure that there will be cutting-edge content around SQL Server 2016 to solve real-world problems. I’m in the PASS Summit 2016 keynote as well, helping with some things… to be announced! I’m extremely honoured.

 

Signpost Two: Want to learn in agile, small groups with the experts?  Microsoft have also added a new type of session called a Chalk Talk. These are Level 500 sessions with Microsoft senior program management hosting open Q&A in a collegiate style setting.  Seating is limited to 50 so you’ll want to get there early to claim your spot.

Signpost Three: Want in-depth, one-to-one help? SQL Clinic is the place to be. SQL Clinic is the hub of technical experts from SQLCAT, Tiger Team, CSS, and others. Whether you are looking for SQL Server deployment support, have a troublesome technical issue, or developing an application the experts at SQL Clinic will have the right advice for you.

Signpost Four: Want to know about anything SQL Server? Microsoft has also increased investment in sending employees onsite to talk with attendees.  They’ll be easy to spot – all 500 Microsoftees will be wearing bright fuchsia t-shirts.  You can find them in big numbers the Day 1 keynote, Microsoft booth, SQL Clinic, Wednesday’s Birds of a Feather luncheon, Thursday’s WIT luncheon, and of course in our big booth in the Expo Hall.

 

Signpost Five: Want Mobile Business Intelligence? SQL Server 2016 offers end-to-end mobile BI solutions on any device at a fraction of the cost of other vendors. Join me at my PASS Session on Wednesday 26th October at 1.30pm, called Mobile BI and Dataviz with SQL Server 2016, R, and PowerBI [Room BID-304] If you want a calendar entry for my session, please download here below.

Outlook Calendar Invite

That’s not all!  The full PASS Summit schedule is here. With SQL Server 2016 , Microsoft is positioned as an industry leader, and now packs an even bigger punch in the recent Gartner Magic Quadrant for Operational Database Management Systems. SQL Server 2016 builds on this leadership, and is packed with powerful built-in features.

I look forward to seeing you there!

 

Guess who is appearing in Joseph Sirosh’s PASS Keynote?

This girl! I am super excited and please allow me to have one little SQUUEEEEEEE! before I tell you what’s happening. Now, this is a lifetime achievement for me, and I cannot begin to tell you how absolutely and deeply honoured I am. I am still in shock!

I am working really hard on my demo and….. I am not going to tell you what it is. You’ll have to watch it. Ok, enough about me and all I’ll say is two things: it’s something that’s never been done at PASS Summit before and secondly, watch the keynote because there may be some discussion about….. I can’t tell you what… only that, it’s a must-watch, must-see, must do keynote event.

We are in a new world of Data and Joseph Sirosh and the team are leading the way. Watching the keynote will mean that you get the news as it happens, and it will help you to keep up with the changes. I do have some news about Dr David DeWitt’s Day Two keynote… so keep watching this space. Today I’d like to talk about the Day One keynote with the brilliant Joseph Sirosh, CVP of Microsoft’s Data Group.

Now, if you haven’t seen Joseph Sirosh present before, then you should. I’ve put some of his earlier sessions here and I recommend that you watch them.

Ignite Conference Session

MLDS Atlanta 2016 Keynote

I hear you asking… what am I doing in it? I’m keeping it a surprise! Well, if you read my earlier blog, you’ll know I transitioned from Artificial Intelligence into Business Intelligence and now I do a hybrid of AI and BI. As a Business Intelligence professional, my customers will ask me for advice when they can’t get the data that they want. Over the past few years, the ‘answer’ to their question has gone far, far beyond the usual on-premise SQL Server, Analysis Services, SSRS combo.

We are now in a new world of data. Join in the fun!

Customers sense that there is a new world of data. The ‘answer’ to the question Can you please help me with my data?‘ is complex, varied and it’s very much aimed at cost sensitivities, too. Often, customers struggle with data because they now have a Big Data problem, or a storage problem, or a data visualisation access problem. Azure is very neat because it can cope with all of these issues. Now, my projects are Business Intelligence and Business Analytics projects… but they are also ‘move data to the cloud’ projects in disguise, and that’s in response to the customer need. So if you are Business Intelligence professional, get enthusiastic about the cloud because it really empowers you with a new generation of exciting things you can do to please your users and data consumers.

As a BI or an analytics professional, cloud makes data more interesting and exciting. It means you can have a lot more data, in more shapes and sizes and access it in different ways. It also means that you can focus on what you are good at, and make your data estate even more interesting by augmenting it with cool features in Azure. For example, you could add in more exciting things such as Apache Tika library as a worker role in Azure to crack through PDFs and do interesting things with the data in there. If you bring it into SSIS, then you can tear it up and down again when you don’t need it.

I’d go as far as to say that, if you are in Business Intelligence at the moment, you will need to learn about cloud sooner or later. Eventually, you’re going to run into Big Data issues. Alternatively, your end consumers are going to want their data on a mobile device, and you will want easy solutions to deliver it to them. Customers are interested in analytics and the new world of data and you will need to hop on the Azure bus to be a part of it.

The truth is; Joseph Sirosh’s keynotes always contain amazing demos. (No pressure, Jen, no pressure….. ) Now, it’s important to note that these demos are not ‘smoke and mirrors’….

The future is here, now. You can have this technology too.

It doesn’t take much to get started, and it’s not too far removed from what you have in your organisation. AzureML and Power BI have literally hundreds of examples. I learned AzureML looking at the following book by Wee-Hyong Tok and others, so why not download a free book sample?

https://read.amazon.co.uk/kp/card?asin=B00MBL261W&preview=inline&linkCode=kpe&ref_=cm_sw_r_kb_dp_c54ayb2VHWST4

How do you proceed? Well, why not try a little homespun POC with some of your own data to learn about it, and then show your boss. I don’t know about you but I learn by breaking things, and I break things all the time when I’m  learning. You could download some Power BI workbooks, use the sample data and then try to recreate them, for example. Or, why not look at the community R Gallery and try to play with the scripts. you broke something? no problem! Just download a fresh copy and try again. You’ll get further next time.

I hope to see you at the PASS keynote! To register, click here: http://www.sqlpass.org/summit/2016/Sessions/Keynotes.aspx 

5 Things I need you to do if you want me to nominate you for an MVP Award

mvp_logo

It’s great to see so many people want to participate in the MVP Program. I find that I’m being asked fairly frequently at the moment – say, a couple of times a week – by community individuals if I will nominate them.

Here are some disclaimers:

  • I have no influence over the MVP Program at all
  • I consider myself lucky to be part of the Program. It is a gift, not an entitlement, and it can be gone at any time.
  • The people who nominated me were not my friends, apart from one person (thank you Andrew!). These were generous people who gave their time to nominate me, and it turns out I was nominated by a lot of people, over a period of time, before I got the Award.

I tend to be happy to nominate people if they ask me; after all, it’s not my decision and it may be good for the Program as well as the individual. From my experience, it wasn’t my community ‘friends’ who nominated me, it was people who didn’t know me very well but they could see that I was making a positive difference in the community. I see the MVP Award as a ‘golden ticket’ to do even more positive things for the community; it is about being other-centered, and not self-centered, I think.

OutliersI don’t see that I am an expert now I’ve been given an Award. Throughout his book Outliers, Gladwell repeatedly mentions the “10,000-Hour Rule”, claiming that the key to achieving world class expertise in any skill, is, to a large extent, a matter of practicing the correct way, for a total of around 10,000 hours. What he doesn’t say is the next step: the world is moving so fast, you have to keep working all the time to stay on top. So that means that other things sometimes have to be let go.

My brother, a wise man, once told me that ‘it’s lonely at the top’ when I complained about the number of ‘real’ friends I’d lost, particularly over the past two years. Although I don’t see myself at the top of anything (unless it is a complete mess) I see that, sometimes, other people do; and that’s why they ask for the nomination. If I can inspire someone to do good things for the community, then that’s a good thing for me. In fact, leaders should leave a plan and a structure behind them in their trail; good leaders look at what they leave behind them, as well as looking far forward into the future.

I do nominate people myself, and sometimes I’m lucky that they get the Award after one or more nominations e.g. Stephanie Locke, Mark Wilcock, Ryan Adams and Mark Broadbent, but sometimes I nominate and it doesn’t happen for the nominee. I do try to nominate people who I can see are in my ‘trail’ and hopefully, if anything, my life will serve as a cautionary tale and a ‘teachable moment’ for others.

So, what do I need you to do for me? Tell me, in your own words:

  1. Your community activities. Please list them out for me. Don’t assume that I know. I don’t remember what I did, last week. I certainly will have very little clue what you did, even if you were with me.
  2. What you think you’d contribute to community life for Microsoft, their product groups, and the people who work at Microsoft. They are people too and I love most of the ones that I come across. Be generous with your time with Microsoft people too; don’t assume that, because they work for a massive company, that they aren’t under pressure or really busy. Trust me. They are. Don’t criticise without offering to help first.
  3. The area of expertise you think you bring to the MVP Program. I know we are all Data Platform these days, but it makes things simple.
  4. What would you like to do for the Program?
  5. Tell me more about you. Help me to find a thread that makes you unique, and stand out a little.

I know it seems a lot. I’m busy and i need help filling out the form, and I want to do a good job for you. If you can’t be bothered to give me these things, well, you can’t really expect me to spend hours collating all of this information for you! I can tweak it so it’s good English (for example) but you will help me a lot of if you can be your own voice. I don’t want to miss something out, because I forgot to put something in.

What you could do in return; say thanks to me, ask other people to nominate you too, and, most of all, nominate people yourself. Be generous with your time.

Help me to help you.
Image from page 311 of "Greek athletic sports and festivals" (1910)

See you in Paris? Presenting at SQLSaturday Paris?

Fancy joining me in Paris? 25th June, I’ll be there! The details are below.It’s the place to be, to learn Microsoft Data Platform technologies e.g. Azure, Power BI, SQL Server – and there’s a range of sessions for beginners to experts. Register here – http://www.sqlsaturday.com/510/eventhome.aspx 

Also, a big Thank You to the SQLSaturday Paris team for having me along again. They always do a professional, world-class job of organising the event. Contact Jean-Pierre Riehl for more information ( twitter and GUSS site  )

They are also offering workshops and here’s the information for you to check out. Kevin Kline‘s session will be in English.

unnamed

I will be attending Marco Russo’s session on DAX, Markus Ehrermueller-Jensen‘s session on data visualisation, Isabelle Van Campenhoudt and Serge Luca‘s session on Power BI, Kevin Kline’s session on Troubleshooting, and then I’ll be presenting on Cortana Analytics.

L’agenda

SQLSatParis Agenda

20 sessions, 25 experts internationaux
http://www.sqlsaturday.com/510/Sessions/Schedule.aspx

Le SQLSaturday, c’est LA conférence technique internationale de l’année. Avec plus de 25 speakers de 10 nationalités, vous retrouvez le meilleur des technologies Data de Microsoft : SQL Server, Power BI, Azure, deep dive, etc.

Les préconférences

Cette année, les préconférences sont de retour. Imaginez passer la journée entière avec un expert internationalement reconnu pour creuser un sujet particulier ? A mi-chemin entre la formation et la conférence, les préconférences vous permettent de découvrir en profondeur une technologies ou un savoir-faire.

Les premiers sponsors du SQLSaturday Paris

Microsoft, Pyramid AnalyticsData by Design, Jobly, AZEO, DCube et SUPINFO Paris.

Vous pouvez devenir sponsor en nous contactant: sponsors@guss.pro ou en passant par le site de l’événement: https://www.sqlsaturday.com/510/Sponsors/SponsorSignup.aspx

Jen’s PASS Diary: SQLSaturday Edinburgh: My heartfelt thanks go to…

SQLSaturday Edinburgh went ahead last Saturday, June 13th, and everyone had a great day. It’s clear that people in the community believe in what I am doing. They voted with their feet to attend, to speak, and to sponsor. We had high quality speakers delivering world-class content – 8 MVPs, 2 Microsoft staff, and the remainder are international speakers – and we know that Content is King.

Basically, SQLSaturday Edinburgh Business Intelligence edition was the turning point for the Business Analytics and Business Intelligence ( SQL Server based ) community in the UK.

  • Our event only had five people who had spoken at SQLBits (Carmel Gunn, Bob Duffy, Gary Short, Chris Webb and Satya Jayanty).
  • three of our speakers (Mark Wilcock, Chris Webb and Bob Phillips) all spoke at PASS Business Analytics Conference last April in San Jose, and they all spoke at PASS SQLSaturday London Business Analytics in November 2014.
  • The other speakers have delivered sessions internationally in their field of expertise: Visio, SharePoint, CRM, and this was the first time they’d spoken at a SQL event.

We tried to be more BI and BA focused, and did it work? The feedback so far is a resounding YES. We didn’t try to squeeze the formula for other SQL events onto this one, jam some R in there, and announce it as an analytics event. The content was focused on what we do with data, why, and what the business value is.There will be more on this in future posts. In the meantime, however, I have a lot of thank yous!

I also want to say a heartfelt thank you to the volunteers, without whom, the event would not have happened.

  • Malcolm Smith
  • Izabela Borzecka
  • Robert French
  • Melissa Coates ( Twitter ) who helped by collating templates from her events to use.
  • Prathy Kamasani ( Twitter ) who is just simply amazing. Her smile lifts me and she has really helped to keep me going with her sunny attitude and unfailing support.
  • Rodney Kidd ( Twitter ) has been a rock and a great listener, as well as a helpful, kind gentleman.

Prathy, Rodney – I cannot thank you enough, and your friendship and support will stay with me forever. Thank you.

I want to thank the following sponsors for putting themselves forward to support me in what I’m doing for the Business Intelligence and emerging Business Analytics community in the UK. Without them, there would be no event. Fact.

SQLSaturday Edinburgh 388 Sponsors

I also want to thank our amazing SQLSaturday speakers. If you’d like to download their slides, you will find them on the site.

The speakers were, in order of appearance:

Jon Woodward ( Twitter / Website )

Iain Elder (Twitter)

David Parker ( Website )

Chris Webb ( Website / Twitter )

Ian MacDonald ( Website )

Adam Vero ( Website )

Bob Duffy ( Website / Twitter )

Carmel Gunn ( Website / Twitter )

Peyman Blumstengel ( Website )

Murali Nagaraj ( Website )

Peter Baddeley ( Website / Twitter )

Tom Sykes ( Twitter )

Niall MacLeod ( Website / Twitter )

Mark Wilcock ( Website / Twitter )

Bob Phillips ( Twitter )

Dave Lawrence ( Website / Twitter )

Tim Jones ( Website / Twitter )

Jean-Pierre Riehl ( Twitter / Website )

Gary Short ( Twitter / Website )

Satya Jayanty ( Twitter / Website )

Ric Howe ( Twitter / Website )

If I have missed anyone, it will be a genuine oversight due to a very tired little Jen missing things out!

I owe people emails so please forgive me until I catch my breath! Please bear with me. I’m doing my best.

Love always,

Jen Stirrup