Day One was dedicated to .net technology. We had lot of session on the .net technology. .Net framework areas covered on day 1 session are ASP.NET,ADO.net Entity framework,WCF,WWF,Cloud application development,AJAX etc,.
The First Session that i attended was "Business Intelligence Design Patterns- BI Made Easy" by Stephen forte, the Regional Director of Microsoft New York.
Day started with a welcome speak by the host of GIDS program, sorry I don’t know her name. Post which Stephen took over the charge and made the audience dive into the world of Business Intelligence Design pattern.
He explained the Advantages of Business Intelligence design pattern by explaining the advantages of BI and ETL process.
These are the points that were discussed during session
- For any Transactional Database Data Entry optimization is utmost key important area.
- Online Banking is the best example of Business Intelligence design pattern.
- Deciding the schedule for updating data is important will working with business Intelligence Design Patterns.
- Deciding the details that needs to be Transfer to data warehouse is also important. These are called Facts
- Processes involved in building the Data ware house are
o Summarization of Database
o Transformation Process
o Running Reports against the Data ware house.
- Some of the Terminology involved in the Data ware house paradigm are
o Facts table – Captures the data at details level
o Measures- Numeric facts, a column in a facts table
o Dimension Table-is a structure that categories the data.
- There are two model or schema involved in the Data ware house
- In Star Schema these are the points to be aware of
o Fact table are in Third Normal Form
o Dimensional tables are de-normalized to (2NF) and Contains Hierarchies and Partitions
o Star Schema diagram depicted below
- In Snow Flakes Schema is derived from Star, but normalized dimension table.
No comments:
Post a Comment