Thanks everyone who attended, I hope it was helpful!
Here are some ways to follow the Virtual Chapter: Website: http://bavc.sqlpass.org/ Youtube: https://www.youtube.com/channel/UCOiRAA4gBxEeVxwmEZ1qy1w Twitter: https://twitter.com/passbavc LinkedIn: https://www.linkedin.com/groups/PASS-Business-Analytics-Virtual-Chapter-6701113
This seems like a great way to visualize where your fans are from. In my case, most of them are from India and so one actionable insight would be to schedule posts based on Time Zone in India. And I can imagine that such reports could be very helpful to brands who have sizable fan following on Facebook.
Here’s the screenshot:
Thanks to the following blog-posts for inspiration:
Part 2/2 of the series on building Ideal Models for Power View reports is live!
Summary: “In this article, we will first compare the PowerPivot and Tabular models, which will help you choose between these two models for your scenarios, and then we will study the reporting properties in a Tabular Model that you can configure to build an Ideal model for Power View reports.”
Step 1 Get the Binaries: SQL Server 2012 RTM, Windows Server 2008 R2, Sharepoint 2010 SP1 x64 Setup a VM: Check the System Requirements and configure the VM. And then Install Windows Server 2008 R2 x64 SP1 (and updates)
Step 2 Add Server Roles: Application Server, File Services, Web Server Change Server Name to a friendly Name
Step 3 At this stage, I cloned the Virtual Machine. And the following steps will be performed on the cloned (copied) virtual Machine. Thanks for the tip that I found here. The benefit of cloning is that you have a Windows Server 2008 R2 VM Template that you can use in Future.
Step 4 On the cloned VM, run dcpromo.exe. This will make your server the Domain Controller and it will install ADDS binaries if they are not installed prior to running dcpromo.exe
Step 5 Install Sharepoint per-requisites Install Sharepoint 2010 SP1 Note: Do NOT run the SharePoint configuration wizard
Step 6 Run SQL server setup to Install “SQL Server PowerPivot for SharePoint”: Post-Installation: Launch the PowerPivot configuration tool to configure the server
Step 7 perform a NEW installation of SQL Server Analysis Services Mode: Tabular
Step 8 perform a NEW installation of SQL Server Analysis Services Mode: Multi-Dimensional
Step 10 At this point, I installed and ran the SQL Server Training Kit 2012. It will list various “Missing” softwares like office, silverlight and also it will help you install sample databases. It’s a nice “shortcut” to make sure that you a “complete” sharepoint BI dev Environment
That’s about it for this post. I’ll refer to this post whenever I have to setup my SharePoint BI Dev Environment. And if you are in the same position, then i hope the Bird’s eye view and the resources listed are helpful to you as well.
I got a chance to play with power-view which seems like great feature of SQL Server 2012! And I liked it that we can create Hans Rosling styled BI dashboard’s with Powerview. For those who do not know about Hans Rosling presentations, check these collection: All Hans Roslings Ted Videos.
And by studying modules in SQL server Training kit 2012, I was able to create a similar Dashboard, It was fun!
Now, Listing resources for you, If you are Interested to learn about Powerview: