For those who would like a quick primer on PowerPivot Topologies and Configurations, check out the SlideShare below. Enjoy!
Month: March 2012
A Primer on Hadoop (from the Microsoft SQL Community perspective)
For a quick primer on Hadoop (from the perspective of the Microsoft SQL Community), as well as Microsoft Hadoop on Azure and Windows, check out the SlideShare.NET presentation below. Above the cloud: Big Data and BI View more PowerPoint from Denny Lee Note, as well, there is a great end-to-end Microsoft Hadoop on Azure and Windows presentation available at: Apache hadoop for windows server and windwos azure View more PowerPoint from Brad Sarsfield
How to Connect Report Builder 3.0 to a SQL Server 2012 PowerPivot workbook
With the upcoming release of SQL Server 2012, the new and cooler way to connect to a PowerPivot workbook within SharePoint is to use Power View which addresses the concept of Self Service Reporting (similar to how PowerPivot addresses Self Service BI). I even have a cool YouTube video showing how to connect Power View to Hadoop on Azure: https://dennyglee.com/2012/02/10/connecting-power-view-to-hadoop-on-azurean-awesomesauce-way-to-view-big-data-in-the-cloud/ . Why Report Builder 3.0 when there is Power View? Nevertheless, there are some situations where SQL Server 2008 R2 tool – Report Builder 3.0 – can still be quite helpful. For example, if you need to export out the…
Connecting Hadoop on Azure to your Amazon S3 Blob storage
When working with Hadoop on Azure, you may be used to the idea of putting your data in the Cloud. In addition to using Azure Blob Storage, another option is connecting your Hadoop on Azure cluster to query data against Amazon S3. To configure Hadoop on Azure to connect to it, below are the steps (with the presumption that you already have an Amazon AWS / S3 account) and have uploaded data into your S3 account. 1) Log into your Amazon AWS Account and click onto Security Credentials 2) Obtain your access credentials – you’ll need both your Access Key…
Sunny Sunday: Mount Rainier
Here are some great pictures during the hike up Mount Rainier (via the Emmons Route through the Emmons Glacier). These great pictures were taken by Kelly Hedlund; she, Brian Hedlund, and I went up to Mount Rainier in July 2000. — About “Sunny Sunday”: The Sunny Sunday blog posts are photos from various travel and/or outdoor (hiking) trips.
BI and Big Data–the best of both worlds!
As part of the excitement of the Strata Conference this week, Microsoft has been talking about Big Data and Hadoop. It started off with Dave Campbell’s question: Do we have the tools we need to navigate the New World of Data?. And some of the tooling call outs specific to Microsoft include references to PowerPivot, Power View, and the Hadoop JavaScript framework (Hadoop JavaScript– Microsoft’s VB shift for Big Data). As noticed by GigaOM’s article Microsoft’s Hadoop play is shaping up, and it includes Excel; the great call out is: to make Hadoop data analyzable via both a JavaScript framework…
Denny Lee 