- 63
- 687 009
Miss Microsoft
South Africa
Приєднався 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:
ua-cam.com/video/MMF3bNXqT2c/v-deo.html
ua-cam.com/video/da6aveXXC7U/v-deo.html
ua-cam.com/video/DPr4bNFsr-4/v-deo.html
✅ If you would like to subscribe to my free newsletter where I provide even more Power BI and Power Query tips and tricks, please click here: thequeryeditor.beehiiv.com/
✅ If you would like to connect on LinkedIn: www.linkedin.com/in/missmicrosoft/
✅ If you would like to support the channel by buying me a coffee, (it's really quick and easy), please use this link: ☕www.buymeacoffee.com/missmicrosoft
✅ For more videos please subscribe: ua-cam.com/channels/cZhWH_xKNZFIBbBjz1VsWw.html
00:00 The End Result
00:23 Income Statement Transformation for Analysis
06:30 Trial Balance Transformation for Analysis
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:
ua-cam.com/video/MMF3bNXqT2c/v-deo.html
ua-cam.com/video/da6aveXXC7U/v-deo.html
ua-cam.com/video/DPr4bNFsr-4/v-deo.html
✅ If you would like to subscribe to my free newsletter where I provide even more Power BI and Power Query tips and tricks, please click here: thequeryeditor.beehiiv.com/
✅ If you would like to connect on LinkedIn: www.linkedin.com/in/missmicrosoft/
✅ If you would like to support the channel by buying me a coffee, (it's really quick and easy), please use this link: ☕www.buymeacoffee.com/missmicrosoft
✅ For more videos please subscribe: ua-cam.com/channels/cZhWH_xKNZFIBbBjz1VsWw.html
00:00 The End Result
00:23 Income Statement Transformation for Analysis
06:30 Trial Balance Transformation for Analysis
Переглядів: 864
Відео
Combine Multiple Excel Files with Inconsistent Column Headers - No Coding & No Formulas Needed
Переглядів 2,4 тис.5 місяців тому
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,6 тис.6 місяців тому
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 тис.8 місяців тому
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!
Переглядів 6 тис.Рік тому
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,5 тис.Рік тому
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: ua-cam.com/video/Lt_nNLQz0IE/v-deo.html ✅ If you would like to connect on LinkedIn: 🤝 www.linkedin.com/in/missmicrosoft ✅ If you would like t...
Master Power BI: Create Your Own Easy Fiscal Year Calendar
Переглядів 20 тис.Рік тому
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
Переглядів 40 тис.Рік тому
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!
Переглядів 22 тис.Рік тому
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
Переглядів 7 тис.Рік тому
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,1 тис.Рік тому
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 тис.2 роки тому
Power BI: The Ultimate Beginner's Tutorial
How to Combine Multiple Files with Inconsistent Column Headers into a Single Sheet
Переглядів 50 тис.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!
Переглядів 2 тис.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
Переглядів 2 тис.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