SqlServerKudos

BI

1
kudos

Kudos

List of SQL Server 2008 Standard Edition Knowledge Base Notification updates

published 183 days, 20 hours, 12 minutes ago posted by

sa 193 days, 8 hours, 10 minutes ago

List of SQL Server 2008 Standard Edition Knowledge Base Notification updates

Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications FIX: Connector 1.0 for SAP BI throws an exception when data is being loaded in parallel in a SSIS 2008 package http://support.microsoft.com/kb/975058/en-US FIX: The check phase of the WMI service fails when you set up a SQL Server 2008 cluster http://support.microsoft.com/kb/975374/en-US FIX: You receive error message 8672 when you run a MERGE statement in SQL Server 2008 http://support.m... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: BI, business intelligence, data files, Extended Events, kba, message, processor, sap, SQL Server, SSIS, standard edition

1
kudos

Kudos

Trick Question – Part I

published 326 days, 7 hours, 29 minutes ago posted by

sa 332 days, 3 hours, 28 minutes ago

It seems simple enough, yet there's so little consensus about how to do this basic thing that we grapple with every day. In my work, I have to poke and prod a wide variety of third-party applications, and I can say that there's fairly little consistency -- and, frankly, a pretty low level of quality -- around this issue, if you go shopping to buy software. Everyone is basically doing the same "thing": creating an ob... (more)

category: Warehousing | clicked: 0 | comment | | source: sqlblog.com

tags: BI

1
kudos

Kudos

Getting Started with Variables in SSIS

published 334 days, 19 hours, 37 minutes ago posted by

sa 339 days, 21 hours, 56 minutes ago

I recently had to create an SSIS package that used variables to pass data between procs, and I thought it would make a good topic for a blog post. There are many scenarios as to the how and why to use variables in SSIS, but we’re going to keep it pretty simple. Let’s assume we have some need to retrieve data from Proc A, pass it to Proc B, and store the results in Table C. First, let’s set up our environment:US... (more)

category: Warehousing | clicked: 1 | comment | | source: sqlfool.com

tags: BI, BIDS, SSIS, Variables

1
kudos

Kudos

Addressing the MSFT BI Naysayers

published 341 days, 4 hours, 9 minutes ago posted by

sa 347 days, 1 hour, 4 minutes ago

Overall, could MSFT BI be a better story (see ProClarity)? YES. Does MSFT need a better, unified platform vision for it's BI story? YES. All that being said, the MSFT BI software products are good platforms for building an enterprise BI solution on top ... (more)

category: Warehousing | clicked: 2 | comment | | source: weblogs.sqlteam.com

tags: BI

1
kudos

Kudos

Gemini - Self Service BI!

published 343 days, 4 hours, 22 minutes ago posted by

sa 347 days, 2 hours, 44 minutes ago

Gemini is the code name for the new breakthrough Self-Service Business Intelligence (BI) capabilities being delivered in the SQL Server 2008 R2 release. Gemini enables end users to build BI applications by integrating data from a variety of sources, modeling, refining and analyzing the data, adding business logic, building reports and visualizations and ultimately sharing it with their coworkers in an environment that is managed and secured by IT... (more)

category: Reporting | clicked: 0 | comment | | source: blogs.msdn.com

tags: BI, Gemini

1
kudos

Kudos

Where is the intelligence in Business Intelligence?

published 348 days, 6 hours, 32 minutes ago posted by

sa 354 days, 22 hours, 35 minutes ago

Where is the intelligence in Business Intelligence?

Many people believe that if they go ahead and implement a Business Intelligence solution they will suddenly have an intelligent business that will tell them how it is operating and what they need to do. Customers they need contacting will be flagged, orders that are likely to be late are notified so as to keep the customers happy, and the boss is alerted as to the reason profits have fallen from 15% to 10%. (more)

category: Warehousing | clicked: 3 | comment | | source: sqlblogcasts.com

tags: BI, SQL Server 2008, SQL Server 2008 R2, SQLBits, Training

1
kudos

Kudos

Media Business Intelligence - Decentrix and BIAnalytix - Part 2

published 368 days, 7 hours, 52 minutes ago posted by

sa 369 days, 1 hour, 17 minutes ago

Media Business Intelligence - Decentrix and BIAnalytix - Part 2

In this episode, host Kirk Evans talks with Dr. Michael Ludwich, VP of Consulting at Decentrix, where Dr. Ludwich provides a demonstration of the BIAnalytix solution. This quite an interesting demonstration, helping to show the value of BI in a media organization. In Part 1 of this interview, we talked with Wayne Ruting, CEO of Decentrix, about the importance of business intelligence in a Media & Entertainment company. Decentrix has quite a client roster, including some of the largest broadcaste... (more)

category: Analysis | clicked: 0 | comment | | source: channel9.msdn.com

tags: BI, Excel, Excel 2007, Excel Services, Office, SharePoint, SQL 2008, SQL Server, SQL Server 2008, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, SSAS, SSIS, SSRS

1
kudos

Kudos

Media Business Intelligence - Decentrix and BIAnalytix - Part 1

published 365 days, 7 hours, 45 minutes ago posted by

sa 369 days, 1 hour, 38 minutes ago

Media Business Intelligence - Decentrix and BIAnalytix - Part 1

In this episode, Kirk Evans talks with Wayne Ruting, CEO of Decentrix, about the importance of business intelligence in a Media & Entertainment company. Decentrix has quite a client roster, including some of the largest broadcasters, cable operators, and telcos in the US. We talk about why BI matters, how BI is not simply providing reports in a transactional application, and we learn more about Decentrix and their BIAnalytix offering. I learned a lot during this interview about the importance of B... (more)

category: Analysis | clicked: 0 | comment | | source: channel9.msdn.com

tags: BI, Excel, Excel 2007, Excel Services, MOSS, MOSS2007, Office, SharePoint, SQL 2008, SQL Server 2008, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services

1
kudos

Kudos

Agile BI Development: QueryUnit is born!

published 366 days, 7 hours, 50 minutes ago posted by

sa 369 days, 2 hours, 21 minutes ago

Agile BI Development: QueryUnit is born!

Having a developer background I’m used to work trying to apply an Agile approach to projects. In these last years I focused my work primary on BI projects, and so I tried to apply an Agile approach also to them, since I really believe that Agile is the path to follow. While Agile methods in the classic Object-Oriented field are quite widespread nowadays, in the BI field they are basically totally unknown to masses (at least this is my experience). Of course this means also that there is a total lack of ... (more)

category: News | clicked: 0 | comment | | source: sqlblog.com

tags: Agile, BI

Welcome!

BI

List of SQL Server 2008 Standard Edition Knowledge Base Notification updates

Trick Question – Part I

Getting Started with Variables in SSIS

Addressing the MSFT BI Naysayers

Gemini - Self Service BI!

Where is the intelligence in Business Intelligence?

Media Business Intelligence - Decentrix and BIAnalytix - Part 2

Media Business Intelligence - Decentrix and BIAnalytix - Part 1

Agile BI Development: QueryUnit is born!

Open ID Login

Standard Login

Forgot Password?

Sign up