Featured Work

Reporting, BI & SQL Projects

Selected work showing dashboard design, KPI reporting, DAX, data modeling, SQL-supported analysis, clean documentation, and business-facing presentation.

Sales Analysis Power BI dashboard preview
Power BI Case Study Sales Reporting

Sales Analysis — Power BI Dashboard

Business-facing sales reporting project focused on executive KPI visibility, trend analysis, and interactive exploration by product, customer, and time period.

  • Designed a reporting model around sales performance, customer behavior, and time-based analysis.
  • Used DAX measures, guided navigation, drill-through, and tooltips to support self-service exploration.
  • Documented the dashboard as a BI case study with a live report and supporting GitHub repository.
Power BI DAX Data modeling KPI reporting Dashboard design
Live Dashboard GitHub Repo
Maven Airline loyalty program Power BI dashboard preview
Power BI Case Study Customer Analytics

Maven Airline — Loyalty Program Analysis

Interactive Power BI analysis of loyalty activity, customer value, retention patterns, and program performance for business decision support.

  • Built a report structure that turns customer and loyalty questions into clear pages and views.
  • Applied reusable DAX measures for customer value, segmentation, activity, and retention-oriented metrics.
  • Focused on usability through app-style navigation, clean visuals, and business-friendly explanations.
Power BI DAX measures Retention analysis Customer value Interactive reporting
Live Dashboard GitHub Repo
AdventureWorks2022 SQL Query Portfolio 32 documented T-SQL exercises completed through structured training with Microsoft's AdventureWorks2022 sample database. Positioned as supporting technical evidence for SQL querying, joins, aggregations, conditional logic, and readable documentation. 
-- Exercise: summarize products by sales order
SELECT
    A.[SalesOrderID],
    SUM(A.[LineTotal]) AS [Line Total Sum],
    STRING_AGG(B.[Name], ', ')
        WITHIN GROUP (ORDER BY B.[Name]) AS [Product Names]
FROM [AdventureWorks2022].[Sales].[SalesOrderDetail] AS A
INNER JOIN [AdventureWorks2022].[Production].[Product] AS B
    ON A.[ProductID] = B.[ProductID]
GROUP BY A.[SalesOrderID]
HAVING SUM(A.[LineTotal]) > 5000;
SQL Evidence 32 Documented Exercises

SQL Practice Portfolio — Querying, Joins, Aggregation & Documentation

  • Completed and organized 32 numbered SQL files covering filtering, aliases, derived columns, text/date functions, NULL handling, and CASE expressions.
  • Practiced INNER and OUTER JOINs, UNION, aggregate functions, GROUP BY, HAVING, and STRING_AGG through progressively more complex exercises.
  • Standardized files with readable formatting, descriptive aliases, concise documentation, and AdventureWorks2022-compatible references.
SQL Server T-SQL AdventureWorks2022 Joins Aggregations Query documentation
View SQL Files

Technical Foundation

Skills for reporting, BI, and business analysis

Keyword coverage is kept practical and tied to visible project evidence, training, and professional experience.

BI & Visualization

Dashboard design, KPI reporting, report navigation, and business-facing data storytelling.

Power BI DAX KPI design Dashboard UX Power BI Service

Data & Modeling

Data preparation, model structure, SQL querying, and clean semantic-model thinking for reports.

SQL / T-SQL Power Query Star schema Data validation ETL/ELT concepts

Analysis & Business

Turning stakeholder questions into measurable KPIs, analysis views, and documented recommendations.

Requirements notes Trend analysis Customer analysis Operational reporting Documentation

Tools & Workflow

Practical reporting workflow using Microsoft tools, GitHub documentation, and validation-first habits.

Excel GitHub Tabular Editor ALM Toolkit Microsoft 365

Credentials

Certifications, training, and education

Kept concise so the page reads like a portfolio first, with credentials supporting the project evidence.

Microsoft PL-300

Power BI Data Analyst certification supporting the reporting and BI direction.

  • Power BI reporting
  • Data modeling
  • DAX and analysis

Bachelor's — MIS

Management Information Systems / Business Computing background connecting technology, data, and business processes.

  • Business systems
  • Data and reporting
  • Technology management

Advanced DAX

Additional DAX training for measures, filter context, time intelligence, and reusable calculations.

  • Measures
  • Filter context
  • Time intelligence

SQL for Data Analysis

SQL and T-SQL training focused on querying, cleaning, aggregating, and preparing data for reporting.

  • Joins and filters
  • Aggregations
  • Reporting queries

Professional Background

Business-systems experience used as an analytics advantage

IT support is presented as supporting context, not the main portfolio focus.

Systems context, troubleshooting, and communication

My IT support experience helps me understand the operational side of reporting: users ask unclear questions, systems produce messy data, documentation matters, and dashboards need to be understandable by non-technical stakeholders. That background supports requirements discovery, data-quality investigation, application support, and stakeholder communication.

Microsoft 365 Active Directory Ticketing systems Business applications Client communication Troubleshooting

Contact

Open to data, reporting, and BI conversations

Open to Reporting Analyst, Power BI Analyst, Data Analyst, Business Intelligence Analyst, Business Data Analyst, Operations/Data Analyst, and related roles where reporting, business systems, documentation, and stakeholder support matter.

Email Adam Data Analyst Resume LinkedIn GitHub

For IT-focused opportunities, a separate IT Support Resume is also available.