Tag: How to

[Part 3/3] Branding the FIFA 🏆 2019 Power BI report

Posted on by Annie D

In todays video we will build the report navigation, branding and all other elements to make the fifa 2019 report fully functional. #powerbi #curbal #fifa #fifawwc #fifa2019

Useful links:
Link to Part 1: https://www.youtube.com/watch?v=pRxQyYEgfrI
Link to Part 2: https://www.youtube.com/watch?v=46dQsJLHLOw

Here is a link to the fifa blog post where I walk you through how I created this report: http://bit.ly/2I4AlDz
FIFA playlist: https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw/playlists
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

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

Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554

Posted on by Annie D

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

In this video learn how to create Power Query M Code formulas for Exact Match and Approximate Match Two Way Lookup.

Topics:
1. (00:06) Introduction
2. (00:40) Exact and Approximate Match Lookup
3. (01:44) Worksheet Exact Match Two-Way Lookup with VLOOKUP & MATCH functions.
4. (04:11) Power Query Exact Match Two-Way Lookup using M Code formulas. Learn M Code Syntax for looking up a Record. Use the Record.Field Function.
5. (10:40) Worksheet Approximate Match Two-Way Lookup using an Array Formula with VLOOKUP & MATCH functions.
6. (13:25) Power Query Approximate Match Two-Way Lookup using M Code formulas. Learn about Custom Functions. Use the Table.AddColumn, Table.SelectRows and List.Last Functions. Learn syntax for Custom Functions, including the each keyword for Custom Functions or explicitly defined M Code Custom Functions. Learn how to create formulas with back to back custom functions.
7. (20:55) Summary

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

[Part 2/3] Builiding the visualizations for the FIFA 🏆 2019 Power BI report

Posted on by Annie D

In today’s video we continue the series on how to build stunning power bi reports and this time, we will build the skeleton of the report, the visuals.
#powerbi #curbal #fifa #fifawwc #fifa2019

Useful links:
Link to Part 1: https://www.youtube.com/watch?v=pRxQyYEgfrI
Here is a link to the fifa blog post where I walk you through how I created this report: http://bit.ly/2I4AlDz
FIFA playlist: https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw/playlists

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

Cool Ways to Analyze Zip Codes In Excel – Episode 2285

Posted on by Annie D

You have a bunch of zip codes (postal codes) in Excel. What can you do with those? Thanks to the new Office 365 Geography Data type, you can easily get the city, county, state or province from Excel. Then, I show you how to use a State slicer to create a zip code map for any state showing where your customers are located.

View on YouTube

[Part 1/3] Creating the storyboard for the FIFA 🏆 2019 Power BI report

Posted on by Annie D

Here is a link to the fifa blog post where I walk you through how I created this report: http://bit.ly/2I4AlDz

And here is the playlist with all the videos: https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw/playlists

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

MSPTDA 30: Order & Ship Dates in Fact Table: DAX Formulas and Data Modeling to Create Reports

Posted on by Annie D

Download files for videos 29 & 39: http://bit.ly/2IDWV56
Class web site with individual file downloads: http://bit.ly/2GF25Ni
pdf notes for Videos 29 & 30: http://bit.ly/31pQafN

In this video learn about how to create a Side By Side Report and a Cross Tabulated Report for Ordered Sales and Shipped Sales when you have two Date Columns in the Fact Table. Learn about Inactive Relationships, the USERELATIONSHIP DAX Function, and how to use Two Date Dimension Tables in a Data Model.
Learn methods that work in both Excel Power Pivot or Power BI Desktop.
Topics:
1. (00:15) Introduction & look at Data Modeling Problem
2. (02:00) Create Active and Inactive Relationship.
3. (03:43) Use the USERELATIONSHIP DAX Function inside the CALCULATE Function to calculate Shipped Sales.
4. (05:07) Create Side-By-Side Report that uses Two Measures and One Date Dimension Table using Excel Power Pivot.
5. (05:34) Create Two Date Dimension Tables using Power Query, then create relationships in Power BI Desktop.
6. (08:48) Create Cross Tabulated Report that uses One Measure and Two Date Dimension Tables using the Martix Visualization in Power BI.
7. (09:36) Conclusion
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

View on YouTube

DAX Fridays! #130: New comparison operator

Posted on by Annie D

Do you know the difference between zeros, nulls and empties?? Lets take a look at that so we can understand why we the power bi team introduced a new comparison operation, kindof… #daxfridays #curbal #powerbi

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: http://bit.ly/2PUURaz

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:
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!Here you can download all the pbix files: http://bit.ly/2PUURaz

▲▲▲▲▲▲▲▲▲▲

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://amzn.to/2YRfIBm

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

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

Excel To Word Using VBA – Learn Excel 2284

Posted on by Annie D

Robert asks: Is there a fast way to take a 60-sheet Excel file and create a series of linked tables in Word? Today, using some code from Suat Ozgur, a macro to solve the problem.

Buy Suat’s Javascript Book: http://bit.ly/2wSvcIi

Download the Macro: http://bit.ly/2XMlOSs

Videos from MBAS: https://www.youtube.com/watch?v=t8EiLCpp-w4&feature=youtu.be

View on YouTube

Pin custom visuals and analytical updates- Power BI Desktop update June 2019

Posted on by Annie D

In today’s video I will review the new Visualization and analytical features released in the June 2019 update of the power bi desktop.
#powerbi #curbal #powerweek

Here is the video on reporting features: https://www.youtube.com/watch?v=CPN2LgVRla0

and the key influencers review:

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

▲▲▲▲▲▲▲▲▲▲

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

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

#POWERWEEK #CURBAL #POWERBI #POWERBIUPDATE #MVP

View on YouTube