Skip to main content

Posts

Showing posts from June, 2023

Making KPI Dashboards with PowerBI

 While this is the free tier, I cannot share or collaborate with others, nor can I publish content to other people's workspaces, but they will not stop me from screenshooting and recording these self-taught adventures,so! I'm doing this because I idly searched "Mattel careers" and "Information Technology", and seeing a bulletpoint saying the following: Analytical and reporting skills such as creating dashboards and establishing KPIs such as experience with PowerBI, Cognos, Tableau, and Google Data Lake/AWS is preferred And thought "Well, I've used Tableau, and I've heard about PowerBI,  even if its in-demandness is questionable , so how similar is it? And can I write about it?"  First, PowerBI (PIB) does have a downloadable, local version, but apparently Windows-only. I could download the .exe but I couldn't run it / drag it to applications on my MacBook.  Not a problem, we'll use the online SaaS version, and a dataset found here,

Securing Terraform and You Part 2 -- Trivy by AquaSecurity

9/20: The open source version of Terraform is now  OpenTofu    Part one is over here . This comes as the 3rd tool in a long line of tools I am using to make Terraform (OpenTofu) code consistent. I went back to the Styra Academy courses for OPA Policy Writing. I am a very "Just show me the general idea, and I can probably figure it out", and I am reasonable enough to say that it didn't work this time, and I had to take the slow road. Good start; Trivy told us where it installed; trivy info installed /usr/local/bin/trivy /Users/morganza/Library/Caches/trivy the homebrew package had an outdated version, so I had to install v. 0.40.0 myself and link it to the previously installed 0.18.0 I believe -- See the GitHub discussion here . We are now back to rego, but fortunately, Trivy works as intended when you run it locally with the following command; trivy conf --policy . --namespaces morganza . There was an odd combination of YAML with a bit of rego involved for tfsec -- can

Lambdas

 A Lambda is an anonymous function. Places like AWS have services set up entirely just to host these simple functions that don't require a ton of code or backend. To run the Python here, I go back to Google Colaboratory; Check out my Lambda book here   Ex. 1   g =  lambda  x:  3 *x +  2 g( 3 )     Simple.  Ex. 2   full_name =  lambda  fn, ln: fn.strip().title() +  " "  + ln.strip().title() full_name( "   Ember" ,  "Serros" )     Notice the spaces in front of the first name (' Ember')      Ex. 3     def   func ( x , y ):    """Does things"""   func2 =  lambda  x: x + y+ 3 print (func( 2 , 7 ))   Using def seems to be hit or miss. This returns None, which technically is correct,  but I'm expecting a number (12). It's missing a return statement;   return  func2(x) +  3       Ex. 4   def   func ( x , y ):   funct2 =  lambda  x: x+y+ 5    return  funct2(x) +  6 print (func( 3 , 78 ))   Works just fine.      E