Question

Step 1. Access a dataset with store records at AmazingMartEU2.xlsx and view in Excel

Step 2. Describe the dataset in your own words.

Step 3. Come up with questions to answer using this dataset:

Which products are sales leaders by quantity?

Which products are profit leaders by state and by country?

Which products are loss leaders by state and by country??

Sales target met by category by year?

Which customer segment is most profitable overall and by country?

Which products are trending high in profitability by season (3 month quarters, Jan-Mar, …, Oct-Dec)?

Step 4. Import the data into Tableau (see instructions at http://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_excel.html).

Step 5. Try and use filtering, built-in functions, and visualizations to answer the questions. Take screenshots and paste into this document below. Add language to explain each screenshot as you answer the question.

Answer 1

.

The below program will transfers the data from database to excel sheet.

I am not giving the entire program I'm giving the mandatory things and steps to connect to a database and transfer the data to the excel sheet.

import java.io. FileNotFoundException ;

import java.io. FileOutputStream;

import java.io. IOException;

import java.sql. Connection;

import java.sql. DriverManager ;

import java.sql. ResultSet;

import java.sql. SQLException ;

import java.sql. Statement;

import java.util.logging. Level ;

import java.util.logging. Logger ;

import org.apache.poi.hssf.usermodel. HSSFSheet ;

import org.apache.poi.hssf.usermodel. HSSFWorkbook

import org.apache.poi.ss.usermodel.*;

public class Plexada2 {

try {

Class .forName( "driverName" );

Connection con = DriverManager .getConnection( "u

Statement st = con.createStatement();

ResultSet rs = st.executeQuery( "Select * from t

HSSFWorkbook workbook = new HSSFWorkbook ();

HSSFSheet sheet = workbook.createSheet( "lawix10

HSSFRow rowhead = sheet.createRow(( short ) 0);

rowhead.createCell(( short ) 0).setCellValue( "Cel

rowhead.createCell(( short ) 1).setCellValue( "Cel

rowhead.createCell(( short ) 2).setCellValue( "Cel

int i = 1;

while (rs.next()){

HSSFRow row = sheet.createRow(( short ) i);

row.createCell(( short ) 0).setCellValue( Inte

row.createCell(( short ) 1).setCellValue(rs.g

row.createCell(( short ) 2).setCellValue(rs.g

i++;

}

String yemi = "g:/test.xls" ;

FileOutputStream fileOut = new FileOutputStream

workbook.write(fileOut);

fileOut.close();

} catch (ClassNotFoundException e1) {

e1.printStackTrace();

} catch (SQLException e1) {

e1.printStackTrace();

} catch (FileNotFoundException e1) {

e1.printStackTrace();

} catch (IOException e1) {

e1.printStackTrace();

}

.