Tools, examples and practice

Projects and demos.

My own products, demonstrations and practice projects. Each one is labelled so you can see the kind of work behind it.

ReportDesk, Messy Excel and CSV files turned into a clean table and report pack on your own computer.

Messy Excel and CSV files turned into a clean table and report pack on your own computer.

#Excel#Data Cleaning

Scan to Excel, Photos and scans of tables turned into one clean Excel sheet, offline.

Photos and scans of tables turned into one clean Excel sheet, offline.

ReportForge, An Excel valuation model turned into a PowerPoint deck with charts, tables and commentary.

An Excel valuation model turned into a PowerPoint deck with charts, tables and commentary.

#valuation#powerpoint-automation

SeamCheck, Compare product records across two systems and see which differences need attention.

Demo on made up dataLive demo

Compare product records across two systems and see which differences need attention.

Sales Analytics, PostgreSQL to Power BI, A sales dashboard built from 60,000 generated rows in a PostgreSQL database.

Demo on made up data

Sales Analytics, PostgreSQL to Power BI

A sales dashboard built from 60,000 generated rows in a PostgreSQL database.

#PostgreSQL#Power BI

Retail Sales and Inventory, Python generated sales and inventory data explored in an Excel dashboard.

Demo on made up data

Retail Sales and Inventory

Python generated sales and inventory data explored in an Excel dashboard.

#Retail Analytics#Excel Dashboard

Chicago Crime Data Analysis, A Power BI dashboard for exploring public crime records by place, type and time.

Built on public data

Chicago Crime Data Analysis

A Power BI dashboard for exploring public crime records by place, type and time.

#Power BI#Crime Data Analysis

Mortgage Refinance Calculator, A Google Sheets dashboard for comparing example mortgage and refinance figures.

Practice project on sample dataLive demo

Mortgage Refinance Calculator

A Google Sheets dashboard for comparing example mortgage and refinance figures.

#Google Sheets#Mortgage Calculator

Mobile Sales Dashboard, A Power BI practice dashboard for sales, locations and year over year comparisons.

Practice project on sample data

Mobile Sales Dashboard

A Power BI practice dashboard for sales, locations and year over year comparisons.

#Power BI#Sales Dashboard

HR Attrition Dashboard, A Power BI practice dashboard for exploring sample workforce and attrition records.

Practice project on sample data

HR Attrition Dashboard

A Power BI practice dashboard for exploring sample workforce and attrition records.

#HR Analytics#Employee Attrition

Gross Profit Dashboard, A Power BI practice dashboard comparing sample profit figures over time.

Practice project on sample data

Gross Profit Dashboard

A Power BI practice dashboard comparing sample profit figures over time.

#Power BI#Gross Profit Dashboard

Manufacturing and Downtime Dashboard, An Excel practice dashboard for sample production, downtime and cost records.

Practice project on sample data

Manufacturing and Downtime Dashboard

An Excel practice dashboard for sample production, downtime and cost records.

#Manufacturing Analytics#Downtime Analysis

Excel Stock Tracker, An Excel practice tracker with dashboard views and refresh macros.

Practice project on sample data

Excel Stock Tracker

An Excel practice tracker with dashboard views and refresh macros.

#Excel Dashboard#Stock Tracker

Stock Market Tracker in Excel VBA, Sample stock CSV data turned into charts, filters and summary figures in Excel.

Practice project on sample data

Stock Market Tracker in Excel VBA

Sample stock CSV data turned into charts, filters and summary figures in Excel.

#Excel Dashboard#Stock Market Tracker

Smart Inventory Tracker, An Excel VBA practice tool for stock movements, calculations and exports.

Practice project on sample data

Smart Inventory Tracker

An Excel VBA practice tool for stock movements, calculations and exports.

#Excel VBA#Inventory Tracker