Best Practices and Practical Deployment Aspects of Business Intelligence with SharePoint 2013, SQL Server 2012 on Windows Server 2012

I am very lucky in that I have been accepted to present on Business Intelligence Best Practices at a few upcoming SharePoint Saturdays which I hope all of you will attend.

This session is primarily based on walking you through demos on the Design, Development and Deployment of Business Intelligence Objects following SharePoint Best Practices in all aspects from Design to Deployment methodologies of SharePoint 2013. This session will start with a very quick walk through the foundational aspects of Business intelligence when integrated with SharePoint along Best practices in the Design, Development and deployment of Business Intelligence solutions in SharePoint Server 2013, with SQL Server 2012, on Windows Server 2012 that will include Analysis Services Solutions, with PowerPivot, PowerView and Reporting Services, Excel and Visio Services.

Also, Norm and Ivan will walk through the governance issues surrounding the deployment of SharePoint 2013 in general and the Business Intelligence Aspects in specific. In addition, Norm will quickly explain practical paths for designing tabular models in PowerPivot and the SQL Server Data Tools environment. He will explain decision points such as hybrid approaches with Direct Query, and include best practices for automating data refresh in SharePoint and scheduling processing in Analysis Services.

The session includes a thorough demo of creating an Odata feed from SharePoint lists and SQL Azure to relate a date table for quickly showing aspects of time intelligence. The demo will continue by showing how to create partitions in SQL Server 2012 and schedule data refresh (with an interval of 15 minutes) using XMLA. Lastly, the team will discuss how to choose the right Business Intelligence tools to start using now so you can show immediate results while planning for the future evolution of your SharePoint Business Intelligence Dashboards.. All demos are built on Windows Server 2012, SQL Server 2012, and SharePoint Server 2013.

clip_image001I have been very blessed this year to be working on the Second edition of the Business Intelligence in Microsoft SharePoint 2013 with the illustrious group of Norman P. Warren, Mariano Teixeira Neto, John Campbell, Stacia Misner the author’s of the First edition Business Intelligence in Microsoft SharePoint 2010.

Norm currently works for to help people discover, preserve and share their family history. Norm was previously a writer for PerformancePoint Server 2007 and SharePoint Server 2010 at Microsoft, and has written articles on PerformancePoint Server for the information worker, IT Pro, and SQL Server BI developer audiences. Norm has his Master’s degree in computer information technology and is currently earning his MBA with an emphasis in financial accounting.

Norm has an active member of the community to provide the right content about Microsoft business intelligence such the SharePoint BI poster (Visio ( His past time is with his family, mountain biking, and sharing his passion of BI in SharePoint.

Norm will be joining me for the first two in an upcoming series of SharePoint Saturdays during the next few months. The first of this series is coming up on September 22nd 2012 in Redmond WA. at the Microsoft Conference Center. Where if you are like me and have a passion for all things Microsoft then you know its one of the best cities in the world ad I hope you will join us for this event and the place to register is

The second in the series will be held ion Bend OR. on October 6th 2012 at Central Oregon Community College in Bend, Oregon. If you were unable to join us in Redmond then this is the event we hope you can attend due to the numerous seasoned experts, MVPs and MCMs alike. Please don’t forget to register

The last in the series leading up to the SharePoint Conference in Las Vegas Nevada will be held in Sacramento California on October 13th 2012 at the Woodlake Hotel near the Cal Expo in downtown Sacramento. I was fortunate enough to be the keynote speaker last year and the number of people attending and the excellent venue made this one of the highlights of my year of presenting at many SharePoint Saturdays of which I was privileged. Registration is open

Last I would like to thank the many sponsors that make all of the free SharePoint Saturday events possible:
























If you have been in the SharePoint industry  for any length of time you may be able to tell from the number of sponsors with SharePoint products and services, the SharePoint community is getting better very year and becoming more vibrant every day.

Thank You to ALL our SPONSORS and VOLUNTEERS for making SharePoint Saturdays possible…




No comments yet. Be the first.

Leave a Reply