The purpose of this is to become familiar with the fundamentals of SQL Server Analysis Services (SSAS).

The regional sales manager has asked you demonstrate your knowledge of importing a custom Excel report based on preferred clients into the database using SSAS. He has also requested an exported data table after attaching updated sales figures to his data, and he would like you to demonstrate your export skills. The manager has asked you schedule a meeting to present a quick import/export demo.

Part 1:

In planning for this project, there are several issues that need to be addressed. In 250-500 words, answer the questions below so you can plan accordingly to execute the project.

1 Discuss some of the immediate issues you may encounter when loading the package and matching to the database data.

2 Explain what a delimiter is with regard to importing data. Include discussion of why a flat file is important.

3 Considering the database is constantly being updated, discuss some of the possible issues that may be encountered if the manager wants the same extract each month. Discuss the recommendations you would make after analyzing the potential risks. Justify the recommendations with reasons, facts, and examples.