Business intelligence


Business intelligence(BI) can be described as “a set of techniques and tools for the acquisition and transformation of raw data into meaningful and useful information for business analysis purposes”. The term “data surfacing” is also more often associated with BI functionality. BI technologies are capable of handling large amounts of structured and sometimes unstructured data to help identify, develop and otherwise create new strategic business opportunities. The goal of BI is to allow for the easy interpretation of these large volumes of data. Identifying new opportunities and implementing an effective strategy based on insights can provide businesses with a competitive market advantage and long-term stability.BI technologies provide historical, current and predictive views of business operations. Common functions of business intelligence technologies are reporting, online analytical processing, analytics, data mining, process mining, complex event processing, business performance management, benchmarking, text mining, predictive analytics and prescriptive analytics.



Business intelligence is made up of an increasing number of components including

*Multidimensional aggregation and allocation

*De-normalization, tagging and standardization

*Real time reporting with analytical alert

*A method of interfacing with unstructured data sources

*Group consolidation, budgeting and rolling forecasts

*Statistical inference and probabilistic simulation

*Key performance indicators optimization

*Version control and process management

*Open item management.


Data warehousing:

Often BI applications use data gathered from a data warehouse(DW) or from a data mart, and the concepts of BI and DW sometimes combine as “BI/DW” or as “BIDW”. A data warehouse contains a copy of analytical data that facilitates decision support. To distinguish between the concepts of business intelligence and data warehouses, Forrester Research defines business intelligence in one of two ways:

1.Using a broad definition “Business Intelligence is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information used to enable more effective strategic, tactical, and operational insights and decision-making.”Under this definition, business intelligence also includes technologies such as data integration, data quality, data warehousing, master-data management, text- and content-analytics, and many others that the market sometimes lumps in to the “Information Management” segment. Therefore, Forrester refers to data preparation and data usage as two separate but closely linked segments of the business-intelligence architectural stack.

2.Forrester defines the narrower business-intelligence market as, referring to just the top layers of the BI architectural stack such as reporting, analytics and dash boards.

Comparison with competitive intelligence:

BI uses technologies, processes, and applications to analyze mostly internal, structured data and business processes while competitive intelligence gathers, analyzes and disseminates information with a topical focus on company competitors. If understood broadly, business intelligence can include the subset of competitive intelligence.


Business Intelligence Trends:

Currently organizations are starting to see that data and content should not be considered separate aspects of information management, but instead should be managed in an integrated enterprise approach. Enterprise information management brings Business Intelligence and Enterprise Content Management together. Currently organizations are moving towards Operational Business Intelligence which is currently under served and uncontested by vendors. Traditionally, Business Intelligence vendors are targeting only top the pyramid but now there is a paradigm shift moving toward taking Business Intelligence to the bottom of the pyramid with a focus of self-service business intelligence.

Business needs:

Because of the close relationship with senior management, another critical thing that must be assessed before the project begins is whether or not there is a business need and whether there is a clear business benefit by doing the implementation. Another reason for a business-driven approach to implementation of BI is the acquisition of other organizations that enlarge the original organization it can sometimes be beneficial to implement DW or BI in order to create more oversight.

BI Portals:

A Business Intelligence portal(BI portal) is the primary access interface for Data Warehouse(DW) and Business Intelligence (BI) applications. The BI portal is the user’s first impression of the DW/BI system. It is typically a browser application, from which the user has access to all the individual services of the DW/BI system, reports and other analytical functionality. The following is a list of desirable features for web portals in general and BI portals in particular: Usable User should easily find what they need in the BI tool. Content Rich The portal is not just a report printing tool, it should contain more functionality such as advice, help, support information and documentation. The portal should be implemented in a way that makes it easy for the user to use its functionality and encourage them to use the portal. Scalability and customization give the user the means to fit the portal to each user.



Benefits of Business Intelligence

Benefits of Business Intelligence


The most substantial advantage of BI is the time and exertion spared with physically delivering the standard reports for the association. It is once in a while the biggest advantage however. Be that as it may, in light of the fact that it is so substantial it is regularly part of the condition when a choice must be made about actualizing BI, and in the event that things being what they are these investment funds alone can legitimize the BI framework, then it is the most straightforward approach to legitimize it. BI frameworks lessen work costs for creating reports for computerizing information accumulation and aggregation,automating report era ,giving report plan devices that make programming of new reports much straightforward and lessening preparing required for creating and looking after reports. The BI framework permits end-clients to concentrate reports when they require them as opposed to relying upon individuals in the IT or monetary division to set them up. The BI framework will even permit approved clients to outline new reports, Most associations use broad measures of assets assembling heaps of standard reports that are designated all through the organization. To ensure everybody has each data they require, a wide range of reports are sent to workers – typically on an extremely point by point level. Thus representatives feel overpowered by the measures of data that don’t give an unmistakable photo of the general circumstance. Furthermore, in addition, since so much exertion is required to collect the reports they more often than not touch base at the representatives’ desktop days or weeks after they were generally significant. At the point when workers attempt to discover head and tail of the information they even regularly find that the numbers are not tantamount between various reports and wind up breaking down the distinctions as opposed to translating the genuine numbers. Also, since trust in information is lost, no one sets out to settle on a choice in light of the numbers.

In any case, more awful yet: Many workers don’t have the preparation and information to decipher the numbers with a specific end goal to distinguish dangers and open doors. BI frameworks make data significant by giving data through bound together perspectives of information where KPIs are amassed and figured utilizing a focal store of definitions – an information model – to avert clashing definitions and unique report information Choices should be made each day and, as we as a whole know, choices have differing quality. Great choices can give gigantic advantages. Terrible choices give no advantages – they may even bring about you misfortunes. BI frameworks settle on better choices by giving leaders rich, correct and up and coming data and giving clients a chance to jump into information for further examination. In this connection the term chief should be found in an expansive point of view; it is not just administration that decides. Indeed, the choices that influence an association the most are those made by individuals everywhere throughout the association, from the sales representative who chooses to give a client a markdown to the acquisition partner who chooses to purchase certain items for stock.

A choice can be made the minute you have all the pertinent data at your hands. At the end of the day, the speedier the applicable data gets into your hands the quicker you can settle on a choice. Quick choices are vital for two reasonsIt makes the association more receptive to dangers and open doors .It abbreviates the time amongst thought and activity. A great many people will misplace their thought process in the event that they have to sit tight quite a while for additional data about the issue they are managing. BI frameworks empower quick choices by consolidating various information sources in like manner reports, along these lines sparing the client from physically joining information in spreadsheets and so forth. giving explanatory and impromptu reporting abilities that permit clients to rapidly recover new or diverse mixes of information as required as opposed to requesting new reports in the IT or money related offices. It offers with decreased framework reaction times by utilizing pre-amassed information or different strategies for quick information conglomeration

The best associations are those that succeed to make each individual in the association work towards a goa Conventional reporting frameworks mean to give clients information as per an altered and predefined structure. This unbending methodology gives the association answers to precisely the inquiries it can determine ahead of time. Also, no more. Cutting edge business knowledge frameworks then again give specially appointed inquiry capacities that permit clients to jab arbitrarily around in information to get answers to any scrutinize that strikes a chord. This permits clients to fortify there comprehension of the hidden examples of the business and along these lines to increase new bits of knowledge into the elements that lead to achievement or disappointment.

The advantages of actualizing business knowledge are various and strong. Regardless of the fact that the greater part of the advantages must be sorted as soft benefits it is obvious that couple of different frameworks offer the one of a kind vital advantages that business insight does.
Good day! Take care….

Business Intelligence and Entrepreneurs

Business intelligence is described as the set of techniques and tools for changing the raw data into useful information for development of various parts of the business. Despite the fact that BI is a straight forward practice yet the vast majority of the Entrepreneurs still feel that BI requires complex instruments and just huge undertakings can profit by it, in any case this is not valid, in truth ‘BI is for everybody’. Couple of year’s back BI devices had some level of complexity in nature and there was reliance on IT experts however now most business insight applications are cloud-based and prepared to use, with no particular equipment or execution necessities. Their interfaces, dashboards and reporting capacities have enhanced fundamentally, making them exceptionally easy to use and effortlessly sensible. Business visionaries must comprehend that the objective of BI is simple translation of huge volumes of information for recognizing new open doors and actualizing a viable system with a focused business sector advantage and long term stability.

Roles of Business intelligence for Entrepreneurs

Cost Efficiency: From paying workers, buying supplies, and keeping hardware in great condition, it can be hard to oversee costs and comprehend where each rupee of overhead is going. A BI project can help business visionaries comprehend where spending is going, and decide answers for cut expenses.

For instance, an investigation dashboard may discover that a large portion of an organization’s working capital is tied up in distribution center stock that returns the most minimal net revenues. To enhance the money cycle, a business visionary may choose to quit offering such items, and to decrease the quantity of SKUs.

Operation optimization: Organizations use BI instruments to sort out their huge information. This implies increasing constant bits of knowledge on creation, deals, and business forms. Getting to be effective likewise implies having a superior comprehension of the items coming all through your stockroom, and discovering chances to streamline the generation line.

Diminishing waste straightforwardly influences all that really matters. BI is intended to help organizations draw relationships between’s different arrangements of data. A few projects incorporate visual communication apparatuses which produce visual guides like outlines, charts, and different infographics to help you better comprehend patterns. BI applications are getting more modern. Therefore, these projects are turning out to be more easy to understand to business visionaries and little entrepreneurs.

Better performance of staff: BI frameworks upgrade correspondence among divisions, coordinate exercises, and empower representatives to react rapidly to changes. As it were BI clients can rapidly get information driven key responses to business questions, as opposed to investing hours perusing through volumes of printed reports. At the point when a BI framework is all around planned and legitimately incorporated into an organization’s operations and basic leadership process, it specifically enhances representative’s execution. Today, numerous business knowledge programming sellers are making it workable for users to get to key business measurements, reports and dashboards on cell phones as well, giving deals and promoting individuals access to basic business data at whatever time, anyplace.

Quick and better decision: Entrepreneurs need to take several choices ordinary and they can’t generally depend on their hunch, one must comprehend that choices have fluctuating quality, great choices can give great advantages yet at that same time terrible choices can bring about misfortunes. BI helps Entrepreneurs to see point by point, current information on all parts of their endeavors, for example, monetary information, generation information, and client information. They can read reports or view graphical representations that incorporate this data in pre-decided routes, for example, current degree of profitability (ROI) reports for individual items or product offerings. This data helps Entrepreneurs to settle on truth based choices, for example, which items to focus on and which ones to end. In the meantime the speedier data is another key to react dangers and open doors adequately. BI abbreviates the time amongst thought and activity by joining various information sources in like manner reports utilizing pre-totaled information or different procedures for speedier information conglomeration. A late research demonstrated that Entrepreneurs are more OK with BI when contrasted with expansive endeavors since Entrepreneurs can be Agile and respond speedier to crisply revealed bits of knowledge and settle on genuine information driven choices, which just makes upper hand over moderate moving and bigger ventures.


Business Intelligence on the cloud…

I use to get this information from Tcs cloud engine


The use of Business Intelligence (BI) in the cloud is a game-changer, as it makes BI affordable and easily available as compared to traditional BI. It is expected that customers will slowly but surely migrate from in- house BI to BI in the cloud. Cloud Computing was a big topic of discussion in the early part of 2010 and many vendors developed strategies and solutions around Cloud BI in 2011. Customers are expected to continue their shift to the cloud in 2012, helped in part by big vendors enabling their traditional BI solutions as a cloud offering in an attempt to capture more of the mid-size market. Vendors are expected to further strengthen their cloud BI offerings and refine the migration approach to promote better adoption.

This Article  touches upon the drivers and challenges related to Cloud BI, and can act as a source of information related to leading Cloud BI vendors. It also covers a few sample use cases and recommended solutions for each scenario.

Business Intelligence (BI) on the Cloud is a delivery model that is slowly catching up and an area that is being actively watched by many. Although it is not expected that customers will rapidly replace their on- premise BI solutions in favor of Cloud BI options, it is observed that there are a few, legitimate use cases where the Cloud BI model would be beneficial and worth consideration.

This paper touches upon the primary drivers for Cloud BI as well as the main challenges and concerns around it. It further delves on a Return on Investment (RoI) calculator designed to aid a customer to calculate the long term savings of moving to a cloud model as against an on-premise solution. Finally the paper touches upon the Cloud BI product landscape and the leading vendors in this space in the current date, along with a few use cases where the Cloud BI model could be considered.

Cloud deployment strategies are often categorized either as Infrastructure-as-a-Service (IaaS), Platform- as-a-Service (PaaS), or Software-as-a-Service (SaaS).

n IaaS typically provides managed networking, servers, storage, platform virtualization, and operating system environments.

n PaaS builds on IaaS to further include managed middleware, such as application servers, database management systems, data integration services, BI development services, etc.

n SaaS extends this stack to also incorporate the application layer.


Above picture shows example of cloud based BI pictorial representation.

Business Intelligence on the Cloud: Drivers

There are several operational and financial factors that work in favor of Cloud Business Intelligence (BI), the key being:

*Speed of Implementation and Deployment: Immediate availability of environment without any dependence on the long periods associated with infrastructure procurement, application deployment, etc. drastically reduces the BI implementation time window.

*Elasticity: Leverage the massive computing power available on the Web, scale up and scale down based on changing requirements.

*Focus on Core Strength: Outsource running of BI apps to professionals and focus on their core capabilities.

* Lower Total Cost of Ownership: Convert some part of capital expenditure (capex) to operational expenditure (opex), cost-effective pricing models, pay per use model, etc.

*On-demand Availability: Support mobile and remote users, Browser-based access to control everything from the cloud platform to database management, from the data warehouse layer to the analytics platform.

BI On the Cloud: Concerns

There are also many inhibitors which have resulted in a very slow adoption rate to Cloud BI so far. A few common and leading concerns are mentioned here, along with recommendations on addressing the concerns:

n Data Security: Security concerns including confidentiality, integrity and availability of the data continues as the top concern for utilizing the Cloud. For some organizations, the concerns over security may be a barrier that is impossible to overcome today. However, as more organizations move to the Cloud it is expected that the concerns will lessen. In many cases, the Cloud vendors provide a more secure environment than what exists at customer sites.

*On premise Integration: Sudden movement to cloud is not feasible and a phased approach is usually recommended. There will be a co-existence model until the cloud BI market is more mature.

*Lack of control: Tough to get Service Level Agreements (SLAs) from cloud providers. Data control and data ownership, reliability of service challenges are some of the main reasons for client concern. To mitigate this, organizations should already have in place thorough IT governance and service delivery standards and models.

*Vendor Maturity: Too many cloud BI vendors, hosting providers with varying offerings, etc. makes it confusing to choose the right vendor based on required needs and vendor capabilities.

*Performance: Limits to the size and performance of data warehouses in the Cloud, significant latency if BI applications exist in the Cloud but the data exists at a client site, especially when processing and returning large amounts of data.

*Pricing models: Lack of standardized pricing models makes it difficult for customers to select the right one


1      IBM Cognos

IBM works with Industry partners like  ConnectEDU  in the education space to deploy reporting, visualization BI and predictive anayltics solutions to solve real world problems by leveraging IBM Cognos and IBM SPSS.  ConnectEDU has deployed Cognos and SPSS into their Education Cloud infrastructure enabling them to solve problems like creating early-warning systems for at-risk students using predictive analytics to identify those in need of intervention and support.

2      Birst

Birst delivers business analytics in the Cloud or on premise via an appliance which can be installed behind a corporate firewall. It includes BI and analytics components such as interactive dashboards, ad-hoc analysis, and visualization to pixel-perfect report writing. In september 2012, Birst received the highest score in the Wisdom of Crowds Cloud Business Intelligence Market Study, that make it the top-rated Cloud BI vendor over peer providers.

3      Indicee

Indices is a full BI Platform that provides APIs businesses can use to  embed powerful reporting into their own application or extend Indicee’s capabilities to create BI models, reports and dashboards. It can handel multiple types of data and integrat with ERP applications. Indicee can merge data from different business systems, reports and spreadsheets, enabling businesses to efficiently analyze and share that data to improve the decision making processes.

4      GoodData

Good data provides a cloud-based platform to do analytics on applications such as, Netsuite and Zendesk. Its features enable more than 6,000 global businesses to monetize big data. With a set of new business-specific offerings, GoodData users can connect their various data sources to the GoodData service and receive valuable analytics in return.

5      SAP BI OnDemand

It is a comprehensive BI solution in a software-as-a-service model that lets businesses explore, report on, and share business data. Its intuitive interface allows spreadsheets upload, bringing in different data sources, and share information online.

6      Pivot Link

Pivot link also uses in-memory analytics to analyze big data. PivotLink specializes in consumer marketing optimization applications, serving the retail and retail-related industry. Its on-demand analytic solutions aim to give businesses comprehensive view of omni-channel consumer behavior, customer segment performance, marketing program effectiveness and marketing portfolio attribution.

If you decided to implement a cloud-based BI solution, be sure to carefully consider your business requirements and choose the provider that best meets them.



Cloud is a big part of future Business Intelligence and offers several advantages in terms of cost benefits, flexibility of implementation, availability and speed of implementation. It is very relevant to BI/DW implementations as typical BI/DW applications demand high infrastructure requirements, handle unpredictable load volumes, involve high upfront investment, high development and maintenance costs, takes a longer duration for provisioning and has so far displayed a high reliance on IT.

Although initially cloud-based solutions were designed for small- to mid-size companies that did not have available IT resources or capital to spend on creating and managing a software and hardware infrastructure, today, many large companies are investigating the cloud as a way to add new business solutions quickly and augment existing data center capacity.

While considering Cloud BI, organizations are recommended to follow a few risk mitigation steps and strategies:

*Perform due diligence for security, backup, and disaster recovery: Check whether the BI SaaS provider complies with emerging SaaS standards such as the SAS 70 Type II audit.

*Thoroughly understand the BI SaaS pricing and contract matters: Understand the various pricing models offering by the vendor and choose the one that is definitely needed, study the service-level agreements (SLAs) agreed upon by the vendor and keep track of actual application usage.

*Evaluate true long-term total costs of ownership: Perform a detailed RoI calculation to calculate long- term total ownership costs based on the specific environment and requirements.

* Double-check whether any additional source data licenses are needed: Understand if any additional licenses need to be procured for other enterprise applications that the SaaS BI application would need to interface with.

*Plan for the worst: Have a detailed cloud to on-premise migration strategy in place in case the Cloud Vendor fails to perform according to desired expectations.


Reality mining

Reality mining generates the major data streams ripe for further analysis through business intelligence that can assist in decision making, another massive data source .


Reality mining in traffic management

Many device are being used by the consumer and business people are constantly using their location information. Millions of consumer business uses location-enable device for finding nearby services, locating friends and family , navigation ,tracking of assets and pets, dispatching, and engaging in sports, games and hobbies. To access these information a huge amount of historical data is being required and also real-time streaming location information is required. To access these information REALITY MINING builds on the idea that these datasets helps to build a pattern that provide human activity trends.

Reality mining helps to find some distinct classes of behaviour in specific context called ”tribes”. Macrosense is an application platform developed to analyses the data that are generated by mobile device and by using proprietary clustering algorithms to the data sets the customer search pattern is developed.

To use reality mining on a large scale, such as analyzing whole companies or towns, we use tools such as “smart phones” or electronic name badges. These small devices can record users tone of voice, people with whom they interacted, how long the interaction lasted, as well as other subtle social signals. Accelerometers already found in some phones can record patterns of physical activity, and the phone’s signal processing hardware can analyze its user’s speaking patterns. The large datasets that emerge do require sophisticated statistical analysis in order to reveal the underlying social patterns, but it is possible to obtain a real-time picture of hundreds or thousands of people working together. As a result, the science of reality mining can give practical, quantitative answers even for messy, real-world situations.

Citysense, which uses location data to show where peoples are going  and maps their activity. Consumers who have iPhones or BlackBerrys can sign up for the service, which does not ask for personal information. Over time, the software will learn their patterns and recommend places they might like to go, or show them where other people with similar patterns are going. By analyzing these types of data, engineers at Sense Networks can determine the probability that a user will visit a certain type of location, like a coffee shop, many times.



The data resembles a heat map of population density in a given city at any point in time. The data can be strung into time sequences to show the changes in human activity as a city cycles through the workday, the commute home, and nightlife. Path Intelligence method is being used to determine the location of a device to within a meter or two, and individuals can be tracked continuously as they move through an area, allowing the customers to understand which stores in a mall tend to be visited.




Usefulness for society


Reality mining of behaviour data with medication data from millions of people could make drug therapies more effective and help medical professionals detect drug interactions more quickly. If behaviour data were correlated with medical conditions, the data could illuminate the etiologic and preconditions of disease far more powerfully than is possible today and, further, serve as an early warning system for epidemic diseases such as SARS. Comparing the medical data with genomic and protonomic data from different population samples could provide a powerful method for understanding complex gene and environment interactions.


Improving Business Intelligence using BI Automation

To work effectively, organizations are starting to understand that business goals,objectives, obligations and execution prerequisites must be enunciated all through the organization and must be overseen not just at the official and senior administration level, additionally at the grass roots line-of-business (LOB) client level. Business intelligence(BI) is a key empowering innovation that can bolster this corporate need, and its capacities must, subsequently, be reached out to LOB clients. This is not a basic assignment or task. In spite of the fact that BI utilization keeps on developing, substantial quantities of LOB clients are still not ready to abuse the advantages offered by BI innovation. This is on account of numerous LOB administrators and business clients basically don’t have sufficient energy or abilities to utilize BI applications and instruments adequately. The solution for this issue is to make BI occasion driven and more computerized.

Today’s BI products can be analyzed from two key measurements – the sorts of BI processing they give and the sorts of business clients they bolster. From a processing viewpoint, the three fundamental sorts of BI handling to consider are strategic planning, strategic investigation and operational decision making. Inside each of these three sorts of preparing, there are extra levels of granularity, including reporting, receptive investigation (OLAP), prescient examination, and arranging and planning. From a BI client point of view, the four sorts of business clients that should be considered are officials, business investigators, operational LOB managers and operational LOB users.

On the off chance that we take a gander at BI item capacities at the crossing point of the BI preparing and business client measurements, we find that the heft of BI items are still focused at strategic reporting and examination by business investigators .The move toward including business performance management(BPM) abilities to BI items is, in any case, starting to enhance official administration support over the complete BI handling measurement from vital wanting to operational basic leadership. Another territory that is getting the nearby consideration of sellers is the expansion of BI vital arranging and operational basic leadership elements to the strategic BI preparing abilities right now gave to business examiners. There is now a shortage of BI abilities for LOB clients.

Most BI products and applications today are demand driven in that they require the client to stroll up to a PC and run an application to acquire data about business operations and execution. Moreover, to investigate particular business issues and to search for new business open doors, most BI applications and instruments oblige clients to utilize their business and specialized skill to control both the BI application and the data gave by the application. Most LOB clients and supervisors don’t have sufficient time or skill to do this.

The way to settling BI support for LOB clients is to catch the mastery of experienced business clients and to utilize it to streamline and computerize BI preparing for LOB staff. Business expertise can be recorded as far as best business practices which,  can be characterized as an arrangement of business principles if these principles could be bolstered in a BI application, the application could be utilized to screen business occasions to figure out whether any business move should be made. LOB manager or supervisor could then be educated about circumstances that require their activity. These LOB clients could likewise be supplied with nitty gritty data that could help them in settling on choices and taking activities. This events and principles driven BI methodology is easier than traditional BI methodologies and liberates LOB clients from employing BI tools to always screen and analyze business operations.

BI vendors have started to include some level of rules based automation to their items. Cases incorporate standards driven report bursting and conveyance, the highlighting of special cases on management dashboards, cause and effect charts in scorecards, and alarms to portable and email clients. The majority of these capacities, be that as it may, include applying straightforward standards to particular business occasions or measurements. Little has been done to help organizations archive, catch and computerize the perplexing business decides that control how data streams between business procedures and how this data is utilized to settle on business choices. Such capacities would empower associations to execute components, for example, guided investigation and BI design innovation which, thus, would help less experienced LOB clients settle on more educated and better choices.

The conceivable bearing of the BI business here is to gain from the experience picked up utilizing work process, process administration and business rules advancements in the business exchange handling world. Some IT associations have as of now connected this innovation in their BI ventures. Merchants, for example, Fair Isaac, with their decision management product set, are likewise moving in this direction. Thus BI automation plays a good role in BI.


MSBI (Microsoft Business Intelligence) is a suite of instruments giving answers for Business Intelligence Queries. These devices use Visual studio alongside SQL server. It enables clients to access precise and up-to-date information for better basic leadership in an association. It offers diverse apparatuses for various procedures which are required in Business Intelligence (BI) solutions.

Database Management Systems (DBMSs) are uniquely planned programming applications that associate with the client, different applications and the database itself to catch and break down information. A universally useful DBMS is a product framework intended to permit the definition, creation, questioning, overhaul and organization of databases.

ETL (Extracts, Transform, Load) Tools

ETL implies that its takes the information from different source areas, possibly as an alternate information position (for example SQL, txt, xls etc) and store this information into a goal (Data Warehouse).

Extract, Transform and Load (ETL) refers to a procedure in database utilization and particularly in data warehousing that:

Extracts information from homogeneous or heterogeneous data sources.

Transforms the information for storing it in an appropriate configuration or structure for questioning and investigation reason.

Loads it into the last target (database, all the more particularly, operational information store, data mart, or data warehouse).

MSBI is divided into 3 categories


  1. SSIS– SQL Server Integration Services – Integration tool.
  2. SSAS– SQL Server Analytical Services -Analysis tool.
  3. SSRS –SQL Server Reporting Services – Reporting tool.

Working Model of a MSBI Project


SQL Server Integration Service (SSIS)

SSIS is the ETL tool from Microsoft.

Integration Services is a stage for building elite information integration and work process arrangements, including extraction, transformation and loading (ETL) operations for data warehousing.

We can handle the data from different areas and different organizations (source areas) and recovery the data into a concentrated archive as a Data Warehouse/Data Mart (goal).

It incorporates graphical tools and wizards for building and investigating packages.

Data Warehouse and Data Mart

This is usually use for reporting and business investigation purposes. This framework is really the yield of incorporated data from numerous sources and stored into a brought together archive. The Data warehouse stores the present and historical data, so it is easy to create pattern reports, predictive examination and correlation reports. It’s exceptionally useful for the top administration to take the brisk choices about the business.

A Data Mart implies that it’s a little part of a Data Warehouse and demonstrates just a solitary part. It generally holds more outlined data/information.

SQL Server Analysis Service (SSAS)

            This is the way toward changing over two dimensional (lines and segments/OLTP) information into multi-dimensional information model (OLTP). This will help you to dissect the expansive volume of information.

Some of the advantages

  • Multi-dimensional examination
  • Key execution Indicator (KPI)
  • Score card
  • Slice, dice, drill down functionalities
  • Good performance
  • Security

SQL Server Reporting Service

Microsoft SQL Server Reporting Services (SSRS) is an endeavor reporting stage supporting conventional and intuitive reports conveyed over the web or through custom applications. It supports different information sources like two dimensional and multi-dimensional.

Some features of SSRS

  • Retrieve data from various source
  • Web based access to reports
  • Support for Ad-hoc reporting
  • Report developer helps to customize the reports for end client.
  • Easy subscriptions choices
  • Export functionality with lots of format.
  • Display reports in different ways like tabular, graph, Gauge.

Microsoft Business Intelligence platform capabilities

Business Intelligence is a significant wide term, in this way it wouldn’t be unnecessary to bring up what Microsoft BI stage can be utilized for

Preparing dashboards and scorecards. Numbers are critical, however likewise important it is to know where the numbers begin from. Dashboards and scorecards arranged inside the Microsoft arrangement are completely intuitive, in this manner one can rapidly plunge into every region of information to watch it from another perspective and – subsequently – discover something more. Despite the fact that the information may have its source in separated spots, it’s open from inside a solitary dashboard.

Stimulating joint effort. The matter of effective joint effort is urgent to every cutting edge association and Microsoft Business Intelligence stage underpins it extremely well. With all around created correspondence abilities (one can utilize online journals, wiki pages, common archives, and presentations), it permits all clients over the association take a shot at the same “adaptation of information” what helps their execution. Then again, internet searcher permits clients to rapidly discover precisely what they’re searching for, regardless of how high volumes of information are.

Self-adequate reporting and examination. Wide reporting and examination capacities obstructed in Microsoft Business Intelligence stage permit clients to pick up the knowledge as profound as they need. With no requirement for IT offices inclusion, they can get ready and adjust reports and investigation. The workplace is, then, secure and natural, so that no experts need to watch out for the framework unendingly.

Data mining and prescient investigation. The “following level” of Business Intelligence likewise is given inside the Microsoft stage. One can subsequently dissect information from various perspectives consequently and find the patterns what – if managed without PC bolster – could last fundamentally more or get to be inconceivable by any means.

Data warehousing. Microsoft Business Intelligence stage gives ETL (Extract, Transform, Load) forms and – along these lines – bolsters information isolation and warehousing.