Analytics Edge is a purpose-built, professionally written application suite for Microsoft Excel. The add-ins are small, fast, and easy to use. They are also secure, scalable and modular. Designed for individual use, yet strong enough for agencies and enterprises.
Base Technology – Analytics Edge is written in the C# programming language and interfaces with Excel as an XLL add-in. This lets it run much faster than Visual Basic (VBA) add-ins, and doesn’t require the macro-enabled workbooks that create deployment headaches and security concerns.
Dynamically loaded – Unlike many other Excel add-ins, Analytics Edge will not slow down Excel by just being installed. It is designed to stay out of your way (and out of memory), and dynamically loads only when needed. Even when loaded, the application and each of the connectors are about 1 Megabyte or less — tiny.
Modular – The Core Add-in provides connectivity with your Excel worksheets, and it dynamically loads and manages the growing portfolio of Analytics Edge connectors. You install what you need right from Excel’s ribbon bar. You have access to the entire portfolio of connectors, and can install and activate a free 30-day trial with the click of the mouse.
…It really removes the limitation of GA…
Scalable – Designed for Big Data and heavy use, Analytics Edge doesn’t let limits get in the way. Connectors will automatically download more data if the service has it available. Combine multiple queries, from multiple sources, into multiple worksheets and multiple workbooks.
Direct – Analytics Edge add-ins run locally on your computer, and the connectors make calls straight to the service API they support. There is no intermediate server slowing down your request, caching your data, or seeing your queries. This is why the connectors have no usage limits and one low price — the queries and processing runs entirely on your computer.
…the speed of queries! WOW
Fast – Response time is fast – even with 750,000 rows of data! Analytics Edge was designed with a unique combination of technologies, tightly integrated with Microsoft Excel and highly optimized to download, process and deliver your data into your worksheets as fast as possible. No other tool can get the job done faster.
Secure – All account credentials and configuration information is cached only on your computer where they are encrypted with 256-bit AES encryption — the same encryption technology used by many government agencies worldwide. Credentials are not stored in your workbooks, making them safe to distribute without worry. Each connector uses the strongest form of authentication and network communications available from the web service it supports.
Powerful – The Core Add-in uses an in-memory database that mimics Excel’s own tables — using columns of dates, text or numbers. Like expensive ETL tools (Extract, Transform, Load), imported or downloaded data can be manipulated using simple step-by-step function wizards, making it possible to completely automate the conversions necessary to go from raw data to meaningful metrics.
…a 1-2 minute task saving hours of time…
Automation – Refresh all the queries in your workbook with a single click using the Analytics Edge Core Add-in, even if it involves multiple sources or different accounts. For the ultimate in automation, the Core Add-in not only automates the refresh, it also lets you sort, filter, pivot, convert, combine, compare, calculate, and more, without complicated Excel formulas or restrictive pivot tables. It also lets you schedule unattended refreshes, save to PDF, and can even send your report as an email attachment.
No Coding – All Analytics Edge functions and queries are configured through pop-up wizards. Analytics Edge macros are automatically recorded by opening one wizard function after another. Editing a function step or query opens the same wizard with all of your previous settings. Unlike Excel macros, there is no programming involved! For more advanced users, the Core Add-in even supports range name references (variables) and repeating macros (loops).
Flexible – Things change, and Analytics Edge takes it all in stride. The Core Add-in lets you easily step through macros and see the result of each function transformation. Simple macro development and editing is supported with full undo/redo capabilities. You can easily insert, remove or re-order steps, as well as copy and paste queries and functions from other macros.
…it all becomes very easy to understand…
Simple – Our tagline is Simple Excel Report Automation, but our mantra is Simple. Technically, it’s simply better.