Latest Power BI and AI articles from RADACAD team
Microsoft Data Insight Summit in Seattle is next week, and it is already sold out with 2000+ registrations. This is twice last year considering number of registrations. Number of sessions and speakers are also increased this year. This year 100+ sessions will be presented by Microsoft and community speakers. RADACAD team are presenting five (5) Read more about Our Sessions at Microsoft Data Insight Summit 2017; Seattle[…]
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[…]
In previous posts (Part 4 and Part 5), I have explained some of the main components of Azure ML via a prediction scenario. In post one the process of data cleaning (using SQL Transformation, Cleaning Missing Value, Select specific Columns, and Edit Meta Data) has been explained. and in the second Post, I have explained how to apply Read more about Azure ML Part 6: A Machine Learning Prediction scenario (3)[…]
For this blog I thought I would share a handy trick for optimising Power BI using a data modelling solution that is often forgotten or overlooked. It involves focusing on certain columns based on the degree of uniqueness they contain and converting or removing all together from a data model. I will explain how and why this Read more about Optimising Power BI data models[…]
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[…]
I recently encountered a question posed to the Power BI community forum I found interesting enough to kick-start my blogging on Power BI. The essence of the question was asking how to dynamically determine distances between two geographic points from user based selections. So I thought I would cover how this can be done in Power BI to Read more about Dynamic distances in Power BI[…]
In the previous Post , I start to do prediction the cancer diagnosis using some laboratory data. I have explained some of the main components for doing the data cleaning such as “SQL Transformation”, “Edit Meta Data”, “Select Columns” and “Missing Values”. In this post I am going to show the rest of data cleaning Read more about Azure ML Part 5: A Machine Learning Prediction scenario (2)[…]
In previous Posts Part 1, Part 2 and Part3 I have explain some about the azure Ml environment, how to import data into it and finally how to do data transformation using Azure ML component. In this post and the next one I am going to show how to do a Machine Learning in Azure Read more about Azure ML Part 4: A Machine Learning Prediction scenario (1)[…]
In the Part 1 I have explained some of the main statistics measure such as Minimum, Maximum, Median, Mean, First Quantile, and Third Quantile. Also, I have show how to draw them in Power BI, using R codes. (we have Boxplot as a custom visual in power BI see :https://powerbi.microsoft.com/en-us/blog/visual-awesomeness-unlocked-box-and-whisker-plots/ ). However, to see the data Read more about Visualizing Data Distribution in Power BI – Histogram and Norm Curve -Part 2[…]
In this post and next one, I am going to show how to see data distribution using some visuals like histogram, boxplot and normal distribution chart. It always important to have a holistic perspective regarding the minimum, maximum, middle, outliers of our data in one picture. One of the chart that helps us to have a Read more about Visualizing numeric variables in Power BI – boxplots -Part 1[…]