- 34
- 221 187
Exceed Learning
Croatia
Приєднався 31 бер 2020
Welcome to Exceed Learning!
We share educational videos related to the Microsoft Business analytics stack. Our goal is to help you improve your data analysis skills and increase your opportunities in the dynamic business environment.
We create videos on Power Query, Power BI, DAX, data modeling, and Excel.
Our videos are based on practical examples that are the result of multiple years of experience in working with multinational companies in the field of Business intelligence.
More from us on: exceed.hr/en/home/
Check out our Power Query Fundamentals course!
exceed.hr/en/academy/powerquery-fundamentals/
Subscribe if you'd like to improve your Power BI skills.
We share educational videos related to the Microsoft Business analytics stack. Our goal is to help you improve your data analysis skills and increase your opportunities in the dynamic business environment.
We create videos on Power Query, Power BI, DAX, data modeling, and Excel.
Our videos are based on practical examples that are the result of multiple years of experience in working with multinational companies in the field of Business intelligence.
More from us on: exceed.hr/en/home/
Check out our Power Query Fundamentals course!
exceed.hr/en/academy/powerquery-fundamentals/
Subscribe if you'd like to improve your Power BI skills.
Combine multiple Excel files using custom M functions
This video will show you how you can create a custom M function that is going to clean messy table structure and then use that function to iterate through multiple Excel files, connect to the specific sheets and clean them in the same fashion.
You can download the files and solution on this link:
exceed.hr/wp-content/uploads/Solution.zip
👉Need more assistance? Check our website at exceed.hr/en/services/
#powerbi #excel #data #m
You can download the files and solution on this link:
exceed.hr/wp-content/uploads/Solution.zip
👉Need more assistance? Check our website at exceed.hr/en/services/
#powerbi #excel #data #m
Переглядів: 3 828
Відео
Combine multiple Excel files using PowerQuery
Переглядів 23 тис.2 роки тому
This video will show you how you can connect to a folder and then process multiple Excel files with table-like structures. It is an easy-to-follow video that will also explain the M function called Excel.Workbook 👉Need more assistance? Check our website at exceed.hr/en/services/ #powerbi #excel #data #m
PowerQuery M code explanation (for Excel newcomers)
Переглядів 4,3 тис.2 роки тому
In this video we will show the similarities between Excel and M formula language! They are both functional languages with a few important differences. 👉Need more assistance? Check our website at exceed.hr/en/services/ #PowerBI #M #Excel
Row Context DAX vs PowerQuery M Language
Переглядів 1,2 тис.2 роки тому
Row context exists both in DAX and M. We can use the similarities between the two languages to explain the row context in an easier-to-follow way. 👉Need more assistance? Check our website at exceed.hr/en/services/ #powerquery #dax #rowcontext #data
Dynamic Coalesce in Power Query ( Record.SelectFields() )
Переглядів 3,2 тис.2 роки тому
In this video we show you how to perform coalesce on a dynamic selection of columns using Record.SelectFields() function, an extremely important one when dealing with record type M objects! 👉We also wrote a blog on this topic that you can find in the following link: exceed.hr/blog/dynamic-coalesce-in-powerquery/ 👉To learn more about Power Query, check out our Power Query fundamentals course: ex...
Rename first N columns in Power Query
Переглядів 3,6 тис.2 роки тому
In this video, we show you how to form a dynamic rename columns feature using applied steps to form intermediate variables that will be used in later parts of the M code! To provide a solution, we use a bit of advanced #M coding and explain how to use the List.Zip function to create a list of nested lists, but it is an extremely interesting topic! 👉To learn more about Power Query, check out our...
Reverse fill down (Unfill) in Power Query
Переглядів 2,7 тис.2 роки тому
You've probably already met with fill-down operation in Power Query, but this time we show you 2 techniques of unfill or reverse fill operation!! Although the first technique is faster, the second one hides complexity which could help you in more advanced scenarios. Check out both and tell us how you like it! See you soon with more videos! 👉To learn more about Power Query, check out our Power Q...
How to find if your product/event falls inside of a promotion period with Power Query
Переглядів 1,3 тис.3 роки тому
Ever needed to check if your product was sold in a specific time period based on start and end date? In this #PowerQuery video, we will explore how to implement such feature using advanced M scripting. We will deal with iterators and nested environments, so prepare to learn more about internals of M language! Hope you enjoy it! To learn more about Power Query, check out our Power Query fundamen...
Select column to filter upon based on text input or position (Power Query Record.Field function)
Переглядів 4,8 тис.3 роки тому
In this video, we are showing how to dynamically filter table based on column position or text input using Power Query M Language. This approach can be used when the column names you need to filter upon often change or you wish to filter column names based on parameters. If you have any comments, post it down below! To learn more about Power Query, check out our Power Query fundamentals course!...
Optimizing Pivot operation in Power Query
Переглядів 4 тис.3 роки тому
Considering that classic Pivot operation has a really slow performance when working on large data tables, we introduce you a new trick on how to potentially optimize Pivot operation in Power Query. For any questions, comment down below! To learn more about Power Query, check out our Power Query fundamentals course! exceed.hr/en/academy/powerquery-fundamentals/ #powerquery #powerbi #etltools #da...
Top 5 easy to implement Power Query tricks
Переглядів 1,8 тис.3 роки тому
This time we share 5 easy tricks that can improve your performance in Power Query! In case you know another cool shortcut, feel free to post it in the comments! To learn more about Power Query, check out our Power Query fundamentals course! exceed.hr/en/academy/powerquery-fundamentals/ Timestamps 0:00 Intro 0:34 Trick 1: Filtering 2:06 Trick 2: Opening new Excel file 3:28 Trick 3: Merging with ...
Writeback Planner - Licensing requirements
Переглядів 2493 роки тому
In this video, we are explaining the licensing part and making distinction between what do we charge as Exceed and what should you acquire from the Microsoft site. For more information about the Writeback Planner application, check our website: exceed.hr/en/products/powerbi-planning-forecasting-tool/
Writeback Planner - Teams
Переглядів 1383 роки тому
In this video, we are showing how to create new teams or modify teams so that you can share your plan with the whole organization, a certain team or a certain colleague. For more information about the Writeback Planner application, check our website: exceed.hr/en/products/powerbi-planning-forecasting-tool/
Writeback Planner - Log data changes and comments
Переглядів 1013 роки тому
In this video, we are showing the ability of the app to track changes that are made inside of the plan and the ability to add additional comments that justify the change. For more information about the Writeback Planner application, check our website: exceed.hr/en/products/powerbi-planning-forecasting-tool/
Writeback Planner - Change values
Переглядів 1193 роки тому
In this video, we are explaining how to make changes inside the plan and analyze those immediate changes as they are instantly seen on the visuals. For more information about the Writeback Planner application, check our website: exceed.hr/en/products/powerbi-planning-forecasting-tool/
Writeback Planner - Add and delete rows
Переглядів 1483 роки тому
Writeback Planner - Add and delete rows
Each syntax in PowerQuery explained | Extracting maximum value from a Text delimited column
Переглядів 5 тис.3 роки тому
Each syntax in PowerQuery explained | Extracting maximum value from a Text delimited column
How to add a dynamic run-rate calculation in DAX (PowerBI)
Переглядів 6 тис.3 роки тому
How to add a dynamic run-rate calculation in DAX (PowerBI)
How to process multiple folders with a single Power Query script
Переглядів 14 тис.3 роки тому
How to process multiple folders with a single Power Query script
Dynamically expand table column in Power Query (advanced)
Переглядів 11 тис.3 роки тому
Dynamically expand table column in Power Query (advanced)
Dynamically expand table column in Power Query
Переглядів 17 тис.3 роки тому
Dynamically expand table column in Power Query
How to sort Power BI matrix created with calculation groups
Переглядів 8 тис.3 роки тому
How to sort Power BI matrix created with calculation groups
How to access global environment objects in Power Query
Переглядів 1,2 тис.3 роки тому
How to access global environment objects in Power Query
How to use a Record variable inside the Power Query script
Переглядів 3,8 тис.3 роки тому
How to use a Record variable inside the Power Query script
Invoking custom M functions in Power Query (part 3)
Переглядів 4,4 тис.3 роки тому
Invoking custom M functions in Power Query (part 3)
Creating custom M functions in Power Query (part 2)
Переглядів 2,1 тис.3 роки тому
Creating custom M functions in Power Query (part 2)
Introduction to custom functions in Power Query (part 1)
Переглядів 1,6 тис.3 роки тому
Introduction to custom functions in Power Query (part 1)
Data privacy (Privacy levels) in Power Query/Power BI
Переглядів 8 тис.3 роки тому
Data privacy (Privacy levels) in Power Query/Power BI
Conditional formatting in Power BI with calculation groups
Переглядів 6 тис.3 роки тому
Conditional formatting in Power BI with calculation groups