Data Viewer
Data Visualization Web Part for SharePoint & Teams

The Data Viewer connect to data from Microsoft Excel, SQL Azure, OData, External Graph Connectors, and SharePoint lists and displays customizable reports and charts. Seamlessly display these insights on modern SharePoint pages or Microsoft Teams tabs, enhancing decision-making and collaboration.

WHY CHOOSE DATA VIEWER?

The Data Viewer is a powerful, no-code tool that allows SharePoint Site Owners to effortlessly configure and display data from various sources. It connects seamlessly to Microsoft Excel, SQL Azure, OData, SharePoint lists, and External Graph Connections, enabling you to create dynamic, customizable reports and interactive charts. With the Data Viewer, you can easily showcase key insights on modern SharePoint pages or Microsoft Teams tabs, driving better decision-making and collaboration without the need for complex coding or technical expertise. Unlock the power of your data with simplicity and flexibility.

  • Effortless, No-Code Configuration: SharePoint Site Owners can easily set up and configure the Data Viewer without any coding skills, making it accessible for all users.
  • Seamless Data Integration: Connects directly to multiple data sources, including Microsoft Excel, SQL Azure, OData, SharePoint lists, and External Graph Connections, providing a unified view of your data.
  • Customizable Reports and Charts: Create dynamic and interactive reports or charts tailored to your specific needs, enhancing data visualization and understanding.
  • Enhanced Collaboration: Display critical data insights directly on SharePoint pages or Microsoft Teams tabs, promoting better collaboration and informed decision-making across teams.

It supports multiple views, allowing you to switch between different data perspectives easily. With conditional formatting, you can highlight key data points and trends, making critical information stand out at a glance. Calculated columns enable advanced data manipulation and calculations directly within the tool, while grouping and data formatting options give you the flexibility to organize and present your data effectively. The Data Viewer also supports a wide range of chart types, including Pie Charts, Column and Bar Charts, and Tree View Charts, to visually represent your data in the most impactful way. Additionally, you can use Gauges to display key metrics and choose from 3D or 2D color configurations for a more engaging and customized presentation.

  • Multiple Views
  • Conditional Formatting
  • Calculated Columns
  • Sorting & Grouping
  • Wide range of chart types
  • Simple Chart Configuration
  • Multiple Series Charts
  • 3D or 2D Dynamic Charts

As an SPFx web part, the Data Viewer is built using the latest web technologies and is fully responsive, providing a consistent and reliable user experience across all devices and platforms. It can be added directly to SharePoint modern pages, Microsoft Teams tabs, and Microsoft Viva Connections dashboards, making it an ideal solution for organizations looking to enhance their digital workplace with powerful data visualization tools.

A key aspect of the Data Viewer’s architecture is its commitment to data privacy and security. All data displayed by the Data Viewer is sourced directly from within the client’s Microsoft 365 Tenant. The Data Viewer does not store, process, or transfer any data outside of the Microsoft 365 environment, ensuring compliance with organizational and regulatory data protection standards.

Data Viewer: Empowering Business Users to Visualize Data in SharePoint

The Data Viewer by Lightning Tools enables business users to effortlessly add data visualizations to their SharePoint pages. By establishing secure connections to Microsoft 365 Apps, SharePoint Lists and Libraries, as well as external connectors like Salesforce, the Data Viewer transforms how data is presented and analyzed in SharePoint, making it easy to gain insights and drive informed decisions.

  • Seamless Integration: Connects to a variety of data sources, including Microsoft 365 and Salesforce, providing a unified view within SharePoint.
  • Interactive Visualizations: Offers customizable and interactive charts, graphs, and tables, allowing users to tailor visualizations to their needs.
  • Secure Access: Ensures data privacy and security through permissions and access controls, aligned with Microsoft 365 security protocols.

Granular Control and Styling for Data Visualizations with Data Viewer

The Data Viewer by Lightning Tools provides business users with extensive control over the styling and presentation of their data visualizations. With a wide variety of chart types available, including Pie, Donut, Bar, Line, Treeview, Gauges, Maps, and more, users can fully customize the look and feel of their charts and tables, ensuring the data is both visually appealing and easy to interpret.

  • Diverse Chart Options: Choose from a broad selection of chart types, allowing users to select the best format for their data representation needs.
  • Granular Styling Capabilities: Customize every aspect of visualizations, from colors and labels to layouts and interactions, to enhance data clarity and match branding guidelines.
  • Interactive and Dynamic Displays: Create visually compelling dashboards that adapt to user input and data changes, making insights more accessible and actionable.

Data Viewer as an Adaptive Card for Viva Connections

The Data Viewer by Lightning Tools is not only a powerful web part for SharePoint but is also available as an Adaptive Card for Viva Connections. This integration allows business users to surface and interact with data visualizations directly within their Viva Connections dashboard, making key data accessible and actionable within the flow of work.

  • Centralized Access to Data: Adaptive Cards enable users to view and engage with data visualizations without leaving their Viva Connections dashboard, streamlining access to important insights.
  • Consistent User Experience: With the Data Viewer Adaptive Card, users enjoy a seamless experience with consistent styling and functionality across SharePoint and Viva Connections, improving adoption and usability.
  • Personalized and Relevant Information: By embedding data visualizations into Viva Connections, organizations can deliver contextually relevant information to users based on their role or department, enhancing productivity and decision-making.

Effortless Configuration to Multiple Data Sources with Data Viewer

The Data Viewer by Lightning Tools simplifies the process of connecting to a wide range of data sources, making it easy for business users to visualize data from various platforms directly within SharePoint or Viva Connections. Whether integrating with SharePoint Lists, legacy systems through Business Connectivity Services (BCS), OData, SQL Azure, Microsoft Excel, or Microsoft Graph Connectors, the Data Viewer allows for robust and flexible data visualization.

  • Broad Source Compatibility: Connect to a variety of data sources, including SharePoint Lists, BCS-supported legacy systems, OData services, SQL Azure databases, Microsoft Excel files, and Microsoft Graph Connectors, providing a versatile data visualization tool for all types of data.
  • Modern Visualization for Legacy Data: With BCS support, legacy data can be surfaced and visualized in a fresh, modern format, helping users make better sense of old systems and improving the look and usability of legacy data.
  • Conected WebPart Data Display: The Data Viewer allows users to configure multiple web parts on a single page, displaying a variety of data points simultaneously for 1 time views, improving data comprehensiveness and enhancing the ability to compare and analyze information side by side.