Dinesh's Blog :::: Being Compiled ::::

Normalization is a process of identifying the optimal grouping (relations at the end) for attributes that satisfies data requirements in a...

Microsoft Power BI supports adding parameters for queries and use them with various areas. However, since it has some limitations and cann...

I wrote a post on Relational Algebra that discusses most of operations related to it. This is the continuation of it and this explains Jo...

Power BI Desktop allows us to import data from files such as CSV and Excel . Once imported, it automatically creates a Model  that can be ...

Power BI allows us to add shapes like rectangle or oval  for marking specific area, showing covered visuals as they are related and operat...

How do you name columns returned from your created view? Generally, you do not need to explicitly name them as the names of view-columns  ...

Everyone has either used or created  views for getting or creating a dynamic result using one or multiple tables. And everyone knows the u...

Creating a report with stunning, meaningful and appropriate visuals is the key for delivering the information quickly, hence special consi...

Let's talk about another Interview Question  related to SQL Server development. This is about one of the aggregate functions that is A...

Have you experienced that Power BI just connects with your SQL Server without requesting your login credentials? Or you might need to conn...

I experienced a strange issue with Power BI today, I might have missed something or there is something unknown to me. This is what I exper...

Few days back, I wrote an article on SQL Server default behavior when it expands files with AutoGrowth enabled. Where there are multiple f...

As per the announcement made by Microsoft on Power BI early this month,  Following things will be changed on Power BI Free account; ...

When the relational model was introduced, in order to work with the model or in order to retrieve or update data in the model, languages w...