How Data ware house can help you make better decisions A beginners guide

The beginning
What is a warehouse?
Warehouse is collection of huge amount of periodical data that is used to study the behavior of the business over the period of time. 
Let’s assume that we have stored the data about a sale of products in different regions over a period of say 10 years from 2005 to 2015.
With Warehouse, being implemented perfectly, we can easily identify:
        1. Which product has been sold maximum in the month of September 2011?
        2. Which product has achieved maximum profit margins in the 3rd quarter of the financial year 2010?
      3. What is the trend for sale of laptops in Metropolitan city in 2nd quarter of year 2010 as compared to 2nd quarter of last 3 years?
 
So in simple terms, warehouse is a platform where we store:
        1. Raw data from various sources.
        2. Summarized data generated using this raw data.
        3. Data about the data called, metadata, to understand
       - What is the storage requirement of the data?
       - What is the nature of this data? Whether it is number or character or a date? 
 
Life cycle of a Warehouse

Image source- https://goo.gl/MfsVlV
 
Life cycle of a warehouse is all out the journey of data through it. It accepts raw data as an input and stores it as a set of meaningful information. Let’s go through all of the steps one by one. 
Initially, this raw data, having no meaning, is required to be collected from different possible sources.
        1. Uniformity is required to be imposed on the data collected from those different sources, if required.
        2. This uniformed data is now required to be transformed and scheduled to get loaded into the warehouse.
        3. This transformed data is further processed to do analysis.
        4. This analyzed information is then passed to the reporting systems to generate dynamic and meaningful reports.
 
Warehouse Architecture
Over the period of time, many theories have been put up regarding the architecture of a data warehouse. I could come up with 3 different ways that includes majority of patterns in warehouses.
        1. Centralized architecture.
        2. Federated architecture.
        3. Tiered architecture.
However, before explaining these types, I do feel it is important to have few words about data marts. Data marts are a portion of a data warehouse that contains data about a specific group. For example, if we talk about a sales details of an organization, then we can have data marts based on the territory, financial year, product or even sales representative wise. I hope data part is clear to all you.
So now, a stage is set where we can start with these architecture types.
Centralized architecture: In this type, we have single physical data Warehouse. So loading a data in warehouse is simple. However, accessing it is time consuming. This is the most traditional way of implementing a warehouse. 
Federated architecture: In this type, we have no physical data Warehouse. However, we have a logical area, that collects data from various sources and load it into physical data marts. This type is pretty useful, when the end user have all their analysis to be done category wise.
Tiered architecture: In this type, we have   physical data warehouse as Well as physical marts. Clearly with this approach, we can cover various varieties of requirements with faster access. However maintaining a change is a big challenge.
 
Conclusion
Warehouse is a big database that accepts raw data from various sources, processes it and store it in a specific format that helps us in analyzing the data with sound precision.
I hope this article helped you in understanding basics of warehouse. In future, we will be posting in depth discussion about these aspects.

Hello friends!!! Decision making is the one of the key aspects of any business for being successful. I am sure that all of you will agree with me that for any kind of decision making, we need data, a huge amount of data. Gone were the days when we relied on few GBs of data to come up to any conclusion. Today, we need Yottabytes of data for the same. However, to have this much ample amount of data with us, we need to have a special storage system. So in this blog, we will discuss about this special storage system called warehouse. We will also discuss about various terminologies that revolves around it. 

PMP® Certification Exam Training, Pune

PMP® Certification Training, Pune

Vinsys is conducting 4-day full-time PMP® PMBOK® Guide – Fifth Edition certification training at our Kothrud Head Office in Pune, India on April 11-12 and 18-19, 2015. Our PMP training delivery is led by Nitin Shende, PMP expert and SME Reviewer of PMBOK Guide – Fourth and Fifth Editions. We are a Project Management Institute, Inc. accredited training provider for PMP training, our PMI® Global R.E.P. Id is 2739.

Expert Trainer, practice tests, interactive sessions, practical approach, real life questions, training facilities that enhances learning outcomes, PMI REP. Register Now! or email enquiry {at} vinsys {dot} in for more information on upcoming PMP Training course in Pune .

Your Advantages of attending our PMP Certification Training course in Kothrud, Pune on April 11-12 and 18-19, 2015.

• Trained and certified more than 25,000+ professionals worldwide in Project Management processes
• Our consultants are globally experienced trainers and subject matter experts that makes learning interactive with practical application of industry-specific PM concepts
• Get a copy of PMBOK® Guide – Fifth Edition for ready reference
• Get PMP training course material developed in-house by PMP subject matter experts with expert guidance of Mr. Nitin Shende
• Attempt 220 real-life PMP Exam questions in the training sessions for comprehensive understanding of all knowledge areas
• Get PMP Exam prep 600 question bank CD along with the training course material
• Attempt overall 820 PMP Exam real-life questions covering complete syllabus as per PMBOK Guide – Fifth Edition.

Please e-mail enquiry {at} vinsys {dot} in to know more about our upcoming PMP training courses in Pune, India.

PMP Certification Training in Pune on April 11-12 and 18-19, 2015. 4-day full-time intensive PMP Exam Prep certification training workshop spread over two weekends at our Kothrud Corporate Head Office in Pune, India.

Don’t miss this chance to progress in your career with a PMI PMP Credential. Prepare for Project Management Professional (PMP) Certification Exam in Pune.

Price: Rs. 11,500/- + Service Tax. Join Now!

Venue of PMP® Certification Training in Pune:

Vinsys IT Services (India) Pvt. Ltd.,
Corporate Head Office – Kothrud,
28/11+12, Shivaji Niketan, Tejas Society,
Behind Dhondiba Sutar Kothrud Bus Stand,
Opposite Mantri Park Society,
Kothrud,
Pune – 411029.
Maharashtra,
India.

Tel: +91-20-4104 3535
E-mail: enquiry {at} vinsys {dot} in | Twitter: @vinsystraining | Facebook : facebook.com/vinsys

PMP Training: Program Overview

This program is designed to make participants comfortable and confident by demonstrating and illustrating the integrated approach to project management as described in PMBOK® Guide – Fifth Edition. Participants are led systematically to map The Project Management Body of Knowledge – Fifth Edition Guide to the existing practices that they follow.

The program also discusses the best practices and action plan needed to manage projects effectively. Comprehensive sections including sample questions on each knowledge area and planning processes are covered. Discussions on other matters of PMP^® exam, assignments, homework and plan for post course studies for PMP^®

Program Objective:

On successful completion, Project Management Professional (PMP®) training aspirants will be able to:

• Initiate a project.
• Define project scope.
• Develop schedule and cost performance baselines for a project.
• Plan project quality, staffing, and communications
• Analyze project risks.
• Define project procurement requirements.
• Execute the project.
• Control the project.
• Close the project.

Course Contents

1. Introduction 

• What is a Project?
• What is a Project Management?
• Relationships Among Portfolio Management, Program Management
• Relationship between Project Management, Operations Management and Organizational Strategy
• Business Value
• Role of the Project Manager
• Project Management Body of Knowledge

2. Organizational Influences And Project Life Cycle

• Organizational Influences on Project Management
• Project Stakeholders and Governance
• Project Team
• Project Life Cycle

3. Project Management Processes

• Common project management process Interactions
• Project management process groups
• Initiating Process Group
• Planning Process Group
• Executing Process Group
• Monitoring and Controlling Process Group
• Closing Process Group
• Project Information
• Role of the Knowledge Areas

4. Project Integration Management

• Develop Project Charter
• Develop Project Management Plan
• Direct and Manage Project Work
• Monitor and Control Project Work
• Perform Integrated Change Control
• Close Project or Phase

5. Project Scope Management

• Plan Scope Management
• Collect Requirements
• Define Scope
• Create Work Breakdown Structure (WBS)
• Validate Scope
• Control Scope

6. Project Time Management

• Plan Schedule Management
• Define Activities
• Sequence Activities
• Estimate Activity Resources
• Estimate Activity Duration
• Develop Schedule
• Control Schedule

7. Project Cost Management

• Plan Cost Management
• Estimate Costs
• Determine Budget
• Control Costs

8. Project Quality Management

• Plan Quality Management
• Perform Quality Assurance
• Control Quality

9. Project Human Resource Management

• Plan Human Resource Management
• Acquire Project Team
• Develop Project Team
• Manage Project Team

10. Project Communication Management

• Plan Communications Management
• Manage Communications
• Control Communications

11. Project Risk Management

• Plan Risk Management
• Identify Risks
• Perform Qualitative Risk Analysis
• Perform Quantitative Risk Analysis
• Plan Risk Responses
• Control Risks

12. Project Procurement Management

• Plan Procurement Management
• Conduct Procurement
• Control Procurement
• Close Procurement

13. Project Stakeholder Management

• Identify Stakeholders
• Plan Stakeholder Management
• Manage Stakeholder Engagement
• Control Stakeholder Engagement

 Target Audience

36 months of unique non-overlapping project management experience  leading and directing project tasks and holding a baccalaureate or global equivalent university degree or he/she should have 7500 hrs and 60 months of experience if he/she does not hold a baccalaureate or global equivalent university degree.

• Head/GM / AGM Projects
• Senior Project Managers
• Program Managers
• Projects Managers
• Senior Consultants
• CIO / CTO/Vice President
• IT Heads / Senior IT Managers
• Project /Team Leads /PMO
• Business Practice Heads
• Department/ Business Heads
• Business Analysts

Please e-mail enquiry {at} vinsys {dot} in to join this PMP Certification Exam Training 4-day full-time workshop, spread over two weekends; in Pune, India for Rs. 11,500/- + Service Tax only. PMP Certification Training Pune – April 11-12 and 18-19, 2015.