Tag: Productivity

Why you should disable Auto Date/Time – May 2019 Power BI Desktop Update

Posted on by Annie D

One of the new features released in the May 2019 Power BI Desktop update is global disable Auto Date/Time feature. Do you know why? Let me show you in this video.
#powerweek #curbal #powerbi

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

Enterprise DNA Learning Summit – May 2019, Logistics Management

Posted on by Annie D

EVENT DETAILS – http://bit.ly/2VlegnG

Session 4 – Logistics Management

In this session, I will be covering a topic I’ve haven’t reviewed too often before around analyzing events through time.

We’ll be running through a common problem developers have when working with Power BI. That is, dealing with multiple dates and creating compelling analysis around them.

• Events in progress pattern
• Managing multiple dates in fact tables
• Unique data model techniques
• Branching out into complex logic
• Advanced DAX function insights

View on YouTube

Enterprise DNA Learning Summit – May 2019, Session 3

Posted on by Annie D

EVENT DETAILS – http://bit.ly/2VlegnG

Session 3 – Cluster & Groups Analysis

In this session we’ll be covering a grouping technique that allows you to review clusters of your data points.

This is a very powerful analysis technique in Power BI that is incredibly flexible. You can use it in nearly any analytical scenario that you come across.

I can’t wait to show you grouping technique which will have a lot of real-world application for anyone who’s looking to complete this type of analysis with Power BI.

• Creating dynamic group insights
• Editing visual interactions smartly
• Extending supporting tables in models
• Grouping formula patterns
• Highlight important clusters of information

View on YouTube

[FREE Excel Course] Lesson 20 – Excel Conditional Formatting (All You need to Know + Examples)

Posted on by Annie D

In this video, you will learn all about conditional formatting in Excel.

The video covers the following topics:

— Introduction to Conditional Formatting
— Using Formula in Conditional Formatting
— Advanced Examples (Highlight Every Nth Row, Creating Dynamic Search)

Conditional formatting is a great feature in Excel that allows you to highlight data points based on the specified conditions.

There are many awesome things you can do with conditional formatting in Excel and this video covers a few examples of that.

This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX

You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

FREE Online Excel Training – Video Course for Beginners


-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube

The perfomance analyzer review – May 2019 Power BI Desktop Update

Posted on by Annie D

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

Enterprise DNA Learning Summit – May 2019, Session 2

Posted on by Annie D

EVENT DETAILS – http://bit.ly/2VlegnG

Session 2 – Parameter Tables

In the second live session, we’ll be covering parameter tables and how you can use them in Power BI

I will be running through a real-world discounting scenario where using parameter tables is essential. The largest takeaway from this session is how to think about the variables that you can include in your data and how far you can take your analysis.

Sometimes it’s difficult to know where to start with this type of work but I plan to go through my thought process here and hopefully many of these tips can move into your own development processes over time.

• Creating and using parameter tables
• How to plan for implementation
• Real-world discounting scenarios
• Extending calculations w/measure branching
• Showcasing the key insights

View on YouTube

Enterprise DNA Learning Summit – May 2019, Session 1

Posted on by Annie D

EVENT DETAILS – http://bit.ly/2VlegnG

Session 1 – DAX Basics & CALCULATE

During the very first session of the event, I’ll be completing a quick intro and then run through the data and resources we’ll be using. The main part of the session will be about covering key beginner to intermediate concepts around DAX functions.

DAX is crucial to really mastering Power BI and creating compelling analysis, so will look to review what I believe to be essentials for those just starting out with Power BI.

• Intro to key DAX functions
• Deep dive into CALCULATE
• Time Intelligence Formulas
• Cumulative Totals
• Unique Ranking Technique

View on YouTube

[FREE Excel Course] Lesson 19 – Data Sorting & Filtering (Basic + Advanced))

Posted on by Annie D

In this video, you will learn about data sorting and filtering in Excel. It covers the following topics:

— Data Sorting
— Multi-Levels of Sorting
— Data Filtering
— Advanced Filtering
— Filtering and Sorting in Excel Data Tables

Excel has many data analysis functionalities and a good knowledge of filtering and sorting data in Excel will help you analyze a huge amount of data easily.

This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX

You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

FREE Online Excel Training – Video Course for Beginners


-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube

KPI visuals, line charts, filter pane updates on May 2019 Power BI Desktop Update

Posted on by Annie D

In this video I will review the new reporting features released on the Power BI desktop Update for May, and take the opportunity to explaing in more detail how the KPI visual works.
#powerweek #curbal #powerbi

Keynotes:
1. Reorder filter pane in power bi
2. change the position of the legends in the line chart
3. Change the text size of the KPI visual and explain how it works

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

Excel Magic Trick 1551: Lookup Discounted Price? 2 VLOOKUPs & ROUND

Posted on by Annie D

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

In this video learn how to to lookup a discounted price based on Product Name and Units Discount. See how to use 2 VLOOKUP Functions & the ROUND Function in a single formula.

View on YouTube

[FREE Excel Course] Lesson 18 – Data Validation in Excel (drop-down lists)

Posted on by Annie D

In this video, you will learn about using data validation and drop-down lists.

It covers the following topics:
— Data Validation Criteria
— Input Message
— Customizing Error Messages
— Circle Invalid Entries
— Advanced Data Validation Tricks (such as Create Dependent Validation, Make Sub Headings in Validation, Disguise Numbers as Text, Creating Dynamic Drop Down List)

This video is a part of my Free online Excel training where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX

You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

FREE Online Excel Training – Video Course for Beginners


-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube

MSPTDA 24: DAX Multiply / Divide Data Types Discrepancies Solved!

Posted on by Annie D

Download files:
Start File: http://bit.ly/2w4SgDh
Finished File: http://bit.ly/2Q6ESYH
pdf notes for Video #24: http://bit.ly/2w7crRe

In this video learn about how different DAX Data Types can affect multiplication and division results and yield different answers depending on the order of the multiplication or division. This apparently violates the Commutative Property of Multiplication.
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

View on YouTube