Business Intelligence Posts

BI Tips: Understanding Filtering

*Filters allow you to customize how data is displayed to you. There are several levels at which data can be filtered:

Read More

RQ Tips: Map G/L Accounts by Inventory Adjustment Reason Codes

Did you know that you can report shrinkage and inventory adjustments in your general ledger based on the reason for the adjustment? 

Read More

Getting the Most Out of Consumer Insight

By now, most companies realize the importance of gathering data and consumer insight. It’s never been easier to pull in various forms of information, numbers and trends. Now the problem is, what do you do with all this precious data? How do you ensure it’s being interpreted correctly and that the right actions are undertaken based on the findings? 
 

Read More

BI Tips: Using IIF Statements

Did you know? You can use IIF Statements in BI to correct "infinity" and "NaN" errors, as well as to format data according to certain data conditions.

Read More

RQ Tips: Tax Setup Per Product SKU

Assigning a new tax to certain product SKUs can be quick and easy. Do you have a new tax but only need it applied to certain products?

Read More

TracPoint: Serialized Coupons for All Your Digital Marketing

-- TracPoint integrates serialized barcodes for coupons into all digital marketing, including TracPoint Apps and Trac-Mail Email Marketing. --

Read More

RQ Tips: Best Practices in Tracking Door Traffic and Conversion Rates

Recent media reports about foot traffic and location tracking have stirred up interest from our customers around what type of metrics dealers can produce from their RQ data. Are traffic counters a good idea? What are the key metrics we see our dealers incorporating into their reports when it comes to traffic counting?

Read More

RQ Tips: Carrier Commission Reconciliation

When using the Reconcile Vendor Rebates tool in RQ, make sure to use the search filters. 

Read More

Windows XP End of Life: Small Merchants Must Act Now

Windows XP is now over 12 years old. As of April 8, 2014, Microsoft has discontinued the support of Windows XP. The time has now come for us and our hardware and software partners, to invest our resources toward supporting more recent technologies so that we can continue to deliver great experiences for staff and customers.

Read More

Filters versus Parameters

When a filter is added to a data set, it becomes a default view for the report viewer. A filter is a set view, meaning the viewer will not have the opportunity to change this setting at the run of the report.

Read More

Ensuring Employees Get the Product for the Right Purchase Order

Worried about your employees receiving product on the wrong Purchase Order? Is this a training hurdle? Don’t worry. We have the solution! 

Read More

Daily Dose of iQ: Help in Identifying Your Next Store Location?

Today we came across a startup called PiinPoint, which launches this week, whose software is designed to help companies plot out their next physical location.

Read More

Building Expressions

When building ratios (e.g. accessories/opportunity, Actual/Target) there are scenarios in which you will want to build these measures in the Tablix rather than in the query designer.

Read More