Assignments

Instruction From the lookup sheet, use Xlookup to return the plant column from lookup sheet into shipment sheet and name it loading point. Replace not found with Depot. Generate a pivot summary showing counts of shipment by loading point and Total Km they are meant to cover

Replicate same DAX functions to achieve same results that was treated in class.

Load Dataset into Power BI, do a proper relationship of other sheets to the “Dataset” sheet and create a simple chart to confirm that the relationship is well established

Kindly use the dataset uploaded on the WhatsApp platform to recreate the dashboard we created during the class. 

Instruction Use either Xlookup or Vlookup to return Fleet column from the fleet sheet into cost sheet. Create a column on the cost sheet calculating the registration age of the vehicles

Kindly find attached the dataset needed for this assignment. Replicate steps carried out in the dataset as seen by the left side of the worksheet.Use the details in sheet 2 to give a rank to your students and (ii)also fill in the Status columns in the Camanda Bank PLC table using the AND, OR &

In this assignment, you will be provided with a pre-built complex flow that has performance issues. Your task is to analyze the flow, identify bottlenecks, and implement optimizations to improve its efficiency and reliability.

Develop a Power Automate flow that automates data entry and updates in Excel. Your task is to create a flow that extracts data from emails and updates an Excel spreadsheet in real-time. Submit a detailed report of your workflow design and execution.

Create a Power Automate workflow that automates a multi-stage approval process. The assignment requires integrating with external systems, handling exceptions, and ensuring data integrity throughout the workflow.

For this assignment, design a custom flow to automate a task of your choice. Document the trigger and actions you selected, and explain why they are appropriate for your task. Submit a flow blueprint and a brief description of its functionality.

For this assignment, research and identify three real-world use cases where Power Automate can be effectively applied. Provide a brief description of each use case and explain how automation can benefit the scenario.

Feel free to apply any of the knowledge acquired during your learning period on the file.

Practical session on using diagnostic tools to measure emissions Hands-on activity: Identifying emission-reducing techniques during a vehicle inspection

Technicians share current practices and identify opportunities for greenerapproaches

In this assignment, you will review and provide constructive feedback on your peers’ dashboard projects. This exercise will help you develop critical evaluation skills and learn from different approaches to dashboard design and implementation.

For your final assignment, design and implement a realtime dashboard using Power BI and Dataverse. Choose a dataset and scenario relevant to a particular industry, and demonstrate your ability to integrate data, create meaningful visualizations, and deliver actionable insights.

In this assignment, you will create a complex, multi-dimensional dashboard using Power BI. Incorporate advanced visualization techniques and best practices to ensure clarity, functionality, and user engagement. Submit your .pbix file for review.

Apply the concepts learned to design a basic realtime dashboard in Power BI using data from Dataverse. Your task is to integrate key metrics and enable live data updates, ensuring the dashboard reflects changes in data instantaneously.

In this assignment, you will connect a Dataverse environment to Power BI. Follow step-by-step instructions to import data and create a simple dashboard. Document any challenges faced and solutions applied during the process.

Apply your skills by iterating on a set of provided prompts. Modify them to improve their effectiveness based on specified goals and metrics. Submit your revised prompts along with a justification for each change.

In this assignment, students will create a series of prompts aimed at achieving specific outcomes using a given AI model. They will then analyze the results and provide a written report comparing the effectiveness of each prompt.

Create a set of prompts designed to elicit specific types of responses from an AI. Students will apply techniques learned in the module to craft prompts that are clear, concise, and contextually appropriate.

Select an AI model of your choice and conduct a detailed analysis of its capabilities and limitations. Prepare a report that includes the model’s architecture, common applications, and potential biases. Provide real-world examples of its usage.

In this assignment, students will analyze a set of AI-generated outputs and the corresponding prompts used to generate them. The task is to identify what makes these prompts effective and suggest improvements for suboptimal ones.

Create relationships between multiple tables Use basic DAX functions to create new calculated columns

Create basic visualizations (bar chart, pie chart, line chart) Build your first report using multiple visualizations

Import data from Excel and CSV files into Power BI Perform basic data cleaning using Power Query Editor

Install Power BI Desktop Explore the Power BI interface Load sample data into Power BI

Students will work on a data analysis project of their choice (e.g., analyzing sales data, survey data, etc.) Applying learned concepts such as data cleaning, summarization, and visualization

Creating a simple budget or sales report

Students will submit a mid-project progress report that details the steps taken so far in their capstone project. The report should include a reflection on any challenges encountered, adjustments made to the original plan, and preliminary outcomes of implemented practices.

In this assignment, students are required to submit a detailed project proposal outlining the facility management practices they intend to implement. The proposal should include a background of the facility, identified challenges, proposed solutions, and a timeline for implementation.

Develop a comprehensive maintenance plan for a hypothetical facility. The assignment requires identifying key assets, scheduling maintenance activities, and incorporating predictive maintenance tools.

Create a strategic plan for a hypothetical facility, focusing on aligning resources with organizational goals. Your plan should include a mission statement, strategic objectives, and a resource allocation strategy.

Analyze a case study of a real-world facility operation. Identify the key operational strategies employed and suggest improvements based on the principles learned in the module. Present your findings in a detailed report.

Analyze a provided case study to identify key facility management challenges and propose solutions. This assignment will help you apply theoretical knowledge to real-world scenarios, enhancing your problem-solving skills in facility management.

Apply your knowledge of soft skills in leadership by analyzing a series of hypothetical scenarios. Provide solutions and strategies that demonstrate your understanding of effective leadership practices.

For this assignment, students will analyze a provided case study involving a team conflict scenario. They will identify the conflict sources, propose resolution strategies, and reflect on the potential outcomes of their proposed solutions.

In this assignment, you will apply empathy-building strategies to a real-world leadership scenario. Write a reflection on how you can enhance your ability to understand and share the feelings of others in a leadership context. Include examples of how empathic leadership can improve team morale and productivity.

Reflect on your own nonverbal communication habits and identify areas for improvement. Record a short video presentation and analyze your body language, eye contact, and facial expressions to enhance your nonverbal communication skills.

In this assignment, students will reflect on their own leadership experiences and identify the soft skills that they currently possess and those they wish to develop. They will write a short essay discussing how these skills have impacted their leadership style and effectiveness.

In this assignment, students will review and critique the asset management plans of their peers. The focus will be on evaluating the integration of strategies and providing constructive feedback to enhance each plan’s effectiveness.

For this capstone project, students are required to develop a comprehensive asset management plan for a fictional company. The plan should incorporate strategies learned throughout the course, addressing financial performance, risk mitigation, and operational efficiency.

Analyze a real-world case study that focuses on risk management and performance measurement in asset management. Identify the key strategies used and evaluate the effectiveness of the risk management techniques applied.

Create a comprehensive asset allocation plan for a hypothetical client. Consider factors such as investment horizon, risk tolerance, and financial goals. Provide a rationale for your asset mix and any assumptions used in the planning process.

Analyze a real-world company and apply valuation techniques learned in the module. Prepare a report detailing your valuation process, assumptions, and final valuation for the company’s equity.

For this assignment, analyze a case study on a real-world application of asset management. Identify the strategies used and evaluate their effectiveness. Provide recommendations for improvement based on the principles covered in the module.

For this assignment, students will create a comprehensive maintenance plan for a hypothetical air conditioning system. The plan should include a schedule for regular maintenance tasks, a checklist for inspections, and a contingency plan for unexpected failures. Students are encouraged to consider real-world constraints and resources.

For this assignment, students will analyze a detailed case study of a malfunctioning air conditioning system. They are required to apply advanced diagnostic techniques to evaluate the issues and propose a comprehensive maintenance plan.