Description

- Q1: HOW TO REPORT YEAR WISE TOTAL SALES?

-- Q2:  HOW TO REPORT YEAR WISE, QUARTER WISE TOTAL SALES AND TOTAL TAX?

-- Q3:  HOW TO REPORT YEAR WISE, QUARTER WISE, MONTH WISE TOTAL SALES AND TOTAL TAX?

-- Q4:  HOW TO REPORT YEAR WISE, QUARTER WISE TOTAL SALES AND TOTAL TAX FOR JUNE MONTH ?

-- Q5:  HOW TO REPORT CLASS WISE, COLOR WISE PRODUCTS FOR EACH YEAR BASED ON ASC ORDER OF SALES?

-- Q6: HOW TO REPORT AVERAGED SALES AND AVERAGED TAX FOR SUCH PRODUCTS WITH MAXIMUM LIST PRICE AND HIGHEST STANDARD PRICE?

-- Q7: HOW TO REPORT AVERAGED SALES AND AVERAGED TAX FOR SUCH HIGH CLASS RED COLORED PRODUCTS WITH MAXIMUM LIST PRICE FROM?

-- Q8: HOW TO COMBINE THE RESULTS FROM ABOVE TWO QUERIES. HOW TO MAKE IT FASTER?

-- Q9: HOW TO REPORT AVERAGE SALES AND AVERAGE TAX FOR ALL FEMALE CUSTOMERS FROM 2001 TO 2003 YEAR?

-- Q10: HOW TO REPORT YEAR WISE, CUSTOMER WISE, PRODUCT WISE TOTAL SALES AND TOTAL TAX ABOVE 1000 USD?

-- WE HAVE USER INTERFACE IN MSBI AND POWER BI TO AUTO GENERATE THE SQL QUERIES. 

INSERT [dbo].[TIME_DATA] ([TimeKey], [FullDateAlternateKey], [DayNumberOfWeek], [EnglishDayNameOfWeek], [SpanishDayNameOfWeek], [FrenchDayNameOfWeek], [DayNumberOfMonth], [DayNumberOfYear], [WeekNumberOfYear], [EnglishMonthName], [SpanishMonthName], [FrenchMonthName], [MonthNumberOfYear], [CalendarQuarter], [CalendarYear], [CalendarSemester], [FiscalQuarter], [FiscalYear], [FiscalSemester]) VALUES (1, CAST(N'2001-07-01 00:00:00.000' AS DateTime), 1, N'Sunday', N'Domingo', N'Dimanche', 1, 182, 27, N'July', N'Julio', N'Juillet', 7, 3, N'2001', 2, 1, N'2002', 1)

INSERT [dbo].[TIME_DATA] ([TimeKey], [FullDateAlternateKey], [DayNumberOfWeek], [EnglishDayNameOfWeek], [SpanishDayNameOfWeek], [FrenchDayNameOfWeek], [DayNumberOfMonth], [DayNumberOfYear], [WeekNumberOfYear], [EnglishMonthName], [SpanishMonthName], [FrenchMonthName], [MonthNumberOfYear], [CalendarQuarter], [CalendarYear], [CalendarSemester], [FiscalQuarter], [FiscalYear], [FiscalSemester]) VALUES (2, CAST(N'2001-07-02 00:00:00.000' AS DateTime), 2, N'Monday', N'Lunes', N'Lundi', 2, 183, 27, N'July', N'Julio', N'Juillet', 7, 3, N'2001', 2, 1, N'2002', 1)

INSERT [dbo].[TIME_DATA] ([TimeKey], [FullDateAlternateKey], [DayNumberOfWeek], [EnglishDayNameOfWeek], [SpanishDayNameOfWeek], [FrenchDayNameOfWeek], [DayNumberOfMonth], [DayNumberOfYear], [WeekNumberOfYear], [EnglishMonthName], [SpanishMonthName], [FrenchMonthName], [MonthNumberOfYear], [CalendarQuarter], [CalendarYear], [CalendarSemester], [FiscalQuarter], [FiscalYear], [FiscalSemester]) VALUES (3, CAST(N'2001-07-03 00:00:00.000' AS DateTime), 3, N'Tuesday', N'Martes', N'Mardi', 3, 184, 27, N'July', N'Julio', N'Juillet', 7, 3, N'2001', 2, 1, N'2002', 1)

INSERT [dbo].[TIME_DATA] ([TimeKey], [FullDateAlternateKey], [DayNumberOfWeek], [EnglishDayNameOfWeek], [SpanishDayNameOfWeek], [FrenchDayNameOfWeek], [DayNumberOfMonth], [DayNumberOfYear], [WeekNumberOfYear], [EnglishMonthName], [SpanishMonthName], [FrenchMonthName], [MonthNumberOfYear], [CalendarQuarter], [CalendarYear], [CalendarSemester], [FiscalQuarter], [FiscalYear], [FiscalSemester]) VALUES (4, CAST(N'2001-07-04 00:00:00.000' AS DateTime), 4, N'Wednesday', N'Miércoles', N'Mercredi', 4, 185, 27, N'July', N'Julio', N'Juillet', 7, 3, N'2001', 2, 1, N'2002', 1)

INSERT [dbo].[TIME_DATA] ([TimeKey], [FullDateAlternateKey], [DayNumberOfWeek], [EnglishDayNameOfWeek], [SpanishDayNameOfWeek], [FrenchDayNameOfWeek], [DayNumberOfMonth], [DayNumberOfYear], [WeekNumberOfYear], [EnglishMonthName], [SpanishMonthName], [FrenchMonthName], [MonthNumberOfYear], [CalendarQuarter], [CalendarYear], [CalendarSemester], [FiscalQuarter], [FiscalYear], [FiscalSemester]) VALUES (5, CAST(N'2001-07-05 00:00:00.000' AS DateTime), 5, N'Thursday', N'Jueves', N'Jeudi', 5, 186, 27, N'July', N'Julio', N'Juillet', 7, 3, N'2001', 2, 1, N'2002', 1)

INSERT [dbo].[TIME_DATA] ([TimeKey], [FullDateAlternateKey], [DayNumberOfWeek], [EnglishDayNameOfWeek], [SpanishDayNameOfWeek], [FrenchDayNameOfWeek], [DayNumberOfMonth], [DayNumberOfYear], [WeekNumberOfYear], [EnglishMonthName], [SpanishMonthName], [FrenchMonthName], [MonthNumberOfYear], [CalendarQuarter], [CalendarYear], [CalendarSemester], [FiscalQuarter], [FiscalYear], [FiscalSemester]) VALUES (6, CAST(N'2001-07-06 00:00:00.000' AS DateTime), 6, N'Friday', N'Viernes', N'Vendredi', 6, 187, 27, N'July', N'Julio', N'Juillet', 7, 3, N'2001', 2, 1, N'2002', 1)

INSERT [dbo].[TIME_DATA] ([TimeKey], [FullDateAlternateKey], [DayNumberOfWeek], [EnglishDayNameOfWeek], [SpanishDayNameOfWeek], [FrenchDayNameOfWeek], [DayNumberOfMonth], [DayNumberOfYear], [WeekNumberOfYear], [EnglishMonthName], [SpanishMonthName], [FrenchMonthName], [MonthNumberOfYear], [CalendarQuarter], [CalendarYear], [CalendarSemester], [FiscalQuarter], [FiscalYear], [FiscalSemester]) VALUES (7, CAST(N'2001-07-07 00:00:00.000' AS DateTime), 7, N'Saturday', N'Sábado', N'Samedi', 7, 188, 27, N'July', N'Julio', N'Juillet', 7, 3, N'2001', 2, 1, N'2002', 1)

INSERT [dbo].[TIME_DATA] ([TimeKey], [FullDateAlternateKey], [DayNumberOfWeek], [EnglishDayNameOfWeek], [SpanishDayNameOfWeek], [FrenchDayNameOfWeek], [DayNumberOfMonth], [DayNumberOfYear], [WeekNumberOfYear], [EnglishMonthName], [SpanishMonthName], [FrenchMonthName], [MonthNumberOfYear], [CalendarQuarter], [CalendarYear], [CalendarSemester], [FiscalQuarter], [FiscalYear], [FiscalSemester]) VALUES (8, CAST(N'2001-07-08 00:00:00.000' AS DateTime), 1, N'Sunday', N'Domingo', N'Dimanche', 8, 189, 28, N'July', N'Julio', N'Juillet', 7, 3, N'2001', 2, 1, N'2002', 1)

Instruction Files