Finding the data and information in your business for decision-making
Microsoft Office version 2010 and 2013
How do business managers and their staff find data and information they need for decision-making?
- Ask the end-users of the data. But who are they?
- And what if the data exists in different versions? Which version is correct?
A data model is the "Corporate Street Directory". It includes data maps and data details in a repository. It is comparable to the city map and details of streets. A data model, therefore:
- Depends on business rules and business conditions
- Depends on the time requirements, and performance
- Depends on the technology used
A data model should be based on an organisation's strategic, tactical and operational business plans, if information systems are to be built that are aligned with the corporate goals.
Most organisations have not, until recently, recognised the importance of data models - which are as vital to the construction of an information system as an architect's plans are for the construction of a house or a skyscraper.
Today, a data model is an essential prerequisite for development of application databases, data warehouses, for internet/intranet systems and for business transformation to take advantage of the Internet and corporate Intranet technologies.
Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the South African Qualification Authority Act
Click here to download the Accreditation document
Click here to download the Accreditation Extension
Our Microsoft workshop presenters are Microsoft Certified Trainers and Microsoft Certified Technology Specialists
Certiport MOS - Microsoft® Office Specialist
Front Foot manage registration, purchase of exam and facilitate testing
FRONT FOOT IS AN EME
- 100% RECOGNITION
|Register now for this workshop
At the completion of this course the learner will
• Have completed 5 exercises which will guide them through the process of data modelling.
• Have thought critically about the data requirements and processes of a scenario used in class.
• Know the three phases of data modelling and their outcomes.
• Have set up Conceptual and Logical models describing the data in the scenario used in class.
• Understand the notation of 3 different Entity-Relationship diagrams.
• Have set up 3 different Entity-Relationship diagrams using Microsoft Visio.
• Understand Relational Database Management systems.
• Understand and applied Data Normalisation to the data in the scenario.
Delegates attending this course should have completed:
Microsoft Access Level 1
Microsoft Visio Level 1