Zefas Bi and Analytics
Zefas Bi and Analytics
  • 22
  • 25 150
Ultimate Power BI Guide: Analyzing Key Financial KPIs for Fitness Company - Part Two
In this video, I break down the essential financial KPIs that drive the performance of a fitness company, offering a comprehensive analysis of key metrics and trends. The report covers:
1. Revenue KPIs (Total Revenue, Revenue by Business Line, Revenue by Income Group, Revenue Growth Rate, Revenue by Month)
2. Profitability KPIs (Gross Profit, Gross Profit Margin, EBIT, EBIT Margin, Net Profit, Net Profit Margin)
3. Cost-related KPIs / Operational Efficiency KPIs (Total COGS, COGS as a Percentage of Revenue, COGS by Business Line, Total OPEX, OPEX as a Percentage of Revenue, OPEX by Expense Subgroup, Interest and Tax Expenses)
4. Growth and Trend KPIs (MoM Revenue, MoM Expense)
This report covers the key financial indicators (KPIs) and their performance indicators (PIs) that drive the fitness company’s performance, providing valuable insights into its revenue, expenses, and profitability.
Link to One Drive to download dataset, image and pdf KPI document. Once open click on download all - drive.google.com/drive/folder...
Don't forget to like, subscribe, and hit the notification bell for more in-depth financial analysis and insights!
Buy me a Coffee: www.buymeacoffee.com/ZefasBI
Part one : th-cam.com/video/6V0wmkyNjGo/w-d-xo.htmlsi=QQCI4i6LhFELits6
Text 1 Income Statement:
N & F Support saw strong sales throughout the year, with Q1 leading at 405,450, while consulting revenue peaked in Q3.
Sports Equipment had its highest sales in Q4 at 1,950,000, with a decline in consulting revenue from Q1 to Q4. Similarly, Sportswear showed strong sales in Q1 at 1,351,500, though it gradually declined across quarters. Both Sports Equipment and Sportswear saw moderate other income, with noticeable peaks in Q2 and Q4, respectively.
Text 2 Expense Statement:
The expense statement shows that N & F Support maintained steady COGS, peaking at 280,200 in Q2, with consistent interest and tax expenses across all quarters.
Their operating expenses (Opex) were highest in Q1 at 360,900 but slightly decreased by Q4. Sports Equipment had the highest COGS in Q2 at 954,200, with fluctuating interest and tax expenses, which spiked to 119,500 in Q4. Their Opex steadily increased, reaching 689,200 in Q4. Sportswear also saw substantial COGS, with a peak in Q2 at 525,000, and their Opex remained consistent, ending at 434,000 in Q4.
มุมมอง: 399

วีดีโอ

Ultimate Power BI Guide: Analyzing Key Financial KPIs for Fitness Company - Part One
มุมมอง 1.1K14 วันที่ผ่านมา
In this video, I break down the essential financial KPIs that drive the performance of a fitness company, offering a comprehensive analysis of key metrics and trends. The report covers: 1. Revenue KPIs (Total Revenue, Revenue by Business Line, Revenue by Income Group, Revenue Growth Rate, Revenue by Month) 2. Profitability KPIs (Gross Profit, Gross Profit Margin, EBIT, EBIT Margin, Net Profit, ...
How to Connect Power BI to a Folder Data Source
มุมมอง 1002 หลายเดือนก่อน
Learn how to seamlessly connect Power BI to a folder data source in this step-by-step tutorial. Enhance your data analysis and reporting by integrating multiple files from a single folder. Perfect for data analysts and Power BI enthusiasts looking to streamline their workflow and boost productivity. Watch now to master this essential skill.
Build a Pharmacy Daily Sales Dashboard in Power BI with SQL Server & ZoomCharts - Part 2
มุมมอง 6452 หลายเดือนก่อน
Learn how to create a beginner-friendly Power BI dashboard for pharmacy daily sales using SQL Server as a data source. This step-by-step tutorial covers: Connecting Power BI to SQL Server Designing an intuitive dashboard layout Implementing ZoomCharts visuals for enhanced drill-through capabilities Publishing your report to Power BI Service Pinning reports to a dashboard Setting up scheduled da...
Build a Pharmacy Daily Sales Dashboard in Power BI with SQL Server & ZoomCharts - Part One
มุมมอง 1.3K2 หลายเดือนก่อน
Learn how to create a beginner-friendly Power BI dashboard for pharmacy daily sales using SQL Server as a data source. This step-by-step tutorial covers: Connecting Power BI to SQL Server Designing an intuitive dashboard layout Implementing ZoomCharts visuals for enhanced drill-through capabilities Publishing your report to Power BI Service Pinning reports to a dashboard Setting up scheduled da...
Comprehensive Marketing Campaign Report Analysis with Power BI
มุมมอง 6733 หลายเดือนก่อน
Welcome to our in-depth analysis of the latest marketing campaign! This video walks you through a detailed report featuring key performance indicators (KPIs) to measure success across different channels and locations. What's Inside: Performance KPIs: Conversion Rate, Engagement Rate, ROAS, ROI, RPC, RP Conv Traffic KPIs: Impressions, Clicks, CPM, CTR, CPC We explore how these metrics help us tr...
Power BI Report: Analyzing Technical Support Performance - Part 2
มุมมอง 1.3K3 หลายเดือนก่อน
In today’s world, businesses of all sizes rely heavily on technology for daily operations. Technical support plays a crucial role in maintaining these systems efficiently. This month's challenge provides a real-life scenario for you to explore: analyzing the functioning of technical support. It’s a great chance to learn from fellow participants, improve your analytical abilities, and broaden yo...
Power BI Report: Analyzing Technical Support Performance - Part One
มุมมอง 5K3 หลายเดือนก่อน
In today’s world, businesses of all sizes rely heavily on technology for daily operations. Technical support plays a crucial role in maintaining these systems efficiently. This month's challenge provides a real-life scenario for you to explore: analyzing the functioning of technical support. It’s a great chance to learn from fellow participants, improve your analytical abilities, and broaden yo...
Unlocking Customer Insights: Analyzing Survey Data with Power BI
มุมมอง 4564 หลายเดือนก่อน
"📊 Unlocking Customer Insights: Analyzing Survey Data with Power BI! 🚀 In this video, dive into the world of data-driven decision-making as we explore the results of a recent customer survey using Power BI. From Net Promoter Scores (NPS) to satisfaction ratings and beyond, we'll uncover valuable insights to enhance customer experience and drive business success. Plus, learn how to calculate a h...
5 tips to improve your data analytics and visualization skills
มุมมอง 2484 หลายเดือนก่อน
Here are 5 tips to improve your data analytics and visualization skills 1. Get a Clear Understanding of the Data Domain: Before diving into analysis, ensure you understand the context and domain of the data. Know where it comes from, how it's collected, and what it represents. This understanding helps in making informed decisions during analysis. 2. Put Context to What Each Column Entails Withi...
Power BI Dashboard with just New Card Visual, Reference Labels and Matrix Table Visual /Table Visual
มุมมอง 2384 หลายเดือนก่อน
Welcome to Zefas BI and Analytics - Where we learn by building BI Projects! Tableau Vs Power BI Series: In continuation of our Tableau vs Power BI Series 2, I recreated Ervin Lloyd Vinzon's Tableau Dashboard on XYZ Human Resource Engagement Scorecard. The entire dashboard was crafted in Power BI, utilizing new card visuals with reference labels and a matrix table. Process: 1. Minor formatting a...
Build A Matrix Native Visual With Power BI
มุมมอง 7494 หลายเดือนก่อน
Experience the seamless integration of Matrix Native visuals into Power BI, revolutionizing data visualization with unparalleled clarity and depth. This videos explores the different formatting options with specific columns and cell elements . Buy me a Coffee: www.buymeacoffee.com/ZefasBI
Matrix Native Visual With Power BI
มุมมอง 1345 หลายเดือนก่อน
Experience the seamless integration of Matrix Native visuals into Power BI, revolutionizing data visualization with unparalleled clarity and depth.
IMDb Movies Analysis - Power BI Project
มุมมอง 5355 หลายเดือนก่อน
Assessing the Value of the Movie Industry Key KPIs - Budget & Revenue Approach: The movie dataset spans over a significant period, from the 1980s. To gain insights, I categorized the data by decade. Key performance indicators (KPIs) were identified and compared across these decades to understand trends and changes over time.
Power BI Vs Tableau - An Interactive Dashboard Analysis of Udemy Courses. - Part Two
มุมมอง 4225 หลายเดือนก่อน
This interactive dashboard offers an in-depth analysis of Udemy courses spanning from 2011 to 2017. It delves into high-demand subjects, examines reviews as a crucial factor affecting course popularity and engagement, and explores strategies for optimal pricing. Originally developed using Tableau by a Tableau expert, this video guides through replicating the same dashboard using Power BI.
Power BI Vs Tableau - An Interactive Dashboard Analysis of Udemy Courses. - Part One
มุมมอง 5955 หลายเดือนก่อน
Power BI Vs Tableau - An Interactive Dashboard Analysis of Udemy Courses. - Part One
An Interactive Udemy Courses Analysis Dashboard
มุมมอง 5855 หลายเดือนก่อน
An Interactive Udemy Courses Analysis Dashboard
Build A Data Challenge Winning Products Ratings & Reviews Analysis Dashboard with PowerBI -Part One
มุมมอง 2.3K5 หลายเดือนก่อน
Build A Data Challenge Winning Products Ratings & Reviews Analysis Dashboard with PowerBI -Part One
Build A Data Challenge Winning Products Ratings & Reviews Analysis Dashboard with PowerBI -Part Two
มุมมอง 3745 หลายเดือนก่อน
Build A Data Challenge Winning Products Ratings & Reviews Analysis Dashboard with PowerBI -Part Two
Build A Data Challenge Winning Retail Sales Optimization Dashboard with PowerBI - Part Two
มุมมอง 1.4K5 หลายเดือนก่อน
Build A Data Challenge Winning Retail Sales Optimization Dashboard with PowerBI - Part Two
Build A Data Challenge Winning Retail Sales Optimization Dashboard with PowerBI - Part One
มุมมอง 6K6 หลายเดือนก่อน
Build A Data Challenge Winning Retail Sales Optimization Dashboard with PowerBI - Part One
Web Scraping with Power Query - Handling Pagination - Data Extraction - Combining Data
มุมมอง 2676 หลายเดือนก่อน
Web Scraping with Power Query - Handling Pagination - Data Extraction - Combining Data

ความคิดเห็น

  • @tolulopemakinde4392
    @tolulopemakinde4392 10 วันที่ผ่านมา

    This is so awesome, detailed and profesional. I really love what you have done. i'll try to replicate it as well. Thanks for the efforts comited to this production.

  • @MohamedMontaser91
    @MohamedMontaser91 11 วันที่ผ่านมา

    I don't think you need to create measures for conditional formatting

    • @ZefasBi-Analytics
      @ZefasBi-Analytics 11 วันที่ผ่านมา

      There are always several ways to achieve same result

  • @SANDATA764
    @SANDATA764 12 วันที่ผ่านมา

    Thank you, it’s very good. However, I would like to suggest keeping the total duration of the project to a maximum of 1.5 hours. It becomes challenging to follow and stay engaged when there are too many segments, each lasting at least an hour. Replicating the same content will take an additional hour. Moving forward, please consider limiting the overall video length to 1 to 1.5 hours for the entire project. Best regards.

    • @ZefasBi-Analytics
      @ZefasBi-Analytics 12 วันที่ผ่านมา

      Thanks for your advice, however, you mustn’t watch the entire video at a stretch, take breaks. Also if you’re quick to get the concepts, you can always skim through the video. Few strategies that keep you focus.

    • @CarlosVolpe-w1n
      @CarlosVolpe-w1n 9 วันที่ผ่านมา

      Please upload advanced dashboards in eCommerce and Retail domains in both Power BI & Excel 😊 showing the usage of new kpi cards, bookmarks etc.

  • @fabiuskumgne3659
    @fabiuskumgne3659 12 วันที่ผ่านมา

    thank you very much for this video

  • @nikhildhongade291
    @nikhildhongade291 14 วันที่ผ่านมา

    waiting for part 2

  • @davidfeliciofr
    @davidfeliciofr 14 วันที่ผ่านมา

    Verry good, congrats

  • @idewelevictory4255
    @idewelevictory4255 14 วันที่ผ่านมา

    Your teaching has been awesome, pls drop the part 2 of this recording.

  • @shawnsmothers1715
    @shawnsmothers1715 16 วันที่ผ่านมา

    When is part two coming?

    • @ZefasBi-Analytics
      @ZefasBi-Analytics 16 วันที่ผ่านมา

      This weekend

    • @shawnsmothers1715
      @shawnsmothers1715 16 วันที่ผ่านมา

      @@ZefasBi-Analytics thanks. Im done with the first one. Excited for the second part.

  • @adhows4233
    @adhows4233 16 วันที่ผ่านมา

    Sir whenthe second part will be uploaded

  • @praneshnaik5339
    @praneshnaik5339 19 วันที่ผ่านมา

    You're the best, just love the way you explain everything!

  • @Azamkhan-fd5yq
    @Azamkhan-fd5yq 24 วันที่ผ่านมา

    Hi, where can i find the open ticket DoD dax code ?

  • @amrutprasade4277
    @amrutprasade4277 หลายเดือนก่อน

    Hi Okeh Zefas Pharma project is quite suitable for practice i was trying to replicate it, but Due to the low quality of the video, I am unable to see the DAX formulas. Could you please help me with that? I would really appreciate it.

  • @idewelevictory4255
    @idewelevictory4255 หลายเดือนก่อน

    Hello, thanks for all you do. I was trying to recreate this but my _YoY% measures are all showing 0.000 for the year when filtered except for 2011 which is showing the correct value and 2018 is showing blank. I don't know what is wrong, I will any assistance pls.

  • @simplythewestprints
    @simplythewestprints หลายเดือนก่อน

    I keep getting repeats of data from the first page, any ideas?

  • @royarahmatian4541
    @royarahmatian4541 2 หลายเดือนก่อน

    Thank you very much

  • @saichandu5965
    @saichandu5965 2 หลายเดือนก่อน

    Awesome bro...loved this and been looking for this kind of format thanks a lot for making this ...keep on doing this awesome work where beginners like me can learn...it helps if you can keep complete videos on how your making the dashboards... appreciate your work ...

  • @mfonisosamuel7348
    @mfonisosamuel7348 2 หลายเดือนก่อน

    Awesome video. The calender table you created, the DAX function wasn't clear enough. Also, how did you design the background on powerpoint? Thank you for all you do

    • @ZefasBi-Analytics
      @ZefasBi-Analytics 2 หลายเดือนก่อน

      Ok, I think you can work around that. As for the design, I imported an image background then added layout and all in PowerPoint

  • @aishwaryapattnaik3082
    @aishwaryapattnaik3082 2 หลายเดือนก่อน

    Can you please make this from start to end please

  • @neptoonpalace4027
    @neptoonpalace4027 2 หลายเดือนก่อน

    Another great video brother...but your voice is not clear.

  • @akinfelabernard6358
    @akinfelabernard6358 2 หลายเดือนก่อน

    Love this mah boss Will surely watch this boss ❤🎉

  • @akinfelabernard6358
    @akinfelabernard6358 2 หลายเดือนก่อน

    You always make the best and most beautiful dashboard

  • @PowerAnalyst
    @PowerAnalyst 2 หลายเดือนก่อน

    Hey Brother, wouls love to see how you make background images..couls you pls create a video on same? What is the canvas size here ?

    • @ZefasBi-Analytics
      @ZefasBi-Analytics 2 หลายเดือนก่อน

      I will try on this ok. Thanks .

  • @ceyhunozturk5115
    @ceyhunozturk5115 2 หลายเดือนก่อน

    when you are going to share this project :)

  • @MVK7210
    @MVK7210 3 หลายเดือนก่อน

    It seems that data is changed from the reference presentation to the one we are working on 😅😅. 36:50 vs 36:58

    • @ZefasBi-Analytics
      @ZefasBi-Analytics 2 หลายเดือนก่อน

      The reference report is filter to 2014

    • @ZefasBi-Analytics
      @ZefasBi-Analytics 2 หลายเดือนก่อน

      1:21 you will notice i unchecked the filter.. really dont know what's funny though

    • @MVK7210
      @MVK7210 2 หลายเดือนก่อน

      @@ZefasBi-Analytics HO yes i just noticed it 😥

  • @TanmayGoswami-fo9bg
    @TanmayGoswami-fo9bg 3 หลายเดือนก่อน

    Thanks for this informative video! I learned a lot and appreciate the clear explanations. Completing this project personally gave me great hands-on experience. Keep up the great work!

  • @Rukween
    @Rukween 3 หลายเดือนก่อน

    Been watching your videos since last week and boy have I learned a lot!!!! Thank you very much for these well detailed videos 👏👏👏

  • @neptoonpalace4027
    @neptoonpalace4027 3 หลายเดือนก่อน

    Brother Efasa I really like your ticket analysis project but more than the project itself I really want to know how you derive what approach to take what to include and especially your analytical mindset...please make a video on it.... With only the data I could have never derived such insights and proper approach... please teach us

    • @ZefasBi-Analytics
      @ZefasBi-Analytics 3 หลายเดือนก่อน

      Ok Bro I will make a short video on that.

    • @neptoonpalace4027
      @neptoonpalace4027 3 หลายเดือนก่อน

      @@ZefasBi-Analytics Thanks alot 🙏

  • @neptoonpalace4027
    @neptoonpalace4027 3 หลายเดือนก่อน

    Where will I be without you brother 🥹

  • @Foodie-Techie
    @Foodie-Techie 3 หลายเดือนก่อน

    Hey, make a complete end to end video for this project.

    • @ZefasBi-Analytics
      @ZefasBi-Analytics 3 หลายเดือนก่อน

      Not to worry I'm already on it

  • @qasimali-gu3oz
    @qasimali-gu3oz 3 หลายเดือนก่อน

    Can you create this report from the start, please.

  • @eniolaadekoya5623
    @eniolaadekoya5623 3 หลายเดือนก่อน

    Great Video ,For clarity sake was the background design on power point

  • @neptoonpalace4027
    @neptoonpalace4027 3 หลายเดือนก่อน

    Please could you make a video on how to understand business problem...what approach to take...which DAX & KPI's to add...basically the analysis and insights of any project.

  • @neptoonpalace4027
    @neptoonpalace4027 3 หลายเดือนก่อน

    Brother Okeh amazing work as always...every video of yours is so much informative....and could you tell how to get the icons for status ticket KPI's

  • @tomijohn7165
    @tomijohn7165 3 หลายเดือนก่อน

    welldone bro

  • @nikhildhongade291
    @nikhildhongade291 3 หลายเดือนก่อน

    good job brother.

  • @devendrabarasker4987
    @devendrabarasker4987 3 หลายเดือนก่อน

    very much appreciate your work i have learnt lot of things from your videos. keep it up bro and & bring more projects like this 💪💪🔥

    • @ZefasBi-Analytics
      @ZefasBi-Analytics 3 หลายเดือนก่อน

      Glad to hear that.. Will definitely keep it coming

  • @devendrabarasker4987
    @devendrabarasker4987 3 หลายเดือนก่อน

    great content and you explained it very well please come up with more videos like this 🔥🙌🙌

  • @sonalirajput417
    @sonalirajput417 3 หลายเดือนก่อน

    Definitely I am gonna add this in my portfolio.

  • @gurvindersingharora5301
    @gurvindersingharora5301 3 หลายเดือนก่อน

    Hello Sir, When to combine ALL function with Calculate + Filter function in DAX in detail ? Please make a video of it 🙏 ❤

  • @shaikhshoeb9211
    @shaikhshoeb9211 3 หลายเดือนก่อน

    When is the part 2 coming??

  • @alexrosen8762
    @alexrosen8762 3 หลายเดือนก่อน

    Superuseful 👌Subscribed!

  • @geta9722
    @geta9722 3 หลายเดือนก่อน

    If you provide data set that is v.good to flow more.

    • @ZefasBi-Analytics
      @ZefasBi-Analytics 3 หลายเดือนก่อน

      docs.google.com/spreadsheets/d/1mWQZxsmu4z8MNo70m6lwvvK8_78WpRuZC9LF5ItsRfI/edit#gid=1279374726

  • @dhruvikdetroja1993
    @dhruvikdetroja1993 3 หลายเดือนก่อน

    Amazing Dashboard I will definitely do this project by learning from your video's keep making those video's and thanks for making such educational projects

  • @sam02109
    @sam02109 3 หลายเดือนก่อน

    Amazing Sir.... I enjoyed and learned a lot..... Thank you

  • @petermichalek5118
    @petermichalek5118 4 หลายเดือนก่อน

    super cool

  • @eszterkovacs9929
    @eszterkovacs9929 4 หลายเดือนก่อน

    Very useful and helpful video! Thank you!

  • @amitpatel75
    @amitpatel75 4 หลายเดือนก่อน

    Thanks for making hands on video of this beautiful power bi report , You have done a great job 🎉

  • @emmettunderwood6858
    @emmettunderwood6858 4 หลายเดือนก่อน

    🌷 'promo sm'

  • @adityabobade2685
    @adityabobade2685 4 หลายเดือนก่อน

    sir any video on new topic ?

  • @xeeshanahmad8757
    @xeeshanahmad8757 4 หลายเดือนก่อน

    Excellent but need on voice quality.🙏