Here is another short but power packed video which explains how analytics can drive growth. Read the related articles here.
Redundant or unwanted columns can confuse the users of Pivot Table. Here is how you can remove unwanted columns from appearing in the Pivot Table field list.
We have seen many methods of using Excel and related Power BI tools for analyzing data. Now, all that can be done WITHOUT using Excel – using a stand-alone tool called Power BI Desktop. Here is how you do it.
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
Often we get data which is distributed in multiple column sets. Here is how you can convert it to good data (tabular column format) using Power Query. Watch the video. Sample File download.
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.
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!
Thank you for the overwhelming response for Data Analytics webinar video. More than 800 attendees, 70+ questions.
Watch the video on YouTube (use 720P) or Download (MP4, 188 mb, 60 min) and view on your PC. A big thank you to the Microsoft and Economic Times team for making this possible.
Power Query is an amazing tool for importing and cleaning up data from various sources. The problem was that it required you to have professional version of Office. Now that problem is solved…
It is a powerful but often ignored feature of Power Pivot.
It allows you to describe the meaning of the data column – independent of its field name.
Estimated reading time 8 min