Introduction
- Welcome to course
Practice Question and Solutions
- Question 1 - Year 2000 Sales with Profit Less than 5000
- Question 2 - Quantity Ordered for Product XEROX 1895
- Question 3 - Product Sub Category With Highest Percent of Growth
- Find the highest Share of Sales
- Get Bottom third product sub category through Running Total
- Lowest Sales Across All Years
- Moving average considering previous 3 years
- Sales Return Decreasing Trend
- Total Profit Made by 2013 New Customers
- Percentage of Sales Return in 2013 by customers who joined in 2010
- Find the sales return in West Region by Top 5 customers
- Total number of hires in the age range of 30 - 34
- Find how many States or Provinces showed negative profit
- Find out which segment-region has the lowest sales returns
- Find the customers who are in our top 100 customers
- Find the product sub category having third highest average returns
- Find the quantity sold for product with maximum sales in year 2012
Create and Save Data Connections
- Data Connectors
- Extract your data
- Run initial SQL
Modify Data Connections
- Join and Union
- Blend your data
Manage Data Properties
- Manage data properties
Organize Data and Apply Filters
- Order of Operations
- Sets and Context Filter
