Data Warehouse and Business Intelligence

Business Intelligence is the process of utilizing the business data to improve visibility of organizational operations and financial status to manage business better. Businesses needs to utilize and transform their data to plan for future business strategies to help maximize revenues and reduce costs. Business Intelligence helps in producing accurate reports by extracting and analyzing data directly from the businesses database.

Most Business Intelligence applications use data collected from Data Warehousing. Data Warehousing helps in achieving a successful BI program by facilitating several key aspects of reporting and data analytics.

What is Business Intelligence?
Business Intelligence is the process of gathering meaningful information to answer questions and identify significant trends or patterns, giving key stakeholders the ability to make better business decisions.

Why is Business Intelligence important?
Business Intelligence answers some of the important questions any business will have any given point such as What was the total Sales of this month? Is our Sales going up or down? Why Sales is up or down? Forecasting the Sales for future? Planning and targets
Business Intelligence covers the key indicators and address the important details such as What happened? What’s happening? Why it happened? What will happen? What does the business want?

Where is Business Intelligence applied?
Business Intelligence is mainly applied on two fields Operational Efficiency of the Business and Customer Interaction.
Operational Efficient includes ERP reporting, KPI Tracking, Product Profitability, Risk Management, Balanced Scorecard, Activity Based Costing, Global Sourcing and Logistics
Customer Interaction includes Sales Analysis, Sales Forecasting, Segmentation, Cross-selling, CRM Analytics, Campaign Planning and Customer Profitability

• Understand What is Data Warehouse and What is Business Intelligence
• Learn the basic differences and key concepts of Data Warehousing and Business Intelligence
• Understand the Architecture of Data Warehouse and Business Intelligence and compare it with Online Transactional Processing (OLTP) applications i.e. traditional databases
• Understand the design of Data Model for Data Warehousing applications and measure the performance of multidimensional data model
• Learn Facts Tables and Dimensions Tables in Data Warehouse
• Understand the OLAP operations with respect to Data Warehouse and Business Intelligence
• Demo of a Data Warehouse in Access and pivot table using Excel
• ETL (Extract, Transform and Load) tool in Data Warehouse and Business Intelligence