O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Common Business Challenges and BI Solutions

Let’s summarize business challenges and BI solution strengths and then discuss translating these abilities into ROI for your company. You might want to refer back to the Top 10 Questions List earlier in this chapter, as you now are beginning to get enough information to be able to pull the answers to those questions together with the capabilities of the BI product suite. As you examine business needs and product capabilities, you’ll move toward envisioning the scope of your particular implementation. Here are some ways to meet challenges you might face as you envision and develop BI solutions:

  • Slow-to-execute queries. Use OLAP cubes rather than OLTP (normalized) data sources as sources for reports. OLAP ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required