AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
GWC Logistics Data Analyst Interview Questions, Process, and Tips
GWC Logistics Data Analyst Interview Experiences
1 interview found
Sidhesh 24
(4 Questions)
- Q1. Tell me about urself
- Q2. Drop vs truncate
- Ans.
Drop deletes all rows from a table, while truncate removes all rows and resets auto-increment values.
Drop is a DDL command, while truncate is a DML command.
Drop is slower as it logs individual row deletions, while truncate is faster as it deallocates data pages.
Drop can be rolled back, while truncate cannot be rolled back.
Example: DROP TABLE table_name; TRUNCATE TABLE table_name;
- Q3. What is dax function?
- Ans.
DAX (Data Analysis Expressions) is a collection of functions, operators, and constants that can be used in Power BI, Excel, and other data analysis tools.
DAX functions are used to create custom calculations in Power BI and Excel.
DAX functions can be used for tasks like filtering, aggregating, and manipulating data.
Examples of DAX functions include SUM, AVERAGE, CALCULATE, and RELATED.
- Q4. What is data modelling?
- Ans.
Data modelling is the process of creating a visual representation of data relationships and patterns.
Data modelling involves identifying and defining the relationships between different data elements.
It helps in organizing and structuring data in a way that is easy to understand and analyze.
Common techniques used in data modelling include entity-relationship diagrams, UML diagrams, and data flow diagrams.
Data modelling...
(3 Questions)
- Q1. Why we go for power bi instead of excel
- Ans.
Power BI offers more advanced data visualization and analysis capabilities compared to Excel.
Power BI allows for interactive and dynamic data visualization, making it easier to identify trends and patterns.
Power BI can handle larger datasets more efficiently than Excel.
Power BI offers more advanced data modeling and transformation capabilities.
Power BI allows for easy sharing and collaboration on reports and dashboards...
- Q2. What is parameter in power bi?
- Ans.
Parameters in Power BI are values that can be passed to queries, filters, or functions to customize data analysis.
Parameters can be used to filter data based on specific criteria.
They can also be used to dynamically change calculations or visualizations.
Parameters can be defined in Power Query Editor or in DAX formulas.
Examples include using parameters to filter data by date range or product category.
- Q3. Types of data connectivity mode?
- Ans.
Types of data connectivity modes include direct, gateway, and hybrid connections.
Direct connectivity mode involves connecting directly to the data source without any intermediary
Gateway connectivity mode uses a gateway to securely connect to on-premises data sources from cloud services
Hybrid connectivity mode combines elements of both direct and gateway connections for flexibility and security
Skills evaluated in this interview
Interview questions from similar companies
Anonymous
Selected
I applied via Recruitment Consulltant and was interviewed before Feb 2023. There were 3 interview rounds.
Talk to the head hunter. General phone screening
(1 Question)
- Q1. Talk to the hiring manager and another manager from BI. Asked about work experience and gave me a SQL test
Shared a dataset and wanted me to provide some insights and also build some slides to present
Interview Preparation Tips
I applied via Walk-in and was interviewed in Sep 2024. There was 1 interview round.
First round was aptitude test,duration is of 25 minutes involves SQL,PowerBI,Python, Qunatitative Aptitude,SAS skillset
Interview Questionnaire
1 Question
- Q1. What is the mean of DHL. ( full form).
- Ans.
DHL stands for Dalsey, Hillblom, and Lynn, the surnames of the founders. It is a global logistics company.
DHL is a multinational courier, parcel, and express mail service.
It was founded in 1969 by Adrian Dalsey, Larry Hillblom, and Robert Lynn.
DHL provides services for shipping, tracking, and delivering packages worldwide.
The mean of DHL refers to the average or central tendency of the company's operations, such as rev...
Selected
I applied via Naukri.com and was interviewed before Jan 2023. There was 1 interview round.
(1 Question)
- Q1. Highlight min & Max sales for each year in tableau.
- Ans.
Use Tableau to highlight the minimum and maximum sales for each year.
Create a new worksheet in Tableau
Drag the 'Year' field to the Columns shelf
Drag the 'Sales' field to the Rows shelf
Drag the 'Sales' field again to the Color shelf
Right-click on the 'Sales' field in the Color shelf and select 'Measure' > 'Min'
Right-click on the 'Sales' field in the Color shelf again and select 'Measure' > 'Max'
Format the visualization
Skills evaluated in this interview
Interview Questionnaire
2 Questions
- Q1. Safety related questions were asked..
- Q2. U must have full knowledge of axcel.
I applied via Naukri.com and was interviewed in Jan 2024. There were 2 interview rounds.
Python, SQL, Aptitude
(3 Questions)
- Q1. SQL - A table EmployeeSkills was given having two columns EmpID & Skills. There can be multiple for an employee id with skills he possess. You need to find the EmpID having skills in Python and SQL
- Q2. PowerBI - Create Bookmarks in Power BI
- Ans.
Bookmarks in Power BI allow users to save the state of a report, including filters, slicers, and visuals.
Bookmarks can be created by selecting 'View' and then 'Bookmarks' in the Power BI toolbar.
Users can add bookmarks by selecting 'Add' and then naming the bookmark.
Bookmarks can be applied by selecting the desired bookmark from the 'Bookmarks' pane.
Bookmarks can be used to save different views of a report for easy acc
- Q3. SQL - Find cumulative Profit sum in a given table.
- Ans.
Use SQL query with window function to find cumulative profit sum in a given table.
Use window function like SUM() with ORDER BY clause to calculate cumulative profit sum.
Example: SELECT date, profit, SUM(profit) OVER (ORDER BY date) AS cumulative_profit FROM table_name;
Ensure the table has a column for date and profit to order and calculate cumulative sum.
hrishikesh angane
SQL, Python and Power BI
Selected
I applied via Referral and was interviewed before Apr 2023. There was 1 interview round.
(1 Question)
- Q1. Detailed questions on probability. Statistical questions.
Selected
I applied via Company Website and was interviewed before Dec 2023. There were 3 interview rounds.
SQL, Python Coding & MCQ test
Behavioural questions mostly, they tey ro find approach.
(2 Questions)
- Q1. Salary negotiations
- Q2. Location preference
GWC Logistics Interview FAQs
Tell us how to improve this page.
GWC Logistics Interviews By Designations
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
GWC Logistics Data Analyst Interview Process
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
|
Team Lead
6
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Customer Service Officer
6
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Warehouse Assistant
6
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Analyst
5
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Operations Officer
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Agility
DHL Supply Chain
Maersk Line
DB Schenker
- Home >
- Interviews >
- GWC Logistics Interview Questions >
- GWC Logistics Data Analyst Interview Questions
