![Nestor Adrianzen](/img/default-banner.jpg)
- 216
- 2 392 107
Nestor Adrianzen
United States
Приєднався 22 лип 2019
Are you ready to take your Power BI skills to the next level? You might have noticed that there are plenty of free Power BI tutorials on the internet. But it is sometimes time-consuming to find the right lessons. For that reason, I decided to create Quipu Analytics with a unique theory-practice approach. To succeed in Power BI, theory and practice should go together.
With Quipu Analytics, I offer tutorials, tips, and best practices to surprise anyone with your Power BI skills. Among the topics, I cover data modeling, DAX formulas, interactive dashboards, and data connectivity. In addition, I have interviews with professionals in the business intelligence world. Finally, once in a while, I also share Tableau and Excel tips.
Ready to start unlocking the power of Power BI? Subscribe to my UA-cam channel! ▶️www.youtube.com/@NestorAdrianzen
💻Check out my course on Udemy ▶️Microsoft Power BI Desktop Basics: Learn the Fundamentals
Sincerely,
Nestor Adrianzen
With Quipu Analytics, I offer tutorials, tips, and best practices to surprise anyone with your Power BI skills. Among the topics, I cover data modeling, DAX formulas, interactive dashboards, and data connectivity. In addition, I have interviews with professionals in the business intelligence world. Finally, once in a while, I also share Tableau and Excel tips.
Ready to start unlocking the power of Power BI? Subscribe to my UA-cam channel! ▶️www.youtube.com/@NestorAdrianzen
💻Check out my course on Udemy ▶️Microsoft Power BI Desktop Basics: Learn the Fundamentals
Sincerely,
Nestor Adrianzen
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
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
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]
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
❤❤❤thanks so much
Glad you found this tutorial helpful. Cheers!
Our dear professor, can you send the equation as the video is not clear to me? Thank you❤
Our dear professor, can you send the equation as the video is not clear to me? Thank you❤
Creating new table- 8:06
Excellent! Thanks for stopping by.
The first tab is "All" which means everyone has access to the report
ho we can rercord audio with navigation. when i record ausio of dashboard in power point the page of my report does not navigate
Underrated channel. More videos like this and more background design please❤
I appreciate your support. Keep it up 👍
Subscribed! Had to review this video for me to fix some errors. My bookmark came in handy...
Glad to hear it was helpful.
You have good explanation but I told you that I face some problems with buttons since 3 days you not answer me
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
@@NestorAdrianzen Thank you for your kindness i will provide it very soon
@@NestorAdrianzen I sent you an email thank you my brother
Thanks for your time
Thanks for stopping by. Cheers
this video will probably help me in my test
Glad to hear that. Cheers!
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
Thanks for your support. I think you are looking for the canva dimensions. Check them out here 👉 drive.google.com/file/d/1ZKy6mBsH66uQqlwSiX20Eb7uXWjJpqgS/view
Bonjour Merci pour cette vidéo très intéressante. bravo😉
Cheers!👍
That's really cool. Thank you so much
Thanks for stopping by!
nice video please could you please send me the data file
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
"Thanks for the helpful video."
Glad to hear that. Cheers!
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?
are you ecuadorian?
Thanks for stopping by. Please check out my website for more details about my ancestors and my company. quipuanalytics.com
@@NestorAdrianzen My last name is Nunez- Quispe. I also share similar ancestry with my family coming from Ecuador and Peru with Inca Origins
genial, tan claro. Te lo agradezco mucho
Excelente. Gracias por revisar el contenido
@@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
Thank You Nestor this what i need. :)
Glad to hear that. Cheers!
Thanks Nestor...This is exactly what I needed for duration values for call records. CHEERS!!!
Glad to hear that. Cheers!
Muchas gracias! Un consulta, si quiero comparar por semanas, como hago?
Puedes usar DAY como el intervalo y -7 como el número de intervalos.
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.
you can change the order of the pages by going in that particular report
Muchas gracias por esta master class mi estimado ,saludos desde Panamá
Gracias por revisar el contenido, Manuel!
Hi, i have a question, In Bravo calendar, the week number number column is present??
Yes, it should be there. You need to unhide it. Select Table View > Select Date table > Unhide Day of Week Number
Fabulous 👍
Glad to hear that. Cheers!
Espectacular Nestor, saludo desde México
Excelente. Saludos 👍
Fantastic
Glad to hear that. Cheers!
Up to the mark, Bravo 💪👌👍
Cheers!
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 👇
How can we use NETWORKDAYS formula for Averagex and sumx and working hour should count only with in UK time of 8Am - 5Pm
Please can you help me on this?
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?
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
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
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
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?
Loud and Clear 👍. Valuable Tutorial.
Glad it was helpful!
Superb😁
Glad to hear that!
👌👍
Cheers!
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
Excelente, Adolfo. Saludos👍
Amazing tutorial. The best one so far 👌🙏👌
Happy to hear that!
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". 😅
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
Could you please share the file so we could follow along?
Here you go: drive.google.com/drive/folders/1P0lZZ0K5TtId1KZmsr7t1x6TSUFMg-xO
@@NestorAdrianzen Thank you!
Super Amazing show, bro.
Cheers!
Marco the Dax Legend
You bet!
How often do you use Bravo or DAX Studio to optimize your Power BI reports? Leave your comments below👇
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.
Glad to hear that. Cheers!
Superb 👌
Thank you! Cheers!
Excelente video, todo muy gradual como debe ser
Excelente. Saludos 👍
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
For YoY Growth % calculations, please reference this tutorial. ua-cam.com/video/6vJIAJNTdG0/v-deo.htmlsi=6KZRETviEsVG-mS5 Cheres!
me suscribi, sos un grande!
Excelente. Saludos!