We installed Panorama Nova View Flash 6.2.5 and wanted to use it to connect to PowerPivot. While beginning the work, we couldn't connect to the PowerPivot files and would get an error message. My colleague Tomer Horev was in charge of SharePoint installation and also found the following solution. We understood what the problem was through the help of Panorama support. We tried to connect to the cube that's created for our PowerPivot file through the Management Studio. That meant connecting to the SSAS DB with the name of: http://servername/foldername/filename.xlsx ...
Yes I know. I can hardly believe it myself. I'm here again. And I'm glad to be back. So… to business! We wanted to create reports on an excel file our user was updating. We loaded the data into PowerPivot, published the Excel 2010 file into a SharePoint 2010 library and then created Panorama Flash views on top of that (and that's me making a very long story short!).
The daily Excel data update worked fine until… one day it didn't. Obviously it's just a few days before a presentation to our head of department :) My colleague Tomer Horev,...
I have recently been to the last BI User group which hosted a lecture from Mr. Dany Hoter, Senior Program Manager at Microsoft. Last time I saw Mr. Hoter speak was about Excel 2007. Yes, it's been a while. But I dare say that the fact I remember his lecture, speaks volumes on how much I enjoyed hearing him. This time around, Mr. Hoter spoke to us about Excel 2013 (how time flies...)
The lecture itself was filled with demos Mr. Hoter did and showed on an Excel 2013 workbook he put at an Office 365 site, which is at...
I've decided to make a post to round up all the learning days of MOC 50429 SharePoint 2010 Business Intelligence. Hope this somehow helps you reach all the data:
SharePoint 2010 BI Center and Excel Services
SharePoint 2010 PerformancePoint Dashboard
SharePoint 2010 Designer
SharePoint 2010 and BI: PowerPivot and Entity Profile Page
Access and Visio Services and Spatial Data in SharePoint 2010
I would also like include for all us beginners videoes with basic steps on all the services you have for BI in SharePoint 2010.
I have recently posted an article in Silicon India comparing SQL Server 2012 BI tools and means of development. I addressed there the tools in SQL Server 2012: SSRS, Report Builder 3.0, Power View, Tabular and Multidimensional Analysis Services.Though I tried to cover much ground in the article, I would still recommend some additional reading: A short comparison between Tabular mode vs. PowerPivot A more detailed comparison between Tabular mode vs. PowerPivot vs. Multidimensional SSAS ...
I have recently finished MOC 50429 SharePoint 2010 Business Intelligence with Lior Cohen Amikam which I found very enlightening. I thought I’d share with you some of the excerpts from my summaries throughout the course. It’s a mix of ideas of what to do with SharePoint BI abilities and a short description of what they are. This is the fourth post in a series of posts that I am making from the material of the course:
Entity Profile Page
If the entity I’m using is for instance a customer, and the table describing that customer has a long list of columns...
Via BI/BPM - The SeeQueL, I have recently learned of a great new site I would like to share with you: MSBIAcademy. MSBIAcademy is a site created by Rob Kerr, SQL Server MVP and CTO at BlueGranite. The site currently offers lessons on: Excel, Integration Services, Data Warehouse Design, SQL Server, Mobile, SharePoint, Analysis Services (both Tabular and Multidimensional) and PowerView! Quite the impressive list. Most lessons are on the latest version of SQL Server, but guide lines given in them are true for earlier versions as well.
I highly recommend you check out MSBIAcademy as in short lessons of...
In a short newspaper article a friend stumbled upon, he saw that Mr. Kamal Hathi, Director of Program Management at Microsoft is coming to Israel for the Think Next Convention. It was also detailed that Mr. Hathi was responsible for the SQL Server Business Intelligence technologies. As the time of the convention drew nearer, I felt more and more interested in trying to catch him for an interview about SQL Server 2012.
At the end, I had to finish my questions quickly as Mr. Hathi did not stay till the convention, but I did feel like I had quite...
SoftArtisans have approached me to write a review about OfficeWriter v8 integration with SSRS. Your first question would be: what's OfficeWriter? :)
OfficeWriter is an application that works with Reporting Services in two ways:
1. It Allows you to design a report in Word or Excel and render it to an RDL
2. It allows you to take data from an RDL report and use it in a Word or Excel document
I believe just those two point hold within them quite a lot, but we'll get to that shortly.
I decided to try my hand at creating a report on Adventure Works data:
SQL Server 2012 was released last weekend (and yes, I know this means I’m late to blog about it!). Along with it were released the Data Mining Add-In for Excel 2010 (with a 64 bit version) and PowerPivot v2.0. Whether your company just bought SQL Server 2012, you downloaded the Express Edition or the Evaluation, you could probably still use some help. The ”Introducing Microsoft SQL Server 2012 (second DRAFT preview)” EBook was released in January and is free to download – enjoy!