Blog

Bonbon's Guide To Data & Tech > Blog

DAME 2: All MS Data Analysis Tools in 1 Video: Excel, Power Query, Power BI, Data Flow, DAX & M Code

Posted on by Annie D

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week01a02/Video01-02Files.zip
Pdf notes to read online: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week01a02/01-DAMEMPT.pdf
Alternative link for zipped folder: https://excelisfun.net/files/Video01-02Files.zip
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about ALL the Microsoft Power Tools: Excel, Power Query, Power Pivot, Data Model, Power BI, Dataflow, Worksheet formulas, Dynamic Spilled Array Formulas, M Code formulas, DAX formulas, and much more!
Topics:
1. (00:00) Introduction
2. (00:13) List of MS Power Tools taught in video
3. (00:44) Preview of 7 examples
4. (01:48) Why use Worksheet as a data analysis Continue reading “DAME 2: All MS Data Analysis Tools in 1 Video: Excel, Power Query, Power BI, Data Flow, DAX & M Code” →

At last!!! Power Query within Power BI Report Builder!

Posted on by Annie D

With Power Query being available for Power BI Paginated reports in Report Builder, you can now do something that was very hard to do in the past. Patrick shows you what’s new!

Get data with Power Query available in Power BI Report Builder (Preview)
https://powerbi.microsoft.com/en-us/blog/get-data-with-power-query-available-in-power-bi-report-builder-preview/

Connect to Snowflake, Databricks, and others with Power Query Online in Power BI Report Builder
https://learn.microsoft.com/power-bi/paginated-reports/report-builder/connect-snowflake-databricks-power-query-online

📢 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: rel=”nofollow”>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 – https://guyinacube.com/tools/

#PowerBI #Paginated #GuyInACube

DAX Counterculture: Alternative Prospectives on DAX

Posted on by Annie D

Know the techniques in creating indexes and how to loop efficiently using DAX.

Details of what you will learn during this video:

– Showcase effective ways when and when not to use CALCULATE
– Determine when not to use Time Intelligence functions (always)
– Learn how to loop in DAX efficiently
– See how to use the greatly maligned EARLIER function
– Know the techniques in creating indexes in DAX

***** 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 – <a Continue reading “DAX Counterculture: Alternative Prospectives on DAX” →

DAME 01: Data Analysis Terms & the Awesome Microsoft Power Tools!

Posted on by Annie D

Download files: DAME01zip Pdf notes to read online: DAME01pdfNotes
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught my Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about data analysis terms and all the amazing Microsoft Power Tools such as: Excel, Power Query, Power Pivot, Power BI, Dataflow, Worksheet formulas, Dyanamic Spileld Array Formulas, M Code formulas, DAX formulas, and much more!
Topics:
1. (00:00) DAME Intro Song
2. (00:12) Introduction
3. (01:18) Table terminology
4. (04:52) What is Grian?
5. (06:41) SQL database as a data source
6. (07:55) Columnar Database in the Data Model in Power Pivot and Power Continue reading “DAME 01: Data Analysis Terms & the Awesome Microsoft Power Tools!” →

🔴 Microsoft Fabric / Power BI Q&A – LIVE (April 6, 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

Connect with Brad Schacht:
https://twitter.com/bradleyschacht
rel=”nofollow”>https://www.linkedin.com/in/bradleyschacht/
https://bradleyschacht.com/

Connect with Scott Sewell:
https://twitter.com/scottsewell
https://www.youtube.com/@MSFT_ScottSewell
https://www.linkedin.com/in/mscottsewell/

📢 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 – https://guyinacube.com/tools/

#MicrosoftFabric #PowerBI #GuyInACube

Boost DAX Performance in Power BI with Dual Mode

Posted on by Annie D

Don’t ignore Dual Mode! If you are leveraging DirectQuery and Import in your Power BI semantic model, you could have some performance problems you aren’t aware of. Patrick shows you what’s going on!

📢 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 Continue reading “Boost DAX Performance in Power BI with Dual Mode” →

Wait!?! It’s the same data source! What’s going on???

Posted on by Annie D

Think you are using the same data source in Power BI? Maybe you aren’t? Patrick shows you how this can affect DAX Query performance and how to correct it.

📢 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 “Wait!?! It’s the same data source! What’s going on???” →

Create Beautiful Report Templates with PowerPoint

Posted on by Annie D

Build a minimalistic report in PBI with PowerPoint template and icons.

Details of what you will learn during this video:
– Learn basic tips & tricks to handle different shapes in PowerPoint. 
– Apply artistic effects to images to create glasmorphism style effects. 
– Use almost any background image to create beautiful templates. 
– Build a minimalistic report in PBI with PowerPoint template and icons. 
– Explore best custom theme generator to speed up Power BI development.

***** 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 – <a Continue reading “Create Beautiful Report Templates with PowerPoint” →

Copilot for Power BI: Your Ultimate Copilot Guide

Posted on by Annie D

Have you used Copilot for Power BI? Do you know there are different copilots within Power BI? Carly joins us for the ultimate Copilot for Power BI guide!

Overview of Copilot for Power BI (preview)
https://learn.microsoft.com/power-bi/create-reports/copilot-introduction

Create report pages with Copilot for the Power BI service
https://learn.microsoft.com/power-bi/create-reports/copilot-create-report

Create a narrative with Copilot for Power BI
https://learn.microsoft.com/power-bi/create-reports/copilot-create-narrative?tabs=powerbi-service

Summarize a report page in the Copilot pane
https://learn.microsoft.com/power-bi/create-reports/copilot-pane-summarize-content

Use Copilot to create measure descriptions (preview)
https://learn.microsoft.com/power-bi/transform-model/desktop-measure-copilot-descriptions?toc=%2Fpower-bi%2Fcreate-reports%2FTOC.json&bc=%2Fpower-bi%2Fcreate-reports%2Fbreadcrumb%2Ftoc.json

Connect with Carly Newsome
https://www.linkedin.com/in/carlylanders/

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

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

Want to take your Power BI skills to the Continue reading “Copilot for Power BI: Your Ultimate Copilot Guide” →