Our Blog

Read about latest technologies, our team's experience, and thoughts, best practices, and real world solutions, from our frequently updated blog.

Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold

Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold

After a long wait, in the October 2018 release of Power BI Desktop we saw the fuzzy matching feature added finally. Yay! Have you ever wanted to match two tables together but not on exact matches, but also on a threshold of similarity? if your answer to this question is yes, then this feature is ...

Read More

Power BI and Azure ML make them work with Power Query

Power BI and Azure ML make them work with Power Query

In this blog post, I am going to show how to use the Azure ML web service in Power BI (Power Query). First Step: You need to create a model in Azure ML Studio and create a web service for it. The traditional example in Predict a passenger on Titanic ship is going to survived ...

Read More

Quick DAX : Word count

Quick DAX : Word count

Here is a technique you might consider if you need to split text down to individual words.  This could be used to help count, rank or otherwise aggregate the words in some longer text.  The approach detailed here uses spaces as a delimiter and will not be tripped up if multiple spaces are used between ...

Read More

Our Clients Love Us

What our clients say about our service and solutions

  • Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools

    “I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.

    Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.

    After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.

    I would recommend Radacad Power BI Training without hesitation.”

    Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools
  • Dan Cheshire, Senior Project Manager Air New Zealand

    “Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know.  He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful.  When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable.  Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.”

    Dan Cheshire, Senior Project Manager Air New Zealand
  • Sonia Buckley, Data Analyst at Zoom2u

    “We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg.  I had a call with Reza who made my life so much easier in just under an hour!  Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way!  Not only that but he is very patient and straight forward.  Highly recommended!”

    Sonia Buckley, Data Analyst at Zoom2u
  • Martin Catherall – Data Platform MVP, PASS Regional Mentor

    “I attended Reza’s Power BI pre-con “From Rookie to Rock star” at SQL Saturday Brisbane in May 2016. I was a complete Power BI novice, having only previously accomplished a few very basic things with Power BI. Reza took the group through all the components that make up environment. He explained how they had evolved and took the group through walk-throughs of each one. Reza was great an answering questions from the audience at the event and going into extra detail if necessary. All-in all, I would say that I’m now a very confident Power BI user after attending Reza’s pre-con.”

    Martin Catherall – Data Platform MVP, PASS Regional Mentor

Don’t hesitate, should you have any inquiries

Contact Us