Tableau Interview Questions Set - 3 Released
Intermediate Level Differentiate parameters and filters in Tableau Filters are the simpler and straightforward feature in Tableau. It applies to dimensions or measures directly. For example, to only show Gujarat or Karnataka in a State dimension, we can apply the filter on that. In Tableau,...
Tableau Interview Questions Set - 2 Released
Intermediate Level What is Mark Card in Tableau? There is a card to the left of the view where we can drag fields and control mark properties like color, size, type, shape, detail, label, and tooltip. Define published data source? When you are ready to...
Tableau Interview Questions Set - 1 Released
Intermediate Level What is TABLEAU? Tableau is the powerful and fastest visualizing tool that is used in the Business Intelligence(BI) Industry. It simplifies the raw data into an understandable format. Analysis of the data becomes faster with Tableau. The visualizations can be created in the...
SQL Interview Question Set - 5 Released
Intermediate Level How do I count the number of records in a MySQL query? select count(*) from TABLE_NAME where 'status' = 1; What is heap table in MySQL? HEAP tables are in memory. No TEXT or BLOB fields are allowed inside HEAP tables. They are...
SQL Interview Question Set - 4 Released
Intermediate Level What are Storage Engines in Mysql? Storage engines are Mysql components, that can handle the operations for different table types to store and manage information in a database. • InnoDB • MyISAM • MEMORY • MERGE • EXAMPLE • CSV • ARCHIVE etc...
Python with Gemini (Gen AI) using Google Colab
Introduction Hi folks! Welcome to an another exciting blog at Gamaka AI. This article basically deals with the use of Python with Gen AI using Google Colab. The advantage of using Google Colab is that it allows you to write and execute Python code directly in your...
SQL Interview Question Set - 3 Released
Intermediate Level What are the difference between MongoDB and MySQL? MongoDB - The representation of data in MongoDB is totally different from Mysql, as in MongoDB data is represented in the collection of JSON documents. MongoDB is an object oriented database. MySQL - The representation...
SQL Interview Question Set - 2 Released
Intermediate Level Explain the difference between primary key and candidate key in Mysql? Primary Key - It is a column that uniquely identifies a record. In Mysql, only one candidate key can behave like Primary Key. Candidate Key - It can be any column that...
SQL Interview Question Set - 1 Released
Intermediate Level What is MySQL? MySQL is a multithreaded, multi-user SQL database management system which has more than 11 million installations. It is the world's second most popular and widely-used open source database. It is interesting how MySQL name was given to this query language....
Power BI Interview Question Set - 4 Released
Intermediate Level 1. Case: Sales Performance Analysis Question: You're tasked with analyzing sales performance for a retail company. How would you approach this analysis using Power BI? Solution: - Import sales data into Power BI Desktop. - Create visualizations such as sales trend over time,...
Power BI Interview Question Set - 3 Released
Intermediate Level 1. Explain the concept of incremental data refresh in Power BI and its benefits? Incremental data refresh in Power BI allows you to refresh only the new or modified data since the last refresh, rather than refreshing the entire dataset. This improves performance...
Power BI Interview Question Set - 2 Released
Intermediate Level 1. What is the role of Power Query in Power BI, and how does it facilitate data preparation? Power Query is used for data transformation and cleansing tasks within Power BI. It enables users to extract, transform, and load data from various sources,...