Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2.1 The group creates a OneDrive account to use as a place to store information data general for the project (provide User, pass for teachers

2.1 The group creates a OneDrive account to use as a place to store information data general for the project (provide User, pass for teachers to check when needed) (0.5 points) 2.2. Load the Data source data from the file SalesRepAnalysis.accdb and execute. Create the Model to create a connection between data tables (1 point) 2.3. Set up Create Calculated Columns to create more calculated columns to support for analysis and in Reports and Dashboard settings (1 point) 2.4. Use the Create Measures function to calculate the measurement indicators KPIs for employees (1 point) 2.5. Extract data from SalesRepAnalysis data source, perform Power Pivot Table for aggregate analysis of any data, then use Power Pivot Chart to show aggregate data in chart form (1 point) 2.6. Extract data from SalesRepAnalysis data source, set up Dashboard with Power BI Desktop aims to track sales performance (based on sales) sales quota and number) of each group of salespeople (1 point) 2.7. Create Reports to report the sales of each group by interval time (1 point) 2.8. Comment and rate the above Revenue reports (0.5 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions