__STYLES__
Log In
Sign Up
Log In
Sign Up
Johnkings Otieno Banner Image
Johnkings Otieno Avatar
Johnkings Otieno Avatar

Johnkings Otieno

Business Intelligence Analyst
Nairobi City Water & Sewerage Company
About Johnkings
Work experience
Education
Had fun with the LEGO Data Challenge and developed some interesting insights.
Had fun with the LEGO Data Challenge and developed some interesting insights.Well that was fun! I joined this challenge out of curiosity as being a fan of legos, I was fully interested on what insights I could derive from this project and I was not disappointed. Here are my findings:
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Had fun with the LEGO Data Challenge and developed some interesting insights.
Had fun with the LEGO Data Challenge and developed some interesting insights.Well that was fun! I joined this challenge out of curiosity as being a fan of legos, I was fully interested on what insights I could derive from this project and I was not disappointed. Here are my findings:
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Power BI Report Summary - Evolution of Car Efficiency and Fuel Costs
Power BI Report Summary - Evolution of Car Efficiency and Fuel CostsCame across Data on Automotive Changes over the Years and Decided couldn't help but play around with the data and see the insights I could derive.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Power BI Report Summary - Evolution of Car Efficiency and Fuel Costs
Power BI Report Summary - Evolution of Car Efficiency and Fuel CostsCame across Data on Automotive Changes over the Years and Decided couldn't help but play around with the data and see the insights I could derive.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Power BI Insights on Penda Health Key Perfomance Indicators.
Power BI Insights on Penda Health Key Perfomance Indicators.I decided to work on a previous report on visits,diagnosis and revenue received from different branches of Penda hospital. I managed to get a few insights after building relationships with the different tables and adding a few measures with DAX.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Power BI Insights on Penda Health Key Perfomance Indicators.
Power BI Insights on Penda Health Key Perfomance Indicators.I decided to work on a previous report on visits,diagnosis and revenue received from different branches of Penda hospital. I managed to get a few insights after building relationships with the different tables and adding a few measures with DAX.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Motor Vehicle Thefts in New Zealand
Motor Vehicle Thefts in New Zealand These insights provide a comprehensive overview of the patterns observed in motor vehicle theft in New Zealand, linking population dynamics, specific vehicle preferences, and the timing of theft spikes, particularly in April 2022.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Motor Vehicle Thefts in New Zealand
Motor Vehicle Thefts in New Zealand These insights provide a comprehensive overview of the patterns observed in motor vehicle theft in New Zealand, linking population dynamics, specific vehicle preferences, and the timing of theft spikes, particularly in April 2022.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Power BI - I made a simple and easy to understand Adventure Works KPI Presentation.
Power BI - I made a simple and easy to understand Adventure Works KPI Presentation.Completed a project showing various KPIs of Adventure works and tried to display as much information as possible while still making it easy to understand.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Power BI - I made a simple and easy to understand Adventure Works KPI Presentation.
Power BI - I made a simple and easy to understand Adventure Works KPI Presentation.Completed a project showing various KPIs of Adventure works and tried to display as much information as possible while still making it easy to understand.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Tableau Visualization of Audiobook Sales and Reviews over the Months
Tableau Visualization of Audiobook Sales and Reviews over the MonthsDid analysis on Audio book sales and reviews over a period of months and visualized it with Tableau depicting analysis of the relationship between Reviews, Ratings and Sales over the months.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Tableau Visualization of Audiobook Sales and Reviews over the Months
Tableau Visualization of Audiobook Sales and Reviews over the MonthsDid analysis on Audio book sales and reviews over a period of months and visualized it with Tableau depicting analysis of the relationship between Reviews, Ratings and Sales over the months.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Did a Power Pivot Table of Hospital showing Revenue collected from different branches of the Hospital.
Did a Power Pivot Table of Hospital showing Revenue collected from different branches of the Hospital.Had an assignment which provided the data on different branches of Penda Health hospital and decided to do a power pivot on how the different branches performed based on their payments with regards to cash and Insurance companies.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Did a Power Pivot Table of Hospital showing Revenue collected from different branches of the Hospital.
Did a Power Pivot Table of Hospital showing Revenue collected from different branches of the Hospital.Had an assignment which provided the data on different branches of Penda Health hospital and decided to do a power pivot on how the different branches performed based on their payments with regards to cash and Insurance companies.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Power BI - I also added a Map Visual on the Adventure Works presentation displaying how differetnt orders were made around the world.
Power BI - I also added a Map Visual on the Adventure Works presentation displaying how differetnt orders were made around the world.Made a Map showing how different continents were ranked with regards to Total orders. Making it possible for the user to see displayed total orders while hovering the mouse around the different areas. Also added buttons to help select different countries.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Power BI - I also added a Map Visual on the Adventure Works presentation displaying how differetnt orders were made around the world.
Power BI - I also added a Map Visual on the Adventure Works presentation displaying how differetnt orders were made around the world.Made a Map showing how different continents were ranked with regards to Total orders. Making it possible for the user to see displayed total orders while hovering the mouse around the different areas. Also added buttons to help select different countries.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Power BI - Product Details presentation for Adventure Works Presentation.
Power BI - Product Details presentation for Adventure Works Presentation.Added a presentation to help the user be able to select different products and see their performances and KPIs and also added a slicer to compare Adjusted profit with Adjusted price.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Power BI - Product Details presentation for Adventure Works Presentation.
Power BI - Product Details presentation for Adventure Works Presentation.Added a presentation to help the user be able to select different products and see their performances and KPIs and also added a slicer to compare Adjusted profit with Adjusted price.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Power BI - Customer Detail presentation for Adventure Works Project.
Power BI - Customer Detail presentation for Adventure Works Project.Added a presentation showing more customer insights to help user be able to see specific customers and the Revenue per customer presented by a line graph.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno
Power BI - Customer Detail presentation for Adventure Works Project.
Power BI - Customer Detail presentation for Adventure Works Project.Added a presentation showing more customer insights to help user be able to see specific customers and the Revenue per customer presented by a line graph.
0 Likes
0 Comments
Johnkings Otieno Avatar
Johnkings Otieno Avatar
Johnkings Otieno