Welcome to the EcoPower Logistics Power BI Report Project repository! This project focuses on creating a comprehensive Power BI report to analyze and visualize logistics data for EcoPower Logistics. As a member of the development team, your role is to acquire and practice the necessary skills to create a report that provides valuable insights into customer orders, product sales, and other relevant metrics.
EcoPower Logistics provides comprehensive logistics solutions that tackle the complexities of acquiring, storing, and transporting resources and goods globally. Through their logistics management system, orders are received and processed, while the warehouse serves as a secure storage facility. The data stored can be shared in different ways, including visualizations built into a report or dashboard. The company has opted to use Power BI to create a report that allows stakeholders to monitor the status of customers and their orders.
As the company needs to analyze and visualize the data for easy interpretation, Power BI is utilized to create graphs, tables, cards, and other visuals summarizing the data. The report consists of four pages:
High-Level Metrics: Provides information that may influence decision-making.
Order Monitoring: Offers insights into order status and progress.
Product Monitoring: Displays information about product sales and performance.
Customer Monitoring: Summarizes information about customers over time and other relevant metrics.
The report includes various graphs and filters to facilitate easy interpretation and customization of the displayed information. Data is imported from the provided Excel document, and the SQL Server database is connected as a datasource.
Link to Power BI Report: https://app.powerbi.com/links/8C9emC73K8?ctid=b14d86f1-83ba-4b13-a702-b5c0231b9337&pbi_source=linkShare
SQL Server Database: llaytont-cmpg323.database.windows.net
Due to the fact that I am not a student anymore, the database may not work because the details are deactivated.
The EcoPower Logistics Power BI Report Project aims to provide stakeholders with valuable insights into logistics data through comprehensive visualizations and analysis. Thank you for your interest in the project!
Author: Llayton Titus
Contact: [email protected]
- Analyst, A. T., n.d. Full Power BI Guided Project | Microsoft Power BI for Beginners, s.l.: Youtube.
- Analytics, L. A. C., 2022. What are filters & the different types of filters in Power BI?, s.l.: Youtube.
- Biswal, A., 2023. An introduction to Power BI Dashboard. [Online] Available at: https://www.simplilearn.com/tutorials/power-bi-tutorial/power-bi-dashboard [Accessed 23 October 2023].
- Biswal, A., 2023. Power BI Vs Tableau: Difference and Comparison. [Online] Available at: https://www.simplilearn.com/tutorials/power-bi-tutorial/power-bi-vs-tableau [Accessed 23 October 2023].
- Biswal, A., 2023. Simplilearn. [Online] Available at: https://www.simplilearn.com/tutorials/power-bi-tutorial/what-is-power-bi [Accessed 23 October 2023].
- Coursera, 2023. What Is Power BI? What It Is, How It’s Used, and More. [Online] Available at: https://www.coursera.org/articles/what-is-power-bi [Accessed 23 October 2023].
- Cube, G. i. a., 2021. Power BI slicers vs the filter pane (2021), s.l.: Youtube.
- Explains, K., 2023. Top 5 Awesome Power BI Visuals You Probably Didn't Know, Potchefstroom: Youtube.
- Gharani, L., 2022. 10 Power BI Tips for Better Dashboards | Are you using these in your Power BI reports?, s.l.: Youtube.
- Gharani, L., 2022. How To Create these useful Power Bi Visuals that Excel Lacks, Potchefstroom: Youtube.
- Gharani, L., 2022. Power BI Tutorial For Beginners | Create Your First Dashboard Now (Practice Files included), Potchefstroom: Youtube.
- Gharani, L., 2023. Easiest Way to Edit Visuals in Power BI - Watch before using the new features (Includes hidden tips), s.l.: Youtube.
- Guy, T. P. B., 2021. How to Use Calculate & Filter() in Power BI to Change Filter Context, s.l.: Youtube.
- Lalwani, P., 2020. 6.5 How to create a Filter on Visual in Power BI |Power BI Tutorial for Beginners | By Pavan Lalwani, s.l.: Youtube.
- learn, M., 2023. Drill mode in the Power BI service. [Online] Available at: https://learn.microsoft.com/en-us/power-bi/consumer/end-user-drill [Accessed 23 October 2023].
- learn, M., 2023. Reports in Power BI. [Online] Available at: https://learn.microsoft.com/en-us/power-bi/consumer/end-user-reports [Accessed 23 October 2023].
- learn, M., 2023. Slicers in the Power BI service. [Online] Available at: https://learn.microsoft.com/en-us/power-bi/consumer/end-user-slicer [Accessed 23 October 2023].
- learn, M., 2023. Visualization types in Power BI. [Online] Available at: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a [Accessed 23 October 2023].
- learn, M., 2023. Visualizations in Power BI reports. [Online] Available at: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-report-visualizations [Accessed 23 October 2023].
- Michals, B., 2022. Power BI Slicers vs Filters - How To Choose?, s.l.: Youtube.
- Scardina, J., 2023. DEFINITION. [Online] Available at: https://www.techtarget.com/searchcontentmanagement/definition/Microsoft-Power-BI [Accessed 22 October 2023].
- Stratvert, K., 2020. How to use Microsoft Power BI - Tutorial for Beginners, Potchefstroom: Youtube.
- Stratvert, K., 2023. Power BI Tips and Tricks, s.l.: Youtube.
- Stratvert, K., 2023. Power BI Tutorial for Beginners, Potchefstroom: Youtube.
- Works, P., 2022. Data Modeling for Power BI [Full Course], Potchefstroom: Youtube.
- Works, P., 2023. Hands-On Power BI Tutorial Beginner to Pro 2023 Edition [Full Course], Potchefstroom: Youtube.