Different steps in BI projects

Monday, June 16, 2014

A project I just did for the municipality’s Sanitation Department made us rethink the different steps in BI projects in our team. Up till now, we would first have meetings with the customer and the operational system developer to learn what the client wants and what are the corresponding tables in the system.  We would then sit and write two documents – one for the customer detailing what we’re about to give him, and one for the BI developer detailing which tables should be extracted and how they should be manipulated. The client would have to wait two months (at...
no comments

MOC 50429 SharePoint 2010 Business Intelligence

Monday, August 27, 2012

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 Reporting Services and JavaScript 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.

A Comparison between SQL Server 2012 BI Tools

Saturday, July 28, 2012

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

Access and Visio Services and Spatial Data in SharePoint 2010

Wednesday, June 27, 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 is the fifth post in a series of posts that I am making from the material of the course: Access Services Making the data in access available to everybody – just like with the Excel files in Excel services.This enables us to manage the...

SharePoint 2010 and BI: PowerPivot and Entity Profile Page

Tuesday, June 19, 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 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...

SharePoint 2010 Designer

Sunday, June 3, 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 is the third post in a series of posts that I am making from the material of the course.   Business Connectivity Services (BCS) Business Connectivity enables me to connect to an external data source. Allowing the SharePoint user to update\ delete\ insert rows to...
no comments

SharePoint 2010 PerformancePoint Dashboard

Monday, May 21, 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 is the second post in a series of posts that I am making from the material of the course.   PerformancePoint PerformancePoint Dashboard Designer is the place where we connect the different parts of the dashboard one to another. We build the different reports, (scorecard, filter), and...

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

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