STAR-schema-StackOverFlow-Analysis

• Conducted a data warehousing project using the Stack Overflow dataset, analyzing across multiple dimensions and creating a star schema.
• Designed an Entity-Relationship Diagram (ERD) and developed a data cube for analysis services.
• Applied MDX queries on the cube to generate insights, visualizing data through charts to analyze and count posts and comments at specific times, locations, and topics, and examined how users interact with one another and their actions over time during published challenges using the fact table.

Developed using SQL Server, Visual Studio, Microsoft Excel, and Tableau.