Tuesday, March 13, 2018

Power BI Q&A feature in reports

I know I've been lazy in the last six (ok, even more) months... but things have changed around my career a little bit. Don't get me wrong, I am still doing lots of SharePoint stuff, but since last summer I also got involved in some Power BI projects. I've also started putting up a another small blog on Facebook related to my other passion, which is globetrotting.

I got really good insights in the Power BI technology during a full day workshop at the European Collaboration Summit in Zagreb, Croatia last year. Thanks to John White and Jason Himmelstein for the wonderful delivery of the content. It was transferred to hands-on experience starting the day I got back to work.

In the last 9 months, I've got my hands dirty and designed several solutions, based on Power BI reports and dashboards, with data from SharePoint, Exchange Online and other business applications.

To prove I'm seriously into this, today, I have actually passed the now official Microsoft exam:

Analyzing and Visualizing Data with Microsoft Power BI (70-778)


It was the toughest exam I've taken (no kidding!), there were a lot of DAX queries and a mix of admin and developer questions...it was a close one with a passing score of just 745.

Anyway, I wanted to give you some value with this post by telling you about a feature that got released in Power BI Desktop recently... that's the Q & A.

Even on the exam, questions to Q & A referred only to the dashboards in the Power BI service, but this feature is now also available in the reports in Power BI Desktop. Your Power BI desktop client must be at least the December 2017 version... but I recommend you get the March 2018 update.

It's a preview feature, so you'd need to enable it first. You can do that by going to File -> Options and settings -> Options -> Preview features. Tick the Q &A feature, click OK and restart Power BI desktop.


The next time you start your Power BI desktop client, you will see this:


How does the feature work? Pretty simple, you can ask questions about your data in a natural language. Just click on the canvas in Power BI desktop report view and the following visual will appear:


For example, I'll load a dataset of Projects and ask the simple questions.. ok how many are they? Rather than doing a COUNT function with DAX... and boom: I've got the answer.


Now, sometimes, you will not know the exact field name by which to search... let's say you insert a query for top client by revenue, but the field in the dataset is called customer. Here's where the synonyms come into play. I will write another post on how to get the most of those.

So... how many of you are using Power BI? Are there any of you interested on taking the exam?


29 comments:

  1. The advanced world we live in directly is flooded with a wide range of computerized information: information produced through web based life posts Data Analytics Course in Bangalore

    ReplyDelete
  2. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!
    data analytics course

    ReplyDelete
  3. This was really one of my favorite website. Please keep on posting. ExcelR Data Analytics Course Pune

    ReplyDelete
  4. I agree with a lot of the points you made in this article. I appreciate the work you have put into this and hope you continue writing on this subject.
    Best Data Science training in Mumbai

    Data Science training in Mumbai

    ReplyDelete
  5. I wanted to leave a little comment to support you and wish you a good continuation. Wishing you the best of luck for all your blogging efforts.
    Know more about Data Analytics

    ReplyDelete
  6. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries. keep it up.
    data analytics course in Bangalore

    ReplyDelete
  7. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
    Data Science Course

    ReplyDelete
  8. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  9. I feel very grateful that i read this.It is very helpful and very informative and i really learned a lot from it.
    learn360digitmg artificial intelligence course

    ReplyDelete
  10. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression

    ReplyDelete
  11. You completed certain reliable points there. I did a search on the subject and found nearly all persons will agree with your blog.
    learn360digitmg artificial intelligence online course

    ReplyDelete
  12. This is a fantastic website and I can not recommend you guys enough.
    360digitmg ai and machine learning courses

    ReplyDelete
  13. A good blog always comes-up with new and exciting information and while reading I have feel that this blog is really have all those quality that qualify a blog to be a one.
    data science course in guwahati

    ReplyDelete
  14. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. machine learning projects for final year In case you will succeed, you have to begin building machine learning projects in the near future.

    Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.


    Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.

    ReplyDelete
  15. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression
    data science interview questions

    ReplyDelete
  16. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  17. Really impressed! Everything is very open and very clear clarification of issues. It contains truly facts. Your website is very valuable. Thanks for sharing.
    digital marketing course in guduvanchery

    ReplyDelete
  18. Very Useful article
    https://360digitmg.com/course/certification-program-in-data-science

    ReplyDelete
  19. Amazing and interesting blog found to be well written in a simple manner that everyone will understand and gain the enough knowledge from your blog being more informative is an added advantage for the users who are going through it. Once again nice blog keep it up.
    DevOps Training in Chennai

    DevOps Online Training in Chennai

    DevOps Training in Bangalore

    DevOps Training in Hyderabad

    DevOps Training in Coimbatore

    DevOps Training

    DevOps Online Training

    ReplyDelete

  20. Very good points you wrote here..Great stuff...I think you've made some truly interesting points.Keep up the good work.
    click here

    ReplyDelete
  21. I see some amazingly important and kept up to length of your strength searching for in your on the site
    artificial intelligence course in delhi

    ReplyDelete
  22. This is a great post I saw thanks to sharing. I really want to hope that you will continue to share great posts in the future.
    HRDF training

    ReplyDelete
  23. I think I have never watched such online diaries ever that has absolute things with all nuances which I need. So thoughtfully update this ever for us.
    360DigiTMG data analytics training malaysia

    ReplyDelete
  24. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!

    Simple Linear Regression

    Correlation vs covariance

    KNN Algorithm

    Logistic Regression explained

    ReplyDelete
  25. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete

  26. The blog and information is incredible and useful also
    hrdf claimable

    ReplyDelete
  27. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete