Code Monkey home page Code Monkey logo

budgets's Introduction

Create Budgets in AWS Budgets using Excel

Common Challenges

Finance, IT, operations typically dont want users going into the portal to do work

  • But you still to need to create a budget in AWS to track your spend, get notified, and detect anomalies

How to use Excel to enter, then create Budgets in AWS

Assumptions: Already have python, and AWS SDK Boto3 installed on laptop

  • Download github repo or clone to desktop
  • Install libraries in requirements.txt
  • Csv should be in same directory, if not, move to same directory where the code is stored
  • Open excel, enter your data (test data is fine). In this example, I used filters by service. You could set this up by Tag, to encompass a product or category of products.
  • Open the create-budget.py code, and update account with your information
  • Update email address
  • Save
  • Run python code [Budgets API links](Budgets โ€” Boto3 Docs 1.25.2 documentation)
  • Check results in AWS Console

Link to Demo in youtube

Coming soon

  • Create buget from csv file that gets uploaded to S3, which operationally a way to handle budget creation, and updates on an ongoing basis without going in the portal, and or learning skills (just use excel).
  • Budget pipeline deployment integration.
  • A S3 trigger will run lambda function (serverless compute in the cloud), then create AWS budget.
  • Move upload file from bucket to a processed bucket in S3.

Remember this is a POC, only to be used for testing

  • I excluded logging
  • I excluded error handling
  • I excluded Excel data validation

budgets's People

Contributors

the-csm-builder avatar

Stargazers

 avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.