Skip to main content
Image
By Asna

My Portfolio

📊 Small Business Sales Dashboard
Excel • SQL • Power BI

Cleaned messy data, used Excel formulas & pivot tables, and built a Power BI dashboard for a grocery shop.

🔗 View Project
🧾 Inventory Database Design
SQL • ER Diagram • SQLite

Designed an efficient relational database to manage stock items with foreign keys, triggers, and views.

🔗 View Diagram
📁 Freelance Project Tracker
Excel • Data Cleaning

Created an Excel workbook to help freelancers manage deadlines, earnings, and project priorities.

🔗 See Screenshot

Popular posts from this blog

By Asna
Fixing Slow Database Performance | Why Is Your Database So Slow? How to Fix It If your business database is running slower than expected , it can affect customer satisfaction and workflow efficiency. Let’s explore why databases slow down and how to fix performance issues fast! Pain Point: Slow database performance impacts your applications and delays data retrieval. 💡 Common Causes of Slow Databases 🔹 Inefficient SQL Queries – Queries that scan unnecessary rows slow down responses. 🔹 Missing Indexes – Without proper indexing, searching through data takes longer. 🔹 Large Data Volumes – Too much unarchived data can cause delays. 🔹 Hardware or Server Limitations – A slow CPU or memory issues affect performance. How to Improve Your Database Speed Optimize SQL Queries – Use EXPLAIN to analyze execution plans and remove inefficient joins. ...
Post a Comment
Read more