Data Engineering Technical Blog
The blog includes article on Datawarehousing, Business Intelligence, SQL Server, PowerBI, Python, BigData, Spark, Databricks, DataScience, .Net etc.
Write a python program to find factorial of a number ?
Factorial
Write a python program to check if a number is palindrome ?
Palindrome
CODE
T-SQL LEAD LAG and SUM function based query
Query
on T-SQL window clause
Below is the sales table
Order_Date |
Name |
Product |
SubCategory |
Category |
Quantity |
SalesAmount |
DiscountAmount |
10-08-2011 |
Megan Stewart |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
14-09-2011 |
Elizabeth Clark |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
14-10-2011 |
Olivia Torres |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
20-10-2011 |
Ethan Foster |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
14-11-2011 |
Beth Gutierrez |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
14-11-2011 |
Dawn Wu |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
20-12-2011 |
Desiree Dominguez |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
22-12-2011 |
Kevin Wright |
Mountain-100 Silver, 38 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
17-01-2011 |
Clarence Rai |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
23-01-2011 |
Elizabeth Johnson |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
03-02-2011 |
Jaclyn Lu |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
19-03-2011 |
Jon Zhou |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
04-04-2011 |
Arthur Carlson |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
07-04-2011 |
Adam Ross |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
17-04-2011 |
Carolyn Navarro |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
29-04-2011 |
Abby Sai |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
05-05-2011 |
Ross Jordan |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
06-05-2011 |
April Deng |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
02-06-2011 |
Ebony Gutierrez |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
08-06-2011 |
Julian Ross |
Mountain-100 Silver, 42 |
Mountain Bikes |
Bikes |
1 |
3399.99 |
0 |
- From the above table display all records along with sum of sales amount for each category.
- From the above table display all the records along with sales amount per month.
- Compare the sales between each day with previous sales value for each category.
Write a python program to find factorial of a number ?
Factorial When we recursively multiply number incrementing from 1 to a given number then its called factorial of that number. We use the no...
-
INTRODUCTION TO DATAZEN PRODUCT ELEMENTS ARCHITECTURE DATAZEN ENTERPRISE SERVER INTRODUCTION SERVER ARCHITECTURE INSTALLATION SEC...
-
Microsoft Business Intelligence Course Syllabus SSRS – SQL Server Reporting Services Getting Started 1. Understanding Reportin...
-
Power BI Interview Questions – General Questions 1). What is self-service business intelligence? Ans: Self-Service Business Intelligenc...