Data Warehouse/Business Intelligence is a system useful for collecting, reporting the data and analyzing it and taking it into further actions like planning. DW is a Store House of many data coming from many operational sources. In a single place you can find many data from history to current and use it for creating Analytical reports. Meanwhile BI Provides Insights for that analytical reports, Predictive views and Strategies for the Business Operations. Identifies Large amount of data- Structured or Unstructured and create new strategic business opportunities.
-
Lesson 1. Introduction to Data warehouse Business Intelligence (DWBI)
-
Unit 1 Understanding Business Intelligence
-
Unit 2 Business Intelligence Technology Counterparts
- 1. Data Warehousing
- 1.1 What Is a Data Warehouse?
- 1.2 Data Marts and Analytical Data
- 1.3 Organization of the Data Warehouse
- 2. Enterprise Resource Planning
- 2.1 Distributing the Enterprise
- 2.2 First ERP, then Business Intelligence
- 2.3 The Current State of Affairs
- 3. Customer Relationship Management
- 3.1 CRM, ERP, and Business Intelligence
- 3.2 Customer Decisions
- 3.3 Decisions About Customers
- 4. Business Intelligence and Financial Information
-
Unit 3 The Spectrum of Business Intelligence
-
Unit 4 Business Intelligence User Interfaces
- 1. Querying and Reporting
- 2. Reporting and Querying Toolkits
- 3. Basic Approaches
- 3.1 Building Ad-Hoc Queries
- 3.2 Building On-Demand Self-Service Reports
- 3.3 Enhancing and Modifying
- 4 Data Access
- 4.1 Pull-Oriented Data Access
- 4.2 Push-Oriented Data Access
- 5. Dashboards
- 5.1. EIS Is the Engine
- 5.2 Metric System and KPIs
- 5.3 Business Intelligence Dashboards
- 6 Briefing Books
-
Unit 5 On-Line Analytical Processing (OLAP)
- 1.What Is OLAP
- 1.1 OLAP and OLTP
- 1.2 Operational Data Stores
- 1.3 Variations in Data and Approach
- 2. OLAP Applications and Functionality
- 3. Multi-Dimensions
- 3.1 Thinking in More Than Two Dimensions
- 3.2 What Are the Possibilities?
- 3.3 Drilling and Pivoting
- 4. OLAP Architecture
- 4.1 Cubism
- 4.2 Tools
- 4.3 ROLAP
- 4.4 MOLAP
- 4.5 HOLAP
- 5. Data Mining
- 5.1 What Is in the Mine?
- 5.2 Start with a Question
- 5.3 Examples
-
Unit 6 What’s next?
-
Unit 7 Business Intelligence: Is It for You?
- 1. How Do You Know?
- 2. Customizing Business Intelligence
- 2.1 Start with Questions
- 2.2 What Good Is the Information?
- 3. The Business Intelligence Project Plan
- 3.1 Planning the Plan
- 3.2 Resources and Roles
- 3.3 Risk Management
- 3.4 Data Migration Issues
- 4. Human Factors
- 4.1 The Business Intelligence Technology Team
- 4.2 The Users Don’t Want It
- 4.3 What Is It For?
- 5. “Could Be” as Opposed to “Should Be”
- 6. Choosing the Right Size, Shape, and Cost
- 6.1 Architecture Alternatives
- 6.2 User-Oriented Architecture
- 7. Best Practices
-
Unit 8 The Bottom Line
-
Lesson 2. SAS Business Intelligence
- Prerequisites
- 1. Introduction
- 2. Introducing the Business User Reporting Applications
- 3. Introducing Advanced Reporting Techniques and Roles
- 4. Creating an Information Map
- 5. Building a SAS BI Dashboard Application
- 6. Building Stored Processes
- 7. Utilizing Advanced Techniques with SAS Reports
- 8. Consolidating Information into a Business Reporting Application
- 9. Introducing Multidimensional Data Sources
- 10.Introducing SAS Visual BI
- 11.Examining the Environment Metadata
-
Lesson 3. Creating Stored Processes Using SAS 2
This course provides information about how to create advanced stored processes that prompt the user for input and create different types of output.
-
Lesson 4. Jasper Soft
-
Lesson 5. Tableau
-
Lesson 6. Denodo
This course provides the key concepts of the data virtualization architecture needed for management, planning, design and implementation of this kind of architectures.
- Prerequisites
- 1.Introduction to Denodo Platform
- 2. Virtual DataPort architecture
- 3.Virtual DataPort basic concepts
- 4.Introduction to the Virtual DataPort Administration Tool
- 5.Importing data sources and creating base views with Virtual DataPort
- 6.Creation of derived views and queries with Virtual DataPort
- 7.Publication of views as Web services
- 8.VQL (Virtual Query Language)
- 9.Advanced view management
- 10. Development best practices
- 11.Introduction to custom functions
- 12.Introduction to stored procedures
- 13.User administration in Virtual DataPort
- 14.Governance and data lineage
- 15. Server and user administration in Virtual DataPort
- 16.Updating the Denodo Platform
- 17.Backup and migration best practices
- 18.Monitoring and error analysis
- 19.Scheduler. Architecture.
- 20.Scheduler Administration Tool, jobs, handlers
-
Lesson 7 QlikView Course
The QlikView training-introduction module is presented to let you know that it is a flexible business intelligence platform, for turning data into knowledge.
-
Lesson 8 Qlik Sense
-
Unit 1 Teach Me Qlik Sense
1.Why learn QIik Sense and NOT QlikView 2. Getting Started 3. My First Qlik Sense App
No items in this section -
Unit 2 Creating Qlik Sense Apps
1.Read Data into QIik Sense Data Sources 2.Table Files 3.Excel 4.Drag and drop 5.Select data button 6.Text files 7.Inner Join
No items in this section -
Unit 3 Manage Data
1.Manage data loaded into Qlik Sense 2.Circular references 3.Link Tables 4.Use the QUALIFY statement 5.ODBC Connection to an Access database 6.Add some expressions 7.Read less data 8.Useful Script Functions 9.Folder connections
No items in this section -
Unit 4 Charts and Tables
1.Overview 2.Tables 3.Bar chart 4.Line Chart 5.Pie Chart 6.Chart Expressions 7.Chart Groups 8.Change Charts
No items in this section -
Unit 5 Development Tips
1.Memory stick development 2.App icons 3.User Interface Design 4.Bookmarks 5.Export data to Excel
No items in this section -
Lesson 9 IBM COGNOS ANALYTICS
Target audience - Multi-role (consumers, business authors, professional authors, developers, administrators, project managers)
-
Lesson 10 Oracle Business Intelligence Suite OBIEE
- 1.Introduction to Oracle Business Intelligence
- 2.Oracle’s Transactional Business Intelligence
- 3.Introduction to Oracle Data Warehousing
- 4.Business Intelligence Project Planning
- 5.Understanding Business Intelligence Needs
- 6.Justifying Business Intelligence Projects – cost/benefit analysis
- 7.Choosing a Platform for Oracle Business Intelligence
- 8.Designing Oracle Business Intelligence for Maximum Usability
- 9.Oracle Business Intelligence Tools
- 10.Oracle Data Loading and ETL
- 11.Managing the Oracle Data Warehouse
- 12.Business Intelligence Performance Tuning
0.00 average based on 0 ratings
