SharePoint 2010 BI Center and Excel Services

Wednesday, May 16, 2012

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 will be the first post in a series of posts that I am making from the material of the course.   My Site in SharePoint We can leverage the user’s personal page to show his photo (a personal touch), his history of reports and his...

Mr. Kamal Hathi on SQL Server 2012, PowerPivot, SharePoint and Azure

Monday, April 30, 2012

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...

OfficeWriter v8 for SSRS

Wednesday, April 4, 2012

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: I...

Advanced Dashboard Creation with SharePoint 2010

Monday, November 29, 2010

This is a live post from the session of Asaf Bar and Erez Avital at Tech Ed Israel 2010 . SharePoint 2010 enables us getting a BI solution with a workflow, social computing and an office integrated solution. Tools for BI in SharePoint 2010:PerformancePoint (is the main tool for BI in SharePoint)Excel ServicesPowerPivotVisio ServicesSQL Reporting Services We can use Lync to connect to the employees in the workplace directly from the SharePoint Dashboard. We can add a comment to the values in the scorecard to communicate with each other. Dashboard Designer in SharePoint 2010 opens as a click once application. We can create different...
no comments

Amir Netz and Ariel Netz Talk on PowerPivot, DAX, Report Builder and PivotViewer

Monday, August 16, 2010

Ok, so the unexpected happened - about a month and a half after interviewing Mr. Donald Farmer, I got to interview Mr. Amir Netz and Mr. Ariel Netz! I know!... You probably remember Mr. Amir Netz from his appearance in the recent keynote session in the BI conference in New Orleans. He spoke about what's going to be new in PowerPivot. When I heard he was coming to Israel for a conference discussing Panorama and PowerPivot, I decided I'd try to get a few more tidbits from him... In the keynote session, Mr. Netz had talked about adding the ability to...

PowerPivot and Panorama Nova View

Wednesday, August 11, 2010

Mr. Amir Netz, Distinguished Engineer at Microsoft, came to lecture about Self - Service BI and Panorama, along with Kobi Averbuch, VP of R&D at Panorama. These are a few of the major points in their lecture: PowerPivot IT cannot meet all demands. People will try to find a solution themselves.We need a technology to bridge the gap. How to build a PowerPivot application We start by installing the PowerPivot add - in. PowerPivot runs in - memory using the Vertipaq engine that ensures quick time response.All this is without indexing and caching. We connect to the various data sources and bring the data...

Donald Farmer on SQL Server 2008 R2, SharePoint and PowerPivot

Monday, June 14, 2010

If you're following this blog, then you know that Sunday, May 30th 2010, I went to the SQL & BI Data Platform convention held in Tel Aviv. Specifically, I went to Mr. Donald Farmer's seminar on Data Integration in Large Organizations. I did live blogging from most of the event, though actually, I didn't manage to blog about the last part of it, because I was preparing for something that was pretty big for me.... I'll start over. When I first heard Mr. Farmer was coming to lecture in Israel, I was like "What? Really? Like, Donald Farmer? Like THE...

Live Blogging Data Integration in Large Organizations

Sunday, May 30, 2010

This is live blogging from the Donald Farmer seminar from the SQL & BI convention in Tel Aviv. I would really like to thank Hamada who lent me his netstick so I can blog - Thanks Hamada! Business Intelligence is about people not about IT.Your data is always connected to real world and in direct connection to it. It's important to know your business for you to design a good Decision Support system.BI has always been in the middle of the spectrum - tactical decisions. CEO and operational workers will usually look just at your BI reports, they won't create...

BI capabilities in Office 2010 – SharePoint, Excel and Project

Wednesday, May 12, 2010

Office 2010 RTM - ed on the end of April. You probably heard already about PowerPivot and Excel 2010. And of course there's also SharePoint 2010 which has Excel Services, Visio Services, Access Services, PerformancePoint Services and PowerPivot integration. Still, that doesn't make for the entire BI scope in Office 2010. I have just recently learned that there are BI capabilities in Project Server 2010. Going deeper I have learned that there were already such capabilities in Project Server 2007 which integrated with PerformancePoint Services 2007... still, never too late to learn something new :) Project 2010 has multiple...

Microsoft All UP BI Demo version 9.2

Thursday, March 25, 2010

I knew from Russell Christopher's blog that Microsoft All UP BI Demo version 9.2 was released to partners, but as I'm not a registered partner, that didn't help me much... So I was delighted to discover today from the RDA blog that "Microsoft has configured a remote server for general public to get hands on experience with this new BI version 9.2 solution" - so yes, you can take that baby off for a spin!You need to register to the site first, run a .exe to enable the ActiveX to run from that site and download the demo script. After that,...