Month: August 2019

Enterprise DNA Learning Summit – August 2019, DAX Formula Combinations

Posted on by Annie D

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 4: DAX Formula Combinations

When looking to scale your work in Power BI, you want to understand how you can reuse DAX formula combinations throughout your model. The speed in which you can create detailed analysis is significant when you utilize these techniques.

I will be covering techniques such as cumulative totals, grouping, averaging, and more.

• How to scale your development w/ DAX
• How to quickly create compelling analysis
• Analyze trends and time-based information
• Learn to re-use similar combinations of formula

View on YouTube

#D50 Reuse and customize your Power BI service usage reports

Posted on by Annie D

In today’s video I am going to show you how to reuse and modify your power bi Usage reports 🙂

This trick was shared by Kasper DeJonge here: https://ift.tt/2uXB0wH and there you will find the link to Gilbert’s post too. Enjoy!

You can download the pbix files here: https://ift.tt/2yGx9Ih and then community downloads number #50.

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:
https://ift.tt/2NEZM2b

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/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:

https://ift.tt/2NrgChB

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://ift.tt/2I8nl09

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

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

View on YouTube

Enterprise DNA Learning Summit – August 2019, CALCULATE vs CALCULATETABLE

Posted on by Annie D

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 3 – CALCULATE vs CALCULATETABLE

With CALCULATE and CALCULATETABLE you have two of the most important functions in the entire DAX language. Understanding how these two functions operate is essential to any advanced analytical work in Power BI.

During this particular session, we will be drilling into the main differences between these two DAX formulas and also when it’s appropriate to use either one inside your calculated logic.

• Understand what CALCULATE does in-depth
• Start using CALCULATE correctly
• When to use CALCULATETABLE
• The main differences between these two functions

View on YouTube

Power Query Running Count Based on Row Condition – Excel Magic Trick 1588

Posted on by Annie D

COUNTIFS($A$1:A1,A1) Formula in Power Query? – Excel Magic Trick 1588
Download Excel File: https://ift.tt/2OTCWpe
Learn how to create a Power Query Custom Column Formula that has an expandable range, counts based on the row condition and is equivalent to the Excel Worksheet Formula COUNTIFS($A$1:A1,A1). See how to use the Power Query Functions Table.AddColumn and Table.SelectRows. Also see how to create Two Custom Functions so we can access the Outside Table and Inside Table in the same formula.

View on YouTube

Enterprise DNA Learning Summit – August 2019, DAX Fundamentals

Posted on by Annie D

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 2 – DAX Fundamentals

To harness the analytical power behind Power BI, you really need to master DAX. DAX is the formula language which enables you to discover incredible insights into your data.

Throughout the session, we’ll be diving into some initial key concepts that you certainly will want to understand thoroughly when creating reports with Power BI. These include topics such as iterating functions, context, and measure syntax to name a few.

• Review the concept of context
• Iterating vs Aggregating functions
• Understand how DAX works w/ the data model
• How to structure and organize your measures

View on YouTube

Enterprise DNA Learning Summit – August 2019, Data Model Design Best Practices

Posted on by Annie D

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 1 – Data Model Design Best Practices

During this first session, we will be covering aspects of data modeling when working with multiple tables. Getting your model set up correctly in Power BI is absolutely essential to creating a scalable solution.

Enterprise DNA has many best practices to utilize in this particular area. Ideas around how to structure your model and also how to connect the right relationships between your tables.

• Learn how to optimize data
• Setup data model structure
• Relationship best practices
• Unique data model designs
• Working w/ multiple tables

View on YouTube

Renewed MVP!! ….but I should do better…

Posted on by Annie D

Here you can download all the pbix files: https://ift.tt/2yGx9Ih

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:
https://ift.tt/2NEZM2b

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/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:

https://ift.tt/2NrgChB

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://ift.tt/2I8nl09

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

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

View on YouTube

Count Number of Saturdays in Month – 5 Different Formulas!- Excel Magic Trick 1587

Posted on by Annie D

Download Excel File: https://ift.tt/2KoRI3i
5 different formulas to count the number of Saturdays in any month:
1. (00:01) Introduction
2. (00:43) SEQUENCE, EOMONTH, DAY, WORKDAY and SUM functions in one formula.
3. (03:04) SUMPRODUCT, ROW, INDIRECT, EOMONTH and WORKDAY functions in one formula.
4. (04:45) Bonus Formula #1, same as previous but rather than doing double negative to convert TRUEs and FALSEs to ones and zeroes, we use the mysterious N Function
5. (05:06) NETWORKDAYS.INTL and EOMONTH functions in one formula. Learn about Text String of ones and zeroes to indicate the Monday through Sunday days that are workdays and not workdays.
6. (06:25) Bonus Formula #2: Amazing Dynamic solution that is linked to cell so we can choose any day and count how many in a month. Same as previous but we use an Array Constant, the Not Comparative Operator, Double Negative and the CONCAT function in the weekend argument of the NETWORKDAYS.INTL function.

View on YouTube

Dynamic Arrays to Increment 1-6, 7-12, 13-18 – SEQUENCE Array Function… – Excel Magic Trick 1586

Posted on by Annie D

Download Excel File: https://ift.tt/2KoRI3i
Learn how to use a Dynamic Array Formula to increment numbers to create labels like: 1-6, 7-12, 13-18 and so on for Raffle Ticket Categories.

View on YouTube

DAX Fridays! #136: Correlation in Power BI

Posted on by Annie D

In today’s video I will show you what correlation is and how to calculate it in power bi, as well as show you the correlation custom visual. #powerbi #curbal #dax #daxfridays

Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU

Link to EXCEL SURVEY: https://1drv.ms/xs/s!Ar8CDNp8cGTcgjaHonN82T8I1jQT

Here you can download all the pbix files: https://ift.tt/2yGx9Ih

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

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://ift.tt/2NEZM2b

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/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:

https://ift.tt/2NrgChB

Many thanks in advance!Here you can download all the pbix files: https://ift.tt/2yGx9Ih

▲▲▲▲▲▲▲▲▲▲

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

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

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://ift.tt/2I8nl09

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

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

#daxfridays #curbal #dax #powerbi #mvp

View on YouTube

DAX Fridays! #136: Correlation in Power BI

Posted on by Annie D

In today’s video I will show you what correlation is and how to calculate it in power bi, as well as show you the correlation custom visual. #powerbi #curbal #dax #daxfridays

Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU

Link to EXCEL SURVEY: https://1drv.ms/xs/s!Ar8CDNp8cGTcgjaHonN82T8I1jQT

Here you can download all the pbix files: https://ift.tt/2yGx9Ih

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

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://ift.tt/2NEZM2b

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/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:

https://ift.tt/2NrgChB

Many thanks in advance!Here you can download all the pbix files: https://ift.tt/2yGx9Ih

▲▲▲▲▲▲▲▲▲▲

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

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

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://ift.tt/2I8nl09

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

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

#daxfridays #curbal #dax #powerbi #mvp

View on YouTube

Enterprise DNA Learning Summit – August 2019 PREVIEW

Posted on by Annie D

REGISTRATION FOR THIS SUMMIT – https://ift.tt/2OPUJOe

FOR MORE DETAILS ON THE EVENT – https://ift.tt/2yMzfH9

Summit is free for all Power BI users.

EVENT DETAILS

Session 1 – Data Model Design Best Practices

Learn how to optimize data
Setup data model structure
Relationship best practices
Unique data model designs
Working w/ multiple tables

Session 2 – DAX Fundamentals

Review the concept of context
Iterating vs Aggregating functions
Understand how DAX works w/ the data model
How to structure and organize your measures

Session 3 – CALCULATE vs CALCULATETABLE

Understand what CALCULATE does in-depth
Start using CALCULATE correctly
When to use CALCULATETABLE
The main differences between these two functions

Session 4 – DAX Formula Combinations

How to scale your development w/ DAX
How to quickly create compelling analysis
Analyze trends and time-based information
Learn to re-use similar combinations of formula

Session 5 – Budgeting Techniques

Learn to deal w/ data at different granularity
Manage a more complex data model
Learn how to create virtual relationships using TREATAS
Review Actuals vs Targets overtime

Session 6 – Optimizing DAX Formulas

Learn to structure your formulas correctly
Master the proper syntax and best practices for measures
Understand why your formula is working slowly
Learn auditing techniques to optimize your measures
Understands more deeply how formulas are calculated

View on YouTube