@@raquieldanadu1175 Hi, these files appear to be working on our end. Please try downloading again from a different browser. Let me know if I can assist further!
This is one of the best free webinars that I have seen. As a long-time Excel user who is relatively new to Power BI, I feel very empowered as data analyst.
Thank you for providing the video on youtube. Due to the time difference, I cannot participate in real-time, but I can come to your youtube channel to watch any time I want. That's great!
Jonathon Silva, you and Pragmatic Works rock so hard! This course is a gem and so very much worthwhile. I watch it over and over. I have a subscription to Pragmatic works and try to take as many courses as possible.
Waou !! Fantastic presentation. You are an amazing trainer. Keep up with the excellent work. It is a privilege to have this free training. Thank you, Pragmatic Works Team.
Great thanks for sharing this unique video over the world during the bad and gloomy period we faced currently, now I am getting my fully understanding after I got your excellent presentation, for me you deserve to subscribe and Dibble like , give more and get our god bless , this is Alaa from Iraq , cheers
Great Job! Thank you for this video. I'm really a newbie to data analysis; also, I have an entry level knowledge of MS Excel. What do I need to focus on to be a data analyst. How long will it take me to really understand the data terms, start cleaning data, and developing dashboards? Thank you once more.
Load all tabs with data to power Query, pre-process the data, and save as connection-only 2. Create the Data Model 3. Using the connection-only query as a reference: a. Create a calculated field called "Actual Balance" and apply new customer discounts » What is the total balance now? What is the average and median of the "actual balances" owed b. Using the Statistics function, what is the highest amount owed c. Split the account ID column by # of characters/by positions; how many Regular, High Risk, Government Affiliate and Premium customers does the company have, respectively? & Show balances owed in each category d. Identify customers that bought additional licenses during the period and for which products e. How much in total did the company lose as discounts during this period? 4. Describe the four steps in data preprocessing and explain how/if they apply with the practice data set you are working with. 5. Present your answers in a Microsoft Word document with Screenshots of all your tables, queries and data model.
Great training. I am looking forward to building my model. You have answered many of my challenges going in. Now I will be looking for your training that will allow me to do everything and stay in Excel (How to create DAX formulas without going into Power BI Desktop first as an example). I suspect I will be signing up for some of your more detailed classes soon.
Great Session. Never knew the power of the Power Apps till this video . Was wondering how you could draw the red squares and arrows on the excel sheet ? Is the tool also available in Excel or Power Query where we can highlight the way you do to focus on the particular area
From what I understand you can use Microsoft Whiteboard and make it transparent, then add Microsoft Whiteboard to OBS Studio (this is a free open-source software) or other video software then you should be able to write on Microsoft Whiteboard on screen where ever you want. May be with Excel on screen, but whatever.
I am a novice excel use having 2019 excel downloaded. i would like to move some of the workbooks into the web version to utilize some of the functionality. how do i import from excel 2019 to excel web
Great webinar. The only thing that would make it fabulous is for you to remove yourself when you're doing PivotTables in Excel, and in PBI working with the Visualization & Data Panes.
Impossible to follow this lesson. The international sales/World sales folder you are talking about at 25:05 time mark is completely empty. I have downloaded the student files three times now.
@@desktopdatacrunching4032 Of course I unzipped it. If had not, I would not even be able to see the folders. I just realized, I CAN see the files in file explorer. It is excel power query that cannot see them. WTF?
@@KingCAMBO Hi, maybe you could try changing the folder name from "Bridging Your Skills from Excel to Power BI" to simpler and shorter name like "Tutorial", it works for me. Because what I found is that the file path is too long and microsoft is unable to read file path more than 256 path name. Based on google, Microsoft Windows has a MAX_PATH limit of ~256 characters
All of these videos on Power BI and Power Pivot are great. But I cannot find a good solution to the following question: What if in Get Data From Folder, after a period of time the format of the source file changes. There is a need for a new column to be added, for example. If we remove a column, that could critically impact downstream calculations already done in Pivot or BI. But are there specific routines to be followed when the source file format changes? I see no videos or articles on this.
This is providing another option to using Power Query, because, you are correct, it is precisely how we could also do it in Power BI. It would be completely dependent on the journey you are looking to take with the report - for me, I like to have the end goals/ visuals in mind and if its simply to produce a PivotTable, staying in Excel would be the way to go.
Hi Jonathon, I am trying to create a project in Excel PowerBI. I need your assistance to build a work allocation tool with specific conditions allocation of tickets to team based on age of tickets, employee tenure or number of tickets to be assigned, capacity, automatically change assignment based on meetings or team members availability, manage and create workflow reports. Thanks, Anil Kumar
Hi! We are so glad that you enjoyed our tutorial. We offer mentoring hours and would love to help you with your project! Please send an email to training@pragmaticworks.com and one of our team members will reach out to you. Thank you!
![Beginner to T-SQL [Full Course]](http://i.ytimg.com/vi/cACat4KNncg/mqdefault.jpg)
![Beginner to T-SQL [Full Course]](/img/tr.png)
![Power BI Dataflows Tutorial and Best Practices [Full Course] 📊](http://i.ytimg.com/vi/GuU6_cqu8FE/mqdefault.jpg)
👉 Important files:
◉ Download student files - share.hsforms.com/1DW6j0yH2RY-dFcomVMMkPg8xue
◉ Certificate of Completion - share.hsforms.com/1JYYgjCoITT-7M3O8SMRTjg8xue
Why to fill all details like name email id Company name and phone number to download File Such details need to share in website
Please dear, these source files are corrupted, How can I get the correct ones to follow the course along...
@@raquieldanadu1175 Hi, these files appear to be working on our end. Please try downloading again from a different browser. Let me know if I can assist further!
@@PragmaticWorksthanks, I’ll try
@_senthan_amudhan_ I'd need to know you're email address to ensure it's sending.
This is one of the best free webinars that I have seen. As a long-time Excel user who is relatively new to Power BI, I feel very empowered as data analyst.
Highly recommended for all who are looking to learn Power BI. Great video. Thanks for your effort.
I dont even use any of the software in this video and I stayed till the end, excellent video
Thanks for watching!
You blew my mind. The way you explain is AMAZING. Thank you 🙏
This video was very usefull, This is one of the best free webinars that I have seen yet
Thank you for providing the video on youtube. Due to the time difference, I cannot participate in real-time, but I can come to your youtube channel to watch any time I want. That's great!
Jonathon Silva you are a great educator and presenter, thanks very much!
Thank you for watching!
You are the best High school teacher ever, Thank you for your background.
This one of my favorite course to watch. From Cambodia.
Jonathon Silva, you and Pragmatic Works rock so hard! This course is a gem and so very much worthwhile. I watch it over and over. I have a subscription to Pragmatic works and try to take as many courses as possible.
I have watched a lot of videos on this stuff, but you brought out many amazing tips no one else has said. Thank you so much for what you do.
You are so welcome!
Fantastic training Jonathan. Thanks and God bless you.
Glad you enjoyed it
Power Pivot changed my life
Another excellent course from you guys. Thank you for sharing and greetings from Denmark:)
Thanks for watching!
Thank you! for the awesome webinar/class.
Fantastic journey.
Thanks a lot for this great session.
Best regards,
Carlos
Glad you enjoyed it!
Excellent Training , Definitely Your Videos make people to be future Leaders in this competitive market , More thanksful best ever training session
Glad you enjoyed! Thank you!
44mins into this tutorial.... Thank youuuu
You're welcome!!
You are an excellent teacher
Amazing presentation, was able to understand and do the stages on my own, thanks to your excellent teaching skills!
Glad it was helpful! Thank you!
Waou !! Fantastic presentation. You are an amazing trainer. Keep up with the excellent work. It is a privilege to have this free training. Thank you, Pragmatic Works Team.
Such A great video! What do you use as software to write on screen like you do?
Great thanks for sharing this unique video over the world during the bad and gloomy period we faced currently, now I am getting my fully understanding after I got your excellent presentation, for me you deserve to subscribe and Dibble like , give more and get our god bless , this is Alaa from Iraq , cheers
Great Job! Thank you for this video. I'm really a newbie to data analysis; also, I have an entry level knowledge of MS Excel. What do I need to focus on to be a data analyst. How long will it take me to really understand the data terms, start cleaning data, and developing dashboards? Thank you once more.
Fabulous tutorial !!! thanks for sharing 👍👍
Glad you enjoyed!
I am excited with this super information.
Watching this at 1.25x speed makes the resemblance to Ludwig so uncanny hahaha.
Great video and great explanation!
Excellent work... i really liked the last one hr...
excellent tutorial !!! thanks a lot
Glad you liked it!
Hey could show how the jet engine part listing was done.
Amazing content and smooth content delivery.
Much appreciated!
Load all tabs with data to power Query, pre-process the data, and save as connection-only
2. Create the Data Model
3. Using the connection-only query as a reference:
a. Create a calculated field called "Actual Balance" and apply new customer discounts
» What is the total balance now? What is the average and median of the "actual balances" owed
b. Using the Statistics function, what is the highest amount owed
c. Split the account ID column by # of characters/by positions; how many Regular, High Risk, Government Affiliate and Premium customers does the company have, respectively? & Show balances owed in each category
d. Identify customers that bought additional licenses during the period and for which products
e. How much in total did the company lose as discounts during this period?
4. Describe the four steps in data preprocessing and explain how/if they apply with the practice data set you are working with.
5. Present your answers in a Microsoft Word document with Screenshots of all your tables, queries and data model.
Is this a good start for someone who only barely knows excel, or are there any pre-requisites that one should be familiar with ?
Very nice and complete presentation. Thank you!!!
Glad you enjoyed!
Excellent work!
Glad you like it! Thanks!
Great training. I am looking forward to building my model. You have answered many of my challenges going in. Now I will be looking for your training that will allow me to do everything and stay in Excel (How to create DAX formulas without going into Power BI Desktop first as an example). I suspect I will be signing up for some of your more detailed classes soon.
Great video - Thanks!
Great Session. Never knew the power of the Power Apps till this video . Was wondering how you could draw the red squares and arrows on the excel sheet ? Is the tool also available in Excel or Power Query where we can highlight the way you do to focus on the particular area
From what I understand you can use Microsoft Whiteboard and make it transparent, then add Microsoft Whiteboard to OBS Studio (this is a free open-source software) or other video software then you should be able to write on Microsoft Whiteboard on screen where ever you want. May be with Excel on screen, but whatever.
Hi Silva. I cant get the data from cms in excel. getting enable javascript error.
The revenue column is a Txt and when I try changing i=the format to a whole number or a decimal it gives me a error?
what is the software you use to make this video?
I am a novice excel use having 2019 excel downloaded. i would like to move some of the workbooks into the web version to utilize some of the functionality. how do i import from excel 2019 to excel web
Great tutorial 👍🏼👍🏼👈
Thank you 👍
@@PragmaticWorks welcome👍🏼👍🏼
Hey please help me , i downloaded the students file and i try to get the file from "get data" I can't see the file , why is that? Please help me
It was great. Thanks.
great video
Glad you enjoyed!
thanks for sharing
Thanks for watching!
Great webinar. The only thing that would make it fabulous is for you to remove yourself when you're doing PivotTables in Excel, and in PBI working with the Visualization & Data Panes.
Just wow. Oh, and thank you.
Impossible to follow this lesson. The international sales/World sales folder you are talking about at 25:05 time mark is completely empty. I have downloaded the student files three times now.
The files look fine. Please double check that you have unzipped the files before you attempt to pull data from it.
@@desktopdatacrunching4032 Of course I unzipped it. If had not, I would not even be able to see the folders. I just realized, I CAN see the files in file explorer. It is excel power query that cannot see them. WTF?
@@KingCAMBO Hi, maybe you could try changing the folder name from "Bridging Your Skills from Excel to Power BI" to simpler and shorter name like "Tutorial", it works for me. Because what I found is that the file path is too long and microsoft is unable to read file path more than 256 path name.
Based on google, Microsoft Windows has a MAX_PATH limit of ~256 characters
Thanks for this video
Most welcome!
All of these videos on Power BI and Power Pivot are great. But I cannot find a good solution to the following question: What if in Get Data From Folder, after a period of time the format of the source file changes. There is a need for a new column to be added, for example. If we remove a column, that could critically impact downstream calculations already done in Pivot or BI. But are there specific routines to be followed when the source file format changes? I see no videos or articles on this.
I have a doubt, Why would we clean up and import data in excel power query etc, when we can do the same in power bi?
This is providing another option to using Power Query, because, you are correct, it is precisely how we could also do it in Power BI. It would be completely dependent on the journey you are looking to take with the report - for me, I like to have the end goals/ visuals in mind and if its simply to produce a PivotTable, staying in Excel would be the way to go.
@@Jonathon_Silva Thanks.
Kankakee - I lived there for a while it's pronunciation is "Can - ka - key"
Why are your paid plans so expensive despite your 75% discounts? You should have a monthly charge which is reasonable.
Hi Jonathon,
I am trying to create a project in Excel PowerBI. I need your assistance to build a work allocation tool with specific conditions allocation of tickets to team based on age of tickets, employee tenure or number of tickets to be assigned, capacity, automatically change assignment based on meetings or team members availability, manage and create workflow reports.
Thanks,
Anil Kumar
Hi! We are so glad that you enjoyed our tutorial. We offer mentoring hours and would love to help you with your project! Please send an email to training@pragmaticworks.com and one of our team members will reach out to you. Thank you!
Take a shot every time he says leverage
*you look like one of my counsins*
😀