Your Ask Joey ™ Answer

What is business intelligence?

In general, business intelligence is the strategy and technology used by a company to analyze their data. There are a number of difference functions that fall under the business intelligence umbrella. These include analytics, data mining, processing mining, use of dashboards, etc.

The biggest problem most companies face is that they have a ton, and I mean a ton, of unstructured data. Successful companies have learned how to take this unstructured data and manipulate it so that it becomes structured data. The structured data is then used by decision makers to make operational and financial decisions.

What are the key steps to take unstructured data and turn it into useable information?

There are really 5 key steps needed to take unstructured data and turn it into reports that can be used by executives and managers to make decisions. The five key steps are as follows:

1) Unstructured data is extracted from various systems and loaded into a data warehouse.

2) From there, engineers organize the data into data sets.

3) From there, BI analysts and other analytic professional run queries on the data to extract the specific data they want.

4) The data is then loaded into various analytic tools so that the data can be analyzed. This is typically where dashboards and reports are created.

5) The dashboards and reports are analyzed by executives and managers.


Back To All Questions

You might also be interested in...

  • CECL Excel Workbook

    If you would like to use the Excel workbook that was used to create the Universal CPA lecture on CECL for debt securities, please click the link below to download the Excel workbook: CECL Calculation workbook (Universal CPA Review)

  • Journal Entry for Direct Materials Variance

    Journal Entry for Direct Materials Variance In the current year, Mission Burrito budgeted 6,000 pounds of production and actually used 4,000 pounds. Material cost was budgeted for $5 per pound and the actual cost was $8 per pound. What would the debit or credit to the direct material efficiency variance account be for the current...

  • Understanding Variance Analysis

    Variance Analysis Variance analysis is a method for companies to compare its actual performance vs its budgeted amount for that cost measurement (related to the flexible budget). The differences between the standard (budgeted) amount of cost and the actual amount that the organization incurs is referred to as a variance. By analyzing variances, the company...