Nestor Adrianzen
Nestor Adrianzen
  • 216
  • 2 392 107
Create a CALENDAR Table like a Pro with BRAVO for Power BI
Create a CALENDAR Table like a Pro with BRAVO for Power BI//
If you are ready to take your Power BI reports to the next level, you will want to take full advantage of Bravo for Power BI. With Bravo for Power BI, you can create a Calendar table and time intelligence calculations in seconds.
---------------------------------------------------------------------
✅Bravo for Power BI is a free open-source tool that helps you create a Power BI model with a simple user interface. You can analyze your model, format DAX, manage dates, and export data.
Found the Power BI content helpful and want to support my work? Feel free to buy me a cup of coffee ☕👇
✅www.paypal.me/quipuanalytics
🥇 JOIN THE POWER BI DISCUSSIONS
✅Join the Business Intelligence Teammates Group on LinkedIn: www.linkedin.com/groups/12848133/
✅Join the Business Intelligence Teammates Group on Facebook: groups/biteammates
📩NEWSLETTER
✅ Be one of the first to receive my high-quality tutorials in your inbox each week: www.vizxlization.com/subscribetonewsletter
⏳ RESOURCES
☑️ Demo file: drive.google.com/file/d/11bcj5Iv0JCFFtr-WdgxLkWwcjCF1EWsj/view?usp=sharing
-----------------------------------------------
📚HIGHLY RECOMMENDED BOOKS (Affiliate links)
***The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition: 🔗amzn.to/3ldPLpk
***DAX Patterns (Second Edition): 🔗amzn.to/3fBKdnD
***Analyzing Data with Power BI and Power Pivot for Excel: 🔗amzn.to/3fDPLOd
***Beginning DAX with Power BI: 🔗amzn.to/3fDEe1k
***Storytelling with Data: A Data Visualization Guide for Business Professionals: 🔗amzn.to/3mfPcwE
***Storytelling with Data: Let's Practice! 🔗amzn.to/36c6Cot
***Information Dashboard Design:🔗 amzn.to/2V61o7h
📺RELATED VIDEO TUTORIALS
***Playlist with all my Power BI tutorials: ua-cam.com/play/PL0i0p-fpAW5xurQPN_S8K5JH1HBUD_47F.html
*** Playlist with all my Interviews: ua-cam.com/play/PL0i0p-fpAW5xmBS5uZ2mTGstlCRcq_vDK.html
[DISCLAIMER]: Some links included in this description might be affiliate links. I might receive a small commission if you purchase a product with those links. However, there is no additional charge to you! I appreciate your support and this will help me provide you with free content every week.
👋CONNECT WITH ME
LinkedIn 🔗 www.linkedin.com/in/nestoradrianzen/
LinkedIn 🔗 www.linkedin.com/company/quipuanalytics/
Twitter 🔗 quipuanalytics/
Facebook 🔗 quipuanalytics/
Instagram 🔗 nestoradrianzen
Web 🔗www.quipuanalytics.com/
👊SUPPORT MY WORK
***Hit the thanks icon in any video and subscribe to the channel ▶ua-cam.com/users/NestorAdrianzen
👨‍💻COURSES
*** Dismantling the Secrets of Power BI Desktop: quipuanalytics.thinkific.com/courses/power-bi-desktop-the-basics
🎧Song: Axol - Mars [NCS Release]
Music provided by NoCopyrightSounds
Free Download/Stream: ncs.io/Mars
Watch: ua-cam.com/video/0oq2Ej36nlY/v-deo.html
#PowerBI #QuipuAnalytics #BravoForPowerBI
Переглядів: 492

Відео

Master Bravo and DAX Studio for Power BI with Marco Russo
Переглядів 3552 місяці тому
If you are ready to take your Power BI reports to the next level, you will want to take full advantage of free open-source tools such as Bravo for Power BI and DAX Studio. Marco Russo, one of the authors of the Definite Guide to DAX, will walk us through the key functionalities of Bravo and DAX studio. 🎬 Full Interview: ua-cam.com/users/livebG1WS2UUymg?si=wZthJQzX8EyamvHV ✅Bravo for Power BI is...
Use POWER BI Like a Pro | Power BI Workshop for Beginners | Full Course
Переглядів 6722 місяці тому
Use POWER BI Like a Pro | Power BI Workshop for Beginners | Full Course I'm thrilled to announce that I've been hard at work on an all-new Power BI workshop, taking you from zero to hero. Whether you're completely new to Power BI or simply looking for a refresher, this is the perfect opportunity to master Power BI. I encourage you to dive into the Power BI content and kindly share your valuable...
MAY 2024 Power BI Update | Master Publish to Folders and Matrix Layout
Переглядів 5122 місяці тому
Explore the May 2024 Power BI Updates Unlock the full potential of matrix layouts and publish reports to folders directly from Power BI Desktop. Learn to create dynamic reports. Whether you are a Power BI novice or a pro, this video has insights to take your design skills in Power BI to the next level. Enjoy! ✌ Found the Power BI content helpful and want to support my work? Feel free to buy me ...
How to DYNAMICALLY HIGHLIGHT Line Charts in Power BI
Переглядів 6193 місяці тому
IMPROVE Your Power BI Reports by dynamically highlighting line charts in Power BI. Unlock the full potential of line charts with dynamic line selections. Learn to create dynamic reports. Whether you are a Power BI novice or a pro, this video has insights to take your design skills in Power BI to the next level. Enjoy! ✌ Found the Power BI content helpful and want to support my work? Feel free t...
Master VISUAL CALCULATIONS with Jeroen (Jay) ter Heerdt | Highlights
Переглядів 2863 місяці тому
🔥 VISUAL CALCULATIONS, DAX is Simple and Easy Now?! "Visual calculations make it easier to create calculations that were previously hard to create in Power BI, leading to simpler DAX, easier maintenance, and better performance." - Jay ter Heerdt Connect with Jay: ✅ LinkedIn: @jeroenterheerdt ✅ X: @JayPowerBI Found the Power BI content helpful and want to support my work? Feel free to buy me a c...
IMPROVE Your Power BI Reports | 100% Stacked Area Chart and Line Enhancements. What?!
Переглядів 9004 місяці тому
IMPROVE Your Power BI Reports with the 100% Stacked Area Chart and Line Enhancements. Unlock the full potential of the new visual, 100% stacked area chart, and line enhancements in Power BI with my step-by-step tutorial. Learn to create dynamic reports with the new visual 100% stacked area chart and the line enhancements. Whether you are a Power BI novice or a pro, this video has insights to ta...
APRIL 2024 POWER BI UPDATE | What's new, Miguel Myers?!
Переглядів 1,1 тис.4 місяці тому
👋 Hey folks! Ready for the April 2024 Power BI Update? 🔥 Great news. This past Saturday I had the honor to chat with Miguel Myers from Microsoft. Miguel gave us a taste of what's coming in the April 2024 Power BI update. As you might know, one of Miguel's goals is to take the native Power BI visuals to the next level. So far, the new Power BI core visuals have been mind-blogging, especially the...
VISUAL CALCULATIONS in Power BI || DAX is SIMPLE and EASY now?!
Переглядів 8955 місяців тому
Master Visual Calculations in Power BI | February 2024 Power BI Update Unlock the full potential of Visual Calculations in Power BI with our step-by-step tutorial. Learn to create dynamic reports with visual calculations. Whether you are a Power BI novice or a pro, this video has insights to take your visual calculations skills in Power BI to the next level. I share 9 templates/examples to crea...
Master REFERENCE LABELS in Power BI [February 2024] Power BI Update
Переглядів 2 тис.5 місяців тому
Master REFERENCE LABELS in Power BI | February 2024 Power BI Update Unlock the full potential of REFERENCE LABELS in Power BI with our step-by-step tutorial. Learn to create dynamic card visuals with reference labels and compare metrics easily (no more workarounds). Whether you are a Power BI novice or a pro, this video has insights to take your Power BI skills to the next level. I share my top...
Master Power BI DAX Tips!
Переглядів 1,3 тис.6 місяців тому
Power BI DAX Tips Worth Learning!// Unlock the full potential of DAX in Power BI with my step-by-step tutorial. Learn to create powerful Power BI DAX calculations. Whether you are a Power BI novice or a pro, this video has insights to take your Power BI DAX skills to the next level. Enjoy! ✌ Found the Power BI content helpful and want to support my work? Feel free to buy me a cup of coffee ☕👇 ✅...
December 2023 Power BI Update | 3 Tips that You SHOULD Know
Переглядів 1,4 тис.7 місяців тому
December 2023 Power BI Update | 3 Tips that You SHOULD Know
QUIPU ANALYTICS is Born!
Переглядів 4047 місяців тому
QUIPU ANALYTICS is Born!
Master the NEW BUTTON SLICER in Power BI | Nov 2023 Power BI Update
Переглядів 2,1 тис.8 місяців тому
Master the NEW BUTTON SLICER in Power BI | Nov 2023 Power BI Update
Master REFERENCE LABELS in Power BI | November 2023 Power BI Update
Переглядів 23 тис.9 місяців тому
Master REFERENCE LABELS in Power BI | November 2023 Power BI Update
Unlock the Full Potential of CALCULATION GROUPS in Power BI Desktop | Oct 2023 Power BI Update
Переглядів 11 тис.10 місяців тому
Unlock the Full Potential of CALCULATION GROUPS in Power BI Desktop | Oct 2023 Power BI Update
Boost Your Power BI Productivity with Hidden DAX Keyboard SHORTCUTS
Переглядів 63510 місяців тому
Boost Your Power BI Productivity with Hidden DAX Keyboard SHORTCUTS
Become a Power BI Pro: Create Stunning KPI Card Visuals
Переглядів 1,7 тис.10 місяців тому
Become a Power BI Pro: Create Stunning KPI Card Visuals
Create a POWER BI APP Like a Pro | For Multiple Audiences. What?!
Переглядів 6 тис.10 місяців тому
Create a POWER BI APP Like a Pro | For Multiple Audiences. What?!
Power BI Update September 2023 | 3 GREAT Features
Переглядів 1,2 тис.11 місяців тому
Power BI Update September 2023 | 3 GREAT Features
Unleash the Power of Visuals: Dynamic Custom Icons in POWER BI
Переглядів 2,1 тис.11 місяців тому
Unleash the Power of Visuals: Dynamic Custom Icons in POWER BI
Master POWER BI in just 1 hour! From Zero to Hero 💥
Переглядів 5 тис.11 місяців тому
Master POWER BI in just 1 hour! From Zero to Hero 💥
Master the Art of Creating DYNAMIC Calendar Tables in Power BI | Power Query
Переглядів 3,2 тис.11 місяців тому
Master the Art of Creating DYNAMIC Calendar Tables in Power BI | Power Query
August 2023 Power BI Update. What's new?!
Переглядів 2,2 тис.11 місяців тому
August 2023 Power BI Update. What's new?!
How to Create a DYNAMIC Drop-Down List in Excel [2 EASY Methods]
Переглядів 702Рік тому
How to Create a DYNAMIC Drop-Down List in Excel [2 EASY Methods]
Power BI Background DESIGN with FIGMA
Переглядів 6 тис.Рік тому
Power BI Background DESIGN with FIGMA
CUSTOM VISUALS in Power BI by KERRY KOLOSKO
Переглядів 1,3 тис.Рік тому
CUSTOM VISUALS in Power BI by KERRY KOLOSKO
DUPLICATE vs REFERENCE Query in Power BI
Переглядів 2,6 тис.Рік тому
DUPLICATE vs REFERENCE Query in Power BI
DYNAMIC TITLES in Power BI Desktop
Переглядів 2,2 тис.Рік тому
DYNAMIC TITLES in Power BI Desktop
JULY 2023 Power BI Update
Переглядів 1,9 тис.Рік тому
JULY 2023 Power BI Update

КОМЕНТАРІ

  • @emmanuelaolaiya
    @emmanuelaolaiya 2 дні тому

    ❤❤❤thanks so much

    • @NestorAdrianzen
      @NestorAdrianzen 2 дні тому

      Glad you found this tutorial helpful. Cheers!

  • @mohamedyoussef8367
    @mohamedyoussef8367 3 дні тому

    Our dear professor, can you send the equation as the video is not clear to me? Thank you❤

  • @mohamedyoussef8367
    @mohamedyoussef8367 3 дні тому

    Our dear professor, can you send the equation as the video is not clear to me? Thank you❤

  • @erinfield1943
    @erinfield1943 4 дні тому

    Creating new table- 8:06

  • @oladayoadebiyi5166
    @oladayoadebiyi5166 9 днів тому

    The first tab is "All" which means everyone has access to the report

  • @readerisleader12
    @readerisleader12 10 днів тому

    ho we can rercord audio with navigation. when i record ausio of dashboard in power point the page of my report does not navigate

  • @albedoguardian875
    @albedoguardian875 13 днів тому

    Underrated channel. More videos like this and more background design please❤

    • @NestorAdrianzen
      @NestorAdrianzen 13 днів тому

      I appreciate your support. Keep it up 👍

  • @QuantumIdeas
    @QuantumIdeas 15 днів тому

    Subscribed! Had to review this video for me to fix some errors. My bookmark came in handy...

  • @DM.DE.DA.DS.ML.DL.Ai1
    @DM.DE.DA.DS.ML.DL.Ai1 15 днів тому

    You have good explanation but I told you that I face some problems with buttons since 3 days you not answer me

    • @NestorAdrianzen
      @NestorAdrianzen 13 днів тому

      Thanks for stopping by. Could you provide more details about your question so I can guide you better? Please share an email explaining (include screenshots) where you got stuck and I'll do my best to guide you --> nestor@quipuanalytics.com

    • @DM.DE.DA.DS.ML.DL.Ai1
      @DM.DE.DA.DS.ML.DL.Ai1 13 днів тому

      @@NestorAdrianzen Thank you for your kindness i will provide it very soon

    • @DM.DE.DA.DS.ML.DL.Ai1
      @DM.DE.DA.DS.ML.DL.Ai1 15 годин тому

      @@NestorAdrianzen I sent you an email thank you my brother

  • @dbamentorparag
    @dbamentorparag 21 день тому

    Thanks for your time

  • @KelvinTieu
    @KelvinTieu 22 дні тому

    this video will probably help me in my test

  • @stephanemesnildrey105
    @stephanemesnildrey105 23 дні тому

    Pour la France vous pouvez me donner la taille à mettre en place dans les paramètres de début dans Powerpoint, je n'arrine pas à avoir la bonne taille. Merci beaucoup

    • @NestorAdrianzen
      @NestorAdrianzen 10 днів тому

      Thanks for your support. I think you are looking for the canva dimensions. Check them out here 👉 drive.google.com/file/d/1ZKy6mBsH66uQqlwSiX20Eb7uXWjJpqgS/view

  • @stephanemesnildrey105
    @stephanemesnildrey105 23 дні тому

    Bonjour Merci pour cette vidéo très intéressante. bravo😉

  • @theMilgarStudio
    @theMilgarStudio 25 днів тому

    That's really cool. Thank you so much

  • @MohammadAl-Dalalah
    @MohammadAl-Dalalah Місяць тому

    nice video please could you please send me the data file

    • @NestorAdrianzen
      @NestorAdrianzen 10 днів тому

      Mohammad Al-Dalala'h, Thanks for stopping by. I usually share the file in my video descriptions: Check it out here 👉 drive.google.com/file/d/1ntmnSxnHr3r_fGP7lCEC3BSrsyIizZvf/view

  • @rainbow433
    @rainbow433 Місяць тому

    "Thanks for the helpful video."

  • @esteloma
    @esteloma Місяць тому

    Saludos! puedes indicarme si es posible hacer un gráfico que compare los valores de dos meses que no se de barras, quizá utilizando flechas arriba cuando es mayor que o flecha hacia abajo indicando disminución?

  • @zc16jnunez
    @zc16jnunez Місяць тому

    are you ecuadorian?

    • @NestorAdrianzen
      @NestorAdrianzen Місяць тому

      Thanks for stopping by. Please check out my website for more details about my ancestors and my company. quipuanalytics.com

    • @zc16jnunez
      @zc16jnunez Місяць тому

      @@NestorAdrianzen My last name is Nunez- Quispe. I also share similar ancestry with my family coming from Ecuador and Peru with Inca Origins

  • @mauespinola
    @mauespinola Місяць тому

    genial, tan claro. Te lo agradezco mucho

    • @NestorAdrianzen
      @NestorAdrianzen Місяць тому

      Excelente. Gracias por revisar el contenido

    • @mauespinola
      @mauespinola Місяць тому

      @@NestorAdrianzen una duda, tú obtienes los datos de amazon por mes, pero cuando se muestra en tableau es por año. Eso lo hiciste con alguna función, porque a mi me aparecen por cada mes

  • @jamelludwigedma4405
    @jamelludwigedma4405 Місяць тому

    Thank You Nestor this what i need. :)

  • @MichaelShannon-yv8tv
    @MichaelShannon-yv8tv Місяць тому

    Thanks Nestor...This is exactly what I needed for duration values for call records. CHEERS!!!

  • @andreaberdazaiz8580
    @andreaberdazaiz8580 Місяць тому

    Muchas gracias! Un consulta, si quiero comparar por semanas, como hago?

    • @NestorAdrianzen
      @NestorAdrianzen Місяць тому

      Puedes usar DAY como el intervalo y -7 como el número de intervalos.

  • @fankitty929
    @fankitty929 Місяць тому

    Thanks for this very informative video. Q - When there's a report that have multiple pages, is there a way to make the first page the main selection in the menu and page 2-4 all sub? Currently Page 1 is the main drop down + 1st subpage. Thanking you in advance.

    • @akashphatangare721
      @akashphatangare721 Місяць тому

      you can change the order of the pages by going in that particular report

  • @manuelserna1369
    @manuelserna1369 Місяць тому

    Muchas gracias por esta master class mi estimado ,saludos desde Panamá

    • @NestorAdrianzen
      @NestorAdrianzen Місяць тому

      Gracias por revisar el contenido, Manuel!

  • @shoaibrehman9988
    @shoaibrehman9988 Місяць тому

    Hi, i have a question, In Bravo calendar, the week number number column is present??

    • @NestorAdrianzen
      @NestorAdrianzen Місяць тому

      Yes, it should be there. You need to unhide it. Select Table View > Select Date table > Unhide Day of Week Number

  • @xeeshanahmad8757
    @xeeshanahmad8757 Місяць тому

    Fabulous 👍

  • @PCDrCaps
    @PCDrCaps Місяць тому

    Espectacular Nestor, saludo desde México

  • @hadialavi2476
    @hadialavi2476 Місяць тому

    Fantastic

  • @xeeshanahmad8757
    @xeeshanahmad8757 Місяць тому

    Up to the mark, Bravo 💪👌👍

  • @NestorAdrianzen
    @NestorAdrianzen Місяць тому

    Have you been able to explore Bravo for Power BI yet? The results can be astonishing, especially in creating a calendar table and time intelligence calculations 👇

  • @srinidhistiwari8507
    @srinidhistiwari8507 Місяць тому

    How can we use NETWORKDAYS formula for Averagex and sumx and working hour should count only with in UK time of 8Am - 5Pm

  • @davidlopezblog4292
    @davidlopezblog4292 Місяць тому

    Una consulta, si o si al momento de realizar la asignación del correo electrónico debe ser parte de la organización? hay alguna forma de realizarlo con correos para población externa?

    • @NestorAdrianzen
      @NestorAdrianzen Місяць тому

      Funciona siempre y cuando los correos externos corporativos tengan licencia Power BI Pro al menos. Correos personales de gmail, hotmail, yahoo, etc. no los reconoce. Saludos

  • @giovanyediazsalcedo9702
    @giovanyediazsalcedo9702 Місяць тому

    Hola Ing. Nestor, Me gustaría tener una Asesoría Personalizada contigo, para tratar el tema de la interacción de horas hombre día con P6 y relacionarlo con Power Bi y Power Query. Saludos y quedo atento a tu Pronta respuesta

    • @NestorAdrianzen
      @NestorAdrianzen Місяць тому

      Giovany, Gracias por revisar el contenido. Puedes enviarme tu pregunta con detalles a nestor@quipuanalytics.com? Lo reviso y te comparto mi retroalimentación. Saludos

  • @xeeshanahmad8757
    @xeeshanahmad8757 Місяць тому

    instead of using following MEASURE (1) YOY Premium Growth % = VAR PYPremium = CALCULATE([Total Premium],DATEADD(Dates[Date],-1,YEAR)) RETURN DIVIDE( ([Total Premium]-PYPremium),PYPremium) i used the following Measure and it works properly YOY_Premium Growth % = DIVIDE([Total_Premium]-[PY_Premium],[PY_Premium]) What is your suggestion?

  • @xeeshanahmad8757
    @xeeshanahmad8757 Місяць тому

    Loud and Clear 👍. Valuable Tutorial.

  • @xeeshanahmad8757
    @xeeshanahmad8757 Місяць тому

    Superb😁

  • @xeeshanahmad8757
    @xeeshanahmad8757 Місяць тому

    👌👍

  • @ciroadolfo01
    @ciroadolfo01 2 місяці тому

    Saludos amigo Nestor. Lo revisé todo el contenido por un aproximado de 3 horas y gratamente sorprendido por la facilidad como explicas cada truco. Siguiendo tus pasos pudo avanzar los 10 a la vez y no me cabe menor duda esta Power Query, JUNTOS con el POWER PIVOT pueden darle la batalla al POWER BI. Al menos para pequeñas o quizás medianas empresas verdad ? Muchas gracias

  • @alexrosen8762
    @alexrosen8762 2 місяці тому

    Amazing tutorial. The best one so far 👌🙏👌

  • @pablovallejos2172
    @pablovallejos2172 2 місяці тому

    Che no se si es un juego de palabras o que, pero YouTub3 traduce con subtitulos automáticos al nombre del canal cómo 'Bisexuales Station". 😅

    • @NestorAdrianzen
      @NestorAdrianzen Місяць тому

      El traductor de UA-cam no hace la traduccción correcta. Actualicé el nombre de mi compañía. Ahora lo puedes encontrar como Quipu Analytics (www.quipuanalytics.com). Saludos

  • @mrbartuss1
    @mrbartuss1 2 місяці тому

    Could you please share the file so we could follow along?

    • @NestorAdrianzen
      @NestorAdrianzen 2 місяці тому

      Here you go: drive.google.com/drive/folders/1P0lZZ0K5TtId1KZmsr7t1x6TSUFMg-xO

    • @mrbartuss1
      @mrbartuss1 2 місяці тому

      @@NestorAdrianzen Thank you!

  • @xeeshanahmad8757
    @xeeshanahmad8757 2 місяці тому

    Super Amazing show, bro.

  • @irfanabbassi9202
    @irfanabbassi9202 2 місяці тому

    Marco the Dax Legend

  • @NestorAdrianzen
    @NestorAdrianzen 2 місяці тому

    How often do you use Bravo or DAX Studio to optimize your Power BI reports? Leave your comments below👇

  • @xeeshanahmad8757
    @xeeshanahmad8757 2 місяці тому

    Thank you so much for creating such an insightful tutorial on how to insert a date table in Power BI! Your clear and concise explanation makes it so much easier to understand and implement. I really appreciate the effort you put into making this video.

  • @xeeshanahmad8757
    @xeeshanahmad8757 2 місяці тому

    Superb 👌

  • @cristiancontreras352
    @cristiancontreras352 2 місяці тому

    Excelente video, todo muy gradual como debe ser

  • @user-dw3wr9qj5f
    @user-dw3wr9qj5f 2 місяці тому

    Hi, can someone pls help... if we need to select a Year from slicer, then how to have YoY growth % changed as per the selected year in slicer? as we have multiple year ... pls guide what dax to use

    • @NestorAdrianzen
      @NestorAdrianzen 2 місяці тому

      For YoY Growth % calculations, please reference this tutorial. ua-cam.com/video/6vJIAJNTdG0/v-deo.htmlsi=6KZRETviEsVG-mS5 Cheres!

  • @santiagobardelli5675
    @santiagobardelli5675 2 місяці тому

    me suscribi, sos un grande!