My Poem – An Ode to Excel

Written by Magic AI and I

Oh Excel, you’re a sight to behold
Your powers so vast, your secrets untold
Your formulas and charts, they never grow old
Your uses are vast, your features unfold

Your beauty’s unmatched, your power’s divine
Your data so precise, and figures so fine
From pivot tables to macros, you make life sublime
A spreadsheet maven, your use is so prime

Oh Excel, you make the mundane sublime
Your features so strong, all those bold lines
From tracking expenses to uncovering goldmines
You make the mundane task feel more like a sweet rhyme

Your power and ease, it’s hard to describe
Your talents so numerous, they stretch as far as the eye can see
You make the task of data entry so much less of a chore
So, Excel, my dear partner and friend, I thank you for making my work life, oh so much more

Continuing the T-SQL journey with OVER and RANK

Continuing our T-SQL journey, Patrick explores the use of the OVER and RANK functions in combination with common table expressions (CTE) in Azure SQL Database and Azure Synapse Analytics.

RANK (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/functions/rank-transact-sql?view=sql-server-ver16

SELECT – OVER Clause (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-ver16

WITH common_table_expression (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

http://twitter.com/guyinacube
http://twitter.com/awsaxton
http://twitter.com/patrickdba
http://www.facebook.com/guyinacube
Continue reading “Continuing the T-SQL journey with OVER and RANK”

Excel Hold Alt+1 To Repeatedly Run 1st QAT Icon Perhaps Increase Decimal 2368

A cool Excel trick from Geert Delmulle – you can increase decimal repeatedly by holding down Alt+1. This works if you move the Increase Decimal icon to one of the first 9 spots on the Quick Access Toolbar.

Table of Contents
(0:00) Fast Way to Increase Decimal in Excel
(0:47) After Alt key, use 1-9 for first 9 QAT icons
(1:02) Hold Alt+2 to run 2nd QAT icon repeatedly
(2:30) Adding icons to the Excel QAT
(2:54) Moving QAT icon to beginning
(3:06) Finding icons not on Ribbon for QAT
(4:06) Save icon too far left after AutoSave removed

Time Based Cohort Analysis – How To Setup Your Data Model In Power BI

In this tutorial, Sam is going to demonstrate how you can create time based cohort insights within Power BI. You can use this strategy for whatever cohort you’re trying to devise. Cohort Analysis has been popularized by SAS applications. So, you should group your customers based on when they’re churning. You can create incredible analysis in Power BI using this technique.

*****Video Details*****
00:00 Introduction
01:02 Review on cohort analysis
02:06 Creating cohorts
04:58 Cohort Months table
07:39 Cohort analysis insights
10:14 Churning formulas and examples

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To Continue reading “Time Based Cohort Analysis – How To Setup Your Data Model In Power BI”

Hide Excel Pivot Table Rows Using Sets And Then Edit The MDX – 2367

If you need to hide some rows in an Excel pivot table, you can Create a Set Based on Row Items.

This is a rarely used feature: First, it is only available if you choose Add This Data To The Data Model.

Once you create a set, it is a bit strange to remove rows. And if you add data later, you have to go back in to edit the set. Excel offers to let you edit the MDX, but what is MDX?

Thanks to David Jefferson who provided a comment to a YouTube video, he shows how to Continue reading “Hide Excel Pivot Table Rows Using Sets And Then Edit The MDX – 2367”

Excel Suggest The Next Awesome Excel Idea – 2366

Do you love Excel? Do you have a feature that would make Excel easier for you? Write up your idea and post it to the new Feedback Forum for the Excel team. Other people can vote for your idea and many ideas each year are added to Excel.

The Feedback portal for Excel is at: https://feedbackportal.microsoft.com/feedback/forum/c23f3b77-f01b-ec11-b6e7-0022481f8472

Vote for my idea to use the Custom Lists when renaming copied worksheets, vote here: https://feedbackportal.microsoft.com/feedback/idea/13963988-a0a0-ed11-a81b-000d3a0450e3

If you post a great idea at the Feedback forum, let me know the title in a YouTube comment and I will vote Continue reading “Excel Suggest The Next Awesome Excel Idea – 2366”

🔴 Power BI tips from the Pros – LIVE (Feb 4, 2023) (Member Chat 2nd Half)

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “🔴 Power BI tips from the Pros – LIVE (Feb 4, 2023) (Member Chat 2nd Half)”

Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12

Download Zipped Folder with All Files: https://excelisfun.net/files/12-M365ExcelClassVideoFiles.zip
Full Free M Code Class from Basic to Advanced in Excel and Power BI Power Query taught by Excel MVP and Highline College Professor, Mike Girvin. Full Class: Microsoft 365 Excel Complete Story.
This video covers.
1. (00:00) Introduction
2. (00:26) Define M Code
3. (03:05) Power Query and M Code are in Both Excel and Power BI Desktop
4. (05:08) Advanced Editor button in Excel & Power BI Desktop
5. (05:39) Power BI Desktop “Enable Load”
6. (06:22) M Code Basics, tour of Power Query Editor and the three locations to view and change M Code. We Continue reading “Free M Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom Functions 365 MECS 12”

Calculate The Difference In Days Between Purchases Or Events In Power BI Using DAX

Are you trying to work out trends in customer behaviour or would like to target marketing campaigns more specifically to relevant customers? In this video, Sam demonstrates how you can calculate the difference in days between purchases or events in Power BI using DAX formulas. He is going to use some advanced logic using the FILTER and CALCULATE functions.

*****Video Details*****
00:00 Introduction
02:20 Data set
03:17 Last date of purchase
05:01 Difference between purchases
09:22 Conclusion

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources Continue reading “Calculate The Difference In Days Between Purchases Or Events In Power BI Using DAX”

Let’s see if ChatGPT knows what’s coming next for Power BI…

Everyone is making videos on ChatGPT and trying to solve problems. What about telling the future? Let’s see if ChatGPT can tell us what’s coming next for Power BI!

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

http://twitter.com/guyinacube
http://twitter.com/awsaxton
http://twitter.com/patrickdba
http://www.facebook.com/guyinacube
https://www.instagram.com/guyinacube/
https://guyinacube.com

***Gear***
🛠 Check out my Tools page – <a href="https://guyinacube.com/tools/" Continue reading “Let’s see if ChatGPT knows what’s coming next for Power BI…”