-
WhatsApp + 91-9999487949
-
Send Email info@softapptechnologies.com
-
Office No-51/3, 1st floor, Corenthum tower-B, near electronic city metro station, Sector 62, Noida, Uttar Pradesh 201309
Business Intelligence Course
Business intelligence comprises the strategies and technologies used by enterprises for the data analysis and management of business information. who has depend on base on business access to the persion on specific bsuiness domain like software business, food business etc.uses business analytics, data mining, data visualization, and data tools to help organizations make better data-driven decisions.
Why do we need Business Intelligence
EIS, MIS, DSS & BI
BI in various Domains and Functional Area
Information Pyramid
Data Information
Knowledge & Intelligence
Basis for Operational
Tactical & Strategic Decision Making
Requirements Gathering in BI through Business Questions
Why do we need Business Intelligence
EIS, MIS, DSS & BI
BI in various Domains and Functional Area
Information Pyramid
Data Information
Knowledge & Intelligence
Basis for Operational
Tactical & Strategic Decision Making
Requirements Gathering in BI through Business Questions
Foundation for Fact based decision making
Slowly Changing Dimension tables
The STAR and SNOWFLAKE schema
Fact-less Fact Tables
Aggregation Strategy
Time Dimension
Pros & Cons of the STAR/SNOWFLAKE Schema Dimensional Model
Slowly Changing Dimension tables
The STAR and SNOWFLAKE schema
Fact-less Fact Tables
Aggregation Strategy
Time Dimension
Pros & Cons of the STAR/SNOWFLAKE Schema Dimensional Model
Requirements Gathering & Analysis – Functional & Non-Functional Requirements
Typical BI Project Lifecycle
Post Production Support
Testing in a BI Project
BI Project Deployment
Reports & Dashboards Design – Mock-up and Storyboarding
Typical BI Project Lifecycle
Post Production Support
Testing in a BI Project
BI Project Deployment
Reports & Dashboards Design – Mock-up and Storyboarding
Building Reusable Application Objects – Metrics, Filters, Prompts
First Level of Abstraction of the Data Warehouse in MicroStrategy
Building the Schema Objects – Attributes, Facts, Transformation & Hierarchies
Five Styles of BI
Building Reports – Grids & Graphs
Setting up Report Distribution
Report Project
Report Manipulation over the Web – Pivoting, Sorting, Drilling, Exporting etc.
First Level of Abstraction of the Data Warehouse in MicroStrategy
Building the Schema Objects – Attributes, Facts, Transformation & Hierarchies
Five Styles of BI
Building Reports – Grids & Graphs
Setting up Report Distribution
Report Project
Report Manipulation over the Web – Pivoting, Sorting, Drilling, Exporting etc.
Introduction to RDBMS
Filtering, Sorting & Grouping datasets
Various Clauses in a SQL
Retrieving Data from multiple tables – Joins
Introduction to DDL & DML statements
Various Built-in Functions in SQL
Use of sub-queries
Data Dictionary and dynamic SQL
SQL Project
Language for retrieving Data from a database
Filtering, Sorting & Grouping datasets
Various Clauses in a SQL
Retrieving Data from multiple tables – Joins
Introduction to DDL & DML statements
Various Built-in Functions in SQL
Use of sub-queries
Data Dictionary and dynamic SQL
SQL Project
Language for retrieving Data from a database
Need for Enterprise Class Business Intelligence Infrastructure
The BI Ecosystem
Building Blocks of a N-Tier BI System – Servers & Communication Protocols
The Central Repository - Metadata
Information Consumption User Interfaces – Desktop Vs. Web Vs. Mobile
Open Architecture
Scalability, Performance in BI – In Memory Analytics
The BI Ecosystem
Building Blocks of a N-Tier BI System – Servers & Communication Protocols
The Central Repository - Metadata
Information Consumption User Interfaces – Desktop Vs. Web Vs. Mobile
Open Architecture
Scalability, Performance in BI – In Memory Analytics