Month: April 2022

Who doesn’t like FREE Power BI training??? (2022)

Posted on by Annie D

There are a lot of free Power BI training options out there for business analysts and there is now training beyond that for your organization. Adam explores the latest free options that Microsoft has to grow and learn Power BI!

Matthew’s Blog: https://ssbipolar.com/2021/06/07/free-power-bi-intro-training-from-microsoft/

Microsoft Stores Power BI Intro Training: https://www.microsoft.com/store/workshops-training-and-events/professionals#keyword=Power%20BI

Instructor Led Training: https://aka.ms/pbitraining

Power BI Learn Content: https://docs.microsoft.com/learn/powerplatform/power-bi

Guidance Documentation: https://docs.microsoft.com/power-bi/guidance/overview

Adoption Roadmap: https://docs.microsoft.com/power-bi/guidance/powerbi-adoption-roadmap-overview

Implementation Planning: https://docs.microsoft.com/power-bi/guidance/powerbi-implementation-planning-introduction

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next Continue reading “Who doesn’t like FREE Power BI training??? (2022)” →

Enterprise Analytics Summit – FREE virtual training event from 22 Power BI Experts around the world!

Posted on by Annie D

Register here: https://enterprisedna.co/enterprise-analytics-summit-february-2022-registration/

Be part of a powerful data revolution as we deliver an empowering learning experience through the Enterprise Analytics Summit 2022 happening from February 21 to 25, with over 20 training sessions and discussions about all things data and Power BI. It’s going to be 5 days of insights and knowledge from industry experts, helping you shape your future in analytics.

Watch as our founder, Sam McKay, gives an overview on what to expect from this event.

Know more about the Enterprise Analytics Summit here: https://blog.enterprisedna.co/enterprise-analytics-summit-2022-free-powerful-learning-event/

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Continue reading “Enterprise Analytics Summit – FREE virtual training event from 22 Power BI Experts around the world!” →

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

Data Storytelling & User-centered Design In Power BI — Upcoming New Course

Posted on by Annie D

Power BI is a great tool for presenting, visualizing and analyzing data regardless of the field of expertise you want to use it for. One of the things that could make it even more effective is knowing how to tell a story using your data.

In this video, Brian is joined by Enterprise DNA expert and world-renowned Power BI Designer, Alex Badiu, as they give an overview on what our upcoming new course is all about that’s centered on exploring best practices in report design from a whole range of different perspectives.

Read more about the course here: https://blog.enterprisedna.co/data-storytelling-user-centered-design-in-power-bi/

***** Continue reading “Data Storytelling & User-centered Design In Power BI — Upcoming New Course” →

Correlation and Regression in Excel

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/correlation-and-regression-in-excel-april-2022-registration/

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

When is it?
April 21st – 12pm New York (ET), 9am Los Angeles (PT), 5pm London (BST)
April 22nd – 2am Sydney (AEST), 4am Auckland (NZST)

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

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

During This Free Training, You Will Learn:

• Explore the relationship between correlation and causation
• Summarize and visualize linear relationships in Excel
• Interpret regression results for real world impact

If you have questions regarding this training, please send it to Continue reading “Correlation and Regression in Excel” →

Demystifying Custom Partitions in Power BI

Posted on by Annie D

We talk about Incremental Refresh a lot, but what if you need custom partitions in Power BI? How do you even create those? They look scary! Patrick takes the mystery away and walks you through how you can create them.

Partitions in tabular models
https://docs.microsoft.com/analysis-services/tabular-models/partitions-ssas-tabular

📢 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
— rel=”nofollow”>http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #Partitions #GuyInACube

XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1791.xlsx
Learn three important lookup formula tricks: Lookup Last Item, Lookup First Item, Lookup and Return All Matching Records.
Topics:
1. (00:00) Introduction
2. (00:13) Product Lookup Table
3. (00:46) Lookup First using XLOOKUP function (Microsoft 365 = New School)
4. (01:38) Lookup Last using XLOOKUP function (Microsoft 365 = New School)
5. (02:29) Lookup All Matching Records using FILTER function (Microsoft 365 = New School)
6. (03:32) Lookup First using VLOOKUP function (Any Version of Excel)
7. (04:18) Lookup Last using LOOKUP function and Array Operation (Any Version of Excel)
8. (06:11) Lookup All Matching Records using Complicated Array Formula (Any Version Continue reading “XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791” →

Blown AWAY by Column From Examples in Power Query

Posted on by Annie D

Column From Examples, in Power Query, keeps blowing our mind! Patrick shows you an example where he wanted to extract some data. Will Column From Examples work? Of course, it will! Check this out!

Add a column from examples in Power BI Desktop
https://docs.microsoft.com/power-bi/create-reports/desktop-add-column-from-example

📢 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 “Blown AWAY by Column From Examples in Power Query” →

Excel Can You Merge Cells In A Table – 2483

Posted on by Annie D

Uncle S is trying to have a formula copy to new rows. So a table seems like a great way. But he also has merged cells and the table unmerges those.

In this video, two surprising Table tricks:
First, a table can contain Center Across Selection, which is better than Merging Cells in Excel.
Second, a surprising discovery from the Excelforo channel about new headings in a table.

Table of Contents
(0:00) Auto-copying formulas to new rows in Excel
(2:31) Can a table have a merged cell
(4:00) New table columns using custom lists in Excel

How To Use The Send Mouse Click In Power Automate For Improved Flow Performance

Posted on by Annie D

You’ll most likely run into issues of not being able to use an item as a UI element or a button when creating flows in Power Automate. Using the Send Mouse Click action is a good option to solve these kinds of issues. In this video, Jarrett is going to show how you can utilize the Send Mouse Click action to simulate mouse movement and improve the performance of your flows.

***** Video Details *****
00:00 Introduction
01:23 Sample flow
01:49 Microsoft documentation
02:12 Setting parameters
07:45 Adjusting the flow
08:15 Test run

***** Related Links *****
Send Mouse Click Microsoft Documentation – https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/mouseandkeyboard#sendmouseclick

***** Learning Power Continue reading “How To Use The Send Mouse Click In Power Automate For Improved Flow Performance” →

Excel Statistical Analysis 29: HYPGEOM.DIST Function for Conditional Probabilities Across # Trials

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch05-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch05-ESA.pdf
Learn about Hypergeometric Distribution and HYPGEOM.DIST Function to calculate AND Logical Test probabilities for when you have Conditional Probabilities Across a Fixed Number of Trials.
Topics:
1. (00:00) Introduction
2. (00:30) AND Logical Test with Conditional Probabilities for Pulling Two Straight Queens in Two Tries. Long Hand Formula
3. (04:55) HYPGEOM.DIST Function to calculate AND Logical Test probabilities for when you have Conditional Probabilities Across a Fixed Number of Trials. For Hypergeometric Distribution
4. (06:35) Pulling 2 Queen Cards in Five Tries Probability from sample points and with HYPGEOM.DIST function
5. (09:01) HYPGEOM.DIST Continue reading “Excel Statistical Analysis 29: HYPGEOM.DIST Function for Conditional Probabilities Across # Trials” →

Excel Pivot Table Months Or Weekdays Are Alphabetical – 2482

Posted on by Annie D

You have a pivot table in Excel. The months and weekday names are appearing alphabetically instead of in calendar sequence. This happens when your pivot table is based on external data or the data model.
There are two solutions. This video prefers using the Custom Sort Order option. This takes 8 clicks to fix the months and 8 clicks to fix weekdays.
If your Pivot Table Slicers are in the wrong sequence, then you should use the Data Model setting to sort one column by another column.