topic Re: Financial Dashboard in Data Stories Gallery

Financial Dashboard

Samietex — Wed, 06 Jul 2022 08:21:10 GMT

This Power BI report is inspired by Leonardo Karpinski. It shows how major indicators like Operational Revenue, Gross Margin, and Gross Marin percentage among others are analyzed.
This data was extracted and transformed in the Power Query Editor where the M code was used to create custom columns. A lot of transformations were carried out in the Power Query Editor. Measures, calculated columns, and tables were created using the DAX language in the Power BI desktop tool.

The first page (Revenue & Margin) consists of a matrix table showing how some of the calculated measures are analyzed by Suppliers and Groups from the data. From the stacked bar chart, we could see that category (Retail) has the highest revenue. The measures also show that November recorded the highest operational revenue and gross margin, while January recorded the highest gross margin %.
The income statement page is basically showing how the operating income is increasing and decreasing for each month. It also shows the analysis of the header account, subheader account, and the detailed account by the horizontal analysis, vertical analysis, and profit and loss indicator for each month.
The financial simulator page gives room for users to simulate scenarios on the Power BI report. You can easily predict the Variance revenue, Variance costs, and Variance Expenses among several others by interacting with the report by using the What IF? section.

eyJrIjoiNzI0YzlkZmUtNjFiOC00NGE1LWI3MzItNzI1MjNjMjMwNzMyIiwidCI6ImMwODg5MDgwLTg5YTAtNDU2NC04NjU4LWNjMTU0ZDYzZTdmNCJ9&pageName=ReportSection40e92ad55cc5936879e3

Re: Financial Dashboard

StacyLL — Tue, 18 Oct 2022 19:07:29 GMT

Excellent work! I have a background in financial analysis and really like how you captured and visualized the financial data. I am interested in learning more about your model. If you are willing to share. Kind regards, Stacy

Re: Financial Dashboard

Samietex — Sat, 22 May 2021 12:04:31 GMT

Thank you for the nice feedback Stacy. I'm willing to give you more tips on how I went about the report. I'll reach out to you via your email address.

Best regards,

Samuel.

Re: Financial Dashboard

lean_monzon2020 — Tue, 18 Oct 2022 19:06:14 GMT

This is amazing. Can you please share the PBIX file

Re: Financial Dashboard

UrosS — Thu, 05 Aug 2021 10:57:42 GMT

Hi,

I've just joined Leonardo's Power BI course 🙂

Is it possible to get the PBIX file of the report?

Best Uros

Re: Financial Dashboard

mosscon — Tue, 18 Oct 2022 19:03:17 GMT

Hello there,

This is impressive - is it possible to get the PBIX? if your able to share.

Thanks,

Mosscon

Re: Financial Dashboard

Anonymous — Thu, 19 Aug 2021 10:41:42 GMT

Please Share me PBIX file and Dataset..

Re: Financial Dashboard

JasperS — Tue, 18 Oct 2022 19:04:05 GMT

Great work!! would it be possible to get a copy of the PBIX file as well please

Re: Financial Dashboard

alexd1 — Tue, 18 Oct 2022 18:58:35 GMT

Hello Samuel,
that's nice work! I'm interested in learning more about your data model and view from organizing the data. If you are willing to share
Kind regards

Re: Financial Dashboard

Anonymous — Tue, 18 Oct 2022 18:25:03 GMT

Hello Samuel,

Could you please share the pbix file?

Well done job! Congrats!!

Re: Financial Dashboard

Anonymous — Tue, 18 Oct 2022 18:26:47 GMT

Amazing work , Congragulations on that, Can you please share the pbix file?

Re: Financial Dashboard

Anonymous — Tue, 18 Oct 2022 18:02:42 GMT

Amazing work, Will you please share me PBIX file?

Re: Financial Dashboard

Creasso — Tue, 18 Oct 2022 17:54:53 GMT

Hi how are you? 🙂

Amazing work , Congragulations on that, Can you please share the pbix file i'd be very thankfull

Re: Financial Dashboard

DarrenWatson — Fri, 11 Feb 2022 14:55:11 GMT

This looks great could i get a copy of the PBIX

Re: Financial Dashboard

Samietex — Sat, 19 Feb 2022 00:41:31 GMT

Hello guys,

To have access to the PBIX file: https://github.com/samietex/Financial_Dashboard_Modeling

You can also check my github profile for more Power BI files of projects I've worked on: https://github.com/samietex

Re: Financial Dashboard

alexd1 — Mon, 21 Feb 2022 06:37:00 GMT

Hello Samuel,

thanks a lot for sharing!

Re: Financial Dashboard

maxkaoppp — Tue, 18 Oct 2022 17:21:37 GMT

What a great work! Can I have this pbix file? thanks a lot

Re: Financial Dashboard

MSedky — Mon, 10 Apr 2023 10:13:25 GMT

Hello Samuel,

great work keep it up thanks a lot for sharing!

Best Regards

Re: Financial Dashboard

ca_od91 — Sun, 05 Nov 2023 16:23:59 GMT

Hi is it possible to get the pbix file? catherineod91@gmail.com

Thanks so much!