DEV Community: Henry

[Boost]

Henry — Wed, 05 Mar 2025 15:38:06 +0000

💡 Why Don’t People Know About Financial Investments?

Henry ・ Feb 21

💡 Why Don’t People Know About Financial Investments?

Henry — Fri, 21 Feb 2025 19:06:32 +0000

Lack of trust 🏦, high fees 💸, poor marketing 📢, and low financial literacy 📚 are key barriers. My Fishbone Analysis reveals the root causes and opportunities to bridge the gap. Let’s make investing accessible for all! 🌍

FinancialLiteracy #Investing #ProblemSolving #Innovation

Cloud-Data-Analysis-Growth

Henry — Sat, 08 Feb 2025 08:51:16 +0000

"Leveraging Azure Cloud Resources for Smarter Retail Decisions: The VisionMart Analytics Project"

Henry ・ Feb 8

"Leveraging Azure Cloud Resources for Smarter Retail Decisions: The VisionMart Analytics Project"

Henry — Sat, 08 Feb 2025 08:48:26 +0000

🚀🔍 I am Super excited to share my latest project: "VisionMart Retail Analytics" – a scalable, cloud-powered analytics solution designed to empower retail businesses with data-driven decision-making! 📊✨
🌍 Many businesses have the potential to scale, yet they crawl due to a lack of data awareness or fear of the financial burden of cloud resources.
But here’s the truth 👉 You can’t grow until you take the leap! 🚀
I’ve seen too many businesses hesitate, not because they lack potential but because they’re unaware of what data analytics can do. VisionMart is one of them—so I decided to take action! After all, this was also a chance for me to learn, experiment, and grow! 😃📊
💡 My slogan has always been:
🔥 "Start where you are, use what you have, and do what you can." 🔥
🎯 Project Goal:
🔹 Transform raw retail data into actionable insights
🔹 Help businesses optimize sales, customer retention & product performance
🔹 Leverage cutting-edge cloud technologies to scale intelligently
⚡ Tech Stack & Workflow:
✅ SQL Server → Azure SQL Database for centralized data storage 🏪
✅ Azure Data Factory for automated ETL & scheduled data refresh 🔄
✅ Databricks for data cleaning, transformation & predictive analysis 🧹📈
✅ Azure Blob Storage for structured analytics data 🗄️
✅ Power BI Dashboards for real-time, insightful business intelligence 📊🚀
📈 Scalability & Future Expansion:
As data volume & business complexity grow, the architecture is designed to scale seamlessly using Azure services:
🔹 Azure Synapse Analytics for handling large-scale data warehousing 🚀
🔹 Azure Machine Learning for advanced predictive analytics 🤖📊
🔹 Azure Event Hubs to enable real-time data streaming & insights ⚡
🔹 AI-Powered Recommendations to enhance customer personalization 🤯💡
🎯 The Best Part?
Instead of cleaning and prepping data in Excel or Power BI, 😅 all data transformations happen directly in Databricks using Python & SQL before storing it in Azure Blob Storage. This means Power BI handles only visualization – no heavy lifting, just sleek, interactive dashboards! 🚀📊
the goal is insight—not just numbers. And with Business Intelligence Analysts & Business Analysts, the data can undergo root cause analysis, gap analysis, and other techniques to drive better business decisions and growth.
🚀 Personal Growth & Takeaways:
This project challenged and expanded my skills in:
✅ Azure Cloud Resources & Scalability ☁️
✅ Data Engineering & ETL Pipelines ⚙️
✅ Data Analysis & Business Intelligence 📊
✅ Business Strategy & Decision-Making 💡
💡 Final Thoughts?
To every business owner out there:
💡 "Start where you are, use what you have, and do what you can!" 💡
🔥 Your next growth phase is just one data-driven decision away! 🔥

How to configure a Disk on a virtual machine from Azure Cloud and Install windows features using PowerShell.

Henry — Sun, 09 Jun 2024 12:13:37 +0000

*Step 1: Login to Azure portal *

_Click on virtual machines and create _

**Step 2:

a. Select the Azure subscription,
b. Create or select a unique resource group.
c. Create Virtual machine name
d. Select a region, if you require available options, select any but for this we need no redundancy.
e. Select Windows 10pro or any you wish
f. Create admin details (username and password)
g. Select port, RDP, HTTP because we will need to communicate to them
h. Mark licensing **__

Step 3 : Check the Disk information, ensure you select image default or choose anyone you wish
Better you leave it as default and click review and create

_Once Validation is passed as shown below “Click create”
_

_Once Deployment is completed, ‘Go to resource” _

Step 4: On the Virtual machine page , search for ‘Disk” under settings

_Give the Disk a name, and choose the size you desire, leave the remaining as default _
_Back to the VM overview page., connect the VM and select “Native RDP” _

_
Wait for the Public address to get configured and Download RDP file _

_Step 5: Connect to the VM on your local computer.
On your computer, Connect the Virtual Machine, this is how it will look below _

Insert your admin details.

_Leave the rest information as default, click yes _

_Step 6: Search for ‘Disk Management’ on your VM and an Initialize window will pop up, leave everything as default and select ok _

_
On the Disk2 tab , right click anywhere on it and select “ New simple volume” _

_Continue selecting the default options and click finish, until the Disk 2 is partitioned _

_Congratulations you have partitioned your Disk on your VM. _

**_Step 7: Lets install windows features on the VM through PowerShell.

Open PowerShell on your VM and ensure it is in “the name of your VM”
_**

Now enter this command “ Enable-WindowsOptionalFeature -Online -FeatureName IIS-WebServerRole”, click enter.

Once it is done. CONGRATULATIONS, YOU HAVE INSTALLED WINDOWS FEATURES AND MANAGEMENT TOOLS.

Now let’s confirm this by copying the IP address of the VM and paste it into our browser.

_CONGRATULATION, BELOW PAGE CONFIRMS YOU HAVE ATTACHED A DISK TO YOUR VM AND HAVE SUCCESSFULLY INSTALLED WINDOWS FEATURES. _

How to link your Blob file storage to Azure SQL database

Henry — Mon, 03 Jun 2024 18:27:23 +0000

Step 1: Login to Azure portal and search for storage accounts

**First we need to create a Blob file storage before we link it to our SQL database.

Step 2 : Create a file storage **

Select your subscription
Create a resource group or add from an existing one you have created before.
Create a storage account name
Select a region and ensure performance is set at “Standard”
Select Redundancy to Geo-redundant storage then click “Create”

_Leave other tabs as default, the main goal to create a file storage that can be sent to SQL database.
_

Once you click on resources, the below page shows, click on containers to create a file storage.

Step 3: Create a container to store our files such as excel files, csv or other files that can be used to store data.
Select “container access level” and click create.

Step 4: click on the container and upload any csv file or any file used to create, store dataset from your computer, then click “upload”.

Now we have BLOB storage container with a CSV file in it. Now let’s create an SQL database

**
Step 5 : Go to the Home page of the portal and search “SQL database” and click Create

Select Subscription and resource group( if you have created one before) in this case you can select the same resource group used to create the BLOB storage for this SQL database to ensure you have all resources for the activity in the same resource group.
Create a Database name and select a server or create a server
Ensure the storage redundancy is “geo-redundant storage” similar to the BLOB storage, leave other tabs has default and click “create”

Once your SQL Database has been deployed, go to the resource page of the database. And click “Query editor.
Enter your login details you created while creating your SQL database.

**_

Now we are going to create table heads of CSV file in the blob storage into this tables folder in the database for us to link the dataset later.

_**

Now save the query as “dataset” and congratulations, you have create a SQL database

Congratulations you have successfully created A Blob storage and A SQL database.

**
**

_Now lets link the storage file to the Database, _

**
Step 6: Go back home, and create “Data Factory” and create.
Select subscription, resource group such as the one for the data storage and SQL database.

Once you create and deploy, click on the resource for it and “launch studio”

Henry — Mon, 27 May 2024 11:51:49 +0000

*Step 1: Login to Azure portal and create a Virtual Linux Machine” *

Select resource group, name the VM , choose a region , select the image type “Ubuntu 22.04” or any latest.
Select password for authentication types and add details for authentication
For Public ports rules, allow all ports because we will be communicating with the VM through an IP address on powershell.
Then click review and create, wait for deployment and go to resource group.

*Click on the IP address to increase the idle timeout to max, to enable us communicate with it more without shutting down then save.
Go back to the VM and copy the IP address *

Step 3. Open powershell as admin on your computer and input this command
“ssh “your vm user name”@”IP address of the VM” . to establish communication.
Enter ‘yes”to continue, enter VM password

Now your VM has established communication, Now to install the engine, we have to enter the root of the VM to install the engine ,
Enter the command “sudo so”
Then include the command “apt update” to update any latest requirement, then “apt install nginx” enter Yes for confirmation

When its 100%, Congrats, you have installed the engine.

*Step 4: Go to the IP address, copy it and paste it onto a new tab. *

CONGRATS YOU HAVE SUCCESSFULLY INSTALLED NGINX INTO YOUR AZURE VM LINUX MACHINE

How to Connect an IoT field device(Raspberry Pi simulator) from the field to an Azure Cloud IoT Hub for communication and data.

Henry — Mon, 27 May 2024 11:30:00 +0000

Step 1. Login into your Account, search for “IoT Hub” and click create

Step 2. Create your IoT Hub by entering the necessary details(Resource group, Hub name, region), you can choose from a resource group which you have created or create another one , depending on your project. Continue through next, then review and create.

Then wait for deployment to be complete and go to resource.

Then check the IoT Hub details to confirm details., click on devices

*Step 3 : Create devices on the IoT devices hub *

*Create (Name, select “symmetric key”), and save *

*Click on the device and copy the “Primary connection string” and make sure it is enabled to IoT Hub to enable it communicate to the field device communication port. *

Then go to https://azure-samples.github.io/raspberry-pi-web-simulator/, insert the “Primary connection string from the IoT device on azure portal into “Line 15” on the raspberry pi simulator and click run button the red indicator on the raspberry pi must blink to confirm communication

Now from above you can see your raspberry pi simulator is communicating with the IoT device in azure portal and recording messages and data, now go back to the IoT hub Below shows the communication is established and everything is fine
CONGRATULATIONS, YOU HAVE CREATED AND CONNECTED AN IoT DEVICE FROM AZURE TO A FIELD DEVICE (RASPBERRY PI SIMULATOR).

How to host a Static Website on Azure App Service( Using Azure CLI)

Henry — Sun, 19 May 2024 18:30:34 +0000

*Step 1. Open Power shell on your computer *

*Step 2. Download Azure CLI for either “windows” or “Mac”
Go on Google, search for “Download Azure CLI” for your computer version and install it *

*Step 3; After Installation, open “Power shell” and login into Azure portal by entering the command below
“az login” , then “check your default browser, a window is meant to be open for you to login to azure portal. *

*Step 4: After Login, the above pictures shows, then proceed back to power shell to confirm you are logged in *

Step 5: Create a resource group or use an existing resource group which you have already created
To create a resource group on power shell, enter the command below ** **_“az group create –name “Resourcegroup” –location “eastus” _

**
Step 6: Create a Web service plan, by entering the code **
_“az appservice plan create –name WebPlan –resource-group “Resourcegroup” _

Step 7: Create a Web Application to run **
**“az webapp create –name “MyWebApp” – resource-group “Resourcegroup” –plan “WebPlan” “

*Step 8: Check Azure portal, click on App service on the home page, check the empty website if its running *

Step 9: Check if the empty web app is running , click on “Default domain” or copy the link and paste in a browser

Then back in webapp service in the azure portal, search for “advance tools” and click “Go”
To access the back end of the hosting service.
Then Click “Debug console” and select “CMD

*Then navigate to raw file page *

*Then edit the above raw code, by inserting the raw code of the website you want to host from an IDE into this page.
And save
Step 10 : Then go back to the empty web page and refresh Congratulations, you have hosted a web page on AZURE PORTAL *

How to create "Code Resume"using index.html from Git-Bash to Git-Hub

Henry — Sat, 04 May 2024 19:41:13 +0000

Step 1. Create a New file or directory on your computer Desktop and name it “My resume”

Step 2: Open the folder, right click and Open Git-bash here, a new window will open
“MINGW64:/c/Users/lenovo/Desktop/My resume”--- for example

Step 3: Create a text file by entering the command
“cd touch file1”

Step 4 : Get a sample Index.html resume from chatgpt and copy the code

Step 5 : On your Git-bash, Enter the command

“vim file1” – To enter the file for editing

“Press ‘I’ “ – To insert a text or code such as the Index.html sample resume

Insert the index.html code from chatgpt

Press “ESC” – To stop inserting
Press “Shift+ colon(:)” – to end the process
Press “ W” – To save your work or “wq” --- To save and exit the file.
Then press “enter” to take you back to bash.

Step 6: Configure your identity in git-bash
Enter the command – “git config – global user.name “Name”
Then press enter
Enter the command – “git config – global user.email “email”
Then press enter

Step 7 : Initialize the git file
Enter the command “git init”

**Step 8: **Go to your github account, login and find the “+” on the top right corner and create a new repository

Give it a name “ Resumerepo” and click “create repository”

Next, Click on the “Code button” and copy the “HTTPS Code”

Step 9 : Git Clone

Enter the command – “git remote add origin “(insert the HTTPS code from github here)”
Enter the command – “git remote add origin https://github.com/busyhenrybrain14/Resumerepo.git

Press Enter

Lets Check the status of our file so far
Enter the command – “ git status”

Untracked files tells us that Git can’t track our file , we need to add it to a staging area to track the file
Enter the command – “git add .” and check the status again by entering “git status”

Now our file is staged.

Step 10: Commit our file to prepare it to be sent to github
Enter the command – “ git commit –m “(commit comment)”
Enter the command – “ git commit –m “Commiting Resumepo”

Now push to Git-hub
Enter the command --- “git push origin master”

Go back to Github and click “ compare & pull request”

_
Congratulations your resumerepo is on github **___**

Back on your desktop folder , open the folder and the file to see your “Index.html resume code” and confirm with the one on Github

How to create a Virtual Machine on Azure Portal

Henry — Tue, 30 Apr 2024 13:21:30 +0000

Step 1: Visit Azure Portal, and make sure you have an account either free account, student account or organization account and login

After login with your details, below is how your azure dashboard looks like.

Step 2. There are different ways to create a virtual machine in Azure

By searching on the search bar “Virtual machine”, select Virtual machines Or From the Dashboard, Select “Virtual Machines” and click “Create”. Select Azure Virtual Machine ( if creating for the first time ) or “Azure Virtual Machine with present configuration if you already have established a configuration before. *Step 3. * On the create page, under the “Project Details”
Select your subscription, if you have a free account, it will be selected as default, if its organization, select your organization subscription.
Select a resource group, if you don’t have a resource group, “Create new”. **Step 4: **Instance Details section, Under this,
Name your Virtual Machine,
Select a region where you want your VM to be supplied
Select an availability option, this enable you have multiple zones where your VM can be deployed
Select the “Image”, in this case this is the type of Computer you want as a VM, select any of your choice, (Windows, 10, Windows 10pro Ubuntu, etc) *Step 5: **Administrator Account – This is the Username and password for your VM, whenever you want to access your VM (Which in order words, a Virtual Computer). **Step 6: **Inbound port rules, check “Allow selected ports” to create multiple ports to access your VM. Then Under Licensing, “Check the Box to confirm eligibility windows you choose”. **Step 7: * Next Click on “Monitoring Tab”
You are enable alerts for your VM, to get report or updates on your resource
Under diagnostic, you can enable with storage, depends on the purpose of your VM But for this VM, I will disable Boot diagnostic, because this is just a sample process to create a VM.. Step 8. Networking, Click on the Networking Tab and create a Network for the VM for it to be accessible,
Select the default address space and Subnets, then click “Ok”. Step 9. Tag Tab, Create a “Tag” for your VM. Then Click Review and Create After Review and create, the below screen will pop up, to indicate “Validation passed”, then click “Create”. Once your VM is deployed, the next notification is “Your deployment is complete”

Congratulations, you have successfully created a VM on Azure portal.
Then click on “Go to resource”, because this VM is a resource, in order to access it we need to go resource page.

Above is our VM resource page

Step 10: Click on “Connect” to access connect to our VM.

On the VM connect screen, we can see ( the public IP address for the VM , Name and other details)
There are other ways to connect to VM, but for this “Select” Native RDP Local Machine”. 3.Wait until the Public IP Address has been configured. After configuration, Close the page and Download the RDP FILE Step 11. Download the RDP FILE and open it
Connect to the remote DESKTOP connection
Enter the password we gave the VM at the beginning Congratulations, you have created your first VM in Azure.