Close
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications
    • Database

    Microsoft Drives Mass Adoption of BI by Hiding It

    By
    Lisa Vaas
    -
    September 29, 2004
    Share
    Facebook
    Twitter
    Linkedin

      Bill Baker, Microsoft Corp.s general manager of SQL Server Business Intelligence, thinks few people wake up and say, “Im going to do BI today.”

      Instead, they say, “Im doing my job today.” Thats the mass audience Microsoft is targeting with its latest business intelligence offerings, which include new SQL Server Report Packs for Exchange and Business Solutions CRM; Report Builder, a tool that enables simple report creation via a drag-and-drop environment; and Integration Services, which is a rechristened version of DTS (Data Transformation Services) that will reach into nonpersistent data stores such as those found in RSS (Really Simple Syndication) feeds or Web services.

      Baker sat down with eWEEK.com Associate Editor Lisa Vaas at the PASS (Professional Association for SQL Server) user conference in Orlando, Fla., to refute the common user misconception that enabling end users with report building will crush the infrastructure under a data deluge, and to talk about Microsofts latest BI advances.

      Is it a legitimate concern to worry about end users flooding the system with reports after they get their hands on Report Builder?

      [It] is a legitimate concern for DBAs [database administrators] to have. If 10,000 people randomly started writing reports, life could get interesting. But the first thing to understand is DBAs have to give users permission before they write reports. Thats part of role-based permission. You can shut that off for a lot of reasons, and there are a lot of reasons to do that: compliance, for example, or whatever a given corporate policy is.

      /zimages/3/28571.gifDo you really want users to start cranking out reports en masse? Some IT managers say no. Read more here.

      The second thing is, we cache very cleverly. If you and I pull the same report, we only keep one copy if its cached. We cache the smallest number of reports possible.

      Is it true, though, that youll wind up with three report versions, as users tell me? As in, the original report in the OLTP [online transactional processing] system, the flattened Reporting Services version and the rendered report in database cache?

      You definitely will have [the data stored in] operational sources—whether thats in order systems, inventory systems or whatever. Its very common to have a data warehouse, [for example,] for a lot of good reasons. And that data warehouse often represents more data than [the original operational sources].

      Next Page: You dont have to duplicate data to do a report.

      Two

      After that, though, OLAP is just an optimization for [end users]. End users always ask for report versions: What region? What city? … It doesnt mean you have to copy the data.

      The important thing were trying to do with OLAP is to present a business view of the data. Thats how business users think: “Show me the most profitable city for each product.” Thats a really cool thing to be able to find out about a product line.

      Thats a conceptual view of the data. But we dont have to make a copy of the data warehouse and turn it into a cube view and stick it on the disk. We can look at it with a relational OLAP lens. Were not unique in that. But it does not require any duplication of the data. If you want, for performance reasons, we and other vendors can materialize a multidimensional view on disk. You get speed, you get faster queries. But we do not have to duplicate any data to do a report.

      Does Reporting Services require users to cache data?

      No, Reporting Services does not require end users to cache any data. Im not sure where that perception came from. Optionally, we do caching, but we do it on the server.

      Whats the trade-off?

      Taking up space on the Reporting Services server. But youre saving the time and CPUs on the database server. Youre offloading the database server.

      You dont have to cache. You can cache when the first user comes in, keep the cache, expire the cache, keep it around three days or whatever. You have a lot of choices. Theres a lot of control and flexibility there.

      Whats the coolest feature of Report Builder?

      Templates. One principle is that its easier to edit than to create. If I give you a blank template, 99 percent of people just stare at it. If I give you common shapes and you can start from there, then youre off. Take it and modify it for your own needs.

      Next Page: The infinite coolness of infinite drilldown.

      Three

      [Another cool thing] is infinite drilldown. Thats a cool feature [of Report Builder]. Static reports are somewhat interesting. There are people who wake up, say “Im going to do BI today,” they get [reports] in the morning, make a decision and go off and do something [based on the reports findings].

      But we want to achieve more interactivity with data. If a number looks interesting, you can hover over it and click it [in Report Builder]. We generate the reports. We make the reports, we use them, then we get rid of them.

      You can dance around from report to report to report. You dont have to think it out in advance. Nobody says, “Heres where people may go.” You just draw the report, publish it, and end users start navigating it. Theyre creating reports every time they click [on a given piece of data within a report], and they dont even know it.

      Thats how you drive mass adoption of BI, is to hide it.

      You featured Barnes & Noble Inc. in your keynote. Are they a good example of hiding BI?

      Barnes & Noble, now theres a company devoted to its geographies. They say, “The person who runs the store can make a better decision about what books to put in front, what books to put in back, etc., better than any corporate executive or IT staff can do.” But theyre not a BI person. We cant tell them to take a training class and go write a report. We say, “Look at the information weve got. If you want to think of it more, start clicking.”

      Check out eWEEK.coms Database Center at http://database.eweek.com for the latest database news, reviews and analysis.

      Be sure to add our eWEEK.com database news feed to your RSS newsreader or My Yahoo page

      Lisa Vaas
      Lisa Vaas is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on eWEEK.com, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.

      MOST POPULAR ARTICLES

      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      Chris Preimesberger - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Cloud

      Why Data Security Will Face Even Harsher...

      Chris Preimesberger - December 1, 2020 0
      Who would know more about details of the hacking process than an actual former career hacker? And who wants to understand all they can...
      Read more
      Cybersecurity

      How Veritas Is Shining a Light Into...

      eWEEK EDITORS - September 25, 2020 0
      Protecting data has always been one of the most important tasks in all of IT, yet as more companies become data companies at the...
      Read more
      Cybersecurity

      Visa’s Michael Jabbara on Cybersecurity and Digital...

      James Maguire - May 17, 2022 0
      I spoke with Michael Jabbara, VP and Global Head of Fraud Services at Visa, about the cybersecurity technology used to ensure the safe transfer...
      Read more
      Big Data and Analytics

      GoodData CEO Roman Stanek on Business Intelligence...

      James Maguire - May 4, 2022 0
      I spoke with Roman Stanek, CEO of GoodData, about business intelligence, data as a service, and the frustration that many executives have with data...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2021 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×