Deprecated: Creation of dynamic property CF\WordPress\DataStore::$logger is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php on line 23
Deprecated: Creation of dynamic property CF\WordPress\Proxy::$pluginAPI is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/Proxy.php on line 31
Deprecated: file_get_contents(): Passing null to parameter #2 ($use_include_path) of type bool is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/codelights-shortcodes-and-widgets/codelights.php on line 20
Warning: session_start(): Session cannot be started after headers have already been sent in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/wordpress/src/class/wordpress.php on line 53
Deprecated: Return type of Requests_Cookie_Jar::offsetExists($key) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/Requests/Cookie/Jar.php on line 63
Deprecated: Return type of Requests_Cookie_Jar::offsetGet($key) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/Requests/Cookie/Jar.php on line 73
Deprecated: Return type of Requests_Cookie_Jar::offsetSet($key, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/Requests/Cookie/Jar.php on line 89
Deprecated: Return type of Requests_Cookie_Jar::offsetUnset($key) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/Requests/Cookie/Jar.php on line 102
Deprecated: Return type of Requests_Cookie_Jar::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/Requests/Cookie/Jar.php on line 111
Deprecated: Return type of Requests_Utility_CaseInsensitiveDictionary::offsetExists($key) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/Requests/Utility/CaseInsensitiveDictionary.php on line 40
Deprecated: Return type of Requests_Utility_CaseInsensitiveDictionary::offsetGet($key) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/Requests/Utility/CaseInsensitiveDictionary.php on line 51
Deprecated: Return type of Requests_Utility_CaseInsensitiveDictionary::offsetSet($key, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/Requests/Utility/CaseInsensitiveDictionary.php on line 68
Deprecated: Return type of Requests_Utility_CaseInsensitiveDictionary::offsetUnset($key) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/Requests/Utility/CaseInsensitiveDictionary.php on line 82
Deprecated: Return type of Requests_Utility_CaseInsensitiveDictionary::getIterator() should either be compatible with IteratorAggregate::getIterator(): Traversable, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/Requests/Utility/CaseInsensitiveDictionary.php on line 91 April 2022 – Bonbon's Guide To Data & Tech
Practical Solutions for Excel, Power BI, SQL, Access, Python, Data Science, Automation & Other Tech
Month: April 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
We are more than ecstatic to finally launch the Enterprise DNA Power Tools developed by author and 6th-time Microsoft MVP, Greg Deckler. The whole team has been working tons on this exciting new endeavor and it’s definitely a big milestone for us.
In this video, Brian and Greg will give an overview on what to expect with this member-exclusive tool set, how to best use these powerful tools to dramatically speed up your own report development, and the capabilities that will be coming to this tool suite in the future.
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
In this tutorial, Reid is going to demonstrate a few different ways to add notes in Power Query, which can be especially helpful to people who aren’t much of a fan of taking down notes.
***** Video Details *****
00:00 Introduction
00:21 Step properties
01:02 Advanced editor
01:38 Query properties
02:33 Group properties
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
Download Excel File: https://excelisfun.net/files/Ch06-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch06-ESA.pdf
Learn about how to create a Normal Bell Curve Chart in Excel using Area Chart. Other Charting tricks also.
Topics:
1. (00:00) Introduction
2. (00:26) Create Data for Chart
3. (00:45) Create X Values. SEQUENCE function.
4. (01:55) Create Probabilities with NORM.DIST function
5. (02:55) Create Area Chart for Normal Bell Curve
6. (04:37) Create Z Values
7. (05:10) Label for Probability Less Than an X Value. Text Formula and the ROUND function.
8. (06:45) Create Probability Less Than an X Value using the IF Function
9. (07:55) Add Second Column of Probabilities to Area Chart Continue reading “Excel Statistical Analysis 33: Chart Normal (Bell) Probability Distribution in Excel with Area Chart”→
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
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
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
(00:00) Start, (00:04) Nick Roth ride, (00:3) Nathon Ride, (00:53) Magic ride (excelisfun), (01:23) Isaac “Iceman” Girvin ride. Blue Grass Music Played throughout : )
Two Old Guys on BMX Bikes: Mike “Magic” Girvin (excelisfun at YouTube) and Nick “Rad 68” Roth. Two Young Dudes on Skateboards: Isaac “Iceman” Girvin and Nathon.
Washington BMX Old Guy Adventure 14.
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
Struggling with using Row-Level Security (RLS) together with Object-Level Security (OLS) in Power BI? You think it can’t be done? Think again! Patrick shows you how to use both together.
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
In this tutorial, George will show how to write gg2plot plots in Excel to create reproducible and more advanced custom data visualizations with improved quality and aesthetics.
***** Video Details *****
00:00 Introduction
02:05 Data set
02:32 Creating workbook
03:17 Regression
04:00 Tidy
05:28 ggplot
06:18 insertPlot
07:25 Exporting
09:20 Recap
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
Download Excel File: https://excelisfun.net/files/Ch06-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch06-ESA.pdf
Learn about the Normal (Bell) Probability Distribution and the Excel worksheet functions to calculate probability and x values: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV.
Topics:
1. (00:00) Introduction
2. (00:22) pdf notes: characteristics of Normal Bell Probability Distribution.
3. (04:40) pdf notes: Math Formulas for Normal (Bell) Probability Distribution
4. (05:14) pdf notes: X values or Z-score (Standard Value)?
5. (05:50) pdf notes: notes on Excel Functions for Normal (Bell) Probability Distribution: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV
6. (08:49) pdf notes: Professor observes a bell shape (normal) distribution.
7. (09:07) pdf notes: 3 Types of Probability Calculations: Continue reading “Excel Statistical Analysis 32: Bell Curve Functions: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV”→
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
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
Download Excel File: https://excelisfun.net/files/Ch06-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch06-ESA.pdf
Learn about the formulas and calculating probabilities for the Uniform Probability Distribution.
Topics:
1. (00:00) Introduction
2. (00:23) Understanding what a Uniform Distribution is and how it is related to the data behind it.
3. (02:36) Formulas for Uniform Distribution
4. (05:22) Paper Example for Waiting Times on Customer Service Phone Calls
5. (07:11) Excel Example for Waiting Times on Customer Service Phone Calls
6. (12:16) Golf Example using Excel Formulas
7. (14:40) Summary of video
8. (14:58) Closing and 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
IIn this video, Pascal is ecstatic to test out and share the report his team recently worked on for a real-life call center client and compare it against some of the entries for our Power BI Challenge 19. Pascal will be showcase and demonstrate how to develop specific requirements that lets the client be able to drill through all the way to the single phone call level by simply selecting a single call within the Power BI report.
***** Video Details *****
00:00 Introduction
01:00 Client requirement
01:58 Data set
02:26 Data model
03:40 Custom visuals
06:21 Call code
08:50 Call button code
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
Download Excel File: https://excelisfun.net/files/Ch06-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch06-ESA.pdf
Learn about Continuous Probability Distributions.
Topics:
1. (00:00) Introduction
2. (00:20) Compare Discrete Probability Distributions to Continuous Probability Distributions
3. (05:05) Continuous Probability Distributions Density Function to calculate the height of plotted curve of continuous probability distributions
4. (05:56) Integral Calculus or Excel functions to calculate the area under the curve, or probability
5. (07:03) Three examples of Normal, Uniform and Exponential Distributions.
6. (08:26) The distributions we learn about in this chapter use population data, not sample data.
7. (08:57) Next Video, Closing and Video Links