Tag: How to

Enterprise DNA Learning Summit – November 2019, Developing Enterprise Apps

Posted on by Annie D

EVENT DETAILS – https://ift.tt/2q8z6Ni

Session 4 – Developing Enterprise Apps

The Power BI Online Service has gone through a huge upgrade recently and finally, there is a lot more clarity around how each different feature should be used. During this workshop, we’ll cover how to create compelling apps for your teams and organisations. We’ll also go over many of the new and interesting upgrades that have been created in the web-based platform for Power BI.

• Learn how to build effective app workspaces
• Scale the Power BI online service within your teams
• Manage multiple different reports and insights effectively
• Refresh your enterprise distribution strategies for insights

View on YouTube

Administrate in bulk in Power BI Service

Posted on by Annie D

Have you ever wonder how to give access to multiple workspaces at once, or how to restore a deleted workspace? Here is a quick and easy way to do that 🙂

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

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

#CURBAL #SUBSCRIBE

View on YouTube

High Tech – VLOOKUP First Last name to LAST, FIRST – 2297

Posted on by Annie D

Sweeps URL: https://ift.tt/2NRz7gu
Evan has two lists of names. One is Firstname Lastname and the other is LAST, FIRST. He would like to do a VLOOKUP between these. My solution today involves running both lists through Power Query and then doing a Full Outer Join while merging the two lists.

View on YouTube

Administrate in bulk in Power BI Service

Posted on by Annie D

Have you ever wonder how to give access to multiple workspaces at once, or how to restore a deleted workspace? Here is a quick and easy way to do that 🙂

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

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

#CURBAL #SUBSCRIBE

View on YouTube

Enterprise DNA Learning Summit – November 2019, Ranking Insights Tips

Posted on by Annie D

EVENT DETAILS – https://ift.tt/2q8z6Ni

Session 3 – Ranking Insights Tips

Using either RANKX or TOPN in Power BI enable some fantastic insights. During this workshop we’ll be running through many variations where you can utilize these DAX functions to enable great analysis. Covered will be the key differences but also the best times to use each of these ranking formula concepts.

• Learn the versatility of ranking formulas with DAX
• Understand the possibilities with ranking functions
• Delve into the nuances of these important functions
• Create unique visualisations with ranking techniques

View on YouTube

Crucial Power Query with Two Way Lookup – 2296

Posted on by Annie D

How to do a two-way lookup during import in Excel Power Query.
Sweeps URL: https://ift.tt/2NRz7gu
Recorded at Ignite 2019 in Orlando, this video shows you how to do a two-way lookup when merging files in Power Query – even if the fields are in the “wrong” order.

View on YouTube

Suddenly It’s Here: Combine Sheets in Power Query – 2295

Posted on by Annie D

The MSFT Sweeps URL: https://ift.tt/2NRz7gu
Thanks to Matt Allington for this technique. Check out Matt’s book: https://ift.tt/2Q86SNn
Today’s video: How to combine data from multiple worksheets using Power Query. Combing multiple workbooks is easy, but combining Sheets is now possible, even though the method is mostly hidden. Thanks to Matt Allington, see how to solve this common problem.

View on YouTube

8 helpful tips for Power BI service

Posted on by Annie D

This 8 tips will help you administrate and configure Power Bi service like a Pro. If you are not an admin, make sure you check it as some of the features are useful to you if they are configured 🙂

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

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

#CURBAL #SUBSCRIBE

View on YouTube

8 helpful tips for Power BI service

Posted on by Annie D

This 8 tips will help you administrate and configure Power Bi service like a Pro. If you are not an admin, make sure you check it as some of the features are useful to you if they are configured 🙂

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

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

#CURBAL #SUBSCRIBE

View on YouTube

Enterprise DNA Learning Summit – November 2019, Virtual Table Exploration

Posted on by Annie D

EVENT DETAILS – https://ift.tt/2q8z6Ni

Session 1 – Virtual Table Exploration

During this first session, we will be exploring what virtual tables are in Power BI and how you can use these effectively to discovered advanced insights very fast. This is a very unique topic that will take you Power BI development to the next level if you can understand it well.

• Understand what virtual tables are in Power BI
• Create dynamic data groups within formulas
• Discover advanced insights fast with DAX
• Explore the limitless possibilities with virtual tables

View on YouTube

Split Text By Capital Letters in Excel using Power Query EMT 1617

Posted on by Annie D

Download Excel File: https://ift.tt/2Nw3F8M
Learn how to split text by Capital Letter. See the huge array formula in an Excel Worksheet and then the simple Power Query M Code formula to accomplish this task. Learn about the Power Query M Code Functions: Table.AddColumn, List.Count, Splitter.SplitTextByCharacterTransition, List.Max, Table.SplitColumn.
Downloadable Excel File has Excel Worksheet Array Formula that works in Office 365.

View on YouTube