| |
|
|
| |
 |
|
Excel add-in for Microsoft SQL Server Analysis Services
|
Microsoft SQL Server is the leading data warehouse on the market today. But for most business professionals, it is virtually impossible to view or query this data without significant programming skills or direct IT support.
MIS Plain provides the missing link. Business professionals can browse, report and analyze their data from the Excel environment they know and trust. Behind the spreadsheet interface, however, lies a direct connection to Microsoft SQL Server Analysis Services. Since data are stored in a central database and not in local files, MIS Plain minimizes typical spreadsheet shortcomings such as manual rekeying, time-consuming consolidations and the risk of human error. |
|
|
Why MIS Plain?
- Just like Excel - only better - MIS Plain empowers business users to report and analyze Microsoft SQL Server data - without needing a degree in computer science.
- Drag and drop modelling - Users can also create new or modify existing models within the Excel environment. This helps keep the software in sync with changes in company, department or product structures without requiring IT support.
- Intuitive browsing - Most databases have been developed as IT tools and require advanced programming skills to run the simplest of queries. MIS Plain, however, is designed for business professionals. To browse your data, just drag and drop the desired elements into an Excel spreadsheet. With a double click you can zoom down to more details on the desired element.
|
Key features: - Sophisticated reports in seconds - Once you have your desired view, sorting, ranking, color-coding and other sophisticated analytic options help you assess information in seconds. Fine-tune views by switching the breakdown from sales per product to their percentage of total revenue or calculating the sum or average for a certain period.
- Minimal maintenance - MIS Plain reports maintain their professional layout with zero maintenance. For example, reports automatically select the correct number of rows and columns for each information query.
- Built-in analytics - Wizards support you in creating sophisticated reports such as ABC, trend analysis in just a few mouse-clicks. Advanced users can also create custom templates or adapt standard ones to corporate design, KPI's, etc.
- Mass report delivery made easy - By pairing MIS Plain with Microsoft SQL Server Reporting Services, companies can deliver flexible yet powerful enterprise reporting solutions. Users can publish dynamic MIS Plain views using the powerful scheduling and delivery functionality of Reporting Services. As a result, business professionals can deliver important information across the enterprise quickly and easily.
|
|
|
|
