Month: May 2022

EFFICIENT approach in Microsoft Teams for Power BI questions!

Posted on by Annie D

Using Microsoft Teams? Have a central place for your Power BI folks in your organization? This efficient approach will help you to get your question to the right people! At the same time cutting down the noise for other folks.

Steve Campbell
https://twitter.com/PowerBISteve
https://www.linkedin.com/in/powerbisteve/

Power BI Support Channel: Microsoft Teams Tips
https://powerbi.tips/2022/04/power-bi-support-channel-in-teams/

Power BI adoption roadmap
https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-adoption-roadmap-overview

Power BI implementation planning
https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-introduction

Manage tags in Microsoft Teams
https://docs.microsoft.com/en-us/microsoftteams/manage-tags

📢 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 Continue reading “EFFICIENT approach in Microsoft Teams for Power BI questions!” →

Excel Statistical Analysis 35: Exponential Probability Distribution & EXPON.DIST function

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 calculating probabilities from the Exponential Probability Distribution and the EXPON.DIST function.
Topics:
1. (00:00) Introduction
2. (00:26) Notes about Exponential Probability Distribution
3. (03:17) Dick’s Hamburgers example with math formula and EXPON.DIST function
4. (07:15) Disneyland Ride wait time example with math formula and EXPON.DIST function
5. (11:06) Summary of video
6. (11:25) Closing and Video Links

My Excel file is in the cloud! Why isn’t refresh working in Power BI???

Posted on by Annie D

Pulling data from an Excel document in the cloud? Is your Power BI dataset not refreshing? Adam looks at why this could be the case and how to get it working.

📢 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 – Continue reading “My Excel file is in the cloud! Why isn’t refresh working in Power BI???” →

How To Edit Data In R Using The DataEditR Package

Posted on by Annie D

DataEditR is an R package that will let you build dashboards and reports in R using a GUI, which is actually built using shiny, that makes it easy to interactively view, enter, filter and edit data. In this video, George is going to demonstrate how to do basic data editing and manipulation using DataEditR.

***** Video Details *****
00:00 Introduction
01:16 DataEditR
02:15 Ecdat
02:22 Data set
02:58 Data editor
04:25 Saving data
06:45 Saving selection
07:51 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 Continue reading “How To Edit Data In R Using The DataEditR Package” →

Why you should look at Azure Synapse Analytics!

Posted on by Annie D

Have you heard about Azure Synapse Analytics! Is your data in Synapse? It’s so much more than SQL Server! Adam and Patrick look at why you should care about it!

What is Azure Synapse Analytics?
https://docs.microsoft.com/azure/synapse-analytics/overview-what-is

📢 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***
🛠 Continue reading “Why you should look at Azure Synapse Analytics!” →

Security Risk Microsoft Has Blocked Macros From Running – 2485

Posted on by Annie D

A new pink bar warning is appearing in Excel, Word, and PowerPoint telling you that there is a security risk and that your VBA macros have been blocked.
This warning is designed to make you ask, “Is there a valid reason for this person to be sending me a macro?” If there is, I will show you the easy steps to unblock the workbook.
This is called the Mark of the Web.
Kevin Lehrbass Word Game is here: https://www.myspreadsheetlab.com/word-game/

Table of Contents
(0:00) Kevin Lehrbass has a Wordle game in Excel but the macros are blocked with the pink bar.
(1:08) Continue reading “Security Risk Microsoft Has Blocked Macros From Running – 2485” →

How To Use Chi-square Test In Excel To Compare Variables

Posted on by Annie D

The chi-square test is a statistical non-parametric test used to compare two or more variables from randomly selected data. It helps find if there are any significant relationship between two or more categorical variables. In this video, George is going to teach how to use the chi-square test using Excel.

***** Video Details *****
00:00 Introduction
00:21 What is chi-square test?
01:40 Data set
01:52 PivotTable actual
02:42 Formula expected
05:07 85% significance level
05:40 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 Continue reading “How To Use Chi-square Test In Excel To Compare Variables” →

Excel Statistical Analysis 34: Answering Probability Questions With NORM.DIST Function

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 solving questions using the Normal Bell Curve and the NORM.DIST and NORM.S.DIST Excel Probability Functions.
Topics:
1. (00:00) Introduction
2. (00:24) Answering an Accounting example with the NORM.DIST Function
3. (03:13) Answering a Gas Prices example with the NORM.DIST Function
4. (05:45) Answering a Manufacturing example with the NORM.DIST Function
5. (08:14) Summary of video
6. (08:40) Closing and Video Links

Call Centres Data Reporting – Intro To Power BI Challenge 19

Posted on by Annie D

We know that you’ve been enjoying our Power BI challenges and we’ve been kept on our toes coming up with great topics and datasets for you to work on to keep the excitement going round after round.

We’ve always strived to make every challenge reminiscent of real-life scenarios, and this challenge developed by our new Head of Challenges, Federico Pastor, is no different. For this round, we’re going to help with the expansion of a call centre by showing them what Power BI can offer for their business.

While the learning and experience of participating in the challenges are very rewarding, Continue reading “Call Centres Data Reporting – Intro To Power BI Challenge 19” →

Introducing Enterprise DNA Power Tools

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/top-speed-pro-tips-for-edna-power-tools-march-2022-registration/

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

When is it?
March 31st – 10am Los Angeles (PDT), 1pm New York (EDT), 6pm London (BST)
April 1st – 4am Sydney (AEDT), 6am Auckland (NZDT)

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

Who’s doing it?
Presented by Greg Deckler – Vice President, Fusion Alliance

During This Free Training, You Will Learn:

• How to create your own custom quick measures – create once, and then be able to apply them in every future report you do
• Secrets of Power Tools-insider tips on how to best use these powerful tools to Continue reading “Introducing Enterprise DNA Power Tools” →