Category Archives: Power BI

Convert Power View dashboards to Power BI Desktop

Although Power View and Power BI reports are similar, Microsoft is focusing on the later. Power BI platform is being separated out from Excel for many reasons. One of the reasons is to eliminate the dependence upon Silverlight (technology used to create Power View, which is now being phased out).

Here is a 2 minute video which explains how to convert Excel based Power BI components like data mode, queries, relationships and Power View dashboards into Power BI Desktop. Once converted, you can publish these to the Power BI portal.

Don’t use Power BI with PowerPoint

I work with many customers on Power BI. It is a new topic for many users and decision makers (not techies). The benefits of using Power BI are obvious and everyone wants to use it immediately. However, the first question I get is – How to use Power BI with PowerPoint ?Here is the answer. Don’t try to put Power BI dashboards or visualizations into PowerPoint. Simple. If you want to know why, read on …

Why not use Power BI with PowerPoint

Continue reading Don’t use Power BI with PowerPoint

Power BI Glossary in plain English

Power BI Glossary is a one line description of relevant terms. Jargon free and easy to assimilate. This is actually part of the Power BI Udemy course I am working on. Let me know your feedback.

Power BI Glossary poster

Power BI Glossary

Data Information
Raw data Data as it is received by you
Good data Information in a table form
Bad data Data which is not good
Table Good data with a name
Summarization Roll up or combine raw data into smaller, easier to grasp information
Analysis Finding all possible useful things from the data
Pivot Table Popular tool to summarize tables and analyse the information
Report A way of sharing results of analysis
Action Using the analysis to eliminate bad things or increase good things in future
Power BI Set of new tools which allow even more, faster and easier analysis
Power BI Desktop Windows application which helps in gathering data, cleaning and analysis
Visualization Showing data using a graphic rather than just numbers and text
Dashboard Multiple, related visualizations shown together
Interactive Dashboard Dashboard where changes to one item affects the related visualizations
Power BI Portal The place on internet where you can publish and share the analysis
Power BI app A mobile app for viewing and interacting with Dashboards

Where is your data stored in Power BI portal

This is a common concern amongst customers. Many countries have a requirement that their data should be physically stored within a data center located in their country. Here is a simple way to find out where exactly your data is stored in Power BI.

The steps

Login to Power BI Portal and click on the Help (Question Mark) button. Choose About Power BI option.

About Power BI

Where is Power BI data stored?

Now it shows a dialog which displays the actual country in which your data is stored. Of course, if you want to change that location, you will need to talk to your Microsoft account manager or partner.

Power BI portal

Power BI Desktop course – Need your inputs

Power BI is powerful, as the name suggests. But it is also confusing. Exactly what what does Power BI mean? There is no simple, single line answer. Let me try. It is a set of new tools to analyze old data in new ways. Today the simplest way to get started it to sign up for a free Power BI subscription and use Power BI Desktop tool to create your reports and dashboards. I have already written an introductory article and published a walkthrough video.

Power BI Desktop course on Udemy

I feel this is one tool which can transform the way we work on data and analyze it. The primary reason is that it is independent of Excel. So all the bad habits which we have developed in Excel over decades simply disappear! I am planning to create a course on Udemy for Power BI Desktop. I would like your inputs on the content and any additional ideas or wish list. Read on to have a look and post your comments. You can also send a mail to me on nitin@maxoffice.biz

Continue reading Power BI Desktop course – Need your inputs