Category Archives: Power BI

Power BI Desktop tutorial for Beginners

In the earlier article, we saw how Power BI Desktop can help us create complex, interactive and useful reports from various sources of data. Here is a detailed walk-through of how exactly to use this tool. In this video we will use the simplest possible scenario: Start with a simple CSV file, create a report, publish it on Power BI site and share it with a colleague. We will also see the Power BI mobile app in action. Download this sample CSV file (ZIP) if you want to follow along. 12 min video. Watch it in full screen mode at highest resolution.

In brief, this video will walk you through the following:

  • How to create a FREE Power BI account
  • Overview of the steps required for creating your first Power Bi Desktop dashboard
  • Download Power BI desktop
  • Import Data to Power BI Desktop
  • Create a Power BI desktop Report
  • Power BI Amazing Filter capability:  Anything which is plotted is a Filter
  • Ctrl + Click to select multiple fields
  • Publish a Power BI desktop report to Power BI site
  • Power BI report browser view
  • Create a Power BI dashboard
  • Share a Power BI dashboard
  • Power BI natural Language Q&A tool: Ask a question in simple English and get answered instantly
  • Power BI app on mobile
Photo credit: kevin dooley via Foter.com / CC BY

Instant benefit: Try Distinct Count wherever you are using Count

SUM and COUNT are the most common methods of summarizing data. It is easily done in Pivot Table or any other analytical tool. What is equally important is DISTINCT COUNT. But it is not commonly used. Why not? Firstly, due to lack of awareness and secondly, due to lack of that feature in Pivot Table. Let us solve both problems in the next 10 minutes.

distinct count or unique count

Continue reading Instant benefit: Try Distinct Count wherever you are using Count

Office 365 Worst Practices – Part 6 – Power BI tools not deployed / used

Office 365 plans which include Office Pro Plus are capable of running Power Pivot, Power Query, Power View and Power Map. Extremely powerful tools. Highly popular with users and top management. Unfortunately, in many cases, these tools are just not deployed!

image

Continue reading Office 365 Worst Practices – Part 6 – Power BI tools not deployed / used