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)

Free data analysis for "VEGAN RESTAURANT ".

Image
  We provide free data analysis for "VEGAN RESTAURANT ". This will be one time service and you will be free to use it or show it to your "INVESTORS". Info you can deduce are  The food combination ,which are popular The food and drink combination ,which are popular The food combination ,which are popular and generating more profit The food is popular on which day The food and location correlation See sample         

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...