How do your communicate with applications that don’t have connectors in Power Automate? The answer is HTTP requests. HTTP allows you to expand Power Automate to virtually any application through the concept of REST APIs. In this video, Henry goes Continue reading “How To Make Simple HTTP Requests in Power Automate”
Month: February 2022
New Excel Formula Editor Debuts – 2466
Big news today for Win / Mac / Online versions of Excel. A new Advanced Formula Editor will make LAMBDA and LET far easier. Among the highlights:
New Advanced Formula Editor (Windows, Mac, Online)
Share Lambda through GitHub
Better Recursion Limits (16x Continue reading “New Excel Formula Editor Debuts – 2466”
Addressing Troublesome Time Intelligence Issues In Power BI
In today’s video, Brian will provide some additional techniques and tips for dealing with common problems caused by weekly granularity in time intelligence calculations.
***** Video Details *****
00:00 Introduction
01:51 The problem
02:05 Data model
04:28 CROSSJOIN
09:29 Snowflake schema pros & cons
10:15 TREATAS
***** Continue reading “Addressing Troublesome Time Intelligence Issues In Power BI”
Mastering DAX Calculations Now In Udemy
Access the full course here: https://www.udemy.com/course/mastering-dax-calculations/?referralCode=18B80C2AF9591760B188
As you know, we’ve expanded our reach by joining Udemy. Mastering DAX Calculations course is now made available in the platform.
This training will take you from a beginner to advanced user of Continue reading “Mastering DAX Calculations Now In Udemy”
REPLAY Power BI tips from the Pros – LIVE w/ Matthew Roche (Feb 5, 2022)
Join us live as we answer your questions about Power BI! With special guest, Matthew Roche!
Connect with Matthew:
Twitter: https://twitter.com/SQLAllFather
YouTube: https://www.youtube.com/channel/UCpsilPn-2qFlrYYuvyFkpPQ
Website: https://ssbipolar.com/
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public Continue reading “REPLAY Power BI tips from the Pros – LIVE w/ Matthew Roche (Feb 5, 2022)”
Highline College Advanced Excel – Busn 218 – Winter 2022 Quarter Introductory Video
Busn 218, Advanced Excel – Busn 218 (Spreadsheet Construction) class taught by Excel MVP Mike Girvin at Highline College. This is the intro video for matriculating students at Highline College in winter quarter, 2022.
This is the intro video for matriculating Continue reading “Highline College Advanced Excel – Busn 218 – Winter 2022 Quarter Introductory Video”
Excel Statistical Analysis for Business – Busn 210 – Winter 2022 Quarter Introductory Video
Busn 210, Excel Statistics for Business class taught by Excel MVP Mike Girvin at Highline College.
This is the intro video for matriculating students at Highline College in winter quarter, 2022.
To watch at YouTube here is the playlist: rel=”nofollow”>https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN
The videos for this class will be released each week over the next few months.
Financial Reporting Course Now In Udemy
Check the full course here: https://www.udemy.com/course/financial-reporting-power-bi/?referralCode=A7D888AEA9E3D7F80A2F
The course contains a number of real-world tips and techniques for financial reporting development work using Power BI. By using the unique ideas and concepts reviewed in detail throughout this course you Continue reading “Financial Reporting Course Now In Udemy”
Tulalip Skate-BMX Park Sunday Rad: Two Old Guys and a Kid!
Isaac “Iceman” Girvin, Mike “Magic” Girvin (excelisfun at YouTube) and Nick “Rad 67” Roth get rad at Tulalip BMX Skatepark on Sunday Sep 19, 2021. Not Big Air. No Big Tricks. Just Old Guys having fun! Old Guys Just Wanna Continue reading “Tulalip Skate-BMX Park Sunday Rad: Two Old Guys and a Kid!”
Old Guy BMX Racing, then Park Riding: SeaTac BMX Track and Burien Park BMX: Rad Fun!
Mike “Magic” Girvin (excelisfun at YouTube) and Nick “Rad 67” Roth get rad racing at SeaTac BMX Track with Aaron “Trickster” Edwards and Eric “The Professor” Altendorf.
Then Nick Roth and Magic hit Burien BMX Park for some park fun!
Washington BMX Continue reading “Old Guy BMX Racing, then Park Riding: SeaTac BMX Track and Burien Park BMX: Rad Fun!”
How To Combine Multiple IF Formulas In Excel – 2465
You wrote some IF functions to assign a score based on numerical ranges. You want to combine those formulas into a single long Excel formula. This video will show you how to do it and how to avoid some pitfalls.
Along Continue reading “How To Combine Multiple IF Formulas In Excel – 2465”
From Intern To Founder – A Data Analytics Journey
Today’s video is a continuation of our ongoing series exploring different elements of Data Analytics careers. Brian haves a chat with Haroon Ali, co-founder of Stellify BI, a top-flight business intelligence consulting firm in the UK.
In just six short years, Continue reading “From Intern To Founder – A Data Analytics Journey”