Month: May 2019

Enterprise DNA Learning Summit – May 2019, New Power BI Online Experience

Posted on by Annie D

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

Session 6 – New Power BI Online Experience

During the final session, we’ll be running through some of the many great changes to the Power BI online service.

There has been so many, and they have all be huge updates. I look forward to showing and telling you what I think about them!

• Reviewing new features in online service
• New home page experience
• Managing apps, workspaces & reports
• Distributing your insights effectively
• Updated best practices for management

View on YouTube

Enterprise DNA Learning Summit – May 2019, Session 5

Posted on by Annie D

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

Session 5 – Ranking Techniques

In the 5th session, we’ll be covering a variety of ranking techniques that can be used in many different environments and data scenarios.

Formulas such as RANKX and TOPN are some of the harder to learn and understand in Power BI, so I plan to complete a deep dive into them and really show you how they work.

• Covering nuances of RANKX function
• Diving into key topic of ‘context’
• Extending ranking insights further
• Reviewing TOPN and how it works
• Isolate top or bottom sales

View on YouTube

[Free Excel Course] Lesson 21 – Introduction to Excel Charting

Posted on by Annie D

In this video of this Free Excel course, you will learn about Excel charting and how to make useful charts quickly.

It covers the following topics:

— Excel Chart Types
— Chart Editing
— Formatting Chart Elements
— Combination Charts
— Handling Gaps in Charts

Excel has a lot of inbuilt charts that you can use instantly to visualize your data. And there are many combination charts and advanced charts you can create to pack a lot of information in a single chart.

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

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