Tech Mentalist

"Think Bigger about BI"

SSRS #01: Introduction – Sql Server Reporting Services (SSRS)

Hello Friends,

Let’s start with SQL Server Reporting Services Stuffs.SSRS comes in Microsoft Business Intelligence tools.

SSRS is a server based reporting services. It is used to prepare and delivered variety of interacting and printed reports. Reporting services was firstly released in 2004 which is Add-on (i.e. Patch) for SQL Server 2000.After that Reporting services released as part of SQL Server with SQL Server 2005 in 2005.Next version released with some additional features as part of SQL SERVER 2008 and SQL SERVER 2008 R2. Latest version was released with SQL Server 2012.

Reports are defined in Report Definition Language (RDL) which is an XML markup language. Reports can be designed using versions of Microsoft Visual Studio, with the Business Intelligence Projects plug-in (i.e. installed with Sql Server) or with the included Report Builder. RDL Reports can be export in variety of formats including Excel, PDF, CSV, XML, DOC etc. You will find all Versions of SQL SERVER.

SSRS 2005

SSRS 2005 is SQL Server Reporting Services ships with all versions of SQL Server 2005. SSRS allows you to quickly and easily create reports from multiple database sources. The finished reports can be presented directly from the reporting services website, or Windows-based applications. Reports can be exported to multiple formats, including comma delimited text, XML, PDF, Excel.

SSRS 2005 requires IIS to create Virtual Directories to host web service for running and managing the report. Report builder 1.0 released with SSRS 2005 which is used as ad-Hoc reporting tool.

Report Builder 1.0 would only allow the report developer to build reports against report models. Report models are very tightly controlled similar to using a SQL Server view or stored procedure and do not allow the report developer to freely access and directly query tables or directly write T-SQL statements against the data source.

SSRS 2008

In SSRS 2008 includes an advanced report layout structure called Tablix, data-visualization controls for charts and gauges, and a better report-authoring design experience in the Business Intelligence Development Studio (BIDS). In addition, a new Report Builder 2.0 tool is available to develop ad-hoc reports. First version that support SharePoint integration mode for reports. It provides added support for exporting reports in Microsoft Office Word format and has enhanced rendering to Excel and CSV.

Report Server is no longer hosted in Internet Information Services (IIS) and can independently take care of its networking and memory management needs. The report-processing engine can now do on-demand processing. For example, in a 100-page report, each page layout is computed only when the user actually wants to view the page. A new report-rendering object model provides more consistency in layout and pagination between report-rendering formats.

Report Builder 2.0 supports the full capabilities of SQL Server 2008 Reporting Services. We can create our own dataset; work with data source, Queries etc. which was not supported in Report Builder 1.0 that is added advantage for end user.

SSRS 2008 R2

SSRS 2008 R2 come up with additional Data Sources for Microsoft SharePoint list and Azure Databases, Parallel Data Warehouse. It provides some Add in for SharePoint integration, Reports Parts, Data visualization (Maps, Sparklines and Data Bars, and Indicators), Cache refresh plans etc. BIDS and Report Builder 3.0 were released.

SSRS 2012

Sql server 2012 provides new great features i.e. Power View. Power view Add-in for Microsoft SharePoint Server 2010 and 2013, is an interactive data exploration, visualization, and presentation experience. It provides drag-and-drop ad hoc reporting for business users such as data analysts, business decision makers, and information workers. Reporting Services report server in SharePoint mode supports SharePoint 2013. Provide BIDS with Visual Studio 2010/2012 which is SSDT.

SSRS 2012 provide Reporting Services data alerts are a data-driven alerting solution. Interactive view reports in Apple Safari on iOS devices. We can Renderers Microsoft Word/Excel 2007-2010.Report Builder 3.0 Remain Unchanged.

These are all reporting services release versions.

Hope this helps!!

Happy learning. Enjoy learning………….

Read more of this post

Advertisements

Tech #11: Business Intelligence Software’s {Part-II}- MSBI

Hello Friends,

Back in action after long period; apologize to my readers for this because of my non regularities from last 1 year. I am starting to share something new for readers, don’t want to disappoint them.

Thanks to Vishal for inspiring me to write and rejoin to Mentalist Network.

From last blogs I started with the technologies (products) in market for Business intelligence. Let’s start with Microsoft Technologies I.e. Microsoft Business Intelligence (MSBI).

Microsoft Business Intelligence

Microsoft Business Intelligence (MSBI) is a suite of products and tools that you can use to monitor analysis and plan your business by using scorecards, dashboards, management reporting and analytics.

Business Intelligence tool are available with SQL Server2008, SQL Server2008 R2, SQL Server2012.

Main important thing is Microsoft provide BI tool in Sql server (which is inbuilt). We can install directly when we are installing Sql server.

MSBI mainly having three Services :

1) Integration Services

2) Analysis services

3) Reporting Services

1) Integration Services:

Sql Server Integration Services(SSIS) mainly used for populating data warehouses (Extract, Transform and Load), Cleaning and standardizing data, merging data from multiple data stores, automating administrative tasks etc. developer can extend the built in functionality to accommodate any tasks.

2) Analysis Services:

Sql Server Analysis Services(SSAS) provides Online analytical processing(OLAP) and Data Mining by using Business intelligence applications.It Support OLAP By design, create multidimational structures contains aggregated data from Data Sources. Used to Build Cubes and Dimensional Database Model.

3) Reporting Services:

Sql Server Reporting Services (SSRS) used to present information from relational database, OLAP Cube or XML file. Provide Business reports, Ad Hoc Reports, Embedded Reports, and Portal Integration.

Sql Server Component Interface

 

image                                          Sql Server Component Interface

For Sql Server 2008, Sql Server 2008R2 set up having inbuilt Business Intelligence Development Studio, Need to check services at the time of installation.

For Sql server 2012 need to install add-in tool SSDT (Sql Server Data Tools) for visual studio 2010/2012 to work in Integration Services, Analysis Services, and Reporting Services.

You can also get additional information from Vishal’s blog.

From next we will see some Sql Server and SSRS Stuffs.

Hope it helps.

Happy Learning, Enjoy Learning

Read more of this post

Tech #10 : Business Intelligence Software’s {Part-II}- myDIALS

Hello Friends,

I like to share, its great achievement for our mentalist network, our 4 links are released on global domain.

We are officially announcing we have transferred our 4 blogs into personal domain !!

Now our Domains are:

  1. Business Intelligence Mentalist – http://bimentalist.com/
  2. Microsoft Mentalist – http://microsoftmentalist.com/
  3. SQL Server Mentalist – http://sqlmentalist.com/
  4. Dactylonomy of Web Resource – http://linkmentalist.com/

Bigger Network ,Bigger Market ,Bigger Knowledge ,Bigger Blogging !!

Our remaining MSBIMENTALIST and Tech Mentalist will release in global domain very soon.

In last post we saw about Microstrategy.lets move ahead with our new BI Supplier.

Today our supplier is myDIALS.

myDIALS:

image

Wayne Morris, CEO, leads myDIALS, which was founded in 2006. myDIALS is the leading SaaS performance management platform for the visualization and analysis of right-time performance metrics. The only SaaS-operational BI solution that incorporates advanced, easy-to-use analytics, myDIALS enables all users to view, filter, and interact with data to make more informed decisions, more quickly.

myDIALS connects to any data source for immediate data update and availability, and delivers unparalleled interactivity, knowledge sharing, and predictive analytics to support cost-effective continuous improvement. Thousands of users across multiple industries including manufacturing, financial services, and government rely on myDIALS to improve operational performance and business results through better decision-making.

NetSuite Business Intelligence:

NetSuite delivers built-in, real-time financial dashboards, reporting and analytics that allow you to continually monitor personalized key performance indicators (KPIs) and get access to the latest management and financial reports as part of your everyday activities. With NetSuite, you can diagnose financial issues on the fly with drill-down visibility to customer, employee or transactional details—and quickly take action to drive business performance.

myDIALS provides a SaaS Business Intelligence solution that is focused on helping companies improve operational performance. The myDIALS NetSuite Module is seamlessly integrated within the NetSuite user interface and includes a self-serve and interactive dashboard that enables everyone to make better operational decisions by viewing, interacting with and analyzing performance measures and drivers that are relevant and continuously updated.

myDIALS Dashboard:

image

myDIALS dashboard capabilities:

  • Highly visual with graphics designed to aid in quick, consistent understanding.
  • Interactive to allow the user to filter and “drill into” information to obtain more detail.
  • Provides information in context — additional detail is presented in a hierarchical drill tree showing the original information and the path taken to obtain the detailed information.
  • Allows you to quickly apply filters, change contexts, and alter the time period and level of all information in the dashboard.
  • Enables you to drill directly into drivers, the formula used to calculate Key Performance Indicators (KPI metrics), and see the components or actionable Key Performance Drivers (KPD metrics).
  • Enables authorized users to easily view, filter, sort, modify, add, or delete raw data records.

 

Feature support ratings for BI:

image

WebFocus Support all major database for operations like Microsoft Acces,Oracle,ASCII-Text file-based,Microsoft SQL Serve,MySQL,Other ODBC Compliant Systems etc.

SaaS has become a common delivery model for most business applications. myDIALS is one of that.

Will see our next BI Suppliers in upcoming posts.

If you really like reading my blog and understood at least few thing,then please don’t forget to subscribe my blog.

Hope it Helps!!!


If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog

Where todays links are:

                              Dactylonomy of Web Resource

Tech #9 : Business Intelligence Software’s {Part-II}- MicroStrategy

Hello Friends,

Again ,I must be apologize to my readers for this because of my non regularities.

I will not let you down again for sure and will start boost posting again.

Lets move ahead with new BI suppliers. Today our Supplier is MicroStrategy.

MicroStrategy:

image

MicroStrategy, founded in 1989, is led by Michael J. Saylor, chairman, president, and CEO. The company had revenues of $455 million in 2010. MicroStrategy provides integrated reporting, analysis, and monitoring software that enables companies to analyze the data stored across their enterprise to make better business decisions. MicroStrategy’s BI platform delivers actionable information to business users via e-mail, Web, and mobile devices.

MicroStrategy 9

MicroStrategy 9 is a fully integrated BI platform that makes business intelligence faster, easier, and more user-friendly. Specific enhancements in the newest releases yield significant benefits to MicroStrategy customers.

These include: –

Enhanced Mobile Capabilities for iPhone and iPad : Transactions and multimedia capabilities expand the potential for mobile apps alongside Business Intelligence, multi-tasking, alerting, information workflow support, improved collaboration, and data visualizations with security features for the iPad and iPhone.

Visual Insights : Features within MicroStrategy Report Services provide a whole new way of doing Business Intelligence that will change the way you see your data; your first data visualization can be built in less than 30 minutes.

In-Memory BI Acceleration Technology : Enhanced navigation and search, parallel app loading, and automatic diagnostic checks.

Richer Dashboard Experience : It gives us 3x more data, 2x faster, plus new customized workflow capabilities and enhanced OLAP functionality on Flash dashboards.

Geo-Mapping Capabilities : Enhanced mapping visualizations for dashboards in iPad, iPhone, and MicroStrategy Web with Google Maps and out-of-the-box integration with ESRI (Environmental Systems Research Institute is a software development and services company providing Geographic Information System (GIS) software and geodatabase management applications).

Faster Start-Up for New BI Apps : Data import capabilities let users publish their own data into the BI system, predesigned mobile and dashboard app templates enable fast prototyping, and portable document capabilities allow dashboards to be moved between applications.

The MicroStrategy 9 Platform is uniquely engineered for enterprise BI performance and scale. It also serves the rapidly changing business needs of smaller, departmental BI applications. MicroStrategy 9 provides a seamless path to migrate workgroup and departmental BI applications into an integrated enterprise BI operation.

World-class Business Intelligence Products:

 

image

 

Feature support ratings for BI:

image

It served for all database support,MicroStrategy provide services for all industry type, it works in all platforms.

More than one million people worldwide and thousands of leading companies across all industries use MicroStrategy Business Intelligence software every day for better business decisions.

Will see our next BI Suppliers in upcoming posts.

If you really like reading my blog and understood at least few thing,then please don’t forget to subscribe my blog.

Hope it Helps!!!


If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog

Where todays links are:

                             Link Resource # 29 – All link – October 2011

Tech #8 : Business Intelligence Software’s {Part-II}-Jaspersoft

Hello Friends,

I must be apologize to my readers for this because of my non regularities.

I will not let you down again for sure and will start boost posting again.

We are with new BI Suppliers.

Todays our supplier is Jaspersoft.

Jaspersoft:

image

Jaspersoft Business Intelligence Suite is the world’s most widely deployed Business Intelligence (BI) suite due to it’s comprehensive capabilities, flexible light weight architecture, and affordable subscription model. Jaspersoft BI Suite delivers reporting, dashboards, analysis, and data integration services for both stand-alone and embedded BI requirements. With self-serve web based design and analysis tools, users and businesses of all sizes can improve their competitiveness and decision making with Jaspersoft.

Data Integration:

Jaspersoft ETL builds integration jobs with an intuitive graphical interface to handle the smallest to the most complex data integration job definitions. In business intelligence, data integration such as ETL (extract, transform, load) services are used to create and update a data warehouse or data mart. A state-of-the-art data integration product must be able to connect to all your data sources and support graphical modeling to design multiple process flows.

Products for Data Integration:

Reporting Software:

Jaspersoft allows you to create a broad range of report types to meet the needs of different users. Some reports are relatively static and highly structured to meet corporate identity, barcode scanning or other standards. Such “pixel perfect” reports are created by a technical user or professional report designer. At the other extreme, ad hoc reports are much more dynamic, providing the business user with the data and a drag-and-drop web tool to create their own reports.

Products for Reporting Software:

Dashboards:

Jaspersoft provides a drag-and-drop design environment for creating dashboards and mashboards.Dashboards can take many forms depending on the target audience and the information to be presented. Ideally, business users should be able to assemble their own dashboards and share them with others, all without involving technical people. Mashboards (a combination of mash-up and dashboard) provides real-time information from multiple public and private data sources.

Products for Dashboards:

Analysis:

Some users want to explore data quickly, without the expense of building and managing a data warehouse. In-memory analysis is the best approach to allow these power users to slice, dice, pivot, filter, and more. Other users have more advanced analytic needs or larger data sets to analyze. These users need online analytical processing (OLAP) to gain business insight from their data warehouse or data mart.

Products for Analysis:

Business Intelligence Platform:

Jaspersoft is a state-of-the-art BI platform designed to scale and to meet the tough requirements of a wide variety of organizations and deployment models.A modern BI platform must perform a variety of functions to support the needs of a diverse user community. The platform must secure and deliver the data as it moves from the source to the data warehouse, and ultimately to the user in the form of a report or analysis view. Metadata is often used to simplify the complexity of data for self-serve BI designers and users. Finally, it must support deployment and integration into a variety of environments and delivery models.

Feature support ratings for BI:

image

It served for all database support,Jaspersoft provide services for all industry type,it works in all platforms.

Will see our next BI Suppliers in upcoming posts.

If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog

Hope it Helps!!!


If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog

Where todays links are:

                                       Dactylonomy of Web Resource

Off Campus Jumbo Job Fair in Pune From My Company !! Welcome all !!

Hi folks,

One Good news for you !!

There is lots of opening in my company in many streams (Almost All  Smile )

We are organizing off campus in association with Times Job !!

Click on Add for more details !!

image

If your Interested Directly visit @ Venue in Given Time and Dates

See you there !!

Hope this helps

Mentalist Network Blogs

(B)usiness (I)ntelligence Mentalist -> http://bimentalist.wordpress.com

SQL Server Mentalist -> http://sqlmentalist.wordpress.com/

Link Resource Mentalist-> http://linkmentalist.wordpress.com/

MVC Mentalist -> http://microsoftmentalist.wordpress.com/

MSBI Mentalist ->http://msbimentalist.wordpress.com/

ALL BI Mentalist –>http://techimentalist.wordpress.com/

Professtional Blogging ->http://beyondrelational.com/blogs/vishalpawar/default.aspx


If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog


If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog

Where todays links are

Dactylonomy of Web Resource >> Link Resource # 25: Sept 12–Sept 24

Tech #8 : Business Intelligence Software’s {Part-II}-Information Builder

 

Hello Friends,

We move ahead with our BI supplier series.

Today our supplier is Information Builders.

Lets move ahead with it.

Information Builder:

image

Founded in 1975 by CEO Gerald Cohen, Information Builders’ BI and enterprise integration software is used by more than 12,000 customers, generating over $300 million in revenue. The company’s WebFOCUS BI software provides security, scalability, and flexibility. It helps users create executive, analytical, and operational applications.

Information Builders sets the standard for enterprise business intelligence and reporting with software and services that turn any enterprise data into actionable information.With the right information at the right time, users throughout your organization can make better decisions faster. WebFOCUS, Information Builders’ flagship product, is a fully integrated Enterprise Business Intelligence Suite (EBIS) that enables customers to make decisions based on complete information.

WebFOCUS:

image

The WebFOCUS business intelligence (BI) platform delivers rich, consumable, interactive information to the widest range of employees, managers, analysts, partners, and customers via solutions such as dashboards, portable analytics, and ad hoc reporting. It offers true do-it-yourself reporting with unmatched scalability.

WebFOCUS users don’t need training and it is easy for developers to create and maintain our solutions. Everyone, from end users of large-scale applications to power users who want access to raw data, can easily create their own reports and analysis using the latest technology for ribbon-based interfaces. And every bit of content in WebFOCUS is shareable and reusable.

FOCUS

FOCUS application development and reporting tools provide maximum functionality for non-technical business managers to business analyst/power users to professional developers. FOCUS can create reports from virtually any database, relational or legacy. FOCUS reports and applications are portable and scalable to more than 35 operating systems, including IBM mainframes, Compaq OpenVMS and NonStop systems, AS/400s, and an array of UNIX platforms, such as HP-UX, AIX, Solaris, and others. So users on multiple computer platforms throughout an enterprise can run the same consistent reports. FOCUS users in every major industry are finding it easier than ever to build and maintain custom applications and reports in Windows, Windows NT, even the Internet. In the history of the software industry, few products have offered a more open upward-migration path or more remarkable return on investment.

Focus for Mainframe

FOCUS for Mainframe continues to be the world’s leading mainframe 4GL for reporting, database access, and decision support. It’s the most accurate and dependable mainframe report writer available.

Focus for UNIX

Release 6.9 is a significant upgrade for FOCUS customers running Sun Solaris, IBM AIX, or HP-UX platforms. This release extends the scalability and compatibility between our two core offerings – WebFOCUS for real-time information delivery over the web and iWay Software, Information Builders’ division for business integration.

Platfrom Supported:

  • HP/MPEiX
  • Linux
  • Sun Solaris/Sun OS
  • Microsoft Windows NT/2000/XP
  • HP/UX
  • Microsoft Windows CE
  • Microsoft Windows Server 2003
  • IBM AIX
  • Silicon Graphics IRIX
  • Apple Macintosh
  • Sequent DYNIX
  • Palm OS
  • IBM OS/400

WebFocus Support all major database for operations.

Will see our next BI Suppliers in upcoming posts.

Hope it Helps!!!


  For more interesting links and daily update please subscribe
        our link resource website
       Todays link are follows:

                  Link Resource # 24: Sept 08–Sept 12

Tech #7 : Business Intelligence Software’s {Part-II}-IBM COGNOS

Hello Friends,

Go ahead with new suppliers those provide Business Intelligence software’s.

Lets see about IBM COGNOS.

IBM:

image 

IBM is under the direction of Samuel J. Palmisano, chairman of the board and CEO. The company, founded in 1911, manufactures and sells computer hardware and software. Today, it has revenues of approximately $100 billion. The company’s Business Intelligence offering is called Cognos 10 BI. The software helps companies with decision-making that enables them to understand trends, opportunities, weaknesses, and threats. Cognos 10 allows users to explore data in combination and over time using analytics.

IBM Cognos business intelligence (BI) and performance management solutions deliver world-leading enterprise planning, consolidation and BI software, support and services to help companies plan, understand and manage financial and operational performance.

 

  image

 

 With the ability to interact, search and assemble all perspectives of your business, Cognos Business Intelligence provides a limitless BI workspace to support how people think and work. It delivers the complete range of BI capabilities: query and reporting, analysis, dashboarding and scorecarding on a single, service-oriented architecture (SOA). And it expands traditional business intelligence (BI) with planning, scenario modeling, real-time monitoring, collaboration and predictive analytics, to extend your BI capabilities.

Query and Reporting:

Cognos query and reporting capabilities ensure users are equipped with the information they need to make fact-based decisions in a system that’s simpler, faster and easier to manage. From professional report authors who design one-to-many reports for the enterprise, to business users who need to create their own ad-hoc queries or customize existing reports, Cognos query and reporting capabilities fits the needs of users across the organization.

Analysis:

Cognos analysis capabilities allows all users to explore information easily and intuitively to drive better, smarter business decisions. From general business users who can easily view, assemble and analyze the information required to make smarter decisions, to business and financial analysts who need more advanced, predictive or what-if analysis capabilities, Cognos analysis capabilities enable all users across the organization to outperform.

Dashboarding:

Cognos dashboard capabilities allow any user to access, interact and personalize content in a way that supports the unique way they make decisions. Secure access to information from all time horizons including Business Intelligence, Real-time Monitoring, SPSS and Cognos TM1 means that users can quickly move from insight to action.

Scorecarding:

Cognos scorecarding capabilities enable organizations to capture corporate strategy and communicate that strategy at the operational level. It helps executives and managers provide quantifiable goals and targets and allows them to track performance across business units, operating subsidiaries and geographic regions to quickly identify the areas that need attention.

Real-time Monitoring:

Cognos features real-time monitoring capabilities for consumers of actionable business intelligence. It provides an organization’s frontline employees with a rich view of operational KPIs and measures to support up-to the-moment decision making.

Statistics:

Cognos statistics capabilities, powered by IBM SPSS (Statistical Package for the Social Sciences) Statistics Engine, make it easy to incorporate statistical results with core business reporting, reducing the time it takes to analyze data and prepare business presentations based on that analysis.

Extending BI:

Empower users across your organization with the business intelligence (BI) they need to make effective, fact-based decisions. Cognos Business Intelligence provides solutions to ensure users have consistent, trusted and relevant BI, when, where and how they need it, with Cognos Mobile, Cognos Active Report, Cognos for Microsoft Office and Cognos Mashup Service.

Collaborative BI:

Collaboration capabilities within Cognos Business Intelligence facilitate decision-making for groups and teams. With this solution, users can build stronger relationships and learn from history with a centralized, searchable corporate memory. Cognos Collaboration helps teams maximize their efficiency and ensure the most effective use of resources when making important decisions.

 

Feature support ratings for BI:

image

It support for all database,Cognos provide services for all industry type,it works in all platforms.

Cognos delivered in On-Premises. On-premises software is installed and run on computers on the premises (in the Building) of the person or organisation using the software, rather than at a remote facility, such as at a server farm somewhere on the internet.

Will see new BI Suppliers in upcoming Posts.

Hope this Helps !!!


“  For more interesting links and daily update please subscribe
        our link resource website
         Todays link are follows:

                              Link Resource # 23: Sept 04–Sept 07

Tech #6 : Business Intelligence Software’s {Part-II}-BOARD

Hi Friends,

From my lasts posts think each technology have its own advantages and disadvantages, but I think every technology gives us good support, we take it as an advantage.

Let’s move ahead with new supplier, todays BI supplier is Board International

Board:

image

BOARD provides the functionality required to build any BI or Corporate Performance Management application without the need for programming. BOARD International, founded in 1994, is a privately held company with more than 2,500 customers. The company is led by CEO Giovanni Grossi.

A full complement of Business Intelligence functions, including reporting, multi-dimensional analysis, ad hoc querying and dashboarding,is combined with the ability to manage and monitor all performance planning and control processes, from budgeting, planning and forecasting to profitability analysis, score carding and financial consolidation.

From simple reports to the most sophisticated performance management applications, any analysis can be easily built using the drag and drop function and the configuration of objects that are automatically synchronized with the data.

A highly scalable multidimensional database, data reading and transformation tools (ETL), application user interface environment (client and web), security and a multi-tier architecture for system delivery—are the pieces one might expect when building an analysis application. The BOARD toolkit was designed to use all these tools together within the same development framework to provide an unparalleled combination of speed, flexibility and affordability.

“BOARD Capsules” are containers which can accommodate any BOARD object: reports, graphs, spreadsheets, folders, carousels, simulation models, dashboards and navigation

menus, which Board provide with every tool.These objects can be freely positioned on the screen with a simple drag & drop from the ribbon bar and interactively configured.

They are immediately synchronized with each other and with the database and they automatically react to users’ actions – empowering information workers to autonomously create their own analysis and reporting applications.

Molap Rolap ETL:

BOARD makes it possible for professionals to choose their data ‘engine’ type. Data may be stored in the proprietary multi-dimensional database (Multi-Dimensional Engine) or directly accessed in relational databases (Relational Engine).

It is combines both Multi-Dimensional and Relational Engines for the highest architectural and application flexibility.

In all versions data maintenance and management doesn’t require any programming. Provide guarantees speed and efficiency in information analysis and modeling.It also supports direct access to any relational database.

BOARD integrates all the capabilities required to handle data cleansing and standardization processes, thus eliminating the need to use specific products for Extraction, Transformation and Loading process (ETL).

BOARD ARCHITECTURE:

image

ROAR Portocol:

Communications between the client and the server uses a proprietary protocol named ROAR (Remote Object Access & Replication) which provides extremely high performance in communications and is designed to work efficiently over low band-width connections such as WAN or the Internet. The ROAR protocol in BOARD 7 is built upon the Windows Communication Foundation (WCF) classes of Microsoft .Net Framework 3.5.

Feature support ratings for BI:

image

Database Support:

  • Microsoft Access
  • Oracle
  • IBM DB2
  • Microsoft SQL Server
  • Informix
  • Sybase

 

Will see new BI Suppliers in upcoming Posts.

Hope this Helps!!!


      For more interesting links and daily update please subscribe
               our link resource website
               Todays link are follows:
                      Link Resource # 23: Sept 04–Sept 07

Tech #5 : Business Intelligence Software’s {Part-II}-BITAM

Hi Friends,

After Very long break, I am starting to write next BI Suppliers Information.

In last post we saw about Birst. let’s move ahead, my next supplier is Bitam.

 

BITAM : 

 

image

“Bitam is a global provider of Business Intelligence (BI) and Enterprise Performance Management (EPM) software solutions, delivering high business analytical capabilities to organizations of any size. The Bitam solutions are known for their rapid deployment, a high rate of adoption by users, low implementation risk, ease of use and minimal training requirements. CEO David Abdo leads Bitam, which was founded in 2000 and has more than 2,000 customers.

 

image

The company provides Artus, a BI application that provides monitoring and analyzing capabilities, including management dashboards and ad-hoc reporting.

Artus’ capabilities include slicing, dicing, and drilling into underlying data; performing trend analysis; using powerful statistical functions, predictive modeling and integrating visualization components into other existing applications such as intranets, portals, or customer extranets.

Artus provides the capability of both management dashboards and ad-hoc analysis within one product, providing a single solution for all of your business intelligence needs.

image

The dashboards contain live components that are connected directly to the underlying data giving you confidence that you are seeing the most current data that resides within your organization.

image

Artus leverages a rules and alerts engine to automatically notify users of information that requires immediate attention.Users can define and targets for key performance indicators, prioritize activities and be confident knowing that Artus will notify you either through visualization or through electronic means such as e-mail.

BITAM also provide solutions for:

1) Stratego for Enterprise Strategy planning

2) Ektos for Financial planning

3) Advisor for Intelligent Agent (for Powerful Alerts)

4) EAS-Enterprise analysis Server

5) EFS-Enterprise Forms Server

6) Papiro-Enterprise Reporting

“The Business Intelligence, Strategic Planning and Financial planning suites comprise Bitam’s complete product offering for Enterprise Performance Management (EPM) solutions.”

BITAM Artus mostly used in retail, finance, manufacturing, Transportation & Logistics, healthcare, government etc.

Database Support:

1) Oracle

2) DB2

3) Microsoft SQL Server

5) Informix

6) Red Brick

7) Access

9) Essbase

10) SAP BW

Saas Has Common Delivery for Birst, But for BITAM It can deliver in On-Premises or Saas.

On-premises software is installed and run on computers on the premises (in the Building) of the person or organisation using the software, rather than at a remote facility, such as at a server farm somewhere on the internet.

Will see new BI Suppliers in upcoming Posts.

Hope this Helps !!!


 
    “For more interesting links and daily update please subscribe
          our link resource website
          Todays link are follows:

                           Link Resource # 22: Sept 01–Sept 03