Assignments

Kindly follow the instructions given in each of the assignment pages to attempt the tasks mentioned there. Afterwards, re-attach your solved file on the submission part of the platform.

Instruction has been provided on the slide to be projected during the live session.

Ensure it looks nice and communicates insights. 

Recreate the dashboard created in class

Upload the completed dashboard from previous assignment to Power BI service and share the report to learners and I.

Using the file for Week 3’s class, recreate the dashboard that was created during the class. Feel free to use the color and visual of your choice and ensure they are nicely arranged.   

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

Create a dashboard based on your understanding of the attached file. Applying the concepts covered in this week’s lesson, ensure you include visual(s) showing business goal and actual in the dashboard.

Upload the completed dashboard from previous assignment to Power BI service and share the report to learners and I.

Using the file for Week 3’s class, recreate the dashboard that was created during the class. Feel free to use the color and visual of your choice and ensure they are nicely arranged.   

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.