SSBI Central
SSBI Central
  • Видео 62
  • Просмотров 33 410
Rele practici în Excel și cum să le evităm (Part 2) | Romulus Milea
Speaker: Romulus Milea
Recording Date: Thu, Nov 24th 2024
Language: ROMANIAN
===============================================================
Description:
Destul de mulți utilizatori Excel practică fără să își dea seama diverse stiluri de lucru care mai devreme sau mai târziu își vor arăta dezavantajele.
Dacă găsim peste tot cursuri și sfaturi despre bunele practici, de data aceasta încercăm să scoatem la iveală într-o manieră amuzantă cele mai importante practici rele în Excel și cum să facem să scăpăm de ele.
Sunați-vă vecinii, colegii și dușmanii, că nu aveți cum să ratați așa ceva ! Unde mai pui că va rămâne înregistrată pe You Tube, pentru veșnicie :-))).
Partea 1 poate fi vizionata aici: ruc...
Просмотров: 51

Видео

Branching in Fabric and Power BI | Mathias Thierbach
Просмотров 243Месяц назад
Speaker: Mathias Thierbach Recording Date: Tue, Oct 22nd 2024 Language: ENGLIGH 🗃️ Session Slide Deck: github.com/cristiangyal/ROPUG_Files Description: In this session, we’ll explore the powerful concept of Git branching and how it can elevate your development processes within Microsoft Fabric and Power BI projects. We'll start by introducing the fundamentals of Git branching, highlighting how ...
Dynamic format strings and conditional formatting in Power BI | Antony Catella
Просмотров 2462 месяца назад
Speaker: Antony Catella Recording Date: Thu, Sep 19th 2024 Language: ENGLIGH Session files: github.com/cristiangyal/ROPUG_Files Description: In general formatting of visuals in a Power BI report are fixed for the end user. How can we give end users more flexibility to format the visuals for their requirements? In this presentation, we look at making use of dynamic format strings and conditional...
Join RomanianDATA Tribe | Sergiu Rotaru and Claudiu Anghelescu
Просмотров 402 месяца назад
Speakers: SERGIU ROTARU and CLAUDIU ANGHELESCU Recording Date: Thu, Sep 12th 2024 Language: ROMANIAN ⚠️ Description: Discover the community/tribe that wants to improve the data visualization literacy in Romania through monthly challenges. At the end of the Meetup we had have a Raffle with prizes offered by ETA2U: 1 FREE Voucher for a Data Related Training Live with ETA2U for one lucky winner fr...
From Imagination to Reality: Craft Any KPI in PowerBI with Powerviz KPI Visual | Lakshmi Ponnurasan
Просмотров 1522 месяца назад
Speaker: Santhana Lakshmi Ponnurasan Recording Date: Thu, Aug 29th 2024 Language: ENGLISH Description: Join me for a fun and interactive session where we'll dive into the incredible world of the KPI Visual, a custom Power BI visual by Powerviz that can turn any KPI idea you have into a stunning, functional visual. Whether you want to track performance, measure success, or visualize trends, the ...
Why and How to Consider Design When Crafting a Dashboard | Diana Maier
Просмотров 1853 месяца назад
Speaker: DIANA MAIER Recording Date: Thu, Aug 8th 2024 Language: ROMANIAN ⚠️ Session Slides: github.com/cristiangyal/ROPUG_Files Discover why thoughtful design is essential for creating effective dashboards that enhance user experience, improve comprehension, and increase engagement. We’ll explore key design principles and practical tips to help both designers and data professionals elevate the...
Adding custom totals to your tables with Calculation Groups | Bernat Agulló
Просмотров 2814 месяца назад
Speaker: Bernat Agulló Recording Date: Thu, Jul 25th 2024 Language: ENGLIGH Description: Sometimes we might get the following request: I want to see the sales by month and at the end I want to see the total for the year, but also the average sales per month, the sales from previous year and the absolute and percentual change vs previous year. This is not straight forward in Power BI but Calcula...
Power BI Best Practices (Part 1) | Denis FĂRÎMĂ
Просмотров 2074 месяца назад
Speaker: DENIS FĂRÎMĂ Recording Date: Wed, Jul 10th 2024 Language: ROMANIAN ⚠️ Session_Files: github.com/cristiangyal/ROPUG_Files Description: In this session we will discuss how to build maintainable and scalable solutions with Microsoft PowerBI. At the end of the Meetup we had have a Raffle with prizes offered by ETA2U: 1 FREE Voucher for a Data Related Training Live with ETA2U for one lucky ...
The Excel and Power BI user's guide to ChatGPT | Wyn Hopkins
Просмотров 3564 месяца назад
Speaker: Wyn Hopkins Recording Date: Thu, Jun 27th 2024 Language: ENGLISH Description: How can Chat GPT help you create better reports quicker? Wyn has created a number of GPTs that are available from the Chat GPT store including a Power Query Magician, A DAX helper, a Visualization expert and and Excel formula helper. Wyn will talk you through how they were created and demonstrate how they hel...
Oncoming features for Core Visuals in Power BI | Miguel Myers
Просмотров 1,1 тыс.5 месяцев назад
Speaker: Miguel Myers Recording Date: Thu, May 30th 2024 Language: ENGLIGH Description: Join Miguel Myers, a visionary in the Power BI landscape, as he unveils the roadmap to revolutionary features set to transform your data experience. In this exclusive session, Miguel will share a first glimpse into the innovative capabilities our team is crafting for the months ahead. Seize this rare chance ...
Top 3 life changing reports in Excel | Mihaela Stancu
Просмотров 2365 месяцев назад
Speaker: Mihaela Stancu Recording Date: Thu, Jun 13th 2024 Language: ROMANIAN ⚠️ Session working files: github.com/cristiangyal/ROPUG_Files Description: When you have lots of data coming your way, you might find it impossible to approach just the one you actually need, in order to work more efficiently. But wait, this is not the complete story: once you get the right data, how can you make sure...
Power Up Your Data: Synergizing Power BI & Power Apps | Cristian Prifti
Просмотров 1106 месяцев назад
Speaker: Cristian Prifti Recording Date: Thu, May 9th 2024 Language: ROMANIAN ⚠️ Description: 🌟 Empower Your Apps and Analytics: Integrating Power BI with Power Apps 🌟 Join us for an electrifying session where we explore the dual power of Power BI and Power Apps! Learn how to not only embed detailed Power BI dashboards into Power Apps for dynamic data insights but also enhance Power BI reports ...
Rele practici în Excel și cum să le evităm| Romulus Milea
Просмотров 2486 месяцев назад
Speaker: Romulus Milea Recording Date: Wed, Apr 24th 2024 Language: ROMANIAN File for practice here: github.com/cristiangyal/ROPUG_Files Description: Destul de mulți utilizatori Excel practică fără să își dea seama diverse stiluri de lucru care mai devreme sau mai târziu își vor arăta dezavantajele. Dacă găsim peste tot cursuri și sfaturi despre bunele practici, de data aceasta încercăm să scoa...
Visual Calculations - Making DAX easier | Jeroen (Jay) ter Heerdt
Просмотров 2017 месяцев назад
Speaker: Jeroen (Jay) ter Heerdt Recording Date: Thu, Apr 11th 2024 Language: ENGLIGH Description: This is it. The day that the way that DAX became easier. After this, how you write DAX changes forever. Learn all about it in this session! The Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calc...
Understanding the External Tools ecosystem: Tabular Editor | Daniel Otykier
Просмотров 1207 месяцев назад
Speaker: Daniel Otykier Recording Date: Wed, Nov 29th 2023 Language: ENGLIGH Description: If you’re a Power BI developer you’ve probably heard about External Tools, and you may already be using a few of them in your daily work. In this session, we’ll provide a brief overview of the most popular tools available today, before diving deeply into one of them; Tabular Editor - a free, open-source to...
Data Visualization Techniques for Effective Dashboard Creation | Gustaw Dudek
Просмотров 6 тыс.7 месяцев назад
Data Visualization Techniques for Effective Dashboard Creation | Gustaw Dudek
Power BI Dataset & Power Automate Magic | Cristian Prifti
Просмотров 2577 месяцев назад
Power BI Dataset & Power Automate Magic | Cristian Prifti
Power Up Your Excel: Unlocking the Magic of Power Pivot | Cristian Angyal
Просмотров 3738 месяцев назад
Power Up Your Excel: Unlocking the Magic of Power Pivot | Cristian Angyal
Webinar OnLearn - De la Excel la Power BI | Radu Popa & Cristian Angyal
Просмотров 1328 месяцев назад
Webinar OnLearn - De la Excel la Power BI | Radu Popa & Cristian Angyal
3 Things Every Power Query User Should Know | Gašper Kamenšek
Просмотров 6758 месяцев назад
3 Things Every Power Query User Should Know | Gašper Kamenšek
Data summaries in Excel: Pivot and Power Pivot | Radu Popa
Просмотров 2038 месяцев назад
Data summaries in Excel: Pivot and Power Pivot | Radu Popa
Power BI la Următorul Nivel: Magia Automatizării cu PowerShell | Ioana Bouariu
Просмотров 1398 месяцев назад
Power BI la Următorul Nivel: Magia Automatizării cu PowerShell | Ioana Bouariu
Microsoft Fabric's Gen 2 Dataflow - Where Even Data Gets a Standing Ovation | Parv Chana
Просмотров 758 месяцев назад
Microsoft Fabric's Gen 2 Dataflow - Where Even Data Gets a Standing Ovation | Parv Chana
Tips and Tricks in Modern Excel | Gabriel Cheva
Просмотров 2239 месяцев назад
Tips and Tricks in Modern Excel | Gabriel Cheva
Firul magic al narativității: Cum storytelling transformă designul | Alex Badiu
Просмотров 15910 месяцев назад
Firul magic al narativității: Cum storytelling transformă designul | Alex Badiu
Leveraging Field Parameters for Dynamic Data Visualization | Antony Catella
Просмотров 31211 месяцев назад
Leveraging Field Parameters for Dynamic Data Visualization | Antony Catella
Let's improve the Tabular Model by combining queries | Ana Maria Bisbe York
Просмотров 171Год назад
Let's improve the Tabular Model by combining queries | Ana Maria Bisbe York
Smart work with Dynamic Arrays in Excel | Victor Momoh
Просмотров 399Год назад
Smart work with Dynamic Arrays in Excel | Victor Momoh
Advanced Power Query for Business Analysis | Viorel Cazacu
Просмотров 433Год назад
Advanced Power Query for Business Analysis | Viorel Cazacu
Analytics Godzilla - Combining Power BI, R, and ChatGPT Code Interpreter | Brian Julius
Просмотров 726Год назад
Analytics Godzilla - Combining Power BI, R, and ChatGPT Code Interpreter | Brian Julius

Комментарии

  • @AgulloBernat
    @AgulloBernat 12 дней назад

    this is awesome!

  • @AA-kq8on
    @AA-kq8on Месяц назад

    thank's

  • @davidjosevarelagarcia7011
    @davidjosevarelagarcia7011 Месяц назад

    Great Video, i have a question, In the text field, to place the title, you can make it dynamic, in which it changes based on a selected month or year and says sales as of Feb/24 $222k, to give an example and so it changes according to what you select ?

  • @MrKhulaid
    @MrKhulaid Месяц назад

    This was amazing. God bless you brother.

  • @user-data_junkie
    @user-data_junkie 2 месяца назад

    I’m halfway through this video and I absolutely love it!! Formatting is probably something I’ve spent too long on in my report designs. Well done to a fellow South African 🇿🇦

  • @birasafabrice
    @birasafabrice 2 месяца назад

    great, thank you!

  • @carloscantu75
    @carloscantu75 3 месяца назад

    Very interesting, thanks for sharing!

  • @massimocolaceci
    @massimocolaceci 3 месяца назад

    Thank you for such a masterclass

  • @user-data_junkie
    @user-data_junkie 3 месяца назад

    I love it how Miguel knows the finest details of his work. How he stops to think about a question, and then go right into the nuts and bolts of it. Talking about love, our baby is getting pimped in the future 😂, wow!! Out of the box things will replace the things that now takes us multiple measures and long DAX and workarounds to implement. Wonder what the sophisticated workarounds then will look like❤❤❤❤ Thanks for the podcast!

  • @mrbartuss1
    @mrbartuss1 4 месяца назад

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

  • @chahineatallah2636
    @chahineatallah2636 4 месяца назад

    I liked the golden rule "dont trust chat gpt " always validate results

  • @Fernando_Calero
    @Fernando_Calero 4 месяца назад

    Q: What do you do for a living? A: I'm a New Card visual developer I actually started using it and it's not that hard and the result is great!

  • @cristiantilihoi2591
    @cristiantilihoi2591 5 месяцев назад

    Buna Mihaela. Foarte interesanta sesiune. Te mai asteptam cu alte exemple intainite in practica. Ne usureaza munca de zi cu zi, ne salveaza timpul, nu mai muncim ca "maimutele". In legatura cu importul de cursuri valutare, am realizat si eu o mica apliactie in Power BI, ce se actualizeaza automat, o singura data pe zi, in care prezint cursul valutar utilizat la facturare in paralel cu cursul publicat da BNR

    • @DataManagementRO
      @DataManagementRO 4 месяца назад

      Multumesc frumos! Imi cer scuze, abia acum am vazut comentariul tau, din pacate n-am activat cum trebuie notificarile :( Suna interesant aplicatia ta!

  • @mrbartuss1
    @mrbartuss1 5 месяцев назад

    What's the purpose of creating 'Base'? Couldn't we simply refer to 'Source' in the following steps?

  • @Giridharan952
    @Giridharan952 5 месяцев назад

    Bharath Matha KI Jai........Jai bholo ElectionCommision.....for the entire team who worked tirelessly ....

  • @victorionescu7653
    @victorionescu7653 6 месяцев назад

    Congrats Cristi&Cristi! 👏👏👏

  • @AdiCristea
    @AdiCristea 7 месяцев назад

    This was an excellent session, glad is on RUclips now so we can go through it whenever is needed. Thank you, Jay (and both Cristi)!

  • @NikolaosMantas-ft9lg
    @NikolaosMantas-ft9lg 7 месяцев назад

    Thanks. what level is the presentation aimed at?

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20 7 месяцев назад

    NICE. Please share data file for practice

  • @wwpharmacist
    @wwpharmacist 7 месяцев назад

    Thanks

  • @serban2743
    @serban2743 7 месяцев назад

    thanks for uploading it so soon! unfortunately I missed the live event

  • @GrainneDuggan_Excel
    @GrainneDuggan_Excel 8 месяцев назад

    You can always count on Gašper Kamenšek to make difficult concepts easier to understand. Thanks Gašper and Cristian!

  • @KMF7955
    @KMF7955 8 месяцев назад

    Really appreciate you posting this video!

  • @josephansah
    @josephansah 8 месяцев назад

    Thank you for recording and sharing this very practical session. It's very helpful to have the very brilliant Gustaw expand a bit more of his process, thoughts & tricks via video format.

    • @SSBICentral
      @SSBICentral 8 месяцев назад

      You are welcome @josephanash. The file used is also available here: github.com/cristiangyal/ROPUG_Files

    • @AltPacino
      @AltPacino 6 месяцев назад

      @@SSBICentral Thank you very much for facilitating this fantastic session with Gustaw. Did Gustaw shared this report with you as pbix?

  • @richardmensah3327
    @richardmensah3327 8 месяцев назад

    sorry ,I dont understand your language

  • @AdiCristea
    @AdiCristea 8 месяцев назад

    Was looking for this, thank you! :)

  • @svenh5752
    @svenh5752 8 месяцев назад

    A very rewarding video. Unfortunately, it seems that authorization is required to download the Excel workbook.

  • @usmaniqbal1836
    @usmaniqbal1836 8 месяцев назад

    Please share data file for practice

  • @emmettokuneva
    @emmettokuneva 8 месяцев назад

    😈 "promosm"

  • @usmaniqbal1836
    @usmaniqbal1836 9 месяцев назад

    Please share data file for practice

  • @Mohamed.GadAllah
    @Mohamed.GadAllah 11 месяцев назад

    Thanks :)

  • @Henrik.Vestergaard
    @Henrik.Vestergaard 11 месяцев назад

    Great session 👍 Hope it will easy my comming pain ....

  • @Milhouse77BS
    @Milhouse77BS Год назад

    Thanks! A good example for full refresh. Incremental Refresh might be more difficult? Say, if the Product keys change for Products in past. But now that I watch to the end, the keys with meaning might fix that.

  • @romulusmilea2747
    @romulusmilea2747 Год назад

    Domnul Petculescu este foarte modest, dar trebuie să știți că dânsul este arhitectul șef pentru Power BI. Din punctul meu de vedere, dânsul este unul dintre românii cu care trebuie să ne mândrim, fructul inteligenței și muncii sale de atâția ani este folosit de zeci de milioane de oameni la nivel mondial !

  • @keylanoslokj1806
    @keylanoslokj1806 Год назад

    Would be great if you also gave the solutions for older excel version

  • @sue_bayes
    @sue_bayes Год назад

    This is pure gold dust!! Inspiring talk and session from Brian hosted by ROPUG.

  • @markp8600
    @markp8600 Год назад

    Hi Cristian, Thank you for the weblink - I was on with Mark Proctor for Office Hours. I am grateful for your willingness to share these trainings with the global community! Mark P. USA

  • @AdiCristea
    @AdiCristea Год назад

    Ce rău îmi pare că nu am ajuns, chiar mi-ar fi plăcut, mulțumesc că ai urcat repede video pe YT̀! Felicitări, Cristi x2 și Teodora!!

  • @markp8600
    @markp8600 Год назад

    Cristian, do you have the sample worksheets available to reproduce while watching this webinar? It would be very helpful to see the work "right in front of me" while learning the processes you are teaching in the webinar. Thank you. Mark P. Minnesota, USA

  • @martyc5674
    @martyc5674 Год назад

    Great Topic, thanks Alan and Cristian 👍

  • @loose.electricity
    @loose.electricity Год назад

    Fantastic video, thanks for making this available!

  • @vashisht1
    @vashisht1 Год назад

    Awesome Cristian....

  • @mihaizamfirescu5357
    @mihaizamfirescu5357 Год назад

    Hi Cristi, you forgot to check for duplications of form's submission for increase of chances! 😀 You know that the people are resourceful! 🤣😂🤣

  • @llau0203
    @llau0203 2 года назад

    Hi Melissa, Thank you for showing different ways of doing transformation. For the UI method, the logic of using Index and Divide (Integer) will not work if there is missing data. For example, the sample data contains the missing data (Number of Employee) on Dec 28, 2015. In that case, the Number of Employee will be shifted due to the missing Number of Employee data. This is just my observation. Thanks

  • @kebincui
    @kebincui 2 года назад

    Excellent tutorial. Thanks Christian and Power Query queen Lelissa 👍.

  • @qasimjan5258
    @qasimjan5258 2 года назад

    Amazing session Melissa.

  • @chahineatallah2636
    @chahineatallah2636 2 года назад

    Great video, I have a question why it gave an error for customer during rename process? Although customer was in “rename” query ? Is it a bug? 🤨

  • @jeffreyfitzgerald4673
    @jeffreyfitzgerald4673 2 года назад

    ᑭяỖmo𝓼𝐦 ✌️

  • @constantinrusencu3534
    @constantinrusencu3534 2 года назад

    The dataflow/dataset refresh is quite restrictive because it counts against the number of refreshes. I say from my perspective as a Pro licence user where 8 refreshes don't give much choice for the use to do their own, especially if there are some scheduled ones.

  • @jorstube
    @jorstube 2 года назад

    amazing Chandeep!!!!