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 … Continue reading Why UK Power BI Summit? Derive business value from your data

What do you need for my SQLBits R and PowerBI session? Nothing!

What do you need for my SQLBits R and PowerBI session? Nothing! I am not expecting people to have installed anything in advance, hence I have made no requests for the event. I will cover it during the session. Usually people never do it in advance because they are hassled in work, trying to clear their desks before … Continue reading What do you need for my SQLBits R and PowerBI session? Nothing!

Note to Self: Some useful DAX commands which I keep forgetting

Over time, I will add to this list. I want to keep an online copy of DAX commands so I can copy and paste them for future Power Pivots.When you have an integer and want to convert it into HH:MM or HH:MM:SS format=FORMAT(TIME(0,0,'CiscoData'[queuetime]),"hh:mm:ss")When you want to create a key from a standard date. This will … Continue reading Note to Self: Some useful DAX commands which I keep forgetting

Democratization of Data: from Thoughts to Decisions presentation at SQLKonferenze – see you there!

I’m proud to be speaking at the SQLKonferenze in Germany.  It’s a very special event: 10 years of PASS in Germany!  I am doing two things:I'm giving a brief talk during the opening session on Monday 10th Feb, as part of my role on the Board of Directors for PASS, where I am honoured to … Continue reading Democratization of Data: from Thoughts to Decisions presentation at SQLKonferenze – see you there!

My PowerBI Contest Entry: it is not your belt rank that matters but the legacy you leave

“In martial arts it is not your belt rank that matters but the legacy you leave.” – Grandmaster CK Leow, Founder, Moodukkwan MalaysiaIt’s the voting round in the Power BI contest.  I would ask you to please vote… but not necessarily for me. I mean for any and all of the participants who took the … Continue reading My PowerBI Contest Entry: it is not your belt rank that matters but the legacy you leave

Business Intelligence Barista: Mixing your choice of BI Coffee with Tableau, Power BI or Qlikview?

** Update at 11th March: This is not an advert for PivotStream and I am not endorsing their services or solution. To show that this blog post is not an advert for PivotStream, I will explore alternatives, which I will follow up in a future post.In the meantime, you could look at PowerBI and Office 365 with … Continue reading Business Intelligence Barista: Mixing your choice of BI Coffee with Tableau, Power BI or Qlikview?

Big Data for the Business Intelligence Professional SQLPass Summit Preconference Day

I'm delighted to announce that Allan Mitchell (blog ¦ twitter) and I are giving a Big Data for the Business Intelligence Professional preconference session at SQLPass Summit 2013 in Charlotte, NC.What will we be covering? What does Big Data mean for business intelligence professionals? Come see the “whats,” “hows,” and “whys” as this full-day pre-conference … Continue reading Big Data for the Business Intelligence Professional SQLPass Summit Preconference Day

PowerPivot error: unable to upgrade the Data Model in this workbook

Upon opening a PowerPivot in Excel 2013 workbook, I get the following message:unable to upgrade the Data Model in this workbook. The error occurred while upgrading PowerPivot workbook. The data model has reverted to the previous version The PowerPivot model was created in Excel 2013. The machine is 64-bit and the model was created here … Continue reading PowerPivot error: unable to upgrade the Data Model in this workbook

Up and coming PASS BA Sessions, and Data Visualisation and Microsoft Workshops

If you're here looking for precon notes, I will be posting these up in the next few weeks after I've finished my precons at SQLSaturday Denmark, Databasedays Switzerland and SQLBits in Nottingham, UK. So please keep checking back, or email me at jen.stirrup@copperblueconsulting.com I'm delighted and proud to be presenting at the PASS Business Analytics Conference … Continue reading Up and coming PASS BA Sessions, and Data Visualisation and Microsoft Workshops

PowerPivot and Excel 2013 Overview Slides

Here are the slides for my recent presentation that I did recently, which was organised by Dell. Unfortunately, for some reason the recording didn't turn out properly. However, the slides are available here for download:http://static.slidesharecdn.com/swf/ssplayer2.swf?doc=questionpowerpivotspiderman-120729174846-phpapp02&stripped_title=powerpivot-and-excel-in-office-2013&userName=jenstirrupPowerPivot and Excel in Office 2013 from Jennifer Stirrup.Any questions, please do get in touch. I will try to arrange another … Continue reading PowerPivot and Excel 2013 Overview Slides

SQLPass Business Intelligence Virtual Chapter References and Slides

Thank you to everyone who attended my SQLPass Business Intelligence Virtual Chapter webinar! I have lots of questions to follow up, from both during and after the event. Please watch this space for more responses to questions over the next few days, and I will try to ensure that I answer every question. The slides … Continue reading SQLPass Business Intelligence Virtual Chapter References and Slides