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.
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 …
Continue reading Don’t use Power BI with PowerPoint
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
||Data as it is received by you
||Information in a table form
||Data which is not good
||Good data with a name
||Roll up or combine raw data into smaller, easier to grasp information
||Finding all possible useful things from the data
||Popular tool to summarize tables and analyse the information
||A way of sharing results of analysis
||Using the analysis to eliminate bad things or increase good things in future
||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
||Showing data using a graphic rather than just numbers and text
||Multiple, related visualizations shown together
||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
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.
Login to Power BI Portal and click on the Help (Question Mark) button. Choose About Power BI option.
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 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.
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 email@example.com
Continue reading Power BI Desktop course – Need your inputs