👉 Important files: ◉ Download student files - share.hsforms.com/1DW6j0yH2RY-dFcomVMMkPg8xue ◉ Certificate of Completion - share.hsforms.com/1JYYgjCoITT-7M3O8SMRTjg8xue

@Funway20

Жыл бұрын

Why to fill all details like name email id Company name and phone number to download File Such details need to share in website

@raquieldanadu1175

Жыл бұрын

Please dear, these source files are corrupted, How can I get the correct ones to follow the course along...

@PragmaticWorks

Жыл бұрын

@@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!

@raquieldanadu1175

Жыл бұрын

@@PragmaticWorksthanks, I’ll try

@desktopdatacrunching4032

Жыл бұрын

@_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.

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.

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!

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.

@PragmaticWorks

2 жыл бұрын

You are so welcome!

You blew my mind. The way you explain is AMAZING. Thank you 🙏

Jonathon Silva you are a great educator and presenter, thanks very much!

@PragmaticWorks

Жыл бұрын

Thank you for watching!

I dont even use any of the software in this video and I stayed till the end, excellent video

@PragmaticWorks

Жыл бұрын

Thanks for watching!

This video was very usefull, This is one of the best free webinars that I have seen yet

Fantastic training Jonathan. Thanks and God bless you.

@PragmaticWorks

Жыл бұрын

Glad you enjoyed it

Amazing presentation, was able to understand and do the stages on my own, thanks to your excellent teaching skills!

@PragmaticWorks

Жыл бұрын

Glad it was helpful! Thank you!

Another excellent course from you guys. Thank you for sharing and greetings from Denmark:)

@PragmaticWorks

2 жыл бұрын

Thanks for watching!

This one of my favorite course to watch. From Cambodia.

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.

Fantastic journey. Thanks a lot for this great session. Best regards, Carlos

@PragmaticWorks

2 жыл бұрын

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

@PragmaticWorks

Жыл бұрын

Glad you enjoyed! Thank you!

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.

Thank you! for the awesome webinar/class.

44mins into this tutorial.... Thank youuuu

@PragmaticWorks

Жыл бұрын

You're welcome!!

Just wow. Oh, and thank you.

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

Excellent work... i really liked the last one hr...

Great video - Thanks!

Fabulous tutorial !!! thanks for sharing 👍👍

@PragmaticWorks

2 жыл бұрын

Glad you enjoyed!

It was great. Thanks.

Such A great video! What do you use as software to write on screen like you do?

Amazing content and smooth content delivery.

@PragmaticWorks

Жыл бұрын

Much appreciated!

excellent tutorial !!! thanks a lot

@PragmaticWorks

2 жыл бұрын

Glad you liked it!

Excellent work!

@PragmaticWorks

Жыл бұрын

Glad you like it! Thanks!

I am excited with this super information.

Very nice and complete presentation. Thank you!!!

@PragmaticWorks

2 жыл бұрын

Glad you enjoyed!

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.

Watching this at 1.25x speed makes the resemblance to Ludwig so uncanny hahaha. Great video and great explanation!

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.

Thanks for this video

@PragmaticWorks

Жыл бұрын

Most welcome!

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

@GROWINGBUSINESSESBETTER

2 жыл бұрын

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.

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.

thanks for sharing

@PragmaticWorks

Жыл бұрын

Thanks for watching!

Hey could show how the jet engine part listing was done.

Is this a good start for someone who only barely knows excel, or are there any pre-requisites that one should be familiar with ?

great video

@PragmaticWorks

2 жыл бұрын

Glad you enjoyed!

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?

Great tutorial 👍🏼👍🏼👈

@PragmaticWorks

Жыл бұрын

Thank you 👍

@ihgamingfun6295

Жыл бұрын

@@PragmaticWorks welcome👍🏼👍🏼

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

what is the software you use to make this video?

Kankakee - I lived there for a while it's pronunciation is "Can - ka - key"

*you look like one of my counsins*

Take a shot every time he says leverage

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?

@Jonathon_Silva

Жыл бұрын

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.

@zubiamasood9571

Жыл бұрын

@@Jonathon_Silva Thanks.

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

Жыл бұрын

The files look fine. Please double check that you have unzipped the files before you attempt to pull data from it.

@KingCAMBO

Жыл бұрын

@@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?

@pin-jiecheng1833

4 ай бұрын

@@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

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

@PragmaticWorks

Жыл бұрын

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!

😀

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.