top of page
Search
Optimizing Performance in Power BI: Best Practices and Strategies
This article explores key techniques to enhance Power BI performance, covering data modeling, DAX optimization, efficient visuals, and...
Gowtham V
Feb 20, 20254 min read
Co-Pilot for Power BI Desktop (Developers) and Power BI Service (End Users)
Co-Pilot is an AI-powered assistant integrated into Microsoft products, including Power BI, to enhance user experience by enabling...
Gowtham V
Feb 1, 20254 min read
Navigating Specialized Date Computations in Power BI & Tableau.
In the dynamic field of data analytics, mastering the subtleties of date calculations is a crucial skill that can enhance the insights...
Gowtham V
Feb 11, 20242 min read
Hypothesis Testing
Hypothesis testing ascertains whether a particular assumption is true for the whole population. It is a statistical tool. It determines...
Gowtham V
Sep 13, 20234 min read
Power BI For Tableau Developers.
In this article, I explained, how a Tableau Developer can leverage existing Tableau skills to create power data driven calculations,...
Gowtham V
Sep 4, 20232 min read
How to handle filters while performing sheet swapping In Tableau, (2 Difference Data Sources).
Scenario - Consider we have 3 different years of sales data sources each of them are not related to one another. And we wanted to show...
Gowtham V
Feb 17, 20232 min read
Introduction To SQL
Basic Concepts - Data, Table, Databases. What is data? Data are pieces of information that are gathered and used for some specific...
Gowtham V
Jan 26, 20239 min read
Tableau (Fixed - Include - Exclude) & DAX in Power BI - Concepts
LOD - (Definition) "Level of detail expressions (Also known as LOD expressions) allows you to compute values at the data source level and...
Gowtham V
Jan 5, 20239 min read
Random Numbers and Probability
In this chapter, you'll learn how to generate random samples and measure chance using probability. You'll work with real-world sales data...
Gowtham V
Nov 2, 20223 min read
SQL Interview Questions
1. What is normalization? Ans : Normalization is a database design technique to remove redundant data. 2. How to Implement normalization?...
Gowtham V
Oct 25, 20226 min read
CTE & Recursive CTE
CTE : Common table expression. A CTE is a temporary result set, that can be referenced within a SELECT, INSERT, UPDATE, or DELETE...
Gowtham V
Oct 2, 20223 min read
SQL Query Order of Execution
Definition : The SQL order of execution defines the order in which the clauses of a query are evaluated. Understanding query order can...
Gowtham V
Sep 27, 20223 min read
Pricing Analytics (Reporting & Insights)
Pricing analytics are the metrics and associated tools used to understand how pricing activities affect the overall business, analyze the...
Gowtham V
Aug 7, 20221 min read
Tableau & Power BI - Concepts
Data Visualization is the representation and presentation of data that exploits our visual perception abilities on order to amplify...
Gowtham V
Jun 28, 202215 min read
Writing Complicated Tableau Calculations.
Writing calculated fields can be really difficult, especially when the logic is complex or there are multiple layers. In Tableau, I’ve...
Gowtham V
Jun 26, 20222 min read
SRS Data: India’s Life Expectancy
Recently (SRS) sample registration system has released the data of Indian's Life's expectancy report for the period of 2015-19. Based on...
Gowtham V
Jun 16, 20222 min read
SQL - Intermediate to Complex Queries
Q1. From the weather table, fetch all the records when London had extremely cold temperature for 3 consecutive days or more. Approach :...
Gowtham V
Jun 4, 20227 min read
SQL - Basics
SQL is a standard language for storing, manipulating and retrieving data in databases. What is SQL? SQL stands for Structured Query...
Gowtham V
Jun 4, 20229 min read
SQL Analytical Functions
Analytical functions are one of the most popular tools among BI/Data Analysts for performing complex data analysis. These functions...
Gowtham V
Jun 4, 20227 min read
Risk Stock Management - Fresh Products
In this article, I'm going to explain how to visualize the risk stock management details on higher level with the help of Waffle chart....
Gowtham V
Jun 4, 20221 min read
bottom of page