🎯 Data Analyst & Business Intelligence Developer specializing in Microsoft and Google ecosystems
💡 Data Trainer & Content Creator focused on Excel, Power BI.
🚀 Transforming raw data into actionable insights through advanced analytics and custom business solutions
📊 Experienced in building end-to-end data solutions from ETL to visualization
|
Power BI | Power Query | DAX The project demonstrates advanced Power BI modeling techniques including dynamic pagination, ranking systems, time-intelligence calculations, and interactive filtering mechanisms that allow users to drill down into specific cities and neighborhoods with ease. |
|
Power BI | Power Query | DAX The project demonstrates advanced Power BI capabilities including DAX measure development, Power Query transformations, calculated tables, dynamic filtering, and interactive visual design to deliver actionable insights from raw CSV data. |
|
Sql | Sql Server This project provides a comprehensive analysis of US baby names data using SQL. It explores naming trends over time, gender distribution, popularity rankings, and historical patterns across states and regions. |
|
Sql | Sql Server Analyze order data to identify the most and least popular menu items and types of cuisine. |
|
Google Sheets | lookerstudio This Coffee Shop Sales Report provides insights into daily and hourly transactions, highlighting peak sales periods. It breaks down revenue by product category, showing top-selling items like coffee and tea. Monthly revenue trends are also tracked to monitor growth and support business decisions. |
|
Google Sheets | lookerstudio This interactive visualization presents global CO2 emissions data through multiple perspectives: a world map showing geographic distribution, a scatter plot analyzing the relationship between population and emissions with per capita metrics, and a time-series chart tracking each country's share of global emissions over time. The dashboard enables users to explore emission patterns across countries, revealing disparities in per capita contributions and historical trends in carbon footprints. This comprehensive tool helps identify major emitters and understand how emission responsibilities have shifted globally over the years. |
| Tool | Technology | Description | Link |
|---|---|---|---|
| HTML Excel Form | JavaScript + Excel | web Form for data entry in excel | View |
| VBA-Material-Design | VBA + Excel | VBA Material Design in excel | View |
✅ Build interactive dashboards and reports
✅ Automate repetitive tasks and workflows
✅ Design custom business systems
✅ Optimize data processes and ETL pipelines
✅ Provide training on BI tools
✅ Consulting on data strategy
If you find my projects helpful, consider:
⭐ Star repositories you like
❤️ React to my LinkedIn posts
📺 Subscribe to my YouTube channel
📤 Share my content with your network
☕ Buy me a coffee (https://linktr.ee/ahmedsamir00003)
"Data is the new oil, but insights are the new gold."