Geoffrey's Data Analysis/Engineering Portfolio

Geoffrey's Data Analysis/Engineering PortfolioGeoffrey's Data Analysis/Engineering PortfolioGeoffrey's Data Analysis/Engineering Portfolio
  • Home
  • About Geoffrey
  • Power BI
    • Build SVGs in PBI
    • Reality TV US Viewership
  • Tableau
    • The Office Project
    • Food Inventory Project
    • 5 D6 Project
  • Python
    • Build SVGs in PBI
    • The Office Project
    • 5 D6 Project
  • More
    • Home
    • About Geoffrey
    • Power BI
      • Build SVGs in PBI
      • Reality TV US Viewership
    • Tableau
      • The Office Project
      • Food Inventory Project
      • 5 D6 Project
    • Python
      • Build SVGs in PBI
      • The Office Project
      • 5 D6 Project
  • Sign In
  • Create Account

  • My Account
  • Signed in as:

  • filler@godaddy.com


  • My Account
  • Sign out

Geoffrey's Data Analysis/Engineering Portfolio

Geoffrey's Data Analysis/Engineering PortfolioGeoffrey's Data Analysis/Engineering PortfolioGeoffrey's Data Analysis/Engineering Portfolio

Signed in as:

filler@godaddy.com

  • Home
  • About Geoffrey
  • Power BI
    • Build SVGs in PBI
    • Reality TV US Viewership
  • Tableau
    • The Office Project
    • Food Inventory Project
    • 5 D6 Project
  • Python
    • Build SVGs in PBI
    • The Office Project
    • 5 D6 Project

Account


  • My Account
  • Sign out


  • Sign In
  • My Account

Build Scalable vector graphics in Power BI

Power BI, Python

Overview:

Power BI report utilizing Python for dynamically creating custom SVG images in Power BI based on user's selections. 


Features/Analysis Enablement:

The report layout has the dynamic SVG image on bottom right. The left (dark blue) section enables toggling visibility for all objects as well as controlling 1 specific object for additional settings by clicking the arrow to right of object row. The middle (light blue) section is for controlling properties for the object selected from before (which gets highlighted in the Objects list) and controls shape, color, size, x-position, and y-position properties. The upper right section has property filters pertaining to the SVG background color/ and axis labels. Technically - this report utilizes Power BI bookmarks/buttons for handling the left dark blue and middle light blue section's interaction logic. The user input is gathered through Power BI Measures/Slicers which get passed to Python visual/Script Editor for creating a SVG within Python using svgwrite module based on this user input, then converting file type within memory to PNG using cairosvg module and ultimately displayed using matplotlib.pyplot visual which can't work with SVGs by default. 

Build SVGs in Power BI Demo Video

Watch this few minute report overview video.

Copyright © 2024 Geoffrey's Data Analysis/Engineering Portfolio - All Rights Reserved.


Powered by GoDaddy

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

Accept