Month: June 2019

[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

Deep dive on shared and certified datasets – Power BI Desktop update June 2019

Posted on by Annie D

In today’s video I am going to cover in detail the new shared and certifified datasets capabilities introduced in the Power BI desktop update of June 2019.
#curbal #powerbi #powerweek

Here is the keynotes:
1. Promote a dataset
2. Enable certify certifications
3. Certify datasets
4. New workspace experiences
5. Share datasets between new workspaces
6. Copy datasets between new workspaces

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

MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas

Posted on by Annie D

Download file for video: http://bit.ly/31jt5LE
Class web site with individual file downloads: http://bit.ly/2GF25Ni
pdf notes for Video: http://bit.ly/31pQafN

In this video learn about how to create a Side-By-Side and Cross Tabulated Report for Total Sales for Order Date and Ship Date using SUMIFS Worksheet function, Mixed Cell References and the EOMONTH Function. This is the classic Two Dates in a Fact Table Problem. MSPTDA #29 we solve it with Worksheet formulas and in MSPTDA #30 we use the Data Model and DAX formulas in both Excel Power Pivot and Power BI Desktop.
Topics:
1. (00:15) Introduction & look at Data Modeling Problem when we have two dates in a Fact Table.
2. (01:22) Side-By-Side Report for Total Sales for Order Date and Ship Date using SUMIFS and EOMONTH with Mixed Cell References using two conditions or criteria.
3. (04:22) Custom Number Formatting for both reports so we have useful labels in our report
4. (06:41) Cross Tabulated Report for Total Sales for Order Date and Ship Date using SUMIFS and EOMONTH with Mixed Cell References, and four conditions and criteria.
5. (09:37) Conclusion
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

View on YouTube

Conditional formatting, filters on slicers and more, -Power BI desktop update June 2019

Posted on by Annie D

In this Power BI desktop Update on June 2019, the Power BI team has released some cool new features, one of them my favourite for this month. Which one is yours? #powerbi #curbal #powerweek

Keynotes:
1. New look and feel, what do you think?
2. Filter slicer data- Be careful with this one!
3. Conditional formatting, -what is not to love there?
4. Visual headers tooltips- still in doubt about this one, how about you?
5. Table & matrix custom total label.

Link to sources mentioned in the video:
Performance analyzer part 1: https://youtu.be/UCioY5ZgBkg
Performance analyzer part 2: https://www.youtube.com/watch?v=yMKTt4Y5o60

Conditional formatting w dax: https://www.youtube.com/watch?v=uial9zxDmfU

See you tomorrow with more updates!

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

Convert UTC datetime to local time zones in Power Query

Posted on by Annie D

In today’s video I will show you how to have power query change from utc time to local time so you can follow #FIFAWWC #FIFAWomensWorldCup in your own timezone.
#curbal #powerbi #powerquery

Here are the resources mentioned in the video:
http://bit.ly/2I4AlDz

and the download center to get the FIFA file:
http://bit.ly/2PUURaz

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

Tricky: Find Excel Duplicates Based on Two Columns – 2283

Posted on by Annie D

If you work in Accounts Payable, check out the great resources at https://www.ap-now.com/. Today’s question from a recent webinar that I did for the AP-Now members: Given an Excel worksheet of payments made by accounts payable, how can you look for duplicate payments.
My solution involves the new TEXTJOIN function, the Mark Duplicates feature in Conditional Formatting, and then Filter by Color.

View on YouTube