Should You Learn Power Bi? Everything You Need To Know
Вставка
- Опубліковано 28 чер 2024
- 🎓 Link to full course: link.xelplus.com/yt-d-learn-p...
🎁 To start learning for free, sign up to our FREE QuickStart Power BI course: link.xelplus.com/yt-d-learn-p...
What is Power BI? What is Power BI used for? This video explains Power BI in plain English.
You see, there is a reason why companies are investing more and more in Power BI projects.
Actually, there are four reasons why Power BI is preferred to the competition.
Power BI beats the competition in terms of sharing reports - you can easily share Power BI reports on the browser, on mobile, in Excel, Teams and also PowerPoint.
Power BI also wins in terms of implementation times. A Power BI project is much more flexible and faster to implement.
🌍 Join 400,000+ professionals in our courses: www.xelplus.com/courses/
⭐ If you're ready to become a Power BI Pro, join our "Fast Track with Power BI" 👉 www.xelplus.com/course/fast-t...
00:00 What is Power BI?
01:00 Power BI compared to Competition (Tableau)
01:47 Why You Should Learn Power BI
03:32 Why Power BI is Better than the competition
03:40 How You Can Share Reports with Power BI
04:41 Is Power BI Difficult to Implement?
05:12 Is Power BI Flexible?
05:53 Is Power BI Only for Dashboards?
07:01 How to learn Power BI (Course announcement)
🎬 LINKS to related videos:
- How to Use Microsoft Power BI: • Power BI Tutorial For ...
- 10 Power BI Tips for Better Dashboards: • 10 Power BI Tips for B...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#powerbi
If you'd like to become a Power BI Pro, here's the link to the "Fast Track to Power BI Course": link.xelplus.com/yt-c-learn-powerbi-course
Over 4,000 people already signed up and started improving their Power BI skills.
This course wasn't easy to put together. Me and my team spent many months and sleepless nights coming up with the best learning experience while making sure we cover all the real-world topics that you will likely come across at work. If you've signed up already, THANK YOU 🙏
We've also prepared a FREE QuickStart version for you: link.xelplus.com/yt-c-learn-powerbi-freecourse
Love that you made it starting from basics that will get anyone building to THEN integration with source/references using M and PowerQuery. Astute and practical so in short time someone could speak to their knowledge and ability which already exceed antiquated reporting options requiring 3rd party integration in most cases as you spoke to. Your trajectory is awesome and hope it affords you great success, now you and your team go enjoy a holiday or just R&R for the solid work!
I hope there would be an alternative payment method because I don't have PayPal and Credit Card.
I'm a big fan of Power BI, Excel, and of Ms. Leila... starting to use these tools on my job. I hope I can get a slot on your course.
@@j.ballsdeep420 Thank you for the kind words and the comments. They did not go unnoticed by our team ;)
@@sesantihastering1447 About the same here. I never use credit card for online shopping and I try to avoid using PP as much as possible.
My company has been implementing PowerBI for 2 years and we’re yet to have something usable. The problem with letting people create their own reports is they have to know and understand the data, otherwise they make bad decisions based on bad reports.
This is a metrics utility. It isn't really Business Intelligence. For actual BI, you would need an actual business logic or business application integration utility whereby a business analyst can create scenario's based on business rules to be applied to an actual metric, business function and process. BI via MS is just an advert ploy.
@@nrgpirate -- Not simply for sake of argument and to start any stupid internet arguments, I do humbly disagree: Even if you believe I am still wrong here, I would implore you to research what top-tier industry leaders like Forrester define it as (or even many top-tier business schools or schools with strong computer science programs and their textbook definitions) only because I think if you don't just take some person on UA-cam or a commentor say, perhaps their definition of BI is/includes along with their objective statement for what BI could be considered, perhaps you'll see what I do which is that I believe you're really speaking more to machine learning and AI utilized within an RPA. That said, PowerBI queries can be used as source data for RPA programs such as BluePrism or PowerAutomate, plus I would argue the benefits of that all being in the MS ecosystem so your database storage, data intelligence, reporting, and general data generation all living within their sphere makes for a far better end-user experience, continuity, increased adoption and therefore nurture a greater digitally leveraged enterprise, while doing so with far less growing pains, knowledge gaps, or silo'd knowledge to ultimately get to a similar end-goal as using multiple systems/applications from a myriad of options from 3rd parties. RPA though with BI is what I think you may have been driving at, though I am happy to agree to disagree.
I once worked with a business manager that spent all his time creating and shaping metrics. Didn't spend much time at all working on actual profit generation. There needs to be balance in terms of simplicity (to deploy and understand) and time. Remember the good old days of KISS - Keep It Simple Stupid?
@@jebear1 we have measures to support measures that support measures. 3 tiers. All three level get included in raise and bonus determination as if it were a portfolio. All three levels get measured and discussed with accountability on a regular basis (daily). So much so that it drives people to focus on record keeping for the scorecards rather than the performance that the scorecard is supposed be measuring and driving.
@@j.ballsdeep420 You are the first person in years to reply with facts. I commend that and I do agree. You are right. RPA with BI is what I am driving at. BI is just the presentation, where by RPA helps to drive the source of the data and logic, which demonstrates MVC paradigm. BI as the name is just an advert moniker and nothing more. This causes a lot of confusion for stake holders in companies expecting it to magically do everything. Its ability as a visualization tool gives false impressions to what it can and cannot do. As an architect and engineer, it is vital to evangelize to both sides of the business unit - the business side and the IT side.. the importance of gaining the proper metrics and simulate them in a DevOps/Product driven environment. If we are talking about the product side, knowing what is the customer behavior during a session helps drive the shape of the ui for customer experience to improve engagements in a campaign. If we are talking about thru-put, knowing where the bottle-necks are occurring and why is essential for maintaining enterprise solutions that have heavy traffic, so then the convo comes into play of SLA. For that I would never entertain BI... I would use Dynatrace, because I can dive all the way to the device responsible and be able to escalate it. Again Thank you for your comment.
As a Team Leader, I have been accessing Power-BI for months. The filtering and sorting of the information is quite impressive. Most of the charts that my company uses are not flashy by any means, but they are clean and easy to read. I am quite impressed with the application.
I agree with a previous post... You have a very complete way of presenting the material. You always present value-added features which are actually useful to the common business professional.
And, please continue to provide the video outline in the Description so we can glance over it and decide if the video is interesting as we're not always in the video-viewing mood or want to watch and take notes but are not in a position to do so.
Thanks for all the hard work at keeping us informed!
I joined my company as they were transitioning from excel to power bi. I will admit there was very little out there to learn from but somehow I taught myself by remembering excel formula. I agree power bi is the future.
You're videos are always so helpful! And I love your laid-back confident presentation style! 👍
Thank you Leila and the XelPlus Team for another fantastic course. You make it so accessible but comprehensive at the same time. Completing a whole course gives me the confidence and the skills without any gaps. Instead of a mash up of UA-cam tutorials I know I have all the essential information to start and in addition a great deal of further detail to study and become expert. Many thanks again
Thank you Amy! Great to have you onboard.
@@LeilaGharani is only power bi is enough to get a good job
I have been working with powerBI for a month now and it is really great to use. Thanks for all your videos :) the mapping functionality has really come in handy for me
Great to hear!
Hi Leila, thank you for yet again a great video! We experienced a snag with Power BI recently, namely only users with Pro subscription can see the created presentation. Is there a way to share the interactive report (interactive as using buttons to filter different way) on a webpage or Teams group (or really any way other then export a "flat" file)? Thank you for you great tips :)
Well, I finally enrolled in your Power BI course Leila, and progressing! It appears promising, and I am sure, I will learn a lot. Thank you for your teaching passion that's helping so many people around the globe! Keep up the great work! 🙂
Thank you for your trust, Vijay! Hope you'll enjoy the course.
Hi Vijay. Are you switching from a different field to power BI?
@@sarihaddu No, I am already using Power BI and just want to enhance my knowledge and skills in it...
Is this the lifetime access??
@@subhsworld5603 Yes, lifetime access...
having used power BI for biopharma application for a while now, Its a great tool. However, the business focus backed into the defaults means that it is limited for particularly time course analysis. The big advantage is it support data integrity as not making copies of raw data.
PowerBI visualisations have some huge shortcomings, but it’s strengths are evident. It needs a little more support and QOL improvements
Could you make a similar power bi video for academics? Specifically for professors who coordinate programs and have 100 students who major in a topic. That would be very helpful. The goal would be student retention and Fast Track graduation. Whenever a student fails a course they are set back to not graduate on a schedule. Classes are not offered every semester, so the delay for graduation may increase. Basically what I'm looking for is a personal interaction with hundred plus students hoping the power bi may help me. For example, social support, celebration messages, birthday greetings, highlights of achievements, such as presentation at conferences or other activity students do. Additionally, personal stories, testimonials, and alike (from students). Tnx!
I like this angle that you are talking about Power Bi implementation. My experience (approx 1 years) of Power Bi dev projects are much more complicatedt than that what the end users are made to belive. As they start off in wrong angle and dont understand update of data, storage etc.. It is not as excel unless you deal with data in your local machine then is more possibilities. Depends on company but Power Bi reports are tip of ice bergs, and has to have to e part of a solid ecosystem. The stong pro of power bi is that you can maintain and control datasets in that environment. The datasets can then be provided to end users for their purposes.
After following your videos more than 3 years , i found the quality of your presentation has improved a lot, the edits and your communication skills are far perfect .
Thank you. There is still a lot that can be improved but one day at a time 😊
I really enjoy all your videos and will try to register to start my journey in Power BI. Thank you
Thank you for sharing this information. I've been using PBI for a few years now but still not fluent. I may just look into this course.
Phenomenal interactive explanation that I was looking for days!
I recently had to hand in my Power Bi report as final exam assignment.. It sucked really bad. But im willing to learn it, and Ill definitely will watch your videos for this
Great summary of the huge value of PowerBI! ☺️
@Leila, I’m looking for project portfolio management using Powe bi application. Please make some tutorial or video on it to monitor multiple projects monitoring at same time.
Does the course provide how to use pro licence stuffs : like publishing dashboard, implementation of RLS, scheduled refresh in the project? Or its just theory part?
I believe that powerbi is leading because A) it is more readily available to all employees under the office 365 and free version versions, and B) it is better documented and supported on multiple platforms than any other. Ie it even has a learning app with man in a box videos for power bi.
Hi Leila, You have no idea how valuable THIS little video is to me and many others…!!
This is the exact video I want to share profusely! :-)
My schedule doesn’t allow much, but I’m gonna make an effort to try to squeeze this in…
(I would LOVE to teach Noob Leila a few tricks, too, so, she’s more of a match for Pro Leila ;-)
Yeah, but noob Leila got a head start on the course though 😁 Thank you for your support, Geert! Hope to see you inside the course.
@Noob Leila: here I come!... 🙂
Amazing amazing video sharing as always dear friend Leila..
All your videos are truly amazing..
Thanks for sharing this with us giving another a big Big like thumbs up 👍👍👍
See you again take care 😊
God bless 🙏🙏🕊️
Keep intouch 👍❤️
Very much looking forward to the P-BI Course ... but I need to fit it into my 'Deep Work' schedule so I can focus on the material. But unfortunately at this moment, 'DW' is a crowded space. I have NO doubt the course will be worth it and will be the same quality as Prof. Leila's other work, which is to say, I expect it will be excellent. 😍😍😍😍
I can relate. Focus time is rare these days. Hope to see you on the inside at some point though 😊
MICROSOFT APPROVED THIS COMMERCIAL. Good video, learnt a lot about Power BI. Thank you. Moreover, dear Leila, to belong to the Magic Quadrant, you have to pay.....
Can you do a video that compares PowerBI vs. Tableau? Pros and cons of each. Would love to know your detail thoughts on how these 2 compare.
You can use Tableau public for free! PowerBi is $9 per user per month (100 users $900 per month!) or a enterprise 365 E for $$$$$ and more tech complications
Most excellent video and channel - added this to my subscription
Do you have course content list?
I just got access to powerbi from my company to create some reports.. the best replacement for excel and sheets or pp.. powerautomate as well extreamly useful to automate even the smallest task and share everything with others in your org.. extremely logical and intuitive
And their MS cross-app and vast non-MS database integration is stellar --easy to understand why this has catapulted PowerBI over Tableau/Salesforce
Can you explain the subscription model? I use it at work but can’t share it in a useful fashion without a paid subscription
I need to have a row and column comparator. For example if I want to measure accounts that a producer is overseeing, while looking at the profit center he is tied to over a span of time. In tableau it was really easy to set that up--can that also be done in Power BI? If so, how?
Well Explained, I should need to use this tool.
Hello 👋 good morning
Please do excell campus have a n e-learning site that offers online training and issues certificate??
How to incert new row in power query
Can you display how much the course is before clicking on buy?
A good thing to have in power bi would be for users to view a shared published report without having pro access
Thank you dear Leila, the great motivator for great technology !
@Leila Gharani i hope there is installment option over 3 month in future + coupon that would be superb ☺️
Or different pricing to people in 3rd world countires or hyperinflationary Like Egypt USD to EGP Changed in one over 23% Devaluation ... just a side to attract another customer that you already have over platforms like Udemy .. Thanks
Yes Power BI is the future. It take automation to the next level. I am using Power BI extensively and trust me I have not shared my BI dashboard or report to anyone. Yes you heard right and still I have automated 100% reporting needs of my department with this amazing tool. Everyone get what he want without any delay. No person dependency for any kind of report. Around 100 people are served happily with around 30 reports ranging from daily, weekly to monthly reports. Not only reports but a complete workflow is working with BI, powerapps and power automate. We are using Excel just to download and view reports. No formula any where
Thanks for sharing your experience!
Im working with pbi for 4y now, basicly you need good data model or cube for Reporting. Then you can delegate front end to self service.
Im my company we have big bi team (30ppl) and over 20 bi solution made for bussines, with 5k Daily pbi users and still growing around +1k users /year. Quite a jurney
"Leila Gharani: Thank you so much for being 'Super Intelligent, A Powerful Educator, and a Wonderful person who knows how to deliver KNOWLEDGE." It appears that I am way behind on finding you, yet I am most proud to say you are the reason for me being more confident and readying to take off into this new world of change: 🤗🤗🤗🤗🤗 "
Finally I've got to understand what is Power BI!
Thanks!
Happy to help, Mauro!
I think I'm slowly realising that I've been way too reliant on Excel over the years for everything rather than just using it for what it should be used for -- spreadsheets and really quick ad-hoc calculation. It isn't really efficient for large scale models or transforming data regularly.
If I had actually sat down and learned 1) Python and 2) Power BI I would probably have upped my career development, salary...and job satisfaction tbh....rather than just scrapping stuff together in Excel all the time. Better late than never though, so thank you for giving me the push!
Did you learn it in those 9 months?
@@kqi32 haha yes, I managed to get a job that was way beyond my skillset so it forced me to learn them very quickly! I am still learning new things of course.
Thank you so much for the good work, we really appreciate it.
Kindly create for us Introduction to python"lessons as well.
I am using the Forecast ETS formula to get my forecast for next 5 years. But as soon as the sales are coming in i need to include those latest sales and improve my forecast for the future months. Is there a simple way with the help of vba or macro to do that , as my client is not very supportive of going back and changing the formula in each cell? Aprreciate your help
Can Power BI help me monitor food inventory with expiry dates? Inventory is difficult to monitor properly when I have duplicate items with different expiry dates.
Respected Ma'am.... Could you please help me with a video on regarding write back options in Power bi
Looking forward to learning more Power BI! Thanks Leila!
My pleasure!
I keep seeing videis on data analitics. Aka processibg data ALREADY existing. But very few on how to GATHER data, safely, organize it, verify tge corectness of data entered. I think we shoukd address the foundation of data analitics as well.
Hi Leila, Can you please make a video on below flow in power automate. I receive attachments in two different emails in outlook and I have to forward these two attachments in new email. I couldn't find any content on this issue on internet. Please do a tutorial on this.
When will it be available in Udemy because I'm following your courses on that? Thank you.
Will it be available on Udemy? Thank you for all your efforts and keeping up the good work!
Available only on XelPlus.
Congratulations on getting over 2 million subscribers!
Thanks Leila. Will xplore.
Hello mam in Excel ( if condition in that logical value contain text i want return true value as a color cell )ex : when I am putting a text in a cell i need a color in another cell, is this possible kindly reply mam
Great stuff as always. Thanks Leila!
Pretty cool! I'm thinking about getting a certification in Power BI as I look to transition from finance to a more analytical role. Thanks!
Go for it! Rooting for you.
@@LeilaGharani . Thank you!
Congratulations for 2million subscribers!!!!.
Hi leila. Is all very nice, but there are NO too many tutorials that teach us how to link Excel to Power BI. most of thew companies use Exel for all the data capture . My company as well . I've tried linking Excel to Power BI with automatic updates of the POwer Bi repoerts once data is changed in Excel, and No MVP is actually addressing this issues. In my opinioin this is the 'missing link". A proper synchronization tutorial that will make it easy for most of the companies. Are you not in agreement with me?.. Thanks Lelila. Cheers Martin
My data is in my accounting systems. I say systems because we have 45 stores, each a separate LLC with separate accounting systems. I pull these reports from the individual stores and compile the information, and start pulling it all together. Will Power BI link to my accounting systems to pull real time data without me having to pull and compile reports? I have seen an add on I can buy called Scotts that links right into my QB. I just have not plulled the trigger yet.
Wow.. Leila, This is something I never head before the way you present... awesome.. thank you
You're so welcome!
a killer video = love it by value | this video is good to go for an Oscar 🙂 in various disciplines
I was literally searching for this yesterday!
Big Brother is watching you.=)
Because phone has spyware on speech and characters recognition
If you already have some PowerQueries in Excel, can you connect to them/import them from PowerBI or do you have to re-create them in PowerBI from scratch?
No recreation needed. You can import them with one click into Power BI. All you Queries, connections, model etc will come over. Just go to File / Import.
Congratulations Leila for 2M Subs
Anyone questioning this needs to know as someone in a Fortune 100 company dynamic to change but most importantly to S-tier applications that are used in our level of industry, if you have ANYTHING to do with reporting or reporting creation, you NEED to learn PowerBI: If your company hasn't already adapted as a good solid 50%+ of our company has from any other antiquated dashboards, I can tell you they WILL in the coming years or next decade if your company is not quite so high-level. PowerBI allows you to build on existing MS Power based applications and integration like PowerQuery where M language will be interchangeable, but being able to even take basic Excel data and ramp it up using advanced functions like PowerQuery getting data from a plethora of datasets simply as a source data or even reference to be able to manipulate, tie other sources together, while having dynamic data that is 100% accurate to existing workbooks, databases including SQL, Teradata, Azure, AWS, etc, then you can see the power and interconnectivity of PowerBI as a reporting dashboard while also learning it from a very skilled and talented person who can teach you from an introductory level to being a MS certified Master. Don't question it, research it to validate this, then don't hesitate and jump on the cutting edge so you're not a Dinosaur talking about your abilities to take MS data and integrate it into Tableau, plus look at any Forbes 100 job postings, this is only a preferred qualification as of today so you're learning what will make you a fucking rock star as any applicant.
I work for a massive global company also, and I am pretty sick of people presenting page upon page of stats in Power BI when the useful data can be summarised in a couple of well planned dashboards. This is the result of providing tools to people without backing it up with proper training. Plus, some of the people using the tool clearly dont have a clue about the context behind the data they are supposed to analyse...
@@cerealport2726 -- Lmfao, you're TOTALLY right and I have experienced the _same_ _exact_ _thing_ but I speculate that is due to their own excitement learning a new skill and flexing. Perhaps something productive such as reaching out afterwards and telling them it's awesome they're on the bleeding edge, learning and being able to create on a platform only recently being adopted by most Fortune 100 companies, but ask if they're interested in brainstorming ways of presenting the data similar to how it may align better with previous dashboards so you can hopefully learn from them on the skills they've learned while also providing feedback on how it is presented being someone new to this dashboard while seeing the GREAT benefit it will have for not only you and them but your company, you're very excited for their willingness to consult and help, but that you feel you have an added value of providing insight as a n00b looking in from the outside of their intention to mutually benefit each other. Not even a lie or manipulation, mutually beneficial.
Best of luck!
@@cerealport2726 -- Stroke their ego, empower them, genuinely learn from them as they clearly can create, then partner to create something better for both of you 😉 ✌️
@@j.ballsdeep420 yes, you are right. When possible I do try to mentor and encourage people, it's much more constructive than tearing them down. I also appreciate when people do the same for me, because while I am a recognized expert in some areas, I definitely dont pretend to know everything, and am happy to learn more.
@@cerealport2726 -- Absolutely true since no one is a SME for everything and no one likes that douche acting like they are. Civility and humility go very far. Kudos to you recognizing this as well as willingness to learn as we should never stop learning and I fully agree. Have a great day, bud!
Can someone confirm if all the users in D365 would need to have a Power BI embedded license in order to view the Power BI Embedded reports/dashboards configured or is the license just needed for the admins who create and share the reports?
Good day, what the use of this tutorial when it's only required in the workplace environment? l did try this couple of months back but PBI can't be used with a personal Microsoft account. Personal Microsoft accounts are not supported for
this application unless explicitly invited
by your organization. It requires you to sign out and sign back in with an organization/ workplace account.
Hi Leila,
I have Power BI Pro at work, and when I publish to our Corporate SharePoint site or Teams Channel, only my colleague with Power BI pro can view the Report/Dashboard.
Is there some trick I'm missing?
How long is the course you have?
I love your videos. I've been learning so much, thank you
I'm so glad, Lori!
Amazing as usually, BUT, could be cheaper to be honest. There are plenty other courses out there with an amazing content, but more affordable.
What is self services reporting in power bi
Leila, I would have loved to join your course! Will wait due to budget constraints. You will see me soon signing in for this course.
You don't need to pay to learn a free service holy crap pull up some documentation and start reading its free...
How can i study power BI DAx function from your video
Any plan to explain the Power BI apps on windows?
There is 3 different app versions of it on Microsoft store on windows
And I checked their site there is different paid subscription for it such as pro and premium etc
I'm checking to see if it's worth for me to invest in power bi and learn it but confused for all these different versions
Hi Leila, have you tried Insightsoftware's Spreadsheet Server for Excel?
💩
Hi Leila, when will your Pwer BI course be available on udemy.
thank you.
Hey!!! Do You offer live online classes. Not just a course for me to go buy. I mean do you offer live online training sessions.???
Does your company do formation online?
Power BI is good for non-technical users. Tableau is better for serious developers.
Excel table does not expand automatically if locked. When some columns are open and other columns are locked to feed the data, the table does not expand and the pivot table also does not update. I haven't found the answer to this yet after searching on google. Is there any solution for this??
Being Manager Bidding & Cost Control, have stored tones of Data which with passage of Time is getting outdated as well difficult to retrieve. Now can switch to BI.
well.... signed up for the free course but there is no way to access it. Lesson content locked. must sign up. there is no link to sign up other than where I already signed up. So sad.
Should I learn Microsoft Excel first or jump to power bi?
Part of my job, unfortunately, is data science. I don't see this used much compared to products like Tableau. I have always preferred to look at data in a programming language. Then again my data sets are millions of lines, so you have to integrate with data lakes. I'll use Tableau when I have to, but my goto is Python coupled with Pandas and MatPlotLib. That way I can use machine learning and large language model AI concepts. If you wan to be relevant in the near future, you better learn the AI models, before they are used to replace a lot of people.
If only you had released this last week, FTX would still be around 😂
Damn, too soon
🤣🤣
Someone explain please
@@Rawyu -- FTX was a crypto coin currency exchange to buy/sell/house investors funds. Tens of billions of dollar possible losses, possible financial crime, founder filed bankruptcy after $16B personak loss, etc as the story continues to unfold. They had an unknown "disappearance" of $8B and therefore the joke was if they had a good financial reporting dashboard accounting for all funds with financial reporting it could have been avoided or brought to light before it got to a complete collapse, they literally had/have very little records retention or transparency allowing them to commit what almost certainly will be treated as a criminal liability case if not straight up fraud👍
@@j.ballsdeep420 Thank you J
Hi Leila can you tell which laptop model you are using?
It's a Surface Book 3.
Can I pay the course fee in installements
Hi Leila,
Is it possible to know which are the months and number of days in the month between 2 given dates in excel?
Bro are you serious right now do you not have access to Google like what kind of questions are these you people are hopeless
@@ykonratev Hi, i hope the Google isn't the solution for all... May be you could also suggest me for the solution
The answer to your question is “yes it is possible”. You can do it using Excel functions (formula) and you can do it using PowerQuery (also known as get and transform data or simply “M”). In Excel explore the date functions they can even take account of working days and bank holidays. In powerquery explore date tables.
However if I understand your question correctly you may need quite a complex formula. What I did was create my own excel function using VBA (which is part of Excel). I had to cope with blank end dates (the service hadn’t stopped) and data issues such as end dates before start dates and to choose between counting days and counting nights. If a service starts on 1 may and ends on 2 may then in my data that was 2 days or 1 night.
The key thing to understand is that excel holds dates as whole numbers. 29April - 3May gives a meaningful result. So does max(29April,1Apri)-min(30April,End date). In this context max means “the latest of”.
@@gavonak2841 thanks for the feedback, I was working in a project overview dashboard. Where it was a task to visualize the total occupancy . Somehow, I could not do it..
Power BI vs Tableau vs Qlik - what are your thoughts about these tools in comparison?
Tableau is slightly better than Power BI, but far more expensive. The enterprise version is $70 per month per person. Power BI is $10 per month per person.
Leila, I have a question about transposing data. How can I contact you?
How do you get around the cost of hosting the Power BI reports so others in the company can access the reports created by anyone without them having to use Power BI desktop? Using powerbi is nice, but unless you can share dashboards created by someone to everyone in the company, they start to fall flat. Getting management to use the tool can also be an uphill battle. If there was a simple, inexpensive way to host reports in read only on SharePoint so everyone could use them, it would be worth it. As it is, you have to pay for way too much to get analysis you can do in excel and share more widely under a current cost structure.
With the removal from 365, one of the best options is to share via Teams or even directly add via Teams since the Dyamics/SharePoint integration of Teams/BI still is functional to launch there, plus you can create a group or channel that allows you to control access to said group along with visibility to given your data set/dashboards with easy permissions management simply by adding/removing users rather than deep settings on SharePoint.
Best options given your question of if the given users don't have Enterprise Office**
Can you please provide a coupon?
I'm still a little confused, how is it different from Excel? Why wasn't PowerbBI just made inside Excel, i.e. why wasn't Excel just given the extra horsepower of PowerBI?
The company I work for is implementing power BI…makes me feel that I may not be needed in a few months. Realizing this, I signed into a Data analytics and visualization bootcamp for 24 weeks and by the time it’s done I’ll have an option of lies ahead.
Are you available for questions or specific help if we enroll in your courses??
We have teaching assistants who will help out with issues in the course. However, we cannot provide consulting services for non-course related topics or projects.