Tag: How to

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

Excel Basics Course Trailer. Free Excel Education for the World excelisfun YouTube Learning Playlist

Posted on by Annie D

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

View on YouTube

Dynamically Group Receivables Based On When Cash Is Expected – Power BI Accounting

Posted on by Annie D

During this unique accounting focused example I’m going to showcase how you can create some incredible analysis of your receivables within your organization.

We are going to review some dynamic grouping formula techniques that I believe will amaze you in their ability to showcase information in new and interesting ways.

This scenario can also be referred to as an ‘aged trial balance’

This is also a short break out session from the financial reporting course now available at Enterprise DNA Online.

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

MSPTDA #00, Course Trailer Comprehensive Data Analysis & Business Intelligence Class from excelisfun

Posted on by Annie D

Join Free class from excelisfun at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0ks5W7U5NmDCU2ydSnNZA_1
Introductory Class Video for free YouTube Learning Class Playlist from excelisfun at YouTube. 30 Videos that teach Comprehensive Data Analysis & Business Intelligence using Microsoft Power Tools. Then 30 more references videos for all your Data Analysis needs. There are a total of 66 videos that teach basics to advanced Power Query, Excel Power Pivot, Power BI Desktop (and Online), DAX Formulas and Excel. Taught by Highline College Professor, Michael Girvin.

View on YouTube

Excel Formulas & Functions – excelisfun Flashback Friday 01 – Excel Basics

Posted on by Annie D

Download Excel File: https://ift.tt/2Y0QCSK
In this video learn about formulas and functions from an excelisfun YouTube video posted back in the year 2008. This is a new Friday Event at the excelisfun channel: Flashback Friday. This video is remarkable because it covers most of the basics you need for formulas such as: Formulas Basics, Functions, Excel’s Golden Rule, Number Formatting, Number Formulas and Text Formulas, all in one video! Even though this video was published in 2008, all the content in the video is what you need to know about Excel Formulas and Functions in the year 2019.

View on YouTube

DAX Fridays! #132: Dynamic TopN + Others in Power BI

Posted on by Annie D

I was recently asked to do a TopN + Others for a customer and in this video I will share my solution with you. #curbal #dax #daxfridays #powerbi

Link to RANX video: https://www.youtube.com/watch?v=z2qzJVeYhTY
Gerhard post: https://ift.tt/2LhhfwT

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