Here's a little Complex SAS Reporting Example to work with...
One of the Adhoc Reporting groups at a company maintains a MS Access Database of all the Internal and External Dept requests that are worked by a Data Analysts team. Now the Management team of that group needs a summary Productivity report on the team performance in an Excel Report.
MS Access Database has 6-7 tables containing Normalized tables of the Work performed by the group…Screenshots of the tables are shown below….
Since the Report Requests is huge...showing just the layout of the table…
Download Sample MS Access database
Requirements
- Excel Report should have 4-6 Tabs (depending on data) with different layout of reports…Each Tab should have the totals by the current month (till date) and Year to date Information…The Code should be flexible enough to run for historic data as well…i.e. last years May Month as well.
- Tab #1 Analyst - Number of Requests worked on by Analysts.
- Tab #2 Report Category - Number of Requests worked on by Analysts per Report Category… The Request Categories should be grouped as External or Internal Requests based on the criteria below.
- Tab #3 Analyst by Report Category – Show ALL Requests Completed Count by Analysts on the Column.
- Tab #4 Analyst by Dept Name/ Dept Head - Show External Requests Number of Requests worked on by Analysts per Dept Name/ Dept Head.
- Tab #5 Open Requests – Show ALL requests that are Not Completed by Analysts and their details.
- Tab #5 ALL Requests Whose Details were Not Insufficiently filled and require completion. Number of Requests worked on by Analysts per Report Category details…Count of Reasons what info is missing…Reasons are identified by these conditions….
Download ALL Project files
..under Projects | Mini Projects 2 Try...
