SharePoint Saturday Presentation and Samples

Hi all,

Thanks a lot for everyone honored us by being there in the SharePoint Saturday event 16th October 2010.


Presentation Cover


In this post  – and the updated ones – I’ll post all the related content of my session [SharePoint 2010 Business Intelligence Insights] ISA

You can download the presentation file from here

Then, to configure the lap machine please follow the following steps:

  1. Download the 180 days evaluation software from the following links, if you don’t have licensed ones:
    • Windows Server 2008 evaluation from here.
    • SQL Server 2008 R2 evaluation from here.
    • Office Professional Plus 2010  evaluation  from here, this one only works for 60 days unfortunately Sad smile.
    • SharePoint designer 2010 from here, this one is free Smile.
    • Download the SQL Server 2008 R2 AdventureWorks sample database from here.
    • Download PowerPivot for SharePoint and excel from here, this one is free Smile.
  2. Follow the following guide to have SharePoint 2010 installed here.
  3. When you been asked to create a site collection, create one using the Business Intelligence Center Template.
  4. Install the SQL Server 2008 R2 AdventureWorks sample database executable.
  5. Follow this guide to install the analysis services database.
  6. Install Office Professional Plus 2010.
  7. Install PowerPivot fro excel ( the download page has a small guide for that).
  8. Install PowerPivot for SharePoint using this guide.
  9. Configure Excel Services using this guide.
  10. Add the Data Connection Library on your BI Center to the trusted data connection libraries on the Excel Services manage page.
  11. Configure the unattended service account for PerformancePoint Services using this guide.
  12. To be able to open Office files from SharePoint without annoying unknown errors enable the Desktop Experience Feature using the following guide.


Now, you have the presentation and lap machine up and running.

Kindly, note that additional configuration steps will be added within their related demos, as the above setup is the basic one.

Please, try to create the machine and let me know if you need any help.

ISA in the following posts, I’ll create samples using the above created machine on the different tools of the Microsoft BI framework.

I hope that helped


Just back from Oslo Dev Night!

I just got back to home from the Oslo Dev Night; I was going to bed, but I couldn’t without writing about that session 🙂

The session, the people, the speaker, the place and of course Amr El Garhy were just perfect.

Imran, you were simply brilliant, I enjoyed listing to you a lot, thank you.

Really, I had a lot of information now about Oslo that I want to share with you.

Oslo is the code name for the new Microsoft SOA modeling platform, that enables Business Analysts, Designers and Developers to design and develop applications with a very deep level of abstraction.

It’s the new advance from Microsoft into the Model-Driven Development.

Oslo is basically consists of three major components:













Using Oslo enables all the involved people in the software development –from the business analyst to the IT support engineers- to share and model the entire application using visual modeling and domain specific language and share all the models and specifications in one centralized database repository.

You can think of each model in Oslo as a schema of a table in the database with all the constraints and validations applied, and each instance of that model is a new row added to that table.

Model can be business process, workflow activity or even entity in the application.

Oslo stores all the Models and the Model instances in the database, and gives you the ability to reuse models in different scenarios, export them to XAML, visualize them and more capabilities.

The Oslo run time components responsible of the loading of the models from repository and executing them, so we have the ability to build production software by just model it in our domain specific language and with visual support.

Another very interesting feature in Oslo, the high level of integration with Visual Studio, for example you can write a workflow activity  in Visual Studio and import it into Oslo repository and vise versa, amazing right? 🙂

I’ll get more hands on Oslo, the M language and Oslo tools and I’ll post more about how to use it ISA, once I had time of course 🙂

One of the great news that I heard in the events, that the Performance Point Server will be integrated into SharePoint and there is a new SharePoint on the way, cheers!

I hope that helped