What is a Database? What are the Types and Components of it ?
Data is information and to organize this data, you require a Database. This article on What is a Database will help you understand the definition, the different types, their advantages…
TOP 25 Advanced SQL Interview Questions And Answers
Top 25 SQL Interview Questions You Must Prepare
Q1. What are the different subsets of SQL? Data Definition Language (DDL) – It allows you to perform various operations on the database such as CREATE, ALTER, and DELETE objects.…
What are Looker Blocks?
Looker Blocks are building blocks--pre-built pieces of code that you can leverage to accelerate your analytics. From optimized SQL patterns to fully built-out data models, custom visualizations to weather and demographic…
Heap in Looker?
Heap automatically captures every user behavior across websites and applications - clicks, taps, gestures, form submissions, page views, field changes etc. - and allows you to enrich your data with…
How do I add a derived table to explore Looker?
Derived Tables in Looker: A Guide to Creating Custom Views and Reports
Derived tables in Looker, a derived table is a query whose results are used as if it were an actual table in the database. For example, you might have a database…
How to set conditional formatting in LOOKER?
Looker supports conditional formatting in visualizations in several different ways: With the html LookML parameter. This is ideal for formatting values when the conditions that drive the formatting are consistent across analysis…
How to Convert Case statement, Filter from T-SQL query to DAX
CapIDFinal:= SWITCH(TRUE(), AND(CONDITION_1_1, CONDITION_1_2), "Value if condition 1 is true", AND(CONDITION_2_1, CONDITION_2_2), "Value if condition 2 is true", "Value if none of above conditions is true )
DAX Expression – How to determine Shift in “Shift” column based on Time in “Time” Column
Case statement CASEWHEN CONVERT(VARCHAR(8), datetime, 108) BETWEEN'07:00:00' AND '14:59:00' THEN 'Day'WHEN CONVERT(VARCHAR(8), datetime, 108) BETWEEN'15:00:00' AND '22:59:00' THEN 'Evening'ELSE 'Night'END AS ShiftName You can also use Switch statement WorkShift =…