PySide6 Application
Modern desktop interface for staff and managers.
Back to portfolio
Active development
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 staged portfolio build
- Purpose
- Sales, memberships, customers, inventory, purchasing, events, employees, operating expenses, and owner reporting
Application side
A custom desktop application for daily lounge operations.
The planned build connects staff workflow to reporting through a clean local architecture: PySide6 application to SQLAlchemy to SQLite database to Power BI reporting suite.
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.
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 ready now, and what still needs evidence.
- Status
- Active development / staged portfolio preview.
- 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.
- Planned evidence
- Working screens, source data, operating model, report validation, and implementation notes.
- Disclosure
- No real customer, employee, or venue data is represented on this staged preview page.
Technology
Technologies planned for 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.