.
Applying for the Position of
This field is required.
Not a valid answer
Full Name
This question is required
Invalid Entry: Please Enter Only Characters
Email
This question is required
Please enter valid email address
Phone
This question is required
Invalid Format (Minimum 5, Maximum 20 digits)
Age
This question is required
Invalid Entry: Please Enter Only Numbers
City and Country
This question is required
Invalid Entry: Please Enter Only Characters
What is your current in-hand salary? Please enter the Monthly amount.
This field is required.
Invalid Entry: Please Enter Only Numbers
What is your expected in-hand salary? Please enter the Monthly amount.
This question is required
Invalid Entry: Please Enter Only Numbers
Do you have your system to connect & work remotely on the office system?
This question is required
Not a valid answer
Please mention the speed of your internet connection [In Mbps].
This question is required
Invalid Entry: Please Enter Only Numbers
Are you legally authorized to work in India?
This question is required
Not a valid answer
Have you completed the following level of education: Bachelor's Degree?
This question is required
Not a valid answer
What is your notice period [in days]?
This question is required
Invalid Entry: Please Enter Only Numbers
What is your level of proficiency in English?
This question is required
Not a valid answer
Why do you want to quit your Current Organization?
Shift + Enter for line break
This question is required
Not a valid answer
Responsibilities handled by you in existing org, if not mentioned in CV
Shift + Enter for line break
This question is required
Not a valid answer
How many years of experience do you have as a Data Analyst?
This question is required
Not a valid answer
Do you have work experience in Python (Programming Language)? If yes, then how many years?
This question is required
Not a valid answer
How many years of experience do you have in Power BI?
This question is required
Not a valid answer
Which sectors did you make your dashboards for (e.g., finance, marketing, supply chain, internal management)?
Shift + Enter for line break
This question is required
Not a valid answer
Have you interacted directly with clients in your earlier roles ?
Shift + Enter for line break
This question is required
Not a valid answer
Upload your Resume here.
Maximum file size: 10MB
Uploaded
only in pdf format.
Not a valid answer
What function in Pandas is used to read a CSV file into a DataFrame?
  • A read_csv()
  • B csv_reader()
  • C pd.read_csv()
  • D load_csv()
This question is required
Not a valid answer
To replace all NaN values in a DataFrame 'df' with 0, which method is used?
  • A df.fillna(0)
  • B df.replaceNaN(0)
  • C df.NaNtoZero()
  • D df.setZero()
This question is required
Not a valid answer
In Pandas, how do you select the rows where the column 'Age' is greater than 30?
  • A df['Age'] > 30
  • B df[df['Age'] > 30]
  • C df.query('Age > 30')
  • D All of the above
This question is required
Not a valid answer
To group a DataFrame 'df' by 'Category' and calculate the mean of 'Sales', which code is correct?
  • A df.groupby('Category').mean('Sales')
  • B df['Sales'].groupby(df['Category']).mean()
  • C df.groupby('Category')['Sales'].mean()
  • D df.mean('Sales').groupby('Category')
This question is required
Not a valid answer
What is the method to pivot a data frame, transforming unique values from one column into multiple columns?
  • A pivot_table()
  • B pivot()
  • C unstack()
  • D Both a) and b)
This question is required
Not a valid answer
What is the purpose of the "Query Dependencies" view in Power Query?
  • A It displays the flow of query dependencies and their dependencies
  • B It shows the relationships between tables in the data model.
  • C It displays a list of available data sources.
  • D It shows a graphical representation of data in the report.
This question is required
Not a valid answer
To group rows and perform an aggregate operation in Power Query, which option is used?
  • A Group By
  • B Aggregate Rows
  • C Summarize Data
  • D Collect & Summarize
This question is required
Not a valid answer
Which option allows you to create a calculated column in Power Query?
  • A Custom Column
  • B Add Column
  • C Transform Column
  • D New Column with Expression
This question is required
Not a valid answer
Which option is employed to renew data in Power Query?
  • A Refresh Data
  • B Update Data
  • C Reload
  • D Renew Data
This question is required
Not a valid answer
To extract the first 100 rows from a dataset in Power Query, which option should you use?
  • A First 100 Rows
  • B Top 100 Rows
  • C Select First 100
  • D Limit to 100 Rows
This question is required
Not a valid answer
Which language is used to create macros in excel?
  • A C++
  • B Python
  • C Visual Basic
  • D Java
This question is required
Not a valid answer
Which of the following keyboard shortcut can be used for creating a 'Chart' from the selected cells ?
  • A F2
  • B F10
  • C F11
  • D F3
This question is required
Not a valid answer
Assuming cell A1 is displaying the number "12000.7789". What formula should be used to round this number to the closest integer?
  • A =MROUND(A1,100)
  • B =MROUND(A1,10)
  • C =ROUND(A1,1)
  • D =ROUND(A1,0)
This question is required
Not a valid answer
How can you view and delete macros that have been created in a worksheet?
  • A All of the options listed above are correct.
  • B Press Alt+F11. Click on Tools and select Macros. Select the macro to delete and click delete.
  • C Press Alt+F8, select the macro to be deleted and click delete.
  • D Under the Developer tab, click on the Macros button in the Code group. Select the macro to delete and click delete.
This question is required
Not a valid answer
Using the following string of characters, DLM343456B82, which formula will extract 343456? The data is located in cell B2
  • A =Mid(B2,3,6)
  • B =Right(B2,4,6)
  • C =Mid (B3,3,6)
  • D =Mid (B2,4,6)
This question is required
Not a valid answer

Thank you for your submission. {{}}

0% Completed
0% Completed