• banner

    “The PCA crew is leagues above
    the competition” - Pepsico

  • "a prior vendor failed to develop
    the application, which (Practical) delivered." - Franklin Park

  • "the application (is) easier to use, with a
    much simpler, more intuitive use interface" - Royal Administration Services

  • "Sometimes it's the things you don't ask for
    that are important" - Royal Administration Services

  • "PCA turned our raw data and algorithms into easy to use
    and understand features and reports." - CareScout

  • "The quality and professionalism ... has been
    so outstanding that we want to send you a letter of thanks." - USALCO

  • "PCA people and applications stand out by
    far exceeding our expectations." - USALCO

  • "The resulting application greatly increas(ed)...
    our business effectiveness and efficiency." - The Advest Group

  • "PCA completes projects
    efficiently and effectively" - Pepsico

Visual Reporting with Power View

Practical Computer Applications (PCA) uses Power View, PowerPivot, SQL Server, SharePoint, SQL Server Analysis Services and other BI products to solve our clients business problems, while helping customers to avoid complexity of installation, configuration and development of custom applications with these latest technologies from Microsoft.

PCA uses the capabilities of Power View to produce Visual Reports, Data Visualizations, Dashboards and Charts that behave as interactive synchronized data filters and to support advanced visual drill-down, slicing and dicing functionality. 

New Power View is packaged by Microsoft as a SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition. Power View is Silverlight-based (ad-hoc) report designer which provides for user an interactive data exploration, visualization, and presentation web experience. PCA takes care of all development and infrastructure problems so our users have an easy access to Power View functionality without worrying about the complexity of SharePoint configuration, SQL Server tuning and problems related to “own” in-house software development and deployment.

Previous report designers (still available from Microsoft:  BIDS, Report Builder 1.0, Report Builder 3.0, Visual Studio Report Designer) are capable to produce only static reports, but Power View enables users to visually interact with data and drill-down all charts and Dashboards similar to Tableau and Qlikview. In short, Power View allows PCA users to have easy to use Data Analytics.

Power View is a Data Visualization tool, integrated with Microsoft ecosystem. Here is a Demo of how the famous Hans Rosling Data Visualization can be reimplemented with Power View:

[tube]http://www.youtube.com/watch?v=uuZesGpnoAQ[/tube]

Compare with previous report builders from Microsoft, Power View allows many new features, like Multiple Views in a Single Report, Gallery preview of Chart Images, export to PowerPoint, Sorting within Charts by measures and Categories, Multiple Measures in Charts, Highlighting of selected data in reports and Charts, Synchronization of Slicers (Cross-Filtering), Measure Filters, Search in Filters (convenient for a long lists of categories), dragging data fields into Canvas (create table) or Charts (modify visualization), convert measures to categories (“Do Not Summarize”), and many other features, including new types of Charts, like Trellis and ScatterPlot.

Trellis Chart by Power View

 

It is a PCA experience that the Analytical applications in many cases need to be able to use OLAP Cubes from SSAS (SQL Server Analytic Services) and  Excel PowerPivot as data sources while preserving all Cube infrastructure, design, dimensions, measures and calculations. Power View can use SSAS Cubes and connect to PowerPivot. Power View is a good choice for those PCA customers, who has their IT infrastructure build with Microsoft software stack and who needs advanced Data Analytics.

If you need to discuss your Data Visualization, BI and Data Analytics needs in more details, please Contact Practical Computer Applications via email, phone: 617-527-4722×127 or Request For Information regarding our Database, Data Analytics or Data Visualization consulting services.