Business Intelligence: The art of extracting right information in timely manner to right person from raw data, it doesn’t depend on specific technology but very wide of technologies depend on; like Data Mining. It makes the organization realize its resources, potential and give the Big Image* to the status of its goals.
Operational Business Intelligence: Business Intelligence Systems build on the same Business Intelligence process ETL, Analysis then Reporting but they don’t care about KPIs and Measures more than data listing.
Tactical Business Intelligence: Business Intelligence Systems build on the same Business Intelligence process ETL, Analysis then Reporting beside they give a wide solutions to tactical managers who can use them to get the most of KPIs (Profit in dollars, number of CRM tickets, etc) to take their organization step towards its goals.
Strategic Business Intelligence: Business Intelligence Systems build on the same Business Intelligence process ETL, Analysis then Reporting it helps the top management get the status -very brief status- of the organizations and its step towards its goals.
Measure\Fact: What’s the organization looks for, profit in currency, revenue, number of user come to website, number of CRM tickets, etc…
Dimension: How the Measure\Fact measured per, means profit in currency (Measure\Fact) can be measured per time, sales region, sales person, product type, etc.. so we call time, sales region, sales person, product type dimensions. Simply everything you can group by…
Hierarchy dimension: Dimension has self-relationship like time dimension we may see Year, Quarter, Month, Week, Day and may be more deep details. Simply everything with more than one level (deparment employee).
Attribute: Fact\Dimension property like Currency dimension may have currency name in English, currency name in Arabic; those are attributes.
Calculated member: Is a more comlicated calculation derived from the existing measures.
Data Mart: Dimension and Facts for specific department in the organization.
Data Warehouse: Big datamarts connected together.
ROLAP: Relational-OLAP: OLAP architecture where data stored in relational database where there’s no limit for data storage.
MOLAP: multidimensional-OLAP: OLAP architecture where data stored in multidimensional cube for fast retrieval for data and for executing very complicated queries.
HOLAP: Hybird-OLAP: OLAP architecture combines the both of ROLAP and MOLAP
Snowflake Schema: Data mart schema where Measures connected to Facts, but hierarchies dimensions not in one table like Time dimension, we have Year dimension connection with Month which connects with Day and so on.
Star Schema: Data mart schema where Measures connected to Facts, and all hierarchies dimensions exist in one table, in Time dimension example we find Year, Month, Day, etc. data exists on one table.
Report: form to list all data in tubular or matrix format where use can drill through to find more information about something.
KPI: Key Performance Indicator, $200 million is success to organization X? for sure the answer is I don’t know. so KPI come to say if the profit is more than H we made success and if it lower than L then we didn’t manage to achieve our target. so in scorecards we use some symbols like green light in case the measure exceeds the KPI. so dashboards depend on the KPI to give the right view to top management users because they just understand numbers.
Dashboard: Interactive report with various charts which state the status of organization POI, users can drill through and drill down to see more and more details.
Scorecard: Very interactive report with a lot of symbols and less words, for strategic managers depends mainly on KPIs.
ETL: refers to Extract, Transform and Load process which happens in the most Business Intelligence solutions to get data from different heterogenous sources, cleansing it then load it to the data warehouse.
OLAP: OnLine Analytical Processing, the stage to analyze the data to get the information.
OLTP: Online Transactional Processing simply is the backend data repository for any business application; It maintains data for business process and it’s from the sources of ETL process.
Data Mining\Forecasting: Built-in algorithms use to predicate the future based on existing data.
Cube: Microsoft term which represents “Data Mart”.
2005 download studio development intelligence business
2005 studio development intelligence business
2008 download studio development intelligence business
2008 express studio development intelligence business
2008 installation studio development intelligence business
2008 server sql download studio development intelligence business
2010 download studio development intelligence business
2010 market software intelligence business
2010 studio development intelligence business
2010 tools intelligence business
2010 vendors software intelligence business
2011 tools intelligence business
advisors intelligence business
analysis market and comparison tools intelligence business
analyst advisors intelligence business
analyst intelligence business
area bay in jobs intelligence business
atlanta jobs intelligence business
atlanta training intelligence business
bangalore in certification intelligence business
bangalore training intelligence business
boston jobs intelligence business
business intelligence
Business Intelligence
business intelligence advisors
business intelligence advisors analyst
business intelligence analyst
business intelligence analyst certification
business intelligence analyst interview questions
business intelligence analyst job description
business intelligence analyst job requirements
business intelligence analyst jobs
business intelligence analyst resume
business intelligence analyst resume sample
business intelligence analyst salary
business intelligence analyst salary canada
business intelligence analyst salary range
business intelligence analyst starting salary
business intelligence certification
business intelligence certification ibm
business intelligence certification in bangalore
business intelligence certification in pune
business intelligence certification india
business intelligence certification microsoft
business intelligence certification online
business intelligence certification program
business intelligence development studio
business intelligence development studio 2005
business intelligence development studio 2005 download
business intelligence development studio 2005 install
business intelligence development studio 2005 tutorial
business intelligence development studio 2008 download
business intelligence development studio 2010
business intelligence development studio download
business intelligence development studio download 2005
business intelligence development studio download 2008
business intelligence development studio download 2010
business intelligence development studio download sql server 2008
business intelligence development studio express
business intelligence development studio express 2008
business intelligence development studio install
business intelligence development studio installation 2008
business intelligence development studio installer
business intelligence development studio licensing
business intelligence development studio tutorial
business intelligence jobs
business intelligence jobs atlanta
business intelligence jobs boston
business intelligence jobs chicago
business intelligence jobs dallas
business intelligence jobs houston
business intelligence jobs in bay area
business intelligence jobs in denver co
business intelligence jobs salary
business intelligence jobs san diego
business intelligence software
business intelligence software comparison
business intelligence software examples
business intelligence software for small business
business intelligence software market
business intelligence software market 2010
business intelligence software open source
business intelligence software reviews
business intelligence software vendors
business intelligence software vendors 2010
business intelligence software wikipedia
business intelligence software's time is now
business intelligence tools
business intelligence tools 2010
business intelligence tools 2011
business intelligence tools business objects
business intelligence tools comparison
business intelligence tools comparison and market analysis
business intelligence tools gartner
business intelligence tools in the market
business intelligence tools list
business intelligence tools microsoft
business intelligence toolsets
business intelligence training
business intelligence training atlanta
business intelligence training bangalore
business intelligence training chicago
business intelligence training course
business intelligence training hyderabad
business intelligence training in dubai
business intelligence training in pune
business intelligence training microsoft
business intelligence training online
business small for software intelligence business
canada salary analyst intelligence business
certification analyst intelligence business
certification intelligence business
chicago jobs intelligence business
chicago training intelligence business
co denver in jobs intelligence business
comparison software intelligence business
comparison tools intelligence business
course training intelligence business
dallas jobs intelligence business
description job analyst intelligence business
diego san jobs intelligence business
download 2005 studio development intelligence business
download 2008 studio development intelligence business
download studio development intelligence business
dubai in training intelligence business
examples software intelligence business
express studio development intelligence business
gartner tools intelligence business
houston jobs intelligence business
hyderabad training intelligence business
ibm certification intelligence business
india certification intelligence business
install 2005 studio development intelligence business
install studio development intelligence business
installer studio development intelligence business
intelligence business
Intelligence Business
intelligence business networks
intelligence business solutions
jobs analyst intelligence business
jobs intelligence business
licensing studio development intelligence business
list tools intelligence business
market software intelligence business
market the in tools intelligence business
microsoft certification intelligence business
microsoft tools intelligence business
microsoft training intelligence business
now is time software's intelligence business
objects business tools intelligence business
online certification intelligence business
online training intelligence business
program certification intelligence business
pune in certification intelligence business
pune in training intelligence business
questions interview analyst intelligence business
range salary analyst intelligence business
requirements job analyst intelligence business
resume analyst intelligence business
reviews software intelligence business
salary analyst intelligence business
salary jobs intelligence business
salary starting analyst intelligence business
sample resume analyst intelligence business
software intelligence business
source open software intelligence business
studio development intelligence business
tools intelligence business
toolsets intelligence business
training intelligence business
tutorial 2005 studio development intelligence business
tutorial studio development intelligence business
vendors software intelligence business
wikipedia software intelligence business
