Business Analytics
Order Description
Having covered the CRISP-DM methodology at length at the university, you decide to apply it to this project.
You are free to make reasonable assumptions about possible data sources. However, keep in mind that some data may not be allowed to be used in the Netherlands. You need not know the precise laws in the Netherlands or elsewhere, just highlight your legal/ethical concerns if any arise.
(a) Elaborate on the Business Understanding: determine business objectives and possible ways to achieve them. Assess the situation, making assumptions where necessary, and determine data mining goals. [35%]
(b) DiscussthenextstagesofDataUnderstandingandDataPreparation.Howdoesyour plan of these stages look like? Think of additional data sources that might be useful for this problem. Be creative but realistic. Describe all data sources in terms of their expected properties (structured, unstructured, 4Vs). Comment on practical challenges that may arise from using these sources. [30%]
(c) What variable do you expect to use as target? What specific challenges your predictive analytics on detecting fraudulent claims might face using the past data? Why will you need to partition the data for predictive modelling? Will over-sampling be needed? [35%]

Business Analytics

USK Your task is to complete The following activities, a/design a relational data model to enable everyday transactions, la) develop a Dimensional Model OW) using a star schema representation for OW, c) justify your fact and dimension tables (including. facts and attributes) on your DM, d) build 01.AP cubes tram the star schema using appropriate SQL commands, e) identify different types of questions That can be answered using The OLAP data cubes, f) develop data marts for decision-making at different departments, and g) design dashboards and scorecards for different stakeholders.
CASE INSCRI¦TIOX Thd’s Threads is a business specializing in a limited set of youtb-oriented apparel. They were founded in 20D0 and have enjoyed rapid expansion and now have 175 retail outlets in SO states. The states are organized into 5 regions for Their operations: East oast, West Coast, Midwest, Cenff al, and South. They also sell their products via The Internet,  which are shipped directly to customers hom 3 different warehouses Through Third-party logistics providers. Stores are replenished from The same 3 warehouses using their own fleet. They obtain Their products from brand-narne cloThing manufacturers. They sell 3 categories of clothing: ats, t-sbirts, and oodies. They carry, lines of t-sbirts: Meffo (aimed at The urban/ modern market) and Retro (generalThrowback lie), 3 lines of bats: Wooly (knit bats aimed at The snowboarder), Bully (gangsta-sty. ballcaps aimed at The gang crowd), and Unruly (unconventional bats aimed at The general rAT/ crowd); an lines of es ?hooaea ZPPY UiPPered) and .iPPY (slipover). Each product line comes in a number of sizes and colors. The inventor, at each store and.. Internet store are maintained an a transaction processing system That also bandies various internal act,ities (e.g., distribution, scheduling, restocking) and external activities (e.g., store sales, Internet orders, purchase orders). Thd’s Threads is interested in obtaining management insights into Their operations including store operations, sales, profitability, customer segments, logistics, etc.

Business Analytics

USK Your task is to complete The following activities, a/design a relational data model to enable everyday transactions, la) develop a Dimensional Model OW) using a star schema representation for OW, c) justify your fact and dimension tables (including. facts and attributes) on your DM, d) build 01.AP cubes tram the star schema using appropriate SQL commands, e) identify different types of questions That can be answered using The OLAP data cubes, f) develop data marts for decision-making at different departments, and g) design dashboards and scorecards for different stakeholders.
CASE INSCRI¦TIOX Thd’s Threads is a business specializing in a limited set of youtb-oriented apparel. They were founded in 20D0 and have enjoyed rapid expansion and now have 175 retail outlets in SO states. The states are organized into 5 regions for Their operations: East oast, West Coast, Midwest, Cenff al, and South. They also sell their products via The Internet,  which are shipped directly to customers hom 3 different warehouses Through Third-party logistics providers. Stores are replenished from The same 3 warehouses using their own fleet. They obtain Their products from brand-narne cloThing manufacturers. They sell 3 categories of clothing: ats, t-sbirts, and oodies. They carry, lines of t-sbirts: Meffo (aimed at The urban/ modern market) and Retro (generalThrowback lie), 3 lines of bats: Wooly (knit bats aimed at The snowboarder), Bully (gangsta-sty. ballcaps aimed at The gang crowd), and Unruly (unconventional bats aimed at The general rAT/ crowd); an lines of es ?hooaea ZPPY UiPPered) and .iPPY (slipover). Each product line comes in a number of sizes and colors. The inventor, at each store and.. Internet store are maintained an a transaction processing system That also bandies various internal act,ities (e.g., distribution, scheduling, restocking) and external activities (e.g., store sales, Internet orders, purchase orders). Thd’s Threads is interested in obtaining management insights into Their operations including store operations, sales, profitability, customer segments, logistics, etc.