From January 2015, she started to practice leetcode questions; she trains herself to stay focus, develops "muscle" memory when she practices those questions one by one.
2015年初, Julia开始参与做Leetcode, 开通自己第一个博客. 刷Leet code的题目, 她看了很多的代码, 每个人那学一点, 也开通Github, 发表自己的代码, 尝试写自己的一些体会.
She learns from her favorite sports – tennis, 10,000 serves practice builds up good memory for a great serve. Just keep going.
Hard work beats talent when talent fails to work hard.
In this step-by-step tutorial video, learn how to get started using Microsoft Power BI. Power BI allows you to get insight from your business data. This is an introductory overview of Power BI to get you started.
📚 RESOURCES
- Download Power BI here: https://powerbi.microsoft.com/en-us/d...
- Kevin Cookie Company Financial Spreadsheet: https://1drv.ms/x/s!AmxrofZZlZ-whJlAi...
- Wikipedia link: https://en.wikipedia.org/wiki/List_of...
- How to use Microsoft Power Automate: https://youtu.be/dDO4Y4aDYXw
⌚ TIMESTAMPS
00:00 Introduction
01:01 Download and install
03:00 Welcome screen
04:20 Sample data overview
06:00 Get data spreadsheet
07:40 Transform data from spreadsheet using Power Query Editor
10:10 Get data from web
11:25 Transform data from web using Power Query Editor
13:10 Join tables by merging queries
14:27 Overview of Power BI layout, including fields and visualizations
16:40 Insert title
17:20 Insert variety of visualizations
22:10 Insert slicer
23:30 Apply theme and change style
25:00 Save and Publish report
26:30 Share with others
27:05 Wrap up
In this step-by-step tutorial, learn how you can use Microsoft Power Query to get and clean up data in both Microsoft Excel and Microsoft Power BI. Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources.
Power Query (Get & Transform data in Excel) is a true game changer. It can simplify and automate various data activities. The key benefits of Power Query are,
Connect to any type of data source and fetch data
Define process for data cleansing and transformation
Combine datasets (table joins, appends)
Automate data collection & management tasks (refresh etc.)
In this Power Query Tutorial, learn what it does, how to use it with 4 practical examples, tips & tricks to work with Power Query better.
IIf you need to learn one new tool today, Power Query is it! This FREE course explains the fundamental concepts of Power Query, so you can have a basic understanding of what Power Query does and when to use it. You also receive our free eBook, 'Magic Tricks for Data Wizards'.f you need to learn one new tool today, Power Query is it! This FREE course explains the fundamental concepts of Power Query, so you can have a basic understanding of what Power Query does and when to use it. You also receive our free eBook, 'Magic Tricks for Data Wizards'.
Course Overview
Course Description
Power Query is an amazing ETL technology that allows you to “Get & Transform” your data in order to build refresh-able solutions for your business intelligence. First available as a free add-in for Excel 2010 and Excel 2013, it’s now build in to Excel 2016 and higher, as well as acting as the “Get Data” layer for Power BI.
Simply put, Power Query allows you to Extract data from a vast array of sources, Transform it more quickly and easily than you ever thought possible, and then Load it directly into a table or your data model.
If you need to learn one new tool today, Power Query is it! This FREE course is sets the fundamental concepts of Power Query, so you can have a basic understanding of what Power Query does and when to use it.
In this course, we will introduce you to the magic of Power Query and how it will transform the way you work with data forever.
Who this course is for?
Anyone that needs to import and clean data to be analyzed
Anyone who copies and pastes data into the same Excel spreadsheet on a regular basis in order to be able to continue their workflow
Anyone who has ever tried to consolidate data in Excel using VLOOKUP() or other methods
Every user of Excel or Power BI
What you'll learn?
Basic understanding of what Power Query is and what it's designed for
How the Power Query User Interface is used to Extract, Transform and Load data
Simple transformation solutions that you can apply to your work
Building solutions to import data from common Data Sources
Methods to debug errors in your Power Query solutions
That you have been wasting a huge amount of time doing repetitive manual work that can easily be automated
I like to learn how to provide training courses in the future as well. I have spent hundreds of hours to work on Excel, and I also spent time to get familiar with VBA programming.
Hello jianmin,
Registration is now open for the next semester of my Excel Fundamentals Boot Camp, which begins on August 19, 2022. This course will teach you all the core skills of an Excel Analyst!
What is the course about? The Excel Fundamentals Boot Camp is developed and delivered by me, Ken Puls, and will ensure that your Excel skills advance to an intermediate level. Our goal is to fill any knowledge gaps you may have.
This course will make you more efficient and build the core level of skills required to move onto advanced Excel analytics in the future (should you choose to do so). You’ll learn all the fundamental skills for the Excel analyst, including:
A refresher on Excel formulas, as well as absolute and relative referencing
A review of Math, Logic, Text, and Date functions
A deep dive into the powerful, but often feared, VLOOKUP (yes, there are better alternative functions today, but trust us, if you can master this function you can master any Excel function!)
An overview of how to create PivotTables, and how to summarize data sets of all sizes
An introduction to Power Query for gathering, cleaning, and transforming your data with ease (seriously, it will change your life!)
The training consists of:
Viewing the online videos (recorded by Ken Puls).
Working through the downloadable practice exercises.
Attending weekly live online Q&A calls with me for help with questions about that week's lessons.
Attending the monthly live online Ask Me Anything sessions with me for on-going support as you apply your skills to your own work and run into real world problems.
A copy of our handy Power Query Recipes collection to refer back to. (This includes all new and updated cards for as long as you are subscribed to the course.)
Although the the new semester officially kicks off on August 19, you’ll get immediate access to the all of the video content so you can dive in as soon as you're ready. Students are able to continue to join the live AMA sessions for as long as they are subscribed, even after their initial semester is finished.
Early Bird Discount The regular price of this course is $695 USD for a full year of access (and then $169 USD/year after that if you choose to continue your subscription). However, you automatically save $100 if you register before July 17, 2022!
I like to share my research on Canadian oil stocks in 2020. I tried so hard to be a long term investor, but in reality I was so afraid to lose money. Life is so good since I can go back to learn from my own experience, mistakes, naive analysis. Gambling or taking chance is part of investment game, I should embrace and be happy, and get more work done.
SOUTHLAKE, Texas, March 9, 2022 /PRNewswire/ -- Sabre Corporation ("Sabre") (Nasdaq: SABR) today announced a refinancing of a portion of its existing indebtedness. Sabre incurred no additional indebtedness as a result of the refinancing above the refinanced amount, other than amounts covering certain interest, fees and expenses. The refinancing has meaningfully improved Sabre's debt maturity profile.
The refinancing included the application of the proceeds of a new $625 million term loan "B" facility (the "New Facility"), borrowed by its wholly-owned subsidiary Sabre GLBL Inc. ("Sabre GLBL") under its existing senior secured credit agreement (the "Credit Agreement"), with the effect of extending the maturity of approximately $623 million of the existing Term Loan B credit facility incurred prior to March 9, 2022 under the Credit Agreement. The New Facility matures on June 30, 2028 and offers Sabre the ability to prepay or repay the New Facility after 12 months or to prepay or repay at a 101 premium before that date. The interest rates on the New Facility will be based on Term SOFR, replacing LIBOR, plus an applicable margin.
The New Facility is guaranteed by Sabre Holdings Corporation and each subsidiary of Sabre GLBL that guarantees the Credit Agreement. The New Facility and the guarantees thereof are secured, subject to permitted liens, by a first-priority security interest in the same collateral that secures Sabre GLBL's other senior secured indebtedness, which is substantially all present and hereafter acquired property and assets of Sabre GLBL and the guarantors (other than certain excluded assets).
BofA Securities, Inc., Citibank N.A., Goldman Sachs Bank USA, Mizuho Bank, Ltd., MUFG Bank Ltd and Wells Fargo Securities, LLC acted as joint bookrunners and BofA Securities, Inc. acted as sole lead arranger. Bank of America, N.A. is the administrative agent and the collateral agent for the Credit Agreement.
"The three major publicly traded cruise stocks are way oversold as booking trends and cruise demand remains strong. While the risk right now is the overhanging debt, the demand trends and upcoming revenue should exceed pre-pandemic trends by sometime in mid-2023. The fact that all three cruise companies cut costs significantly during the pandemic means that more revenue will flow to cash flow to pay down debt and drive a snapback in net income as well," says Ivan Feinseth. Cruise line stocks include Carnival (CCL), Norwegian Cruise Line (NCLH), and Royal Caribbean (RCL).
Warren Buffett: How Investors Can Overcome Greed and Fear
Karen Thomas, MSc, CFA
·4 min read
Warren Buffett has built his fortune on some simple principles. As he says, when it comes to investing, “you don’t need to be a rocket scientist.” So, what are some of Warren Buffett’s secrets to success?
Well, there are so many. In this article, I will focus on two very basic principles. They are the two emotional roadblocks that stand in the way of many investors. We are all human, and greed and fear are common human characteristics. As investors, we must learn to keep them in check.
It’s not as difficult as it sounds. Anyone can do it. Here’s how.
Warren Buffett: “Be fearful when others are greedy and greedy only when others are fearful”
This quote says it all. It captures the essence of successful investing. The stock market is a numbers game. But it’s also a very emotional game. Valuation depends not only on numbers but also on the psychology of investors.
So, in our quest to overcome the emotions of greed and fear, we must understand this. For example, a market that’s trading off greed is likely overvalued. It’s likely pricing in overly optimistic scenarios. If no news is bad news, that’s a problem. If the market rises regardless of the bad news, it’s a sign of disconnect. Rose-coloured glasses result in faulty decision making.
Likewise, if no news is good news, that’s also a problem. Investors sometimes view everything through a dark and pessimistic filter. This is also a sign of disconnect. But if we’re patient, we can snatch up some undervalued gems in this environment.
Investors: Watch out for greed like Warren Buffett does
Today, the market is looking through rose-coloured glasses. The pandemic has hit the economy hard. We’ll feel the negative effects more when the government aid stops. But for now, things seem great.
Lightspeed POS (TSX:LSPD)(NYSE:LSPD) stock comes to mind here. Lightspeed stock has been a clear winner; there’s no doubt. The company facilitates e-commerce. This has been a rapidly growing industry in 2020. And Lightspeed’s business in firing on all cylinders. But as Lightspeed stock climbs ever higher, we should ask, how much is too much?
Lightspeed stock is very expensive. It factors in growth many years down the line. It’s benefitting from those rose-coloured glasses I spoke about.
Stand up to fear: Warren Buffett buys Suncor stock
Energy stocks come to mind when I think about this scenario. Oil and gas stocks have been hit hard. They’ve been shunned by investors of all stripes. But in this fear, I know there are many good opportunities. Suncor Energy (TSX:SU)(NYSE:SU) stock was once an investor favourite. Today, the oil and gas industry is in a cyclical low. Yet Suncor remains the high-quality company it always was. Warren Buffett is a buyer of Suncor stock.
The main difference? Suncor stock is way cheaper today. I mean way, way cheaper. The market is very fearful with regard to energy stocks. But what if the industry isn’t dying? What if it’ll be around for many years yet? If we ignore the fear, we can make huge sums of money.
Suncor is an integrated oil company. This means that it produces and refines oil. These two businesses have different drivers and risk profiles. They diversify Suncor’s risk. That makes Suncor more stable than most oil and gas companies.
Suncor stock is already in the midst of a comeback. It’s rallied 50% since the end of October. But the stock is still trading well below pre-pandemic levels.
Warren Buffett: “If you don’t find a way to make money while you sleep, you will work until you die”
Don’t misunderstand; work is respectable. Work is necessary and fulfilling. But having options is always best. For example, having the option to do the work you want to do is priceless. Also, having the option to work how much you want to is priceless.
The way to achieve this state is through investing. Choose the right companies and the rewards will keep coming.
Sabre’s flight planning technology adopted by LATAM Airlines Group to streamline operations
Sabre Flight Plan Manager will help the group improve operational efficiency and achieve reductions in fuel use
Southlake, Texas, and Santiago, Chile – July 13, 2016 – Sabre Corporation (NASDAQ: SABR) has expanded its long-term technology agreement with LATAM Airlines Group , the leading airline group in Latin America, with the implementation of Sabre´s Flight Plan Manager and broadening the adoption of Software-as-a-Service solutions from the Sabre AirCentre operational suite.
Sabre´s AirCentre Flight Plan Manager, which provides fully-automated flight planning capabilities and significant productivity savings, will help the group unify flight operations and fuel policies across its domestic operations in seven countries – in Chile, Brazil, Peru, Argentina, Colombia, Ecuador and Paraguay – as well as its international network.
Sabre’s Flight Plan Manager brings together real-time information on a number of key variables – including weather, air space restrictions, aircraft performance and schedule information – and then calculates the most optimal flight route. Sabre’s technology aims to help LATAM Airlines Group to deliver a wide range of enhancements in flight planning and operational efficiency, including a subsequent reduction in CO2 emissions.
“Sabre is fully committed to helping LATAM Airlines Group optimize its operation across its network to deliver efficiencies and fuel savings,” said Kamal Qatato, vice president of Sabre AirCentre. “Sabre and LATAM have a strategic relationship across the Sabre Airline Solutions portfolio and with this new agreement we are confident that our leading solution will help improve its flight planning.”
Jorge Ihnen, LATAM Operations VP, said: “LATAM Airlines Group is committed to adopting the latest technology – such as Sabre’s Flight Plan Manager – to deliver improvements and efficiencies for our operation. As the leading airline group in the region, we will continue to work with partners such as Sabre to identify further advancements.”
The airline group will also benefit from Flight Plan Manager’s integration with other software from the Sabre AirCentre operational suite, including Movement Manager, which enables operations controllers to easily monitor the status of flights, and Flight Explorer, which provides data for real-time fleet monitoring.
Since 2010, LATAM Airlines Group is one of a growing number of airline groups using Sabre airline technology, and has also selected Sabre as the technology provider for its combined reservation system.
