MBA 582 PPU Programming & Database Environment Worksheet

Create three sources of origination of where the data will originate from.

Example;

1. Hard copy file: CSV

2. Database Environment (another database resource)

3. API

You will need to create CSV files with real data,

Create 3 different Data Marts

1. Data Mart 1 will represent business intelligence reporting

2. Data Mart 2 will represent Data Science (Analytics)

3. Data Mart 3 will represent Big Data (Hadoop)

Data Warehouse: Identify the database organization that you want to use

for your data warehouse. Research what different data warehouses are

available, and why you are going to use the one that you chose.

Create a diagram of the blue print of the data architecture, and include in

your document the information around the data warehouse.

Database Management &
Applications
Author: Jeff Seaman
Data architecture
11/18/2021
Development Process| Point Park University
3
What is a data
architecture?
Describes the structure of an organization’s logical and
physical data assets and data management resources.
11/18/2021
Databases| Point Park University
4
What is a data
architect?
Technical experts who adapt dataflow management and
data storage strategy to a wide range of businesses and
solutions. In charge of continually improving the way
data is collected and stored.
11/18/2021
Databases| Point Park University
5
Responsibilities
In addition, responsibilities include design patterns, data
modeling, service-oriented integration, and business
intelligence domains.
11/18/2021
Databases| Point Park University
6
Responsibilities
Always looking for ways to seek out innovations to
provide improved data quality and reporting, and
eliminate redundancies, provide better data collection
sources, methods and tools
11/18/2021
Databases| Point Park University
7
Data Architecture Example
11/18/2021
Databases| Point Park University
8
Data Architecture Example
11/18/2021
Databases| Point Park University
9
Data Architecture Example
11/18/2021
Databases| Point Park University
10
Data Architecture Roles
11/18/2021
Databases| Point Park University
11
Data Architecture Process
SDLC – (System Development Life Cycle)
Process for planning, creating, testing, and deploying an information system
oPlanning
oCreating
oTesting
oDeploying
11/18/2021
Databases| Point Park University
12
Thank You!
11/18/2021
Database Management| Point Park University
13
QUESTIONS
11/18/2021
Database Management| Point Park University
14