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?


44 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
  28. 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
  29. This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.

    data science interview questions

    ReplyDelete
  30. very well explained. 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
  31. This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  32. very well explained. 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.
    Logistic Regression explained
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm

    ReplyDelete
  33. A Computer Scientist learns to design software systems and gains in-depth knowledge of the theory of computation. data science course syllabus

    ReplyDelete
  34. I am overwhelmed by your post with such a nice topic. Usually I visit your blogs and get updated through the information you include but today’s blog would be the most appreciable. Well done!
    data science training

    ReplyDelete
  35. Attend The Artificial Intelligence course From ExcelR. Practical Artificial Intelligence course Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Artificial Intelligence course.
    Artificial Intelligence Course

    ReplyDelete
  36. Good to become visiting your weblog again, it has been months for me. Nicely this article that i've been waited for so long. I will need this post to total my assignment in the college, and it has exact same topic together with your write-up. Thanks, good share.

    data science course in India

    ReplyDelete

  37. it’s really nice and meanful. it’s really cool blog. Linking is very useful thing.you have really helped lots of people who visit blog and provide them usefull information.
    Data Science Training in Hyderabad

    I am really happy to say it’s an interesting post to read . I learn new information from your article , you are doing a great job . Keep it up

    Devops Training in USA

    Hadoop Training in Hyderabad

    Python Training in Hyderabad

    ReplyDelete
  38. Thank you for your post, I look for such article along time, today i find it finally. this post give me lots of advise it is very useful for me !data science training in Hyderabad

    ReplyDelete
  39. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
    Artificial Intelligence Course

    ReplyDelete
  40. You completed certain reliable points there. I did a search on the subject and found nearly all persons will agree with your blog. tableau vs power BI | visualization tools comparison

    ReplyDelete

  41. keep up the good work. this is an Ossam post. This is to helpful, i have read here all post. i am impressed. thank you. this is our site please visit to know more information
    data science courses

    ReplyDelete