Blog Home  Home RSS 2.0 Atom 1.0 CDF  
some thoughts... - BI
IT makes the world go round - and sometimes stops it...
 
 Monday, September 24, 2007

A long time ago - February and March 2006 - Eugene Asahara has posted two very intersting articles about

The "KPI Cause and Effect Visio Graph" is a very useful visualization tool to diskuss KPI´s with the prospective users whereas the "KPIRelationships sample application" is a very smart tool to control if all perspectives, KPI´s, etc are developed and have the right definitions.

This two articles are a really must-read and Eugene also provides the tools for download - so check it out!

Monday, September 24, 2007 8:10:02 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |   | 
 Monday, May 07, 2007

 

With the conference beginning on Tuesday with the Welcome Reception, I tried to build my schedule online today.
But as expected I have had a problem while choosing my schedule because there are some slots with many interesting session - I will have to choose spontaneously which session I attend...

Tuesday, May 8

3:00 PM - 8:30 PM
Registration   North Lobby, WSCTC    
 
6:00 PM - 8:30 PM
Welcome Reception   Hall 4CD, WSCTC    
 

Wednesday, May 9

7:00 AM - 7:00 PM
Registration   North Lobby, WSCTC    
 
7:00 AM - 8:00 AM
Breakfast   Hall 4AB, WSCTC    
 
8:00 AM - 10:15 AM
General Session - Jeff Raikes, Michael Treacy   Hall 4F    
 
10:15 AM - 10:30 AM
Break       
 
10:30 AM - 11:45 AM
BV108 Building a Plan for Success and Avoiding the Five Fatal Flaws of Business Intelligence   6C    
CL208 Enabling End-User, Ad-Hoc Reporting with Microsoft SQL Server 2005 Reporting Services   608/609    
 
11:45 AM - 1:00 PM
Lunch   Hall 4AB, WSCTC    
 
11:45 AM - 12:45 PM
 
11:45 AM - 2:30 PM
Solution Expo Hall Open   Hall 4E    
 
1:30 PM - 2:15 PM
Platinum Sponsor Session: Hewlett-Packard (HP) Transforming Information for Better Business Outcomes   6B    
 
2:15 PM - 2:30 PM
Break       
 
2:30 PM - 3:45 PM
PL203 Innovating Data Integration with Microsoft SQL Server 2005 Integration Services   6B    
 
3:45 PM - 4:00 PM
Break       
 
4:00 PM - 5:15 PM
CL301 Extending Enterprise Search Capabilities to your BI Applications   6B    
CT30 Writing MDX for KPIs   Chalk Talk Theater 3    
PL306 Practical Design Techniques for Modeling Common Business Scenarios in Analysis Services 2005   6E    
 
5:15 PM - 5:30 PM
Break       
 
5:30 PM - 6:45 PM
BV102 Business Value of Master Data Management   6C    
CT31 SQL Server Integration Services: Moving from development to test, from test to production   Chalk Talk Theater 3    
PL207 Microsoft SQL Server 2005 Reporting Services Integration with Microsoft Office SharePoint Server 2007   6B    
 
6:45 PM - 9:00 PM
Partner Solution Expo Reception/ Community Area Open   Hall 4E    
 

Thursday, May 10

7:00 AM - 7:00 PM
Registration       
 
7:00 AM - 8:00 AM
Breakfast   Hall 4AB, WSCTC    
 
8:00 AM - 10:15 AM
General Session - Ted Kummert, Dr. Robert Kaplan   Hall 4F    
 
10:15 AM - 10:30 AM
Break       
 
10:30 AM - 11:45 AM
CL201 Microsoft Office PerformancePoint Server2007: Business Modeling and Planning   6E    
PL204 Business Intelligence at Microsoft – a Center of Excellence View   6B    
 
11:45 AM - 1:00 PM
Lunch   Hall 4AB, WSCTC    
 
11:45 AM - 12:45 PM
 
11:45 AM - 2:30 PM
Solution Expo Hall Open   Hall 4E    
 
1:30 PM - 2:15 PM
Platinum Sponsor Session: Tata Consultancy (TCS) Creating Agile, Adaptable and Efficient Enterprises via Fast Track and Cost-Effective BI Solutioning: Speedily and Cost-Effectively filling the gap between People and Data   6C    
 
2:15 PM - 2:30 PM
Break       
 
2:30 PM - 3:45 PM
CL206 Delivering intelligence through Microsoft Office SharePoint Server 2007 (MOSS)   6E    
PL209 Microsoft Business Intelligence for SAP   608/609    
PL410 Real-World Microsoft BI Implementations: Lessons Learned the Hard Way   6B    
 
3:45 PM - 4:00 PM
Break       
 
4:00 PM - 5:15 PM
CL211 BI Power Hour   6E    
CL212 Reporting Services: Enrich your report authoring experience through Microsoft Office   608/609    
PL302 Microsoft SQL Server 2005 Analysis Services Best Practices around Performance and Scale   6B    
PL303 Using SQL Server 2005 Integration Services to Populate a Kimball Method Data Warehouse   6C    
 
6:30 PM - 11:30 PM
Microsoft BI Conference 2007 Attendee Party & Awards Ceremony at Experience Music Project       
 

Friday, May 11

7:00 AM - 12:00 PM

Registration     

 

7:00 AM - 8:00 AM

Breakfast   Hall 4AB, WSCTC  

 

8:00 AM - 9:15 AM

General Session - Steve Ballmer   Hall 4F  

 

9:15 AM - 9:45 AM

Break     

 

9:45 AM - 11:00 AM

BV109 Aligning IT with Business Needs Around BI: War Stories and Lessons Learned   6C  

 

CL204 Master Data Management: What's Microsoft Thinking?   6E  

 

CL210 PerformancePoint Server for the Mid-Market   608/609  

 

11:00 AM - 11:15 AM

Break     

 

11:15 AM - 12:30 PM

CL207 Microsoft Office Excel 2007 and Microsoft SQL Server 2005 Analysis Services   6E  

 

PL201 SOA and Business Intelligence   6B  

 

12:00 PM - 1:15 PM

Lunch   Hall 4AB, WSCTC    
 
Monday, May 07, 2007 1:00:08 AM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |   | 
 Tuesday, August 15, 2006

Mark Miller has shared his experiences on competing against a SAP solution offering in his article SAP the New BI Player .

It seems that I am not the only one who expects that SAP is going to push the Business Warehouse within a short time to engage a new target group - even though they are bundling a bunch of components to SAP Netweaver (including BI, Enterprise Portal and some other interesting applications)...
Sure there are enough SAP core customers which are not using BW at the moment to engage, but MS also is entering the market of SAP core customers with tools and techniques like SQL Server Reporting Services, Biztalk, Performance Point Server and so on. We will have to wait and see...

Mark also mentions the concept of BI Accelerator for high performance analytics and there we both also have the very same opinion:

"They also have the BI Accelerator for high performance analytics (i.e. hardware and extra license fees) to make your large queries respond quickly. Not a one running in Australia yet. My perception is that this is a mistake in product marketing for SAP. It makes it sound like if you have lot of data, you're going have performance problems so you need to invest in additional hardware and we are going charge you an additional license because the one you already bought doesn’t do the job. SAP needs to rethink this."

Sounds very weird, doesn´t it? ;-)

Tuesday, August 15, 2006 6:34:26 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |   | 
 Tuesday, July 11, 2006

The "Microsoft Architect Insight Conference" was held on 22 - 23 March 2006 and the slides are now available for download.

I would highly recommend that you read the PPT about Service-oriented Business Intelligence (SoBI) by Sean Gordon, Robert Grigg, Michael Horne, and Simon Thurman, which brings up some really good new approaches.
The authors also have published an article, which contains a more detailed descriptions and is available online.

And here are two additional links extracted from the article page:

You also should have an eye for the slides of Eric Nelson, who tries to explain that there are seven new servers in the SQL world...

Tuesday, July 11, 2006 11:36:32 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |  |  |   | 

You surely know "Project REAL", the SQL Server 2005 reference implementation at Barnes & Noble. It contains information on all upcoming topics in a BI project.

And now...
your are not only able to read about it - you are able to download a whole subset of the project REAL data and the various parts of the implementation

Extract from the website:
"The kit contains:

1. A set of instructions for setting up the environment
2. Guidance on how to explore the implementation
3. A sample relational data warehouse database (a subset of the Project REAL data warehouse)
4. A sample source database (from which we pull incremental updates)
5. SSIS packages that implement the ETL operations
6. An SSAS cube definition and scripts for processing the cube from the sample warehouse
7. Sample SSRS reports
8. Sample data mining models for predicting out-of-stock conditions in stores
9. Sample client views in briefing books for the Proclarity and Panorama BI front-end tools

This kit will guide you through the key points to observe in the Project REAL implementation. Use it to learn and to get ideas for your own implementation. (While we believe it represents a very good design and generally follows best practices, it should not be regarded as the solution for every BI situation.) It will be helpful to see the overview presentations about the BI tools in SQL Server, or read documentation, before exploring the kit. One good source of information is to go through the tutorials that ship with SQL Server (the tutorials are installed when you select “Workstation components, Books Online and development tools” at installation time)."

Tuesday, July 11, 2006 10:59:25 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |  |  |   | 

Chris Webb has blogged about the "Business Intelligence Architecture and Design Guide" downloadable at gotdotnet.

I agree with Chris, this is not really new stuff, but I personally think it is good to have informations like this in a kind of "complete package".

Extract from the website:
"The patterns & practices team is please to announce the availability of Architecture and Design Guidelines for Business Intelligence Applications. This exploratory community project provides prescriptive guidance on how to overcome architectural challenges and design issues when building Business Intelligence solutions using Microsoft platform. This guide is intended for software architects and developers who are developing Business Intelligence applications on the Microsoft .NET Framework using SQL Server 2005 - Integration Services and Analysis Services. Being an exploratory community project - anticipate gaps and scope for improvement. For more information see: http://codegallery.gotdotnet.com/biguide."

Tuesday, July 11, 2006 10:47:16 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |  |   | 
 Tuesday, June 06, 2006

Yet another version 2.0 of a three-letter-buzzword you may think...

But the article "Information Management: DW 2.0 - Architecture for the Next Generation of Data Warehousing" is provided by Bill Inmon, the father of data warehouse.

The article acommodates the encreased needs, the gathered work experience and also the developed status of hard- and software.

Read carefully - in my opinion it is more than another "version 2.0" hype...

If you want to know more than written in the article, you could register here.

Tuesday, June 06, 2006 3:37:03 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   | 
 Friday, May 26, 2006

With SP1 SQL Server Reporting Services 2005 will now also accept SAP BW as a data source. The connection will be established without any custom code in SAP BW (and therefor no need of installation assistance by SAP Administration) using XML/A (XML for Analysis, XML standard for Online Analytical Processing [OLAP] using standard Internet protocols), which is an established standard as described at the website of the organization (http://www.xmla.org/, http://www.xmlforanalysis.com/).

Microsoft provides a really good white paper, which includes a step-by-step guidance and also describes some prerequisites and basics. There is also a video, which visualizes the described steps of the white paper.

The whole documentation and the connect to SAP BW is real good work, but some things regarding "real life" is not included in the white paper or is not mentioned as clearly as needed - in my personal opinion.

Basic Information

The SDN at http://www.sdn.sap.com/ (SAP Developers Network - do not hesitate to surf there, you will not get infected... :-) ) provides a real good basic information as pdf-file for XML for Analysis from the SAP point of view.

SAP System Prerequisites

If you are authorized to connect to the SAP system and would like to test if the XMLA SOAP Services is up and running please use transaction SICF (Service Maintenance) to check this - as described in the above mentioned pdf-file on page 14. And if SAP Administration does not know how to verify this hand them over the pdf-file...

You will also be able to discover the service url using the transaction SE37 and the function module RSBB_URL_PREFIX_GET as desribed on page 13.

Patch Level

As described in the white paper, there is a certain patch level required to assure a working XMLA-Connect.

  • Support Package 30 for SAP BW 3.0B
  • Support Package 24 for SAP BW 3.1
  • Support Package 16 for SAP BW 3.5
  • Support Package 6 for SAP NetWeaver 2004s (BW 7.0)

Other patch levels will also work BUT... will not support real interesting things like selections via variables for example. But I would suggest that you COULD use Reporting Services to do a real smart master data reporting for example - the best way to convince the stakeholder of the SAP System that doing the patching will be really worth the work.

You will not be able to convince the SAP Administration to do the patching required for Reporting Services, because implementing a Patch is not as "easy" as in the SQL Server World, doing a patch in SAP BW definitely means a own and time intense project, because all implementations in the system have to be checked, if they would work as expected and as designed at the current patch level.

So just think about this point and do not hassle with SAP Administration and please do not start moaning, if they are not willing to do the patch update - remember, it is not as in other worlds...

Language / Communication with SAP BW Developers

Do not wonder about the terms that SAP Developers are using while talking about the objects in SAP BW - this will be different from the terms you will encounter using XMLA or you certainly will know from the SQL Server world. So communication sometimes will be difficult but an accurate translation will be helpful and is also provided in the pdf-file on page 19 and 20. 

Security & Single Sign on (SSO)

To be shure, that we think and talk about the same thing while having SSO in the mind first a definition:

"What’s the Difference Between Authentication and Single Sign-On?

Authentication, or initial authentication, occurs when users first identify themselves to a system, and in turn this identification is verified. Initial authentication in SAP environments can take a number of different forms, ranging from anonymous or guest access to a Web site through the familiar user ID and password procedure, to using X.509 digital certificates.

Where single sign-on is in place, the user is issued credentials in one form or another following initial authentication. This allows the user to forego subsequent authentication steps when accessing further systems, offering not only convenience, but also increased security by limiting the number of times users enter sensitive information. This reduces the temptation for users to choose an easy-to-guess password. Single sign-on authenticates the user to access all the applications they have been given rights to in the SSO landscape, and eliminates future authentication prompts when the user switches applications during that particular session."
[from the SAP Developers Network]

But what does this mean regarding RS on SAP BW?
While SAP BW is a data storage and reporting system whith an own authorization system you definitely would like to make the usage of the reports as comfortable as possible. Though a user should not need to athenticate against the SAP system as backend while running the different reports and provide his credentials again and again. Therefor a automatic authentification should be possible and established by the system without contacting the user.

Normally in enterprise environments you will not face a homogeneous landscape whith SAP BW residing on a Windows Server but will discover, that SAP BW is running on a UNIX OS.

If you are a lucky one with SAP in a windows environment, you probably will be able to use kerberos and the SAP CUA (central user administration) and this will be the right documentation:

But what to do, if you are facing the "standard", SAP BW on UNIX OS??
There are alos certain ways to implement a SSO solution between Windows and UNIX, including Kerberos, or 3rd-Party-Tools like the ticketing with the Tivoli Access Manager or the solution from secude. You will find appropriate documents on the SDN or other sources like:

If you do not like to establish the SSO via a 3rd-Party-Tool and are using the SAP ITS (Internet Transaction Server) than you should read this article provided by Thomas Jung very intendly.

If you can not solve the above mentioned topics, you probably could use a technical user to connect RS via XML/A, but please consider, that the user authorization in SAP BW normally is based on so called authorization objects (for example key identifiers like company code) and you will not be able to use this build-in security concept for the user while using a technical one and though you will have a loose of security. If you are just planning to deploy master data reports, than the use of a technical user could be without security concerns.

I would highly recommend that you avoid a scenario where you implement your own security structure in Reporting Services or in SQL Server. Then you are only building up certain places for administration and could not be sure that your "home-made" security provides the same security settings for the users as the settings in SAP BW. And because of SAP BW normally being the leading system and the main reporting system you should prevent this situation.

Please do not forget to ONLY use the https-SOAP-Connection, whether you are using SSO nor provide the credentials via the reporting manager application during the report call.

Conclusion

Doing Reporting Services on SAP BW is a good option to enhance enterprise reporting towards the microsoft plattform regardless, which data source is connected. Doing so also will bring up some points for discussion or some pain points - if you face a hardliner SAP Administration for example... :-)
But to be honest, you also would not be really glad if your SQL Server data would be assimilated by a SAP BW system, would you?

If someone has other arguements, opinions and especially hints on the SSO-topic please feel free to use the comments

Friday, May 26, 2006 12:59:39 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |   | 
 Monday, March 06, 2006

This video highlights two mission-critical applications within Microsoft that take advantage of SQL Server 2005: MS Sales, a worldwide revenue reporting system, and SAP R/3, an enterprise resource planning system.

http://www.microsoft.com/downloads/details.aspx?FamilyID=2ef438a4-4ae3-4d7b-bfe5-037c954f72c0&DisplayLang=en

Monday, March 06, 2006 7:09:07 AM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |  |  |  |  |   | 

Discussion on how Microsoft IT used SQL Server 2005 to deliver Microsoft Report Analytics, a robust, ad hoc reporting application and MS Sales Business Intelligence, a comprehensive business intelligence solution.

http://www.microsoft.com/downloads/details.aspx?FamilyID=92fbac74-0ca3-4b47-98ca-85014ec5df26&DisplayLang=en

Monday, March 06, 2006 7:06:52 AM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |  |  |   | 

There is an interesting artice available called "Installation of the Microsoft BI Suite (SSRS, SSAS, SSIS, BSM, SPS, WSS)" published by "the_jim_and_dan_show"

Monday, March 06, 2006 4:14:16 AM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |   | 
 Saturday, February 25, 2006

You shurely know, that Microsoft provides a control to display reports in your own applications without just linking to the SQL Server Reporting Services by http or SOAP. It is a little bit difficult to understand how this control works and especially the difference between the remote mode and the local mode needs to be clarified, I think...

It´s a pity that the the ReportViewer control cannot be extended by adding custom renderers or custom report items - that is the only disadvantage.

Here are some links, that should bring up light into the dark:

Microsoft Report Viewer Redistributable 2005
[As a german developer you will need the Microsoft Report Viewer 2005 Language Pack Deutsch to bring up the right screen messages]

http://www.gotreportviewer.com/, which provides informations and sample codes to give a quick start. Especially the difference between local mode and remote mode is described clearly.

MSDN article about ReportViewer Controls (Visual Studio)

MSDN Forum: Visual Studio Report Controls

Teo Lachev, Building Report-enabled Applications with the New ReportViewer Controls (Part 1 of 2)

Teo Lachev, Building Report-enabled Applications with the New ReportViewer Controls (Part 2 of 2)

Saturday, February 25, 2006 10:10:22 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |  |  |   | 
 Wednesday, February 22, 2006

Project REAL is a cooperative effort between Microsoft and a number of technology partners in the business intelligence (BI) industry to build on actual customer scenarios to discover best practices for creating BI applications based on SQL Server 2005. The term REAL in Project REAL is an acronym for Reference implementation, End-to-end, At scale, and Lots of users.

This page gives tons of informations and really is worth reading carefully and staying for hours!

Wednesday, February 22, 2006 5:45:32 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |  |   | 

Crystal Xcelsius - formerly known as Infommersion Xcelsius - is a kind of Dashboard Designer where the development ends up in an interactive flash-file.

You can have a look at the gallery here: http://www.xcelsius.com/Examples/Overview.html.

Wednesday, February 22, 2006 5:21:49 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |   | 

DBxtra is defined as an ad-hoc reporting tool and is very interesting if your scenario does not include MS SQL Server Reporting Services and you have to use an alternative reporting solution.

If you are interested watch the movie or start the download of a 30day trial version.

Wednesday, February 22, 2006 5:18:40 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [1]   |   | 

Jedox - normally known for the Worksheet-Server has released a Open-Source OLAP-Server called PALO a while ago.
You will find more Informations at the Jedox-website or on the official PALO-pages.
The free download is placed here.

Wednesday, February 22, 2006 4:26:58 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |   | 

Without Office 2007 (Office 12) having hit the market you could use this for BI...
But please regard that this download is available at a Microsoft website but is not a supported product, it is just a demonstration - but it is a really good one!

Business Intelligence Portal Sample Application for Microsoft Office 2003

Extract from the website:
"The business intelligence portal sample application for Microsoft Office 2003 is an integrated, customizable, multilingual, Web-based OLAP solution that enables employees in an organization to create and share structured views (OLAP and Relational) and unstructured views (Documents and URLs), based on various data sources, such as SQL Server 2000 Analysis Services, offline cube files, relational databases, SQL Server Reporting Services reports, spreadsheet data files, XML Web services, XML files, and any requested URL.
The business intelligence portal is entirely built on top of Microsoft Windows® SharePoint® Services. It extends Office Web components capabilities, and uses SQL Server Reporting Services. The BIP Viewer is a smart Web Part that can show multiple views from multiple sources and filter data based on Web Part connections with other Web Parts such as the Business Scorecard accelerator.
The business intelligence portal also contains an add-in for Office 2003, that enables end users to consume reports and OLAP-based views (charts and PivotTable reports) directly into Microsoft Outlook®, Microsoft PowerPoint®, Microsoft Excel, and Microsoft Word documents. This can streamline their daily work, and enhance their business productivity."

Wednesday, February 22, 2006 4:12:49 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |  |  |  |   | 
 Sunday, February 19, 2006

Microsoft offers free e-learning courses for SSAS, SSIS and SSRS as a kind of delta-courses to enable an update of your knowledge to SQL 2005.

Course 2942: New Features of Microsoft® SQL Server™ 2005 Analysis Services

Extract from the website:
"Description:
This course will enable business intelligence developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into five modules.

  • Exploring SQL Server™ 2005 Analysis Services Core Concepts and Architecture
  • Designing and Deploying a Unified Dimensional Model
  • Administering SQL Server™ 2005 Analysis Services
  • Programming in SQL Server™ Analysis Services 2005
  • Working with Data Mining Solutions in SQL Server™ 2005 Analysis Services

Objectives:
At the end of the course, students will be able to:

  • Build a Cube in SQL Server 2005 Analysis Services
  • Administer SQL Server 2005 Analysis Services
  • Program in SQL Server Analysis Services 2005
  • Work with Data Mining Solutions"

Course 2943: Updating Your Data ETL Skills to Microsoft® SQL Server™ 2005 Integration Services

Extract from the website:
"Description:
This course will enable business intelligence developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into four modules.

  • Exploring SQL Server™ 2005 Integration Services Architecture and Core Concepts
  • Designing and Debugging SQL Server™ 2005 Integration Services Packages
  • Rich Functionality in SQL Server™ 2005 Integration Services
  • Extensibility

Objectives:
At the end of the course, students will be able to:

  • Design and debug SSIS Packages
  • Configure and deploy SSIS Packages "

Course 2944: Updating Your Reporting Skills to Microsoft® SQL Server™ 2005 Reporting Services

Extract from the website:
"Description:
This course will enable business intelligence developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into three modules.

  • Exploring the Features and Core Concepts of SQL Server™ 2005 Reporting Services
  • Designing Reports Using Report Designer
  • Deploying and Managing Reports
  • Working with Ad Hoc Reports

Objectives:
At the end of the course, students will be able to:

  • Design Reports Using Report Designer
  • Deploy and Manage Reports
  • Work with Ad Hoc Reports"
Sunday, February 19, 2006 11:18:08 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |   | 

Microsoft has published the documentation about MARS - there internal financial reporting solution - as an "Microsoft IT Showcase".

Extract from the website:
"Overview of how Microsoft implemented a more robust and flexible financial reporting solution by using SQL Server 2005 technologies. By using SQL Server 2005 Analysis Services and SQL Server 2005 Reporting Services, the standard reporting of the financial results was upgraded to provide end users with an effective business intelligence platform that was more flexible and more secure."

Sunday, February 19, 2006 10:44:08 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |   | 
 Friday, February 03, 2006
Friday, February 03, 2006 8:08:35 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   | 
 Saturday, January 14, 2006
 Wednesday, January 11, 2006

BIRT was started in September 2004 as Toplevel-Projectof the Eclipse-Organisation.

It is an open source, Eclipse-based reporting system that integrates with your application to produce compelling reports for both web and PDF and provides core reporting features such as report layout, data access and scripting.

Wednesday, January 11, 2006 6:08:08 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |   | 

LGX Report is a free reporting tool by LogiXML.
There is a new version available, called "LGX Report Liberator+ Edition", which uses Excel as front end for designing.

The website and the reporting gallery gives a good impression about the value of this tool - LogiXML provides also enhanced versions, which are not free.

Anyone tried this tool? Comments appreciated.

Wednesday, January 11, 2006 5:45:12 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |   | 
 Tuesday, January 10, 2006

Visual Studio .NET Web Control for Business Intelligence

This OLAP Web Control, developed by GrapeCity, Inc. brings the OLAP cubes right into your business applications allowing you to view, explore, and summarize data through your browser.
Following are some of the features provided by the control:

  • Drilldown, drillup, slicing, and drillthrough
  • Run-time layout designer
  • Multi-language support
Tuesday, January 10, 2006 5:00:26 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |   | 
 Monday, January 09, 2006

MS did it!

A real MCP for Business Intelligence, called Microsoft Certified IT Professional: Business Intelligence Developer (MCITP: Business Intelligence Developer) will be available soon in English. We will have to wait and see when the German one is ready...

Seems, that they have put very useful stuff together for these exams.

Extract from the website:
"Microsoft Certified IT Professional: Business Intelligence Developer (MCITP: Business Intelligence Developer) is the premier certification for business intelligence system designers and developers. This certification demonstrates that you can design solutions, data transformations, and reports.

Business intelligence developers design and implement multi-dimensional database models (logical and physical), data marts, data warehousing, data transforms, data analytics, and reporting solutions. This includes programming and customizing servers that use MDX, customer transforms, and custom reporting solutions. Business intelligence developers are typically employed by mid-size to large organizations."

Monday, January 09, 2006 11:27:48 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |   | 
 Monday, January 02, 2006

Mauro Cardarelli tries to bring up some clarification regarding Dashboards and Scorecards in his post Dashboards versus Scorecards.

Monday, January 02, 2006 6:08:07 AM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |   | 

As posted before, there are all Office12-Teams blogging about there products.

You will find the Business Scorecard Manager Team Blog here. They haven´t posted many articles but you will find many usefull links there.

If you would like to read a bunch of articles you should visit the blog of Ian Tien called "Ian Tien's Unofficial Business Scorecard Manager Blog - Scorecards and Dashboards for the masses".

Monday, January 02, 2006 5:47:05 AM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |   | 

I just came across this post from Bayer White who is a co-blogger of Brian Knight - they are sharing this Community Server.

There is a website available called msbicentral.com, regarding to the post, this should be a "pilot community and the "the "GOTO", place for Business Intelligence knowledge".

Extraxt from the website:
"Wayne, Brian and I spoke about what the future holds for MSBICentral and came to the conclusion that there were not enough BI Communities. We decided we should do more and make sure that are content is up to date and give examples of BI techniques for 2005. Please hold me accountable to this!"

I think we should do this... ;-)


Extract from msbicentral.com:
"MSBICentral.com is a community site that helps users like yourself learn to develop, use and administer Business Intelligence (BI) solutions using Microsoft products like SQL Server. On this site, you'll find hundreds of articles, scripts and tutorials to help you learn or perfect your BI skills. If you have a question or if you're a business intelligence newbie, look on the left bar for some quick links to get you started.
Please note: You'll need to be logged in with your free account to see articles and use much of the site."

And be ashured, registering is really worth investing the two minutes to fill out the form!

Monday, January 02, 2006 3:11:34 AM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |  |   | 

to be continued...
just to store the links - text will be added...

http://www.msftdwtoolkit.com/
Chapter 13 - Metadata Plan Reporting package:
http://www.msftdwtoolkit.com/ToolsandUtilities/Ch13/DW%20Metadata%20Browser%20Master.zip

Monday, January 02, 2006 2:51:05 AM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |   | 

As Chris Webb posted here, there is a "SQL Server 2005 Business Intelligence Metadata Samples Toolkit", which brings up "Tools and Sample reports for Metadata Dependency Analysis of SSIS, SSAS", available for download for free.

Extract from the website:
"Microsoft SQL Server 2005 BI Metadata Samples provides tools and samples for analysing dependencies within and across SSIS and SSAS. The source code for the tools is provided.
The following are the components of this pack:
DependencyAnalyzer: a utility that scans SSIS packages and SSAS databases for enumerating metadata (objects, properties and dependencies).
DependencyViewer: a utility to view metadata organization & inter-dependencies (lineage/impact analysis).
Analysis Services Samples : sample SSAS packages that can be analyzed
Integration Services Samples: sample SSIS packages that can be analyzed
Report Model Samples (Report Builder): report builder model
Reports: sample reports built from metadata store
SQL: SQL script for creating metadata store
"


You will also be able to download a whitepaper called "SQL Server 2005 Business Intelligence Metadata Whitepaper".

Extract from the website:
"This white paper covers several interesting and unique methods for managing metadata in SQL Server Integration Services, Analysis Services and Reporting Services using built-in features including data lineage, business and technical metadata and impact analysis."

Monday, January 02, 2006 2:32:07 AM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |  |  |  |  |   | 

Mosha Pasumansky has posted his experiances with a presentation about "Analysis Services 2000 vs. 2005".

Extract from the website:
"I have run across a presentation called “Analysis Services 2000 vs. 2005” prepared by Jaimie Basilico and Mark Frawley (Jamie works in Microsoft as Senior Technology Specialist in the East Cost, and he is one of the best field people in Analysis Services that we have). This presentation is targeted towards people who are familiar with Analysis Services 2000 and want to come on speed with Analysis Services 2005. I have found the presentation very useful, but not all subjects are covered in the same depth. Below are my comments [...]"

Full presentation can be found at http://www.nysia.org/events/past/2004/2004129dbprof.pdf

Absolutely worth reading and also worth reading Mosha´s comments!

Monday, January 02, 2006 12:48:44 AM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |  |   | 
 Wednesday, December 28, 2005
Wednesday, December 28, 2005 5:33:13 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   | 

With meta data getting more and more in the focus of BI-Projects you should look at http://www.metaintegration.net/

Here is a little self-explaning extract from there website "Meta Integration is the leading "Metadata Component Provider" to major database, data integration, business intelligence, repository, and modeling tool vendors. [...]"

They have also some publications online, especially the PDF-File Meta-Data Version And Configuration Management In Multi-Vendor Environments seems to be worth reading.

Because of having not tested the mentioned products any comment is appreciated!

Wednesday, December 28, 2005 2:06:50 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |   | 
 Tuesday, December 27, 2005

Microsoft has its own BI-Site up and running!

Look at http://www.microsoftbusinessintelligence.com/

Not many pages up there, but you will be able to register for a Microsoft® Business Intelligence Solutions Kit DVD here.

Tuesday, December 27, 2005 8:13:01 PM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |   | 

MSDN Webcast: Introduction to Microsoft Office Information Bridge Framework (Level 100)
12.01.2005 -  1:00 PM - 2:00 PM Pacific Time (22:00 - 23:00 Uhr MEZ)
Michael Kiselman, Technical Product Manger, Microsoft Corp.

Find out what the buzz is all about. Microsoft Office Information Bridge Framework is a technology that enables developers to create powerful Office-based solutions. In this session, you will learn how to use the Information Bridge Framework to build solutions that extend the value of the Microsoft Office System by providing information workers with the ability to consume line-of-business data from within Office applications.

MSDN Webcast: Building Web Services According to Microsoft Office Information Bridge Framework Guidelines (Level 300)
19.01.2005 -  1:00 PM - 2:00 PM Pacific Time (22:00 - 23:00 Uhr MEZ)
Ricard Roma Dalfo, SDE Lead, Microsoft Corp.

Save time when you learn how to develop solutions more efficiently using the Microsoft Office Information Bridge Framework to connect Microsoft Office-based applications with Web services. Join this webcast to see the tools you can use to allow users direct access to line-of-business services from content hosted by Microsoft Office applications like Word, Excel, and Outlook. We'll also help you get familiar with the Metadata Designer tool.

MSDN Webcast: Building Microsoft Office Information Bridge Framework Solutions: Metadata (Level 300)
26.01.2005 - 1:00 PM - 2:00 PM Pacific Time (22:00 - 23:00 Uhr MEZ)
Don Reamey, Software Development Engineer, Microsoft Corporation

The Microsoft Office Information Bridge Framework includes an XML schema for defining service operations, business entities, relationships, and user interface (UI) elements. In this session, we will show you how to develop solutions using this XML schema to move information between sources without losing the metadata that is required to update the original data source. Learn how to create Information Bridge solution metadata using the Metadata Designer tool that is included with Information Bridge.

Tuesday, December 27, 2005 1:58:01 AM (Mitteleuropäische Zeit, UTC+01:00)  #     Author:Markus Fischer   Comments [0]   |   | 
Copyright © 2010 Markus Fischer. All rights reserved.
DasBlog 'Portal' theme by Johnny Hughes.
Pick a theme: