Category: 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!” →

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

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

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

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

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

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

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