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