Category: Business

Different ways to work with Microsoft Excel in Power BI (2023)

Posted on by Annie D

Using Excel? Of course, you are! How can you take advantage of Power BI? Adam shows you the different ways you can leverage Excel with Power BI to get the most out of 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 Continue reading “Different ways to work with Microsoft Excel in Power BI (2023)” →

ChatGPT & The Future Of Learning Data Skills | Innovations In Power BI & Power Platform Summit

Posted on by Annie D

Session 25: ChatGPT & The Future Of Learning Data Skills

When is it?
February 23rd – 3pm Los Angeles (PST), 6pm New York (EST), 11pm London (GMT)
February 24th – 10am Sydney (AEDT), 12pm Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Sam McKay & Brian Julius

During This Free Event, You Will:

• Learn what we think about ChatGPT
• See how it can compliment your learning journey
• How can you use AI tools right now!
• What’s the future of ChatGPT and its integration with MS tools

If Continue reading “ChatGPT & The Future Of Learning Data Skills | Innovations In Power BI & Power Platform Summit” →

DAX Is Easy, CALCULATE Makes It Hard | Innovations In Power BI & Power Platform Summit Session 24

Posted on by Annie D

Session 24: DAX Is Easy, CALCULATE Makes It Hard

When is it?
February 23rd – 2pm Los Angeles (PST), 5pm New York (EST), 10pm London (GMT)
February 24th – 9am Sydney (AEDT), 11am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Brian Julius & Greg Deckler (MVP)

During This Free Event, You Will:

• Understand the Challenges of Working with CALCULATE in DAX
• Examples of how to write DAX measures Without using CALCULATE
• Techniques for Visualizing Intermediate Tables in Data Analysis
• Discover methods for automating intermediate table measures Continue reading “DAX Is Easy, CALCULATE Makes It Hard | Innovations In Power BI & Power Platform Summit Session 24” →

Using Power Automate To Email Power BI Data As A CSV File

Posted on by Annie D

Session 23: Using Power Automate To Email Power BI Data As A CSV File

When is it?
February 23rd – 1pm Los Angeles (PST), 4pm New York (EST), 9pm London (GMT)
February 24th – 8am Sydney (AEDT), 10am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Jarrett Moore – Enterprise DNA Expert

During This Free Event, You Will:

• Learn how to setup and schedule a Power Automate flow using data from your Power BI Reports
• Know how to get DAX Query data from Power BI Desktop without Continue reading “Using Power Automate To Email Power BI Data As A CSV File” →

Advanced SQL Skills For Data Analysts | Innovations In Power BI & Power Platform Summit Session 22

Posted on by Annie D

Session 22: Advanced SQL Skills For Data Analysts

When is it?
February 23rd – 11am Los Angeles (PST), 2pm New York (EST), 7pm London (GMT)
February 24th – 6am Sydney (AEDT), 8am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Kedeisha Bryan – Co-founder & Community Leader at Data in Motion LLC

During This Free Event, You Will:

• Simplify complex queries, break down complex calculations, or perform recursive queries using Common Table Expressions (CTEs)
• Perform calculations across a set of rows in a query result, without Continue reading “Advanced SQL Skills For Data Analysts | Innovations In Power BI & Power Platform Summit Session 22” →

Excel Select All Formulas And Their Precedents – 2380

Posted on by Annie D

Harsinchh asks if there is a way to highlight all formula cells and the precedents of those formulas. There are a lot of techniques discussed in this video:
Show Formulas in Excel
Select all Formulas in Excel
Go To Special Precedents in Excel
Direct versus All Precedents in Excel
VBA to select formulas in Excel
VBA to select precedents in Excel
VBA to union two ranges in Excel

Table of Contents
(0:00) Excel: Select Formulas & the precedents
(0:25) Excel Show Formulas
(0:55) Selecting all Excel Formulas
(1:16) Selecting Formula Precedents with Go To Special
(1:40) All Precedents versus Direct Precedents
(2:52) Four-step is a kludge
(3:08) VBA Macro to select formulas and precedents
(4:49) Personal Continue reading “Excel Select All Formulas And Their Precedents – 2380” →

Harnessing The Power Of Dataverse – A Practical CRM Example

Posted on by Annie D

Session 15: Harnessing The Power Of Dataverse – A Practical CRM Example

When is it?
February 22nd – 8pm Los Angeles (PST), 11pm New York (EST)
February 23rd – 4am London (GMT), 3pm Sydney (AEDT), 5pm Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Ben Clist – Business Analytics and Applications Manager, Napier Port

During This Free Event, You Will:

• Learn how you can utilise out of the box Dataverse functionality to quickly develop a CRM solution
• Ideal for small teams without the budget for Dynamics 365, Continue reading “Harnessing The Power Of Dataverse – A Practical CRM Example” →

How to get a CLOCK in your Power BI Report

Posted on by Annie D

We had a question about how to get a clock in Power BI? Is that even possible? Patrick takes advantage of the Deneb visual to make it happen!

Vega Clock Sample
https://vega.github.io/vega/examples/clock/

HTML Content Custom Visual Limitations
https://www.html-content.com/reference/limitations

Kerry Kolosko
https://kerrykolosko.com/exploring-deneb-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
— <a Continue reading “How to get a CLOCK in your Power BI Report” →

Introduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_

Posted on by Annie D

Free Classes & Videos on the home page of my excelisfun channel: https://www.youtube.com/@excelisfun
This video introduces you to the excelisfun channel at YouTube, where you can learn anything would want about Excel and Power BI. My name is Mike Girvin. I am a professor at Highline College and a Microsoft Excel MVP since 2013. I have posted over 3,500 videos and created over 100 playlist of videos since Feb 2008 here at YouTube. The Home page: youtuve.com/@excelisfun , has full free classes in: 1) Microsoft 365 Excel/Power BI, 2) Basic and Advanced Excel, 3) Basics and Advanced Data Continue reading “Introduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_” →

5 Report Design Tricks That Will Make Any Power BI Report Look Awesome

Posted on by Annie D

Session 12: 5 Report Design Tricks That Will Make Any Power BI Report Look Awesome

When is it?
February 22nd – 8am Los Angeles (PST), 11am New York (EST), 4pm London (GMT)
February 23rd – 3am Sydney (AEDT), 5am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Mara Periera – Founder & Principal Power BI Architect, Data Pears

During This Free Event, You Will:

• Understand the main factors that can influence the design and user experience of your Power BI reports
• Learn how Data Visualization techniques Continue reading “5 Report Design Tricks That Will Make Any Power BI Report Look Awesome” →

Collection Of Custom Visuals & Niche Techniques In Power BI

Posted on by Annie D

Session 16: Collection Of Custom Visuals & Niche Techniques In Power BI

When is it?
February 23rd – 12am Los Angeles (PST), 3am New York (EST), 8am London (GMT), 7pm Sydney (AEDT), 9pm Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Injae Park – Senior Business Intelligence Developer, Objectivity

During This Free Event, You Will:

• Embed HTML, CSS, and JavaScript code directly into your report using HTML visuals
• Explore a wide range of options for customizing the appearance of your data visualizations with 1400+ Fonts Continue reading “Collection Of Custom Visuals & Niche Techniques In Power BI” →

What’s New & What’s Coming For Power BI | Innovations In Power BI & Power Platform Summit Session 14

Posted on by Annie D

Session 14: What’s New & What’s Coming For Power BI

When is it?
February 22nd – 10am Los Angeles (PST), 1pm New York (EST), 6pm London (GMT)
February 23rd – 5am Sydney (AEDT), 7am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Jay ter Heerdt – Microsoft, Senior Program Manager for Power BI

During This Free Event, You Will:

• Learn how the improved user experience in Power BI has made it easier to create and manage complex calculations
• Discover new and enhanced visualization options, improved collaboration Continue reading “What’s New & What’s Coming For Power BI | Innovations In Power BI & Power Platform Summit Session 14” →