Data Analytics Portfolio

Hi, I'm Vikas.

Data Analyst | BI Analyst | Reporting Specialist

Melbourne, Australia · Open to Data / BI / Reporting roles across Australia

I help teams make better decisions using clean data, clear dashboards, and focused analysis. I enjoy taking projects from raw data and SQL queries through to Power BI reports, forecasts, and practical business insights.

View Projects Contact Me Download Resume
SQL Power BI Python Tableau
Photo of Vikas

Skills

A snapshot of the tools and techniques I use most often.

Data & Querying

  • SQL (PostgreSQL, MySQL, Snowflake)
  • Data cleaning & transformation
  • Joins, aggregations, window functions
  • Data modelling & validation

Analytics & BI

  • Power BI (DAX, data models)
  • Tableau dashboards
  • Excel (pivot tables, lookups)
  • Reporting & KPI tracking

Programming

  • Python (Pandas, NumPy, Matplotlib, Seaborn)
  • R for stats & time series
  • Jupyter & RStudio
  • Git & GitHub

Methods & Domain

  • Exploratory data analysis (EDA)
  • Time series forecasting (ARIMA)
  • Experimentation & hypothesis testing
  • Stakeholder reporting & communication

Projects

A selection of data and analytics projects demonstrating my approach to problem solving, analysis, and communication.

Power BI · Reporting

Retail Sales Performance Dashboard

An end-to-end retail analytics dashboard in Power BI, built from raw transactional data to help track revenue, profit, product performance, and regional trends.

  • Cleaned and modelled sales data for reporting in Power BI.
  • Designed KPIs: revenue, profit, orders, AOV, and margin%.
  • Enabled quick identification of top products contributing ~60% of revenue.

Stack: Power BI, Excel, Power Query, DAX

View on GitHub • Dashboard PDF & PBIX available in repo
Python · SQL · Tableau

Audiobook Pricing & Ratings Analysis

Analysis of audiobook metadata to understand how pricing and content features relate to ratings and potential sales performance.

  • Used SQL and Python to clean and shape audiobook datasets.
  • Explored relationships between price, length, category, and ratings.
  • Highlighted pricing bands and categories linked to higher average ratings.

Stack: Python (Pandas), SQL, Tableau, PostgreSQL

View on GitHub
R · Time Series

US Military Spending Time Series Forecasting

Time series analysis of 60+ years of US defence budget data to forecast future spending and understand long-term trends.

  • Converted historical budget data into a time series structure.
  • Performed stationarity tests and fitted ARIMA models.
  • Produced 10-year forecasts with confidence intervals for scenario planning.

Stack: R, forecast, tseries, ggplot2

View on GitHub

About

A bit more about my background and how I work.

I'm a data analyst based in Melbourne with experience in research, IT support, and analytics internships. I enjoy working across the full data lifecycle: gathering requirements, cleaning and modelling data, building dashboards, and presenting insights to stakeholders.

My recent work includes supporting academic research at RMIT, resolving data-related issues in IT service environments, and building analytics solutions that reduce manual effort and improve reporting accuracy.

I’m focused on Data Analyst, BI Analyst, and Reporting Analyst roles where I can combine SQL, BI tools, and clear communication to help teams make evidence-based decisions. I’m based in Melbourne and open to roles across Australia.

Education

Master of Data Science
RMIT University

Bachelor of Technology
Kurukshetra University

Certifications

  • Google Data Analytics Professional Certificate
  • Python Data Structures (Coursera)

Contact

If you'd like to discuss an opportunity or just connect about data and analytics, feel free to reach out.

Say hello

Email is usually the best way to reach me.

nitesh.vikas11@gmail.com

Elsewhere