Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

How To Resample Time Series Data Using Pandas To Enhance Analysis

You’ll most likely encounter the requirement to change the frequency or time period when reporting time series data to derive a more reliable and consistent report. This process of changing the time period that data are summarized for is called resampling. In this video, George will demonstrate how you can resample time series data using Pandas.

***** Video Details *****
00:00 Introduction
01:17 Upsampling vs Downsampling
01:51 Resampling in Pandas
02:25 Data set
03:21 Setting index
03:47 Upsampling
05:21 Downsampling
06:00 Visualization
07:23 Recap

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – Continue reading “How To Resample Time Series Data Using Pandas To Enhance Analysis”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Dad/Son Rad Road Trip To Oakland Lower Bobs Skatepark

Pictures and videos of epic trip that Magic (Dad) and Iceman (Son) took to Oakland to see pro skateboard contest and skate-punk band Boneless Ones Music Video Shoot.


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

REPLAY Power BI tips from the Pros – LIVE (April 16, 2022)

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 “REPLAY Power BI tips from the Pros – LIVE (April 16, 2022)”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Formulas, Text To Columns or Power Query to Fix Dates. Excel Magic Trick 1790

Download Excel File: https://excelisfun.net/files/EMT1790.xlsx
Learn how to convert improper dates (text or YYYMMDD dates) into proper serial number dates.
Topics:
1. (00:00) Introduction
2. (00:19) Worksheet Formula Method, TEXT function
3. (01:18) Text To Columns Method
4. (02:34) Power Query Method
5. (03:41) Summary, Closing, Video Links


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

OEE Manufacturing Report: Power BI Challenge Winner #18 Best Practices

EVENT DETAILS – https://enterprisedna.co/power-bi-challenge-winner-18-oee-manufacturing-report-april-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/

When is it?
April 14th – 7pm Los Angeles (PDT), 9pm Oklahoma (CDT), 10pm New York (EDT)
April 15th – 3am London (BST), 12pm Sydney (AEST), 2pm Auckland (NZST)

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

Who’s doing it?
Presented by Paul Gerber, Power BI Challenge Winner #18 – Driving an analytical movement through using Power BI!

During This Free Training, You Will Learn:

• Discover the key points around OEE and producing a technically sound report
• Showcase an attractive report with excellent navigation and some interesting wrinkles
• Learn an effective Continue reading “OEE Manufacturing Report: Power BI Challenge Winner #18 Best Practices”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

How to get a DATE TABLE easily in Power BI

Do you use a central date table for your Power BI datasets? There is a LOT of POWER in having one. Adam shows you different ways to create one including a really simple easy option that’s BANANAS!

REDUCE Power BI dataset size by 60% with ONE CHECKBOX???
https://www.youtube.com/watch?v=RnDdDlozcdo

Bravo for Power BI
https://bravo.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
— <a href="http://twitter.com/awsaxton" Continue reading “How to get a DATE TABLE easily in Power BI”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Count Number Of Weekdays Per Month using Excel – 2481

Ronak asks: How can I use Excel to find out how many weekedays per month for the whole year?

This video shows how to do it using SEQUENCE, TEXT and a quick pivot table in Excel.


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Are you backing up your Power BI Dataset???

While Power BI is a SaaS service, backing up your dataset is still important. What if something was accidently deleted? How do you recover it? Patrick shows you how you can get a backup / restore process in place so you can sleep at night.

Backup/Restore PowerShell Script: https://guyinacu.be/backuprestorescript

Backup and restore datasets with Power BI Premium
https://docs.microsoft.com/power-bi/enterprise/service-premium-backup-restore-dataset

Power BI Service Principals 101
https://www.youtube.com/watch?v=1SO19uik1rw

📢 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 Continue reading “Are you backing up your Power BI Dataset???”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

How To Use Concurrent Function In Power Apps For Faster Process Time

Concurrent functions are a way great to optimize your Power Apps. Concurrent enables you to run processes in parallel instead of in sequences, making your Power Apps a lot faster. In this tutorial, Henry shows you how to use the Concurrent function, and shows you a side-by-side performance difference between regular sequence processes, and concurrent processes.  

***** Video Details *****
00:00 Introduction
00:48 Application overview
01:05 Variables
04:18 Concurrent function
07:24 Test run

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Continue reading “How To Use Concurrent Function In Power Apps For Faster Process Time”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Supercharging Your Charts & Graphs in Power BI

EVENT DETAILS – https://enterprisedna.co/supercharging-your-charts-graphs-in-power-bi-april-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/

When is it?
April 12th – 6pm New York (EDT), 3pm Los Angeles (PDT), 11pm London (BST)
April 13th – 8am Sydney (AEST), 10am Auckland (NZST)

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

Who’s doing it?
Presented by Reid Havens (MVP), BI Evangelist & Instructor

During This Free Training, You Will Learn:

• Discover various techniques to enhance and upgrade native visuals in Power BI
• Showcase helpful tips on how to deliver greater insights and unlock features for report consumers

If you have questions regarding this training, please send it to Continue reading “Supercharging Your Charts & Graphs in Power BI”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

How To Automatically Launch A New Web Browser In Power Automate

Web applications are essential components of most organizations. In today’s tutorial, Jarrett is going to demonstrate how to utilize a Power Automate Desktop function that you’ll be using often when doing web-related tasks and automation, the Launch New Browser.

***** Video Details *****
00:45 Building a flow
01:20 Browser options
01:44 Browser extensions
03:20 Launch new Chrome

***** Related Links *****
Launch New Chrome Microsoft Documentation – https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/webautomation#launchchromebase

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources Continue reading “How To Automatically Launch A New Web Browser In Power Automate”


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Statistical Analysis 28: Poisson Distribution, POISSON.DIST function and Poisson Column Chart

Download Excel File: https://excelisfun.net/files/Ch05-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch05-ESA.pdf
Learn about the Poisson Distribution and how to calculate probabilities using the POISSON.DIST function.
Topics:
1. (00:00) Introduction
2. (00:22) Data for arrivals at Dick’s Hamburgers restaurant
3. (01:05) Poisson Distribution Characteristics and requirements
4. (03:36) Poisson frequency Distribution pattern
5. (04:35) POISSON.DIST function
6. (08:22) Plot a Poisson Distribution on an Excel Column Chart
7. (09:31) Examples of when you can use Poisson Distribution, kike Waiting and stretches of road
8. (11:02) Poisson Math Formula
9. (11:20) The number e
10. (11:40) EXP worksheet function to calculate the number e
11. (12:20) POISSON.DIST function for the Dick’s Hamburgers Continue reading “Excel Statistical Analysis 28: Poisson Distribution, POISSON.DIST function and Poisson Column Chart”