About Me

1

My name is Nicolò Grando and i’m a consultant at The PoriniInSight company .

I started out as an economist , graduated in Management at Bocconi I turned my passion for computers in a work combining economy and programming.

I deal with consulting and development of Business Intelligence solutions applied to Microsoft technology , starting from the analysis to the modeling .

The main technologies that use everyday are

  • SQL Server since 2008 until the most recent version , with all its components , integration services , reporting services , analysis services .
  • Excel since 2007 up to the latest version .
  • Sharepoint 2010 up to the latest version but only as a front end for data sharing
  • Datazen
  • Power BI

 

 

 

2 pensieri su “About Me

  1. Hey, Thanks for this article https://powerbloggerbi.com/2016/06/09/google-analytics-multiple-site-and-power-bi/

    I researched quite a bit about merging multiple GA accounts and yours was the only one I found. However, I have had difficulty understanding your English but I managed to get going but it is failing at the last step.

    When I run this query I get a window with Enter Parameters and three fields for id1, id2, id3.

    let Multiple = (id1 as text,id2 as text,id3 as text)=>
    let
    Source = GoogleAnalytics.Accounts(),
    #”9231159″ = Source{[Id=id1]}[Data],
    #”UA-9231159-1″ = #”9231159″{[Id=id2]}[Data],
    #”18579777″ = #”UA-9231159-1″{[Id=id3]}[Data],
    #”Added Items” = Cube.Transform(#”18579777″, {{Cube.AddAndExpandDimensionColumn, “ga:exitPagePath”, {“ga:exitPagePath”}, {“Exit Page”}}, {Cube.AddAndExpandDimensionColumn, “ga:hostname”, {“ga:hostname”}, {“Hostname”}}, {Cube.AddAndExpandDimensionColumn, “ga:landingPagePath”, {“ga:landingPagePath”}, {“Landing Page”}}, {Cube.AddAndExpandDimensionColumn, “ga:pagePath”, {“ga:pagePath”}, {“Page”}}, {Cube.AddAndExpandDimensionColumn, “ga:pageDepth”, {“ga:pageDepth”}, {“Page Depth”}}, {Cube.AddMeasureColumn, “% Exit”, “ga:exitRate”}, {Cube.AddMeasureColumn, “Avg. Time on Page”, “ga:avgTimeOnPage”}, {Cube.AddMeasureColumn, “Entrances”, “ga:entrances”}, {Cube.AddMeasureColumn, “Entrances / Pageviews”, “ga:entranceRate”}, {Cube.AddMeasureColumn, “Exits”, “ga:exits”}, {Cube.AddMeasureColumn, “Page Value”, “ga:pageValue”}, {Cube.AddMeasureColumn, “Pages / Session”, “ga:pageviewsPerSession”}, {Cube.AddMeasureColumn, “Pageviews”, “ga:pageviews”}, {Cube.AddMeasureColumn, “Time on Page”, “ga:timeOnPage”}, {Cube.AddMeasureColumn, “Unique Pageviews”, “ga:uniquePageviews”}})
    in
    #”Added Items”
    in
    Multiple

    When you have a couple of minutes can you respond with a note on what I should be checking to resolve this. Thanks a lot.

    Mi piace

    • Its correct, you have to use this script as a fuction of another power query table. In particular you have to create a custom column in the table where there is the list of your websiye. Have you got the table with the 3 ids for all your website?

      Mi piace

Rispondi

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione / Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione / Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione / Modifica )

Google+ photo

Stai commentando usando il tuo account Google+. Chiudi sessione / Modifica )

Connessione a %s...