PySide6 Application
Modern desktop interface for staff and managers.
Back to portfolio
Working portfolio system
Ember & Oak Cigar Lounge Management System
Where premium hospitality meets intelligent operations. Manage the lounge, understand the business, and make every decision with confidence through one connected desktop application and reporting suite.
Project summary
One premium lounge system, from daily work to management reporting.
- Industry
- Premium hospitality / cigar lounge
- Architecture
- PySide6 application -> SQLAlchemy -> SQLite operational database -> Power BI reporting suite
- Primary tools
- Python, PySide6, Qt Designer, SQLAlchemy, SQLite, Power BI, DAX
- Deployment model
- Local-first Windows desktop application
- Purpose
- Sales, memberships, customers, inventory, purchasing, events, employees, operating expenses, and owner reporting
Application side
A custom desktop application for daily lounge operations.
The working build connects staff workflow to a production-scale local dataset through a clean architecture: PySide6 application to SQLAlchemy to SQLite database, with Power BI as the reporting layer.
SQLAlchemy
Reusable business logic and database communication.
SQLite Database
Local source of truth for operations and finance.
Power BI Suite
Interactive reporting for long-term business analysis.
Home & Operations Dashboard
Today's revenue, completed transactions, active members, upcoming events, reorder alerts, open purchase orders, recent sales, and quick actions for daily work.
Sales & Transaction Management
Create sales, add products, attach customers, identify member activity, apply authorized discounts, calculate tax and tips, record payment methods, and review history.
Customers & Memberships
Maintain customer profiles, plans, renewal dates, expiration status, lifetime spending, notes, purchase history, and membership enrollment or renewal workflows.
Products & Inventory
Manage products, brands, categories, SKU codes, cost, retail price, stock quantity, reorder points, supplier links, receipts, adjustments, and movement history.
Purchasing & Vendor Management
Create purchase orders, add product quantities, assign suppliers, track expected costs, receive partial or complete orders, and increase inventory automatically.
Events & Lounge Operations
Schedule tastings, member gatherings, promotional nights, and private functions with attendance, capacity, pricing, event revenue, and status tracking.
Employees & Service Activity
Maintain staff records, roles, active status, transaction attribution, revenue, average ticket, tips, and later permission-based access for managers and employees.
Operating Expenses
Record rent, utilities, payroll, marketing, insurance, repairs, software, professional services, and other expenses that support operating-profit reporting.
Search, Records & Data Management
Search customers, products, transactions, events, purchase orders, and records with consistent filters, sort behavior, detail views, and authorized edits.
Administration & System Settings
Configure business information, tax settings, membership plans, categories, roles, backups, restoration, exports, preferences, validation, and confirmation messages.
Verified SQLite data product
The application is connected to the real operating database.
These images were generated from ember_and_oak.db after a read-only integrity check. They document the live schema, row counts, reporting views, indexes, and product inventory records used by the desktop application.
- 26 business and application tables plus 4 reporting views
- 105,174 sales, 183,223 sale-detail rows, and 159,345 inventory movements
- SQLite integrity check verified as OK before publication
Database structure
Schema and integrity evidence
Tables, reporting views, indexes, record counts, and the successful integrity check.
Operational records
Products and inventory balances
Real portfolio records from the same database used by the PySide6 application.
PySide6 application gallery
Working screens from the lounge operations application.
These screens come from a tested copy of the connected Ember & Oak SQLite database. Select any image to inspect the full-resolution interface.
Daily operations dashboard
Owner and manager overview with quick actions, live KPIs, recent sales, inventory alerts, events, and purchasing priorities.
Sales and transaction history
Searchable sales records with customer, employee, membership, tender, tax, tip, and total detail.
Complete a new sale
Structured checkout with customer and employee attribution, tender, products, discounts, tips, and calculated totals.
Products and inventory
Live catalog and stock balances with vendors, cost, retail price, reorder thresholds, and product status.
Purchasing and vendors
Purchase-order creation and receiving with vendor, timing, status, expected cost, and quantity progress.
Customers and memberships
Customer relationships with contact preferences, membership details, expiration, lifetime spend, and status.
Reporting side
Seven Power BI pages, each constrained to real operator decisions.
This page is a staged preview. The temporary card names and descriptions below reflect the current reporting plan; screenshots and source-backed evidence will be added only as the working system becomes ready to show.
Executive Overview
Six KPI cards for total revenue, gross profit, gross margin %, total transactions, average ticket, and active members, supported by revenue trend, revenue mix, and top retail product visuals.
Sales & Product Performance
Product revenue, units sold, gross profit, gross margin %, and average selling price, with category revenue, top products, margin scatter, and product-level detail including discounts.
Members & Customers
Active and new members, membership revenue, average member spend, and member revenue share, with plan mix, new memberships, and member versus nonmember revenue and ticket behavior.
Inventory & Purchasing
Current inventory value, low-stock products, units received, units sold, and variance, tied to category value, movement trends, supplier views, and a low-stock reorder table.
Events & Lounge Operations
Total events, attendance, average attendance, event revenue, and average revenue per event, with attendance trends, revenue by type, and attendance versus revenue analysis.
Employees & Service
Revenue, transactions, average ticket, and tips, with employee revenue, employee average ticket, service timing, and a staff detail table for role-level review.
Financial Trends
Revenue, COGS, gross profit, operating expenses, and operating profit, supported by trend views, monthly operating profit, expense breakdown, and segment context where useful.
Dashboard preview
A darker, richer reporting surface for a premium venue.
The teaser establishes the project's dashboard mood: deep charcoal, warm cream, copper, muted gold, and focused owner metrics. Future screens will stay premium and practical rather than filling the report with decorative lounge imagery.
Case-study status
What is working now and what comes next.
- Status
- Working PySide6 application and verified SQLite database; Power BI reporting remains in development.
- Business type
- Fictional premium cigar lounge.
- Primary audience
- Owners, managers, and staff who need one operational system connected to reliable performance reporting.
- Application stack
- PySide6, Qt Designer, Python, SQLAlchemy, and SQLite.
- Page standard
- Each report page targets 4-6 KPI cards, 3 analytical visuals, 1 detail table, and 2-4 slicers.
- Build sequence
- Sales, members, inventory, events, employees, financial trends, then executive overview last.
- Current evidence
- Working screens, source-backed database visuals, operating model, automated tests, and implementation notes.
- Disclosure
- All customer, employee, product, sales, and venue records are fictional portfolio data.
Technology
Technologies used in this project.
- Python
- PySide6
- Qt Designer
- SQLAlchemy
- SQLite
- SQL
- Power BI
- DAX
- Git
- GitHub
- HTML
- CSS
- JavaScript
Want this kind of operating system for your organization?
OCBS builds practical data, workflow, and reporting systems around the way a business actually works.