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

Maven Healthcare Challenge: Aug 2023

-
Image
In recent Maven Analytics challenge, we need to do analysis of hospital survey data. The data is about National & state-level scores from 2013 to 2022 for the Hospital Consumer Assessment of Healthcare Providers and Systems (HCAHPS) survey, a national, standardized survey of hospital patients about their experiences during a recent inpatient hospital stay. First know about, what is HCAHPS? 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 is a patient satisfaction survey that was developed by the Agency for Healthcare Research and Quality (AHRQ) in collaboration with Centers for Medicare and Medicaid Services (CMS) beginning in 2002. It was designed to help government agencies begin to collect ...
Read more

Tour de France : History of Largest Sporting Event

-
Image
  Goal of the Project The goal of the project is to create an infographic-style visual to educate new viewers, highlight the magnitude of the event, and build anticipation for this year's Tour de France. This challenge requirement is different from others as here we are not getting any business insights or solution to do better. Here we have the information and we tried to spread information in easy and simple manner that more viewers can show interest in the coming years. As there are still many people has lack of knowledge about this event and access to watch this event (or lack of resources). What were business need The need is to create an infographic visual to educate new viewers about the world’s largest event Tour de France and 3.5 billion viewers were interested to watch from all around the world. My focus is to attract more viewers and provide base information or history that they don’t know. We are 8 billion population and we have to showcase this largest annual sporting ...
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

Fitness Tracker Dataset Challenge

-
Image
  About the Project: This is a fitness tracker product dataset consisting of different products from various brands with their specifications, ratings and reviews for the Indian market. The data has been collected from e-commerce websites namely Flipkart and Amazon using web scraping technique. This dataset contains 451 samples with 16 attributes. There are some missing values in this dataset. Tool Used: Power BI
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

INDIA HAS BEEN WRONGLY PLACED AT 126TH RANK IN THE WORD HAPPINESS REPORT 2023

-
Image
  T h e World Happiness Report is an annual report published by the United Nations Sustainable Development Solutions Network. It ranks countries based on how happy their citizens perceive themselves to be and provides analysis of the factors that contribute to happiness, such as income, social support, and life expectancy. The 2023 World Happiness Report has been released, and it shows that Finland remains the happiest country in the world for the sixth year in a row. Denmark, Iceland, Israel, and the Netherlands are the next happiest countries, with other European countries such as Sweden, Norway, Switzerland, and Luxembourg also making the top 10. Now question raise here that how India’s position in the World Happiness Report has ranked at 136th place, despite having the world’s fastest-growing economy, India’s ranking in the report has consistently been low, leading some to question how it can be ranked lower than countries in turmoil.Despite the ongoing conflict between Russia ...
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

Highlights of Railway Budget: 2013-2014

-
Image
                                              Our Honorable Railway Minister Pawan Kumar Bansal has presented his maiden railway budget in the Parliament.                Key Highlights of Railway Budget: ·          No passenger fare hike ·          5% average increase in freight rates ·          More usage of agro-based and recycled paper and ban use of plastic in catering. ·          Railways have been annually disposing of scrap which not only generates revenue but also helps in de-cl...
Read more