NB all, the SharePoint List doesn't work (or at least it doesn't for many of us) but that's OK - it's just a demo and that table is never used. Don't waste your time on trying; just watch the video and see how you would be able to connect to your own SharePoint Lists, if you have access to such things. And a lot of people are asking about Day 4: it follows on from Day 3 IN THIS VIDEO. See the timestamp for "Introduction" at 1:23:40. I'd like to express my thanks for this great set of tutorial videos. Not exactly up-to-date as regards the UI (I'm watching in August 2021), but if you look for things carefully, it's not too different. Power BI is very much a moving target!
@LearnitTraining3 жыл бұрын
Thank you for the kind words Claire! Our updated Power BI videos will be coming out next week!
@erickgarcia30942 жыл бұрын
does anybody have trouble connecting to the sharepoint list (04:33)?
@tonyc9453 жыл бұрын
One other suggestion for those of you watching this tutorial. When Chelsea says to remove items from the fields area BEFORE moving on to next topic, simply create a blank/duplicate page. That way you will keep all the information that you can later use when you are dealing with your data. Anyway, wish I would have done that, but now I'm finished with the tutorial.
@umairvlogs12112 жыл бұрын
😭❤️
@kervinocampo68657 ай бұрын
The best tutorial I've found. Because of you, I managed to create my own dashboard that I'm using in our company. Thank you so much!!!
@LearnitTraining7 ай бұрын
Glad it helped!
@Alazir20072 жыл бұрын
Great job! I had some Power BI courses before but none of them has the amazing details you explain in this video. Thank you so much for it!
@LearnitTraining2 жыл бұрын
You are very welcome Alazir! Thank you so much for your support! It helps us continue to create new videos!
@Benfather4 жыл бұрын
wow ! Chelsea you're great teacher... I followed from day 1 to day 4. you know well both the tool and the data. Stay blessed and caring
@mariateresapepe67843 жыл бұрын
Hi! Where did you find day 4? I can't find it on youtube
@achinthya973 жыл бұрын
plz tell us wheres day 4 plzz🥺
@clairejsquibb3 жыл бұрын
@@achinthya97 Day 4 is the second half of this video, starting at about 1:23:40
@fadiabusafat51623 жыл бұрын
Dear Chelsea, Thank you so much for your amazing tutorial. I really enjoy it and love it . Thank you so much. Nice one Chlesea.
@ShawnTheSheep4073 жыл бұрын
One Course to Rule them all.. Thank you very much! very informative
@LearnitTraining3 жыл бұрын
You are very welcome Name Less! Great name by the way!
@hariskhan794 жыл бұрын
At 52:00, shouldn't formula be opposite? like current month - prev month / current month? That will give us positive or negative growth as compared to prev month
@Cedar22554 жыл бұрын
I think (current month - Prev month)/(Prev month) if you want to see the grow or loss from previous sales.
@felixhuang51984 жыл бұрын
best PowerBI course to day
@MrAszurbanipal3 жыл бұрын
Last exercise from day 3 - wouldn't reversing relationship from "colors unique" "colors" and making it "many to 1" work as alternative to creating a measure?
@bemalsdvanitha20903 жыл бұрын
All 3 videos are amazing 🐱🐱🐱 waiting for more power bi content
@LearnitTraining3 жыл бұрын
Hi Bemals! In February we will have LIVE session planned. Details coming soon!
@abubakrsaadmakyhoun75354 жыл бұрын
great and powerful resources and Tutorials. my greeting for the instructor, she is amazing and know exactly how to explain each topic and know how to select sample to show her vision.
@LearnitTraining4 жыл бұрын
You're very welcome!
@jorgevargas97222 жыл бұрын
Best teacher I have seen ever. Thanks so much.
@LearnitTraining2 жыл бұрын
You're very welcome!
@raja49994 жыл бұрын
Hi...Excellent class ...could you please upload the day 4 session also ...Thank you
@vivianxu20852 жыл бұрын
Amazing tutorial! I solved the problem that puzzled me for weeks by watching this video very thoroughly. While I noticed at 1:49:10, the % Total Sales of Parent Category is actually the % of Total Sales negating all categories not the % of Parent Category (Audio; Camera and camcorders; Cell phones). Not sure if I misunderstood anywhere...
@hsummer2544 жыл бұрын
So lucky to find these courses which helped me a lot! Thank you soooo much~Great Course!
@balanarasimman.n48353 жыл бұрын
Hi Chelsea, Its a great tutorial. I just finished watching the power bi series. It was a great work. Easily understandable to even a person without any knowledge about this software. Keep up your good work. Thank you.
@LearnitTraining3 жыл бұрын
You're very welcome!
@stefancolic3435 Жыл бұрын
Did you land some job?
@AZ-em6nj3 жыл бұрын
Learned a lot through the 3 series, thank you for creating the tutorial!
@vladimirkliman71853 жыл бұрын
1:16:00 Why there is problem with many to many relationship in power bi ? I know there is not this possibility in power pivot .... but in power bi I have created a lot of these and they work perfectly
@Learningboy7773 жыл бұрын
Thank you for creating this course. This is very much helpful.
@LearnitTraining3 жыл бұрын
You're very welcome!
@hussammohamed92053 жыл бұрын
its best course ever
@LearnitTraining3 жыл бұрын
Best comment ever!
@TheDanielsony11 ай бұрын
This is the best course I've ever found on this. Thank you so much for sharing. Question though. When making the dates table, I typically list the dates, then in the data model. I think that option taxes the processor instead of the ram. Do you have an opinion which way is best? (Assuming you have 30 years of dates or something like that)
@LearnitTraining11 ай бұрын
Hello TheDanielsony! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@viv_digital_013 жыл бұрын
Chelsea is such an amazing teacher. Keep it up
@LearnitTraining3 жыл бұрын
We will!
@yingruozhou54284 жыл бұрын
Access to the resource is forbidden - what is the solution?
@fernandozambrano41024 жыл бұрын
The solution is to ignore that and continue with the tutorial. You won't need that data, as Chelsea says in the video.
@edwardgustaf73993 жыл бұрын
Hi thank you for the nice video. One question, what if we have multiple things to be unpivoted? Is it the same way just don't select the column?
@piyushashah13 жыл бұрын
Can't coonect to the sharepoint, it says that "We could'nt authenticate with the credentials provided. Please try again". And, I am signed in with my microsoft account. What am i doing wrong here?
@wangangcwayi94202 жыл бұрын
Thanks a lot Chelsea!
@LearnitTraining2 жыл бұрын
You're so welcome!
@TheBkDani4 жыл бұрын
By far the best tutorial online. Clear and easy to follow. Thanks a lot.
@alanf56153 жыл бұрын
Can you help me out with the average promo calculation and hi-low promo visual In most measures, you read the Dimension column and aggregate by the fact table. Product name > Fact Table > Total sales visual In this case your going Product> Totals Sales. and then you're reading the promo amount off of the Promotion table? it's very confusing because the only promotion data we have on the Fact Table is a Promo Key number and not a discount percentage. How are we aggregating data that's only on a dimension table?
@rishav91253 жыл бұрын
It shows an error with the message "forbidden" when I try to get data from sharepoint. Please help!!!!
@tonyc9453 жыл бұрын
It's ok. She doesn't use the data in the remaining parts of the video. So you and everyone else can continue with the tutorial. When I first hit the snag as you did, I contacted LearnIt to see if they could adjust the SharePoint permissions, but they said they couldn't. Then I continued to play the video and then found out the data wasn't going to be used.
@rishav91253 жыл бұрын
@@tonyc945 okay thanks .
@AbhinavSingh-oq7dk3 жыл бұрын
Understood USERELATIONSHIPS, but what was the purpose of 'TotalSales by Due Date'? What was the insight? Not getting it.
@bhushanks26603 жыл бұрын
Files aren't downloading larger than 25MB from your exercise File
@brucefogelstrom79852 жыл бұрын
I'm also stuck at 04:25 connecting the SharePoint sire.
@allabout11354 жыл бұрын
So brillant course. Hope to see in the future deeper M and deeper DAX. You are doing amazing job, that You are sharing, knowledge with us. Thanks!
@tawerwerroronoa38252 жыл бұрын
i like the term complicated relationships.. :)
@LearnitTraining2 жыл бұрын
LOL!
@malcolmmay93323 жыл бұрын
Hi guys... when trying to connect to your "sharepoint online list" as per the video walk-through around the 3:53 mark, I'm getting an error... "Access to the resource is forbidden." Has the resource been shut down now?
@ghada2602 Жыл бұрын
Thank you for those 3 tutorials! You are a beast!
@LearnitTraining Жыл бұрын
Our pleasure!
@davidrahman81828 ай бұрын
1:23:14 segment, I am getting all Color Theme same number 2282482. I cannot figure out the problem. I have added same formula as you have done CountOfSalesQuantiy = CALCULATE(COUNT(FactSales[SalesQuantity]),Colors). But your result and my result are different. Can you please let me know where is the problem? At least little hints. Thank you for your excellent presentation. I have learnt lot.
@alcq20063 жыл бұрын
Great class!!, thanks for your help!
@LearnitTraining3 жыл бұрын
You're very welcome!
@garysimpson5603 жыл бұрын
It won't allow me to access the demo data. I get a message forbidden when I try to connect to the sharepoint data
@harshalpatil21113 жыл бұрын
same here.. anyone can help here ?
@cs-kw4pl2 жыл бұрын
Excellent !!! Thank you very much!!!
@LearnitTraining2 жыл бұрын
You are welcome!
@salimaassi31553 жыл бұрын
Thank you so much for this course I finished the three tutorials but I have a problem I can't sign in on line because I don't have a company email any solution??
@AbhinavSingh-oq7dk3 жыл бұрын
The total for every year in your power bi is showing below December, but in my power bi, it is showing above January for every year? Any explanation?
@grahamthenomad97043 жыл бұрын
Great Tutorial spoilt by too many interruptions for ads !
@tundeaboloye45294 жыл бұрын
Your Tutorials where awesome when are we expecting day 4 and 5 uploaded? Hope to hear from you soon I have already Subscribed to you guys
@fernandozambrano41024 жыл бұрын
There is no day 5, at least not online.
@princeboadi79042 жыл бұрын
@@fernandozambrano4102 Is there day 4? If yes, kindly reply with the link. Thank you
@firdausjahan82612 жыл бұрын
Thanks for these great videos. Why can't we apply multiple filter conditions in the same calculate function for all product categories? Why to create separate measures?
@LearnitTraining2 жыл бұрын
Hi Firdaus! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
@maheshgore62653 жыл бұрын
Very well taught ..from scratch to pro💯🤙🏻🤙🏻
@LearnitTraining3 жыл бұрын
Glad it helped!
@almanamo6858 Жыл бұрын
Thanks A LOT. Where can I find the Contoso Sales Customers dataset, please?
@LearnitTraining Жыл бұрын
Exercise Files: bit.ly/2S4ARFI
@tonyc9453 жыл бұрын
AT 1:48 I believe the measure is incorrectly labeled. The percentage actually calculates against TOTAL SALES NOT the PARENT CATEGORY. If anyone else sees it this way, please let me know since I may be thinking about it wrong. Thanks.
@TT-oy1rp3 жыл бұрын
Yes I saw it the same way as you did. Maybe just some mistake, I guess.
@leifwermundsen86723 жыл бұрын
Hello! Please fix this, it seems that many other has the same problem! I Cannot download Day3 workfiles. The PBIX file is larger than the allowed download size on your onedrive. Please advise. Thanks
@kimpflugradt23593 жыл бұрын
I have the same problem
@sarahbottomley45654 жыл бұрын
Instructor Chelsea is excellent. Content was very valuable. I did find that some of the information is different based on the newest upgrades, however I was able to complete all of the tutorial with a few variations.
@madroneroc2 жыл бұрын
Great Tutorials however, for this I am not able to proceed - even when using "Anonymous" I am getting credentials error. Anybody has any idea how to resolve this? Tia.
@LearnitTraining2 жыл бұрын
Hi Issa! You can get your question answered at Offsite, our online community - www.offsitebylearnit.com
@princeboadi79042 жыл бұрын
Is there a fourth tutorial in this series? I'm currently on this episode but the day files are four (4) in total but I cannot find the fourth tutorial. Anybody that has come across the fourth tutorial, if any, should kindly reply this comment with the link to it. Thanks!
@LearnitTraining2 жыл бұрын
Hi Prince! This is the 4th episode of the series. The 3rd video would be the expert tutorial.
@ycbq999 Жыл бұрын
Thank you so much for the awesome tutorial. One question.If I write a program that will update data regulary, can PowerBI automatically update the charts?
@LearnitTraining Жыл бұрын
Hello ycbq999! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@elmin133 жыл бұрын
This has been an amazing indepth guide on PowerBI, detailed and very well layed out!
@LearnitTraining3 жыл бұрын
Thank you kindly!
@stefancolic3435 Жыл бұрын
Did you land some job?
@uroojatif97533 жыл бұрын
Hi, for some reason all of my values in the tables are exactly the same. So for example TotalSalesMTD, all of the values underneath are the same. The value in the first row is $8,467,938,313.52 and in the second one it's also $8,467,938,313.52? I think there is something wrong with my TotalSales table or something. Can you please tell me what might be wrong with it?
@mudokulamgopinaik13974 жыл бұрын
Excellent explanation
@chrisg93524 жыл бұрын
Hi - does anyone have a fix for the "Access to the resource is forbidden" issue? A shame as the first two videos were awesome!
@fernandozambrano41024 жыл бұрын
The solution is to ignore that and continue with the tutorial. You won't need that data, as Chelsea says in the video.
@waynethurman21443 жыл бұрын
@@fernandozambrano4102 Thanks!
@ferdinandorian2030 Жыл бұрын
Do we need a subscription in downloading tutorial content files?
@LearnitTraining Жыл бұрын
You do not need a subscription to download the exercise files
@elrevesyelderecho4 жыл бұрын
1:21:05 what if you change the relationship to be bidirectional?
@worldaccess3 жыл бұрын
How to add additional table in relationship fields? Thank you
@rsisler19593 жыл бұрын
Cannot access the Sharepoint Data. Even though I am connecting Anonymously, I get the message "We could not authenticate with the credentials provided"
@nhatthuonghuynh9604 Жыл бұрын
I think for 1:49:00, the %TotalSales is calculated against the sales of all categories, not just each parent category. Is there anyway to just calculate foreach category?, i.e. sum of % for each category is 100%
@pack15203 жыл бұрын
I have just discovered Chelsea's training videos. Can you please tell me where to get the sample (student) data files? Thanks very much!
@LearnitTraining3 жыл бұрын
Hi Rich! The link to the exercise files is in the video description
@leandroalvesferreira54673 жыл бұрын
Thank you for the whole course!
@LearnitTraining3 жыл бұрын
You're very welcome!
@Sergiolario Жыл бұрын
Hi LearnIT guys, thanks for great tutorial! At 53:45 one of the values in Pct Change column is infinity....what can be done to the formula to get rid of that? I tried using calculate function and excluding TotalSalesPrevMonth 0, but it throws an error. Thanks!
@LearnitTraining Жыл бұрын
Hello Sergii! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@user-ct3ki1xc3r3 жыл бұрын
It is a brilliant tutorial. Thanks a lot!!!
@LearnitTraining3 жыл бұрын
You are welcome!
@spyxxx5663 жыл бұрын
Does power BI auto query-ing pulling the data source (daily) without user having to open Power BI nor having to have to turn on the machine?
@LearnitTraining3 жыл бұрын
Hi Dee N! You can ask our instructors questions directly on Offsite our online community - bit.ly/30HMjvw
@ronaksurana84 жыл бұрын
I would request Learnit to upload Day 5 class as well. I would really appreciate if you could do this - Learnit Team
@NipunRawat084 жыл бұрын
abe day 4 ki to dalli nahi day 5 kaha se bahuch gaya ??
@ronaksurana84 жыл бұрын
@@NipunRawat08 bhai day 3 and day 4 combined h ek baar dekh pehle...😂😂
@ngoichoixoinuoc27434 жыл бұрын
In the last video, we created the profit by year and month chart. I have reordered and sorted it out by MonthNum or Year&Month. But it came up with January 2014, January 2015, January 2016, and February 2014, Feb 2015 etc. How can I fix it and make it to be right order (Jan2014, Feb 2014, March 2014 ex)? Please help me
@tinatnth95344 жыл бұрын
Add a new column in the dates table, use metric : YEAR ABC = Dates[Year]*100 + Dates[MonthNum] , then go back to report and choose sorting by YEAR ABC
@anilrawat97094 жыл бұрын
I am facing an issue. I have a matrix when I export it, its formatting get lost. Any solution for it? thanks in advance.
@RogerBurke3 жыл бұрын
problems with importing the sharepoint list. keep getting error message "we couldn't authenticate with the credentials provided" even though anonymous is selected. No option to change credentials. So stalled at beginning of lesson. Maybe LearnIT could provide some dummy credentials??
@RogerBurke3 жыл бұрын
All ok...don't need this file anyway..great lesson.
@ajinkyadeshmukh96742 жыл бұрын
Hi, I have a doubt, when you create Month Name it is in Text data type, however when you start with DatesYTD they are shown as January till December for each year, are there any changes that you have applied?
@veemalsewtohul15232 жыл бұрын
Hello. Many thanks for this awsome training session. I see that Competitor Report Excel is password protected. Can you share same?
@LearnitTraining2 жыл бұрын
Hi Veemal! You can download the file locally and make any changes you want then.
@nhatthuonghuynh9604 Жыл бұрын
hi, I still do not get the last lesson in day 3. How can Power BI calculate the count of sales quantity by color using the table "Colors" when there is no relationship between ColorsUnique, Colors and FactSales?
@AWBL3 жыл бұрын
Whenever it try to connect to sharepoint it says we couldn’t authenticate with the credentials provided. Not sure why this is an issue, I logged into my Microsoft account just fine. Wonder what I’m missing...
@dhumanizer993 жыл бұрын
Apparently it's not needed for the rest of the video. So simply follow along and it'll be fine :) . Had the same issue
@hkohila3 жыл бұрын
Hello Chelsea, I Cannot download Day3 workfiles. The PBIX file is larger than the allowed download size on your onedrive. Please advise. Thanks
@karencrump97423 жыл бұрын
Any updates on this problem? I have tried several times as well to get the workfiles. Course is great but so frustrating when you can get the work files. Thanks!
@oscarmorton37823 жыл бұрын
Download the entire zip file, solved the problem for me
@MohammedSaad-yx7jc4 жыл бұрын
Thanks for all the knowledge and training, it was superb
@noshortcuttoglory64434 жыл бұрын
Thank you. Great presentation.
@elrevesyelderecho4 жыл бұрын
2:03:53 why you don't use SelectedValue or created a what if scenario?
@pabeader19414 жыл бұрын
Were those available 3 years ago?
@elrevesyelderecho4 жыл бұрын
@@pabeader1941 Yes.
@raduandreicosmin4 жыл бұрын
thx for pointing out a more straight-forward way to do this
@harshalpatil21113 жыл бұрын
Very Well done !!!
@LearnitTraining3 жыл бұрын
Thank you for the kind words Harshal and an extra big thank you for subscribing!
@candytang11234 жыл бұрын
Thank you so much Chelsea for creating the best Power BI course! I’ve got one question, at 1:49, why do the results of the measure % TotalSales of Parent Category turn out to be percentages of total sales? Isn’t the measure TotalSales All ProductSubcategories supposed to keep filters in the Product table while negating all the filters in the ProductSubcategory table? For example, in the first row, it should be the total sales of Bluetooth Headphones divided by the total sales of Audio, since Audio has been filtered out before ALL(product subcategory) function is applied, and according to the order of operations, Product Category table is in a higher position. Please help me out...
@bertoncx Жыл бұрын
i have the same question
@srinivaschodavarapu78353 жыл бұрын
I am very very Happy to hear 'everytime' from Chelsea, when you she says "Friendly Calculate Function" 🌝
@LearnitTraining3 жыл бұрын
Me too!
@PSB1203 жыл бұрын
Thank you 👍
@LearnitTraining3 жыл бұрын
No problem 👍
@manishashah26443 жыл бұрын
i cant find the facts table in wrorkfiles
@aiqiliang44284 жыл бұрын
Great course! Thanks!
@RaviKiranPeethala4 жыл бұрын
Great course and thank you for the Brilliant course
@DeepakJaiswal-pg8zg4 жыл бұрын
Thank you
@LearnitTraining3 жыл бұрын
You're welcome!
@biswajeetnag014 жыл бұрын
very well explained details
@zhed703 жыл бұрын
Amazing video and very helpful!
@LearnitTraining3 жыл бұрын
Glad it was helpful!
@AbhinavSingh-oq7dk3 жыл бұрын
@@LearnitTraining you could also reply to doubts related to power bi asked in comments section, no?
@waynethurman21443 жыл бұрын
Excellent!
@LearnitTraining3 жыл бұрын
Thank you! Cheers!
@williamkiong19983 жыл бұрын
Great 3 videos! Totally worth the hours!
@LearnitTraining3 жыл бұрын
Glad you enjoyed it William Kiong!
@JC-tq4tg3 жыл бұрын
Hi, is there an alternative source on where I can get the files from sharepoint? I kept on trying to sign in for me to access it but it's always denied.
@LearnitTraining3 жыл бұрын
Hi J! The link is an open link so there are not any security settings on our end blocking access. We definitely recommend checking if you have a limit on the download size for files on you computer as that is typically the main culprit.
@scottsampson59113 жыл бұрын
this step appears to require an office 365 account that my organization doesn't have
@debanshumajumdar97903 жыл бұрын
I can't connect with the sharepoint link. Error message:"we couldn't authenticate with the credentials provided. Please try again."
@ivangroznins3 жыл бұрын
Me too. I got the same message.
@mohamedabdelmohsen23204 жыл бұрын
nice content thank you
@jsandeepk3 жыл бұрын
I don't have a office 365 account. How do I follow your instructions and complete the lab? Can I get a free account?
@LearnitTraining3 жыл бұрын
Hi Sandeep! You can start with Power BI for free.
@nepoata773 жыл бұрын
Hi! I have a problem and I really hope you can help me. In the beginning of the lesson, I can't get data from sharepoint online. I can't access it with anonymous and when I log in, I get the message "We can't authenticate with the credentials provided". Is there a solution? Thank you!
@LearnitTraining3 жыл бұрын
Hi Nepoata - that data set will not be used for the class, it is just a demo of SP site.
@nepoata773 жыл бұрын
@@LearnitTraining Thank you!
@DinoAMAntunes4 жыл бұрын
Hello, give me Give me this error Details: "Access to the resource is forbidden."
@prashantb42664 жыл бұрын
yes i am getting same error
@michaelreed58314 жыл бұрын
Yip. The same issue for me too. Help?
@garyxia64154 жыл бұрын
excellent course, looking forward to day 4 and day 5 upload also.