Category: Business

Dive into Microsoft Fabric’s Power BI Direct Lake

Posted on by Annie D

Let’s break down Power BI Direct Lake in Microsoft Fabric and explain how you can leverage one copy of the data from OneLake. Patrick explains!

Direct Lake
https://learn.microsoft.com/power-bi/enterprise/directlake-overview

📢 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 – Continue reading “Dive into Microsoft Fabric’s Power BI Direct Lake” →

Generate Random Data Sets with Dates & Sales Numbers: RANDARRAY Function. Excel Magic Trick 1857

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1857-1858.xlsx
Learn how to create a data set with dates and sales numbers using an Excel Formula.
Topics:
1. (00:00) Create Inputs for Randon Data Set
2. (00:37) Create Random Dates using RANDARRAY function
3. (01:21) Create Random Sales amounts using RANDARRAY & ROUND function
4. (02:00) Paste Special Values Trick!
5. (03:00) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #randomdata

Getting started with Visual Calcs in Power BI

Posted on by Annie D

It’s been a long time coming but Visual Calculations within Power BI are here!!! Jay joins us to get us started on using Visual Calcs within our reports.

Share your thoughts on visual calculations (preview)
https://aka.ms/visual-calculations-feedback

Using visual calculations (preview)
https://learn.microsoft.com/power-bi/transform-model/desktop-visual-calculations-overview

Jeroen (Jay) ter Heerdt
https://twitter.com/JayPowerBI
https://www.linkedin.com/in/jeroenterheerdt/
https://www.dutchdatadude.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
— <a href="http://twitter.com/awsaxton" Continue reading “Getting started with Visual Calcs in Power BI” →

9 1/2 Tips for Awesome Visualization in Power BI

Posted on by Annie D

Learn some tips and tricks for awesome visualization in Power BI.

**** Details of what you will learn during this video ****
– Learn a variety of Power BI tips and techniques to use yourself in Power BI 
– Review how to develop solutions that solve multiple real-world business problems 
– Showcase how to create compelling visuals within your dashboards 

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing
Enterprise DNA Workouts – https://bit.ly/41F9weH

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial Continue reading “9 1/2 Tips for Awesome Visualization in Power BI” →

Uncovering OneLake’s Secrets with Delta Analyzer in Microsoft Fabric

Posted on by Annie D

You need to make sure your delta files in OneLake are healthy! Phil has you covered with a Delta Analyzer notebook that you can use within Microsoft Fabric to check on things.

Delta Analyzer
https://aka.ms/deltaanalyzer

Phil Seamark
https://twitter.com/PhilSeamark
https://www.linkedin.com/in/seamark/
https://dax.tips

📢 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 #GuyInACube

Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1854-1856.xlsx
Learn how to group transactions with no key or invoice number using Power Query and the Table.Group fourth and fifth arguments: groupKind and comparer function. Group By when there is no key column and there are duplicates and empty cells. How to group transactions with no transaction number and repeating dates and empty cells.
Topics:
1. (00:00) Introduction
2. (00:28) Group By Date Column with two aggregate calculations: join descriptions and sum amount.
3. (01:00) Text.Combine with Column Lookup to join descriptions
4. (02:10) Table.Group fourth argument: groupKind using GroupKing.Local or zero, 0
5. (02:56) Table.Group fifth argument: comparer function
6. Continue reading “Power Query Table.Group Function Fifth Argument: Comparer Function: Group without Key. EMT 1856” →

🔴 Microsoft Fabric / Power BI Q&A – LIVE (Mar 2, 2024) (Member Chat 2nd Half)

Posted on by Annie D

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

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

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

Want Continue reading “🔴 Microsoft Fabric / Power BI Q&A – LIVE (Mar 2, 2024) (Member Chat 2nd Half)” →

All Code!!! Extract ZIP files with Notebooks in Microsoft Fabric

Posted on by Annie D

Who needs NOCODE? Patrick takes you on a journey where you can extract ZIP files within a Notebook in Microsoft Fabric. Also found a very cool feature in Notebooks!

📢 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 “All Code!!! Extract ZIP files with Notebooks in Microsoft Fabric” →

GROUPBY Function to Group Transactions with No Transaction Number. EMT 1855

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1854-1856.xlsx
Learn how to group transactions with no key or invoice number using dynamic spilled array formulas. Group By when there is no key column and there are duplicates and empty cells. How to group transactions with no transaction number and repeating dates and empty cells.
Topics:
1. (00:00) Introduction
2. (00:27) Teammates!
3. (00:38) Create Unique Identifier with SCAN
4. (03:06) GROUPBY Function
5. (03:28) HSTACK, SUM and ARRAYTOTEXT
6. (04:44) DROP Function to finish report.
7. (05:29) Summary
8. (05:45) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #reporting #groupby #groupbyfunction #PivotBy #pivottable #pivot

Use Excel to Build & Validate Complex DAX

Posted on by Annie D

Discover how to visualize, debug, validate, and solve complex DAX problems using Excel

Details of what you will learn during this video:
Know – how to form DAX logic by creating Excel rough work
Discover – how to visualize and solve complex DAX problems using Excel
Learn – to debug and validate calculations using Excel

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing
Enterprise DNA Workouts – https://bit.ly/41F9weH

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial #excel #exceltips

NO CODE extract ZIP files with Pipelines in Microsoft Fabric

Posted on by Annie D

Need to extract ZIP files and don’t want to write code? Adam walks you through how you can do this with Pipelines and dataflows within Microsoft Fabric. A NO CODE approach!

📢 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 – Continue reading “NO CODE extract ZIP files with Pipelines in Microsoft Fabric” →