Stock Analysis Power BI Report for 2022

 Happy Holidays!

Just another day is left and new year knocking our door bell. Microsoft published lot's of splendid features in Power BI in the mid of June this year and here the link https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-format-pane . Thank You Microsoft Power BI Team :)

In this post, I'm trying to bring a few different verities of Power BI report based on stock exchange fictitious data. The objective is to give you high level overview about what level of profit/lost has been made and from which stock and how far profit or loss has been made of.

The reports are very self explanatory. In the below report, a simple pie chart shows your total transaction volume on month wise. You'll able to understand which are the busiest month for you in this year.


Next one, is simple tabular report which tells you which stocks make your happy and how far you make your profit :) 


Below is simple and beautiful. Visualization shows you the name of the stocks which make you highest profit and how much profit you made out of it.  


And this walkthrough you till the end where you might found a few stocks where you made loss and how much loss you took. 


Now the below, funnel one, help you to understand which are your more favorite stocks where you put your bet most of the time. You can easily identify those stocks where you don't get interest at all at the end. 

Heatmap - the traditional report give you the picture. Below report brings you the total quantity of share you deal against different stocks throughout the year. Again another representational where your can find your favorite buddy.


Line chart is simpler - show you the overall profit/loss you made at the end of each month. 


And the last one below is the ribbon chart. Another visual representation of showing what you made and for whom you made this. Finally this help you to understand how much you made it :) 



What next? The report might gets over here, however, you have plenty of rooms to utilize data analysis using complex library and algorithm to brig your best strategy for next year.

Wish you all - A Happy And Prosperous New Year 2023 :)







Comments

Post a Comment

Popular posts from this blog

How to fix Azure DevOps error MSB4126

Image
Setting up build and release pipeline always tedious and we face many build related issues. Here is one common error I face couple of times while setting app Web or windows apps in Azure DevOps After placing the code in repos, and creating the build pipeline and run it, you can face the following error ##[error]D:\a\8\s\<your solution file>.sln.metaproj(0,0): Error MSB4126: The specified solution configuration "release|$(BuildPlatform)" is invalid. Please specify a valid solution configuration using the Configuration and Platform properties (e.g. MSBuild.exe Solution.sln /p:Configuration=Debug /p:Platform="Any CPU") or leave those properties blank to use the default solution configuration. To understand what is target platform defined in your project you need to visit or open the solution(.sln) file and review the following sections. In my case, this has been defined as x86 as target platform.                   GlobalSecti
Read more

SharePoint Admin Center

Image
 SharePoint Admin Center allows you to view your organization's SharePoint site including communication sites, channel sites, and sites that belong to Microsoft 365 group. This is same like Site Admin in earlier days of SharePoint versions. You can search organizational site, sort them or filter sites the way you want. Easy way to find and apply/change site settings. Under Policies, click on Sharing - This will allow you to create rules/ set control sharing at the organization level in SharePoint and OneDrive Here, in this page, you can apply settings to restrict how users are allowed to access content in SharePoint and OneDrive. Term store, the word getting populated from SharePoint 2010. You can feed metadata of metadata information of your organization level, program level, project level in Term store. helps your organization's knowledge better.  AI soon will play a vital role here and using AI, you can acyually find collect and process and finally yoour organization's d
Read more

How to create Custom Visuals in Power BI – Initial few Steps

Image
This post will help you to know the steps to create custom visuals in PowerBI. Microsoft defined them as well at https://docs.microsoft.com/en-us/power-bi/service-custom-visuals-getting-started-with-developer-tools . First things first, and you need to download and install NodeJS , in case if you do not have npm setup in your machine.  Second step is to run couple of npm commands to install Power BI Visual Tools and create & publish the cert. Finally, create your own package and upload with the help of npm. 1.       npm install -g powerbi-visuals-tools 2.       pbiviz --create-cert pbiviz --install-cert 3.       pbiviz new My Visual name – This will create the file under the name of your visual file. 4.      pbiviz start – You need to go to the folder where your custom visual  resides, and run this command. You can change a few things in your pbiviz.json file, like author, display name, icon, style etc. Finally, package your
Read more