I’m Aschale Ambissa Bidika, an analytical and results-driven IT academic and data analyst based in Assosa, Ethiopia. I have 10 years of higher-education teaching experience at Assosa University, and I enjoy turning complex data and technical requirements into clear learning experiences and practical, reliable solutions for real users. Alongside my faculty work, I also do hands-on freelance analytics and dashboard automation—building dynamic spreadsheets, automated reporting workflows, and structured datasets that help businesses track performance and make better decisions. I bring strong leadership experience from serving as Head of the Department of Information Technology, with a focus on curriculum management, system administration, and end-to-end data processing.…

Aschale Ambissa Bidika

I’m Aschale Ambissa Bidika, an analytical and results-driven IT academic and data analyst based in Assosa, Ethiopia. I have 10 years of higher-education teaching experience at Assosa University, and I enjoy turning complex data and technical requirements into clear learning experiences and practical, reliable solutions for real users. Alongside my faculty work, I also do hands-on freelance analytics and dashboard automation—building dynamic spreadsheets, automated reporting workflows, and structured datasets that help businesses track performance and make better decisions. I bring strong leadership experience from serving as Head of the Department of Information Technology, with a focus on curriculum management, system administration, and end-to-end data processing.…

Available to hire

I’m Aschale Ambissa Bidika, an analytical and results-driven IT academic and data analyst based in Assosa, Ethiopia. I have 10 years of higher-education teaching experience at Assosa University, and I enjoy turning complex data and technical requirements into clear learning experiences and practical, reliable solutions for real users.

Alongside my faculty work, I also do hands-on freelance analytics and dashboard automation—building dynamic spreadsheets, automated reporting workflows, and structured datasets that help businesses track performance and make better decisions. I bring strong leadership experience from serving as Head of the Department of Information Technology, with a focus on curriculum management, system administration, and end-to-end data processing.

See more

Skills

Experience Level

Microsoft Excel
Expert
Data Visualization
Expert
SQL
Expert
Python
Expert
CRM
Expert
Microsoft Office
Expert
DaVinci Resolve Studio
Expert
Adobe InDesign
Expert
Microsoft PowerPoint
Expert
Microsoft Word
Expert
Java
Intermediate
Tableau
Intermediate
Power BI
Intermediate
PHP
Intermediate
Node.js
Intermediate
MySQL
Intermediate
HubSpot
Intermediate
HTML5
Intermediate
Google Drive
Intermediate
C++
Intermediate
Audacity
Intermediate
See more

Language

English
Fluent
Amharic
Fluent

Work Experience

Data Analyst & Dashboard Specialist at Upwork (Freelance)
January 1, 2025 - Present
Engineered interactive spreadsheets, dynamic financial tracking models, and automated reporting systems using Excel and Google Sheets for international clients. Managed data entry, transformation, and cleaning to reduce errors and deliver structured datasets for analysis. Developed custom Excel VBA scripts and complex formulas to automate routine administrative and financial reporting tasks, improving speed and consistency of deliverables.
Freelance Data Entry & Excel Expert at Assosa University
August 18, 2022 - November 25, 2025
Lecturer of IT & Former Department Head at Assosa University — Department of Information Technology
January 1, 2016 - Present
Served as Head of the Department of Information Technology, leading curriculum revisions, managing course allocations, and overseeing department administration. Prepared and delivered lectures and lab courses in Database Management, System Analysis & Design, Computer Networking, and Information Security. Supervised 50+ senior capstone projects, guiding students through software development life cycles, database architectures, and IT research methodology. Supported operational and technical needs across teaching and administration, including end-to-end data processing and student advisement.

Education

M.Sc. Information Technology at Bahir Dar University
January 11, 2030 - January 1, 2022
B.Sc. Information Technology at Haramaya University
January 11, 2030 - January 1, 2019
Master of Science (MSc) in Information Technology at Assosa University, College of Computing & Informatics
January 11, 2030 - September 24, 2026
Bachelor of Science (BSc) in Information Technology at Assosa University, College of Computing & Informatics
January 11, 2030 - September 24, 2026

Qualifications

Microsoft Azure
September 21, 2025 - August 31, 2029

Industry Experience

Software & Internet, Professional Services, Education, Computers & Electronics, Financial Services
    Sales and Pricing Data Analysis using Pivot Tables
    This project uses Microsoft Excel Pivot Tables to quickly extract and summarize key business insights from raw sales data. Three distinct pivot tables were generated to answer specific questions: ✅Regional Sales Analysis: Determined that the East region has the highest total sales (20,882). ✅Product Pricing Analysis: Identified the Mouse as the cheapest product overall with an average unit price of 23. This table also shows how the average unit price varies by region. ✅Salesperson Performance: Pinpointed Olivia as the salesperson who sells the most Laptops (7,120 in total sales). Skills and deliverables ✅Data Analysis ✅Microsoft Excel ✅Pivotal Software Pivotal Tracker ✅Data Analysis Expressions ✅Interactive Data Visualization…
    Google Sheets Dashboard Comparative Sales Analysis
    This project demonstrates an advanced Google Sheets interactive dashboard used to compare sales performance across Government and Private business segments. It includes dynamic filters, automated KPIs, and multiple visual charts to help businesses easily monitor and analyze their sales data. ✅Dashboard Highlights: ✅Dynamic slicers/filters (Year, Segment, Country, Product, Discount Band) ✅Real-time KPIs: Gross Sales, Discount, Net Sales, Profit ✅Trend visualization using Net Sales by Month ✅Profit by Country donut chart for geographic insights ✅Net Sales by Segment comparison using bar charts ✅Profit by Product waterfall-style visualization ✅Automated calculations sourced from structured tables ✅Fully interactive layout suitable for management reporting This dashboard showcases my ability to transform raw business data into clean, interactive, and insightful visual reports using Google Sheets. Skills Used ✅Google Sheets ✅Dashboard Design ✅Data Analysis ✅Data Visualization ✅Pivot Tables ✅Google Sheets Slicers & Filters ✅Formulas & Functions (LOOKUP, QUERY, ARRAYFORMULA) ✅Business Reporting ✅Spreadsheet Automation ✅Sales & Financial Analysis…
    An Excel Dashboard Profit Trends by Region and Product
    This project showcases a fully interactive Excel dashboard designed to analyze Profit Trends by Region and Product across Africa. It includes dynamic slicers, automated charts, and clean visual layouts that allow users to filter data by Region and Product instantly. Key features of the dashboard: ✅Region-based and product-based interactive slicers ✅Gross sales and profit breakdowns ✅Dynamic bar charts, line charts, and comparison visuals ✅Automated calculations using formulas and pivot tables ✅Clean, professional layout suitable for business presentations ✅Easy-to-understand insights for decision-makers This dashboard demonstrates my ability to create clean, automated, and visually appealing Excel dashboards that help clients turn raw data into actionable insights. Skills Used ✅Microsoft Excel ✅Excel Dashboards ✅Pivot Tables & Pivot Charts ✅Data Analysis ✅Data Visualization ✅Power Query (if needed) ✅Chart Design ✅Data Cleaning ✅Business Intelligence (BI) ✅Reporting & Automation…
    Data Cleaning and Standardization
    This project focuses on transforming a raw, inconsistent dataset ("Before") into a structured, analysis-ready format ("After"). The "Before" data exhibits common issues like mixed case, non-standard. The "After" state shows the results of a comprehensive data cleaning process: names are standardized the Case, ages are consistently numeric, email addresses are corrected to standard domains, and country names are standardized and made distinct using conditional formatting (color-coding). This transformation ensures data quality and prepares the information for reliable reporting and analysis. Key Data Skills Used: ✅Data Quality Assessment & Profiling ✅Data Cleaning/Wrangling ✅Data Standardization ✅Data Structure/Preparation ✅Data Visualization & Formatting ✅Microsoft Excel…