Introduction

 

Welcome to IntelligentApps 4excel™. IntelligentApps 4excel™ is a new product dedicated to providing the Microsoft® Excel user with a new dimension in business analysis and modeling power. IntelligentApps 4excel™ runs as an Add-In to Microsoft® Excel, exploiting all the capabilities and usability features of Excel with the power and scalability of Microsoft®’s Analysis Services. A number of Wizards are available to guide the user through the different steps required to build a cube from a Excel report or via edition, create data entry sheets or data load profiles to enter data into the cube and produce several styles of reports to display the analyzed information.

 

Cube Wizard Using the cube wizard you can build cubes either from existing Excel applications or in free form mode.
Data Loading Wizard You can load data into your cubes from either csv files or existing Excel reports. The data loading wizard takes you through this process in a step-by-step manner.
Data Entry Wizard You might not have all your information available in existing file or reports or you might want to perform what-if analysis. You can create any number of data entry worksheets using the data entry wizard and once you have the worksheet formatted in the way you work, you can perform direct data entry, what-if simulations, reference information in any other worksheet and perform data entry at higher levels.
Pivot Table Wizard A PivotTable is known to most Excel users as a means of analyzing data in relational databases and complex spreadsheets. The pivot table wizard makes use of this same technology, but greatly simplifies the process of creating a pivot table.
Formatted Report Wizard The report wizard provides you with a very powerful multi-dimensional report writer. with this you  can build as many report queries as you like, link them together and specify how you want the report sets packaged and distributed to the customers.
Briefing Book Wizard The briefing book wizard allows you to perform both simple and very complicated analysis on a cube. You can save any view as part of a briefing book and once complete, you can export this book as a live powerpoint application.