Posts

What is Google data Studio or Looker studio

Image
  What is Google data Studio or Looker studio- Looker Studio is now Google Data Studio .It is a tool for data visualization ,but not for data cleaning ,the data cleaning should be done out side of it. What is Google data Studio official site- https://lookerstudio.google.com How to use it- Use it for free by logging in with your gmail.  Examples- On my blog (click)

Google data studio function corresponding Azure SQL formulas

Image
                                                               Category Original Function Azure SQL Equivalent Notes Aggregation AVG(X) `AVG(X)` Aggregation COUNT(X) `COUNT(X)` or `COUNT(*)` `COUNT(X)` counts non-NULL values in column X. `COUNT(*)` counts all rows. Aggregation COUNT_DISTINCT(X) `COUNT(DISTINCT X)` Aggregation MAX(X) `MAX(X)` ...

Google Data Studio functions corresponding Power BI DAX

Image
  Category Original Function DAX Equivalent Notes Aggregation AVG(X) `AVERAGE(X)` Aggregation COUNT(X) `COUNT(X)` or `COUNTA(X)` `COUNT` counts numerical values; `COUNTA` counts non-blank values. Aggregation COUNT_DISTINCT(X) `DISTINCTCOUNT(X)` Aggregation MAX(X) `MAX(X)` Aggregation MEDIAN(X) `MEDIAN(X)` Aggregation MIN(X) `M...