I'm hugely honoured to be speaking at SQLRally Dallas on Friday May 11th. My subject is 'Business Intelligence and Azure: SSIS and SSRS Focus' and I'll be doing a demo which shows, 'end to end', how we can take some data, load it into the cloud usng SSIS, and then review it in SSRS. The whole Schedule… Continue reading Here’s why I’m travelling 4735 miles to go to SQLRally Dallas!
In preparation for my SQLRally Presentation in Dallas in May 2012, I've been investigating SQL Azure, using the SQL Server Data Tools to create SQL Server Reporting Services 2012 reports. One issue you might encounter is that your report runs perfectly well in SSDT, but does not run when it's been deployed to SQL Azure.… Continue reading SSRS 2012 CTP Shared Datasets in SQL Azure
I often hear requests for Power View to be made available outside of Sharepoint. Currently, Power View does require Sharepoint Enterprise 2010 and SQL Server 2012. I see that people are starting to love Power View. I love Powr View since I think it is facilitating businesses to ask the different questions of their data. If… Continue reading Power View outside of Sharepoint Enterprise
I believe that the MSDN Analysis Services tutorial and AdventureWorks files on Codeplex aren't quite matching up. For the tutorial 'Using a Modified Version of the Analysis Services Tutorial Project' (http://msdn.microsoft.com/en-us/library/ms166582.aspx), the reader is instructed to download the file 'SSAS Multidimensional Model Projects SQL Server 2012.zip' The reader is directed to 'Browse to the Lesson… Continue reading MSDN Analysis Services 2012 Tutorial and AdventureWorks Codeplex files Re-Pointer
Currently, Power View is supported by a number of browsers: IE, Safari, and Firefox. What about Chrome? I've opened a Microsoft Connect case about this, and you can go and vote it up or down here. For the full list, please take a quick look at the Microsoft documentation. I've taken an excerpt from the original… Continue reading Cross-Browser support for Power View
I've had some questions from people using the AdventureWorks tutorials on Analysis Services 2012, so I thought I would answer them here.When deploying the Analysis Services project for the first time, you might get the following error message:'A connection cannot be made. Ensure that the server is running. To verify or update the name of… Continue reading Some tips on doing the Analysis Services 2012 Tutorials
In response to my last blog, I received the question: ‘Is Power View supposed to be a replacement for Oracle OBIEE 11g?’ This blog is aimed at answering that question. Before we start, however, I would like to say that these opinions expressed here are mine, and no-one else’s opinions. Therefore, if I’ve got some… Continue reading Is Power View supposed to be a replacement for Oracle BI Answers in OBIEE 11g
At first glance, it could be easy to confuse Power View and Report Builder. This blog is aimed at helping you to understand the 'why' of these packages, so that you and your business can get the best out of these complementary reporting packages.I do hear complaints now and again, that the Microsoft Business Intelligence… Continue reading Is Power View meant to replace ReportBuilder?
I was recently asked how to connect Tableau to a Microsoft Tabular model. The concept itself is straightforward in Tableau. In my opinion, tabular models will become more prevalent, so I will start to look at them more detail.It turns out that the individual who questioned me was struggling, unfortunately. The resolution was that he… Continue reading Tabular models and Tableau