Category: Business

The MAGIC of Microsoft Teams + Power BI

Posted on by Annie D

Are you using Power BI within Microsoft Teams? Daniel joins us to show the possibility of leveraging Microsoft Teams and the different ways to use Power BI.

Announcing – Embed your Power BI organizational apps in Microsoft Teams Channels and Meetings
https://powerbi.microsoft.com/en-us/blog/announcing-embed-your-power-bi-organizational-apps-in-microsoft-teams-channels-and-meetings/

Daniel Glenn:
https://twitter.com/DanielGlenn
https://www.linkedin.com/in/danielglenn/
https://365mcs.com/
https://www.youtube.com/365mcs

📢 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
— <a Continue reading “The MAGIC of Microsoft Teams + Power BI” →

Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13

Posted on by Annie D

Download Zipped Folder with All Files: https://excelisfun.net/files/13-M365ExcelClassVideoFiles.zip

This video is a comprehensive lesson in Power Query Importing & Transformation Data in Excel & Power BI. This video shows extensive M Code to create formulas to convert bad data into proper data sets that can be used for analysis.

This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW

This video covers.
1. (00:00) Introduction and video topics
2. (02:24) On-Premise Folder and File Path
3. (03:11) Importing TXT and CSV files
4. (08:08) Create Dynamic File Continue reading “Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13” →

Break Out Outliers And Analyze Over Time – Advanced DAX Concepts [2023 Update]

Posted on by Annie D

Dynamic outliers are data points that significantly deviate from the typical pattern of the data over time. Identifying these outliers can help highlight underlying performance trends and provide insights for better decision-making.

In this tutorial, Sam shows how to identify dynamic outliers in your data set using DAX. By mastering these advanced concepts, you’ll be able to showcase underlying performance trends and gain valuable insights for better decision-making.

***** Video Details *****
00:00 Introduction
02:01 Classification of an outlier
03:48 Outlier vs non-outlier
05:15 Outlier measure
05:53 Total sales
09:05 Real-life applications

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – Continue reading “Break Out Outliers And Analyze Over Time – Advanced DAX Concepts [2023 Update]” →

Getting Crazy with the Power Query UI

Posted on by Annie D

Using Merge statements? Alex shows you how that can break the fold in Power Query! He’s got you covered though and shows you a different way to approach it to make folding work! Using the UI!

Alex Powers:
https://twitter.com/notaboutthecell
https://www.linkedin.com/in/alexmpowers/
https://itsnotaboutthecell.com/

📢 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
— rel=”nofollow”>http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #PowerQuery #GuyInACube

Driving a Data Culture and Overcoming Challenges as a Power BI Sherpa with Thomas Martens

Posted on by Annie D

In this episode of the podcast, learn from the expertise of Thomas Martens, a Microsoft Data Platform MVP and Solution Architect at Munich Re. Join us as he explores the role of a Power BI Sherpa in driving a data culture and overcoming challenges in organizations. With 25 years of experience delivering Business Intelligence, Data Warehousing, and Analytics solutions, Tom shares his insights on using Power BI to tackle analytical challenges and apply analytical methods to small and large amounts of data. In this episode, Tom discusses the importance of Power BI in fostering a data culture, the challenges faced Continue reading “Driving a Data Culture and Overcoming Challenges as a Power BI Sherpa with Thomas Martens” →

Adding Subtotals In Excel

Posted on by Annie D

subtotal a column in excel
how to add subtotal function in excel
how to formulate subtotal in excel
how to subtotal sum in excel
how to use subtotal in excel for sum
using subtotals in excel to sum
how do you do a subtotal in excel
how to automatically subtotal data in excel
how to automatically subtotal rows in excel
how to calculate subtotals in excel
how to insert subtotals into excel
excel how to make subtotals
excel how to subtotal
excel how to use subtotals
how create subtotals in excel
how do i add subtotals in excel
how do i do a subtotal in excel
how do i do subtotal in excel
how do i use the Continue reading “Adding Subtotals In Excel” →

How To Remove Subtotals In Excel

Posted on by Annie D

excel how to get rid of subtotals
how do i remove subtotals in excel
how remove subtotals in excel
how to do subtotal remove all in excel
how to remove a subtotal in excel
how to remove all subtotals in excel
how to remove excel subtotals
how to remove subtotal excel
how to remove subtotal in excel
how to remove subtotals in excel
how to remove the subtotal in excel
how to undo subtotals in excel
remove subtotal in excel
how to take out a subtotal in excel
how to eliminate subtotals in excel
how to remove – from excel to show subtotal

Excel Challenge How Did Bill Manage To BREAK The Excel Status Bar Sum #shorts

Posted on by Annie D

There was a scary post online today… the Excel Status Bar sum was WRONG! But it is not wrong… it is a great trick that will win you bar bets from your Excel guru friends!

The Status Bar sum is CORRECT when you select from bottom to top!
But it is INCORRECT when you select from top to bottom!

Down in the YouTube comments, tell me how I managed to do this.

It required no VBA. You can easily do it yourself and freak out your Excel guru friends!

Don’t feel bad… when I first saw it, I could not figure it out Continue reading “Excel Challenge How Did Bill Manage To BREAK The Excel Status Bar Sum #shorts” →

Excel Two Levels Of Subtotals

Posted on by Annie D

how to add a second level subtotal feature excel
how to subtotal by two levels in excel
how to subtotal multiple columns in excel
excel how to make multiple subtotals
how to add multiple subtotals in excel
how to create multiple subtotals in excel
how to create multiple subtotals in excel?