The Data Viewer by Lightning Tools is a powerful, no-code solution designed for SharePoint Site Owners to effortlessly configure and display data. It seamlessly connects to a wide array of data sources, including Microsoft Excel, SQL Azure, OData, SharePoint lists, and External Graph Connections (such as Salesforce), allowing for the creation of dynamic, customizable reports and interactive charts. This tool empowers business users to showcase key insights directly on modern SharePoint pages or Microsoft Teams tabs, significantly enhancing decision-making and fostering collaboration without requiring complex coding or technical expertise. Beyond its core web part functionality, the Data Viewer is also available as an Adaptive Card for Viva Connections, enabling users to access and interact with data visualizations directly within their Viva Connections dashboard. The solution provides extensive control over the styling and presentation of data visualizations, offering a wide variety of chart types like Pie, Donut, Bar, Line, Treeview, Gauges, and Maps. Users can fully customize the look and feel to ensure data is both visually appealing and easy to interpret, while maintaining data privacy and security through alignment with Microsoft 365 security protocols. It simplifies connecting to various platforms, including legacy systems via Business Connectivity Services (BCS), and supports displaying multiple web parts on a single page for comprehensive, side-by-side data analysis.

Features & Benefits

• Effortless, No-Code Configuration
  • Allows SharePoint Site Owners to easily set up and configure data visualizations without any coding skills, making it accessible for all users.
• Broad Data Source Compatibility
  • Connects directly to a wide range of data sources, providing a unified view of information.
  • Microsoft Excel
  • SQL Azure
  • OData
  • SharePoint lists
  • External Graph Connections (e.g., Salesforce)
  • Business Connectivity Services (BCS) for legacy systems
• Customizable & Interactive Visualizations
  • Create dynamic and interactive reports, charts, graphs, and tables tailored to specific needs, enhancing data visualization and understanding.
  • Diverse chart options: Pie, Donut, Bar, Line, Treeview, Gauges, Maps, and more.
  • Granular styling capabilities: Customize colors, labels, layouts, and interactions.
  • Interactive and dynamic displays that adapt to user input and data changes.
• Seamless SharePoint & Teams Integration
  • Display critical data insights directly on modern SharePoint pages or Microsoft Teams tabs, promoting better collaboration and informed decision-making across teams.
• Viva Connections Adaptive Card
  • Integrates with Viva Connections, allowing users to view and engage with data visualizations without leaving their dashboard.
  • Centralized access to data within the flow of work.
  • Consistent user experience across SharePoint and Viva Connections.
  • Personalized and relevant information delivery based on user role or department.
• Secure Data Access
  • Ensures data privacy and security through permissions and access controls, aligned with Microsoft 365 security protocols.
• Modern Visualization for Legacy Data
  • With BCS support, legacy data can be surfaced and visualized in a fresh, modern format, improving the look and usability of older systems.
• Connected WebPart Data Display
  • Configure multiple web parts on a single page, displaying a variety of data points simultaneously for comprehensive views and side-by-side analysis.