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
Title:
Northwind Data Warehouse & BI Analytics Project
Summary:
Built an end-to-end Data Warehouse and Business Intelligence solution using the Northwind dataset, including star schema design, SSIS ETL workflows, SSAS cube development, OLAP analysis, MDX queries, and SSMS deployment.
Description:
I developed an end-to-end Data Warehouse and Business Intelligence project using the Northwind dataset. The goal was to transform raw business data into a structured analytical system that supports reporting, OLAP analysis, and business-driven insights.
My work included designing a star-schema data warehouse, building ETL workflows in SSIS, developing an SSAS multidimensional cube with measures and hierarchies, performing OLAP operations such as roll-up, drill-down, slice, and dice, and writing MDX queries for analysis. I also deployed and validated the solution using SQL Server Management Studio.
The final result demonstrates a complete BI workflow — from source data extraction and transformation to cube development and analytical reporting. This type of solution is useful for businesses that need organized data, performance tracking, sales analysis, and decision-support reporting.
Skills:
Business Intelligence, Data Warehousing, SQL Server, SSIS, SSAS, SSMS, ETL, OLAP, MDX, Star Schema, Data Modeling, SQL, Data Analytics.
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
🚀 Just shared a quick Excel tutorial on how to combine multiple worksheets using the Consolidate Feature in Microsoft Excel.
In this video, I demonstrated how to:
✅ Merge data from multiple sheets
✅ Create a summary report automatically
✅ Save time without using complex formulas
✅ Organize datasets efficiently in Excel
As a Data Analyst, I believe mastering small but powerful Excel features can significantly improve workflow efficiency and reporting speed.
Excel is still one of the most essential tools in data analysis, business reporting, and dashboard preparation — and features like Consolidate make handling large datasets much easier.
🎥 Check out the video and let me know your thoughts!
Operations Dashboard — a multi-view executive snapshot for SaaS, corporate finance, and portfolio metrics. Three coordinated views, one live system: real-time ARR/MRR/churn, cash & runway, and investment AUM/IRR. Built so a founder or board can read the state of the business in 60 seconds. Connects to the underlying finance & ops stack so the numbers update themselves — no more manual board-pack assembly.
Customer churn is a major challenge for telecom companies. Retaining existing customers is more cost-effective than acquiring new ones. In this project, I built a Machine Learning model to predict whether a telecom customer will churn or not based on their service usage, contract details, and billing information. The goal is to help companies identify customers who are likely to leave and take preventive actions.
This project focuses on Exploratory Data Analysis (EDA) of the Sample Superstore dataset to identify profitability patterns, loss-making products, and regional performance. The goal is to support data-driven business decisions using visualization and statistical insights.
Trending
Claude
Claude has entered the design space. How are you using Claude Design?
Contra University
Learn from expert creatives how to earn more using next-gen AI tools.
creativeaiflow
Creative AI workflows are evolving. What tools do you use, and what are their strengths and weaknesses?
portfolioreview
The best portfolios tell a story, not just show a grid. Share yours for feedback.
freelancerlife
Freelancer life is wins, pivots, and everything in between. What’s yours right now?