Difference between Tableau and Power BI | Tableau vs Power BI | Compare Power BI and Tableau

Features	Tableau	Power BI
General	Developed by Tableau.	Developed by Microsoft.
General	Year of Establishment is 2003	Year of Establishment is 2013
General	Uses MDX for measures and dimensions.	Uses DAX for calculated columns and measure columns.
Availability	Tableau Desktop, Tableau Online, Tableau Server.	Desktop, Mobile, and Service.
Visualizations	Users can create charts, scatter plots in the tableau and don’t have any restrictions on the number of data points.	Offers numerous data points to provide visualizations. It has around 3500 data points for drilling down across the datasets and performing an analysis.
Performance	Can handle huge volume of data with better performance.	Can handle only limited volume of data.
Target Audience	Used by data analysts and experienced users mostly for their analytics purposes	Used by both naive and experienced users or by general audience that needs business intelligence to enhance their analytics.
Learning	Little difficult to learn.	Very easy to learn.
Pricing	High. Tableau Explorer – $35 per user/month	Comes at a lower price point, but scaled features and additional users will increase the price. Power BI Pro – Starts at $9.99 per month
Data Capacity	Tableau works on the columnar based structure which stores only unique values for each column and thereby making it possible to fetch billions of rows.	Each workspace/group could handle up to 10 GB of Data. For more than that, either data needs to be in cloud(Azure) or in the other case, if it is in local databases then Power Bl selects or fetches the data from database for reporting purpose and does not import.
Data Source	Has a wider variety and allows connecting to numerous data sources.	Connects to limited data sources but increases its data source connectors in monthly updates.

Advantages of MongoDB over RDBMS

The Advantages of MongoDB over RDBMS are

• No schema migrations. Since MongoDB is schema-free, your code defines your schema.
• Number of fields, content and size of the document can be different from one document to another.
• Tuning using indexes

• Ease of scale-out: MongoDB is easy to scale by adding commodity hardware

What is R - Programming Language – Statistical Analysis – Reporting – Graphic Representation

R is a tool for statistics and data modeling. R is a programming language and software environment for statistical analysis, graphics representation and reporting. The R programming language is elegant, versatile, and has a highly expressive syntax designed around working with data. R is freely available under the GNU General Public License, and pre-compiled binary versions are provided for various operating systems like Linux, Windows and Mac.

How Business Intelligence is linked to Data Warehousing

BI applications use data gathered from a data warehouse or a data mart. But every data warehouses are not used for business intelligence applications and vice versa.

Business Intelligence(BI) is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information which can be used by enterprise users to enable more effective strategic, tactical, and operational insights and decision-making.Business intelligence also includes technologies such as data integration, data quality, data warehousing, master data management, text and content analytics etc.

Data Warehouse and Business Intelligence Books

Please refer the below link for downloading:

Author:The Kimball Group have written authoritative books on dimensional data warehousing and business intelligence. Hope this helps

Datawarehouse and business Intelligence e-books

What is IBM Cognos?

Cognos is a Reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse. Cognos is composed of nearly three dozen software products.Cognos is built on open standards and the software products can be used with relational and multidimensional data sources from multiple vendors, including Microsoft, NCR Teradata, SAP and Oracle. The key feature of Cognos is that it is “A single architecture for viewing, querying, analyzing, and authoring for collaborative contributions to any report including dashboards.”

Why Cognos BI suite?

Cognos is IBM's business intelligence (BI) and performance management software suite. The software is designed to enable business users without technical knowledge to extract corporate data, analyze it and assemble reports. From business intelligence to financial performance and strategy management to analytics applications, Cognos BI suite can provide what actually an organization needs to become top-performing and analytics-driven. With products for the individual, workgroup, department, midsize business and large enterprise, Cognos software is designed to help everyone in an organization to make decisions that will achieve better business outcomes. Across Cognos, every user can read documents prepared in every format, therefore data transforming problems will not be there.

What is Oracle BI Server?

Oracle BI Server

• is a stand-alone process that maintains the logical data model which it provides to BI Presentation Services through ODBC.
• high-impact query, reporting and analysis server that provides its services to the other components of OBIEE such as Answers, Dashboards etc.
• an analysis server providing a calculation and aggregation engine that integrates data from multiple relational, unstructured, OLAP, and other sources.

What is Oracle BI Admin Tool/Oracle Business Intelligence Administration Tool?

Oracle Business Intelligence Administration Tool is

• Used to manage OBIEE server
• Available only for Windows operating systems.
• A Windows application that allows the BI Server administrator to create & edit repositories.
• Can edit repositories in either online or offline mode.
• Having a session manager and a cache manager in online mode.

How to Start Administration Tool in 10G

You can start it in two ways:

1. Using Windows Menu : Start > All Programs > Oracle Business Intelligence > Administration
2. By starting the executable file admintool.exe. 

How to Start Administration Tool in 11G

You can start it in two ways:

1. Using Windows Menu : Start > All Programs > Oracle Business Intelligence > Administration
2. By launching the Administration Tool from the command line using bi-init.cmd.

What is Oracle BI Answers?

Oracle BI Answers

• Provides answers to business questions
• Allows us to explore and interact with information
• An ad hoc query and analysis tool that processes the data from multiple data sources in a pure web environment.
• Present and visualize information using charts, pivot tables, and reports.

What is Oracle BI Interactive Dashboards?

Oracle BI Interactive Dashboards

• Provide personalized views of corporate and external information.
• Display required information to users for their decision making.
• Can aggregate content from other sources like Internet, shared file servers, and document repositories.
• Access to the information is interactive, based on the individual's role and identity.
• The end user works with live reports, charts, tables, prompts, pivot tables, and graphics and has full ability to modify and interact with results.

What is Oracle BI Delivers?

Oracle BI Delivers

• Is the interface used to create alerts based on analytics results
• An alerting tool that provides monitoring of business activity.
• They can be reached through multiple channels including email, dashboards and mobile devices.

What is Oracle BI Disconnected Analytics?

Oracle BI Disconnected Analytics

• Offers BI Answers and Dashboards to mobile professionals on computers disconnected from the network.
• It provides the same interface for users whether they are working in connected or disconnected mode.
• Allows you to view analytics data, Oracle BI Interactive Dashboards,and queries when you cannot connect to the network to access the Oracle Business Intelligence application.

What is Oracle BI Publisher?

Oracle BI Publisher

• Reporting engine able to generate reports from multiple data sources in multiple formats through multiple channels.
• Generates highly-formatted, pixel-perfect enterprise reports
• Based on XML(Extensible Markup Language)
• Can merge multiple data sources into a single output document.
• Report templates can be designed using Microsoft Word, Adobe Acrobat, Microsoft Excel and Adobe Flash
• Allow users to query, view, and format their own reports.

What is Oracle BI Briefing Books?

Oracle BI Briefing Books

• Reports captured series of snapshots of Oracle BI Dashboards.
• If we have a licensed version of Oracle BI Briefing Books, we can store a static snapshot of dashboard pages or individual requests in one or more briefing books. We can then download and share briefing books for viewing offline.
• Briefing books and their content can be updated, scheduled, and delivered using Oracle BI Delivers.
• Used to store/capture a series of static images of pages/requests at server, allowing the information to be viewed offline and shareable with other users and also we can keep track of changes offline.

Read Working With Oracle BI Briefing Books

What is Oracle BI Office Plug-In?

Oracle BI Office Plug-In

• automatically synchronizes information from BI Answers to Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.
• Using these Add-Ins, you can easily insert, deploy, and analyze business intelligence reports in Excel and PowerPoint.

What is Hyperion Web Analysis?

Hyperion Web Analysis 

• Is a module of Oracle Business Intelligence Suite Enterprise Edition Plus
• Is a context driven, thin client reporting and analysis tool
• Is a “report centric” query and reporting tool
• Delivers out-of-the-box presentation and reporting for Oracle [Essbase] and other multi-dimensional sources.
• Delivers powerful, intuitive, Web-based interactive analytics to all corners of the enterprise.
• Highly graphical and easy-to-use interactive interface
• Enables users to view their data in a way that makes sense to them.
• Enables the graphical interaction, presentation and reporting of multi-dimensional (OLAP) data.
• Transforms data from heterogeneous sources into meaningful queries, dashboards and reports by connecting to Oracle BI Server or direct connection to underlying databases as needed.

What is Hyperion SQR Production Reporting?

Hyperion SQR (Structured Query Reporter )Production Reporting

• Provides cross functional reporting from a variety of relational databases and data sources.
• SQR (Hyperion SQR Production Reporting, Part of OBIEE) is a programming language designed for generating reports from database management systems
• Oracle Hyperion SQR Production Reporting (SQR Production Reporting) software is a module of Oracle Business Intelligence Suite Enterprise Edition Plus
• Generates high volume, presentation-quality and pixel-perfect reports with unparalleled performance regardless of the spanning multiple enterprise data sources including SAP R/3 and SAP Business Information Warehouse

What is Hyperion Interactive Reporting?

Hyperion Interactive Reporting

• Is a module of Oracle Business Intelligence Suite Enterprise Edition Plus
  
• Pulls data together from operational or analytic sources to create charts, privots, and reports and can access the Oracle BI Server semantic layer.
• That provides executives, business users, and analysts with intuitive user-directed relational query capabilities. From interactive dashboards in a readily available context, to complex data modeling for fully ad hoc access to source data
• Can pull together data from disparate sources to produce easy to use charts, pivot tables, highly formatted reports, and more.

What is Hyperion Financial Reporting?

Hyperion Financial Reporting

• a reporting solution for multidimensional data (OLAP)
• supports a variety of sources including Oracle's Hyperion performance management applications (EPM) and Oracle Essbase.
• provides conditional suppression and automatic calculations that can be used to focus and filter reports.
• A graphical, object-based interface enables the rapid creation of reports that combine grids of data and text, charts, graphs, and images.
• Generates highly formatted, GAAP(Generally Accepted Accounting Principals) compliant, book quality financial and management reports
• Supports the emerging XBRL(eXtensible Business Reporting Language) standard.

Why to use OBIA?

The main advantage is that it can be used by any industry irrespective of the kind of departments.If its not suiting then we can customize the reports accordingly.

Using BI Apps the company can deliver greater insight to larger user communities across the organization via dashboards, query and analysis, and alerts.If we are building our own reports we can use OBIEE for that and develop BI metric, reports, and dashboard.Else we can just deploy prebuilt without any customization.

Most organizations needs analytic applications pull data from multiple enterprise sources and shed insight into the status and effectiveness of business operations. For example, a financial analytic application can track actual performance versus budget. A sales analytic application can track the size of the pipeline and identify the most profitable opportunities. A supply chain analytic application can optimize inventory levels, predict product fulfillment needs, and identify order backlog issues. While enterprise applications are required to run the business, analytic applications are mandatory to make sense of it.