Month: January 2023

Ready to be a Kusto Detective with Azure Data Explorer?

Posted on by Annie D

Your detective journey starts with the Kusto Detective Agency for Azure Data Explorer. This is a really fun way to learn the Kusto Query Languate (KQL)! Patrick gets you started! And, it’s FREE!

Kusto Detective Agency:
https://detective.kusto.io/

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

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

#ADX #Kusto #GuyInACube

Excel Use Previous Workday If Not A Workday – 2363

Posted on by Annie D

Vicki: I have a list of dates and I’m looking for a formula to calculate the previous workday only if the date in the list is a weekend or holiday.

Why: Accrue Fed Fund Interest Daily (Fed Funds Rate only published on Business Days).

This is mildly complex, because you need to be able to create a named range for the holidays, and after building the long formula, Excel will likely give you the date serial number instead of the formatted date.

Table of Contents
(0:00) Introduction
(0:23) Create a named range with holidays
(1:23) Excel formula to detect if date is a workday using NETWORKDAY Continue reading “Excel Use Previous Workday If Not A Workday – 2363” →

How To Calculate Running Totals In Power BI Using DAX

Posted on by Annie D

Running Totals is one of the most common analytical insight required when building reports or dashboards within most, if not all, organizations. In this video, Sam is going to show the simple logic required in DAX to develop visualization of this type of analysis.

*****Video Details*****
00:00 Introduction
01:42 Running total in 30 days
03:58 Running total in 90 days
04:30 DATESINPERIOD
06:17 Turning it into a visualization

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Continue reading “How To Calculate Running Totals In Power BI Using DAX” →

🔴 Power BI tips from the Pros – LIVE (Jan 28, 2023) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 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 to take your Power BI skills to the next level? We have training courses available to help you Continue reading “🔴 Power BI tips from the Pros – LIVE (Jan 28, 2023) (Member Chat 2nd Half)” →

Free Excel Templates From Microsoft Create – 2361

Posted on by Annie D

The Microsoft Create platform is in preview. Sign in with a Microsoft 365 Home account to access free templates for Excel and more. It also includes training on social media from Kat Norton Miss Excel and promises future features.

Table of Contents
(0:00) Free templates in Preview
(0:34) Start at Create.Microsoft.Com
(1:30) Opening a template in Excel Online
(1:54) Accessing from Win32
(2:24) Learning videos including Kat Norton
(3:00) Designer & Clipchamp coming

Considerations For Dark Backgrounds In Power BI Reports [2023 Update]

Posted on by Annie D

Dark backgrounds with light font colors make your visuals really pop, but there are a few things to consider when implementing this design format. In this video, Sam details out what to watch out for and what you need to implement to make sure your reports still stay effective.

*****Video Details*****
00:00 Introduction
01:06 Why Use Dark Backgrounds For Visuals
03:58 Conclusion

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events Continue reading “Considerations For Dark Backgrounds In Power BI Reports [2023 Update]” →

What do you want to see from Guy in a Cube? – Channel Update

Posted on by Annie D

It’s 2023 and there are amazing things ahead! Adam looks at what will be coming for the Guy in a Cube channel, and more importantly has a question for YOU!

📢 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 Continue reading “What do you want to see from Guy in a Cube? – Channel Update” →

Less F9 In The Excel Formula Bar And Two Other New Features – 2360

Posted on by Annie D

Three new features coming to Excel.
1) Value Preview will evaluate part of your formula when you select it in the Excel formula bar. You don’t have to press F9 and Esc anymore.
2) AutoSave moves from an icon to Words in the Excel Title Bar
3) Small preview of Personalized Toolbar in Excel

Table of Contents
(0:00) Three new Excel Features
(0:30) F9 replaced with Value Preview
(3:57) AutoSave icon moves to Title Bar words
(5:07) Personalized Toolbar in Preview
(10:38) Wrap-up

Save Time in Excel: Copy Only Excel Format with Format Painter. Excel Magic Trick 1815 #Shorts

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1814-1815.xlsx
Learn who to copy Excel Formatting and Apply in other locations
Topics:
1. (00:00) Introduction
2. (00:05) Copy Only Formatting with the Format Painter in Ribbon
3. (00:20) Format Painter in Mini Toolbar
4. (00:31) Apply Formatting multiple Times by Double-clicking Format Painter
5. (00:43) Keyboard for Format Painter
6. (01:03) Apply Same Formatting to Many Columns Simultaneously
7. (01:19) Closing, Video Links

#Shorts

Value Preview for Excel Formula Elements: No More F9 & Ctrl + Z!!!! Excel Magic Trick 1816 #Shorts

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1816.xlsx
Learn about new “Value Preview” for Excel Formula Elements: No More F9 & Ctrl + Z
Topics:
1. (00:00) Introduction
2. (00:01) Learn about new “Value Preview” for Excel Formula Elements: No More F9 & Ctrl + Z
3. (00:47) Closing, Video Links

#Shorts

What happens when you miss a refresh day with Power BI Incremental Refresh?

Posted on by Annie D

You’ve set up Power BI Incremental Refresh and there is a day that is missed because schedule refresh failed or some other reason. What happens? Do you lose that data? Patrick digs in!

📢 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 “What happens when you miss a refresh day with Power BI Incremental Refresh?” →

How To Easily Create Data With Python Faker Library

Posted on by Annie D

Fake dataset is often used for testing and filling databases or maintaining user privacy by using some dummy data. Data analysts would know that manually creating fake data would be a daunting task! In this tutorial, Gaelim will demonstrate how you can easily create data using Python Faker.

*****Video Details*****
00:00 Introduction
01:28 Libraries needed
02:25 Locale
03:54 Types of data
05:11 Random element selector
05:58 Creating the dataset

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Continue reading “How To Easily Create Data With Python Faker Library” →