Imitating QlickView through Excel 2010

Friday, May 9, 2014

I have recently started a new project for the Sanitation department in the municipality. The Local Recycling and transfer station where the sanitation truck go to dump trash or recycle has a report system that is a QlickView over their operational system. Their power user saw reports being generated by QlickView and offered we see them as well. We showed him earlier what we can do with Panorama Nova View and SSRS but he didn’t buy it. Having seen what QlickView did for the recycling center, I can see why. Though we didn’t have QlickView to offer him as...
no comments

Preview SharePoint List Structure

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

How to define a Smart City

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 NYC...
no comments

Excel 2013 GeoFlow \ Power Map – Pros and Cons

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

SQL Server 2012 Licensing Reviews and Views

Tuesday, November 8, 2011

Microsoft has recently announced the SQL Server 2012 Licensing. 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 Licensing review on the Adatis blog which lists the pros and cons of the new edition and payment method. Amongst other things, they point out that: "The Business Intelligence edition strips away - Advanced Security (Advanced auditing, transparent data encryption) - Data Warehousing (ColumnStore, compression, partitioning) and provides a cut-down, basic (as opposed to advanced) level of High Availability (AlwaysOn)" I felt like I read mostly good feedback from different bloggers on the matter, coming from...

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

SQL Server 2008 R2 November CTP

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

Performance Point integration in SharePoint 2010

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

The future of SQL Server: Project Kilimanjaro, Madison and Gemini

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