Month: July 2019

Advanced RANKX – How To Understand This Function More Deeply

Posted on by Annie D

In this particular tutorial I’ll be diving into the RANKX function and how complex it can be at times.

By working through an example I hope that you can understand the many nuances to working with this particular function.

You first need a solid understanding of context and then also how to use RANKX within that context.

Enjoy!

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

Excel Keyboard to Insert Sheet & Rename Sheet. Excel Magic Trick 1565. (Sheet Tab or Worksheet)

Posted on by Annie D

Download Excel File: https://ift.tt/2JBlq4q
This video shows how to insert an Excel Sheet (also known as Sheet Tab or Worksheet) with the Excel Keyboard: Shift + F11. Also see keyboard to Rename a Sheet: Alt, H, O, R.

View on YouTube

Excel for Statistical Analysis Course Trailer. Free YouTube Learning Playlist Class from excelisfun.

Posted on by Annie D

Join Free class from excelisfun at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0ngx_uPhvasTbOWLOztsaBj
Learn University Business & Economics Statistics Class from the world renowned Excel Educator, Mike Girvin, Microsoft Excel MVP and Highline College Professor. 73 videos, free notes, Excel files make this THE best free online class for learning how to use Excel to do all of your University Statistical Tasks. This class uses the amazing new YouTube Learning Playlist structure. This is the Highline College Busn 210 class taught by Michael Girvin.

View on YouTube

Data Talks #2: How to hire your next Power BI Analyst

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

Logistics Insights For Power BI – DAX And Data Modeling Overview

Posted on by Annie D

In this particular example we will cover how you can solve for logistics insights in Power BI.

This has a lot to do with dealing with multiple dates in your fact table, then using the events in progress pattern with DAX.

This is a really good real-world application of a variety of Power BI techniques.

Enjoy working through this one.

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

4 Types of Criteria for SUMIFS & COUNTIFS – Excel Magic Trick 1564, SUMIF & COUNTIF too

Posted on by Annie D

SUMIFS & COUNTIFS: 4 Types of Criteria: Cell Reference, Hard Code, Operator Joined, Array
Download Excel File: https://ift.tt/2jXe8yh
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
In this video
Topics:
1. (00:01) Intro
2. (00:32) Cell Reference as Criteria for SUMIFS
3. (01:22) Hard Coded Value as Criteria for COUNTIFS
4. (01:43) Excel’s Golden Rule
5. (02:28) Cell Reference Joined To Comparative Operator as Criteria in COUNTIFS, See an AND Logical Test
6. (04:29) Array Criteria (Function Argument Array Operation) as Criteria for SUMIFS, see and OR Logical Test and the SUMPRODUCT Function
7. (06:16) Conclusion

View on YouTube

Cluster Analysis Visualization Techniques For Power BI – Power BI Review

Posted on by Annie D

In this break out session from a recent Enterprise DNA Learning Summit workshop, we are diving into how you can showcase data clusters in Power BI.

Not only this we are also showing how these data clusters change through time.

There are many DAX concepts and also visualization techniques discussed during this tutorial.

Enjoy.

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

Last Working Day Of Month – Excel Formula – Excel Magic Trick 1563

Posted on by Annie D

Download Excel File: https://ift.tt/2jXe8yh
In this video see how to create an Excel Formula that can calculate the Last Working Day In The Month using EOMONTH Function and the WORKDAY.INTL function.

View on YouTube

Advanced Excel Course Trailer. Free Advanced Excel Training from excelisfun YouTube Learning

Posted on by Annie D

Join Free class from excelisfun at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw
Learn Advanced Excel from the world renowned Excel Educator, Mike Girvin, Microsoft Excel MVP and Highline College Professor. 27 videos, free notes, Excel files and homework problems make this the #1 Free Online Advanced Excel Class in the world. This class uses the amazing new YouTube Learning Playlist structure.

View on YouTube

#D49 – Add rows and columns to tables using M in power query

Posted on by Annie D

In this video, I am going to show you how to add column and rows to a table in power query without appending it. Simply using the M language. #powerquery #curbal #powerbi

Here you can download all the pbix file (download 49- community downloads): 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

#MAGICMONDAYS #CURBAL #POWERQUERY #POWERBI #MVP

View on YouTube

Time Based Cohort Analysis – How To Setup Your Data Model In Power BI

Posted on by Annie D

In this example we’re going to work through how you can create time based cohort insights within Power BI.

You need to get a number of development techniques right here to make it all work, including with the data model and also with your DAX formulas.

This is a break out session from a recent Enterprise DNA member only event.

Enjoy working through this advanced analytics example for Power BI.

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