Power BI Financial Report
- Client Fictional company
- Date May 2024
A project manager is responsible for overseeing projects from start to finish, coordinating tasks, resources, budgets, and ensuring delivery.
Manage data analysis tasks from initial data collection to deriving insights, preparing reports, until finalizing data-driven recommendations for process improvements
I’ll help you optimize your business processes to maximize profitability and eliminate unnecessary costs.
Objective:
This project aimed to develop a comprehensive, friendly, and visually appealing Power BI dashboard to analyze the finances from a company, providing real-time insights for stakeholders.
Goals:
◾ Track key performance metrics (KPIs) and trends for the company.
◾ Empower stakeholders with real-time data for better decision-making.
◾ Make it as simple and comprehensive as possible so that anyone can understand it.
Activities:
◾ Data Integration: Connected to various data sources like CSV and Excel files to gather transaction information.
◾ Data Cleaning & Transformation: Prepared the data by ensuring accuracy and consistency, making it suitable for analysis.
◾ Optimize the model: Make key DAX measurements that allow us to have all the information needed without loading the model.
◾ Dashboard Design: Utilize Figma to make a powerful dashboard design with a bit of complexity to make it appealing for everyone while not loading the data model with unnecessary Power BI design options.
Key Findings and recommendations:
◾ Review the enterprise category: While analyzing the data, by first hand you can notice that the “Enterprise” Category is only showing losses throughout the whole period filtered.
Actions:
◾ Review the cost of goods: it is easy to notice that the profit made is approximately 13% of the gross sales.
Actions:
◾ Reevaluate the discounts: We can see in the dashboard that the total amount of discounts provided are more than half of the profit made.
Actions:
DAX Formulas used:
ADDCOLUMNS (
CALENDAR(MINX(‘Sheet1’,‘Sheet1’2024),MAXX(‘Sheet1’,‘Sheet1’2024)),
“DateAsInteger”, FORMAT ( 2024, “YYYYMMDD” ),
“Year”, YEAR ( 2024 ), “MonthNo”, FORMAT ( 2024, “MM” ),
“YearMonthNo”, FORMAT ( 2024, “YYYY/MM” ),
“YearMonth”, FORMAT ( 2024, “YYYY/mmm” ),
“MonthShort”, FORMAT ( 2024, “mmm” ),
“MonthLong”, FORMAT ( 2024, “mmmm” ),
“WeekNo”, WEEKDAY ( 2024 ),
“WeekDay”, FORMAT ( 2024, “dddd” ),
“WeekDayShort”, FORMAT ( 2024, “ddd” ),
“Quarter”, “Q” & FORMAT ( 2024, “Q” ),
“YearQuarter”, FORMAT ( 2024, “YYYY” ) & “/Q” & FORMAT ( 2024, “Q” ))
Screenshots:
Data Model:
Objective:
The objective is to provide stakeholders with insights into mission details, success rates, and the usage of space rockets, facilitating informed decision-making and enhancing understanding of past, current, and future space missions.
Goals:
◾ Track key performance metrics (KPIs) and trends for the company.
◾ Empower stakeholders with real-time data for better decision-making.
◾ Make it as simple and comprehensive as possible so that anyone can understand it.
Activities:
◾ Data Integration: Connected to a CSV file to gather Space Missions information.
◾ Data Cleaning & Transformation: Used Power Query to Prepare the data by ensuring accuracy and consistency, making it suitable for analysis.
◾ Optimize the model: Make key DAX measurements that allow us to have all the information needed without loading the model.
◾ Dashboard Design: Utilize Figma to make a beautiful and minimalist dashboard design able to showcase the most important information for the stake holder. It is intended to have an intuitive and friendly user experience. Since it has a fresh and minimalist look, a Q&A visual was added on the filter pane so that the user can get any other analytic that is not shown on the dashboard.
Key Findings and recommendations:
◾ Success rate: It is safe to say that most of the missions performed have been successful.
◾ Prelaunch Failures: The prelaunch failures are less than 1% of the total missions performed, which means that the process involved has been carefully crafted.
DAX Formulas used:
CALCULATE(
COUNTA(space_missions[MissionStatus]),
FILTER(space_missions,space_missions[MissionStatus]=“Failure”)
) + 0
CALCULATE(
COUNTA(space_missions[MissionStatus]),
FILTER(space_missions,space_missions[MissionStatus]=“Partial Failure”)
) +0
CALCULATE(
COUNTA(space_missions[MissionStatus]),
FILTER(space_missions,space_missions[MissionStatus]=“Prelaunch Failure”)
) +0
CALCULATE(
COUNTA(space_missions[MissionStatus]),
FILTER(space_missions,space_missions[MissionStatus]=“Success”)
) +0
Screenshots:
Data Model:
Objective:
This project aims to create a dynamic and user-friendly Power BI dashboard for an electronic retailer, offering in-depth analysis of sales data and customer behavior.
Goals:
◾ Track key performance metrics (KPIs) and trends for the company.
◾ Empower stakeholders with real-time insights for better decision-making.
◾ Make it as simple and comprehensive as possible so that anyone can understand it.
◾ optimize sales strategies, and enhance overall business performance in the competitive electronic retail market.
Activities:
◾ Data Integration: Connected to various CSV and excel files to gather sales and customer behavior information.
◾ Data Cleaning & Transformation: Used Power Query to Prepare the data by ensuring accuracy and consistency, making it suitable for analysis.
◾ Optimize the model: Make key DAX measurements that allow us to have all the information needed without loading the model as well of a more complex formula to connect the exchange rate. It was also added a date table for avoiding many to many relationships between the exchange table and the sales table.
◾ Dashboard Design: Utilize Figma to make an informative dashboard design able to showcase the most important information for the stake holder.
Key Findings and recommendations:
◾ Least sold products: there are quite a few products that were sold only once.
Actions:
◾ Profit fluctuation over the year: At first glance, it seems that there is an unusual behavior in the profit trend.
Actions:
◾ Bost Online Sales: As of now, online sales are the most beneficial for the company, leaving almost half of the profit of the year.
Actions:
◾ Customer’s age: Most of the customers range from 23 to 47 years old.
Actions:
DAX Formulas used:
COGS =
SUMX(
Sales,Sales[Quantity]*
RELATED(Products[Unit Cost USD])*
LOOKUPVALUE(Exchange_Rates[Exchange],
Exchange_Rates[Date], Sales[Order Date].[Date],
Exchange_Rates[Currency],Sales[Currency Code]
))
Gross Sales =
SUMX(
Sales,Sales[Quantity]*
RELATED(Products[Unit Price USD])*
LOOKUPVALUE(Exchange_Rates[Exchange],
Exchange_Rates[Date], Sales[Order Date].[Date],
Exchange_Rates[Currency],Sales[Currency Code]
))
Profit =
SUMX(
Sales,
Sales[Quantity]*
(RELATED(Products[Unit Price USD]) – RELATED(Products[Unit Cost USD]))*
LOOKUPVALUE(Exchange_Rates[Exchange],
Exchange_Rates[Date], Sales[Order Date].[Date],
Exchange_Rates[Currency],Sales[Currency Code]
))
DateTable =
ADDCOLUMNS (
CALENDAR(MINX(‘Sales’,‘Sales'[Delivery Date]),MAXX(‘Sales’,‘Sales'[Delivery Date])),
“DateAsInteger”, FORMAT ( 2024, “YYYYMMDD” ),
“Year”, YEAR ( 2024 ), “MonthNo”, FORMAT ( 2024, “MM” ),
“YearMonthNo”, FORMAT ( 2024, “YYYY/MM” ),
“YearMonth”, FORMAT ( 2024, “YYYY/mmm” ),
“MonthShort”, FORMAT ( 2024, “mmm” ),
“MonthLong”, FORMAT ( 2024, “mmmm” ),
“WeekNo”, WEEKDAY ( 2024 ),
“WeekDay”, FORMAT ( 2024, “dddd” ),
“WeekDayShort”, FORMAT ( 2024, “ddd” ),
“Quarter”, “Q” & FORMAT ( 2024, “Q” ),
“YearQuarter”, FORMAT ( 2024, “YYYY” ) & “/Q” & FORMAT ( 2024, “Q” ))
Screenshots:
Data Model:
Led development teams, ensured timely project delivery with meticulous planning and risk management. Managed budgets, allocated resources, and maintained product quality. Initiated strategic projects aligning with organizational goals, conducted market research, and engaged stakeholders.
Led multidisciplinary teams through 35+ innovation, automation, and cybersecurity projects, ensuring timely delivery and high-quality outcomes. Managed budgets, allocated resources, and reduced costs by 30% through strategic drone and ML applications. Fostered strong supplier relations and localized projects, slashing expenses by 70%.
Led full-cycle automation and instrumentation projects, cutting operational load by 20%. Spearheaded 30% automation of Maya plant, driving 15% energy savings. Oversaw SCADA systems for 99% reliability. Implemented programs ensuring compliance with Swiss corporate control standards.
Developed and implemented strategic maintenance procedures enhancing functionality and reliability of electrical equipment. Evaluated and mitigated electrical hazards, fostering a safe, productive work environment.
Effectively coordinated structured cabling project across 15 US and Canadian sites, ensuring 100% on-time delivery. Utilized agile methodologies to optimize workflows and project development, ensuring success. Prioritized resource efficiency, minimizing expenses while upholding quality standards.
Successfully coordinated 25+ fire protection projects in San Francisco, achieving 100% NFPA standards compliance. Managed budgets and resources to maximize project value and ensure completion. Led all project phases from quotation to state approval, applying project management and agile methodologies.
Focuses on advanced knowledge and skills to optimize operations, streamline processes, and enhance efficiency
Emphasizes advanced expertise to optimize systems, streamline processes, and enhance energy efficiency in electrical operations and industrial automation technologies.
Ffocuses on developing expertise in programming, troubleshooting, and optimizing industrial control systems for enhanced efficiency and productivity in manufacturing environments.
All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary
1 Page with Elementor
Design Customization
Responsive Design
Content Upload
Design Customization
2 Plugins/Extensions
Multipage Elementor
Design Figma
MAintaine Design
Content Upload
Design With XD
8 Plugins/Extensions
All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary
5 Page with Elementor
Design Customization
Responsive Design
Content Upload
Design Customization
5 Plugins/Extensions
Multipage Elementor
Design Figma
MAintaine Design
Content Upload
Design With XD
50 Plugins/Extensions
All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary
10 Page with Elementor
Design Customization
Responsive Design
Content Upload
Design Customization
20 Plugins/Extensions
Multipage Elementor
Design Figma
MAintaine Design
Content Upload
Design With XD
100 Plugins/Extensions
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks.
Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lo rem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
A programming language is for thinking about programs, not for expressing programs you’ve already thought of. It should be a pencil, not a pen.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks. Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks. Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida. Risus commodo .
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks. Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lo rem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks.
Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lo rem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
A programming language is for thinking about programs, not for expressing programs you’ve already thought of. It should be a pencil, not a pen.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks. Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks. Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida. Risus commodo .
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks. Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lo rem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks.
Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lo rem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
A programming language is for thinking about programs, not for expressing programs you’ve already thought of. It should be a pencil, not a pen.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks. Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks. Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida. Risus commodo .
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don’t look even slightly believable. If you are going to use a passage of Lorem Ipsum. You need to be sure there isn’t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend toitrrepeat predefined chunks. Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
Necessary, making this the first true generator on the Internet. It re are many variations of passages of Lo rem Ipsum available, but the majority have suffered alteration in some form, by injectedeed eedhumour, or randomised words which don’t look even slightly believable.
Connect with me via linkedin or feel free to give me a call.
Phone: +503 7922-2420 Email: [email protected]