Every so often I find myself needing to import data, but only want data relevant to values already existing in my data model. This is common where I build smaller models based on a subset of fact or transaction records. Rather than bring in entire dimension tables, I may only need the dimension records that Read more about Dynamic SQL Using Power Query[…]
In the last post, I have explained the main concepts behind the neural network, In this post I will show how to apply neural network in a scenario in R and how to see the results and hidden layers in a plot. For this post I got some great example from [1]. Scenario: Concert has Read more about Neural Network R codes in Power BI Part2[…]
Microsoft Data insight Summit 2017 has been held in Seattle from 12 to 13 Jun. It is the main conference for Microsoft Data Analysis with Power BI. All interesting and new topics in Power BI has been presented. Most of the speakers are from Microsoft product team or experienced speakers in this fields. there are Read more about Speaking Files in Microsoft Data Insight Summit 2017[…]
Power BI Desktop file stores many metadata information in it, one of the most important piece of information stored there is Power Query M scripts. It is always easy to open a PBIX file and realize the queries in Query Editor Window. However, if you have many queries and you want a way to get Read more about Exposing M Code and Query Metadata of Power BI (PBIX) File[…]
I read a quote somewhere along the lines of… If you are trying to solve a problem with regular expressions… you now have two problems This seems a little harsh for a useful tool that has been with us for what seems a very long time. Plenty of languages offer support for Read more about Power BI and Regular Expressions[…]
In the previous post,I have explained the main concepts and process behind the K-mean clustering algorithm. Now I am going to use this algorithm for classifying my Fitbit data in power BI. as I have explained in part 5, I gathered theses data from Fitbit application and I am going to cluster them using Read more about K-mean clustering In R, writing R codes inside Power BI: Part 6[…]
K Nearest Neighbour (KNN ) is one of those algorithms that are very easy to understand and it has a good level of accuracy in practice. In Part One of this series, I have explained the KNN concepts. In Part 2 I have explained the R code for KNN, how to write R code and how Read more about Prediction via KNN (K Nearest Neighbours) KNN Power BI: Part 3[…]
What is the main difference between M and DAX? Why we can do a calculated column in two different places? What are pros and cons of each? Which one should I use for creating a profit column? Why I cannot do all of it in only one; DAX or M! Why two different languages?! Why Read more about M or DAX? That is the Question![…]
Power Query is the component of getting data in Power BI. But have you used Power Query to get metadata of the Power BI queries itself? In this post I’ll show you a quick and simple way of using Power Query to get metadata (name of queries and the data in queries) from all queries Read more about Get List of Queries in Power BI[…]
I’ve hear this question many times; “Do you think we need a date dimension?”. some years ago, date dimension has been used more, but nowadays less! The main reason is that there are some tools that are using their own built-in date hierarchy. As an example Power BI has a built-in date hierarchy that is Read more about Do You Need a Date Dimension?[…]