Home Silverlight Lives On in New SQL Server 2012 Reporting Tool

Silverlight Lives On in New SQL Server 2012 Reporting Tool

The Power View tool is meant to be run remotely, including from a service linked to a SQL Azure cloud-based database, so this is indeed a Web application. Technically, it may run from any browser that supports Silverlight. As with charting in Excel, you point Power View to your source and adapt the visualizations to best suit how that data may be explained to a viewer, and you do so without impacting the data itself.

One new tool called the slicer, added to the project during its public preview phase (proof that Microsoft can indeed incorporate good suggestions during a public preview), lets the user select a segment of data in a table to pull out and either highlight in the context of the bigger chart, or demonstrate within a separate graph. Then by creating what Power View calls cards, you can take a record about one of the items depicted in a chart – for example, one of the factors that the chart is comparing, like HP’s share price to Dell’s or Angus cattle prices compared to Hereford – and generate what Metro would call a “tile” for that item.

The card can show a picture and some recent data about the item, and clicking on it can trigger the chart to “pivot” around it, showing either the highlight or the slice you created earlier.

The result might have you imagining producing your weekly meetings the way CNN’s John King dances around his big board on Election Night, poking on-screen cards by hand and watching the results zoom into the foreground.

History has demonstrated that if one of the teams at Microsoft believes so sincerely in their technology that they don’t want it to die, bestowing upon it the word “Power” gives it an almost magical ability to survive, and perhaps even thrive. During the development of Windows Server 2003, a truly revolutionary command line tool code-named Monad threatened to invalidate the need for a graphical operations management tool. In 2006, its developers managed to get its name changed to PowerShell, and though executives refused to enable it to ship with the server itself, the company agreed to distribute it for free from its Web site. It was a fateful decision; at a time when other companies had already discovered the tremendous power of free distribution, Microsoft decided to distribute PowerShell for free, perhaps with the intent of watching it dwindle and fade away.

The opposite happened, of course: Now the tool has become an integral part not only of Windows Server but of Exchange – indeed, the graphical Exchange operations are all built around PowerShell scripts. So now that Silverlight is being tucked away inside some data visualization tool – at a time when data visualization tools are becoming the axis of an entirely new ecosystem of the database and data storage industry – little ol’ Power View may breathe some new life yet into the technology. Indeed, we could be seeing a kind of architectural divergence, where “business Windows” based on the Desktop model thrives as “consumer Windows” on the Metro model goes its own direction.

About ReadWrite’s Editorial Process

The ReadWrite Editorial policy involves closely monitoring the tech industry for major developments, new product launches, AI breakthroughs, video game releases and other newsworthy events. Editors assign relevant stories to staff writers or freelance contributors with expertise in each particular topic area. Before publication, articles go through a rigorous round of editing for accuracy, clarity, and to ensure adherence to ReadWrite's style guidelines.

Get the biggest tech headlines of the day delivered to your inbox

    By signing up, you agree to our Terms and Privacy Policy. Unsubscribe anytime.

    Tech News

    Explore the latest in tech with our Tech News. We cut through the noise for concise, relevant updates, keeping you informed about the rapidly evolving tech landscape with curated content that separates signal from noise.

    In-Depth Tech Stories

    Explore tech impact in In-Depth Stories. Narrative data journalism offers comprehensive analyses, revealing stories behind data. Understand industry trends for a deeper perspective on tech's intricate relationships with society.

    Expert Reviews

    Empower decisions with Expert Reviews, merging industry expertise and insightful analysis. Delve into tech intricacies, get the best deals, and stay ahead with our trustworthy guide to navigating the ever-changing tech market.