isaacarnault

 ________  ________  ___  __    ___     
|\_____  \|\   __  \|\  \|\  \ |\  \    
 \|___/  /\ \  \|\  \ \  \/  /|\ \  \   
     /  / /\ \   __  \ \   ___  \ \  \  
    /  /_/__\ \  \ \  \ \  \\ \  \ \  \ 
   |\________\ \__\ \__\ \__\\ \__\ \__\
    \|_______|\|__|\|__|\|__| \|__|\|__|
                                                
                                        

isaacarnault

________  ________  ___  __    ___     
|\_____  \|\   __  \|\  \|\  \ |\  \    
 \|___/  /\ \  \|\  \ \  \/  /|\ \  \   
     /  / /\ \   __  \ \   ___  \ \  \  
    /  /_/__\ \  \ \  \ \  \\ \  \ \  \ 
   |\________\ \__\ \__\ \__\\ \__\ \__\
    \|_______|\|__|\|__|\|__| \|__|\|__|
                                            
Windows, gist was made on a Linux OS.

isaacarnault

 ________  ________  ___  __    ___     
|\_____  \|\   __  \|\  \|\  \ |\  \    
 \|___/  /\ \  \|\  \ \  \/  /|\ \  \   
     /  / /\ \   __  \ \   ___  \ \  \  
    /  /_/__\ \  \ \  \ \  \\ \  \ \  \ 
   |\________\ \__\ \__\ \__\\ \__\ \__\
    \|_______|\|__|\|__|\|__| \|__|\|__|
                                         
## log into your AWS Management Console

isaacarnault

I've put in place an Project Management cheat-sheet for those aiming to become Project Managers.

---

Question
answer

---

During which process group does the project manager orient team members to the project and expectations?
Executing

Your project seems to be going off track, so you take action to resolve the problem. In which project management process group are you working?

isaacarnault

These artefacts are intented to help you provision a SAP S/4HANA Public Cloud edition on AWS and to provision an AWS RDS (SQL Server database) along with our SAP installation.

---

The testing and GitHub documentation were technically performed by Isaac Arnault, EMEA Managing Director for Data, AI and Analytics at HUBIA (Consulting IT firm for Data, AI, BI and Analytics) in France.
This gist is mainly dedicated to HUBIA's Clients' teams and its prospective customers.

isaacarnault

 ________  ________  ___  __    ___     
|\_____  \|\   __  \|\  \|\  \ |\  \    
 \|___/  /\ \  \|\  \ \  \/  /|\ \  \   
     /  / /\ \   __  \ \   ___  \ \  \  
    /  /_/__\ \  \ \  \ \  \\ \  \ \  \ 
   |\________\ \__\ \__\ \__\\ \__\ \__\
    \|_______|\|__|\|__|\|__| \|__|\|__|
                                        
                       
                                        

isaacarnault

Cost considerations are based on a cluster running 5 hours daily on a monthly basis.

To estimate the monthly cost based on a Databricks cluster running for 5 hours daily, we'll need to consider the pricing for the Databricks cluster instance type (e.g., Standard_DS3_v2) and the number of nodes, as well as any associated Azure services like storage, Key Vault, and Azure AD integration. Let's break down the estimation:

• Databricks Cluster: Determine the hourly rate for the selected instance type and number of nodes. For example, let's say the hourly rate for a Standard_DS3_v2 instance is $0.5. Calculate the daily cost: 5 hours/day * $0.5/hour = $2.5/day Calculate the monthly cost: $2.5/day * 30 days = $75/month

• Azure Storage Account:

isaacarnault

 ________  ________  ___  __    ___     
|\_____  \|\   __  \|\  \|\  \ |\  \    
 \|___/  /\ \  \|\  \ \  \/  /|\ \  \   
     /  / /\ \   __  \ \   ___  \ \  \  
    /  /_/__\ \  \ \  \ \  \\ \  \ \  \ 
   |\________\ \__\ \__\ \__\\ \__\ \__\
    \|_______|\|__|\|__|\|__| \|__|\|__|                                       
                                        
                                        
You don't have to use packages such as datetime, timedelta, calendar.

isaacarnault

Data collection using Python

See output

isaacarnault

 ________  ________  ___  __    ___     
|\_____  \|\   __  \|\  \|\  \ |\  \    
 \|___/  /\ \  \|\  \ \  \/  /|\ \  \   
     /  / /\ \   __  \ \   ___  \ \  \  
    /  /_/__\ \  \ \  \ \  \\ \  \ \  \ 
   |\________\ \__\ \__\ \__\\ \__\ \__\
    \|_______|\|__|\|__|\|__| \|__|\|__|
                                  
SQL workbench. Use Oracle SQL Developer instead.
PL/SQL. Gist uses basic SQL syntax.