Stop building the monthly cost report.
Start analyzing it.
Dollar Grid automates cost performance reporting within Power BI, providing your team with a governed view of actuals, outlook, variances, and trends without the burdensome spreadsheet-heavy reporting cycle. With Power BI integration, teams gain access to real-time variance reports, ensuring reliable cost performance insight for Business Analysts, Project Managers, and Project Controls teams.
Why Dollar Grid
Instead of
- Building reporting models from scratch
- Manually consolidating financial data
- Recreating monthly reports
- Spending hours preparing management views
- Discovering trends after they become problems
Use Dollar Grid to
- Start with a purpose-built cost-performance environment
- Centralize financial and operational reporting
- Automate recurring reporting workflows
- Analyze actuals, outlook, and variances
- Identify trends and emerging cost risk
Bring Your Own Data
Step 1:
The Dollar Grid template app can load user data from Dataflows in Power BI service.
Step 2:
Provide the workspace id and dataflow id. There are 3 tables that are required in the Dataflow. The schema for these three tables should be defined as explained in the following steps. For users without subscription, data should not include dates beyond 2025. Only subscribed users can load data beyond 2025. For support on setting up dataflows, please contact us at sales@bideploy.com.
Step 3:
Financial Outlook
a. Order Number (Type: Text, Nullable: False)
b. Year (Type: Text, Nullable: False)
c. Cost Type (Type: Text, Nullable: False)
d. Jan-Dec 12 Columns (Type: Decimal Number, Nullable: True)
Step 4:
Financial Actuals
a. Order Number (Type: Text, Nullable: False)
b. Cost Type (Type: Text, Nullable: False)
c. Actuals (Type: Decimal Number, Nullable: False)
d. Fiscal Period (Type: Date (MM/DD/YYYY), Nullable: False)
e. Vendor Description (Type: Text, Nullable: True)
f. Cost Center (Type: Text, Nullable: True)
Step 5:
Work Order List
a. Cost Category (Type: Text, Nullable: True)
b. Order Number (Type: Text, Nullable: False)
c. Order Description (Type: Text, Nullable: False)
d. Project ID (Type: Text, Nullable: False)
e. Project Description (Type: Text, Nullable: False)
f. Department (Type: Text, Nullable: False)
g. Region (Type: Text, Nullable: True)
Step 6:
Subscription Authentication
The email id used when purchasing the annual subscription. The app verifies subscriptions through the Azure URL. Please make sure that authentication method is set to Anonymous and Privacy Level is set to Public. Without subscription, users will only be able to use the app with limited features. Click on Sign in and Continue.