Reports, Datawarehouse, Staging, Source,

Source data, target data, data Warehouse, Data mart, reports, Etl-extract Transform Load, ETL logic-incremental or ful L, Integration Services, Reporting Services, Analysis Services, Database engine, cubes, measures, measure Groups,dimensio NS, facts, reports Testing-drill down, drill through, build deployment. I mean there is just so many of them.
How does is the chain look like? May is something like this:
Reports, Datawarehouse, Staging, Source --, Oracle, MYSQL, SAP, Teradata, DB2, Sybase. It can be any combination of the listed as well as non listed ones for example as simple as flat text files. These multiple data sources can be a input data source to a application software that might help the end user take futur E Strategic decisions.
Staging:An intermediary state of source data that act as a input to the datawarehouse where in data are loaded by the ETL logic US ING Integration Services from the source data. It is more or less the source data in its original form with those tables getting discarded this might not being needed for T He report generation within the application.
Datawarehouse:It is the final entity developed within the database engine that gets created in the sequence mentioned above. It's here, the final objects get created and based on these objects the cubes was created for the analysis purpose. Here the object types, the complete data are organized into are called dimensions and facts. They as well as just-tables but the attributes within each dimensions and facts has a specific association WI Thin itself to resemble some realistic facts and associated information as per the business requirement.
Cube:This is the analytics services objects within the complete BI application development phase. As the name suggests it is not just the the and the dimension tables that hold its relevance in a typical RDBMS. It is indeed a three dimensional data modeling technique wherein we analyze a data set in more than just both dimensions. The facts that is associated with an application is analyzed as per the association they has with the various parameter s which in BI terms is called as measures, or measure groups. Measure groups is actually a combination of more than one related Measure. Thus we get greater insights into what a specific aspect of any business decision making gets impacted with a variation in Various parameters.
Reports: Reports is nothing but the cubes data getting represented onto a user friendly interface with the option to Parameterise The reports as per the business needs. In simple terms it's the end product that gets developed and the data we look for in the cubes be available for view pur Pose in them. We can drill down and drill through them based on the scenario we need. For example we can by default see the report for any specific fiscal year as to how much sales has been materialized and Then drill down to onto the quarter basis, and then monthly basis, then the weekly basis and finally on the daily basis. Similarly drill through also gets applied on to the reports and the data can be visualized as per needs. Authorization and authentication are another feature that have their role to being played in the Reporting Services but then the Authorization of the cubes over ride the privileges granted on the reports.

Staging, Datawarehouse, Reports, Source,