Month: February 2023

Getting Started w/ Power BI Deployment Pipelines | Innovations In Power BI & Power Platform Summit

Posted on by Annie D

Session 3: Getting Started w/ Power BI Deployment Pipelines

When is it?
February 21st – 3pm Los Angeles (PST), 6pm New York (EST), 11pm London (GMT)
February 22nd – 10am Sydney (AEDT), 12pm Auckland (NZDT)

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 Akshata Revankar – Data Engineering Specialist, McKinsey & Company

During This Free Event, You Will:

• Use a CI/CD pipeline to automate the process of building, testing, and deploying the reports and dashboards
• Move content smoothly from Development/Test to QA to Production with Power BI Deployment Pipelines
• Learn Continue reading “Getting Started w/ Power BI Deployment Pipelines | Innovations In Power BI & Power Platform Summit” →

Embedding A Power App Directly Into Your Power BI Report

Posted on by Annie D

Session 4: Embedding A Power App Directly Into Your Power BI Report

When is it?
February 21st – 6pm Los Angeles (PST), 9pm New York (EST),
February 22nd – 2am London (GMT), 1pm Sydney (AEDT), 3pm Auckland (NZDT)

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 Tim Weinzapfel, Enterprise DNA Expert

During This Free Event, You Will:

• Learn how to embed a Power App into a Power BI report and update data directly
• Create a very simple Power App automatically from a SharePoint List and add to your Continue reading “Embedding A Power App Directly Into Your Power BI Report” →

Excel Formula to Add 12,12,12,12 from a cell to get 48!?!? Excel Magic Trick 1817

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1817.xlsm

Learn about how take CSV Number Data like 12, 12, 12, 12 and add to get 48. See a Microsoft 365 formula and then an Excel Formula that will work in any version of Excel!
Topics:
1. (00:00) Introduction
2. (00:04) Goal of Video
3. (00:26) Microsoft 365 Formula: TEXTSPLIT and SUM
4. (01:23) Formula that works in any version: SUBSITUTUE function
5. (02:12) Excel 4.0 Macro Function and Macro Sheet
6. (03:09) EVALUATE function
7. (04:11) Relative Cell Reference in a Defined Name
8. (05:08) Closing, Video Links

#excelisfun #excel #excelformulas #freeclass #excelfunctions #addtext #freeclasses #freecourse Continue reading “Excel Formula to Add 12,12,12,12 from a cell to get 48!?!? Excel Magic Trick 1817” →

Power BI & Power Automate Better Together | Innovations In Power BI & Power Platform Summit

Posted on by Annie D

Session 5: Power BI & Power Automate Better Together

When is it?
February 21st – 9pm Los Angeles (PST)
February 22nd – 12am New York (EST), 5am London (GMT), 4pm Sydney (AEDT), 6pm Auckland (NZDT)

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 Ilgar Zarbaliyev – Head of Curriculum, Enterprise DNA

During This Free Event, You Will:

• Identify trends in sales and customer behavior and assess the performance of different stores or regions using the LFL Analysis in Retail
• Evaluate the potential impact of different scenarios on a business Continue reading “Power BI & Power Automate Better Together | Innovations In Power BI & Power Platform Summit” →

Power Up w/ The Power Platform | Innovations In Power BI & Power Platform Summit

Posted on by Annie D

Session 6: Power Up w/ The Power Platform

When is it?
February 21st – 11pm Los Angeles (PST)
February 22nd – 2am New York (EST), 7am London (GMT), 6pm Sydney (AEDT), 8pm Auckland (NZDT)

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 Jordi Frijters – Azure Data Solution Architect, DataMotuZ

During This Free Event, You Will:

• Explore the three main components of the Power Platform and how they can come together in an integrated solution
• Discover what a small investment in the Power Platform can accomplish depending on the Continue reading “Power Up w/ The Power Platform | Innovations In Power BI & Power Platform Summit” →

Explore Joins In DAX With/Without Relationships | Innovations In Power BI & Power Platform Summit

Posted on by Annie D

Session 7: Explore Joins In DAX With/Without Relationships

When is it?
February 22nd – 12am Los Angeles (PST), 3am New York (EST), 8am London (GMT), 7pm Sydney (AEDT), 9pm Auckland (NZDT)

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 Arpita Ghosh – Data Scientist

During This Free Event, You Will:

• Explore how to combine data from different tables with or without a relationship in DAX
• Use DAX to join tables that have relationships among them
• Learn the steps to join tables using DAX without a relationship
• Understand Continue reading “Explore Joins In DAX With/Without Relationships | Innovations In Power BI & Power Platform Summit” →

Innovations At Enterprise DNA | Innovations In Power BI & Power Platform Summit

Posted on by Annie D

Session 1: Innovations At Enterprise DNA

When is it?
February 21st – 12pm Los Angeles (PST), 3pm New York (EST), 8pm London (GMT)
February 22nd – 7am Sydney (AEDT), 9am Auckland (NZDT)

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 Sam McKay, CEO & Founder of Enterprise DNA

During This Free Event, You Will:

• Learn more about eDNA will support your data skills development
• Hear about what upgrades have happened recently
• Learn what’s coming next!
• Understand how we are positioning ourselves for the future of data

If you have questions regarding Continue reading “Innovations At Enterprise DNA | Innovations In Power BI & Power Platform Summit” →

Using Excel And HYPERLINK To Automate Custom E-Mail – 2378

Posted on by Annie D

Today, a great idea from Yure in Brazil.
He is using concatenation inside the HYPERLINK function to create a MailTo hyperlink. Click the cell in Excel and your e-mail program opens with the Recipient, Subject, and Body already filled in.
However… it the hyperlink grows to more than 255 characters, we are getting a #VALUE! error instead.
Can you go and vote to ask the Excel team to increase the limit for the HYPERLINK function: https://feedbackportal.microsoft.com/feedback/idea/b71ba7be-0944-ec11-a81a-0022484e21f1

In the meantime, you can use VBA code from Ron De Bruin to send e-mails from Excel. See his code at: rel=”nofollow”>https://www.rondebruin.nl/win/section1.htm

Who remembers the time that Kelly Rowland used Excel to SMS Nelly? Here is a link to that music video. https://www.youtube.com/watch?v=8WYHDfJDPDc

Table of Contents
(0:00) Sending e-mail from Excel using HYPERLINK
(1:19) Hyperlink fails with more than 255 characters
(1:52) Ron De Bruin’s VBA pages for emailing from Excel

Creating Custom KML Regions For Excel 3D Map – 2377

Posted on by Annie D

What if you want to map custom regions in Excel 3D Map?
After yesterday’s video importing KML files from the Census.Gov site, today, we take a look at creating your own KML file using Google Maps and then exporting it to Excel.

In today’s example, I create a custom map of 10 neighborhood allotments.

Google Maps makes it easy to draw new polygons, name them, and then export the layer to KML. You can then import to Excel for Windows using 3D Maps.

Table of Contents
(0:00) Create custom shapes for Excel 3D Maps
(0:22) Neighborhood Allotments
(1:04) Open Google Maps
(1:34) Drawing a polygon for one jurisdiction Continue reading “Creating Custom KML Regions For Excel 3D Map – 2377” →

Excel 3D Map With KML Custom Regions – 2376

Posted on by Annie D

Mapping Census Tracts in Excel.
Excel supports mapping by county, zip code, state, country. But they don’t natively support census tracts. In today’s video, you will see how to download population data and a map KML file from Census.Gov.

Learn how to import the KML file into the 3D Map feature in Excel and make a map from it.

This video also covers:
Downloading a CSV with population by census tract from Data.Census.Gov.
Downloading a KML file by Census Tract
Importing and merging that data in Excel.

Table of Contents
(0:00) Excel Mapping Other Jurisdictions
(0:51) Four Video Sections
(1:19) Examining KML File in Notepad++
(2:14) Opening 3D Map
(2:54) Importing KML Continue reading “Excel 3D Map With KML Custom Regions – 2376” →

Help Delete FAKE excelisfun Account

Posted on by Annie D

Go to this fake channel: https://www.youtube.com/@ExcelIsFun_./about
and report channel as impersonating excelisfun to illegally spread ads. The real account is (they need it in report): https://www.youtube.com/@excelisfun

#fake #abuse #fakeyoutubers #youtube #youtubebots #report #deleteyoutube #bots #illegal

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