![From Zero2BI Hero with Stelian](/img/default-banner.jpg)
- 31
- 24 010
From Zero2BI Hero with Stelian
United Kingdom
Приєднався 3 гру 2023
I will help you learn Power BI and share my experience gained in years of trial end error.
We will provide you with all the tools and tutorials you need to get from beginner to pro.
From Zero2BI Hero is your go-to destination for everything related to business intelligence. Whether you're just starting your BI adventure or looking to elevate your skills, this channel is designed to empower you with practical insights and step-by-step tutorials. Together, we'll unravel the mysteries of data analysis and reporting.
This channel is more than just videos. It's a community of BI enthusiasts supporting each other on their journey to hero status. Share your insights, ask questions, and connect with like-minded learners in the comments section.
Hit that subscribe button and ring the notification bell to stay updated on the latest Zero2BI Hero content.
🚀 Stelian Your BI Guide
We will provide you with all the tools and tutorials you need to get from beginner to pro.
From Zero2BI Hero is your go-to destination for everything related to business intelligence. Whether you're just starting your BI adventure or looking to elevate your skills, this channel is designed to empower you with practical insights and step-by-step tutorials. Together, we'll unravel the mysteries of data analysis and reporting.
This channel is more than just videos. It's a community of BI enthusiasts supporting each other on their journey to hero status. Share your insights, ask questions, and connect with like-minded learners in the comments section.
Hit that subscribe button and ring the notification bell to stay updated on the latest Zero2BI Hero content.
🚀 Stelian Your BI Guide
The DAX measures behind a SUPERCHARGED KPI Card in Power BI!
I’m sharing with you the exact measures used to create the KPI Card from the video below.
Watch next: Power BI Card Visual : ua-cam.com/video/_cHeyVKBRro/v-deo.html
Supercharge you line charts in Power BI: ua-cam.com/video/b7ULi7B4Q6s/v-deo.html
How to create backgrounds in Power Point: ua-cam.com/video/aU5aU5tlA_0/v-deo.html
🎨 Discover the measures required to elevate your KPI cards.
Update the Card Title, add reference labels, and mastering design options like a PRO! All these are only possible because of the DAX measures that you will discover in this video.
👍 Thank you for watching! If you found this video helpful or insightful, don't forget to like, comment, and subscribe! Your support means the world. Ready to explore the full potential of Power BI? Remember, you're awesome-catch you later! 🌟 #PowerBI #BIforBeginners #DataMagic #TechTutorial
Watch next: Power BI Card Visual : ua-cam.com/video/_cHeyVKBRro/v-deo.html
Supercharge you line charts in Power BI: ua-cam.com/video/b7ULi7B4Q6s/v-deo.html
How to create backgrounds in Power Point: ua-cam.com/video/aU5aU5tlA_0/v-deo.html
🎨 Discover the measures required to elevate your KPI cards.
Update the Card Title, add reference labels, and mastering design options like a PRO! All these are only possible because of the DAX measures that you will discover in this video.
👍 Thank you for watching! If you found this video helpful or insightful, don't forget to like, comment, and subscribe! Your support means the world. Ready to explore the full potential of Power BI? Remember, you're awesome-catch you later! 🌟 #PowerBI #BIforBeginners #DataMagic #TechTutorial
Переглядів: 119
Відео
The choice that can MAKE or BREAK your data model in Power BI!
Переглядів 28114 днів тому
Learn the difference between normalization and denormalization, when it comes to data modeling in Power BI. Watch next: Best Practices in Data Modeling: ua-cam.com/video/-8L8UsLKoR0/v-deo.html How to choose your data model: ua-cam.com/video/90n0mZt3iR8/v-deo.html Excel file to Power BI data model: ua-cam.com/video/-rIAfuayCxU/v-deo.html After being around data, in one way or another, for more t...
Pros and Cons of Star Schema in Power BI! Plus Best Practices.
Переглядів 340Місяць тому
In this tutorial about Star Schema in Power BI I will tell all there is to know about the best data model in Power BI. Watch next: Data modeling best practices - ua-cam.com/video/-8L8UsLKoR0/v-deo.html How I choose my data models - ua-cam.com/video/90n0mZt3iR8/v-deo.html Excel File to Data Model: ua-cam.com/video/-rIAfuayCxU/v-deo.html When it comes to data modeling in Power BI, the best data m...
I tested 3 data data models in Power BI and.... 😮
Переглядів 864Місяць тому
I've tested the 3 main Power BI Data Models against each other: Star Schema, Snowflake Schema and Flat File with unexpected results. Watch next: Data modeling best practices - ua-cam.com/video/-8L8UsLKoR0/v-deo.html How I choose my data models - ua-cam.com/video/90n0mZt3iR8/v-deo.html Understanding Star Schema in Power BI: Understanting Star Schema in Power BI: ua-cam.com/video/DOihCzLsPts/v-de...
STOP Ruining your data model. DO THIS instead!
Переглядів 1,6 тис.Місяць тому
In this Power BI Tutorial we will talk about the best practices when it comes to data modeling in Power BI. Watch next: Understanting Star Schema in Power BI: ua-cam.com/video/DOihCzLsPts/v-deo.html Excel File to Data Model: ua-cam.com/video/-rIAfuayCxU/v-deo.html Access Data Base to Data Model: ua-cam.com/video/x7rmdHcrYXU/v-deo.html After being around data, in one way or another, for more tha...
The ONE KPI that you're not using, BUT you should!
Переглядів 939Місяць тому
In this Power BI Tutorial I will reveal The ONE KPI nobody is talking about. Be one of the 1% Data Analyst that are using it. Watch next: Upgrade Your Line Charts - ua-cam.com/video/b7ULi7B4Q6s/v-deo.html Supercharge the KPI Cards - ua-cam.com/video/_cHeyVKBRro/v-deo.html Data set: fromzero2bihero.ck.page/26d7ecedbf This KPI is one of the most relied-upon metrics in marketing, offering a compre...
This is how I create reports background in Power Point. Time - Lapse.
Переглядів 3532 місяці тому
Learn how to design Power BI dashboard or report in Power Point. How to use this template: ua-cam.com/video/V8cvDGIadf4/v-deo.html Download the SVG file: fromzero2bihero.ck.page/f645fa7b68 From the series: 2024 UPGRADE the Power BI Line Chart! ua-cam.com/video/b7ULi7B4Q6s/v-deo.html DYNAMIC Reference Labels for the New Card Visual Power BI! ua-cam.com/video/_cHeyVKBRro/v-deo.html Power BI for B...
You Asked, I Answered. Power BI Tips and Tricks E.01.
Переглядів 1992 місяці тому
In this Power Query Tutorial for Beginners I’ll answer this question: Should you use DUPLICATE or REFERENCE when you created Dimension Tables? Report Backgound Giveaway: fromzero2bihero.ck.page/f645fa7b68 Watch next: Quick and Easy: Excel Table to Power BI Data Model. File included -ua-cam.com/video/-rIAfuayCxU/v-deo.html Power BI Data Model Selection Simplified. - ua-cam.com/video/90n0mZt3iR8/...
BIG Impact WITH Small Changes. Change the Story of a Power BI Report!
Переглядів 2072 місяці тому
These Power BI Dashboard examples will show you how a few small changes can change the data story you want to tell. THE SURPRISE: fromzero2bihero.ck.page/f645fa7b68 Watch next: 2024 UPGRADE the Power BI Line Chart! ua-cam.com/video/b7ULi7B4Q6s/v-deo.html DYNAMIC Reference Labels for the New Card Visual Power BI! ua-cam.com/video/_cHeyVKBRro/v-deo.html Power BI for Beginners Playlist - ua-cam.co...
SUPERCHARGED Power BI Line Chart with Dynamic Markers and Titles
Переглядів 4273 місяці тому
In this Power BI Tutorial for Beginners you will learn how to create a One of a Kind line chart with DAX measures included. Data set: fromzero2bihero.ck.page/26d7ecedbf Watch next: The One KPI You Are not Using - ua-cam.com/video/LUJRzJgouBc/v-deo.html 3 Report Redesigns to Tell Different Stories in Power BI - ua-cam.com/video/V8cvDGIadf4/v-deo.html Power BI for Beginners Playlist - ua-cam.com/...
Power BI Data Modeling Project FROM Excel File (Dataset included)
Переглядів 6 тис.3 місяці тому
In this Power BI Tutorial for Beginners, you will learn how to create a Power BI Data Model from an Excel flat file in no time. Power BI Data Modelling has never been easier. Data set: fromzero2bihero.ck.page/dc4ab94aa6 Watch next: Data Modeling Best Practices: ua-cam.com/video/-8L8UsLKoR0/v-deo.html Power BI Data Model Selection Simplified. - ua-cam.com/video/90n0mZt3iR8/v-deo.html Behind the ...
SIMPLE Technique for Choosing the Ideal Power BI Data Model
Переглядів 3,1 тис.4 місяці тому
In this Power BI Tutorial for Beginners, you will get all the information you need to choose which data model fits you best! Watch next: Data Modeling Best Practices: Data Modeling Best Practices: ua-cam.com/video/-8L8UsLKoR0/v-deo.html From Excel to Power Bi Data Model - ua-cam.com/video/-rIAfuayCxU/v-deo.html Complete Data Cleaning Project in Power BI! - ua-cam.com/video/x7rmdHcrYXU/v-deo.htm...
Time Intelligence in Power BI: Filter by Period like a PRO!
Переглядів 3734 місяці тому
This Power BI DAX tutorial on Time Intelligence in Power BI is about how to filter by dates! Watch next: How to avoid Blank results in a Total to Date calculation! 🤔 - ua-cam.com/video/cNUj8u07Ndk/v-deo.html Time Intelligence in Power BI! Tutorial for Beginners! - ua-cam.com/video/4EBZ5yfHLlw/v-deo.html DAX Tutorial for Beginners: Dynamic Measure Switching! - ua-cam.com/video/X60TmRcOD50/v-deo....
Total to Date Calculations Examples. NO MORE Blank Results.
Переглядів 1215 місяців тому
This Power BI DAX tutorial is about how to properly use the Total to Date functions In Power BI! Watch next: Power BI DAX Tutorial: Dynamic Measure Switching!- ua-cam.com/video/X60TmRcOD50/v-deo.html Power BI DAX Tutorial: Time Intelligence in Power BI! - ua-cam.com/video/4EBZ5yfHLlw/v-deo.html Power BI DAX Tutorial: Aggregation Functions WITH Examples! - ua-cam.com/video/gJ7OeG9UE2Y/v-deo.html...
Time Intelligence in Power BI! Date Functions Basics!
Переглядів 945 місяців тому
Time Intelligence in Power BI! Date Functions Basics!
How to create a slicer to select measures in Power BI Desktop.
Переглядів 1745 місяців тому
How to create a slicer to select measures in Power BI Desktop.
Turning Multiple Column Groups into Rows with Power Query Magic!
Переглядів 1,5 тис.5 місяців тому
Turning Multiple Column Groups into Rows with Power Query Magic!
DAX in Power BI: Aggregation Functions WITH Examples!
Переглядів 2006 місяців тому
DAX in Power BI: Aggregation Functions WITH Examples!
MASTER Power Query ESSENTIALS with These 10 Tools!
Переглядів 7036 місяців тому
MASTER Power Query ESSENTIALS with These 10 Tools!
Power BI Date Table 4 Ways. Beginner to Expert!
Переглядів 3426 місяців тому
Power BI Date Table 4 Ways. Beginner to Expert!
DYNAMIC Reference Labels for the New Card Visual Power BI!
Переглядів 1,2 тис.6 місяців тому
DYNAMIC Reference Labels for the New Card Visual Power BI!
FULL Power BI Data Modeling Process (Dataset included)
Переглядів 2,1 тис.7 місяців тому
FULL Power BI Data Modeling Process (Dataset included)
How to Create a Report as Beginner in Power BI! Drag and Drop only! 2024
Переглядів 2637 місяців тому
How to Create a Report as Beginner in Power BI! Drag and Drop only! 2024
What is Power BI and Why to Use it in 2024!
Переглядів 1168 місяців тому
What is Power BI and Why to Use it in 2024!
Got the data from the link but where are the predefined measures? and how to get those ?
A quick video with all the measures should be live tomorrow morning. Here is a link: ua-cam.com/video/oYFJQJ1p4fo/v-deo.html
Can you add sparkline plus py sales and percentage with indicators in color codes in a single kpi card please
Hello, I can certainly do that and funny enough, I've just used that on my last project. Give me a couple of day and I'll get the video made.
Amazing What is the measure for the bottom bit?
A quick video with all the measures should be live tomorrow morning. Here is a link: ua-cam.com/video/oYFJQJ1p4fo/v-deo.html
@@MMS-PowerBI Hi thank you for your replyl just tried acccessing the link and it says private
Sorry about that. The video is public now.
Thanks a lot for making that sorts of great content. Sir I have some questions to you . If you could clear me please what are the job responsibilities of a Power BI Developer and what skill set need to aquire if anyone wish to build his Career only as Power BI Developer .If you could tell a bit details kindly. Thanks & regards
Hi Syed. Let me first thank you for your kind words. It makes me really happy to hear that you found my videos useful. Now, I will end up doing a video like that, but I don't have a time line on that. I can though give you some information based on my experience and journey in the Power BI world, without pretending it will be the absolute truth :). Responsibies, or more like a system that I use: 1. Liase with the stakeholders to udnerstand the businisses requirements. (at this step I usually define the important KPIs and a rought structure of the report) 2. Data gathering and transformation (for me it mostly means writing SQL queries that I then import in Power BI). Since I write my custom queries the data transformation in Power BI is minimal for me. 3. Report development (writing DAX, creating visualisations, filters pages, etc.) 4. Data analysis (it is happening pretty much at the same time with the previous step as they are strongly related) 5. Report testing (this is the bit I give most of my time, because here is where I make sure that the reports are accurate, especially when I have to connect two different databases - SQL and Oracle in my case) 6. User training (I cannont expect that the final user will have my knowledge on Power BI and they do need all the help they can get. The whole point is for them to use the report, not just have it there for fun). 7. Support and Administration ( any suport reuqired from users and administration of the Power BI Wev service) Skills: 1. Data modelling (You need to understand very well a data model, how it works and how to use it. A good data model give you accurate information and excellent performance) 2. DAX and M language (This is another very important aspect. You need to understand the logic of DAX and how to build measure. The M language can be learned a bit later) 3. SQL (You don't need to be an expert. You could even get by without any knowledge, but I can guarantee it would help to be confident in SQL) 4. MS Office 365 (You will end up connecting your report in various way with all of the components of the MS Office and you need to have good knoledge of all) 5. Any other expierience in Azure, Power Pivot, Power Query, Data warehousing would be very beneficial. And of course you need the soft skills: communication, creativity, negotiation, critical and analytical thinking and so on. Bear in mind this list could go on, and on, but this it what I can think of based on my role and my experience.
@@MMS-PowerBI Thanks a lot for answering my enquiries , I really appreciate the way you describe everything. Once again many many thanks mate , cheers up.
Very Practical. So before we are told that it depends, from a practical point of view assuming the same data tables and same level of opmimization techniques employed for all the three, which one would you generally recommend.. Time is expensive so i would not not like to do thre designs test them and choose the best especially that as we increase the number of records results may be surprising..
For the company that I work for, I mostly have to go with a snowflake design just because of the sheer volume of data. If I would recommend any of them, it would be in this order: 1. Star Schema 2. Snowflake Schema 3. Flat File (for 1 page dashboard style, small dataset, and it's needed very, very quick without emphasis on accuracy)
@@MMS-PowerBI Thanks!! You knowledge of Data Modelling is TIP TOP!!
Your video is great, but your voice sometime it hard to hear
Thank you for the feedback. I am trying to improve on my editing skill and hopefully on the more recent videos thigs are better :)
i really like your video. it help me a lot ! Thank you!
You have just made my day . Thank you very much!
@@MMS-PowerBIYou're welcome. You deserve more subscribers.
Thank you! keep it coming!
I will do my best :)
Nice Content Stelian
Thank you very much. It makes me really happy to know that you enjoyed it.
Well done ! Very interesting results !
Yes, I was prepared for a different set of results, at least on the bigger file, but sometimes what we believe to be true might not be.
And How would you merge several columns without merging the rows?
Hi Alana, Am I correct to assume that you want to concatenate multiple columns in one? Because in that case all you need to do is merge colums. (like I did in the video at 01:00) But I have the feeling that this is not you desired result. Please let me know what is the desired result and I'll be more than happy to help.
@@MMS-PowerBI thank you so much. i wish i could show you an image i have a table with several columns that contain the same type of information. I want to merge all columns in one but without merging rows, keeping them individual. When i merge columns, each row from all columns merges too, and i want to keep each row individual. Let's say stacked instead of merged all together. My final objective is to be able to do group by count and get how many records of each distinct type i have, but if i merge columns it doesn't leave the rows individual and it can not count properly.
I apologize for the late response. Unfortunately this option is not available in Power Query/Power BI. If you have a Linked In account please send me a message with a couple of pictures of a mock up table and the expected result and I might be able to give you another solution. www.linkedin.com/in/marin-stelian-manolescu
Very insightful and useful info. Thanks for sharing❤
Thank you very much!
C'est quoi BI?
Business intelligence (BI) is a technology-driven process for analyzing data and delivering actionable information that helps executives, managers, and workers make informed business decisions.
@@MMS-PowerBI thank you so much 🙏
You're welcome. I'm happy to help 😀
@@MMS-PowerBI and Im happy to be your first Moroccan subscriber 😊
can you send a datasets!!!!
Hello, Here is a link from where you can download the MS Access database: fromzero2bihero.ck.page/26d7ecedbf I hope you enjoyed the tutorial 😀
Thank you, Stelian. This is really useful. I often work with huge files with 5m rows - download.companieshouse.gov.uk/en_output.html, but I rarely get a file with values together with their ID. This file has several of those - Company name and ID, Position and ID, Department and ID. etc. Why not just remove all the ID columns and work with a single Fact Table?? What am I missing here??? Thanks again.
Hi Robert, The name of the game is performance. And here is how the type of data model might affect it: 1. The size of date model. The larger the size, the worse the performance becomes. It is a good practice for example that in the fact table to keep only events (dates, numbers) and NO descriptions. Just by splitting it into a fact table and dimensions table you could reduce the size of data model considerabely. 2. A flat file (normalized) might work if it has a low amount of rows. When you are talking about millions of rows, as soon as you DAX calculations will get a bit more complicated, the query response time will go through the roof. And we all know is nothing worse than waiting more than 2-3 seconds (and that's very generous) to have a report refreshed. I hope this helps you a little bit.
When creating a dimension table, can I use references instead of duplicates? What is the difference between the two methods?
In theory both duplicate and reference will give you a copy of the initial query, but.... There is a but :) With duplicate when you change/modify the initial query, the copy will not be affected. Whatever steps you make in the fact table, they will not be reflected in the dimension table. With reference on the other hand, any changes you make to the initial query will be reflected in the copy. For example, if you use reference to create the parts dimension and then in the fact table you remove the part description column, then the description column will be removed in the dimension table as well. I hope this answer you question. If if you have any more question please give me a shout. I'll be more than happy to help.
hello sir your content is really good please post a complete video in powerbi from intermidiate level to professional level including dax and other advance features ,it would be really helpful for us.❤❤
Hi there, Thank you for you wondeful comment. I have in plan to get a project through all the steps, from file to upload on the Power BI service, but I can't promise a date just yet. It will be something that most likely will be a couple hours long, and will have some interesting DAX measures.
Thanks ! snowflake is like several star scheme together.
Youre welcome. In theory snowflake schema can be denormalized into a star schema. But sometimes, if you have loads of data, it's advisable to normalize the star schema into a snoflake schema, depending on what type of granularity you need to achieve.
Thank you very much for the tutotrial. One of the first i don't have to accelerate X2 to follow :-). There's step I don't understand well is about value replacement. If you replace departement ID (so secondary key) how the ID HRFM, HRFH ... will link with the DimEmployee table, as the primary keys have not changed...
I am happy you found the tutorial useful and that it has the right speed. I try to stay more to the point, than go around the bushes for nor reason :). Now, related to you question, first of all well spotted. I have tried to add that step more like a how to do it. In real life this would create a blank result and all sort of issues. The solution is to make the replacements in the original table or file, before duplicating, and then both the employees table and the department id table would have the same IDs.
Excellent. Thanks.
You are welcome! I'm glad you liked it 😊!
Excellent instructions. Thanks🎉
I'm glad it was helpful! Thank you for watching, and I hope you'll enjoy more tutorials from me.
👍👍
Thank you!
Super 👍👍,thanks
Thank You! I am very happy that you enjoed it!
I love the tutorial, can you provide the datasets?
Thank you for watching. The data set download link was added to the description of the video.
Ye: thank you for this video. And I, too, would like to receive the data set. Thanks in advance.
Hello and Thank you for watching the video. The download link was added to the description of the video.
@@MMS-PowerBI THANK YOU !!!
Hi and Thank you, But can ytou share data sample for use according your tutorial?
Hello and Thank you for watching the video. The download link was added to the description of the video.
great tutorial, keep up the good work
Thank you. This is much appreciated 👏
Great video!
Thank you very much! I'm glad you enjoyed it 😊
Your introduction is awesome!
Thank you very much! I'm glad you like it!
cool
Thank you for your comment 😊. This example is just a tiny bit of what can be done. You can play with titles more and make them dynamic, use more reference labels, and so on. If there's something you'd like me to do, just let me know.
Very nice explanations. I notice that when you filter for dates only in 2023, you used "is after 01/01/2023", which is distinct from the usual "is on or after 01/01/2023" that you might use in Powerbi to include the first date of the year. Does the method you used here accidentally exclude the date 01/01/2023? If so, then "is after 12/31/2022" would have to be used, or perhaps an adjustment in M to "[PROCDATE] >= #datetime(...". Thanks for any clarification. I look forward to watching more from you.
@kevinhung-liang Thank you for your kind comment. Regarding the date filtering you are correct in saying that on an "official" project the way to use filtering is "on and after". At the company I work for we use SQL and Oracle databases and I always export my data already cleaned and I always filter data as either "<=", either ">=". In Power BI, for both M language and DAX the syntax should be the same. On a separate note, if there is anything specific that you would want me to shoot a video of, just let me know. Thank you for sacrificing your time to watch the video. It is highly appreciated 👏
AMAZING JOB. BUT PLEASE GIVE THE FILES
Thank you for you kind words. let me start by apologizing for the late response. Having said that I have a dded a link in the description box of the video were you can download the access files for the data set.
Valuable content, waiting to see more from you.... Thanks for sharing
Thank you your very much. The next video should be live in a bit over an hour now! I hope you will like it 😀
😅😊😊
Hi there, I hope it wasn't that bad 😀
Nice Video! Do you have a video where you load this dataset into PowerBI, transform it and build the measures? That would be very helpful! Keep up the good work 👍
Thank you for your reply. I hope next Monday I'll be able to upload a video with the process of cleaning the data and creating the data model. After that, we'll transform the report using measures.
@@MMS-PowerBI Good to hear. I can not wait for it (:
@theberg1e Hi there. The video with how i cleaned the data in Power Query. I would appreciate veru much any feedback from you. Thank you
I have recently solved many FAANG SQL interview questions from stratascratch through Power Query and it was such a fun. I love Power BI.
It's good to hear that! 😊 Power Query might seem complicated, but it's not that bad.
Congratulation on starting this amazing Power BI journey.
Thank you so much!