ProfitWizard combines business intelligence, decision support, performance management and ad-hoc reporting with easy-to-use Microsoft tools including Excel and Analysis Services data cubes.
ProfitWizard utilizes the Microsoft technology “stack” allowing customers to use broader and deeper data warehouse and reporting functionality without incurring additional licensing expense. SQL is the platform used for the ProfitSage business intelligence database. The Analysis Services data cubes are the foundation of ProfitWizard and Excel is front-end interface for reporting, modeling, and graphing. Clients can also create additional Analysis Services cubes from almost any data source and combine that data with the ProfitWizard cubes.
ProfitWizard allows users to:
- Create an unlimited number of Excel-based reports, models and graphs to solve mission critical business issues and enhance performance analysis.
- Create custom dashboards for your portfolio for real-time analysis
- Create what-if scenarios for modeling business changes for a single hotel or the entire portfolio
- Analyze statistical information across brands and service styles
- Provide comprehensive labor and performance analysis to improve productivity standards
- Compare guest service scores and profitability across the portfolio in order to create “best practices” for your company
- Save your reports and update the data with the click of a button.
Below are reference items you will need to know to use the Profitwizard Module.
The Cube Formula
The Cube URL will be assigned by the ProfitSword team when given access to Profitwizard application.
Site and Site Group Formula
CUBEMEMBER(CubeAddress,"[Dim Site].[Sites].&[Site ID]")
Site ID will be the Site ID in the ProfitSage system.
Mode Formula
CUBEMEMBER(CubeAddress,"[Dim Mode].[Mode].&[ModID]")
Mode ID definitions are as follows:
Date Formula
Measure Formula
Pivot Table Breakdown
Comments
0 comments
Article is closed for comments.