BI Blogs

Bringing together Business Intelligence voices from across the web

Point in Time Recovery for SQL Server

Posted on the August 31st, 2005. Read 471 times

Source: OLAP/BI/IM stuff [link]

Basic skills, know them inside and out!

Point in Time Recovery: “Every once in a while, an event might happen that corrupts a database. We have all made a stupid mistake at least once that has trashed a database. When this happens what do you do? If you do not have a database backup, then you had better own up to the problem you caused and tell your boss that you screwed up. If you do have at least a complete database backup then you most likely will be able to recover the corrupted database, up to the point that you corrupted the data. This article will discuss how to use a point in time restore to recover your databases. “

Know who your customers are – part 1

Posted on the August 31st, 2005. Read 404 times

Source: Pete-s random notes [link]

Consider a supermarket data warehouse – you know what was sold, where it was sold and when it was sold, we can even identify what else the customer bought in the same basket. But do we really know who the customer was? Identifying retail customers at point of sale has always been problematic, other business sectors have less difficulty identifying customers; banks have account numbers, Telcos

Burton Group: Three Major Stumbling Blocks Derailing SOA News - WebServices.Org

Posted on the August 31st, 2005. Read 403 times

Source: OLAP/BI/IM stuff [link]

Burton Group: Three Major Stumbling Blocks Derailing SOA News - WebServices.Org: “Infrastructure, design, and corporate culture need to be addressed for SOA to succeed, consultancy says. “

SQL 2005 Web Training: Effectively Designing a Scalable and Reliable Database: Session 5 of 10: New Features in Indexing and Index Maintenance

Posted on the August 31st, 2005. Read 374 times

Source: OLAP/BI/IM stuff [link]

Microsoft Partner Readiness: “Once an index is created, it must be maintained in production. Possibly more the system administrator?s job but effectively a database developers performance problem ? an unmanaged index will slowly become fragmented over time and will begin to degrade in performance. In this session, you will learn appropriate strategies in monitoring fragmentation, monitoring index usage and maintaining indexes for better performance. MSDN Web Seminar”

Software ofimatico gratuito para los Madrileños

Posted on the August 31st, 2005. Read 515 times

Source: Mr. BI [link]




Hoy anuncian en la contraportada de Expansión que Sun Microsystems dona al ayuntamiento de Madrid licencias de software ofimático por valor de 540 €. En concreto el ayuntamiento distribuirá 3 millones de copias de la suite StarOffice 7 de Sun tanto a particulares como a empresas con el único requisito de registrarse. El precio de StarOffice ya era una pequeña fracción del Microsoft Office (75$ para un particular o 25 usuarios por 1.500 € para una empresa), pero seguro que muchos se animarán a probarlo.
Yo ya me había instalado OpenOffice que es la suite basada en el código abierto de StarOffice. No lo he usado a fondo, pero abre y graba xls, ppt, doc, etc, sin cambios extraños. Respecto a las funcionalidades, la interfase es lógicamente distinta, pero he intentado operaciones básicas sin mucho esfuerzo. OpenOffice es gratuito y se diferencia de su hermano StarOffice que este último incluye herramientas administrativas y base de datos. OpenOffice incluye un manipulador de base de datos, pero no base de datos. Ahora se puede usar mySQL (y por supuesto otras de pago) y en la próxima versión incluirá HSQL como motor. Las pantallas de OpenOffice son tan atractivas como estas: Calc (Excel), Write (Word), Impress (Powerpoint), Base (Access) y Draw (Paint?).

La pregunta es ¿cuanto tiempo tardarán las grandes empresas en ahorrarse esta partida de gasto? Me comentaba hace unos días el director de organización y sistemas de una multinacionalque decidió sustituir el Microsoft Office por OpenOffice en todos los pc’s después de la última subida de precios de Microsoft y que los usuarios se han acostumbrado y no han tenido mayores problemas. Y los particulares, ¿empezarán a comprar ordenadores sin Office?

Oracle?s Next-Gen ETL Tool?More Details

Posted on the August 31st, 2005. Read 427 times

Source: BI this week [link]

With a new knowledge encapsulation feature and improved scheduling and security, OWB Paris looks like the real deal

Salient’s Margin Minder Max: Real-Time P&L Insight

Posted on the August 31st, 2005. Read 447 times

Source: BI this week [link]

Salient promises real-time visibility into profit and loss from virtually any domain perspective

IBM Announces Linux-powered Data Warehousing Bundles

Posted on the August 31st, 2005. Read 453 times

Source: BI this week [link]

If IBM?s new Linux-powered bundles look and sound like data warehousing appliances, are they, in fact, data warehousing appliances?

DBAs Bar Door Against Big Bad .Net Wolf

Posted on the August 30th, 2005. Read 428 times

Source: OLAP/BI/IM stuff [link]

DBAs Bar Door Against Big Bad .Net Wolf: “‘If you’re a developer, this makes [you] very happy. It has [database administrators] pretty concerned,’ said Kevin Kline, SQL Server MVP, director of technology for SQL Server Solutions at Quest Software and president of PASS (Professional Association for SQL Server). ‘You can have code running on SQL Server and you get a bug and you don’t know how to code and debug it.’ “

Business Intelligence for the Mid-Market

Posted on the August 30th, 2005. Read 402 times

Source: ITPapers.com - Recent Business Intelligence / Data Warehousing White Papers [link]

As a leader in a growing organization, you know the competitive pressure isn’t easing up anytime soon. And with fewer resources than your larger competitors, you have to act smarter, move faster, and make better business decisions without the benefit of armies of analysts and consultants. With this environment in mind, more and more mid-sized organizations are turning to business intelligence (BI) to help them gain a competitive edge in the marketplace. Small start-up companies with a few employees, mid-cap organizations publicly traded, and state and local government agencies are making better use of the information within their organization by using business intelligence.

Solutions for State and Local Government

Posted on the August 30th, 2005. Read 388 times

Source: ITPapers.com - Recent Business Intelligence / Data Warehousing White Papers [link]

Today’s government agencies are faced with more challenges than ever before. There is the challenge to respond to both constituents and employees; the challenge to meet and maintain regulatory requirements; the challenge to be accountable to taxpayers; and the challenge to manage financials while retaining a highly skilled workforce. Implementing technology solutions for state and local government requires a deep knowledge of not only the challenges you face but also the solutions you need. Empower Solutions’ government experience puts them in a unique position allowing us to bring to you tried and true government solutions.

Beyond BI: Building Intelligence Into Your Operational Decisions

Posted on the August 30th, 2005. Read 445 times

Source: ITPapers.com - Recent Business Intelligence / Data Warehousing White Papers [link]

Organizations that are looking to extend the success they have enjoyed with business intelligence are the best candidates to go to the next level, and embed more intelligence into high-volume operational decisions. This discipline which is called Enterprise Decision Management, differs from traditional BI in that it is focused on execution of decisions and actions rather than reporting. EDM uses business rules management systems and predictive analytics to automate and improve decisions for greater precision, consistency and agility. Adding EDM to BI extends the value of analytics-driven insights, allowing businesses to make smarter strategic, tactical and operational decisions.

Business Objects and MapInfo: Location Intelligence Component

Posted on the August 30th, 2005. Read 470 times

Source: ITPapers.com - Recent Business Intelligence / Data Warehousing White Papers [link]

The MapInfo Location Intelligence Component, a way of supplementing business intelligence (BI) with location, is a powerful solution for analysts in both business and government. Because MapInfo and Business Objects technologies embrace open standards and proven server architecture, the Location Component extends power from analysts to the entire organization. Combining two 100% Java technologies, MapInfo MapXtreme and BusinessObjects InfoView, in a 3-tier architecture, provides speed, security and ease of use.

Agencies Make Better Grant Management Decisions With BI

Posted on the August 30th, 2005. Read 444 times

Source: ITPapers.com - Recent Business Intelligence / Data Warehousing White Papers [link]

Two recent federal mandates placed grant management under increased scrutiny. The Federal Financial Assistance Management Improvement Act of 1999 and the President’s Management Agenda (PMA) require agencies to improve performance and demonstrate the effectiveness of federal grant programs in delivering on services to the public. To meet these demands, grant managers must have the ability to monitor and measure the effectiveness of awarded projects to achieve results. They need tools that can track progress throughout all phases of the award process, providing them with better insight into the complete lifecycle of an award. This insight must be correlated with information about grant-program effectiveness as demonstrated by the accomplishment of outcome-based performance measures.

¿Por qué las empresas adquieren herramientas de BI de diferente fabricantes?

Posted on the August 29th, 2005. Read 495 times

Source: Mr. BI [link]



Tras el siempre breve paréntesis vacacional durante el cual he podido desenganchar gracias al retraso que pueblos tan bonitos como Comillas en Cantabria tienen en la asignatura de acceso a la sociedad de la información, me lanzo con entusiasmo a leer los centenares de artículos atrasados. Me encuentro con éste que incide otra vez sobre el viejo tema de si es mejor un paquete integrado o usar distintas herramientas de distintos fabricantes para cada necesidad (best of breed). El artículo es sobre el informe de Data Warehousing Institute titulado “Enterprise Business Intelligence: Strategies and Technologies for Deploying BI on an Enterprise Scale” en el que incide en los beneficios de estandarizar y consolidar las herramientas de BI. Los encuestados para el informe, tienen 3.2 proveedores de BI de media y comentan que las principales razones para la compra de múltiples herramientas de BI son “diferentes requerimientos de los usuarios (54%), autonomía para compras de los departamentos (42%), y falta de funcionalidad en un único vendedor (41%)”.

Leaving on a Jet Plane: Why You Already Know More than You Realize about XML and Web Services Security

Posted on the August 26th, 2005. Read 392 times

Source: OLAP/BI/IM stuff [link]

Jumpstart into Business Intelligence: Implementing BI on a Budget

Posted on the August 26th, 2005. Read 444 times

Source: OLAP/BI/IM stuff [link]

Jumpstart into Business Intelligence: Implementing BI on a Budget: “Getting Started: Choosing the Right Project

Your first initiative should be visible but not over-ambitious. It shouldn’t take more than six months to complete - and that should also limit the cost of your first deployment. When identifying your first BI initiative, follow these basic principles:

Small beginnings are usually best. Focus your first project on getting your BI infrastructure established and satisfying one specific business need, such as sales reporting. With one phase of implementation completed, the next phases can follow a similar - or precisely tailored approach; and this is much easier than attempting several first-time BI initiatives simultaneously or building a ‘big-bang’ implementation.”

Validation of dimensions

Posted on the August 26th, 2005. Read 493 times

Source: Pete-s random notes [link]

If you have an Oracle data warehouse and are using materialized views for aggregations then Oracle dimension objects would have almost certainly been defined. These objects describe the hierarchical, attribute and join relationships for dimensions and together with database constraints enable the query rewrite mechanism to successfully rewrite queries that navigate dimensional hierarchies.

Drillthrough in AS2005

Posted on the August 26th, 2005. Read 577 times

Source: Chris Webb's BI Blog [link]

I mentioned this thread from the microsoft.public.sqlserver.olap ng on ‘Limitations of AS2005′ the other day, and it looks like it has pretty much finished. It turned into an interesting discussion on drillthrough in AS2005. Something I hadn’t realised was that in AS2005 any values you wish to see returned by drillthrough must already be defined in the cube - which, when you consider how you use drillthrough in AS2K seems a bit bizarre. However if you read the thread you’ll see what Mosha and Deepak have say on the subject, namely that for fields you only want to access via drillthrough you should create a hidden, ROLAP Fact dimension. It should be hidden because it probably wouldn’t make any sense at all to your users if they saw it, and it should be ROLAP so that it has no impact on the performance of the rest of your cube until it is queried in the drillthrough. Certainly a different way of handling the issue compared to AS2K, maybe not as intuitive and maybe it will take a little bit longer to set up, but to me quite an elegant way of solving the problem. It also fits in well with the thinking that the UDM should model everything in your data warehouse that you want to query on.

New Book

Posted on the August 26th, 2005. Read 458 times

Source: Pete-s random notes [link]

I see that Digital Press is about to publish a book on Oracle Data Warehouse Tuning for 10g. I hope to pick up a copy of Gavin Powell’s book soon (even though it is not out in the UK for a couple of months) and maybe review it here.

The contents list looks interesting - if only because it is similar to the one I was thinking of for my proposed book :(
But being positive, it also means I was

Next Page »