Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started