Tag: Power BI

Effective Power BI Reporting for Analysts – Enterprise DNA Webinar Series

Posted on by Annie D

TO VIEW REPLAY & DOWNLOAD RESOURCE REGISTER HERE – https://ift.tt/30b1ET4

When is it?
July 3rd, 6pm New York (EDT), 3pm Los Angeles (PDT) , 11pm London (GMT) – July 4th, 8am Sydney (AEDT), 10am Auckland (NZST)

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

Who’s doing it?
Presented by Sam McKay, Founder of Enterprise DNA – Driving an analytical movement through using Power BI!

Why should I be there?
To learn how to develop compelling dashboards within Power BI using a range of analytical and visualisation techniques

What’s it all about?
We’ll be reviewing a number of techiques specifically around reporting dashboards in Power BI. Power BI is not just a visualisation tool, it is a powerful analytical engine that can produce amazing insights so I’ll be going over how you can combine both of these crucial elements to your reporting

View on YouTube

Iterating Functions Deep Dive – SUMX, AVERAGEX, MINX, MAXX

Posted on by Annie D

In Power BI you must understand the difference between aggregating functions and iterating functions very well.

In this tutorial we’ll be diving into iterating functions including SUMX, AVERAGEX, MINX & MAXX. Well be seeing the various ways they can be used and also going into detail how results are actually calculated when using these formulas.

These are some crucial concepts in Power BI when using DAX, so certainly dive into this content in detail and start practicing when you can using these techniques.

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Total Number Of Staff Over Time

Posted on by Annie D

In this example we are attempting to work out how many staff we have at any one time.

The technique discussed here are relevant for when you have a table with multiple dates in it and you need to run logic through that table to work out if an employee is still a staff member at any period of time.

This is also the technique to use if you want to showcase staff numbers or growth through time.

We utilise the correct relationship technique and also the ‘events in progress’ pattern to get this all to work successfully in Power BI.

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Calculate The Difference In Days Between Purchases Or Events In Power BI Using DAX

Posted on by Annie D

In this example I will show you how you can calculated the difference in days between purchases in Power BI using DAX formulas.

There is some advanced logic here using the FILTER and CALCULATE functions.

This is a great insights if you want to work out trends in customer behaviour or would like the target marketing campaigns more specifically to relevant customers.

Enjoy working through this tutorial.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Calculate The Occupancy Days Per Month In Power BI Using DAX

Posted on by Annie D

In this unique example, I will show you how we can dynamically show how many occupancy days per month in a matrix visual.

This is a great example of the power and simplicity of the DAX formula language. Where you can write a straight forward measure and extract some fascinating information and still be able to dynamically filter the data further to showcase varied insights seamlessly.

Enjoy working through this examples

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2SGof6C

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2AyEb3P

FREE – Power BI Resources – http://bit.ly/2C2aBn3

FREE – 60 Page DAX Reference Guide Download – http://bit.ly/2AyEc7T

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

Enterprise DNA Membership – http://bit.ly/2AAqa5u

View on YouTube

How To Manage Multiple Date Calculations In Your Fact Tables – Advanced Power BI

Posted on by Annie D

Managing multiple dates in your fact tables in Power BI can sometimes be very confusing when starting out in Power BI.

The idea behind this tutorial is to explain the logic and techniques required to get this working correctly in Power BI.

You need to get the right relationships and then use the correct DAX formula patterns when managing multiple date calculations.

Enjoy

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2SGof6C

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2AyEb3P

FREE – Power BI Resources – http://bit.ly/2C2aBn3

FREE – 60 Page DAX Reference Guide Download – http://bit.ly/2AyEc7T

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

Enterprise DNA Membership – http://bit.ly/2AAqa5u

View on YouTube

Calculate A Monthly Moving Average Year To Date (YTD) in Power BI Using DAX

Posted on by Annie D

In this tutorial we work through how you can calculate the year to date moving average of results in Power BI using DAX.

It is common to show the absolute YTD numbers but not the average YTD numbers, so it was a good opportunity to jump into the unique calculation and show you how it can be done.

Good Luck

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2SGof6C

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2AyEb3P

FREE – Power BI Resources – http://bit.ly/2C2aBn3

FREE – 60 Page DAX Reference Guide Download – http://bit.ly/2AyEc7T

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

Enterprise DNA Membership – http://bit.ly/2AAqa5u

View on YouTube

Calculate The Last Or Max Value Within A Table Of Data Using DAX In Power BI

Posted on by Annie D

In this tutorial we review how you can work out when the last value from a particular dimension in a table in Power BI.

This is quite a unique insight but a relevant one from many pieces of analysis that you might require in Power BI.

We work through examples of the MAXX and FILTER functions. These are two important functions in the DAX language that can be used in many situations to extract very interesting insights from your data.

Good luck.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2SGof6C

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2AyEb3P

FREE – Power BI Resources – http://bit.ly/2C2aBn3

FREE – 60 Page DAX Reference Guide Download – http://bit.ly/2AyEc7T

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

Enterprise DNA Membership – http://bit.ly/2AAqa5u

View on YouTube

Detecting and Showcasing Outliers in Power BI – Enterprise DNA Webinar Series

Posted on by Annie D

Gain Access to Resource Download by Registering Here – http://bit.ly/2RplO8C

Workshop Session Topics:
– Creating scatter charts and breaking-out outlier results
– Comparing customers who are considered outliers versus those that aren’t
– Showcasing dynamically how outlier customer groups change over time
– Drilling down into what causes outliers through time

***** Learning Power BI? *****

All Enterprise DNA TV Resources – http://bit.ly/2ZhmVtV…
FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2ESTLcy…
FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2ESTLcy…
FREE – Power BI Resources – http://bit.ly/2ZfnaWh…
Learn more about Enterprise DNA – http://bit.ly/2RacRD3

View on YouTube

Scenario Analysis Patterns in Power BI using DAX

Posted on by Annie D

Gain access to resource download by registering here – http://bit.ly/2EV1hne

What’s it all about? We’ll be reviewing a number of techniques specifically around scenarios analysis in Power BI. Don’t just think Power BI is just a visualization tool, it is a powerful analytical engine that can produce amazing insights including running custom scenarios on your raw data.

***** Learning Power BI? *****

All Enterprise DNA TV Resources – http://bit.ly/2ZhmVtV…

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2ESTLcy…

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2ESTLcy…

FREE – Power BI Resources – http://bit.ly/2ZfnaWh…

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

View on YouTube

In the head of: Marc and Dave, the Power BI cheatsheet authors

Posted on by Annie D

During SQL Saturday in Stockholm, i had a chance to meet Dave and Marc, the authors of the Power BI Cheat Sheet and had a chat with them. Thanks guys!
#powerbi #cheetsheet #curbal

Download the Power Bi cheatsheet here: http://bit.ly/2EFUPR0

and here is the merch for charity:
http://bit.ly/2XciHmt

Here you can download all the pbix files: http://bit.ly/2PUURaz

SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
http://bit.ly/2V15a0p

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://bit.ly/2qhiZvU

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

http://bit.ly/2V3o0Ux

Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲

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

What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!

https://amzn.to/2YRfIBm

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

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB

View on YouTube

Average Last 3 Customer Sales: Power Query, DAX Measure or Worksheet Formula

Posted on by Annie D

Download Excel Finished Files: http://bit.ly/2K9SNfn
Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs

In this video learn how to Average a customers last three sales (last three dates) using Excel Worksheet Formulas, Power Query M Code and a Power Pivot & Power BI DAX Measure.
Topics:
1. (00:07) Introduction
2. (00:50) Sort Method
3. (02:09) Excel Worksheet Formulas, including AGGREGATE and AVERAGEIFS functions.
4. (05:27) LARGE Function and New Excel Office 365 Calculation Engine
5. (08:15) Power Query M Code, including Table.Sort, List.Average and List.FirstN M Code functions
6. (12:46) Power Query Parameter Query with condition coming from Excel Worksheet
7. (14:05) Power Pivot & Power BI DAX Measure, including TOPN, CALCULATE and AVERAGE DAX Functions
8. (17:08) DAX Parameter from Excel Worksheet using VALUES DAX Function.
9. (18:43) Add new records to table and test formulas
10. (19:00) Fix Power Query Table.Sort bug using Dummy Insert Column
11. (20:08) Fix Power Query Table.Sort bug using Table.Sort function inside Table.Group Function
12. (22:12) Conclusion

View on YouTube