Download files for videos #26 & 26: http://bit.ly/2QgUgll
Class web site with individual file downloads: http://bit.ly/2GF25Ni
pdf notes for Video #25-26: http://bit.ly/2QgUj0v
In this video learn about how create formulas to compare month product budgeted amounts to actual amounts. Then calculate variances.
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
In this video of this Free Online Excel training, I will show you how to use some tricks to create advanced charts in Excel.
The following advanced charts are covered in this video:
— Multi-Category Charts
— Gauge Chart
— Thermometer Chart
— Milestone Chart
— Water Fall Chart
— Gantt Chart
— Chart with Trend Arrows in Data Labels
— Actual Vs. Target Values
— Spotting Data in a Scatter Chart in Excel
— Dynamic Target Line in Excel Bar Charts
There a lot of advanced charting technique shown in this video and you can use these to create more types of advanced charts in Excel.
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:
-~-~~-~~~-~~-~-
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
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
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
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:
-~-~~-~~~-~~-~-
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
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
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
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
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:
-~-~~-~~~-~~-~-
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
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
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
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