Category: Power BI

Publish from Power BI Desktop for External Users

Posted on by Annie D

Have you ever wanted to publish from Power BI Desktop to a different organization? External Users publishing!!! I show you how you can log in as an external user in Power BI Desktop and then publish. BANANAS!!!

Ross Couldrey
LinkedIn: https://www.linkedin.com/in/rosscouldrey/

Distribute Power BI content to external guest users using Azure Active Directory B2B
https://docs.microsoft.com/power-bi/guidance/whitepaper-azure-b2b-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
— Continue reading “Publish from Power BI Desktop for External Users” →

Improving Data Literacy with George Mount

Posted on by Annie D

Businesses are increasingly recognizing the importance of data analytics in making informed decisions across all aspects of their operations. However, simply having access to data is not enough. They need to be able to extract value from it as well. They also need to have the skills and tools to analyze it effectively. How can businesses become more literate about their data in order to identify and respond to opportunities and threats strategically?

George Mount is the founder and CEO of Stringfest Analytics, a consulting firm specializing in analytics education and upskilling. He has worked with leading bootcamps, learning platforms, and Continue reading “Improving Data Literacy with George Mount” →

Practical Power Query Solutions – Nested Structured Values (Part 2)

Posted on by Annie D

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

When is it?
June 16th – 12pm Los Angeles (PDT), 3pm New York (EDT), 8pm London (BST)
June 17th – 5am Sydney (AEST), 7am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

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

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

During This Free Training, You Will Learn:

• Explore structured columns containing Lists, Records or Tables
• Retrieve only certain parts from nested Lists, Records or Tables
• Deal with mixed columns or lists inside records, or Continue reading “Practical Power Query Solutions – Nested Structured Values (Part 2)” →

What tool do you use to optimize your Power BI dataset?

Posted on by Annie D

Need some help optimizing your Power BI Dataset but don’t want to hand over your Power BI Desktop file? Patrick shows you some tools to get information to help with optimizing assistance! These are tools we use EVERYDAY!

DAX Studio
https://daxstudio.org/

Bravo for Power BI
https://bravo.bi/

Tabular Editor 3
https://tabulareditor.com/

📢 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
— Continue reading “What tool do you use to optimize your Power BI dataset?” →

How To Create Chatbots With Power Virtual Agents

Posted on by Annie D

Power Virtual Agents enables you to respond to your customers of even within your organization using intelligent sophisticated, AI-powered, conversational bots. For today’s video, Henry is going to demonstrate the exciting new evolution of the Power Virtual Agents.

***** Video Details *****
00:00 Introduction
00:28 What is Power Virtual Agents?
01:06 Creating a chatbot
02:12 Creating topics
03:45 Sample workflow
06:38 Suggest topics

***** 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://www.enterprisedna.co/power-bi-resources
FREE – Continue reading “How To Create Chatbots With Power Virtual Agents” →

What are the main tools for Azure Synapse and SQL???

Posted on by Annie D

Getting started with Azure Synapse Analytics or Azure SQL Database? Or even Microsoft SQL Server in general? Patrick shows you how to use some of the common tools and be able to connect to your instance!

Download SQL Server Management Studio
https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms

Download and install Azure Data Studio
https://docs.microsoft.com/sql/azure-data-studio/download-azure-data-studio

📢 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
— <a href="http://twitter.com/patrickdba" Continue reading “What are the main tools for Azure Synapse and SQL???” →

How To Create Dynamic Temporal Scale In Power BI Pt.1

Posted on by Annie D

Every so often we’ll be needing the availability of a custom visual of a bar chart or line chart that gives an option to plot the chart either weekly, monthly, quarterly, or yearly. In this video, Greg is going to demonstrate how you can create dynamic temporal scale using calculated columns in Power BI that can let you change the level of granularity depending on your date or time basis.

***** Video Details *****
00:00 Introduction
00:47 What is a dynamic temporal scale
01:40 Use cases
02:48 R10_Table
03:05 IsCurrentQuarter
03:48 DTS
04:40 DTS Sort By
06:45 Limitations of calculated column

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Continue reading “How To Create Dynamic Temporal Scale In Power BI Pt.1” →

How To Create External Tools For Power BI (Part 1)

Posted on by Annie D

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

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

How long is it?
Session will run for approximately 1 hour

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

Who’s doing it?
Presented by Greg Deckler (MVP) – VP at Fusion Alliance

During This Free Training, You Will Learn:

• Create external tool to generate the Enterprise DNA extended date table (Holidays, Some Date Intelligence Measures, Set Sort By)
• Time Machine
• Text box for naming the date table
• Date picker for StartDate and EndDate

If Continue reading “How To Create External Tools For Power BI (Part 1)” →

🔴 Power BI tips from the Pros – LIVE (June 18, 2022) (Member Chat 2nd Half)

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 “🔴 Power BI tips from the Pros – LIVE (June 18, 2022) (Member Chat 2nd Half)” →

How To Handle Missing Data In Python With Interpolation

Posted on by Annie D

Interpolation is a method for generating points between given points. In Python, Interpolation is a technique mostly used to impute missing values in the data frame or series while preprocessing data. In this tutorial, Gaelim is going to show how you can use Interpolation to estimate missing data points in your data using Python in Power BI.

DESCRIPTION:

***** Video Details *****
00:00 Introduction
00:25 Original data
00:49 Types of estimation
01:17 Methods of interpolation
03:46 Data set
04:39 Data types
06:22 Index
07:05 Nearest interpolation
09:12 Linear interpolation
09:16 Weighted time interpolation
09:42 Flag
11:15 Troubleshooting & test run

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – <a href="http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi" Continue reading “How To Handle Missing Data In Python With Interpolation” →

🔴 Power BI tips from the Pros – LIVE (June 11, 2022) (Member Chat 2nd Half)

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 “🔴 Power BI tips from the Pros – LIVE (June 11, 2022) (Member Chat 2nd Half)” →

Power BI External Tool with Greg Deckler

Posted on by Annie D

Analyzing, interpreting, and monitoring data is crucial for a business or an organization, and things have never been easier than using Power BI.

Microsoft Power BI creates an analytical environment for monitoring data and sharing reports. It delivers interactive data visualization BI capabilities allowing users to see and share data and insights throughout their organization.

In this episode of The Analytic Mind Podcast, Sam McKay interviews Greg Deckler, Vice President (Microsoft) at Fusion Alliance and is also part of the team at Enterprise DNA, helping them move the needle on some great initiatives.

Find out many exciting things that Continue reading “Power BI External Tool with Greg Deckler” →