The most intriguing Information Technology business topics learned over the past month began with creating a blog website, relational database systems, and analyzing business intelligence.
Relational database systems are how to manage data using a structure and language where all data is organized and grouped in relation.
Purpose and benefits of using the relational model for database management:
- Data Structure using tables, rows, and columns, foreign key relations.
- Data manipulation with SQL power to modify and retrieve data.
- Data integrity mechanisms for business rules maintaining data integrity.
Another topic in IT that is intriguing and important to grasp the idea is the Business Intelligence process. Business Intelligence is vital to understand because it helps process valuable information to the users. Business Intelligence process includes:
- Acquiring data by obtaining the data, cleansing it, so it is relevant. Organizing and relating the data so it can be cataloged.
- Then perform analysis with data mining and reporting.
- Finally, publishing the results on web servers, automation, and printing.
Where does the Business Intelligence System retrieve the data from raw:
- Operational databases
- Social data
- Purchased Data
- Employee Knowledge over time
