Analance Data Integration
Technical Whitepaper
www.ducenIT.com
Executive Summary
Business Intelligence is a thriving discipline in the marvelous era of computing in which we live. It’s the process of analyzing and exploring information, trends and patterns hidden in data. BI escalates the business roadmap and facilitates business users to deliver better strategic solutions. This process helps enterprise decision makers by providing data models, statistical analysis and forecasting for comprehensive data analysis.
In order to maximize the abilities of your BI platform, it is imperative that data is collected from applicable data sources and presented to users in a single view of the business operation. It sounds simple enough but integrating data
continues to be a challenge for most enterprises.
There isn’t one standard process for integrating data. There are disparate data sources, databases, data warehouses, and data marts. Each database handles data very differently, so what works for one organization doesn’t necessarily work in another.
The merging of data happens in the data warehouse or data mart where it is Extracted, Transformed and Loaded (ETL) from heterogeneous sources into one data store with common schema enabling the ability to query data. The challenge of “data
freshness” remains. When the original data source is updated, it doesn’t update the main data repository. To reconcile this problem, the ETL process has to be re-executed in order to synchronize the data. Additional problems arise when the query is designed to utilize summary data and the user would like to query granular level data. The process is further complicated when combining data from different departments such as when marketing is developing a bundled promotion. In addition to marketing data, a company might find it useful to evaluate information from field services, customer service and product returns. Yet often times, each department has their own silos of data.
Analance
TMand Data Integration
Analance BI provides a comprehensive integrated business intelligence, data analysis and enterprise reporting solution with its state of the art analytical and reporting services. Leveraging a modern architecture design based on SOA and XML web services, Analance Report Services provides a highly flexible, scalable, customizable and high performance reporting solution in a cost effective way.
Advanced Analytics
Real-Time Quick Data Modeling
Exploration and Discovery
Automates Business Logic
Point and Click Interface Easy and Quick Access
Automated Report and Dashboard Delivery Cos
Analyse a query and return the list of fields used for grouping, sorting
Iterate through rows and retrieve metadata easily
In order to maximize the abilities of your BI platform, it is imperative that
data is collected from applicable data sources and presented to users in a single view of the business operation.
Enterprise reporting
Rich, interactive reports
Reduces IT role of running reports
Powerful Analytics
Real-time data analysis
Robust data mining
Performance Management
Scorecards and Dashboards
Simplified metrics management
Unified Data Source
Built on single, integrated Enterprise BI Platform
2
Analance Collaboration and Integration
The ability to extract and present information in a meaningful way is vital to business success. Regardless of where data sits within an organization, people need the ability to access and transform data into actionable insight.
Executives need aggregated data that captures a complete view of the company and its operations if they are to measure performance and respond proactively to changes in the marketplace and the industry. Managers, teams and
individuals need the ability to find, share and use information from across all areas of the business to perform tasks effectively and monitor business operations. Finally, in this era of regulatory scrutiny, effectively managing compliance activities across the company requires a continuous flow of information and streamlined reporting activities.
Simply put, if companies are to make smart, fast decisions, they need business intelligence tools like Analance that deliver the right information to the right people at the right time.
The Analance framework provides prebuilt adaptors to work across platforms and integrate with several applications to provide:
An integrated architecture
A secure and personalized user experience
A collaborative environment
A comprehensive, cost-effective solution
The ability to extract and present information in a meaningful way is vital to
business success.
Disclaimer: All other products and service names mentioned in this document are trademarks of their respective companies.
Analance SAP Integration
Analance BI offers comprehensive flexibility for instant provision of all SAP R/3 & BW info objects for analytics and reporting platforms so knowledge workers can monitor business activity, analyze business performance and utilize goal driven business processes to optimize corporate performance. Analance on the Microsoft platform extends the SAP Net Weaver platform by following:
Reporting and analysis on data held in SAP transactional systems (e.g. mySAP ERP / R/3)
Leverage SAP BW business content and R/3 integration
Flexible free-form reporting on SAP BW
Flexibility, through deployment options
Greater analytics and reporting flexibility and features
MOLAP technology for better performance and scalability
More productive and efficient data transformations
Analance and Microsoft SharePoint Integration
Analance custom web parts like Connection Content Manager,
Navigation, Favourites’, Single & Multiple Tabbed Report Viewer, Dashboard Viewer
Single Sign On Manager for Business Intelligence & Performance Management Tasks
Integrate Analance BI into your day to day business applications in Microsoft SharePoint Portal
Drag & Drop BI
Analance BI offers comprehensive flexibility for instant provision of all SAP R/3
& BW info objects so knowledge workers can monitor business
activity, analyse business
performance.
4
Analance Collaboration Benefits
Analance provides a comprehensive integrated business intelligence, data analysis and enterprise reporting solution that delivers extended benefits to any business:
Dashboards and applications can be created with specific BI content and merged with other web parts to present a cohesive and productive user experience for different departments and user groups within your organization.
By integrating Analance Web Parts within SharePoint, you unlock the ability to create countless combinations of applications with embedded business logic.
Users become more productive when presented with focused business workflow that can revolve around a single report, a series of reports or dashboards.
Easy to use, customizable features allow you to add a discussion group right next to your sales reports, create a site dedicated to your department’s scheduled reports, add links to training material for additional information, or notify users of news alerts or system updates.
These enhanced BI tools help to streamline business processes to optimize corporate performance. By gaining faster access to data, you can more closely monitor your business processes and drive smarter, more profitable decisions.
6
About Ducen
Ducen is global technology company specializing in advanced business intelligence and optimization solutions. The company is focused on helping its customers leverage IT not just as a business utility, but also as a strategic driver to gain a competitive edge. As a diverse end-to-end IT Solutions Company, Ducen offers a wide range of expertise, aimed at helping companies re-engineer and add value to their growing businesses.
