peacetheboy/power-bi-business-intelligence-

Power BI

EcoPower Logistics Report Project

Overview

EcoPower Logistics comprehensive logistics solutions tackle the complexities of acquiring, storing, and transporting resources and goods globally. This project aims to create a Power BI report that enables stakeholders to monitor orders and product sales. The report is built using Power BI and is designed to provide a high-level view of crucial data for decision-making.

Tasks

To organize this project

• Project Progress

  • Create and Configure GitHub Repository
  • Create a repository for the project
  • Create a README.md file to describe the project and how to use the report.
  • Commit and push the report to source control.
  • Update the GitHub project iteratively to demonstrate progress.

• Project Setup:

• Create the Reporting Project

• Clone your GitHub repository to your desktop.

• Install Power BI Desktop.

• Create a new Power BI Report named 'EcoPower Logistics – Order Monitoring'.

Process followed creating this project

To get started with this project, follow these steps:

1. create and clone the GitHub repository.
2. Install Power BI Desktop and sign in with your organizational account to access everything.
3. Get the excel Data provided.
4. Configure secure connections to data sources.
5. Clean the provided Data and check for any Typing error and remove null rows.
6. Create various pages for different aspects of the report.
7. Start building the Power BI report.
8. Add pages, High Level Overview, Order Monitoring, Product monitoring and customer Monitoring
9. Create visualizations for high-level metrics, order monitoring, product monitoring, and implement filtering.
10. Add filters for all pages
11. Create live connection and publish
12. Document how to use the report in the README.md.
13. Create a reference list of sites and resources used for the project.

How to use this report?

1. To use this Power BI report, one must navigate to the high level overview to get the summary of the data collected
2. On the high level metrics, make use of filters to view data
3. Next, Navigate to the Order Monitoring page to see the detailed information about orders, number of customers and quantity available
4. navigate to the product monitoring page to monitor all the products available, you can filter this by category to check the number of products per category
5. lastly, the customer monitoring page will show a table of all customers and their details such as order id, delivery address and phone numbers

Report Preview

References

List of sites and resources used for this project.

1. (2023). 6 June. Available at: https://youtu.be/NNSHu0rkew8?si=G37hqWEKzHhfVyOw (Accessed: 20 October 2023).
2. (2023). YouTube. 9 February. Available at: https://www.youtube.com/live/77jIzgvCIYY?si=vTOmcIK8Q5NVA6GI (Accessed: 20 October 2023).
3. (2023). 24 October. Available at: https://youtu.be/8QSVnwcYzIo?si=PY8eL72cK7fKCaEy (Accessed: 20 October 2023).
4. (2021). 18 September. Available at: https://youtu.be/0BKlUySopU4?si=X1l_xsdXszasYTfZ (Accessed: 22 October 2023).
5. Power bi dev camp session 35 - power bi embedding best practices with the power bi javascript API (2023) YouTube. Available at: https://youtu.be/IlXl1-aiJEc?si=auRXYBSvgXY-Qa9- (Accessed: 22 October 2023).
6. (2022). 3 November. Available at: https://youtu.be/GpP0EbSMRpg?si=_f6VtcpXvMU0efko (Accessed: 22 October 2023).
7. (2020). 2 November. Available at: https://youtu.be/Z2t7l8b1uWU?si=u3d_B6GSBYeDttMK (Accessed: 22 October 2023).
8. (2022). 10 October. Available at: https://youtu.be/v6fP8gyCLLc?si=-Xi1i3mi1TCW_TYm (Accessed: 24 October 2023).
9. (2023). 28 September. Available at: https://youtu.be/ZSrVOyKAC4Y?si=WdK90uRc3502QbrG (Accessed: 24 October 2023).
10. (2023). 22 March. Available at: https://youtu.be/ScRA9dkm4WY?si=zZZ8wxssZ3Q-UqVv (Accessed: 24 October 2023).
11. (2023). 19 January. Available at: https://youtu.be/mCUfmanCpIQ?si=p4d6X95PWK72JI51 (Accessed: 25 October 2023).
12. (2020). 16 June. Available at: https://youtu.be/cTqFNg_y9lw?si=ZxLsf-StDEneEyFO (Accessed: 25 October 2023).
13. (2020). 22 June. Available at: https://youtu.be/jrRwPMIAT_M?si=ZHyiURYNOg0lIZrh (Accessed: 25 October 2023).
14. (2022). 24 January. Available at: https://youtu.be/rIEd9KrS5NY?si=oHGJE8yivcs-U1N7 (Accessed: 26 October 2023).
15. (No date). Available at: https://learn.microsoft.com/en-us/power-bi/fundamentals/fabric-get-started (Accessed: 26 October 2023).
16. (2022). 2nd Watch. 22 November. Available at: https://www.2ndwatch.com/blog/high-level-overview-of-power-bi/ (Accessed: 26 October 2023).
17. Suman (2023) What is power bi desktop - A guide to microsoft power BI desktop, Intellipaat Blog. Available at: https://intellipaat.com/blog/power-bi-desktop/ (Accessed: 26 October 2023).
18. Suman (2023) What is Power Bi - architecture, features and components: Intellipaat, Intellipaat Blog. Available at: https://intellipaat.com/blog/what-is-power-bi/#no6 (Accessed: 26 October 2023).
19. Compton, J. (2022) The Microsoft Power BI Guide for Businesses, Pragmatiq. Available at: https://www.pragmatiq.co.uk/the-microsoft-power-bi-guide-for-businesses/ (Accessed: 26 October 2023).
20. (2020). 17 November. Available at: https://youtu.be/2CXhHe4DU9Q?si=bAa1Hy7IO0pOrJrl (Accessed: 26 October 2023).
21. Power bi (2022) YouTube. Available at: https://youtu.be/0c2Q365tdz8?si=QIhHr356HaDQRWPY (Accessed: 26 October 2023).
22. Lesson 16 how to load rest API post call data into power BI Desktop. DO SUBSCRIBE...!!! (2021) YouTube. Available at: https://youtu.be/gIErefQv3Pk?si=ezgrHvVe5LaFYdvF (Accessed: 26 October 2023).
23. (2023). 13 October. Available at: https://youtu.be/gv58fGGgRQs?si=Nh6wElbbWfznUncK (Accessed: 26 October 2023).
24. (2023). 11 October. Available at: https://youtu.be/HrPipzMA5gk?si=tiY5iSARUiwlc7vG (Accessed: 26 October 2023).
25. (2019). 7 May. Available at: https://youtu.be/4xapOrfLvbg?si=VXDOB2Bpqh2oubNC (Accessed: 26 October 2023).

power-bi-business-intelligence-'s Issues

img3

img4

img7

img 5

image

IMG2