Tableau Interview Questions Set - 4 Released
Intermediate Level Can we see SQL generated by Tableau Desktop? Tableau Desktop Log files are placed in C: UsersMy DocumentsMy Tableau Repository. In case of live connection to any data source, check the log file “log.txt” and “tabprotosrv.txt” files. In case of extract connection to...
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...
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...
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,...
Power BI Interview Question Set - 1 Released
1. What is Power BI? Power BI is a business analytics tool developed by Microsoft that helps you turn multiple unrelated data sources into valuable and interactive insights. These data may be in the form of an Excel spreadsheet or cloud-based/on-premises hybrid data warehouses. You...
Introduction to PandasAI Part 1
Introduction: Currently, we spend a lot of time editing, cleaning, and analyzing data using various methodologies. Pandas is a popular Python library through which we can do the data manipulation. Data Manipulation using Python means — It keeps the data in a structured format that...