Chukwuebuka Oguadimma’s Post

Name: Created a data analysis dashboard for Quantum Analytics NG | Chukwuebuka Oguadimma posted on the topic | LinkedIn
Uploaded: 2024-07-21T16:18:25.112Z
Channel: Chukwuebuka Oguadimma

Chukwuebuka Oguadimma

Fleet Operations Manager, NB Operations Ama Enugu.

3mo

Good day everyone, I recently joined Quantum Analytics NG as a data analyst intern, and I am excited to make my first publication here of an analysis dashboard that I prepared myself. It’s my 2nd dashboard assignment in Quantum Analytics Ng. Dashboard Title: Unicorn Companies Analysis Dashboard. Data Source: Quantum Analytics NG. Tool Used: Power BI. Some of the generated Insights: · Total of the Unicorn Companies. · Total Number of Unicorn Companies. · Number of industries the Unicorn Companies fall into. · Countries with most Unicorn companies. · Top 10 most funded Unicorn Companies. · Top 10 most valued Industries that these companies belong to, Etc. A very special thanks to: Quantum Analytics NG, Jonathan Osagie, Christian Okwara and the entire Quantum Analytics team. #dataanalysis #quantumanalyticsng

Transcript

Everyone, my name is Chukwuebuka Kizito, Oklahoma. I'm Editor Analyst Intern at Quantum Analytics Nigeria and I'm here today to present one of my project dashboards. The title of the dashboard is Unicorn Companies Analysis Dashboard. The datasets for this dashboard was presented by Quantum Analytics. Power BI was used to. And a nice and prepared this dashboard. I want to show us the datasets that was used to prepare this dashboard. The data set as you can see on the screen comprises of the company name, that is the companies that was analyzed, the valuation, the date those companies joined the industry, the city, the country and the continents. Where these industries are domiciled, these companies are domiciled. The year these companies were founded, the funding. Then the investors who fund these companies, for purposes of clarity, I would like to explain what Unicorn companies mean. Unicorn companies are those companies, all those startups rather that. Reach $1 billion valuation and they are not listed in the stock market. So on the screen you can see that for this data set. There is a total of $3.7 trillion. Valuation for these Unicorn companies and we have a total of 1074 Unicorn companies covered by these datasets. These companies are from 15 different industries and there are also domiciled in 257 different cities of the world and 46 countries of the world. OK. Let me go straight to explaining the slides on this dashboard. From the first slide, you can see that this slide tends to look at the evaluation of these companies by year. From here you can see that in 2007. In 2007, there's a total valuation of $1 billion in 22,000 and seven for this total number of companies. And then there's also a total valuation of. $52 billion in 2011 on Overall, there is a gradual increase of value in evaluation of all these companies across the number of years. This data set actually looked at these companies from 1919 to 2022, but there is a spike in the valuation in 20/21/2021 is the post. COVID, yeah, that is post 2022 COVID. Post 2020 COVID, there's a total of 11.189 trillion naira information of these two trillion dollars information of these two companies, that is the highest so far in 2021. Then there's also a drop from from 1.81.189 trillion to $200 billion. In 2022 and the next slide, you can see the total number of companies that joined by year. In 2007, you can see that there's only one company that joined this set of Unicorn companies then in. In in 2011, two companies joined. You can see the gap between 22,000 and seven and 2011. Then let's move quickly to 2018. In 2018, there is a total of 103 countries, the three companies that joined the Unicorn companies. But then there is spike again in 2021, which explains the valuation. In 2021 as in 2520, companies that joined in 2021 and there's also a drop in the total companies that joined in 2022, which also explained the evaluation in the year 2022. So I want to also quickly take us to this slide. You can see on this slide, you can see the the slide is actually the the top ten countries with most Unicorn companies. United States stands out from the crowd there with 562 companies. Try to finance 62 Unicorn companies, followed by China with 173 and India with 65. If you drill down, United Kingdom was looked at as as as not as a not as a country, but as a segment of that continent. You can see 43 different companies of 43 different Unicorn companies in the UK. Then let's look at. The two toward the top 10 most funded industries don't forget that we have 15 different industries to which these companies belong to the the most the most funded industry here is the fintech industry fintech is the financial technology industries. That's where you find the lights of Opie, the likes of Uber, the likes of Pompeii and the rest. You can see that the the the. Funding student 0.11 trillion dollars for the fintech industry, followed by the ecommerce that we will find the, the, the, the, the, the, the likes of Jumia and that's an example of an ecommerce company. So and then let's go to the next slide where you have the top 10 most valued industry's top 10 most valued industry. Remember the first language then the previous one we looked at was top 10 most funded. Now this is top 10 most valued. Fintech also stands at the most valued industry at 0.88 trillion dollars. That's awesome for the fintech industry. What this shows, what is clearly shows is that. For, for would be investors who would want to invest in any of these companies and industries and fintech industry and one of the fintech companies would be a good choice because obviously there would be a great return, a great return on investments when there's any, when there's an investment in the fintech, one of the fintech companies, then let's look at the top 10 most valued companies. Now we are not looking at the industry and we're looking at we are we are really down to the. The companies and Bite Dance, Bite Dance is the most most valued company there with 0.18 trillion. That is very awesome. If the total by turns belongs to the fintech industry with the total, if the total of the fintech industry is 0.88 trillion and by dance alone is standing at 0.18 trillion, that's very awesome. This dashboard also included. It slides up, it slides out. With this, Liza, you can be able to look at the individual continents, the country and the industry. You can select any of the continents or any of the any of the countries or any of the industry you wish to look at. We can go to let's take one of them. Let's look at North America, United States and the industry is health. So we'll click there. You can look at this, look at see where it is now. I've clicked on North America. The country is United States. The industry is the health industry. Look at the valuation by year for this particular selection. We can see. There is a. There is a total of 515151. She's one different companies, health companies in United States that are part of the Unicorn companies and then the the, the the funding, the funding stood at 0.02 trillion for the health industry and of the Unicorn companies in the US then the the value is at 0.15 trillion dollars. This is only for the health in the United States. Of America, we can see that. The valuation by year has kept increasing in 2014. In 2014, it is at $4 billion. Now the highest is is in the year 2021 for only the health, the health, the health industry, the companies, the Unicorn companies that belong to the health industry in United States only in the in 2021. There's a total of $63 billion only for that particular industry in the United States of America. So I will be leaving this, this analysis in life analysis on LinkedIn and so that anybody can access it. All thanks to Quantum Analytics for making this possible. Thank you very much. And I, I will see you again in my next presentation. Have a nice day.

To view or add a comment, sign in

More Relevant Posts

LILLIAN ONWUEGBU

JUNIOR DATA ANALYST
8mo
Report this post
Hello everyone, my name is Lillian, an intern at Quantum Analytics. I have been tasked to generate insights from the Space mission data. PROJECT FIFTEEN: SPACE MISSION ANALYSIS The objective of this project was to create a report with the following insights: 1. Total number of missions 2. Total number of successful mission 3. Total failure 4. Total prelaunch failure 5. Total partial failure 6. Total number of companies 7. Mission trend over the months 8. Most successful mission by company 9. Missions carried out by each rocket 10. Missions by mission status 11. Missions carried out by each country This was my very first analysis using Power BI, and I am really thankful for the growth in this journey so far. My growth would not have been possible without my amazing facilitators: Quantum Analytics NG Jonathan Osagie Christian Okwara Abdullah Bankole, MCDAA GMNSE Godswill Ojumeaka

1 Comment
Like Comment
To view or add a comment, sign in
Ifeoluwa Olonisakin

Risk Analyst | Accounts Payable/Receivable Specialist | Data Analyst & Consultant | MSc International Business & Management | Risk Management
1mo
Report this post
Hello everyone, I present to you my 1st project as a data analyst intern with Quantum Analytics NG. It is imperative that I appreciate Quantum Analytics NG for giving me the support and learning platform needed to achieve this milestone. I will be doing a descriptive analysis of the dataset below. ✅ Project Title: Airplane Crash Data Analysis. ✅ Data Source: Quantum Analytics NG ✅ Visualization Tool: Power BI. ✅ Key Performance Indicators: ● Total fatalities. ● Total aboard. ● Total deaths. ● Total aircrafts. Based on the dataset, the following key insights were generated. ● Top 7 fatalities by aircraft operators. ● Top 7 fatalities by aircraft. ● Fatalities by location. ● Aircraft routes. ● Number of fatalities by months. ● Timeframe in which fatalities occurred. ● Years with the highest fatalities. ✅ Acknowledgement Quantum Analytics NG, Jonathan Osagie, Blessing Olayemi

2 Comments
Like Comment
To view or add a comment, sign in
TITILOPE FASHOLA, (MCPAA)

Data Analyst||Accountant||Power BI||MySQL||Tableau||Microsoft SQL Server|| Python||Microsoft Excel
8mo
Report this post
Good day everyone, I am delighted to share my 16th project with you titled "Historical Stock Price of 10 Popular Companies". Been a data analyst intern at Quantum Analytics NG has contributed greatly to the achievement of this project. Visualization tool:- Power BI Data source:- Quantum Analytics NG KPIs:- a.) Total volume b.) Total stock price (low) c.) Total stock price (high) d.) Total stock price (Adj close) e.) Total companies Insights:- 1.) Price growth by company 2.) Total volume by company 3.) Stock price prediction Special thanks to my facilitators, Jonathan Osagie, Christain Okwara, Abdullah Bankole (MCDAA, GMNSE), Segun Umoru, Prince Chukwemeka, Godswill Ojumeaka and Quantum Analytics NG team. #dataanalyst #datascience #datavisualization #project #powerbi #problemsolvingskills
Like Comment
To view or add a comment, sign in
Ahmed Olaleye

Internal Auditor | Data Analyst | Fraud Analyst | Financial Analyst
5d
Report this post
Hi Everyone, I am excited to share with you my second project as a Data Analyst Intern with Quantum Analytics NG. Project Title: Sales Activities for WixSin Company Dataset Source: Quantum Analytics NG Tool: Microsoft Excel Outcome: Microsoft Excel Interactive Dashboard KPIs: - Total Revenue - Total Units Dashboard Insights/Business Case Questions: - Monthly Revenue Growth - Revenue Trend by Weekdays - Category Proportion to Revenue - State Contribution to Revenue - Revenue by Segment - Top 5 products Slicers: - Category - Weekday Acknowledgement Quantum Analytics NG, Jonathan Osagie and Godswill Ojumeaka. Thanks for watching! #DataAnalysis #MicrosoftExcel #Data #DataVisualization

2 Comments
Like Comment
To view or add a comment, sign in
Sophia Anibueli
9mo
Report this post
Project 4 Project Title: HISTORICAL STOCK OF 10 COMPANIES Hi there, my name is Sophia. I am a Data Analyst Intern with Quantum Analytics (Quantum Analytics NG) and will provide insight my project dashboard. Visualization tool: Power BI Desktop. In this project, I used Power BI query to clean and transform the dataset provided by Quantum Analytics NG. Afterwards, I visualized the transformed data in the Power BI Dashboard. Insight Generated includes: Stock Analysis of Facebook, Tesla, Zoom, Netflix, Apple, Microsoft, Uber, Walmart, Amazon and Google 1. Total opening stocks 2. Total Closing stocks 3. Total stock volumes of companies Please listen to get more insight from the Visual My heartfelt gratitude goes to Quantum Analytics NG, Jonathan Osagie, Godswill Ojumeaka, Abdullah Bankole, Christian Okwara hashtag #powerbidashboard hashtag #datacleaning hashtag #dataanalysis hashtag #visualization
Like Comment
To view or add a comment, sign in
Ereaku Chimmezirim

Operations Business Development Manager | Data Analyst | Project Manager |
10mo Edited
Report this post
Good day everyone, Here is one of my projects as an intern with Quantum Analytics NG PROJECT TOPIC: DATA SOURCE: QUANTUM ANALYTICS NG DATA VISUALIZATION TOOL: Powerbi KPIs DERIVED; Lab confirmed death Affected states Top 5 lab confirmed cases by states Deaths by top 5 affected states States affected Lab confirmed cases Number of deaths Cases discharged For more insights from the dashboard, kindly watch the clip attached. Your feedback and comments are highly appreciated. Special thanks to my facilitators: Jonathan Osagie, Godswill Ojumeaka, Christian Okwara,Segun Umoru #analytics #powerbi
Like Comment
To view or add a comment, sign in
Joseph Aghiagbe

Data Analyst @ Quantum Analytics NG | Data Interpretation, Visualization
9mo
Report this post
Greetings, esteemed audience, I am Joseph Aghiagbe, currently sharpening my skills as an intern at Quantum Analytics NG. I am eager to share insights from my 11th project presentation, where I utilized PowerBI for data visualization. Today’s discussion is centered around the “Historical Stock Price Analysis of 10 Popular Companies”. Please note that all transactions discussed in this presentation are denominated in dollars. We will be delving into Key Performance Indicators (KPIs) such as the all-time high price, all-time low price, average of open, close, high, and low prices, and the total volume. Here’s a preview of the insights this presentation will offer: yearly and quarterly total volume, yearly averages of open, close, high, and low prices, yearly maximum of open and close prices, and quarterly sum of price change (%). I am profoundly grateful to Quantum Analytics NG for this remarkable opportunity and for providing the Dataset. I would also like to express my deep appreciation to Jonathan Osagie, Prince Chukwuemeka (MCDAA, MCT), Segun Umoru, Christian Okwara, and Abdullah Bankole (MCDAA, GMNSE) for their invaluable guidance and support throughout this project. Stay tuned for more updates! #QuantumanalyticsNG
Like Comment
To view or add a comment, sign in
Hamza Mohammed

Data Analyst
5mo
Report this post
PROJECT 1 Good day, I will be presenting my first project analysis as an intern with quantum analytics *Title: WHO COVID-19 data analysis report 2020-2024 *Visualization tool: Microsoft Power BI *KPI: -total case -total death -total survival -total country *Insight -annual reported case trend -case reported by month -death and survival proportion -top 10 country by reported case -top 10 country by death -top 10 country by survival *Recommendations 1. World leaders should be more proactive and keep politics aside so as to avoid the bottle neck of sharing information on time which was a contributing factor to the initial spike of spread of Covid. 2. Countries with a high rate of immigration should improve on their health condition scrutiny of their visitors so as to spot health anomalies early enough before it spreads. 3.A world wide campaign should be rolled out to encourage people to make good health choices and life styles that could improve their immunity to disease invasion as it was observed that countries with less sedentary life style with higher preference for natural and healthy food choice had a better survival rate than those that did otherwise. thank you. Special gratitude to Quantum Analytics NG Jonathan Osagie

3 Comments
Like Comment
To view or add a comment, sign in
Oludolapo Oladokun

Teaching at Tender toes Kiddies Academy
9mo
Report this post
Project Title: WHO Covid-19 Global Analysis Hi there, my name is Oladokun Oludolapo. I am a Data Analyst Intern with Quantum Analytics (Quantum Analytics NG) and will provide insight into my project dashboard. Visualization tool: Power BI Desktop. In this project, I used Power BI query to clean and transform the dataset provided by Quantum Analytics NG. Afterwards, I proceeded to visualize the transformed data in the Power BI Dashboard. Insight Generated includes: 1. Number of cases globally 2. Number of vaccinated persons globally 3. Number of global death. etc. For a more comprehensive understanding of this project, listen to the video below. thank you. Quantum Analytics NG Jonathan Osagie
Like Comment
To view or add a comment, sign in
Salahudeen Nabil

Data Analyst | Virtual Assistant | Geologist
7mo
Report this post
Here's my 10th project as an intern at Quantum Analytics Project name: Shark Attacks Visualization tool: Power BI Data source: Quantum Analytics NG Shark attacks reported over the past 100 years, including location, activity, victim info (name, gender, age), shark species. Recommended Analysis 1. Make a graph of number of shark attacks annually over time since 1900. What trends do you see? 2. Which countries report the most shark attacks? Within those countries, which areas and locations seem to be the most dangerous? 3. The next questions will require you to practice your data cleaning skills. The data is pretty raw, and will need some work before you analyze it... 4. What body parts are most often injured? (hint: you'll need to perform text analysis on the Injury column) 5. Are shark attacks more common during certain parts of the day (again, the Time data isn't quite ready to go. You may need to transform it before analyzing) 6. Which species of shark are attacking most often? (you guessed it... this data is messy too!) INSIGHTS GENERATED -Total number of Countries -Total Location -Total Areas -Total Shark Attack -Body Part Injured -Total Shark attack by year -Total Shark attack by country -Total Shark attack by area -Total Shark attack by specie of shark -Total Shark attack by injury part -Total Shark attack by day time description Thanks to Quantum Analytics NG, Jonathan Osagie, Christian Okwara
Like Comment
To view or add a comment, sign in

180 followers

26 Posts

View Profile Follow

Chukwuebuka Oguadimma’s Post

Transcript

More Relevant Posts

Explore topics