Dynamics 365 Time and Task Management System: Workweek Overview

The goal of this project is to develop a Workweek Overview feature for a time and task management system within Microsoft Dynamics 365. This feature will be inspired by Dynamics 365 Field Service and aims to provide users with a visual representation of tasks across a workweek. The project will involve designing and implementing a JavaScript-based web resource that integrates seamlessly with Dynamics 365. By focusing on task visualization and management, the project seeks to enhance user productivity and streamline task scheduling. The project will require learners to apply their knowledge of JavaScript, web development, and Dynamics 365 integration. The successful completion of this project will contribute to the larger initiative of creating a comprehensive time and task management system.

Dynamics 365 Time and Task Management System: Time Logging and Estimation

The project aims to enhance Microsoft Dynamics 365 by integrating a time and task management system inspired by Jira's time logging and estimation features. The primary goal is to develop a JavaScript-based web resource that allows users to track time spent on tasks and compare estimated versus actual effort within Dynamics 365. This integration will help users manage their time more effectively and improve project planning and execution. The project will focus on creating a user-friendly interface and seamless functionality that aligns with existing Dynamics 365 features. By providing accurate time tracking and effort comparison, the system will enable better resource allocation and project management. - Develop a JavaScript-based web resource for time tracking. - Integrate time logging and estimation features inspired by Jira. - Ensure seamless functionality within Microsoft Dynamics 365. - Create a user-friendly interface for easy navigation and use. - Enhance project planning and execution through accurate time tracking.

Dynamics 365 Time and Task Management System: Stopwatch Functionality

The goal of this project is to develop a Stopwatch Functionality integrated into Microsoft Dynamics 365, enabling users to efficiently track time spent on various tasks directly within the platform's forms or dashboards. This functionality is a crucial component of a larger time and task management system aimed at enhancing productivity and time management for users. By leveraging JavaScript, the project seeks to create a seamless and user-friendly experience that aligns with the existing Dynamics 365 interface. The stopwatch feature will allow users to start, pause, and reset timers, providing accurate time tracking for individual tasks. This project offers learners the opportunity to apply their knowledge of JavaScript and Dynamics 365 customization, focusing on creating a practical tool that enhances user interaction and data accuracy.

Automotive Parts Data Analysis for E-commerce Optimization

This project involves analyzing a dataset of over 10,000 automotive electrical system parts. The primary goal is to derive actionable insights from cleaned and organized data to inform pricing strategies and assembly recommendations for e-commerce platforms. Participants will focus on identifying pricing trends, OEM cross-references, and application details to enhance the company's competitive edge in the market. By leveraging classroom knowledge in data analysis, students will work with real-world data to uncover patterns and correlations that can drive strategic decisions. The project emphasizes the practical application of data analysis techniques to solve industry-relevant problems, providing a valuable learning experience for participants.

Automotive Parts Data Scraper Optimization

In the rapidly evolving automotive industry, managing and analyzing vast inventories of electrical system parts is crucial for efficient operations. This project focuses on enhancing data scraping techniques to streamline the extraction of market data for over 10,000 automotive parts. Participants will work on building or optimizing a Python-based scraper to efficiently gather data such as prices, conditions, OEM cross-references, and applications from various online sources, including supplier websites, Amazon, and eBay. The goal is to ensure accurate and comprehensive data collection that supports inventory management and market analysis. By simulating listings, learners will validate the effectiveness of their data extraction methods, ensuring reliability and accuracy in the gathered information.

Automotive Parts Data Standardization and Database Design

The project aims to streamline and enhance the management of automotive electrical system parts records by standardizing data from multiple spreadsheets into a unified format. Participants will focus on cleaning and standardizing these records, assigning unique SKUs, and resolving any missing data through cross-referencing or inspection. The ultimate goal is to design a relational database that will store the cleaned and standardized data, ensuring easy access and efficient management. This project provides an opportunity for learners to apply their knowledge of data management, database design, and data cleaning techniques in a real-world scenario.

Accounting/Bookkeeping Support

This project immerses learners in the role of an accounting technician or bookkeeper within a Canadian small to medium-sized business (SMB) context. Participants will engage in tasks such as bank reconciliations, payroll ledger reviews, vendor invoice processing, and general bookkeeping. The goal is to provide a practical introduction to Canadian financial documentation standards, compliance expectations, and workflow practices. Learners will gain hands-on experience in applying their international accounting knowledge to Canadian-specific systems and practices. This project supports the Bridging Program’s objectives by offering context-rich opportunities for learners to master the nuances of Canadian accounting procedures. The project is designed to be completed by a team of learners, offering a focused and intensive learning experience.

Business Central Migration and Automation Enhancement

This project aims to transition the Company from QuickBooks to Microsoft Business Central, enhancing their accounting processes through automation. The goal is to streamline financial operations, improve data accuracy, and ensure compliance with Canadian accounting standards. Learners will gain hands-on experience in migrating financial data, configuring Business Central, and automating routine accounting tasks. The project provides a practical opportunity to apply classroom knowledge of accounting systems and automation tools in a real-world setting. It is possible to consider this as two (2) projects - one that is focused on Migration to Business Central, while the second project covers Accounting Process Automation. By focusing on Canadian-specific systems and practices, learners will bridge their international experience with local industry standards. Key tasks include data mapping, system configuration, and testing automated workflows to ensure seamless integration and functionality.

Inventory Preparation for E-Commerce: Automotive Parts Data Standardization and Market Analysis

This project focuses on the critical task of cleaning and standardizing approximately 9,000 automotive parts records, which include units, subcomponents, armatures, drives, cores, and endplates. These records are spread across seven spreadsheets and require meticulous attention to detail to ensure consistency and accuracy. The goal is to streamline the data to facilitate efficient inventory management and enhance the e-commerce platform's functionality. Students will apply their classroom knowledge of data management and analysis to assign unique SKUs, ensuring each part is easily identifiable. Additionally, the project involves scraping or developing a scraper to gather market data, which will inform pricing strategies and assembly processes. This will include collecting information on pricing, conditions, and OEM cross-references, such as Bosch and Delco numbers. The project is designed to be completed in two parts, with the initial focus on data cleaning, allowing students to build a strong foundation before moving on to market data analysis.

AI Data Preparation and Visualization Project

This project involves preparing and structuring data to support AI deployment. The primary goal is to process a range of 2000 to 7000 project briefs and records, extracting and structuring data and conducting analysis of the data sets. Small groups will be assigned to specific subsets of the project that may include generating specific text-based output related to the data set, extracting and structuring the data from documents and aligning the data with a subset of 40 text-based fields and categorizing the copy type, such as social, web, or intranet. The project provides an opportunity for learners to apply their knowledge of data processing and Excel skills to real-world datasets. Additionally, some learners will have the opportunity to create a Candidate Tracking Dashboard to visualize recruitment metrics, enhancing their understanding of data visualization and dashboard creation. The project design allows for it to be completed by a team of learners from a single academic program, ensuring a cohesive skill set and efficient collaboration.

AI-Powered Time Blocking Engine for Dynamics 365

The project aims to develop an AI-powered time blocking engine within a custom Microsoft Dynamics 365 project management application. The primary goal is to optimize task scheduling by creating time blocks that consider due dates, priorities, employee work preferences, statutory holidays, and approved leaves. Unlike cloud-based solutions, this AI engine will run on an on-premises server using frameworks like TensorFlow or PyTorch, ensuring data privacy and compliance with organizational policies. The solution will seamlessly integrate with both new and existing entities within the Dynamics 365 environment. Additionally, it will feature an interactive calendar UI designed for both employees and managers to facilitate efficient task management. This project provides an opportunity for learners to apply their knowledge of AI, data privacy, and user interface design in a real-world setting.

Dynamics 365 Time and Task Management Enhancements

The project aims to develop a comprehensive time and task management system integrated into Microsoft Dynamics 365, leveraging JavaScript as a web resource. The primary goal is to enhance task tracking, time management, and effort analysis within the Dynamics 365 environment. This system will include three key functionalities: a custom stopwatch for precise time tracking, Jira-inspired time logging and estimation features for better project planning, and a workweek time entry functionality to streamline weekly task reporting. By implementing these features, the project seeks to provide a robust solution for managing time and tasks efficiently, allowing users to gain insights into their productivity and optimize their workflow. The project will be divided into three closely related tasks, each focusing on one of the functionalities, ensuring that learners can apply their classroom knowledge in a practical setting.

Leave and Absence Management System Enhancement

The goal of this project is to enhance the existing Dynamics 365 custom project management application by developing a Leave and Absence Management System. This system aims to streamline the process of employee leave requests, track time-off allotments, and manage statutory holidays across multiple regions. It will ensure compliance with organizational policies and maintain data security through role-based access. The system will integrate seamlessly with existing project management workflows, providing support for employees, managers, HR personnel, and project managers. Key features include a robust approval process, comprehensive audit trails, and clear visibility into leave balances and holidays. By implementing this system, the organization will improve efficiency in managing employee absences and ensure adherence to regional regulations.

Strategic Market Analysis and Prospect Development

The goal of this project is to provide an individual or small group of learners with an opportunity to apply their classroom knowledge in financial modeling and corporate strategy to real-world business development tasks. The project involves identifying new potential accounts or M&A targets that align with target segments. Learners will compile relevant market and industry information to develop comprehensive lists of prospects. They will also assist in creating customizable outreach scripts and follow-up materials to enhance strategic prospecting efforts. Additionally, the project includes tasks such as data input and cleaning, sales forecasting, and sales operations to support the business development team. Learners will conduct trend and opportunity analysis, and build visualizations using tools like Excel and Power BI to help business and corporate development managers better understand performance metrics.

Capstone Project: Personalized Health & Supplement Research

The project aims to explore the intricate relationship between biological and genetic factors and their impact on individual health outcomes. The project seeks to understand how personalized nutritional strategies can be developed to optimize well-being. Students will engage in comprehensive research to gather and analyze data on genetic markers and their correlation with health indicators. The goal is to identify patterns and insights that can inform personalized dietary recommendations. This project provides an opportunity for students to apply their classroom knowledge in genetics, nutrition, and data analysis to real-world scenarios. By focusing on evidence-based research, the project aims to contribute to the growing field of personalized medicine and nutrition.

Business Systems & Product Analyst (Dynamics 365 & Dataverse)

Mayk Ideas is looking to enhance its business systems by optimizing processes and refining product features within Microsoft Dynamics 365 and Dataverse. The project aims to define clear business requirements and design a scalable, user-friendly system. Learners will apply their knowledge of business analysis and enterprise applications to collaborate with stakeholders, ensuring the system meets organizational needs. The project provides an opportunity to gain hands-on experience in digital transformation and enterprise software development, focusing on UI/UX design for business applications. The goal is to create a robust system that enhances usability and supports future growth.

Health Data & BI Specialist (Dataverse & Power BI)

The project aims to design and develop a personalized health database for Mayk Ideas, focusing on structuring health data using Microsoft Dataverse. The goal is to integrate treatment plans and diagnostic tests into a cohesive system that supports personalized medicine. Additionally, the project involves building a genetics module and creating an interactive Power BI dashboard to visualize health data effectively. This project provides learners with the opportunity to apply their classroom knowledge in health analytics, data science, and biomedical informatics to a real-world scenario. By working on this project, learners will gain hands-on experience in health data management, analytics, and visualization, bridging the gap between healthcare and technology.

Executive Assistant & Project Support

The goal of this project is to enhance the efficiency of executive support tasks at Mayk Ideas by leveraging automation and business intelligence tools. The project focuses on streamlining calendar management, project coordination, and reporting processes. Students will apply their knowledge of business administration and technology to design and implement workflow automation using Microsoft Power Automate and Power BI. By optimizing these processes, the project aims to reduce manual effort and improve the accuracy and timeliness of information available to the executive team. This project provides an opportunity for learners to gain practical experience in process automation and the application of BI tools in a real-world business context.

Business Central Accounting & Automation Assistant

The goal of this project is to assist Mayk Ideas in the deployment of Microsoft Dynamics 365 Business Central, focusing on enhancing their accounting processes. The project will provide learners with the opportunity to apply their knowledge of accounting, finance, and business technology to a real-world ERP implementation. The team will work on setting up accounting processes, migrating existing data to the new system, and conducting thorough system testing to ensure seamless integration. Additionally, learners will explore automation opportunities using Power Automate to streamline business operations. This project is designed to give students hands-on experience with ERP systems and business intelligence tools, preparing them for future roles in business technology and finance.

IT Systems Optimization and Automation Project

The goal of this project is to enhance the efficiency and reliability of Mayk Ideas' IT systems through inventory management, automation, and device management. The project will involve a comprehensive review and optimization of current IT asset inventory processes, ensuring accurate tracking and management of all hardware and software assets. Additionally, the project will focus on developing automation scripts using PowerShell, Bash, or Python to streamline routine IT tasks and improve system backup processes. Learners will also research and configure Mobile Device Management (MDM) solutions, specifically Microsoft Intune, to enhance device security and management. This project provides an opportunity for learners to apply their classroom knowledge in scripting, system administration, and IT security in a real-world setting, while collaborating with the IT team to solve practical challenges.

Inventory Migration to Microsoft Dynamics 365

The goal of this project is to migrate Mayk Ideas' inventory data from an Excel spreadsheet into a robust database within Microsoft Dynamics 365, utilizing the Power Platform. This migration will involve repurposing an existing inventory system, such as Field Services, or other relevant services and apps within Dynamics. The project team will take the existing dataset and design and adapt it to fit the necessary tables, fields, and relationships within the Dynamics system. This project will provide learners with hands-on experience in data migration, database design, and the use of enterprise-level software solutions, allowing them to apply their classroom knowledge in a real-world scenario. Key tasks include: - Analyzing the existing Excel inventory data. - Designing the database schema in Dynamics 365. - Mapping and migrating the data to the new system. - Testing and validating the migrated data. - Documenting the migration process and any customizations made.

High Availability Backups

Mayk Ideas is seeking to enhance the robustness of its internal services, such as File Servers and Active Directory Domains. The goal is to mitigate the risk of severe system failures and minimize downtime. This project requires a comprehensive review and analysis of various methods, configurations, applications, and services that can improve the reliability and resilience of these systems. The team will need to consider factors such as cost, potential caveats, system requirements, and feature sets. The outcome should provide actionable recommendations that can be implemented to ensure continuous and reliable internal service operations. Key tasks include: - Researching current best practices for robust file server and Active Directory configurations. - Evaluating different applications and services that can enhance system resilience. - Analyzing the cost implications and requirements for each recommended method. - Identifying potential caveats and limitations of the proposed solutions.

Feature Review of Multi Device Management (MDM) Solutions

The goal of this project is to research and evaluate various Multi Device Management (MDM) solutions that support Windows, MacOS, Android, and iOS devices. The project team will focus on identifying and comparing key features and metrics of these MDM solutions. The primary objective is to create a detailed comparison document that highlights the strengths and weaknesses of each solution based on selected criteria. These criteria could include remote configuration capabilities, update management, device inventory, application installation, device wiping, and location tracking. This project will enable learners to apply their knowledge of IT management and systems analysis to a real-world problem, providing valuable insights for selecting the most suitable MDM solution for their needs.

Cybersecurity Capstone

What you'll do: For this project you will support the implementation of additional network and email security profiles and settings. Work on the Email side will involve profiles/filters setup to better manage spam and phishing emails as well as user safety and security. In addition, you may be asked to research, and provide recommendations and configurations for optimal setups and solutions that meet organizational needs.   Qualifications: Knowledge of Sophos Firewall or Basic terms and conditional access as well as firewall features and filtering methods. Knowledge of VPN configurations and use cases and configurations for OpenVPN. Knowledge of Microsoft Exchange Online Filtering and Policies. Knowledge of Intune MDM Knowledge of MDM for Android/iOS   Project Goal(s): Enhance and augment email security, systems and policies for daily use and varied onsite and remote stakeholders. In addition, provide a more efficient environment for management of users and access.

Capstone: Genetic-Based Supplement Formulation Development

The project focuses on the intersection of genetics and nutrition, aiming to create personalized supplement formulations based on genetic profiles. Students will analyze 72 key genes that play crucial roles in biological pathways such as metabolism, detoxification, neurotransmitter function, and immune response. By understanding the functional genetic relationships, the goal is to develop customized supplements that optimize health outcomes for individuals. This project provides an opportunity for learners to apply their knowledge of genetics, biochemistry, and nutrition to real-world applications. The project is designed to be completed by a team of students from a single academic program, ensuring a cohesive skill set and collaborative environment.

Features Review: Smart Building Solutions Integration Analysis

The project aims to conduct a comprehensive review and analysis of smart building and energy management products. The primary goal is to evaluate key technologies and compare product features to determine their effectiveness in intelligent automation and energy efficiency. The project will involve analyzing various hardware and software solutions to understand how they can be seamlessly integrated for optimal performance. Students will apply their classroom knowledge of energy systems, automation, and technology integration to assess the compatibility and potential benefits of different products. The project will also explore the latest trends in smart building technologies and their impact on energy management. By the end of the project, students will have a clear understanding of the current landscape of smart building solutions and their potential for future development.

MDM Device Management Scripting

Mayk Ideas is seeking to streamline and automate the setup of systems and management of mobile devices using Microsoft Intune. The goal of this project is to research, compare, and document the capabilities of Intune's out-of-the-box solutions for managing Android and iOS devices. The team will need to evaluate various options, document their findings, and provide a recommendations. Additionally, the project involves writing and testing management scripts using various scripting languages to push settings and configurations to Apple and Android devices through Intune. This project will enable learners to apply their knowledge of mobile device management (MDM), scripting, and system automation in a practical, real-world scenario.

Enhanced File Server Search and Reporting System

Mayk Ideas is seeking to improve its current file server system to enable users to quickly and efficiently search for and retrieve older project details. The existing system lacks robust indexing and search functionality, making it difficult for users to find specific files or generate reports. The goal of this project is to develop an enhanced indexing and search functionality that integrates with the existing file server, potentially leveraging a database for improved performance. This enhancement will streamline the process of locating project files and generating comprehensive reports, thereby increasing overall productivity and user satisfaction. Key points: - Improve search and retrieval efficiency for older project details. - Develop robust indexing functionality. - Integrate search capabilities with the current file server. - Utilize a database for enhanced performance. - Facilitate easy report generation from the system.

Enhanced File Server Search and Reporting System

Mayk Ideas is seeking to improve its file server capabilities to allow users to quickly and efficiently search for and retrieve older project details, as well as generate reports from the current system. The current system lacks an effective indexing and searching mechanism, which hampers productivity and data accessibility. The goal of this project is to develop an indexing and searching solution that operates off a database, thereby enhancing the overall user experience. Learners will be tasked with designing and implementing a database-driven indexing system, integrating it with the existing file server, and ensuring it meets the performance and usability requirements. This project will provide learners with the opportunity to apply their knowledge of database management, indexing algorithms, and software integration.

Analytics Capstone – BI Dashboards

What you'll do: You will update and improve upon a number of Power BI Dashboards that are intended to support the building of better reports and analytics. Using several sources of data, you will either transform, amalgamate or build the data into reports and visuals for easier use and understanding by users.   Qualifications: Knowledge or Ability to learn Microsoft Power BI Basic or Advanced understanding of Microsoft Office Excel features such as Data Connections/Data Sources  Pivot Tables Formulas Multi Table References Data Validation Knowledge or Ability to learn Microsoft SharePoint Lists Knowledge or Ability to learn Microsoft Power Automate and/or Microsoft Power Query   Project Goal(s): Creation of a series of reports that can be automatically updated and will provide as much information to each team that needs it; and will be in one location to reduce work exporting and building reports by hand. Provide users with the ability to select a few dropdowns or filters on a report to get their needed data.