Month: April 2022

Introducing The Enterprise DNA Power Tools – New External Tools For Power BI

Posted on by Annie D

Download the Enterprise DNA Power Tools here: https://enterprisedna.co/external-tools/

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.

***** Continue reading “Introducing The Enterprise DNA Power Tools – New External Tools For Power BI” →

How To Quickly Add Notes In Power Query

Posted on by Annie D

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

***** 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 – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – rel=”nofollow”>https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerQuery #PowerQueryTutorial #PowerBI #PowerBIDesktop #PowerBITutorial

Excel Statistical Analysis 33: Chart Normal (Bell) Probability Distribution in Excel with Area Chart

Posted on by Annie D

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” →

REPLAY Power BI tips from the Pros – LIVE (Mar 26, 2022)

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

BMX & Skate Park Adventure #14: Lake Stevens, Sunday, Sunday, March 27, 2022

Posted on by Annie D

(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.

Row-Level Security and Object-Level Security together in Power BI??? Yup!

Posted on by Annie D

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.

Announcement Blog: https://powerbi.microsoft.com/blog/object-level-security-ols-is-now-generally-available-in-power-bi-premium-and-pro/

Analysis Services Doc: https://docs.microsoft.com/analysis-services/tabular-models/object-level-security

FourMoo: https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specific-users-in-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
— Continue reading “Row-Level Security and Object-Level Security together in Power BI??? Yup!” →

How To Write ggplot2 Plots In Excel For Reproducible And Advanced Visualizations

Posted on by Annie D

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

***** 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 – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – <a Continue reading “How To Write ggplot2 Plots In Excel For Reproducible And Advanced Visualizations” →

Excel Statistical Analysis 32: Bell Curve Functions: NORM.DIST, NORM.S.DIST, NORM.INV, NORM.S.INV

Posted on by Annie D

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” →

Take Power BI To The Next Level w/ The Power Platform

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/take-power-bi-to-the-next-level-with-the-power-platform-april-2022-registration/

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

When is it?
April 26th – 9am Los Angeles (PDT), 12pm New York (EDT), 5pm London (BST)
April 27th – 2am Sydney (AEST), 4am Auckland (NZST)

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

Who’s doing it?
Presented by Henry Habib, Enterprise DNA Expert – Driving an analytical movement through using Power BI!

During This Free Training, You Will Learn:

• Integrate custom made Power Apps directly into your reports, providing users even more functionality
• Add custom workflows to your Power BI reports through Power Automate that your users can execute
• Transfer Continue reading “Take Power BI To The Next Level w/ The Power Platform” →

Excel Statistical Analysis 31: Uniform Probability Distribution

Posted on by Annie D

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

How To Ace Your Power BI Challenge 19

Posted on by Annie D

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

***** Learning Power BI? ***** Continue reading “How To Ace Your Power BI Challenge 19” →

Excel Statistical Analysis 30: Introduction to Continuous Probability Distributions

Posted on by Annie D

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