Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data modelling best practices

Hello there,    I'm in the middle of a process which envolves data modelling, so I start to create some queries (the metrics for the dashboard) inside of the database, then I import the data inside...
General Comment
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    I do all my data prep in Power Query and Dataflows, it gives me the ability to use one ( M ) language to manipulate all data no matter where it comes from, and I find it a lot easier and faster than using SQL for instance.

     

    but I guess it always will a question of what project I'm working on, what's an easier option or simply personal preference.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the help, guys!

 

Just for the record, I realized that importing queries (metrics) already with all kind of details turn on to be a bad idea, because most of the queries I build have a sql group function, and this was hiding some inner details (data), that I was intended to use as slicer/filter inside PowerBI.

So I decide to build the metric inside PowerBI.

 

Best Regards,

pardim7