Category Archives: Coding&Tech

Data analytics is the process of examining data to find patterns, trends, and relationships that can be used to make informed decisions. There are several components or constituents that are typically involved in data analytics: Data: This is the raw … Continue reading →

Choosing the right technology stack for your data engineering and analytics projects can be overwhelming. From big data platforms to data visualization tools, there are countless options to consider. In this article, we’ll explore the key factors that you should … Continue reading →

Data analytics is the process of examining data to find patterns, trends, and relationships that can be used to make informed decisions. There are several components or constituents that are typically involved in data analytics: Data: This is the raw … Continue reading →

Building a data warehouse is an Iterative process. It is imperative that the data warehouse developer have the attitude of moving quickly through the steps of design and development, even though it is known that the processing and data requirements … Continue reading →

The selection of data warehouse technology – both hardware and software – depends on many factors, such as: • the volume of data to be accommodated, • the speed with which data is needed, • the history of the organization, … Continue reading →

Understand the table relationships – most will be one to many. Know the “many” table. Identify the fields required for your joins. Think about LEFT join scenarios – Select all the employees and their paycheck from last month. What if they didn’t … Continue reading →

1. Check if a table exists in the current database schema select table_name from user_tables where table_name = ‘__TABLE_NAME__’ 2. Check if a column exists in a table select column_name as found from user_tab_cols where table_name = ‘__TABLE_NAME__’ and column_name … Continue reading →

STATISTICAL ANALYSIS 1: ESTIMATION AND TESTING This main focus of this course is employing samples to make inferences about certain statistical properties of the underlying population such as means, variances and proportions. The students will learn how to construct range … Continue reading →