SQL server installation and Data Import

In this project I have installed SQL server Express Edition and created new database and table. Imported data from flat file into tables created and analysed the data validity.
1. Installed SQL server Express Edition
2. Created new database and users
3. Created table per data import requirement with appropriate data types.
3. Imported data from flat file into database tables.
4. Validated the integrity of imported data.

Data Analysis in SQL using CAST, GROUPBY & ORDERBY.

In this project I have queried data SQL database table for real time data analysis.
1. Calculated Total Revenue , Average Order Value, Total Pizzas Sold, Totlal Orders, Average Pizzas per Order.
2. Trend analysis with Daily and Monthly Trend of Total Orders along with
3. Percentage analysis with Sales by Pizza Category, Sales by Pizza Size.
4. Best and worst sellers analysis in terms of Revenue, Total Quantity and Total Orders.