Monday, February 3, 2014
We’re starting a new project where we're collecting data, amongst others, from SharePoint lists from the Municipality’s site. Though the SharePoint developers recommended we import data through a web service, we found that SSIS has a component for SharePoint as a data source. We started off by downloading and installing the SSIS component for a SharePoint List Source from CodePlex as it does not come with the SSIS itself. We added the component to our SSIS through the Tools menu > Choose toolbox items and then chose the relevant components:
I needed to predefine for our DBA the tables we...
Monday, January 6, 2014
In the past few months, we've been hearing in the BI team about Smart Cities. We can define a Smart City (according to Wikipedia) as efficiency based on the intelligent management and integrated ICTs (information and communication technology), and active citizen participation.
The term was initially presented to us through a company offering us a POC of a dashboard in SharePoint. They talked with us on what another city in Israel had monitored and talked with us on what was being done, in a very larger scale in New York:
New York Open Data, APIs and Digital Roadmap
NYC Mayor’s Management Report
Tuesday, July 30, 2013
I finally got my hands on Excel 2013 and added to it Power Map (though if to be quite frank with you, it was still called GeoFlow when I did it). I admit I was very enthusiastic after seeing the post on the Excel blog. I would first have to say that visualization is RICH. It is every bit as exciting and beautiful as it looks in the different posts given about it. Seeing things evolve on the map over time really does make a whole lot of sense. You suddenly see things. And yet,...
Tuesday, November 8, 2011
has recently announced the SQL Server 2012
The main news is the new BI edition released with SQL Server 2012 which is
positioned between the Standard edition and the Enterprise edition. You can
read an SQL Server 2012
on the Adatis blog which lists the pros and cons of the new edition and payment
method. Amongst other things, they point out that:
Business Intelligence edition strips away
- Advanced Security (Advanced
auditing, transparent data encryption)
and provides a cut-down, basic (as opposed to advanced) level of High
felt like I read mostly good feedback from different bloggers on the matter,
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:
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...
Wednesday, November 11, 2009
Microsoft just released SQL Server 2008 R2 November CTP. The November CTP is "feature complete" so this should be close to the real thing, before they ship SQL Server 2008 R2 in 2010. I guess you could tell from the news coming from PASS that this would be in the wings. First of all, there was word that the next CTP would be delivered during November (which translates to: now!) and secondly, projects that before would be code named - now have their formal name. Madison is now Parallel Data Warehouse and boasts scalability for the 100+ terabyte DWH...
Monday, November 2, 2009
Microsoft had released not too long ago, the last Service Pack for the standalone version of PerformancePoint Services - PerformancePoint Server 2007 SP3. From here on out, all development for PPS is going to be part of SharePoint Server. This is again part of Microsoft's strategy of empowering SharePoint as a product, as it also connects to Excel Services, Reporting Services (including Report Builder) and Visio Services.So what's new to PerformancePoint 2010?
SharePoint Server 2010 as the repository - meaning PerformancePoint Services stores data sources in document libraries and all other dashboard content in lists.
PerformancePoint Services uses SharePoint Server 2010...
Tuesday, October 7, 2008
The Microsoft BI Conference 2008 has been the source for quite a few announcements. First of all, now that DATAllegro was purchased by Microsoft, the talk is about SQL Server handling bigger amounts of data. There have been posts not just about terabyte projects, but also petabyte projects. The full integration of DATAllegro's technology into SQL Server is planned for the first half of calendar year 2010 and is code named Project Madison. SQL Server 2010 itself is code named Project Kilimanjaro.
The real surprise? Project Gemini which sounds like Microsoft giving QlickView a run for its money... but I'm...