69 Tiger analytics Interview Questions and Answers

20 common asked question in every interview

Data Analytics

Ques:- What are some common data analysis tools and software

Asked In :- Vinove Software & Services Pvt Ltd, Hidden Brains InfoTech, Ziffity Solutions, STIC SOFT E-SOLUTIONS, Born Commerce, TNQ Technologies, MatchMove India, Sun Dew Solutions, Cloud Kinetics Technology Solutions, Recodem,

Right Answer:
Some common data analysis tools and software include:

1. Microsoft Excel
2. R
3. Python (with libraries like Pandas and NumPy)
4. SQL
5. Tableau
6. Power BI
7. SAS
8. SPSS
9. Google Analytics
10. Apache Spark

Data Analytics

Ques:- What is data analysis and why is it important

Asked In :- Unyscape Infocom Pvt. Ltd., WSNE Consulting, AnAr Solutions, Netaxis IT Solutions (p), Rock Solid Solutions, Ziffity Solutions, Chegg India, Aranca (Mumbai), Indocosmo Systems, Fortunesoft IT Innovations,

Right Answer:
Data analysis is the process of inspecting, cleaning, and modeling data to discover useful information, draw conclusions, and support decision-making. It is important because it helps organizations make informed decisions, identify trends, improve efficiency, and solve problems based on data-driven insights.

Data Analytics

Ques:- What is the difference between supervised and unsupervised learning

Asked In :- Medvarsity Online, KRIOS Info Solutions, AnAr Solutions, Netaxis IT Solutions (p), MattsenKumar Services, Shipco IT, Chegg India, Indocosmo Systems, Born Commerce, Cybage Software,

Right Answer:
Supervised learning uses labeled data to train models, meaning the output is known, while unsupervised learning uses unlabeled data, where the model tries to find patterns or groupings without predefined outcomes.

Data Analytics

Ques:- What is a pivot table and how do you use it in Excel or other tools

Asked In :- Xoriant Solutions Pvt Ltd, Fluid AI, Hidden Brains InfoTech, WSNE Consulting, Netaxis IT Solutions (p), MattsenKumar Services, Protege Solutions, Trigent Software, iROID Technologies, TRICON INFOTECH PVT,

Right Answer:
A pivot table is a data processing tool that summarizes and analyzes data in a spreadsheet, like Excel. You use it by selecting your data range, then inserting a pivot table, and dragging fields into rows, columns, values, and filters to organize and summarize the data as needed.

Data Analytics

Ques:- What are outliers and how do you handle them in data analysis

Asked In :- Fluid AI, Trigent Software, Itobuz Technologies, RANDSTAD INDIA PVT, GOQii Technologies, Dhruvsoft Services, Radicle Software, Webvillee Technology, Fission Infotech, Noesys Consulting,

Right Answer:
Outliers are data points that significantly differ from the rest of the dataset. They can skew results and affect statistical analyses. To handle outliers, you can:

1. Identify them using methods like the IQR (Interquartile Range) or Z-scores.
2. Remove them if they are errors or irrelevant.
3. Transform them using techniques like log transformation.
4. Use robust statistical methods that are less affected by outliers.
5. Analyze them separately if they provide valuable insights.

Big Data

Ques:- Compare Hive and Pig in the context of Big Data.

Asked In :- Hidden Brains InfoTech, ISC Software, CAFS, WFP, CDAC Thiruvananthapuram, Softserve Global, A Wabtec Company, transunion, eleks, national payments corporation of india (npci),

Big Data

Ques:- What are the main components of the Hadoop ecosystem?

Asked In :- CropIn Technology Solutions, 63 moons technologies, Data Patterns, SAS Institute, Sigmoid Analytics, Datagrokr, Metrics4 Analytics, Profound Edutech, Opencast Software, Spire Global,

Big Data

Ques:- What is MapReduce? Explain its working mechanism.

Asked In :- Hidden Brains InfoTech, DecisionTree Analytics and Services, ISC Software, Solix Technologies, Inc, Estuate, WFP, Talencia LLC, Sigmoid Analytics, SRDT, Profound Edutech,

Big Data

Ques:- What are the challenges of Big Data security and privacy?

Asked In :- Hidden Brains InfoTech, DecisionTree Analytics and Services, Blackcoffer, Indium Software, Data Patterns, Wingify Software, Prodapt SA, Sigmoid Analytics, Deep Compute, Algoscale,

Big Data

Ques:- What is real-time data processing and which tools support it?

Asked In :- CropIn Technology Solutions, 63 moons technologies, ISC Software, Blackcoffer, Wingify Software, FACTENTRY DATA SOLUTIONS, PromptCloud, ColorTokens, CDAC Thiruvananthapuram, Carbon Black,

Django Python

Ques:- How do you count the occurrences of each item present in the list without explicitly mentioning them ?

Asked In :- E2E Research, Zentron Labs, Twilio, WAEC, Posist Technologies, Addverb Technologies, capillary technologies, zaloni, tiger analytics, ntp,

Right Answer:
You can use the `collections.Counter` class to count the occurrences of each item in a list. Here's how you can do it:

```python
from collections import Counter

my_list = ['apple', 'banana', 'apple', 'orange', 'banana', 'apple']
count = Counter(my_list)
print(count)
```

Python

Ques:- What Is The Return Value Of The Trunc() Function?

Asked In :- Milliman India, STUP Consultants, New Wave Computing, Fusion Analytics, NAVYA, Cittabase Solutions, zscaler, lightspeed hq, arcesium, pipedrive,

Comments

Admin Feb 2, 2020

The Python trunc() work plays out mathematical operations to expel the decimal qualities from a particular expression and gives integer value as the output.

Django Python

Ques:- Types of Authentication in REST API ?

Asked In :- XT Global, Nuware Systems, Codingmart Technologies, iLenSys, Algoscale, factset, delta technology, stfc, first derivatives, phenom people,

Right Answer:
1. Basic Authentication
2. Token-Based Authentication
3. OAuth (1.0 and 2.0)
4. API Key Authentication
5. Session-Based Authentication
6. JWT (JSON Web Token) Authentication

Python

Ques:- How are “is”, “not” and “in” operators used?

Asked In :- First Zen, CodeCraft Technologies, Redisolve, Extentia, CloudKaptan, Rubicon Research, Incubit, Ergo Group, ConveGenius, RCKR Software,

Python

Ques:- Given a text file (FILE1) with lots of words (ex, an ebook), and another file (FILE2) with a list of blacklist words (slangs, porn, etc.), write a program to find the top 100 words(most frequent 100 words) from FILE1 which are not present in FILE2.

Asked In :- Bristlecone India, Tessolve, J K Technosoft, Decision Minds India, Systenics Solutions, CloudThat, Focus Organisation (India ), DigiQ Solutions, TriGeo Technologies, asml,

Comments

Admin May 17, 2020

Steps to solve this.
1. open FILE1 in read mode
2. read content by using read()
3 split content by using
so that you can get lines
4 split lines by split(' ') so that you can get words
5 repeat above 4 lines with file FILE2
6 iterate words list and create dictionary word and frequency as key values.
skip the value if it is found in file2 key words.
7 sort dict by using x= list(sorted(wordsarr.items(),wordsarr.get, reverse=true)
so that we can get sorted dict in desc order.
8 return top 100 words by using print(x[:101])

SQL Server

Ques:- What is BCP? When do we use it?

Asked In :- Rudder Analytics, UIDAI, Microverse Automation, Fare Labs, Consultants Factory, Method CRM, TekFriday Processing Solutions, QX GLOBAL SERVICES LLP, Quantiphi, First Insight,

Project Leader/ Project Manager SQL Server

Ques:- Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.

Asked In :- CBRE South Asia, Techwave Consulting Inc, SSA, Streebo Solutions, DCM Shriram, Iprimed Education Solutions, Advantage Club, MindBowser Info Solutions, Vontobel, HiLabs,

Right Answer:
No, you cannot create a single trigger that directly responds to events on two different tables in SQL Server. You need to create separate triggers for each table. Here’s an example of how to create triggers for both the `employee` and `department` tables:

For the `employee` table:
```sql
CREATE TRIGGER trg_employee
ON employee
AFTER INSERT, UPDATE
AS
BEGIN
-- Trigger logic for employee table
END
```

For the `department` table:
```sql
CREATE TRIGGER trg_department
ON department
AFTER INSERT, UPDATE
AS
BEGIN
-- Trigger logic for department table
END
```

Database Administrator (dba) SQL Server

Ques:- A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

Asked In :- MaxVal-IP Services, Attra Infotech, AJIO, Amagi Media, HLS Asia, Galaxy Weblinks, UTS Consultants, Pickrr Technologies, Braves Technologies, Intello Labs,

SQL Server

Ques:- From where can you change the default port?

Asked In :- Sysfore Technologies, Cloud Assert, GOMO Group AB, Amtex Software Solutions, Attra Infotech, Mind Infotech, SSA, Siemens Healthineers, Iprimed Education Solutions, 3clogic,

Database Architect/ Designer SQL Server

Ques:- What is joins?What is the use?Where it is use?

Asked In :- Shipmnts, Verticurl Marketing, Nova Solutions, Siyana Info Solutions, Tayana Software Solutions, Productsup, Softpal, Pivox Labs, Expenzing, Zorang,

Right Answer:
A join is a SQL operation that combines rows from two or more tables based on a related column between them. Joins are used to retrieve data that is spread across multiple tables, allowing for more complex queries and data analysis. They are commonly used in database queries to gather related information, such as combining customer and order data.

Previous Next

Tiger Analytics is a premier data science and analytics consulting firm, dedicated to helping businesses harness the power of data to drive innovation, optimize operations, and achieve strategic objectives. With a focus on advanced analytics, machine learning, and artificial intelligence, Tiger Analytics offers a wide range of services and solutions that enable organizations to unlock the full potential of their data assets. At Tiger Analytics, we understand that data is the cornerstone of modern business success. That\'s why we employ a team of highly skilled professionals who are experts in data science, statistics, and engineering. Our dedicated team works closely with clients to understand their unique challenges and objectives, ensuring that our solutions are tailored to meet their specific needs and deliver tangible results. One of the key strengths of Tiger Analytics lies in our commitment to innovation and continuous improvement. We leverage cutting-edge technologies and methodologies to develop advanced analytics solutions that drive value for our clients. From predictive modeling and optimization to data visualization and insights generation, we provide end-to-end solutions that empower organizations to make data-driven decisions with confidence.

Find Interview Questions for Tiger analytics

What makes Takluu valuable for interview preparation?

Get Our Mobile App

Programming

Reasoning

Network & Telecom

Management

What makes Takluu valuable for interview preparation?