ETL Concepts and Business Logic
ETL Concept:
It is a process of extracting the data and transforming into required business format via loading into DWH.
ETL is often a complex combination of process and technology that consumes a significant portion of the data warehouse development efforts and requires the skills of business analysts, database designers, and application developers. It is not a one time event as new data is added to the Data Warehouse periodically – monthly, daily, hourly. Because ETL is an integral, on-going, and recurring part of a data warehouse
Load Balancing in SharePoint Server 2010
Brief on how load balancing is performed for SharePoint 2010. Got an oppurtunity to create a medium size SharePoint Farm environment with network load balancing (NLB) configuration. The Farm environment had below listed servers
- Application servers x 2
- Web Front Ends (WFE’s) x 2 /w NLB
- Clustered SQL Server 2008 R2 x 2
Need for Business Intelligence
It is not the strongest of the species that survives, nor the most intelligent that survives.But it is the one that is the most adaptable to change.
-Charles Darwin
Above quote also applies to businesses. Adaptive businesses sustain.
In order to observe the changing trend or in other words predict the market trend, business intelligence plays a pivotal role.
Overview on Microsoft Dynamics ERP
Microsoft Dynamics ERP caters to a variety of industries. From solution providers and system integrators developing add-on to various medium to large scale business challenges across geographies. Microsoft Dynamics ERP family allows localization on result orientated process functionalities, as to provide industry specific solutions. Industry applications for Dynamics ERP include, but not limited to:
|
|
Basics of Performance Testing Tools
Performance testing is monitoring the behaviour of the system under different loads Performance testing cycle can be divided into three stages
- Load Generation
- Load Application
- Load analysis or the system analysis
User Experience Design – The Way to Create Experience
Rewind back to the early days of web, Web designers were ruling the website and web based products. A single role performing the Graphic Designs, Wireframe, Information Architecture and front end development. Later on due to progressive growth of web, advancement of technology and methodologies it become more complex. So a broad vision and wider knowledge was needed for user centered process. By then emerges the User Experience, focusing on the human (user) perseverance and desirability in addition to the custom Human Computer Interface and Usability.