Upcoming Webinar – Creating Power Map Reporting Solutions

image

Come join me for this webinar on 4/17/2014 at 11:00 AM EST

Creating Power Map Reporting Solutions

Excel 2013 with Office 365 brings many new features to the realm of Self-Service BI. There are now new ways to extract, model and present data all within Excel. One of these newest ways to present data is called Power Map. Power Map allows you to create engaging 3D map visualizations to help understand your geographical data better. This session will walk you through the beginning to end process of creating Power Map tours. Register now here.

Upcoming Webinar – Bringing Power BI Q&A to your Organization

image

Come join me for this webinar on 4/15/2014 at 11:00 AM EST

Bringing Power BI Q&A to your Organization

Q&A is an amazing new feature of Power BI that allows you to ask you data question. No longer do you have to write complex SQL queries to get results. Simply type traditional English sentences to return interesting results about your data. This session will walk through how to get a Power Pivot data model ready to use and also the end user experience of Q&A from the Power BI site. Register now here.

Introduction to Power BI Recording and Q&A

I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on March 13, 2014. If you weren’t you can now download the recording and slides.

I usually like to post follow up questions and answer that I wasn’t able to address during the webinar. Here’s several that may help you!

Q: Can you explain quickly how to use Power View on SharePoint 2010?

To use these together you must have SharePoint 2010 SP1 Enterprise and SQL Server 2012 Enterprise or BI Edition. Unfortunately, there’s not a quick way to describe the rest of the configuration so here’s a post that may help.

http://blogs.msdn.com/b/karang/archive/2012/04/13/step-by-step-guide-of-installing-power-view-with-powerpivot-2012.aspx

Q: What devices are supported by mobile BI

The Mobile BI will be available on Windows 8 and Windows RT devices. There is also a native Mobile BI app for iPad under development.

Q: Are MS planning to remove the dependency on Silverlight for Power View (etc.) thus making it possible to render on iPad?

Yes! There are actually some public betas of Power View working on HTML 5 instead of Silverlight. This will be the major enhancement that allows support for the mobile BI app on IPads

Upcoming Webinar – Introduction to Power BI

image

Come join me for this webinar on 3/13/2014 at 11:00 AM EST

Introduction to Power BI 

The future of Business Intelligence has many new and exciting features. This world that was once reserved for only experts in SQL Server technologies has expanded to serve the masses with more and more self-service innovations. In this session you will gain an understanding of what Power BI is and get an overview of each of the components. This includes Power Pivot, Power View, Power Query and Power Map, Mobile Power BI and Q&A.

PASS Summit 2013 and SQL Saturday Charlotte in Review

I love reading the many blogs posts that pour in following a PASS Summit.  I think it is fun to read everyone’s experience.  There’s not really a wrong way to attend the conference unless you just hide our in your hotel the whole week.  Here’s how my week went.

Sunday

This was a travel day for me.  I drove with Brad Schacht and Gareth Swanepoel up to Charlotte from Jacksonville.  This was a fun 5.5 hour drive as Gareth live tweeted our trip with the hashtag #sqlwolfpack.  We arrived Sunday night with just enough time to go register for the conference before registration closed for the night.

Monday

Monday Brian Knight and I delivered a full day precon on Growing up with Analysis Service: Power Pivot to MOLAP.  We had about 100 in the audience for an exciting day of learning.  We took the approach of telling a story of an Analyst that created a Power Pivot model but as requirements changed there was a need to find a more scalable solution through the other forms of Analysis Services.

Tuesday

This was a lighter day for me but I did stop by and visit the networking party hosted by Andy at Buffalo Wild Wings. I also spent much of this day setting up the Pragmatic Works’ booth prior to the opening of the event on Wednesday.

Wednesday

The opening of summit started with the keynote describing a hybrid approach to SQL Server (On Premise and Cloud).  I’m seeing more and more momentum Microsoft cloud.  A lot of the crowd that wasn’t buying into is years ago are now starting to see the benefits clearly now too so that’s helping. 

After lunch I delivered a presentation on Creating an End to End Power View Reporting Solution.  In this session I show what is needed to go from basic data source to full reporting solution using Power View.

After all the sessions were complete the Exhibiter receptions started and the Pragmatic Works’ booth hosted a book signing.

I also attended a Karaoke party hosted by Pragmatic Works that night with a live band.  You can check out about 200 pictures from that event here.

Thursday

On Thursday I presented a session with Dustin Ryan on Choosing the Right Analysis Services: Tabular vs MOLAP.  This was the first time I had ever presented with Dustin and I think it went really well.  I especially enjoyed how we worked off each other to make our points together.  Demos were of course planned but the banter was all thought of on the spot.

I also attended a couple sessions on Thursday.  One on Real Time Data Warehousing on PDW and then also the BI Power Hour.

Friday

I worked the Pragmatic Works booth much of this day and then went to the SQL Saturday Charlotte Speaker dinner at night. 

Saturday

I presented a session at SQL Saturday Charlotte on Power Query.  I had a lot of great questions in this session, which happens to be one of my favorite topics right now.  The event was incredibly organized.  I tip my hat to the organizers who obviously put a lot of work into getting the event together.

Understanding Microsoft Self-Service BI Recording and Q&A

I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 2013.  If you weren’t you can now download the recording here.

Because I covered new material all the way to the end of the webinar i thought I’d also answer some of the top questions I didn’t have time to answer here.

Q: Can an Excel Power Pivot 2013 model be read by Excel 2010 or Excel 2007? What about Excel versions and their compatibility with SharePoint Versions?  I ask because we are upgrading our SharePoint environment to 2013 but most of our users have Excel 2010 (a few have 2007).

You can open an Excel 2013 workbook that has a Power Pivot model in older versions but you cannot modify them.  You can however deploy Excel 2010 and Excel 2013 workbooks to you SharePoint 2013 environment and it they interact the same.

Q: Is there a way for me in us my own map?  ex. wards/districts in my county

I assume this one is referring to Power Map and the ability to map geopolitical regions.  It doesn’t currently have the ability to your own regions yet.

Q: Where do we download power map?

http://www.microsoft.com/en-us/download/details.aspx?id=38395

Q: Can you change to use google maps instead of bing maps?

No, Microsoft tool = Microsoft maps! :)

Q: Could I use relationships using more than one field?

No, Power Pivot only has the ability to create relationships on one field at a time.  If you need to join on more than one field, which in the real world is often, then you have to get creative.  In the quick example I showed we merged two columns together to make a single join column that could be used for our relationship.

Q: Is Power Query available for Excel 2010?

It sure is!  This is one of the great things about Power Query is that it is compatible with both Excel 2010 and 2013.

Q: How can you share Power View reports? Do you have to share the excel file or can you display in SharePoint?

You have a couple options.  You can share the excel file like you’ve suggested or you can deploy it to SharePoint.  If you develop the Power View reports in SharePoint you can also export via PowerPoint.

Q: Will these slides be available

Sure thing!  Download them here.

Q: The maps features is very interesting.  Can it do counties within a state .. and neighboring states?

Yes, Power Map has the ability to regionally map counties and zip codes as well.

Ohio Business Intelligence Road Trip 2013

imageNext month Mike Davis and myself will be making a epic road trip.  We will be flying into Columbus, OH to deliver a two day (7/16 – 7/17) workshop on advanced Reporting Services techniques.  We will then pack up and drive to Cleveland, OH for another two day (7/18-7/19) workshop on advance Integration Services techniques. 

Come join us for what should be a fun week!  I’ve already talked to a few folks that will be making the drive with us and attending both sessions.  Hope to see you there!

Columbus Master SSRS Workshop

Duration: 2 Days

Schedule: 7/16/2013 – 7/17/2013 8:30 AM – 5:00 PM

Price: $299

Location:

Microsoft Office
Polaris Center
800 Lyra Dr.
Suite 400
Columbus, OH 43240

Master Report Developers must hold unique traits to set themselves and their work apart from others. This two day class is designed to take you to the next level in your understanding of SQL Server Reporting Services (SSRS). We use a variety of lab exercises to ensure lecture sessions are backed up by hands on experience. With the hands-on labs, you will learn how to create complex reports that use Analysis Services as a data source and custom code assemblies. This course will cover all the advanced topics of Reporting Services like scaled-out deployment, .Net integration and monitoring Reporting Services usage.

Agenda

Cleveland Master SSIS Workshop

Duration: 2 Days

Schedule: 7/18/2013 – 7/19/2013 8:30 AM – 5:00 PM

Price: $299

Location:

Microsoft Office
Park Center III
6050 Oak Tree Blvd. S., Third Floor
Independence, OH 44131

During this 2 day advanced SSIS training course, you will learn how to use SSIS in your enterprise to solve common extract, transform and load (ETL) challenges. This class assumes you know the basics of SSIS and takes you from the novice level to a more effective, advanced ETL developer. Much of this class focuses on implementing common real-world SSIS patterns taught from the experts of SSIS. You’ll also learn how to performance tune SSIS. Be prepared for a very in-depth day of SSIS that gets advanced in many areas.

Agenda

Follow

Get every new post delivered to your Inbox.

Join 37 other followers