Fishbowl

Fishbowl Inventory scripts, queries, and dashboards.

Overview

This repository contains a collection of scripts, SQL queries, and automation tools designed to enhance and extend the functionality of Fishbowl Inventory management software. Whether you're looking to streamline your inventory processes, generate custom reports, or integrate Fishbowl with other systems, you'll find useful resources here.

Contents

• Scripts - Automation scripts and utility tools for Fishbowl operations
• Queries - Custom SQL queries for data analysis and reporting
• Dashboards - PowerBI dashboards for data visualization and insights (coming soon)

Existing Projects

• DailySOFulfillmentReport - Daily email report of all fulfilled Sales Orders
• InventorySummary - MySQL queries and web-based reporting for inventory changes over time
• Inventory Count Report - Quick report generation tool for inventory counts

Technology Stack

Uses Power BI, Jaspersoft iReport, Fishbowl BI editor.

Features

• Custom inventory management scripts
• Database queries for reporting and analysis
• Integration utilities for Fishbowl systems
• PowerBI dashboard templates and configurations (in development)

PowerBI Dashboards

PowerBI dashboard resources will be added to this repository as time allows. These dashboards will provide visual insights into your Fishbowl inventory data, helping you make data-driven decisions.

Getting Started

1. Clone the repository:

   git clone https://github.com/UncleAndy123/Fishbowl.git

2. Navigate to the relevant directory for the resource you need (scripts, queries, or dashboards)

3. Review the documentation within each section for specific setup and usage instructions

Contributing

Contributions are welcome! Whether you have:

• Useful scripts or queries to share
• Bug fixes or improvements
• Dashboard ideas or designs
• Documentation enhancements

Please feel free to:

1. Fork the repository
2. Create a feature branch (git checkout -b feature/your-feature)
3. Commit your changes (git commit -m 'Add your feature')
4. Push to the branch (git push origin feature/your-feature)
5. Open a Pull Request

We appreciate all contributions that help make this repository more valuable for the Fishbowl community!

Support

For questions or issues related to this repository, please feel free to open an issue on GitHub or contact the repository maintainers.

---