Technical Interview Questions
A measure of the dispersion of data that is shown in a box plot is referred to as the interquartile range. It is the difference between the upper and the lower quartile. As a data analyst, the interquartile range (IQR) is a fundamental statistical concept that measures the spread or dispersion of a dataset. It’s … Read more
The developed model should have predictable performance. A good data model can adapt easily to any changes in business requirements. Any major data changes in a good data model should be scalable. A good data model is one that can be easily consumed for actionable results. The criteria for determining whether a developed data model … Read more
A model does not hold any value if it cannot produce actionable results, an experienced data analyst will have a varying strategy based on the type of data being analysed. For example, if a customer complain was retweeted then should that data be included or not. Also, any sensitive data of the customer needs to … Read more
Data Validation is performed in 2 different steps- Data Screening – In this step various algorithms are used to screen the entire data to find any erroneous or questionable values. Such values need to be examined and should be handled. Data Verification- In this step each suspect value is evaluated on case by case basis … Read more
Having a poor formatted data file. For instance, having CSV data with un-escaped newlines and commas in columns. Having inconsistent and incomplete data can be frustrating. Common Misspelling and Duplicate entries are a common data quality problem that most of the data analysts face. Having different value representations and misclassified data. Data analysts encounter various … Read more