SQL - SELECT Statement “Select” introduction: The SELECT statement is used to retrieve the data from the database tables. We can get all the data or only some part of the data. We can also perform specific operations like filtering and aggregation on the data using the SELECT statement. Syntax: SELE...
Tableau Introduction Introduction In this article, we are going to learn about Tableau. There are many Visualization tools available in the market such as PowerBI, QlikView, Dundas BI, etc. But what makes Tableau stand out is the wide range of data connectivity from Flat files, excel to MSSQL, Impal...
Snowflake - Switching consoles between Snowsight UI and Classic console Snowsight UI Snowflake's Snowsight offers an improved user experience in terms of writing and executing SQL queries. Snowsight is the new UI launched recently by Snowflake. A lot of users are confused and complained as to how to...
Power BI – SUM vs SUMX Introduction: Let us have a quick and detailed understanding of the difference between SUM and SUMX DAX functions in Power BI. Here I have considered the Bike Data where we have the Unit Price Details and Order Quantity details but the Sales value column is not part of the dat...
Creating a Date table in Power BI In this article, we will generate a date table in Power BI which will be a reference point for data models that can be used for time intelligence calculations. Creating a date table is very easy with DAX functions. A date table is essential in creating data models. ...