Find Interview Questions for Looker

Right Answer:
Kanban focuses on visualizing workflow, limiting work in progress (WIP), and continuous flow. Scrum uses time-boxed iterations (sprints) with specific roles (Scrum Master, Product Owner, Development Team) and events (sprint planning, daily scrum, sprint review, sprint retrospective).

Use Kanban when you need continuous delivery, have evolving priorities, and want to improve workflow incrementally. Use Scrum when you need structured development with fixed-length iterations, have clear goals for each iteration, and benefit from team collaboration with defined roles.

Right Answer:
"In one project, we underestimated the complexity of integrating a new third-party API. This caused us to miss our sprint goal. To address this, we immediately re-estimated the remaining work, broke down the integration into smaller, more manageable tasks, and increased communication with the API vendor. We also temporarily shifted team focus to prioritize the integration, delaying a lower-priority feature for the next sprint. Finally, in the sprint retrospective, we implemented a better vetting process for third-party integrations to avoid similar issues in the future."

Right Answer:
The Agile Manifesto values:

* **Individuals and interactions** over processes and tools.
* **Working software** over comprehensive documentation.
* **Customer collaboration** over contract negotiation.
* **Responding to change** over following a plan.

That is, while the items on the right have value, we value the items on the left more.

Right Answer:
The Scrum Master is a servant-leader who helps the Scrum Team follow the Scrum framework. They facilitate Scrum events (Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective), remove impediments, protect the team from distractions, and coach the team on Agile principles and practices.

Right Answer:
* **Epic:** A large, high-level user story that is too big to complete in a single iteration. It's usually broken down into smaller user stories.
* **User Story:** A small, self-contained requirement that represents a valuable piece of functionality for the end-user. It follows the format: "As a [user type], I want [goal] so that [benefit]".
* **Task:** A small, actionable item that needs to be done to complete a user story. It's a technical breakdown of the work required by the development team.

Right Answer:
Yes, banks face significant challenges from money laundering when attracting deposits. Money laundering can lead to reputational damage, regulatory penalties, and financial losses. Banks must implement strict compliance measures and due diligence processes to detect and prevent illicit activities, which can complicate their efforts to attract legitimate deposits.

Right Answer:
The fields used for Project Planning in MS Project include:

1. Task Name
2. Duration
3. Start Date
4. Finish Date
5. Predecessors
6. Resources
7. Percent Complete
8. Work
9. Cost
10. Milestones

Right Answer:
To depict dependency in MS Project, you can link tasks by selecting the tasks you want to connect, then clicking on the "Link Tasks" button in the toolbar or using the shortcut Ctrl + F2. This creates a finish-to-start dependency by default. You can also adjust the type of dependency (finish-to-start, start-to-start, finish-to-finish, or start-to-finish) by double-clicking on the task and modifying the "Predecessors" tab.

Right Answer:
MS Project is used for project management to plan, schedule, and track project progress, allocate resources, manage budgets, and analyze workloads.

Right Answer:
Could you please specify the exact question related to databases?

Right Answer:
My personality is driven by curiosity and a desire to learn, which aligns well with my qualifications. I am adaptable and enjoy collaborating with others, allowing me to effectively apply my knowledge in various situations. My strong communication skills help me share ideas clearly and work well in teams, enhancing my ability to contribute positively in a professional environment.

Right Answer:
I prefer to work in the private sector because I value the opportunities for innovation, career growth, and a dynamic work environment that it offers.

Right Answer:
Beams are structural elements that support loads and span between supports, typically used in buildings and bridges. Panels refer to flat sections of materials, often used in walls or ceilings, that can provide structural support or aesthetic finishes. Experience in this context usually refers to practical knowledge and skills gained through working on projects involving beams and panels.

Right Answer:
A. 101

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

Right Answer:
Regression analysis is a statistical method used to examine the relationship between one dependent variable and one or more independent variables. It is used to predict outcomes, identify trends, and understand the strength of relationships in data.

Right Answer:
To handle missing data in a dataset, you can use the following methods:

1. **Remove Rows/Columns**: Delete rows or columns with missing values if they are not significant.
2. **Imputation**: Fill in missing values using techniques like mean, median, mode, or more advanced methods like KNN or regression.
3. **Flagging**: Create a new column to indicate missing values for analysis.
4. **Predictive Modeling**: Use algorithms to predict and fill in missing values based on other data.
5. **Leave as Is**: In some cases, you may choose to leave missing values if they are meaningful for analysis.

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.

Right Answer:
Data normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. It involves structuring the data into tables and defining relationships between them. Normalization is important because it helps eliminate duplicate data, ensures data consistency, and makes it easier to maintain and update the database.