Overview of the Power BI Reports
CPS Executive Reports v4 – Power BI
Power Business Intelligence, Power BI , or PBI is a reporting tool from Microsoft. This tool combined with the reports generated from Club Prophet's software offer a much deeper look at your data. The revenue-type reports and data from Club Prophet are pulled into the Microsoft reporting tool via an API and are accessible through a browser such as Chrome by using your own secure login.
The tool helps you to drill-down into specific areas to allow you to further analysis your revenue especially in areas of the golf industry standards of revenue: Merchandise, F&B, Membership, Golf, Carts, Range, and Lessons. It does this through the use of visuals. Each screen has multiple filters, reports, graphs that help to tell an interactive story; those entities are called visuals.
Note: Samples are using demo data and do not reflect real world data.
CPS – Revenue Reports
CPS-Revenue are a group of reports related to revenue generated at your facility.
To get to this group of reports, select or hover your mouse over this bar chart icon in the top left of the screen:
This will open the Menu Selection bar where you can select CPS-Revenue to access the revenue reports.
Note: The tabs across the bottom of the screen open to a different revenue report. On the left side, the arrows scroll to more reports.
The following reports are reviewed:
- Benchmarks
- Billing Code List
- Booking by Source
- Cancellations
- Cart
- Credit Book Adjustments
- Credit Book Balance
- Credit Card on File List
- Credit Card Transactions
- Count of Customers
- Customer Address
- Customer Indicators
- Customer List with Dependents & Notes
- Customer List with Notes
- F&B Meal Periods
- F&B Sales Tracking
- Freeze
- Gift Card Matrix
- GL Drill Down
- GL Posting
- Ledger Adjustments
- Ledger Balance and Details
- Loyalty Discount Program
- Loyalty Dollar Program
- Loyalty Points Redeemed by GL - Date (and - Description)
- Member Sales - Date Matrix
- Member Sales Matrix
- Prod GL Mapping
- Product Cross Sale
- Qty Matrix – Customer/Store
- Qty Matrix – Date
- Qty Matrix - Description
- Reservations
- Revenue/Category Matrix
- Revenue Compare
- Rev (pre-tax)
- Rev Geo-Location
- Rev Packages
- RevPatt & Utilized
- Rounds – Acquired/Core/Defectors
- Revenue
- Revenue Per Industry Category
- Revenue per Product xref Package
- Revenue Year Comparison
- Revenue Compare - 2 Year
- Revenue/Category Matrix
- Sale Discounts
- Sale Search
- Sale by Type
- Sales Transaction Details by Customer Report
- Smart Card History
- Smart Card Redeemed
- Supplier Inventory By Month
- Supplier Inventory Status by GL Code
- Supplier Inventory Status
- Supplier Product List
- Supplier Product Revenue
- Transaction Item Audit v3
- Transaction Matrix
- Transaction Summary / Transaction Detail
- Transaction Statistics Matrix
- Transaction Summary Details
-------------------------------------------------------------------------------------
©Club Prophet 2021 - Proprietary documentation