Skip to content

Instantly share code, notes, and snippets.

@johnfelipe

johnfelipe/video2.md

Last active April 18, 2024 14:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save johnfelipe/c5d9f841427a15c00ace22141f9b686b to your computer and use it in GitHub Desktop.
Save johnfelipe/c5d9f841427a15c00ace22141f9b686b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
video2.md

VIDEO2: https://drive.google.com/drive/folders/1rOZupBc3S0UfjM7Hl3x1l3TXgoXgry3Q?usp=sharing

Based on the transcript, here are the detailed Power BI tasks extracted:

  1. [00:01:41] Create a report section in the center that shows the reference portfolio. For the client view, paint the reference portfolio data, but without any amounts since it is not a real balance.

  2. [00:03:18] When a group is selected, update the report to show the group level information instead of client information.

  3. [00:11:40] For painting the group level current balance in the first query (portfolio-group), take the economic group field directly. The name logic is calculated the same way as for client - take fund name if it's from funds, take name if it's from titles, put current account in front if applicable.

  4. [00:13:35] For the second group level query (current balance by asset type), take the group portfolio, group by asset type, take the economic group field directly. Asset type is direct load. Summarize the balance. Participation percentage needs to be calculated.

  5. [00:14:28] For the third group level query (profitability volatility), take economic group name, profitability and volatility from the profitability volatility group table.

  6. [00:05:25] Implement the reference portfolio section that appears for clients only, not groups. There are 5 client profiles (100, 200, 300, 400, 500), each mapped to a specific reference portfolio.

  7. [00:07:10] Reference portfolios work only on percentages, not amounts. Ensure no amounts appear for reference portfolios in the report.

  8. [00:08:25] To know a client's profile, use the investor profile name field from the client table.

  9. [00:08:53] Look up the client's profile in the profile table to fetch their reference portfolio balance sheet data.

  10. [00:09:48] For painting reference portfolio data in the first query, take investment profile name, calculate product name using the source field logic (fund name for funds, "direct position" for titles), and directly show the participation percentage.

  11. [00:12:36] For the second reference portfolio query (by asset type), group by asset type. Profile name and asset type are direct fields. To get distribution percentage, convert the percentage to a whole number, summarize, then calculate percentage of the total.

  12. [00:22:41] For the third reference portfolio query (profitability volatility), directly take the data from profitability volatility portfolio reference table.

  13. [00:25:48] If possible within the time estimate, add a warning on the report interface if the total percentage exceeds 100% for reference portfolios. This is low priority, only if time permits.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment