

You’ll need to save and restart your instance of Power BI Desktop for the changes to become active. Select all that you would like and click Ok.


To enable features that are in preview navigate to File, Options and Settings, Options, and Preview Features. This visualization allows you to analyze data over periods of time such as rolling averages and is currently still in preview, but I doubt it will be for long. The second visualization that I want to highlight is a newly added feature called the Relative Date Slicer. To hide objects, right-click them from the Fields pane and select “Hide in Report View”. This will come in handy if you decide you want to share your work with others and would like to limit what they are able to use in their reporting. One of my favorite features here is being able to hide objects, such as columns or measures, from the report view. Selecting any table will bring a preview into the main presentation area of the window. You can also change data types as well as see a list of tables and their columns (Fields) on the right side. Here, you can create new table, columns, and measures to use in your analysis. The Data tab of PBI Desktop enables you to do several things. This will become especially important when you start adding Historical Tables for multiple companies. Without that column, the two tables would be independent of one another, prohibiting data analysis. You will notice that because we added the Company ID column to the Historical Data table, the two tables are linked together. Now that you’ve got your magicians hat on, lets dig into it! Before you get started in PBI, take a few minutes to establish which companies you would like to analyze and some details about them in an excel document.
Stockmarketeye license key for free#
For the purposes of this blog, all you will need is Power BI Desktop, which can be downloaded for free from the above link. For more details on pricing, check out the Power BI official page here. Power BI is a lightweight, easy to use, free / inexpensive self-service business intelligence tool provided by Microsoft. What if there were a tool available that empowered you to conduct your own analysis of stocks such as trends over time and high level forecasting (the magic word)? Would you consider investing? Or perhaps you’re already an investor and would like to add another tool to your trading arsenal? Microsoft’s latest Business Intelligence tool, Power BI, does all the above and more without overcomplicating the process.
