Home page with free videos, files and full free courses: https://www.youtube.com/@excelisfun
This is an introduction to the excelisfun channel at YouTube, where the videos, practice files and full courses are all free! Mike Girvin created this channel back in 2008 and have posted over 3,700 videos, over 10,000 practice files and over 100 playlists and classes to learn from.
Form to fill out: https://lnkd.in/eT4jM3Bd
Celia’s MVP story: https://www.linkedin.com/feed/update/urn:li:activity:7220049752489431040/
Celia’s YouTube Channel: https://www.youtube.com/c/CeliaAlvesSolveExcel
Here is a poem about excelisfun and the revoked MVP by Hiran de Silva.
Download Excel File: https://excelisfun.net/files/EMT1862.xlsx
Learn how to add a formula helper column to the data set to group the dates by half year increments in a PivotTable.
Topics:
1. (00:00) Introduction
2. () Viewer Question
3. () Helper Column Formula
4. () PivotTable
5. () Summary
6. () Closing, Video Links
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #pivottable #grouping #groupby #formulas #functions
Need to do a bulk change of something in your Power BI report? The new Power BI report format enables some slick automations. Patrick uses Sempy to get this done!
What is semantic link?
https://learn.microsoft.com/fabric/data-science/semantic-link-overview
Items – Get Item Definition
https://learn.microsoft.com/rest/api/fabric/core/items/get-item-definition?tabs=HTTP
Items – Update Item Definition
https://learn.microsoft.com/rest/api/fabric/core/items/update-item-definition?tabs=HTTP
📢 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
— rel=”nofollow”>http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/
#PowerBI #report #GuyInACube
Ready to take the Power BI card visual to the next level? Adam tinkers to get it to look just right. It’s a lot of customization but the outcome is way better than the starting point.
Create a (new) card visualization in Power BI Desktop (preview)
https://learn.microsoft.com/power-bi/visuals/power-bi-visualization-new-card?tabs=On-the-ribbon
📢 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
— <a Continue reading “Happy little accidents with the Power BI Card Visual”
Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.
💥 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
Connect with Matthew:
Mastodon: https://techhub.social/@SQLAllFather
YouTube: <a href="https://www.youtube.com/" Continue reading “REPLAY Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (July 27, 2024)”
We are presenting a full day introduction to Microsoft Fabric at two different events in September! This is also important for Power BI folks to understand what all is available to them. Join us to get up to speed quickly!
Data Saturday Dallas (Dallas-Fort Worth, Texas:
Friday, September 6, 2024
Data Saturday Registration:
https://www.eventbrite.com/e/data-saturday-dallas-tickets-905734084027
Data Saturday Pre-Con Sign up:
https://www.eventbrite.com/e/harnessing-the-power-of-microsoft-fabric-tickets-931743197987
SQLKonferenz (Hanau, Germany):
Monday, September 30, 2024
https://sqlkonferenz.de/precon-workshops-2024/
https://sqlkonferenz.de/registration/
📢 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 Continue reading “Dive into Power BI and Microsoft Fabric – IN PERSON – two events!”
Both the Microsoft Fabric lakehouse and warehouse have a SQL Analytics Endpoint. But they have different limitations. Which one is the right one to use? Patrick breaks it down!
Better together: the lakehouse and warehouse
https://learn.microsoft.com/fabric/data-warehouse/get-started-lakehouse-sql-analytics-endpoint
📢 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***
🛠 Continue reading “Which Microsoft Fabric SQL Analytics Endpoint should you use?”
With a subscription to Copilot 365 and the Edge browser, you will never have to watch an entire YouTube video again.
In this video, I’m showing you an incredible hack using Copilot in Microsoft Edge that will save you from having to watch entire YouTube videos again! Imagine being able to jump straight to the key moments of any video without sitting through the lengthy intros or outros. With Copilot, you can do exactly that—access the essential highlights from any video and skip all the fluff. Here, I’ll walk you through how to do it step-by-step with a practical example from Continue reading “Copilot Never Watch An Entire YouTube Video Again! Episode 2649”
Microsoft Excel Tutorial: Extract Everything After First Digit
**How to Extract Everything in a Cell Starting from the First Digit in Excel!**
In today’s video, we tackle a great question from Alex: *How do we extract everything in a cell starting from the first digit?* Alex has a large dataset, and in one of the columns, he needs to separate “what has to be done” from the address where it needs to be done. The tricky part? There’s no consistent delimiter to separate these two pieces of information. Today, I’ll show you two different solutions to solve this problem—one Continue reading “Excel Extract Everything After First Digit – Episode 2650”
Microsoft Excel Tutorial: Excel New Range Reference For Dynamic Sized Ranges and TRIMRANGE function.
In today’s video, we’re diving into an exciting new feature in the Excel beta that’s bound to change the way we work with dynamic ranges. Microsoft has introduced a groundbreaking method for referencing ranges using a simple dot notation, or by leveraging the new TRIMRANGE function. Say goodbye to inefficient full-column references and hello to cleaner, more efficient formulas. Stick around as we explore how these new features can streamline your Excel workflows!
First up, let’s talk about the TRIMRANGE function. This new function allows you to specify Continue reading “Excel New Range Reference For Dynamic Sized Ranges – Episode 2651”