Data Warehouse

By pwsbuilder / June 16, 2022 /

A Data Warehouse (DW) is a hub where data are collected and processed with a primary aim to provide business insights to the organizational users to make data-driven decisions on the go. The data warehouse is usually a centralized repository where different data sources (transactional systems, relational database management systems and others) are connected.  This…

Read More

Extract, Transform and Loading (ETL) Data Phase

By pwsadmin / May 21, 2022 / Comments Off on Extract, Transform and Loading (ETL) Data Phase

Data Extraction After collecting/gathering data successfully from the different sources, the data experts (data scientists/engineers) have a primary assignment to extract data from different data sources (SQL or NoSQL servers, Flat files, Email, Web pages, Online forms). This process takes place immediately after the data collection step. The collected data are usually in unstructured form.…

Read More

Data Modelling

By pwsadmin / May 10, 2022 / Comments Off on Data Modelling

Data Modelling  The first step of every database design project is data modelling. This process entails the analysis and definition of all the different data within a business as well as the development of relationships, semantics and constraints between these data points. In other words, during the data modelling process, the data team access all…

Read More

Analysis and Insight Data Phase

By pwsadmin / April 19, 2022 / Comments Off on Analysis and Insight Data Phase

The final phase of the data cycle in any business is the analysis and insight data phase. This phase requires a data expert (data analyst or data scientist) to transform the processed data (numbers, images) into information (transformed data that prompts business users to understand their business processes) that produces insights (interpreted information that spurs…

Read More

Seek-Gen-Collect Data Phase

By pwsadmin / April 19, 2022 / Comments Off on Seek-Gen-Collect Data Phase

The Seek-Gen-Collect Data Phase consist of three steps. These steps are seeking data, data generation and data collection.   Seeking Data   An organization that has a good data culture will begin their business process by making an attempt to answer business questions. Questions like   How much funds will I invested in this business?   What are the…

Read More

Business Data Cycle

By pwsadmin / April 18, 2022 / Comments Off on Business Data Cycle

A business is an entity that seeks to meet needs or offer solutions to the community by providing goods, services or both to the consumers. This entity could be a commercial/ industrial, or mercantile enterprise. This entity is built by people with a common vision/purpose to achieve their goals (meeting needs, rendering services).  Several great…

Read More