fredag 30 oktober 2009

Windows mobile 6.5 for HTC Touch Diamond

Just now upgrading my HTC Touch Diamond 2 to Windows Mobile 6.5 downloaded from HTC homepage, released 2009-10-27.

Make sure you have a backup or your files on the memory stick.

I am running Vista on 64 bit, all you had to do was start the Windows Mobile Device Center and make sure the phone was connected. Download the setup from HTC and execute. The whole process took about 5 minutes (except downloading the setup).

First startup took some time, more or less just about the time as the upgrade... And then some wizards and done!

No problems what so ever, amazing...

torsdag 29 oktober 2009

Trying out new stuff: Yammer

As a part of the dev team at Business Vision you get to be a guinea pig for new services and software. I've been thinking a while about using twitter for internal communications instead of email.
However, some colleagues might not like the thought of everything they write being open for anyone to read, so I've entertained the thought of using some kind of internal twitter-service. I even considered writing a sharepoint web part.
Luckily I shared my plans with a co worker and he suggested using Yammer. That turned out to be really fortunate as I think Yammer is great. It has a great lightweight web UI and an optional desktop client. It keeps the simplicity of twitter while adding a few functions catering to more enterprisey users. For example the ability to create groups that you can restrict your messages (yams?) to.
The dev team is testing it right now. We will probably invite more people to join over the next few days so it's gonna be exciting to see how it is received.
(Pictured to the right is the Yammer desktop client)

onsdag 28 oktober 2009

Presenting the dev team: Dan Sydner

Before we begin, please let me introduce myself. My name is Dan Sydner and I've been at Business Vision for the last 5 years. Before that I studied computer science at KTH.

I spend my time at work doing consulting on the various BI tools Microsoft provides. Everything from handcoding (hardcoding?) SQL to SSRS SSAS and SSIS. I also do in house programming in C#, mostly maintaining our report delivery platform, Vision Reporter Web.


And last but not least I'm the editor of this blog! Trying to keep the other guys, Kalle and Richard in line.

Excel 2010 - What is new?

I have now been using Office 2010 CTP since the beginning of August and it's now time to give my view on Excel 2010 from a Business Intelligence point of view.

So, what's new? Not much actually, it feels more or less like Excel 2007 except the blue color. It feels more like a service pack or something. They have fixed many things that felt strange in Excel 2007. So the overall judgement is that Excel 2010 is a little bit better in general.

The two major changes that I think is of importance to Business Intelligence users is: Pivot Slicers and Sparklines.

Pivot Slicers
This is nothing but a flat pivot filter but with some intelligence. Instead of drilling down in a tree view, you can now filter from a more intuitive user interface. The main thing however, is that the slicer knows the choices in the filter that contains information.

The typical scenario is when using the time dimension on the current year. The month or quarters that hasn't happened yet, are greyed out. In the example below, there is no male with 5 children that has 0-1 cars in the underlying data set. This works with cubes, tables and PowerPivot (Gemini).

Sparklines


Sparklines is a nice feature, a small diagram in a cell. You can quickly get a feeling for historical data. I can't say it's a revolution but a nice feature. This will also be available in reporting services 2008 R2.

That's it... The big revolution was Excel 2007, now it's just a little bit better in general.

fredag 23 oktober 2009

Gemini - PowerPivot


Right now listening to Donald Farmer about PowerPivot.

He just showed.how to import a 4 000 000 rows from sql server. Really no magic going on, if you are on a slow network 1 000 000 000 rows will take a loooong time.

Also, since powerpivot is a column based store, datamining wont be available at this point. That ruins the data compression.

You will be able to add additional meta data such as calculated nembers and measures. Many functions, mdx-like, like a lot of time functions. So you can more or less skip olap...

The coolest thing though, is that you can import data from multiple sources, ie sap and the web and define relationships between theese sources.

Last post from sharepoint conference 2009

Final note from the airport in las vegas. The grand finale was at LAX at Luxor, real good clubbing.

In total, a very good conference, but not that many news. Last years bi conference in seattle contained most of the stuff here, but this time it seemed to work...

Over and out

Skickat från min HTC Touch Diamond2

torsdag 22 oktober 2009

Connecting Silverlight Web Parts

In Bob German session about integrating Silverlight in SharePoint, did he demonstrate a sound solution of interconnect Silverlight application hosted in Web Parts.

As SharePoint's built-in support for Web Part communication is server side based, it require postbacks when transmitting data between web parts. This is bad, particularly for Silverlight apps as they (usually) loses there states after an postback, and it gives bad user experiences.

However in Bobs solution, the built-in Web Part communication are only used to mediate the DOM object ID between the Silverlight Applications. That enables a Silverlight Web Part to pass data using a HTML bridge. This technique allows instant communication and interaction between Silverlight web parts and Web part configurations on the SharePoint site as usual. Sweet!

Summary of Sharepoint Conference 2009

Ok, so there is one more day left at the conference, but we will be going home in the morning so I think it's time to sumarize the conference from a BI point of view.

I will divide this in Reporting, Monitoring, Analytics and a general sharepoint category. I havent heard one word about planning, so that is completly out of the picture from microsoft.

Reporting> Reporting services 2008 R2 is a great release! It feels like it is a stable and powerful product and together with the new features I think it will be a pleasure after upgrading. Except from maps, nicer looking charts and inline graphics and charts I think connecting multiple datasets to an object is one of the enhancements made.

Monitoring> Not so much has happened on the surface of performance point except the proclarity decomposition diagram. But a lot of work have been made integrating pps in sharepoint, and it's now more or less fully integrated. No more web sites "on the side". Excel services and Office web applications is also really cool. You can both view and edit a word, excel, powerpoint etc online without the client installed. They made an example of two people playing battleship on BI Power Hour. Cool!

Visio Services is a cool new addition to this area. Another way of visualizing information.

Analytics> The main topic here is Gemini a.k.a. Power Pivot. Really cool in memory database that can handle massive amount of data. However, I wonder how many users really are interested in this. I would say it's one or two per big company... Well, we will have to think and analyze this a bit further to see the true business value in this.

General Sharepoint> A lot of things is happening with collaboration and social computing. Everything is getting integrated and starting to feel like facebook. My site is developed, personal blogs and wikis, team sites. Things are starting to feel more mature.

Another thing is offline access to information. A lot of things is happening here. This is a part of the strategy, BI for everyone.

Cloud computing, Sharepoint Online is a strong focus from microsoft, that was made totally clear...

Finally, everything withing the office family is moving into Sharepoint. Integration is the key, so expect more on that area.

That's it for now.

onsdag 21 oktober 2009

Ssrs 2008 r2

Some great news from the new release of reporting services 2008 R2!

Maps, sparklines, inline charts etc and multiple datasets connected to one tablix!

Starting to look really great comparing to other vendors. Also the possibility to make an offline exe of a report, you could send a demo to a customer without the database.

Skickat från min HTC Touch Diamond2

tisdag 20 oktober 2009

Business Connectivity Services (BDC)

First session of today was about the next generation of the Business Data Catalog, now known as the Business Connectivity Services.

They have now added write functionality, which is a great improvement. Also, you can now connect enitities to office. The main example was hooking up a customers table to a sharepoint list, and to outlook contacts and beeing able to edit the back-end system from outlook contacts.

This raises some questions regarding security which wasn't adressed at this point.

You could probably build som neat applications with the new functionality...

First day at conference

There were not many news during todays sessions and key notes, including Steve Balmer. To sumarize the message I would say cloud computing and collaboration is the main theme of day one.

Sharepoint online will be one of the main focus areas from microsoft, and you will be able to run a whole or partial sharepoint enviroment seamlesly. In other words, you can run your critical LOB systems in house and other not so central parts of you sharepoint farm within the cloud.

The other focus area is collaboration including Office Web applications - Share and edit office documents online without installed clients, Gemini (Now officially called PowerPivot) - 100 000 000+ rows for self analytics in excel and social networks - facebook-like functionality built-in in sharepoint.

Sharepoint 2010 and Office 2010 public beta will be released in november 2009 and first version 1:st halv 2010.

Now we are off to meet with the other swedish attendees.

måndag 19 oktober 2009

Profiler Woes

If I ever get my hands on the person responsible for reversing the meaning of "Yes" and "No" on the SQL Server Profiler exit confirmation box...



It's always the same, you're in a hurry to log out for some reason or another, you alt-f4 your way out of all open applications, clicking "No" in all the alerts about saving you work, until you try to do the same with the Profiler.

Well, well maybe I get the chance to have my say at this year's PASS Summit in Seattle next week!

söndag 18 oktober 2009

Sharepoint conference 2009 in las vegas

We are attending the sharepoint conference in Las Vegas!

We will try to post information relevant to business intelligence continously.

måndag 12 oktober 2009

Presenting the dev team: Richard Lautmann

The thing I like the best with working in the Business Intelligence segment is the possibility to make a great impact on a company performance.

The previous years I have primarily been working on shifting focus from our in-house developed products towards building solutions within the Microsoft BI stack. To achieve the same level of functionality within the platform we have developed a number of add-ins or packaged solutions by using the standard components provided by Microsoft.

I have also worked as a BI consultant in many projects and many roles the past 4-5 years. I am currently responsible for our development team at Business Vision and has been since april 2007.

My academic base lies within my Master of Science from the Royal Institute of Technology studies in echonomics at Uppsala University.