What is Clever Q Copyright Clever Q All

What is Clever. Q ? Copyright© Clever. Q®. All rights reserved. Clever. Q™ is a trademark of Better Days Enterprises, LLC Intuit and Quick. Books are trademarks and service marks of Intuit Inc. Excel, Access, Project, and Power. Point are trademarks and service marks of Microsoft

Transforms Data to Visualizations Clever. Q™

Visualizations n Types n n n n Dashboards Gauges Graphs Score. Cards Pivot Charts Pivot Tables View them. . . n n On your desktop In your presentations (via export capabilities*) On the Web Hardcopies *Export to Excel, Word (RTF), Power. Point (clipboard), Snapshots, and more.

Get Reports (Data) from n n n Spreadsheets (Microsoft Excel) Queries (MS Access, SQL Server, My. SQL, ODBC Databases) Quick. Books Reports Web pages (via Microsoft Excel Web Queries) Future interfaces include MS Project, and other Accounting software Custom designed interfaces from specialized data sources (e. g. Ameri. Soft-Inc, IDS)

Clever. Q™ Does More Than Just “Convert” Data n Clever. Q can analyze and process the data to provide: n n n n Additional Calculations Forecasting (Regression Analysis) Trend Analysis (Seasonal) Comparisons Alerts Conditional Advice Benchmarking Turns “Data” into “Intelligent Information”

Use Clever. Q™ for Monitoring n Measuring n Business Decisions n Evaluating n Alerting n Planning n

Clever. Q™ Components Reports (Data) Report/Data Extractors The optional built-in security manager can limit the data and functionality to specific users or groups of users. Analytical & Calculation Engine Data Cache Visualization Processor

How does Clever. Q work?

Clever. Q™ Components (cont’d) The Clever. Q ‘QBD’ file is like an ‘XLS’ file to Excel or ‘DOC’ file to Word. Extractor Definitions Parameter, Indicator, & Calculation Definitions Gauges, Dashboards, Score. Cards, etc. Definitions Report/Data Extractors (RDE) Analytical & Calculation Engine (ACE) Visualization Processor (VP) Blue blocks represent the Clever. Q™ Software Data Cache contains raw extracted data and pre-calculated results Gold blocks represent the user’s Clever. Q Bundled Definition (QBD) file.

Analytical & Calculation Engine (ACE) Definitions n Parameters n n The mechanism for labeling the report data so it can be used in formulas. Similar to identifying a cell in a spreadsheet Parameters can also be based on a formulas referencing other parameters. Indicators n n n Defines what will be displayed on a gauge Typically used to define a financial ratio Can be categorized Can include ranges with colors, icons, advice May include benchmark values and desired ranges Contains formulas based on parameters

Requirements n n n Clever. Q™ works on any current Microsoft operating system including: Windows XP, Windows Vista, Windows 7, Windows 2003 Server, and Windows 2008 Server. This includes both 32 bit and 64 bit versions. The software uses Microsoft Access and is compatible with Access 2002/XP, Access 2003, and Access 2007. If you do not have Access installed on your system, the installation program will provide an option to install a runtime version so you do not need to purchase Access if you do not have it. There are no special requirements for your computer hardware, but the faster the CPU in your system and the more RAM/memory you have, the better performance you will have with the software. The software once loaded will occupy approximately 100 Mb of disk space.

Build or Buy? n With Clever. Q you can choose whether to Build your own visualizations from scratch n Buy and use our pre-designed visualizations as is n Buy our pre-designed visualizations and customize them for your specific needs n Use our custom design services and have us A set ofbased visualizationson and related create your visualizations your definitions are contained in a Clever. Q Bundled Definition (QBD) file. requirements Visit our website to see a complete list of n Pre-designed QBD files.

The Sample QBD File (Included FREE with Purchase) n Includes: n n Sample extracted data Extraction definition to pull the following reports from any Quick. Books company file n n n n Profit and Loss Balance Sheet Sales by Item Summary Sales by Rep Summary Payroll Summary Inventory Valuation Summary A/R Aging Summary A/P Aging Summary 72 Parameter Definitions 60 Indicator Definitions with formulas, ranges and advice 40 Gauge Definitions using the 20 different gauge types available 5 Dashboards/Score. Cards 17 additional reports n Gauges Included Show: n n n n n Total Income Pie Chart Total Income Actual vs. Forecast Net Ordinary Income Net Income Operating Profit Margin Company Gross Margin Ordinary Income % of Total Income (Seasonally Adjusted) vs. Linear Trend Gross Profit Pie Chart Ordinary Income as % of Gross Profit Fixed & Variable Expense as % of Gross Profit Payroll as % of Gross Profit & Total Expense Trends Current Ratio Acid Test Ratio Company Return on Assets Debt-Equity Ratio Net Working Capitol Ratio And more. .

Purchase Options n Basic System (Comes with Sample QBD file, and ability to create custom QBD files. Also includes Excel, Queries, and Quick. Books Extractors) n Single User – Multiple Companies n Clever. Q™ Standard n For Use on PC using Windows XP, Vista or Windows 7 n Multiple Users – Multiple Companies n Clever. Q™ Pro-Server n For use on Windows Server 2003 or 2008 n Multiple Users using Terminal Services & Remote Desktop (RDP)

Purchase Options (Cont’d) n n Additional Pre-Designed QBD files Clever. Q Live cloud Subscription Service n n Additional Internet viewing of Dashboards using our On-Line Service using your uploaded local Clever. Q™ QBD file. Consulting Services (Call us for a quote) n n n Installation Training Custom designed QBD files, extraction interfaces, etc.

What to do next? n View other parts of our website to learn more n n More presentations, screenshots, features list, links, and more Contact us for a personal live-demo Go to the Purchase Information page of the website Fill out the Buy Now information, and we will contact you for payment information and send you a link for the software download with your installation key

Contact Information n Clever. Q Software www. Clever. Q. com n Email: Sales@Clever. Q. com n Phone: 605 -348 -7338 n Address: n n 722 Alta Vista Dr n Rapid City, SD 57701