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.