
A Quick Guide to BidLight's Data Warehouse Tool
Introduction
The Data Warehouse feature is your go-to tool for centralizing and managing project data efficiently. This guide will walk you through its key capabilities, from detailed data display and 3D model visualization to data updates and export options.
Centralized Data Access
The Data Warehouse is pivotal in project management, offering a unified platform to view, analyze, and manage project data. Its user-friendly interface lets you explore project details, interact with 3D models, and export data seamlessly.
Project List Overview
The main interface showcases a comprehensive project list. Each project entry includes an eye icon, which you click to access detailed information. Here’s what you’ll find:
● Name: Project title
● Project ID: Unique identifier
● Creation Date: When the project was created
● Exported by: Name of the project exporter
● Milestone: Current project milestone
● Cost: Estimated project cost
● Members: Project team members
● Actions: Eye icon for detailed views
Detailed Data View
When you click the eye icon, you'll be directed to a page featuring a detailed data table that presents project information in an organized, structured format. This table allows you to view data categorized into various sections, making it easier to navigate and analyze. You can also refine the displayed information by applying filters based on date ranges, project phases, resource types, or cost thresholds. This filtering capability ensures that you can focus on specific aspects of the project for more targeted insights.
3D Model Viewer Integration
The 3D model viewer is a powerful feature that enhances your understanding of project details. Accessible via a 3D icon, it allows you to interact with the project by rotating, zooming, and panning the model from various angles. This functionality includes layer management, where you can toggle layers on and off to focus on specific components like electrical systems or plumbing. Additionally, any changes made in the data table are instantly reflected in the 3D model, ensuring that the visual representation remains consistent with the data.
Switching Between Data Table and 3D View
Switching between the detailed data table and the 3D model view is seamless with just a single click. This feature supports a flexible workflow, enabling users to alternate between data analysis and visual inspection efficiently.

Data Export Capabilities
Exporting project data is straightforward with the Data Warehouse. The download icon, located in the header, provides an easy way to export data. Users can choose to download all data or apply filters to include only relevant information. The data is exported in CSV format, which is compatible with various analysis tools and supports further manipulation or reporting.
User Interaction and Data Management
The Data Warehouse is designed with user interaction and data management in mind. It supports real-time updates, allowing users to modify data directly and keep it current. Filtering and sorting features enable users to customize their data view to focus on key information. The integration of 3D models with data ensures consistency, enhancing decision-making by aligning visual representations with data insights.
Conclusion
The Data Warehouse is an invaluable tool for project data management and visualization. Its detailed tables, 3D model integration, filtering, and export features streamline project oversight and enhance decision-making. Embrace this feature to elevate your project management efficiency and effectiveness.