Mastering Consulting Prep: Business and Data Understanding Guide
School
KCA University**We aren't endorsed by this school
Course
FOCIM 3201A
Subject
Information Systems
Date
Dec 10, 2024
Pages
3
Uploaded by ChancellorTeamKouprey41
Consulting Prep ReportThe goal is to present your business and data understanding on an intended project. The entireCRISP-DM phases will be included later in your consulting presentation. Please note that this is an individual assignment. I expect you to pose your own research questions, explore all or some of the datasets, and perform EDA.Please note that the client’s datasets are fragmented and combining them is critical in data preparation. Extra credits will be awarded to those who merge multiple datasets before EDA.Please start the business understanding phase with Warren Group Introvideo (1h 29m).GuidelinesFormatThere is no absolute limit to the length of the report. A typical report includes about 2 to 4 pages for the core content. Your report should be followed by an appendix of references, charts, tables, outputs, etc. The appendix may be as long as possible, but make sure to refer to it when needed during the presentation. If it is too long, consider submitting it in a separate document.Your report should cover business and data understanding phases and below are the grading points I consider.●Business understanding○Brief the business context of the client. Note: If you do not have a direct client, suppose potential clients who may use your analysis. For deeper business understanding, I recommend using some articles on the domain. ○Propose a few research questions and discuss why they are important to the client(s).●Data understanding○Discuss the results of EDA. Note: EDA is never enough. Do much EDA and include the details in the appendix.○Variable selection – Discuss variable importance and multicollinearity. Note: Consider correlations, chi-squares, etc.○Report skewed variables and their skewness.○Report outliers or confirm that your dataset is free of them. Note: I recommend box plots. Are they genuine outliers or data errors?○Data quality – Report data errors or duplicate records. Or confirm that your dataset is free of them.○Report missing values or confirm that your dataset is free of them.
○Identify promising subsets (of rows) (if needed). Note: Your business understanding may help. I also recommend clustering.SubmissionSubmit a Word (or PDF) file to: Modules => Consulting => Consulting Prep Report.●Use a font size of at least 11 points and at least 1.15 space.●Name your file as: Consulting_Prep_Report_First_Name_Last_Name. So, if your name isSatoshi Nakamoto, please name your file as: Consulting_Prep_Report_Satoshi_Nakamoto.docx ●(Optional) If you submit a combined data table for extra credits, please name it as: Consulting_Prep_Report_Satoshi_Nakamoto.xlsx (or .csv)●Submit files. Links to external documents are not accepted. ●Unless you get my pre-approval in cases of technical or other issues, email submissions are not allowed.GradingYour report will be graded for a full mark of 3 points with the criteria (and their relative importance) below.●Information selection and organization(2)○Information amount Provides an ideal quantity of information.‒○Information relevance Includes relevant and necessary information at an ‒appropriate level of detail.○Information sequence Sequences information logically and persuasively.‒○Information flow Linking statements create a good flow of ideas.‒●Design and delivery(1)○Engaging Captures and holds audience attention.‒○Professional Exceeds or meets professional expectations for the modality ‒(written communication).○Visual aids Effectively designs and uses visual aids for message and audience.‒○Error-free Has no preventable mistakes or errors.‒How to import a dataset into SAS EMYou can refer to the Income Analysis project of SAS EM Tutorial 1, but below are simpler instructions.●If your dataset is in Excel format, convert it to CSV format.●Copy the CSV file into the Documents folder on OneDrive. ●Open the diagram of your SAS EM project.●Drag a File Import node from the Sample tab into the diagram.●Click the File Import node.
●In the Train property, click the ellipsis (…) next to Import File and select the path to the file.