Microsoft Machine Learning Technologies Overview Artificial intelligence and specifically Machine learning can bring lots of benefit to the business owner. Many businesses using Microsoft data platform tools for many years. Microsoft employed machine learning in creating their products such as Xbox, Bing Search and so forth for a while. However, from 2014 they start to Read more about OVERVIEW ON MICROSOFT MACHINE LEARNING TOOLS[…]
We are excited to share you the November 2018 version of Power BI helper with many interesting features. With this version, you get the list of all pages and list of all bookmarks. You can find all bookmarks related to a page. You can also through this version find out the data columns that consume Read more about Find the Most Expensive Columns for Performance Tuning, Bookmarks, and more with Power BI Helper Version November 2018[…]
If you have worked with Power BI for some time, you know that there are two types of the Date dimensions; Custom or built-in/Default. It is always confusing for people, that which date dimension is good to use, and what is the difference between these two approaches. Also based on the selection of the type Read more about Power BI Date Dimension; Default or Custom? Is It Confusing?[…]
I’ve been honored and had the opportunity to have an interview with some great minds in Ignite 2018. Just to mention a few; it was the discussion about all new Power BI and AI features announced at Microsoft Ignite 2018 conference. In this post, you will see the link to all my 14 interviews of Read more about Ignite 2018 Interviews by Reza Rad; Power BI and AI[…]
The latest addition to my recent series of DAX based games is the classic Minesweeper game. This is the game where you are presented with a 9 x 9 matrix of squares. There are 10 hidden mines and you can either step on a square or place a flag where you think there might be Read more about Fun with DAX – Minesweeper[…]
When you work with tables and queries in Power Query and Power BI, you get the option to copy them through these actions: Duplicate, or Reference. It has been always a question in my sessions and courses that what is the actual difference between these two actions. The explanation is simple but very important to Read more about Reference vs Duplicate in Power BI; Power Query Back to Basics[…]
There are many time intelligence functions in DAX, and each of those is helping in aspects of analyzing data on dates. There are two functions which work very similar to each other but have a bit different usage; DatesInPeriod, and DatesBetween. In this post, I will show you what is the difference between these two Read more about DatesInPeriod vs DatesBetween; DAX Time Intelligence for Power BI[…]
One of the most common requirements in any reporting solution is the ability to drill through from master page to the details page and see the details of an item or category. In this post, I will explain how this feature is simply possible in Power BI, and what are things to consider when you Read more about Master Detail Design with Drillthrough Filter in Power BI[…]
Power BI Helper is getting new features every time, and this time, we got some exciting features; You can now get your M (Power Query script) code beautified and colorful with version 4.0 of Power BI Helper. We also get the row-level security information exposed through the Helper application. Both information above will be now Read more about Beautify M Script and Extract Row Level Security with Power BI Helper Version 4.0[…]
I work with Power Query transformations every day these days, and I want to share one simple, but critical caution with you. If you use Power Query a lot, this tip can improve the performance of your transformation significantly. The number of steps that you add in a query counts in the performance of your Read more about Watch Your Steps! Power Query Performance Caution for Power BI[…]