Analysis Services Demystified video for the ‘need to learn it quickly’ Business Intelligence professionals

My Analysis Services Demystified video for the ‘need to learn it quickly!’ Business Intelligence professional has 60% off! Bargain with Packt Publishing

The video itself is for people who are suddenly landed with an Analysis Services project and need to get an overview of the technology very quickly.

Once they’ve had a look at this video, they could then move forward to one of my favourite Analysis Services books by Chris Webb, and the link is here. I pre-ordered this book before it came out, and it’s a great book.

I am very proud because it took a long time and many, many hours to produce. It’s not like writing a book, where you can hide away for a bit. The recordings demand total silence and even if there is nobody around, the world is quite a noisy place! Birdsong, which normally I love, suddenly plagued my recordings so it was hard to find really ‘quiet time’. My computer fan kicking off….. My neighbour’s television…. And the list goes on and on 🙂

I’d like to thank the team at Packt for their patience: Hyacintha, Shradda and the others. They know who they are!

Notes to Self: useful links for Power View and Multidimensional models

Here is a collation of some useful Power View and Multidimensional Models literature from TechNet and
Quote from the above article: This does not support connecting to and creating reports for multidimensional models. Power View for multidimensional models supports browser based Power View clients only.
 In light of this information, it makes sense that you will need to create RSDS files in SharePoint and here is the link on how to do this: Create a Shared Report Data Source Connection to a Multidimensional Model 
Once you have set up your connection, you can create your Power View report: Create a Power View Report with a Multidimensional Model Data Source
To get an overview of how Power View in SharePoint works with Analysis Services Multidimensional models, take a look here: Understanding Multidimensional Model Objects in Power View

Explore the Adventure Works Multidimensional Model by using Power View – This article walks users through creating a Power View report and exploring the sample Adventure Works multidimensional model.

SQLPass Business Intelligence Virtual Chapter – Join Us for Charting Collections of Connections in Social Media: Creating Maps and Measures with NodeXL

Join Us for a free webinar on Charting Collections of Connections in Social Media: Creating Maps and Measures with NodeXL
The Professional Association for SQL Server (PASS) Business Intelligence Virtual Chapter will be hosting Marc Smith next week, on 2nd July at 7pm PDT. I am honoured to be hosting. To register, click here: 
The topic: Networks are a data structure common found across all social media services that allow populations to author collections of connections. The Social Media Research Foundation’s NodeXL project makes analysis of social media networks accessible to most users of the Excel spreadsheet application. With NodeXL, Networks become as easy to create as pie charts. Applying the tool to a range of social media networks has already revealed the variations present in online social spaces. A review of the tool and images of Twitter, flickr, YouTube, and email networks will be presented. 
Does it work? It’s certainly very interesting stuff. Here is my NodeXL graph for the past week:
I must admit that I’m not terribly good at planning out tweets. I don’t tend to worry about things like ‘reach’ and ‘engagement’. I just put out things that interest me, and things I am excited about. People respond, or don’t respond. I am more concerned about what I don’t tweet: I try to take care not to offend anyone because I think it can be done inadvertently when you have only 140 characters. Things spill out, that interest me! I am an ‘interested’ person, who loves lots of subjects and probably many of you are the same.
Personally I’m very grateful for twitter since it allows me to connect with my sqlfamily from around the globe. I love tweeting people in the US, for example, because it’s great to feel connected with people even though they are far away.
Tweeting suits my lifestyle. I am a single mother and I don’t have a sparkling social life with friends and parties. For example, it is 4am here in the UK and I am still working. However, I am happy and this is no sob story! What I do have, is friends that I see at technology events such as SQL events, and these people are my friends, my ‘sqlfamily’ and I am at home at these events. I never thought I’d feel so at home with a bunch of people from all over the place, and I know I am extremely privileged to know many of the sqlfamily from everywhere.
I suggest you go to the NodeXL website, take a look at the free download, and introduce yourself to your own networks hidden in your data. This could be Twitter data – or perhaps even data and patterns hidden in your corporate Data. You don’t have anything to lose by simply trying it, and who knows what you will find!
I am not holding this webinar, but I am hosting. So please allow me to introduce my guest speaker. For those of you who don’t know, Marc does some interesting research on social media and I recommend that you join us. Marc Smith is a sociologist specializing in the social organization of online communities and computer mediated interaction. Smith leads the Connected Action consulting group and lives and works in Silicon Valley, California. Smith co-founded the Social Media Research Foundation (, a non-profit devoted to open tools, data, and scholarship related to social media research.

Smith is the co-editor with Peter Kollock of Communities in Cyberspace (Routledge), a collection of essays exploring the ways identity; interaction and social order develop in online groups. Along with Derek Hansen and Ben Shneiderman, he is the co-author and editor of Analyzing Social Media Networks with NodeXL: Insights from a connected world, from Morgan-Kaufmann which is a guide to mapping connections created through computer-mediated interactions.

Big Data overview of the Microsoft distro of Hadoop

Here are my Big Data slides from SQLSaturday Dublin and SQLSaturday Edinburgh.

This is part of the preview work that I’m doing for our SQLPass Precon which I’m jointly conducting with Allan Mitchell MVP this October, in Charlotte, NC.  Here is the link to register, and I hope to see you there!

Networking and Careers ‘Women in Technology’ Event in Edinburgh on 8th June

I am delighted to announce a ‘Women in Technology’ event in Edinburgh at 3.30PM on 8th June at SQLSaturday Edinburgh!
Can more diverse networks provide better networks? Is it beneficial to have a diverse network, and do men and women define networking success differently?
Is business networking useful in our careers? How much has networking helped you in your career?
How can you build good social media profiles – or are these even necessary to build a career network?
Join us for this fun and thoughtful discussion!