The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Second part, using SQL statement to create an app based on the Employees table and using the JOIN statement to bring other tables together.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
I designed and developed a web-based Conflict Early Warning and Management Control Room that helps organizations collect, manage and analyze conflict-related information. The system includes an administrative dashboard, incident reporting, interactive geographic mapping, report management, officer/user management, authentication and role-based access, document handling, fact-checking workflows and data visualization. Built with React, TypeScript and Supabase.
Case study on 100K+ real e-commerce orders (Olist dataset): why did revenue growth stop? I built a 6-page Power BI diagnostic star schema, 25+ DAX measures (revenue decomposition into volume vs. basket effects, MoM/YoY, CROSSFILTER) plus a plain-English executive report with a 30/60/90 action plan. Key findings: orders flatlined at 6.6K/month; 97% of buyers never return; one region carries 38.4% of revenue; one category hides a 15.7% decline. Full pipeline on GitHub: Python ETL, SQL validation, dashboard, report.
Created a professional Excel spreadsheet for data entry, data cleaning, formatting, calculations, and sales analysis. The project includes a structured order database, cleaned and standardized data, formulas, summary reports, and visual charts for easy data analysis.
