Business Intelligence Tutorial

Posted by

This blog is Business Intelligence tutorial, which contains lots of definitions and terms.

There are three steps in Business Intelligence: Data forms, Data Warehouse and Reporting.

Data forms:

  • Structured: Standardized and easy for computers to read and query.
  • Semistructured
  • Unstructured: Not stored in rows and coloums, so it can’t easily read by computers.

As we talked in previsou blog, company data can be found in several locations, such as CRM programs, which is also shown in the picture below.

Data Warehouse:

Data warehouse uses a process (ETL, i.e., extract, transform and load) to standardize data, which allows it can be queried.

How does information get to a central location?

ETL———————>Data Warehouse

  • Extract: unstructutred data is tagged with metadata to make it easier to find
  • Transform: normalize data
  • Load: tranfer data to central warehouse or data mart

Turning Data into Powerpoints (Business Intelligence Reporting)

  • Data visualization: Graphic display of results
  • Dashboard: Interfaces that represent specific analyses

If you are interested in some high income skills or have any problems with Business Intelligence, feel free to contact me .

Or you can connect with me through my LinkedIn.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s