Northwind Traders

-




The goal of the project to find out the top KPIs of the company.

I have categorized my dashboard report into four category:

  • Products: Which products are the top revenue generating?
  • Sales: What is the sales trend of the company over the last three years?
  • Customers: Who are the customers? Which countries or region has highest revenue or more number of customers?
  • Shipping: Who is the top shipper? what is the average time of delivery? which coutries are paying more freight charges than generating revenue?

Through this above points, you can find out the top areas where company is doing great and where the company needs to improve.

Tool Used: Power BI




Comments

Post a Comment

Popular posts from this blog

How to create a Word Cloud in R

-
Image
I have seen Word-cloud in so many places such as magazines, websites, blogs, etc. however never thought of making it by myself. I would like to thank R that taught me such a wonderful technique which everybody would like to learn. I don’t know if there are any other free options are available to create word-cloud. Let me give a quick explanation about R first, R is a free source packages and very useful for statistical analysis. We can use R for various purposes, from data mining to data visualization. Word-cloud is a tool where you can highlight the words which have been used the most in quick visualization. If you know the correct procedure and usage, then Word Cloud is simple in R Studio. Further, a package called “Word-cloud” is released in R, which will help us to create word-cloud. You can follow my simple four steps mentioned below to create word-cloud. Those are new to R or Word Cloud, I would suggest first install R studio from the link rstudio.com Also, the following...
Read more

Free Cash Flow to the Firm (FCFF) v/s Free Cash Flow to Equity(FCFE)

-
Shows both the Free Cash Flow to Firm (FCFF) and Equity components of the valuation of an enterprise. Free Cash Flow to the Firm v/s Free Cash Flow to Equity Inputs Earnings before interest and taxes (EBIT) = 100 E xpected growth for next 5 years = 20% Expected growth after year 5 = 5% Tax rate = 40% Debt ratio for the firm = 20% Cost of equity = 15% Pre-tax cost of debt = 9% Return on capital in high growth= 15% Return on capital in stable growth = 10% 0 1 2 3 4 5 Terminal Year Expected Growth rate 10% 10% 10% 10% 10% 5% Reinvestment rate 66.67% 66.67% 66.67% 66.67% 66.67% 50.00% EBIT(Earnings before interest & tax) ...
Read more

A Key Challenge for Apple's Quest for Carbon Neutrality

-
Image
  The Goal of the project: To visualize Apple progress towards becoming carbon neutral in 2030. In 2020, after announcing their corporate operations were officially carbon neutral, Apple pledged to make their products carbon neutral by 2030. To achieve this goal, they set their emissions for 2015 (38.4 million metric tons CO2e) as the baseline and will aim to reduce them by 75% by 2030. The remaining 25% of gross emissions (9.6 million metric tons CO2e) will be removed using carbon offsets, bringing the net emissions to 0. To find out the how much carbon emission is already reduced by Apple in 2022 and how it going to reduce the remaining by 2030. Key Insights: Based on the data and analysis, i have found these below points: Apple has reduced its carbon emission in corporates operations by 2020 The top three highest emission segments are manufacturing, transportations and product use How Apple will reduce the remaining emission by 2030? Apple already implementation many transformat...
Read more

Why Patients Rating (HCAHPS) Declined During COVID-19?

-
Image
  Project Description: The HCAHPS survey is the first national, standardized, publicly reported survey of patients' perspectives of hospital care. HCAHPS (pronounced "H-caps"), also known as the CAHPS Hospital Survey, is a survey instrument and data collection methodology for measuring patients' perceptions of their hospital experience. HCAHPS was designed to help government agencies begin to collect and aggregate data on patient’s perspectives of care at the various healthcare facilities in the United States. HCAHPS scores are used to enable objective comparisons of hospitals across a variety of metrics, inform healthcare consumers about the relative standard of care at each facility and create incentives for hospitals and healthcare organizations to compete on patient engagement and satisfaction. This is the September challenge organized by Maven Analytics. You can find the dataset here . The challenge data consists of 7 files: Measurers National result Questions ...
Read more

Great thought by Mrunal Nandankar

-
Success is not measured by how much a man has, But how much he has done, How far he has gone. Success is the basic human knowledge, Of how well a man has done. It is not taken lightly, Or as it shouldn't be. This is a serious task. One given to man by fate. Only you can determine your success. Only people can comment it. Push your self to the limit, Gas far as you can, Strive for it, For it is important, Your success. One of the most important traits of human kind, Taken for granted by the rich, And serious by the poor. We all have it in us, What it takes to be a success. We just have to reach in deep enough, And we will soon find the success in us, That has been lying there all a long. Success is key to all of life's compances, Enjoy it while it lasts. By Mrunal Nandankar...............
Read more

Global GDP Flow slowed down in 2022

-
Image
  I have only worked on Power BI but to use this voronoi treemap, I have chosen Tableau. I have mentioned the link below, if anybody would like to work on this. Please share your feedback, if you like it. :-) Veronoi treemap link: https://lnkd.in/gVqFuZ8M Thanks for reading.
Read more

Vince Lombardi

-
It's easy to have faith in yourself when you're a winner, when you're number one. What you've got to have is faith in yourself when you're not a winner. - Vince Lombardi
Read more

The Global Space Exploration Roadmap

-
Image
All space missions from 1957 to August 2022, including details on the location, date, and result of the launch, the company responsible, and the name, price, and status of the rocket used for the mission. Recommended Analysis How have rocket launches trended across time? Has mission success rate increased? Which countries have had the most successful space missions? Has it always been that way? Which rocket has been used for the most space missions? Is it still active? Are there any patterns you can notice with the launch locations?  Tool: Power BI
Read more

Pizza Place Sales Analysis

-
Image
  A year's worth of sales from a fictitious pizza place, including the date and time of each order and the pizzas served, with additional details on the type, size, quantity, price, and ingredients. Recommended Analysis How many customers do we have each day? Are there any peak hours? How many pizzas are typically in an order? Do we have any bestsellers? How much money did we make this year? Can we indentify any seasonality in the sales? Are there any pizzas we should take of the menu, or any promotions we could leverage? Tool: Power BI
Read more