Messy spreadsheets
Your important business information is spread across several Excel or Google Sheets files.
Data Analytics & Automation
Turn Your Business Data Into Clear Decisions
I help small businesses organise their data, automate repetitive reports, and build dashboards that make performance easier to understand.
Dashboards · Data Analysis · Reporting Automation · AI Workflows
Analytics Overview
March 2026
Monthly Revenue
€24,850
↑ 8.2% vs last month
Conversion Rate
3.8%
↑ 0.4 pts
Sales Trend
Last 12 weeks
Best Product
Premium Bundle
142 units sold
Active Customers
1,284
Is Your Business Data Difficult to Understand?
Manual reporting
Your team spends hours preparing the same weekly or monthly reports.
Unclear performance
You collect data but still struggle to understand what is working and what needs attention.
Disconnected tools
Your sales, marketing, customer, and operational data are stored in different systems.
I turn these disconnected numbers into one clear reporting system.
Data Services Built for Small Businesses
Practical analytics solutions designed for businesses that need clearer reporting without building a large in-house data team.
Business Data Audit
I review your current spreadsheets, reports, metrics, and reporting process to identify problems and improvement opportunities.
- Data quality review
- KPI recommendations
- Reporting process review
- Automation opportunities
- Action plan
Dashboard Development
Custom dashboards that help you monitor the numbers that matter most to your business.
- Power BI dashboards
- Excel dashboards
- Sales reporting
- Marketing dashboards
- Customer and operational metrics
Reporting Automation
Replace repetitive manual reporting tasks with reliable and automated workflows.
- Python automation
- Excel report automation
- Data cleaning workflows
- Scheduled reports
- CSV and spreadsheet processing
Data Analysis and Insights
I analyse business data to identify trends, problems, opportunities, and recommendations.
- Exploratory data analysis
- Customer behaviour analysis
- Product performance
- Marketing analysis
- Forecasting and trend analysis
AI Workflow Solutions
Practical AI tools that support reporting, internal knowledge, and repetitive business tasks.
- AI reporting assistants
- Internal business chatbots
- Automated summaries
- Document analysis
- Custom AI workflows
Who I Help
E-commerce
- Sales dashboards
- Product profitability
- Customer trends
- Marketing performance
- Inventory reporting
Marketing agencies
- Client reporting
- Campaign dashboards
- Lead tracking
- Advertising performance
- Automated monthly reports
Logistics and operations
- Delivery performance
- Delay tracking
- Order reporting
- Operational KPIs
- Workflow analysis
Startups and small businesses
- KPI definition
- Investor-ready reporting
- Business performance dashboards
- Data organisation
- Process automation
Selected Analytics Projects
Examples of dashboards, forecasting systems, and reporting workflows I have built.
Forecast Model Comparison
Walk-forward backtestElasticNet
RMSE 0.042
LightGBM
RMSE 0.038
LSTM
RMSE 0.045
Portfolio Allocation (MPT)
Stock Forecasting and Investment Decision Support System
A web-based investment decision-support platform combining machine-learning forecasting with portfolio optimisation.
- Built and compared ElasticNet, LightGBM, and LSTM forecasting models
- Created an ensemble forecasting framework
- Used Modern Portfolio Theory for portfolio optimisation
- Applied Ledoit-Wolf covariance estimation
- Evaluated models using RMSE, MAE, MASE, and directional accuracy
- Used walk-forward backtesting to reduce look-ahead bias
PythonPandasNumPyScikit-LearnTensorFlowLightGBMReact
Campaign Performance
Impressions
248K
+12%
Clicks
8.4K
+6%
Conversions
312
+9%
Cost
€2,180
-3%
Conv. Rate
3.7%
+0.2
Marketing Performance Dashboard
A central dashboard designed to help a digital marketing team monitor campaign performance and make faster optimisation decisions.
- Combined multiple campaign metrics
- Tracked weekly performance
- Monitored more than five key metrics in one view
- Highlighted trends and optimisation opportunities
- Supported better budget allocation decisions
ExcelPythonPandasData Visualisation
Reporting Pipeline
Extract
Clean
Transform
Report
SQL Queries
12 active
Records Processed
48,291
Automated Business Reporting Pipeline
A Python and SQL reporting workflow that cleans, validates, transforms, and prepares business data for analysis.
- SQL queries using joins, CTEs, aggregations, and window functions
- Automated data-processing scripts
- Data validation and cleaning
- Exploratory analysis
- Stakeholder-ready reports and visualisations
PythonSQLPandasNumPyExcel
A Simple Process From Data to Decision
Understand
We discuss your business, current reporting process, available data, and the decisions you need to make.
Review
I inspect your data structure, identify quality issues, and recommend the most useful solution.
Build
I create the dashboard, analysis, or automation workflow and share progress during development.
Deliver and Support
You receive the completed solution, documentation, and guidance on how to use it.
Monthly reporting and ongoing dashboard support are also available.
About Muhammad Niyas
Muhammad Niyas is a data analyst based in Kaunas, Lithuania, with international experience in data analysis, digital marketing analytics, automation, and live sports data quality.
He has worked with SQL-driven reporting, Python analytics pipelines, dashboard development, exploratory data analysis, machine-learning forecasting, and stakeholder reporting.
Muhammad completed a Bachelor's degree in Informatics Systems at Vytautas Magnus University. His final project combined machine-learning forecasting models with Modern Portfolio Theory to create an investment decision-support platform.
His approach is focused on understanding the business problem first and then creating a practical solution that stakeholders can use.
- Data Analyst Intern at Gecora, Slovakia
- Data Analyst Intern at Nurture Spark Digital, Dubai
- Sports Statistician at Genius Sports
- BSc in Informatics Systems
- AI for Business Analytics studies
Tools and Capabilities
The technologies and methods I use to organise data, build dashboards, and deliver practical insights.
Data and programming
PythonPandasNumPySQLScikit-LearnTensorFlow
Analytics
Exploratory data analysisA/B testingCohort analysisChurn analysisRetention analysisForecastingKPI development
Reporting and visualisation
Power BIExcelGoogle SheetsMatplotlibBusiness dashboards
Development tools
ReactGitGitHubJupyter NotebookVS Code
What Clients Can Expect
Professional, practical support focused on helping you understand and use your business data.
Clear communication
Regular updates in plain language, without unnecessary jargon.
Practical recommendations
Suggestions focused on what your business can actually use.
Reliable data handling
Careful treatment of your data with attention to quality and accuracy.
Simple explanations
Complex analysis explained in a way stakeholders can understand.
Solutions designed around business needs
Every deliverable shaped around the decisions you need to make.
Ready to Make Better Use of Your Business Data?
Tell me about your current reporting challenges, and I will help you identify a practical next step.
No technical knowledge is required. Explain the problem in simple words, and we can identify the right solution together.