- Видео 63
- Просмотров 670 995
Miss Microsoft
Южно-Африканская Республика
Добавлен 19 фев 2021
If you love making things work smarter with Power Query and Power BI then you've come to the right place!
Through my videos, I’ll guide you step-by-step into the heart of Microsoft's powerful Business Intelligence tools, unravelling their mysteries into something you can understand and use right away. It's not just about learning; it's about making real progress and seeing the impact in your day to day work.
Whether you're a curious beginner eager to automate your first dataset, or a seasoned enthusiast looking to refine your craft, you've found a community that gets you.
This channel is on a journey to make automation accessible to everyone, we're creating a community of data enthusiasts ready to take on any challenge.
Here's to hoping that these videos not only educate but inspire you to reach your goals and aspirations!
Through my videos, I’ll guide you step-by-step into the heart of Microsoft's powerful Business Intelligence tools, unravelling their mysteries into something you can understand and use right away. It's not just about learning; it's about making real progress and seeing the impact in your day to day work.
Whether you're a curious beginner eager to automate your first dataset, or a seasoned enthusiast looking to refine your craft, you've found a community that gets you.
This channel is on a journey to make automation accessible to everyone, we're creating a community of data enthusiasts ready to take on any challenge.
Here's to hoping that these videos not only educate but inspire you to reach your goals and aspirations!
Combine & Transform Financial Statements: Make Your Analysis Easier!
Are you struggling to pull meaningful insights from your income statements or trial balances? In this video, I’ll walk you through transforming these financial statements into analysis-ready data, making your reports both actionable and easy to understand.
Whether you’re new to financial analysis or looking to deepen your skills, this video breaks down practical techniques for reshaping your income statements and trial balances. Follow these steps to automate your transformations and make impactful analysis a breeze!
✅Please click here to download the practice files: buymeacoffee.com/missmicrosoft/e/328518
✅ Please see links to videos mentioned in this video:
ruclips.net/video/MMF3bNXqT2c/ви...
Whether you’re new to financial analysis or looking to deepen your skills, this video breaks down practical techniques for reshaping your income statements and trial balances. Follow these steps to automate your transformations and make impactful analysis a breeze!
✅Please click here to download the practice files: buymeacoffee.com/missmicrosoft/e/328518
✅ Please see links to videos mentioned in this video:
ruclips.net/video/MMF3bNXqT2c/ви...
Просмотров: 811
Видео
Combine Multiple Excel Files with Inconsistent Column Headers - No Coding & No Formulas Needed
Просмотров 2,2 тыс.4 месяца назад
Easily combine data when you have inconsistent column headers. The process involves using just your Power Query interface without the need for any coding or formulas! By following these steps, you can ensure your reports are automated with consistent and uniform column headers. ✅Please click here to download the practice files: buymeacoffee.com/missmicrosoft/e/277188 ✅ Please see links to video...
Create Your Own Easy Fiscal Year Calendar When 1 January is Not The Start Date | Power BI
Просмотров 1,4 тыс.5 месяцев назад
If your fiscal year does not start on January first, then you need to know about the most important date of your life Its going to help you analyse your data accurately by fiscal year, quarter, month, week and even day! Please click here to get the practice file and guide: buymeacoffee.com/missmicrosoft/e/258842 ✅ Please see links to videos mentioned in this video: 🎦 Measures versus Calculated ...
Combine Multiple Excel Files with Inconsistent Column Headers the Right Way!
Просмотров 8 тыс.7 месяцев назад
Easily combine multiple Excel files with inconsistent column headers in just four steps. And when new data is added you just need to hit refresh and your data is updated automatically even if your new data has completely different column names to your original data! Please click here to download the practice file: docs.google.com/spreadsheets/d/1lE0ciIHjcC30DZ7w3-nmrKTTNWlZEvw5/edit?usp=sharing...
Automate Like a Pro: Easy Refresh Macro for Power Query Reports!
Просмотров 5 тыс.Год назад
Learn how to create a refresh macro that will allow your reports to update automatically with just the click of a button. No more right click ➡️Refresh, just hit your Refresh macro and your reports update automatically. This is a game-changer for anyone looking to streamline their data analysis and reporting process in Power Query. 💡 Please click here if you would like to subscribe to "The Quer...
Don’t Skip These: The 4 Easiest Power Query Transformations You Must Try
Просмотров 3,4 тыс.Год назад
Learn how to create some nifty yet practical Power Query transformations using functions readily available to you in Power Query, such as Drill Down, Group By, Statistics, Custom Columns, Conditional Columns, and Merge. 💡 Please click here if you would like to subscribe to "The Query Editor" newsletter where you will receive Power Query tips, tricks and exclusive discounts to my upcoming course...
Effortlessly automate with Power BI & Power Automate in 4 Easy Steps
Просмотров 6 тыс.Год назад
In this Power BI tutorial, I'll guide you through the hassle-free process of how to send Power BI email alerts to anyone using Power Automate. ✅ Please see link to video mentioned in this video: 🎦Master Power BI: Create Your Own Easy Fiscal Year Calendar: ruclips.net/video/Lt_nNLQz0IE/видео.html ✅ If you would like to connect on LinkedIn: 🤝 www.linkedin.com/in/missmicrosoft ✅ If you would like ...
Master Power BI: Create Your Own Easy Fiscal Year Calendar
Просмотров 19 тыс.Год назад
In this Power BI tutorial, I'll guide you through the hassle-free process of creating a fiscal year calendar. Whether you're a data analyst or Power BI enthusiast, this step-by-step guide is perfect for beginners and experienced users alike. Having a fiscal year calendar is crucial for meaningful data analyses and decision-making. With this simplified approach, you'll master the art of building...
Don't Skip This: The Crucial First Step of the Pros
Просмотров 4,8 тыс.Год назад
Learn the crucial first step that Power Query Advanced users and Power BI Pro users take in these four examples using Power Query, Power Pivot and Power BI. Please download the practice file here: drive.google.com/drive/folders/1HYopUkC_RRiEv5-iKXh9uKMZLMyem5qB?usp=sharing Timestamps: 00:00 What's the Crucial First Step of the Pros? 00:24 Example 1 - Power Query 06:17 Example 2 - Power Pivot 08...
The #1 Mistake You're Making in Your Queries
Просмотров 37 тыс.Год назад
Have you ever encountered the dreaded "the table of the column wasn't found error" or the elusive "The key didn't match any rows in the table" error in Power Query? In this video, I will address a common mistake that many people make when creating queries and show you how to avoid that mistake by making your queries more dynamic. I'll explain what these errors mean and provide solutions to fix ...
Measures Versus Calculated Columns in DAX and Power BI - All You Need to Know
Просмотров 2,7 тыс.Год назад
In this Power BI DAX tutorial you will learn the crucial differences between measures and calculated columns in DAX and Power BI. Discover the secrets of creating measures and calculated columns that will transform your data analysis. Gain a deep understanding of the nuances between filter context and row context, and harness the full potential of SUM and SUMX (a powerful iterating function). S...
2 Power Query Refresh Secrets Everyone Should Know!
Просмотров 21 тыс.Год назад
In this video learn how to effortlessly refresh your queries in Power Query with just the latest data and how to prevent your files from being overwritten so that you’re not losing valuable insights when you hit refresh. Please download the practice file here: drive.google.com/drive/folders/1eoFtKEU6YKYxORmcD5qcFj6LMM-r4gqS?usp=share_link Matt Allington's blog: exceleratorbi.com.au/self-referen...
Create Power Query Parameters For Collaboration And Flexibility.
Просмотров 2 тыс.Год назад
Learn how to create Power Query Parameters to enable collaboration with your colleagues to make your queries more flexible and reusable. Please download the practice file here: drive.google.com/drive/folders/1L_1x3-G2RF8Sw5tM6KGETQYnuqm7JOm6?usp=sharing 00:00 The scene 00:36 Step 1 01:19 Step 2 03:50: Step 3 06:00 Step 4 ✅ If you would like to connect on LinkedIn: 🤝 www.linkedin.com/in/missmicr...
14 Power Query Hacks that Feel Illegal to Know
Просмотров 6 тыс.Год назад
14 Power Query Hacks that Feel Illegal to Know
How to Combine Multiple Excel Sheets with Power Query the RIGHT WAY 🤫
Просмотров 6 тыс.Год назад
How to Combine Multiple Excel Sheets with Power Query the RIGHT WAY 🤫
Leila Gharani’s Top 10 Tips for Power BI Success
Просмотров 2 тыс.Год назад
Leila Gharani’s Top 10 Tips for Power BI Success
10X Your Power Query Skills with ChatGPT
Просмотров 13 тыс.Год назад
10X Your Power Query Skills with ChatGPT
Power BI: The Ultimate Beginner's Tutorial
Просмотров 2,3 тыс.Год назад
Power BI: The Ultimate Beginner's Tutorial
How to Combine Multiple Files with Inconsistent Column Headers into a Single Sheet
Просмотров 49 тыс.2 года назад
How to Combine Multiple Files with Inconsistent Column Headers into a Single Sheet
The ONE Useful Power Query Function You Wish You Knew Earlier!
Просмотров 1,9 тыс.2 года назад
The ONE Useful Power Query Function You Wish You Knew Earlier!
A Key Example to Unlock the Potential of List.Accumulate in Power Query
Просмотров 5 тыс.2 года назад
A Key Example to Unlock the Potential of List.Accumulate in Power Query
The Secret to List.Accumulate in Power Query
Просмотров 16 тыс.2 года назад
The Secret to List.Accumulate in Power Query
How to Create Killer Calculations 04 - Become a Power Query Pro - The Series
Просмотров 2,6 тыс.2 года назад
How to Create Killer Calculations 04 - Become a Power Query Pro - The Series
How to Automate the S&P500 in Excel - Become a Power Query Pro 03 (Create Killer Calculations)
Просмотров 2,5 тыс.2 года назад
How to Automate the S&P500 in Excel - Become a Power Query Pro 03 (Create Killer Calculations)
How to Create Killer Calculations 02 - Become a Power Query Pro - The Series
Просмотров 1,9 тыс.2 года назад
How to Create Killer Calculations 02 - Become a Power Query Pro - The Series
Become a Power Query Pro in Three Minutes and Thirty Seconds
Просмотров 2,3 тыс.2 года назад
Become a Power Query Pro in Three Minutes and Thirty Seconds
8 Powerful Power Query Transformations You Must Know
Просмотров 12 тыс.2 года назад
8 Powerful Power Query Transformations You Must Know
Create a Dynamic File Path from SharePoint & Change the Power Query Source Based on an Excel Cell
Просмотров 13 тыс.2 года назад
Create a Dynamic File Path from SharePoint & Change the Power Query Source Based on an Excel Cell
How to Fix Formula.Firewall Error in Power Query
Просмотров 13 тыс.2 года назад
How to Fix Formula.Firewall Error in Power Query
I love you❤
Que bien lo explicas!!! Sigue así!!
Thanks!
Thank you so much for your kind support! Greatly appreciated!
Very good...Thank you!
You’re most welcome!
Takk!
Thank you so much!!! I appreciate your kind support 😊
Wow! Great video! 💪 Do yout think, is there any solution for union in PQ .xlsx files with difrerend numbers of columns and order? Ex. file 1 has col. A, B, C. File 2 has col. B, C, D. FIle 3 has col. A, B, C, D. File 4 has col. A, C, B. In the end i want to get ALL files from folder in 1 table with col. A, B, C, D (all colums). Is it possible?
Gives me an error stating function cannot find a base column of DateTime type in model....
Thanks so much given the super TIP.
Hi, great video and process, thank you. It seems like this will be a one-time query and the new combined file wouldn't update if users add or change data in the original files, is that correct?
Very useful tutorial. You deserve more subscribers!!
Absolute masterpiece
Thanks for the concise and clear explanation.
Thanks!
You’re welcome ☺️
Thank you so much Heishoi for your kindness and support! Super appreciate it!!!!
@MissMicrosoft love your videos, they are great
Thank you ☺️
Awesome 👍👍👍
Glad you enjoyed the video!
Another gem of a tutorial from my favorite power query instructor. Keep it up and more upload of videos like this
This made my day!!! Thank you Lars ☺. I'm so glad the videos are helpful!
Excellent tutorial 👌
Thank you Alex!
hi meslisa
From how many days I am waiting for your videos please upload videos weekly 🙏 Your videos are really helpful
Thank you so much for your support and kind words! I’m glad the videos are helpful. As for uploading weekly, my 9 to 5 keeps me extremely busy!
This has helped me enormously with changing sheet name,t ahnk you so much.
Bad teacher
Awesome video, just what I needed. Thank you Miss Microsoft!
Nicely explained! Thank you very much.
Thank you very much for making this video. I found it well detailed, easy to follow and extremely helpful!
too cool. Thanks
For some reason, this isn't working for me. The macro is tied to the button but clicking the button does nothing. Is there anything I should check?
Excellent channel. Spoken clearly and at a perfect pace. I've learned a lot from you. Thank-you.
Excellent video. I'm curious... can one use the value from the Excel cell to pass directly to the parameter? For example, if I wanted the parameter itself to dynamically change based on the month entered, is there a way to do this? I'm wanting to be able to pass the data input to a SQL query.
What a great tip. Remove other columns.
Thank you for excellent video
why doesn't it save? everytime i open the file its back to leaving zero ot
Thankyou for the solution i searching for this - but my problem is link is not dynamoc as it is not fetching file path dynamically
thk u❤
Its working. Thank you.😀
I have to repeat what another user said: Best video on this subject on RUclips so far. Thank you.
😂😂😂 your highly funny
How can I pass the value in mysql query dynamically from the report section whatever user selected in filter 1) users select a single date that date should pass on my store procedure which I am calling in power bi while fetching the data from database How can I achieve this please help..
finally i found the video that i was looking for! This video has an obvious explanation, not too fast, so easy to follow. Thank you very much, you save my day. Just clicked Subscribe.
Great explanation! Thank you!
In my case it was referring to the PowerBI workspace i have used to create the dataflow to which I have connected excel. People who will not have access to the particular workspace, will get this error as well. Error message is not very intuitive if you ask me :)
Awesome and simple to follow
Thank you so much. Solved my exact problem!
A very good use of UI instead of codes. Wonderful.
Thank you so much for this very clear explanation! 🙏
Thanks
Thank you!!!
Flashing subtitles is not an accessible way to communicate.
Super. I had a very strong need to be able to do this and you solved it. A fellow South African I believe😁
Oh!! that is so smart!! i couldn't have thought of that! thank you so much, sis :) BTW I've missed you a lot. god bless
Hello, the query files do not have the spreadsheets to load or the folder for the path. queries are broken.😢
Hi Daniel, please accept my sincere apologies, I've emailed you the files. Please let me know if you've received them?
hello, I received the files, thank you for your attention!
Glad to hear!