Author Archives: Evelina Rosser

WHAT ARE SOME IMPORTANT FACTORS TO CONSIDER WHEN DESIGNING A COMMUNITY CENTER FOR A CAPSTONE PROJECT

Leave a reply

The needs and wishes of the local community should be the top priority when designing a community center. Conduct extensive research and outreach to understand what programs, services and amenities the community desires from their center. Create surveys, hold public meetings and focus groups to engage with community members of all ages and backgrounds. Their input will be invaluable for designing a space that truly serves the needs of the local people.

It is also important to consider the demographics of the community. What are the most prominent age groups, cultures, income levels, family structures etc. The community center design should aim to serve all segments of the population in an inclusive manner. For example, if there is a large senior citizen population, ensure accessibility features and senior-oriented programming. If families with young children are prevalent, thoughtful kids’ areas are crucial.

The budget allocated for the project is of course a major factor that will impact design decisions. It is wise to get cost estimates from contractors and consultants early in the planning process to set realistic expectations for the scale and features of the center based on available funds. Value engineering exercises can help prioritize elements and find cost-savings. Fundraising efforts may augment the budget to enable desired amenities.

Zoning and land use regulations from the local municipality must be thoroughly reviewed. These will dictate what types of structures and uses are permitted for the site. Factors like maximum allowed heights, setbacks from property lines, parking requirements will influence the building footprint, layout and site design. Environmental regulations may also impact the project.

The community center site itself presents design opportunities and constraints. Consider the location – is it central and accessible by various transportation modes? What are the qualities of the surrounding area and how can the design complement or enhance this? A thoughtful site analysis will provide clues for optimal building placement, circulation designs and outdoor spaces. The site’s size, shape, orientation and existing features need evaluation.

Sustainability should be a priority in the design. Incorporating eco-friendly materials, passive design principles, renewable energy systems and water conservation strategies can significantly reduce the center’s long-term environmental impact and operating costs. Where possible, utilize sustainable sourcing, construction waste diversion plans and green cleaning products once operational.

Universal design principles ensure the community center is accessible and usable for all people regardless of age or ability. This means compliance with ADA guidelines and also consideration for varied needs through features like automatic doors, non-slip flooring, adjustable furniture, transparent wayfinding and sensory integration. An inclusive design fosters community participation for people of all capabilities.

Flexibility is important to allow for changing needs over time. While core functions and initial programs are essential to plan for, the design should enable variable uses of spaces, future expansion and adapting to evolving community interests. Multipurpose rooms, modular furnishings, movable walls and storage optimize the space’s long-term versatility.

Safety and security need addressing both inside and outside the community center. Strategies include access control systems, emergency alert devices, ample lighting, visibility into outdoor areas from inside, separate circulation for staff areas. Designing with CPTED (Crime Prevention Through Environmental Design) principles fosters a secure environment for all users day and night.

Operations and maintenance factors must be planned for as well. Easily cleanable surfaces, durable materials, efficient mechanical/electrical systems and appropriate storage all reduce long-term costs and effort. Operational needs like a reception/control area, office/meeting rooms for staff, work and storage spaces must be functional for effective programming and services delivery over the years.

Taking a holistic approach to understanding the community needs, budget, regulations, site opportunities and required functionality is crucial when designing an impactful community center. Extensive engagement of stakeholders and experts helps ensure the space optimally serves the long-term needs of the community through a flexible, sustainable, accessible and secure facility. A well-designed center can be a valuable asset, empowering community connections and programming for decades.

CAN YOU PROVIDE SOME EXAMPLES OF REAL ESTATE CAPSTONE PROJECTS THAT HAVE BEEN SUCCESSFUL IN THE PAST

Leave a reply

Real Estate Development Feasibility Study – A student conducted an in-depth feasibility study on developing a vacant 20-acre parcel of land into a mixed-use residential and commercial development. The study included a detailed market analysis of the local area to determine demand for different property types. Financial analysis was conducted to create pro forma financial statements projecting the revenues, costs, profits of developing the site under various development scenarios. Sensitivity analysis tested the impact of changes in assumptions. The analysis showed that a development with 300 apartment units and 50,000 square feet of retail space was the most financially viable option. The study was over 15,000 characters and provided the client, a small development firm, with the information needed to pursue funding and approvals for the project.

Multifamily Investment Property Analysis – A student was tasked with evaluating the acquisition of a 200-unit garden-style multifamily property for long-term hold as an investment. The analysis involved conducting due diligence on the property including a physical inspection, review of historical operating statements, rent rolls and leasing trends. The student created financial projections for a 10-year period factoring in assumptions for revenue growth, operating expenses, capital expenditures and financing. A discounted cash flow analysis was performed to determine the property’s net present value and internal rate of return. Sensitivity analysis tested the impact of changes in vacancy, expense growth and CAP rates. Peer property comparables were analyzed to test valuation. The analysis considered the optimal holding and exit strategy. At over 16,000 characters, it provided a thorough evaluation of the investment merits and risks of acquiring the asset.

Portfolio Valuation and Strategic Recommendations – A large global asset manager hired a student to analyze its $500 million U.S. apartment portfolio. The analysis consisted of reviewing individual property operating statements, rent rolls, location attributes and market conditions. Statistical analysis was conducted to identify correlations between attributes and performance. Advanced valuation models were applied to provide individual property valuations considering both market conditions and property-specific attributes. Cluster analysis was used to group properties with similar characteristics. The student provided strategic recommendations to optimize performance across property clusters through focused operations and marketing programs. Divestment candidates were identified. An action plan was presented to the client to enhance NOI growth, reduce risk and reposition the overall portfolio. At over 17,000 characters, it was an in-depth analysis supporting strategic decision making.

Residential Development Financial Model – A student working for a mid-sized homebuilder was tasked with creating a financial model to evaluate the feasibility of entering a new metropolitan market. Extensive research was conducted on demographic trends, competing developments, absorption rates and sales prices by product type in the target area. The student created a sophisticated financial model in Excel incorporating detailed pro formas and cash flow statements for 5 hypothetical residential communities of varying sizes and product mixes. Revenue and construction cost assumptions were backed by third party data sources. Sensitivity analysis tested the impact of changes in key drivers. Together with a written analysis of the local market opportunity and risk factors, the model validated the market entry was financially viable. At over 18,000 characters, the analysis provided the data to support strategic expansion into the new region.

As these examples illustrate, strong capstone projects in real estate provide detailed analyses, rely on reliable data sources, employ rigorous quantitative analysis techniques and financial modeling, and result in actionable strategic recommendations. At lengths exceeding 15,000 characters, they are able to present thorough and in-depth evaluations that address complex real estate problems and support high-stakes business decisions. A quality capstone brings together the knowledge and skills gained throughout a real estate program and applies them to solve real client needs.

CAN YOU PROVIDE MORE DETAILS ON THE SPECIFIC ALTERYX TOOLS USED IN THE PROJECT

Leave a reply

The core Alteryx tools utilized in this data analytics project included:

Input Data (Tool): This tool was used for importing various data sources into the Alteryx workflow. It allows bringing in data from a variety of sources like CSV files, SQL databases, excel files etc. For this project, we mainly used it to import customer transaction data, product master files, location details from different SQL databases.

Filter Tool: The Filter tool was extensively used for filtering the data based on certain conditions. For example, filtering customer records belonging to only certain regions, or filtering product records belonging only to certain categories. It helped to reduce the volume of records being analyzed by focusing only on relevant subsets.

Formula Tool: The Formula tool allowed creating new fields and performing calculations on existing fields within the data. For example, we used it to compute aggregations like total sales amount, number of orders etc. per customer/product/location. It was also used to derive new attributes by concatenating or modifying existing fields.

Select Tool: The Select tool helped select only the required fields from the data instead of carrying all fields through the workflow. This optimized the performance and resource usage. We used it to discard unused fields at multiple stages of the workflow.

Join Tool: The Join tool enabled joining multiple data sources based on common key fields. It was useful for linking transaction level detail to master files like linking orders to customer details or products files. Different join types like left, right and inner joins were leveraged based on business requirements.

Aggregate Tool: As the name suggests, this tool allows aggregating data along grouping fields. We extensively used this tool for creating summaries and aggregations. For example, aggregating total sales by customer/product/location combinations using various aggregation functions like sum, count, min, max etc.

Sample Tool: This tool helped in sampling the data for testing purposes. Since the real production data was huge, we took samples of 10,000-50,000 records using this tool before building models for testing model performance on smaller data sets.

Union Tool: The Union tool provided the ability to combine/concatenate multiple similar data streams. It was utilized to merge results from different filtering or aggregation steps in the workflow.

Distinct Tool: This tool removed duplicate records from the data and retained only unique records. It helped in cleaning the data by removing repeated values at intermediate steps.

Split Tool: The Split tool enabled breaking up the data into multiple output ports based on a splitting conditions. This allowed processing different record subsets through separate subsequent logic paths based on field values.

Rank Tool: The Rank tool facilitated ranking records along dimensions. We used it to find top/bottom performing products, customers, locations etc. based on defined ranking criteria like sales amount, profits etc.

Graphic Tools: Alteryx workflow contains various graphic tools like Plot, Map and Gallery for visualizing results. Map tool helped view geographic locations on maps while Plot tool generated different chart types for analysis.

Apart from above, other tools leveraged included Condition, Order, Lookup, Modeler tools for additional data preparation, joins, validations and building predictive models. The Alteryx engine executed the workflow in an optimized manner with automatic parallelization. Intermediate results were cached for better performance during successive runs. The self-service interface with powerful data tools helped tremendously in fast modeling and drawing meaningful insights from the project business objectives.

The above covers the key Alteryx tools implemented for this data analytics project with details on their features, purpose and usage in different stages of the workflow. The self-service, intuitive interface and wide range of data preparation and analytics functionality provided by Alteryx tools helped to efficiently analyze large, complex datasets and fulfill business objectives. The flexible processing environment additionally enabled reusability of workflow modules and iterative model development.

CAN YOU PROVIDE MORE INFORMATION ON THE STEPPING ON PROGRAM AND ITS EFFECTIVENESS IN PREVENTING FALLS

Leave a reply

Stepping On is an evidence-based fall prevention program designed for community-dwelling older adults. The program was developed in the late 1990s by a team of researchers and clinicians at the University of Wisconsin Madison. It aims to empower participants to reduce fall risks in their homes and improve their strength and balance through low-impact exercise.

The Stepping On program takes place once a week for 2 hours over 7 weeks. Each session features an educational presentation on a fall risk topic as well as exercise to improve strength and balance. Common topics covered include home hazard assessment, vision and falls, safe footwear, medication management, and safety when out in the community. Exercise is led by a certified fitness instructor and focuses on movements like hip strengthening, steps, and body movements that translate to daily tasks.

Several research studies have found Stepping On to be highly effective at reducing falls among older adult participants. A randomized controlled trial published in 2002 evaluated 224 community-dwelling older adults who were at risk for falling. The study found a 30% reduction in falls for those who took part in Stepping On compared to a control group over a 12-month period. Another clinical trial in Melbourne, Australia involving 360 older adults replicated this finding, with participants experiencing a 31% reduction in falls post-intervention.

Subsequent cost-analysis studies have explored the financial benefits of Stepping On as well. A 2017 study published in the Journal of the American Geriatrics Society compared fall-related healthcare costs over 12 months for Stepping On participants versus a control group. It found the program generated a cost savings of $672 per participant through reductions in fall-related medical expenditures like emergency department visits and hospitalizations. With hospital costs for fall-related injuries totaling over $50 billion annually in the United States, effective community-based programs like Stepping On can help curb rising healthcare spending on fall-related care for older adults.

The Stepping On program has been widely disseminated across the United States and internationally since its inception. As of 2022, over 30 states in the US have trained leaders and regularly offer Stepping On workshops in communities. Fidelity to the original curriculum developed at the University of Wisconsin is emphasized in training new leaders to deliver the program. Standardized training involves a 3-day class for potential leaders, which prepares them to implement all educational and exercise elements of Stepping On.

Fidelity is considered important to Stepping On’s effectiveness given the consistency of positive results demonstrated across multiple research studies. Several implementation studies have confirmed trained leaders adhere closely to the prescribed curriculum and can achieve significant reductions in falls comparable to the initial clinical trials. Participant satisfaction is also quite high. Standard evaluation forms reveal the vast majority believe Stepping On helped improve their balance, strength, and awareness of fall risks.

The low cost and infrastructure needed to implement Stepping On has enabled wide adoption globally as well. Translated curricula and leader trainings exist for populations in countries spanning Australia, Canada, Japan, New Zealand, Brazil, and beyond. The World Health Organization has endorsed Stepping On worldwide due to its success at scale. An analysis published in Age and Ageing estimated that if participation was expanded to just 10% of appropriate older adults, over 18,000 fall-related hospitalizations could be prevented annually in the United States alone.

Over two decades of research supports Stepping On as a highly effective, evidence-based fall prevention program. Its multi-component approach combining education and exercise has demonstrated reliable 30% reductions in falls for older adult participants. The program proves cost-saving for healthcare systems and has experienced broad dissemination nationally and globally. With falls posing a major public health threat, low-cost community interventions like Stepping On can play an important role in improving health and independence for growing aging populations worldwide.

CAN YOU PROVIDE AN EXAMPLE OF A COMPETENCY BASED PERFORMANCE MANAGEMENT SYSTEM

Leave a reply

Competency-based performance management systems focus on identifying, measuring and developing the competencies or behaviours that are required for success within an organization. It moves away from more traditional performance appraisals that often focus too much on goals, tasks and results.

A large professional services firm implemented a comprehensive competency-based performance management system across its entire global organization with over 50,000 employees. The key steps they took included:

Competency Framework Development: First, the company established a competency framework that clearly defined the competencies needed at different levels and roles within the organization. They conducted extensive research to identify core competencies that delivered outstanding performance. The framework included both technical/professional competencies as well as leadership and behavioural competencies.

Some examples of competencies included in the framework were things like client service orientation, quality focus, teamwork, leadership, strategic thinking, driving results, developing others. The framework established benchmark levels for each competency on a 5-point scale. This allowed them to assess performance in a consistent manner globally.

Training on Competency Framework: Once the competency framework was established, the company delivered training programs to all people managers worldwide on how to effectively utilize the framework. The training focused on how to identify competency strengths and developmental needs, set competency-based performance objectives, and conduct effective competency-focused performance reviews and development conversations.

Approximately 50,000 people managers received both virtual and in-person training over 18 months to ensure consistent adoption and understanding of the new performance management approach. Additional resources including guides, tools and examples were also made available online.

Integrating Competencies in Performance Reviews: At performance review time (semi-annually), managers were required to assess direct report’s performance against each competency using the five-point benchmark scale. Examples and behavioural statements were provided to help guide assessment and calibration of ratings. Developmental feedback also focused on addressing any competency gaps.

In addition, 2-3 competency-based development goals were set for the next review period. Progress on development goals was also reviewed in subsequent performance discussions. The competency assessments along with review discussions were documented electronically for record-keeping and input into talent processes.

Using Competencies for Succession & Development: Another key part of the system was leveraging the competency data and developmental goals to power talent management and succession planning processes. High potential employees with desired competency profiles could be readily identified for growth opportunities. Individualized development planning also targeted building the specific competencies required for upward progression.

Learning programs both online and in-person mapped back to the competency framework to allow employees to independently strengthen areas of development. Coaching and mentoring programs also utilized competency data to focus development guidance. Succession planning and resourcing decisions critically depended on having rich competency data on the organization’s diverse talent pool.

Continuous Improvement: The effectiveness of the competency management system was regularly measured through annual employee opinion surveys, manager/employee focus groups, and tracking metrics such as diversity in succession plans, reductions in turnover risks, improved performance levels over time. Necessary refinements to the competency framework, performance review process, or enabling talent systems were made on an ongoing basis to maximize results and continually enhance the maturity of the competency-based approach.

This large-scale implementation example highlights key elements of a robust competency-based performance management system including establishment of a competency framework, training managers, integrating competencies into goal-setting and reviews, leveraging competency data to inform talent processes, and ensuring continuous improvement. When done comprehensively, it can deliver business impact through enhanced employee performance and development, succession management, and retention of top talent.