Zefas Bi and Analytics
Zefas Bi and Analytics
  • 26
  • 31 356
Power BI Decision-Making Dashboard | Aurora Bank Analysis - Part Two
Aurora Bank's data to uncover critical insights to improve decision making.
Key highlights of my analysis include:
Demographic Analysis: Age group, gender, and income segmentation.
Financial Health: Debt-to-Income Ratios and Debt Risk Scores to assess high-risk customers.
Transaction Analysis: Patterns across credit card transactions and customer spending trends.
These insights enable personalized engagement strategies and improve risk assessments, driving smarter decisions for the bank.
Link to my Report :app.powerbi.com/view?r=eyJrIjoiNGZmN2I2NTAtNjMwZC00MDJjLThjYzctODhhNmFlMDMyZDFkIiwidCI6IjZlMjY5MzE1LWM2NTAtNDM3Zi1iMzE3LTFhODQyOWRlZjM3MyJ9
Link to Dataset and Files: drive.google.com/drive/folders/1zAhYFy8dBpLbbQ4aHpjCUpjg7D0IY9p1?usp=sharing
Icon Link: www.flaticon.com/
Colors Link:colorhunt.co/
Buy me a Coffee: www.buymeacoffee.com/ZefasBI
มุมมอง: 143

วีดีโอ

Power BI Decision-Making Dashboard | Aurora Bank Analysis - Part One
มุมมอง 3782 ชั่วโมงที่ผ่านมา
Aurora Bank's data to uncover critical insights to improve decision making. Key highlights of my analysis include: Demographic Analysis: Age group, gender, and income segmentation. Financial Health: Debt-to-Income Ratios and Debt Risk Scores to assess high-risk customers. Transaction Analysis: Patterns across credit card transactions and customer spending trends. These insights enable personali...
FP20 October 2024 -Marketing Email Campaign Challenge KPI Analysis
มุมมอง 3692 หลายเดือนก่อน
In this video, we explore how to effectively analyze email campaign data, focusing on the key KPIs that drive performance: Total Emails Sent Emails Delivered Bounced Emails (and evaluating bounce rate) Open Rate Subscription Rate Conversion Rate and more We also discuss the concept of the email funnel. By leveraging these KPIs, you can identify the most successful campaigns and determine which ...
Onyx Data DNA October 2024 - Employee Performance KPI Review
มุมมอง 5582 หลายเดือนก่อน
In this video, we explore the key KPIs essential for analyzing employee performance effectively. The main KPIs identified include: Headcount Retention Rate Turnover Rate / Attrition Rate Performance Our analysis covers: Employee Demographics Employee Valuation Performance and Productivity Download material from one drive Link to one drive: drive.google.com/drive/folders/19AKf-O8wIlFQ11ir6KY9lbA...
Ultimate Power BI Guide: Analyzing Key Financial KPIs for Fitness Company - Part Two
มุมมอง 6983 หลายเดือนก่อน
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, ...
Ultimate Power BI Guide: Analyzing Key Financial KPIs for Fitness Company - Part One
มุมมอง 1.7K3 หลายเดือนก่อน
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
มุมมอง 1485 หลายเดือนก่อน
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
มุมมอง 7925 หลายเดือนก่อน
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.9K5 หลายเดือนก่อน
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
มุมมอง 1.3K6 หลายเดือนก่อน
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.7K6 หลายเดือนก่อน
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
มุมมอง 6K7 หลายเดือนก่อน
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
มุมมอง 4997 หลายเดือนก่อน
"📊 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
มุมมอง 2667 หลายเดือนก่อน
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
มุมมอง 2538 หลายเดือนก่อน
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
มุมมอง 8058 หลายเดือนก่อน
Build A Matrix Native Visual With Power BI
Matrix Native Visual With Power BI
มุมมอง 1488 หลายเดือนก่อน
Matrix Native Visual With Power BI
IMDb Movies Analysis - Power BI Project
มุมมอง 7238 หลายเดือนก่อน
IMDb Movies Analysis - Power BI Project
Power BI Vs Tableau - An Interactive Dashboard Analysis of Udemy Courses. - Part Two
มุมมอง 4698 หลายเดือนก่อน
Power BI Vs Tableau - An Interactive Dashboard Analysis of Udemy Courses. - Part Two
Power BI Vs Tableau - An Interactive Dashboard Analysis of Udemy Courses. - Part One
มุมมอง 6998 หลายเดือนก่อน
Power BI Vs Tableau - An Interactive Dashboard Analysis of Udemy Courses. - Part One
An Interactive Udemy Courses Analysis Dashboard
มุมมอง 6268 หลายเดือนก่อน
An Interactive Udemy Courses Analysis Dashboard
Build A Data Challenge Winning Products Ratings & Reviews Analysis Dashboard with PowerBI -Part One
มุมมอง 2.5K8 หลายเดือนก่อน
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
มุมมอง 4028 หลายเดือนก่อน
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.5K9 หลายเดือนก่อน
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
มุมมอง 7K9 หลายเดือนก่อน
Build A Data Challenge Winning Retail Sales Optimization Dashboard with PowerBI - Part One
Web Scraping with Power Query - Handling Pagination - Data Extraction - Combining Data
มุมมอง 34210 หลายเดือนก่อน
Web Scraping with Power Query - Handling Pagination - Data Extraction - Combining Data

ความคิดเห็น

  • @BcConnect
    @BcConnect 7 ชั่วโมงที่ผ่านมา

    what about the continuation ?

    • @ZefasBi-Analytics
      @ZefasBi-Analytics 3 ชั่วโมงที่ผ่านมา

      Tomorrow almost done

  • @LeggetYomary
    @LeggetYomary 14 ชั่วโมงที่ผ่านมา

    You're doing a fantastic job! I need some advice: My OKX wallet holds some USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). Could you explain how to move them to Binance?

  • @BcConnect
    @BcConnect 18 ชั่วโมงที่ผ่านมา

    calendar = VAR BaseCalendar = CALENDAR(DATE(2012, 1, 1), DATE(2014, 12, 31)) RETURN ADDCOLUMNS( BaseCalendar, "Year", YEAR([Date]), "Quarter", QUARTER([Date]), "Month", MONTH([Date]), "Week Number", WEEKNUM([Date]), "Week Day", WEEKDAY([Date]), "Day", DAY([Date]), "Month Name", FORMAT([Date], "MMMM"), "Month Sort", FORMAT([Date], "YYYY MM"), "Quarter Number", "Q" & QUARTER([Date]), "Year Month", FORMAT([Date], "YYYY MMMM"), "Year Month Sort", YEAR([Date]) * 100 + MONTH([Date]), -- Sortable Year-Month column "Weekend?", [Date] = 0 + WEEKDAY([Date]) )

  • @BcConnect
    @BcConnect 18 ชั่วโมงที่ผ่านมา

    great video i got stuck at 21:39 because the code aint bright enough and you did include the code in the Aurora Dax docx file

    • @ZefasBi-Analytics
      @ZefasBi-Analytics 18 ชั่วโมงที่ผ่านมา

      done check please

    • @BcConnect
      @BcConnect 18 ชั่วโมงที่ผ่านมา

      @@ZefasBi-Analytics i used gpt to extract the text from the video

    • @BcConnect
      @BcConnect 18 ชั่วโมงที่ผ่านมา

      thats fine thanks

  • @ZefasBi-Analytics
    @ZefasBi-Analytics 18 ชั่วโมงที่ผ่านมา

    Will add that to the file on one drive now

  • @BcConnect
    @BcConnect 19 ชั่วโมงที่ผ่านมา

    great but no code for the calender dax

  • @isBessem
    @isBessem วันที่ผ่านมา

    Great work! The only observation I have is about the Canva settings that must be set to 16:9 in case people would like to participate in challenges like in your example 🤗

  • @SandyCoco1
    @SandyCoco1 วันที่ผ่านมา

    Getting my learning materials ready. Thanks for sharing your knowledge with us ❤

  • @chinmayee.m.dchinnu5564
    @chinmayee.m.dchinnu5564 10 วันที่ผ่านมา

    Can plz send the code that u have used in Calendar table sir

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

    I’m stucked to your Chanel

  • @linamishan1831
    @linamishan1831 28 วันที่ผ่านมา

    Thanks a lot Zefas. Just finished Part One video. Looking forward to continue Part Two. Very straight forward and easy to understand.

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

    I think the name of operating profit break down should be gross profit breakdown , because there we calculate only total revenue and Cogs ,then how it becomes Operating profit without deducting operating expenses Gross profit is different from Operating profit EBIT is Operating Profit

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

    Hello! Your dashboard looks fantastic, especially the IMDb interface-it's very impressive. It would be incredibly helpful if you could upload it for further reference. Thank you!

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

    amazing video, thanks for making this video

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

    Thank you very much

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

    This is cool

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

    My Visualization skills got transformed for good via this channel, thanks boss for your teachings.

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

    Great work!

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

    This is cool bro

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

    Great Session

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

    Thank you for the great session! We hope everyone is prepared now, and we are looking forward to your amazing submissions! The deadline to submit your reports to the Onyx Data and ZoomCharts challenges is October 25!

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

    Hey i can't able to download data file please help me with this

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

      docs.google.com/spreadsheets/d/1EoD3ll-vBobCYHdD7zVHp6yapMMRC3aB/edit?usp=drive_link&ouid=101131287472641122866&rtpof=true&sd=true

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

    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 3 หลายเดือนก่อน

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

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

      There are always several ways to achieve same result

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

    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 3 หลายเดือนก่อน

      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 3 หลายเดือนก่อน

      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 3 หลายเดือนก่อน

    thank you very much for this video

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

    waiting for part 2

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

    Verry good, congrats

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

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

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

    When is part two coming?

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

      This weekend

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

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

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

    Sir whenthe second part will be uploaded

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

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

  • @Azamkhan-fd5yq
    @Azamkhan-fd5yq 4 หลายเดือนก่อน

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

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

    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.

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

      ok let me see if i can share the file

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

      check the one drive on the video, you will find the pbix

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

    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 4 หลายเดือนก่อน

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

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

    Thank you very much

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

    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 5 หลายเดือนก่อน

    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 5 หลายเดือนก่อน

      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 6 หลายเดือนก่อน

    Can you please make this from start to end please

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

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

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

    Love this mah boss Will surely watch this boss ❤🎉

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

    You always make the best and most beautiful dashboard

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

    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 6 หลายเดือนก่อน

      I will try on this ok. Thanks .

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

    when you are going to share this project :)

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

    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 6 หลายเดือนก่อน

      The reference report is filter to 2014

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

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

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

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

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

    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 6 หลายเดือนก่อน

    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 6 หลายเดือนก่อน

    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 6 หลายเดือนก่อน

      Ok Bro I will make a short video on that.

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

      @@ZefasBi-Analytics Thanks alot 🙏

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

    Where will I be without you brother 🥹