Business Intelligence & Data Warehousing

We are mid way in 2017 and we have been seeing some big changes in the business world. New forms of data analysis will be emerging to offer companies much more by way of Business Intelligence, operational guidance, and strategic market tactics. So what exactly will we see coming into play next year?   I know that the education system in India still follows once in a 10 year syllabus appraisal system and students still think that computer industry means C, C++, Java and .Net (in some colleges, in fact they still teach COBOL. So ultimately they fall in love with these languages and feel disheartened if somebody asks them to work on something new. This is especially true for Data analytics & Business Intelligence as other IT work would have some amount of language programming (e.g. in Mobile/Web development etc.) but Data analytics & Business Intelligence is mostly playing with software tools at junior level . Data analytics & Business Intelligence has been bill

1.What is Data Warehousing? 2.What is Business Intelligence (BI)? 3.What is a Dimension Table? 4.What is a Fact Table? 5.What are the Fundamental Stages of Data Warehousing? 8.What are the Different Methods of Loading Dimension tables? 9.What is Data Mining? 10.What is the Difference between a View and a Materialized View? 11.What is a staging area? 12.What is OLAP? 13.What is the Difference between OLTP and OLAP? 13.What is ODS? 14.What is ER Diagram? 15.What are Lookup Tables? 16.What are Aggregate Tables? 17.What are Conformed Dimensions? 18.How do you Load the Time Dimension? 19.What is a Level of Granularity of a Fact Table? 20.What is a Factless Facts Table? 21.What are Slowly Changing Dimensions (SCD)? 22.What is a Surrogate Key? 23.What is Junk Dimension? 24.What is a Data Mart? 25.What is Schema? & Types of Schema? 26.Explain the Paradigm of Bill Inmon and Ralph Kimball.

 Interview Questions and Answers – Frequently? 1.What is RDBMS? 2.What are the Properties of the Relational Tables? 3.What is Normalization? 4.What is De-normalization? 5.How is ACID property related to Database? 6.What are the Different Normalization Forms? 7.What is a Stored Procedure? 8.What is a Trigger? 9.What are the Different Types of Triggers? 10.What is a View? 11.What is an Index? 12.What is a Linked Server? 13.What is a Cursor? 14.What is Collation? 15.What is the Difference between a Function and a Stored Procedure? 16.What is subquery? Explain the Properties of a Subquery? 17.What are Different Types of Join? 18.What are Primary Keys and Foreign Keys? 19.What is User-defined Functions? What are the types of User-defined Functions that can be created? 20.What is an SQL Server Agent? 21.What is PRIMARY KEY? 22.What is UNIQUE KEY Constraint? 23.What is FOREIGN KEY? 24.What is CHECK Constraint? 25.What is NOT NULL Constraint? 26.What is the difference between UNION and UNION

The most popular BI tools on the market are: 1] Oracle - Siebel Business Analytics Applications 2] SAS - Business Intelligence 3] SAP - BusinessObjects XI 4] IBM - Cognos 8 BI 5] Oracle - Hyperion System 9 BI+ 6] Microsoft - Analysis Services 7] MicroStrategy - Dynamic Enterprise Dashboards 8] Pentaho - Open BI Suite 9] Information Builders - WebFOCUS Business Intelligence.   Etc

1] Informatica - Power Center //(Best in Market)* 2] IBM - Websphere DataStage(Formerly known as Ascential DataStage) 3] SAP - BusinessObjects Data Integrator 4] IBM - Cognos Data Manager (Formerly known as Cognos DecisionStream) 5] Microsoft - SQL Server Integration Services 5] Oracle - Data Integrator (Formerly known as Sunopsis Data Conductor) 6] SAS - Data Integration Studio 7] Oracle - Warehouse Builder 8] AB Initio 9] Information Builders - Data Migrator 10] Pentaho - Pentaho Data Integration 11] Embarcadero Technologies - DT/Studio 12] IKAN - ETL4ALL 13] IBM - DB2 Warehouse Edition 14] Pervasive - Data Integrator 15] ETL Solutions Ltd. - Transformation Manager 16] Group 1 Software (Sagent) - DataFlow 17] Sybase - Data Integrated Suite ETL

BI  is an abbreviation of the two words  B usiness  I ntelligence , bringing the right information at the right time to the right people in the right format. It is a 5-step process to run your business smarter, starting with registering the right data correctly, collecting the data from multiple sources, transforming, combining and storing it in a data warehouse.                                        This data should be reported, analysed and distributed to the right people at the right time in the right format. The figure  shows these steps.