Global Virtual Power BI User Group

A lot of very cool stuff has been going on lately.
Not only in Microsoft land, but also in my own live and it will affect you as well!
Read on for some great news.

At the end of August, Vishal Pawar (twitter | blog) contacted me via twitter.
He was wondering if I was interested in creating a virtual Power BI community together with him and a couple of other incredible people.
Of course I was interested, but I was already booked completely full for the coming period.
I gave Vishal all my contact info and asked him to please keep me up to date.

Fast forward to November where Microsoft announced Power BI User Groups to support the Power BI community even more.
This announcement made Vishal pick up the previous idea again mid november.
And so the Global & Virtual Power BI User Group (forum | twitter | facebook) came into existence.

Because of previous engagements I wasn’t able to actively participate yet.
This changed last week when I contacted Vishal and was welcomed with open arms.

Very active community

One of the things that amazed me the most was that there’s already an active community!
It doesn’t matter what platform you like the most, the Global Power BI community is active on most of them.

Power BI Community forum
Facebook
 300+ members as of 2015/12/27
LinkedIn 600+ members as of 2015/12/27

Because Vishal asked me, I’ll also list the people who are leading this community.
Check out all these awesome people, in alphabetical order by first name:

Adam Saxton USA (youtube | twitter)
Ásgeir Gunnarsson Iceland (twitter)
Damodaran Venkatesan USA (twitter)
Dustin Ryan USA (blog | twitter)
Gilbert Quevauvilliers Australia (blog | twitter)
Jan Mulkens Belgium (blog | twitter)
Michael Olafusi Nigeria (blog | twitter)
Patrick Guimonet France (blog | twitter)
Praveen Joshi India
Reza Rad New Zealand (blog | twitter)
Vishal Pawar USA (blog | twitter)

Why a Global & Virtual User Group?

Basically this is a User Group for anyone, anywhere and at any time.
There is no need to hurry to a local meetup after working hours or worry about having to excuse yourself again because of your busy personal life.

Log into the forum at midnight local time and ask a question. Or even answer a question someone else had.
View the latest news on the facebook group or share something cool you saw.
Watch a recording of a previous webinar or volunteer to give a webinar.

Whatever your goal is, you’ll be able to achieve it at your own pace together with some very smart people from all over the world.
Just know that the Global Power BI User Group will be there to support you.
And who knows, you’ll probably even make a ton of new friends!


In person meetups

While the Global Power BI User Group might still meet in real life in the future, if you’d like to find a local Power BI User Group near you today, don’t hesitate do so!

Nothing should stop you from joining a local when you’re already a member of the Global Power BI User Group.
Personally I’m also a member of the Belgian Power BI User Group!


Virtual meetups!

There are already more than 300 members in the Global Power BI User Group.
Adam Saxton AKA “Guy In a Cube” (blog | twitter) gave a first presentation, introducing the Global Power BI User Group, a couple of weeks ago.
And now we’re about to announce our second presentation.

It will be a reworked version of “Personal BI to Personal Data Science“, a session demonstrating how Power BI can easily be used by anyone to not only democratize BI but also data science.
I’ve already given this presentation twice in the past month. First time at the “Data Culture Day London – Power BI Edition” and the second time at the local Belgian SQL Server user group.

In addition the the previous content, we’ll dip our toes into the a new feature: using R within Power BI!

So far I’ve given this presentation with my colleague Kimberly Hermans (twitter), a data scientist.
With her experience, she rocks the data science parts in the presentation and she can answer your questions surrounding data science. I expect her to show up but she’s not sure about her agenda yet.

In summary:

  • Webinar: Personal BI to Personal Data Science with Power BI
  • When: January 16th, 2016 at 10:30AM EST (GMT -5)
    (Convert to your local time zone)
  • View: Google Hangouts on Air
    • You can’t pre-register anymore but you can follow live on the day!
    • Or you can watch the video afterwards!

Also, don’t forget to join the Global/Virtual Power BI User Group !


Questions or just some feedback you want to give?
Leave a comment, tweet me or go to the Global Power BI User Group forum or facebook page!

 

Goodbye Datazen, Hello Mobile Reports

24 hours ago I noticed CTP 3.2 being mentioned on MSDN and the download center.
A couple of hours ago it was released, AND HOW!

As we’re used by now, the SQL Server team has made a huge effort.
Get a jump start on all the new features here:

The real treat, and the subject of this blog post, lies in the integration of Datazen into SQL Server Reporting Services.


Mobile Reports released

I’m going to be very brief on this subject because it’s all still very new and I’m sure you want to get started yourself!

The workflow for mobile reports currently boils down to:

  • Authoring of reports in the SQL Server Mobile Report Publisher
  • Publish to on-premises SSRS
  • Consume in Power BI Mobile app

There’s even a new SSRS web portal which you might recognize if you ever used Datazen!

SQL-Server-Reporting-Services-web-portal[1]

For comparison, here’s the Datazen portal.

Datazen

Do you see what Microsoft did?
Perfect integration of Datazen into Reporting Services!
We even notice the differentiation being made between KPI’s, mobile reports and paginated reports.


Start your own Mobile Reporting!

  1. Get SQL Server CTP 3.2 over at the evaluation center.
  2. And get the CTP 3.2 downloads like Report Builder from the download center.
  3. While those are downloading, read up on

There is some sad news however, the Mobile Report Publisher is not available yet.
It is planned for the end of december.

IC840421[1]

Crucial step: Remember to provide Microsoft with a lot of feedback so they can improve the area’s that you think are not up to par yet.


Completion of the Microsoft BI Roadmap

If you’re wondering what the BI roadmap looks like, quickly check this blog post from almost 2 months ago!

After you’ve looked at the road map, you too will notice that this release is a huge leap for SQL Server. The on-premises BI stack now seems to be feature “complete”.
We already had

  • Spreadsheets (excel)
  • Paginated reports (SSRS)
  • Interactive reports (Power BI Desktop)

And we now also received Mobile Reports integrated in SQL Server!

The best thing probably is that your users can enjoy Mobile Reports and Power BI reports in one and the same app. This ensures that they will have the same experience and makes it a bit easier to manage for IT.

 

What are your thoughts on this course for Mobile Reporting in SQL Server?
Were you expecting something different from the Datazen integration?
Let me know in the comments or via twitter!

 

Did bits of SQL Server 2016 CTP 3.2 just leak?

Update: CTP 3.2 now really has been released! I highlighted the greatest new feature for you over here


Only 2 weeks after SQL Server CTP 3.1 and there’s already bits of SQL Server 2016 CTP 3.2 to be found on MSDN. For example, MSDN had this update on several SQL Server 2016 pages

MSDN SQL Server 2016 CTP 3.2

The page for the december update (CTP 3.2) is also already eagerly waiting for us

What's new in December Update

Sadly enough, for now, we get greeted by this headline

What's new in December Update 2

At the time of this writing the new image wasn’t available (anymore?) in Azure and there was no CTP 3.2 available for download from the Evaluation Center.

All the fancy downloads like Report Builder for CTP 3.2 etc are already available however!


I’m sure that we’re all dreaming about all the cool new features that Microsoft is going to release! After having seen R integration, will we now see Datazen integration? Will we already see improvements to R Services?

It will probably be another 2 weeks before CTP 3.2 is actually released.
If you’re like me, you’ll be regularly watching MSDN documentation for spoilers on the new features!

Until then, enjoy these SQL Server 2016 resources:


Got thoughts, information or just an opinion to share?
Let me know in the comments or on twitter!

Connecting to TFS from any version of Visual Studio

 

Sometimes you find some really old SSIS packages on some lone server.
And sometimes you even have to support them.
And rarely, those packages aren’t in source control yet.

TFS2012[1]

Today, I had the joy of bumping into all 3 conditions at once.
Read on to see what I did to solve this!

Read moreConnecting to TFS from any version of Visual Studio

Couldn’t attend PASS Summit 2015?

I’ve included the 3 sessions that I think will have the biggest impact on your daily work.
There are 19 sessions in total for you to enjoy, thanks to PASS.
So let’s watch some recorded sessions!

Read on to

Microsoft’s Vision for BI Reporting

Watch out everyone, here comes Microsoft’s vision for the future of BI Reporting!
Straight from the PASS Summit 2015, thanks to several people on twitter kind enough to share.

From On-premises to Cloud solutions, the vision is complete starting right now!


In other news, SQL Server 2016 CTP 3.0 has been announced.
Not only is it feature complete and amazing, it will just change the way we look at business intelligence.
Read more about it on the official blog and some more in this official post.

UPDATE:


Clicking below picture opens them in full size, for the last 2 it’s very useful because of the quality.
CloudandOnPremSolutions

MicrosoftProvidesCompleteSolution

TheFourMicrosoftBIREportTypes

This last picture is a bit blurry, but those who know the platform can discern the complete picture.

From creating Analytical and Power BI reports, to Mobile and Paginated reports.
It will all be manageable in the cloud on PowerBI.com or on-premises in Reporting Services.
And of course, the journey ends when the end user opens the reports on PowerBI.com, his mobile device or the corporate SharePoint.

VisionForMSBIReporting

 

SQL Server 2016 CTP 2.4 is here!

Microsoft is a busy bee these days… Providing all the updates we actually want and need!
Today there was another great release for the Power BI Service.
And more importantly, a HUGE release called SQL Server 2016 2.4!

This includes a long awaited feature for SSRS and an incredible improvement for analytic workloads.


A quick overview of what you can play with:

General

  • Some sad news for people with old machines: x86 server support is now deprecated!
  • Smart Maintenance Plans
  • Tempdb now has improved scalability

SSRS

  • Export reports to PowerPoint!
  • Position report parameters the way you want
  • Print reports from modern browsers
  • Even better support for new browsers
    • Like no requirement for ActiveX to print reports

SSRSPowerPointExport

Read more details about the Reporting Services changes in this post at the official SSRS blog.

SSIS

  • Excel 2013 finally made the cut as a source and destination
    • Now we wait for Excel 2016 🙂
  • Complex data feeds including Data Streaming destination!
  • oData v4 source support in addition to oData v3
  • Balanced Data Distributor
  • AlwaysOn support

Operational Analytics and In-Memory Data Warehouse

  • Updateable NonClustered Columnstore Indexes, but they no longer need an index rebuild!
  • Parallel building of these NonClustered Columnstore Indexes.
  • Increased speed for insert operations on delta Rowgroups
  • And of course improvede query performance using these NonClustered Columnstore Indexes

Read the official post with more in depth information here

I’m speaking at Data Culture Day London!

One of the sessions I submitted for Data Culture Day London – PowerBI edition has been selected! Which one?

Power BI – From Personal BI to Personal Data Science

  • A look at using Power BI to provide users with self-service capabilities in Data Science projects

You’ll be able to see my colleague Kimberly Hermans and me speak in the first slot (9h45), after the keynote, on 28/11 at Microsoft UK in London.

Take a look at the rest of the schedule for the event.

Places are limited, so if you’re not registered yet, do so now. 🙂

I’ll see you in London!

Motivation and the road to success

Yesterday, I read a conversation between Brent Ozar (blog|twitter) and Jen Stirrup (blog|twitter) on twitter. It gave me a fun but quite insane idea.
To get the ball rolling, I bugged my manager at 10PM. Lucky for him, it was via mail.
Well, today we had a long call about this mail. He thought it would be a good idea but it still needs some work.
This last quarter of 2015 is already fully booked for me. This means that this idea will make 2016 an even crazier year than 2015.

You’re probably curious, so read on for some tips!

Read moreMotivation and the road to success

Data Culture Day London – Power BI Edition

I submitted my sessions for the Data Culture Day London – Power BI Edition.
It’s a free event at Microsoft in London on 28th of November.

The main audience are business professionals who want to learn how to use Power BI and Excel better.

I selected several sessions from my “archive”

  • Power BI – Pushing beyond the built-in limitations
    • Tips, tricks and some hacks to make full use all Power BI capabilities
  • Power BI – Personal BI for the SME
    • A dive into the value PowerBI adds to the average business
  • Power BI – From Personal BI to Personal Data Science
    • A look at using Power BI to provide users with self-service capabilities in Data Science projects
  • Putting data in your culture with Power BI
    • A look at why and how Power BI fits into your BI strategy

Read on for more!

Read moreData Culture Day London – Power BI Edition

%d bloggers like this: