I was live tweeting during our monthly PASS Business Analytics VC meeting, Here are the tweets to learn about 13 Excel Tips!
Thanks everyone who attended, I hope it was helpful!
Here are some ways to follow the Virtual Chapter:
Just a quick note that you can quickly create maps in PowerView in office 2013. I just created one in 2 minutes:
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:
1. Google Fusion Table & Data Visualization (He used Google Fusion Tables, I used PowerView!)
2. Creating Maps in Excel 2013 using Power View
A great end to end demo shown by Microsoft at Strata conference 2012:
Description about Demo:
Scenario: Analyze web logs of an online bike store.
Hadoop (Get started with HDInsight)
Azure Data Market.
A Dashboard in Power View showing co-relation between discount campaigns and the traffic:
This is mash-up of data from Hadoop (traffic) and data from SQL Server (discount campaigns)
In this blog-post, I shared an awesome demo about HDInsight. check it out!
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.”
Read here: SolidQ Journal: Building an Ideal Tabular Model for Power View reports by Paras Doshi
Blog-Post about Part 1 is here: SolidQ Journal: Building Ideal PowerPivot Model for Power View reports
If you have any feedback or comments, please drop a comment or contact me.
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)
Add Server Roles: Application Server, File Services, Web Server
Change Server Name to a friendly Name
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.
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
Install Sharepoint per-requisites
Install Sharepoint 2010 SP1
Note: Do NOT run the SharePoint configuration wizard
Run SQL server setup to Install “SQL Server PowerPivot for SharePoint”:
Post-Installation: Launch the PowerPivot configuration tool to configure the server
perform a NEW installation of SQL Server
Analysis Services Mode: Tabular
perform a NEW installation of SQL Server
Analysis Services Mode: Multi-Dimensional
Verifying Reporting Services Installed in Sharepoint Mode. Tutorial here.
Also Extend the Document Libraries to include BISM connections.[Read Follow up Blog Post: How to extend document library to connect to Tabular Model to create Power View reports ]
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
Resources that I refer to for configuration Details:
1) SQL Shorts Video to configure SharePoint BI environment
2) Getting up and running with SQL Server Denali for Business Intelligence (Crescent and PowerPivot in CTP3)
3) Deployment Checklist: Reporting Services, Power View, and PowerPivot for SharePoint
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:
Check out this SolidQ Journal article: http://www.solidq.com/sqj/Pages/Business_Intelligence/An-introduction-to-PowerView-in-SQL-Server-2012.aspx
Also, SQL server Training kit 2012 is a great resource.
And if you do not like setup’s and want to quickly get hands-on – Check this out: http://www.microsoft.com/sqlserver/en/us/learning-center/virtual-labs.aspx
And also Microsoft Virtual Academy for video tutorials about SQL Server 2012 BI:
That’s about it for this post. Your feedback is welcome!
And Let’s connect! I Look forward to Interacting with you on any of these people networks: