Business Analysis Tool A Powerful Business Intelligence System www.bitimpulse.com

  • Published on
    25-Feb-2016

  • View
    42

  • Download
    1

Embed Size (px)

DESCRIPTION

Business Analysis Tool A Powerful Business Intelligence System www.bitimpulse.com. Contents. Information about Our Company What is a BI-system? Report Module Administrative Module Architecture and Key Features Advantages of Our Reporting System over Business Rivals. - PowerPoint PPT Presentation

Transcript

Business Analysis Tool

Business Analysis ToolA Powerful Business Intelligence System

www.bitimpulse.comCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .1ContentsInformation about Our CompanyWhat is a BI-system?Report ModuleAdministrative ModuleArchitecture and Key FeaturesAdvantages of Our Reporting System over Business RivalsCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .2Information about Our CompanyCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .3Information about Our CompanyOur business is:Development of our own BI system and consulting in this area (creation of OLAP/DW/ETL)Custom development of web/windows applications based on .NET platform

Technologies that we use:Microsoft .NETMicrosoft SQL Server, Analysis Services

We do software development and consulting since autumn 2003.

Our website www.bitimpulse.com Copyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .4What is a BI-system?Copyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .5Problem Each company, regardless of its size and scope of activity, has at least a single informational system with a database. This system contains the entire historic information about company activity sales, orders, shipments, transactions etc.

How is it possible to analyze this data?How to generate reports on this data to make decisions?Copyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .6

Old Model of Reporting Systems

ERPCRMSCM

Direct SQL queries

Client LevelMS SQL, Oracle, MySQL, Access, etc.Reporting systems of this type are currently unable to meet all requirements. Such systems create a set of serious problems.Many companies have reporting made in this way:Copyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .7Briefly on BIData in DBMaking DecisionsBI-systemBusiness Intelligence System (BI-system) is a broad category of applications and technologies for gathering, providing access to, and analyzing data for the purpose of helping enterprise users make better business decisions.+=A perfect analytical system is:All company data are stored in the unified format in the same coordinate systemReports of long time periods (a month, a year) are quickly generatedUsers are able to customize the reportsEverything works well constantly, without involving IT personnel.We are doing our best to make our product a perfect analytical system.Copyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .8Our BI SystemFeatures of our BI-system:InteractivityStabilityIntegration with Microsoft OfficeFlexible administrationSupport of all version of SQL Server since 2005Fearures of Analysis Services:Powerful mechanisms of data selectionFlexible algorithms of cube processingPowerful tools for cube and dimension design

Data Warehouse

Integration ServicesAnalysisServices

SQL ServerApplication ServerReport ModuleAdministrative Module

ERPCRMSCM

BIT Impulse

Business Analysis Tool

OLAP

ORTABULARCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .9

What is an OLAP cube?310201Store 1Store 3Store 2Coca-ColaApple Juice3029March2013AprilTimeStoresProductsAxes contain dimensions (time, stores, products etc)Cube cells contain measures, for example quantity of products sold4053Copyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .10What is a Tabular (BISM)?You can create a set of related tables which are loaded into servers RAM. All calculations are done on-the-fly. You can use either DAX or MDX guery language.

Copyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .11Customers

Copyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .12Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .13Report ModuleData analysis features:Pivot tables, charts, treemap, scatter diagram;Searching, filtering, sorting of data;Easy change of report structure;Highlight of data;Viewing of the data source;Offline data analysis;Export to Excel, Word and PDF;Printing reports.

Copyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .14Pivot/ChartYou can:Drill up/down an elementSelect the desired level of detailingPerform other navigation functionsChange the structure of the report using simple drag&drop operationsHide/Show element

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .15Scatter DiagramThe dynamic scatter diagram allows to track 4 measures at once. Each element is drawn as a circle. 2 measures define its position, while other 2 measures define its color and size.

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .16TreemapThe tree-map algorithm is a combination of a diagram and a tree. One measure corresponds to the size while the other corresponds to the color.

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .17DashboardDashboard gives a possibility to combine several elements in one report.

The main advantage is a possibility to see all high-level KPIs by different dimensions.

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .18DashboardConstructing of dashboard is quite easy: you simply drag and drop the necessary items to its place.

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .19DashboardAt this moment the table can display values using different types of markers.

Future versions will contain another ways of displaying data.

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .20The Member Selector dialog allows to to set the desired set of members. You can not only find the necessary members, but also you may search and filter them.Member Selector

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .21Charts

There are more than two dozens of chart types. Each chart can be configured with preview. Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .22Highlighting of DataWith the help of the gradient and exception highlighting you can analyze a vast amount of data

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .23Filtering and SortingYou can set up filtering of rows/columns of a table

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .24

Change of Report ViewYou can change the following report parameters:Color of text/backgroundFontNumber formatting (number of digits after point, currency, percentage, regional settings)Text orientation and alignment (vertical/horizontal, right/left/center alignment)

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .25Drilling through DetailsFor each position in the report you can see what data is "behind" it

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .26Reviewing Data OfflineIt's possible to save the report into NRP-file or to a local cube. There are special programs to view those files:

NRP

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .27Data ExportThe application supports export to:Microsoft ExcelMicrosoft WordPDFOpenOffice

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .28Scheduler ServiceYou can get the reports by schedule at desired days and time in any format.

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .29PrintingYou can set the scale, margins, comments, select the paper size and printing.

You can print in color.

Preview mode is available

The pages are automatically numbered

Report ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .30Administrative ModuleCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .31Administrative ModuleAdministrative functions:Management by users, roles, reports;Creation of the report templates;Setting of access permissions for the reports and data in the cubesViewing and analyzing of all usage statistics (who has opened what reports, what actions performed, what MDX requests launched)Subscribing users on reports by scheduleE-mail notificationsSSAS roles backups

Copyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .32System ArchitectureCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .33ArchitectureAnalysis ServicesThe following MSAS are supported: 2005, 2008, 2008R2, 2012

HTTP + zip compressionIISASP.NET web servicesProcess Pool of MDX executors.NET remoting

Repository(SQL DB)BAT Application ServerScheduler (Windows Service)Works on Windows 2003 - 2012R2Report ModuleAdministrative Module

OLAP

TABULARCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .34Out GUI application is developed using .NET technology. It communicates with the application server using HTTP protocol. This gives us a set of advantages over zero footprint clients:

1) speed: .NET code works much faster than any javascript

2) visualization: rendering of chars, tables, highlightings etc. looks better when it is a GUI applicatioin if to compare it with DHTML

3) traffic: out .NET code compresses all HTTP traffic using zip compression. The level of compression is at minimum 10 times. With HTML you will never achieve this.

4) resources: we can guarrantee that well free all resources in our .NET code..

5) Stability: our code keeps everything under control. In the case of errors administrators will get a notification with logs about what really happened (what report the user was looking, what button they pressed, etc.) so we can solve the problem in a short period of time.ArchitectureCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .35Key Features One report different access rights: the same report can be accessible for multiple users, however, each user will see only the data to which they have access. Integration with Active Directory: BAT users and roles can optionally bound to users and groups of AD. This simplifies administration of the system. The reports are not linked directly to the cubes: data access is performed through cube pointers. User profiles: each user is assigned a profile by administrator. Dependently on this profile they gain access to certain functions in the report designer. Intellectual application server, which executes user queries and is responsible for correct server load, for timely stopping of command execution, memory allocation, etc. Zip-compression of transferred data from the client to server and vice-versa. Problem tracking subsystem we start reacting on your problems earlier than you notify us. Client application can work both inside the browser and separately. There is a way of deployment of the client through the AD group policies.Copyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .36Advantages of Our Reporting System over Business RivalsCopyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .37Advantages over RivalsTechnical possibilitiesTechnical possibilities of our system are higher than those of the rival systems

PricingOur solution is less expensive than of competitors

Adaptation for your needsIn case if it is necessary to make changes or implement new features for you, we will cope with this for a moderate price and quite quickly. The majority of other BI vendors, on the contrary, will not pay attention to the needs of an individual customer.

SupportWe react to your problems before you are going to notify us. Our rivals have no such support mechanisms.Copyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .38ContactsWeb-site: www.bitimpulse.com E-mail: info2@bitimpulse.com Phone.: +380-32-2442265Address: 149, Zelena st., Lviv, Ukraine, 79035Copyright 2005-2014 BIT Impulse. All rights preserved. 2005-2006 BIT Impulse. .39

Recommended

View more >