Chandoo.org Podcast – Become Awesome in Data Analy 5u4z5m

Bill Jelen is one of my most favorite people on earth. That is why I wanted to have him as my first guest when I restarted the podcast. Even though I recorded this few weeks ago, only now I got around to publishing it. Please enjoy the conversation with Bill. Listen to this episode Resources for this podcast episode More about Bill: MrExcel.com (Bill’s website) Bill Jelen on YouTube Excel eSports The post 05: Interview with MrExcel – Bill Jelen (on his incredible work ethic) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

On the left side, we have a veteran warrior with 37 years of data battle scars and  redundant six pack.  They call him SQL. On the right side, there is a young challenger with transformative powers and “never say undo” attitude. He goes by the moniker Power Query. Who is going to win this battle?!? I have been using SQL for 25 years and Power Query since it came out in early 2012. And in this article, let me share my views on how SQL compares with Power Query. If you prefer to listen, check out the podcast episode – SQL vs. Power Query.  Listen: SQL vs. Power Query Podcast Episode SQL vs. Power Query - The Comparison SQL Power Query What can you do?  All CRUD operations (Create, Read, Update, Delete) Only Read the data What kind of data? Usually single source from a database or warehouse (ex: SQL Server) Can access data from anywhere and combine data from multiple sources too. How do you use it? You need to “WRITE” queries to use SQL.  You “BUILD” Power Queries using the UI buttons and menu options. Where can you use it? Works almost universally. You can use SQL with most database systems and programming languages.  Only with Microsoft stack of products, primarily with Power BI, Excel and Fabric. Who can use it? By default, you need permissions / special software to use SQL. Almost anyone can use Power Query as it comes packaged with Excel and Power BI. How fast is it? Built for performance and scalability. You can use SQL to access data quite efficiently. Can become slow and tedious as your data grows.  Resources for Learning SQL SQL Basics 50 SQL examples for Excel folks Resources for Learning Power Query What is Power Query and how to use it? Learn Power Query in 15 minutes My Power Query Essentials Course What do you think? Have you used both or either of these technologies? What do you think? Leave a comment with your thoughts. The post SQL vs. Power Query – The Ultimate Comparison appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

Power BI is one of the most prominent data analytics technology out there. Power BI is also one of the most marketed and hyped technology out there. Unfortunately, both of these statements are true. In a world where data is the buzz word, Power BI (or other similar platforms like Tableau) appeal to CXOs as panacea for all their data troubles. But, just as any technology, Power BI too has it’s own shortcomings. So in this episode of my podcast, let’s uncover 4 ugly truths of Power BI. I want to preface this discussion with a huge note of thanks & gratitude for what Power BI offers. It is a beautiful technology with a few patches of ugliness. Episode outline: ONE: Power BI is not one technology, even though it is marketed as one. TWO: Power BI changes frustratingly often. This makes it a hard technology to learn and use. THREE: Power BI can get prohibitively expensive as your organization & data needs evolve. FOUR: Power BI visuals / outputs are unimpressive. Listen to this episode Subscribe to the Show Resources for this podcast episode Learn more about Power BI: The truth about Power BI and how to learn it properly (video) Free vs. Pro vs. Power BI – which one you should choose? (video) Introduction to Power BI and full tutorial (article) When & How to use various Power BI charts (guide) Power BI Beginner to PRO – Full Course (paid class) The post 03: The Ugly Truth About Power BI (actually, 4 of them) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

So you want a 6 figure data job? In this podcast episode, I am going to share 6 strategies and tactics to land a $100k+ data job. Episode outline: My experience of working in a a 6 figure ($100k+) data job 6 strategies Build wide data skill base Cultivate deep technical skills in 1-2 areas Develop business & functional knowledge Cultivate interpersonal skills & present yourself better Strong Interviewing skills Focus on L Listen to this episode Subscribe to the Show Resources for this podcast episode In the podcast, I talked about creating a digital wardrobe. My recommended webcam, mic & lights are below: Recommended Webcams: webcam: Elgato Facecam. I have been using Elgato Facecam for the last few months and just love it. It produces crisp, HD quality images & videos with almost no effort. Get it from Amazon. Budget webcam: If you want a good quality webcam that produces decent video and good light capture, try Logitech c920. This was my primary webcam for more than 4 years and never disappointed me. Get it from Amazon. Recommended Mics: mic: If your job involves a lot of talking, I suggest getting a good mic to enhance your voice quality. I use Blue Yeti Mics for my videos and livestreams and just LOVE them. Get it from Amazon. Budget mic: I use the Plantronics Blackwire USB headset on the go and love the voice clarity it produces. Get it from Amazon. Recommended Lighting: The best lighting is natural light. So position your seat opposite to a window so that your face is getting natural light at angle. Try using sheer curtains to diffuse the strong direct sunlight. Alternatively get a ring light if you work from a dark room or away from windows. I suggest this one on Amazon. The post 02: Six Tips to get a Six Figure ($100,000+) Data Job appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

Ladies & gentlemen… I have an exciting announcement. I am relaunching my podcast!!! It only took me 7 years, but Chandoo.org podcast is now BACK! I am planning to make regular episodes on Excel, Power BI, SQL & Data Analytics. Why I am starting it again? Over the last year, I have been thinking about about restarting the podcast. I listen to a lot of podcasts (Tim Ferris show, All-in, Tropical MBA, Office Ladies, YouTube Creators Hub to name a few). They educate, entertain and inspire me. I want to along some of those benefits to you. So here we go (again). In this episode… In the 1st episode of Season 2 of Chandoo.org podcast I talk about, Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 What is in this session? In this podcast, Welcome message Top 5 (Advanced) Excel Skills Tables Power Query Dynamic Arrays & Spill Ranges Pivot Tables & Data Model Charting & Story-telling Listen to this session Subscribe to the Show Resources for this podcast Comprehensive guides on, Excel Tables Power Query – Deep introduction Power Query – Mini Course Dynamic Arrays & Spill Ranges Pivot Tables Data Model & Relationships Charting & Story-telling Examples Advanced Excel Skills Top 5 Excel Skills – Video Top 5 Data Skills – Video The post Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

In the 56th episode of Chandoo.org podcast, let me answer the chicken and egg question of Excel s. How many formulas should you care to learn? What is in this session? In this podcast, Two personal updates 3 legs of formula writing Function knowledge Operators Referencing 6 categories of must-know functions Basic math Conditions Lookups Text Date & time Work specific Closing remarks & resources for you Listen to this session Click here to the MP3 file. Resources for learning Formulas Podcast episodes on formulas All about Excel $@#%%#^^ Mastering aweSUM() formulas of Excel Writing business logic in Excel formulas VTALKUP – learn all about VLOOKUP function VLOOKUP FAQs Articles to learn important formulas Top 10 formulas for aspiring analysts Beyond IF & SUM, 15 formulas for everyone Chandoo.org podcast – Give a little thru Pateron I am happy to announce that I have a Pateron page now. If you love my podcast, head to my Pateron page to pledge a little to Chandoo.org. Thanks for your generosity and love.  

Ladies & gentlemen, its time we revived the much loved Chandoo.org podcast. In the 55th episode, I do a lousy imitation of Arnold Schwarzenegger’s famous “I will be back” and tell you why there was such a long gap between episodes, my plans for reviving our podcast and more. What is in this session? In this podcast, Why there was such a long gap between last and this episode What next? How to extract every 6th item from a list? Listen to this session Click here to the MP3 file. Resources for this podcast Introduction to OFFSET function Introduction to INDEX function Staying away volatile functions Average of every nth value Filter odd or even rows only Love my podcast? What topics you want to hear in it? Thanks for all your generous and love so far. I will be broadcasting new episodes twice a month from now. If you want to hear about a particular topic, share your suggestions in the comments area or email me at [email protected] Press the magic link and get podcasts right in to your earbuds Our podcast is a great place to learn Excel on the go. There are tons of topics and back episodes to keep you busy for next marathon or month of commute. Check out our back catalog or subscribe today. iTunes / iPhone Android Computer / Browser  

In the 54th session of Chandoo.org podcast, let’s make you awesome in Pivot Tables. What is in this session? In this podcast, Quick updates Top 10 pivot table tricks Adding same value field twice Tabular layouts GETPIVOTDATA & 2 bonus tricks Relationships & data model One slicer to rule them all Show only top x values Relative performance Show unique count Spruce up with conditional formats Not so ugly pivot charts Resources & Show notes for you   Listen to this session Click here to the MP3 file. Resources for this podcast Comprehensive guides on, Excel Pivot Tables intro – Podcast Excel Pivot Tables an introduction Excel Slicers what are they, how to use and advanced tips GETPIVOTDATA examples & usage Relationships & Data model example & able workbook Power Pivot introduction and overview Pivot Table Tips & Tricks Use report filters with VBA Structured references for Pivot Tables Group data in Pivot Tables Matching transactions using Pivot Tables Highlight quarters / weekends using styles in Pivot Reports What are your favorite Pivot Table tricks? Now its your turn. Go ahead and share your favorite pivot table tricks in the comments box.

In the 53rd session of Chandoo.org podcast, let’s talk about data validation. What is in this session? In this podcast, What is data validation How Excel DV compares with database & software DV? Types of data validation rules List & custom rules explained Input & error messages Alternatives to data validation Enhancing data validation Removing data validation rules Homework problem for you Resources & show notes Listen to this session Click here to the MP3 file. Resources for this podcast Data validation introduction & examples: Excel basics: How to add drop down box data validation rules? Either-or condition as validation rule Making data validations dynamic VLOOKUP + Data validation = magic Copy data validations using Paste Special, Remove them with Paste Special Advanced validation examples: Advanced data validation techniques (custom rules) Unsorted, duplicate column as source Mix conditional formatting with DV for awesome results Data validation in play – case studies: Invoice template using data validation To do list with data validation Additional resources: Using form controls in Excel Introduction to slicers Data validation home work – your answer Did you get the answer for homework? Please post your answers / explanations in the comments section.

In the 52nd session of Chandoo.org podcast, let’s discuss monkeys, Ok, I am kidding. We are going to talk about M is for Data Monkey book. What is in this session? In this podcast, Updates: Why so much gap between episodes? Quick introduction to Power Query Why you should get this book? What is in this book? A very cool example of the techniques you will learn Conclusions Listen to this session Click here to the MP3 file. Resources for this podcast M is for Data Monkey book More information &  tutorials on Power Query Introduction to Power Query – podcast Unpivot data with Power Query [tutorial] Import web data using Power Query More resources on Power Query PowerQuery.Training Power Query posts from Chris Webb blog Courses to help you tackle data problems Power Query Online Training from Ken & Miguel Big Data & Power Pivot training from Chandoo What is your favorite Power Query book? Have you read M is for data monkey? How do you like it? What other books on PQ do you read? Please share your opinions and suggestions in the comment box.

In the 51st session of Chandoo.org podcast, let’s discuss most frequently asked questions about VLOOKUP. What is in this session? In this podcast, What is VLOOKUP? What happens when VLOOKUP can’t find the value? Should my list be sorted? Is VLOOKUP slower than INDEX + MATCH? What if my list has multiple matches? How to fetch 2nd / 3rd matching item? How to fetch all matching items? How to fetch items matching multiple conditions? How to speed up VLOOKUP? Why doesn’t my VLOOKUP work? What to do in case of errors? Resources for you Listen to this session Click here to the MP3 file. Resources for this podcast 4 Resources to learn lookup functions: Comprehensive guide to Excel lookup functions VLOOKUP Cheatsheet The VLOOKUP Quiz – test your knowledge Recommended book: The VLOOKUP Book Other formulas and links mentioned in this podcast: INDEX formula – introduction, how to use it and why you should use it? INDEX + MATCH formula combination IFERROR Formula What is it, syntax, examples and uses Looking up 2nd or 3rd matching value Looking up based on multiple conditions Ultimate VLOOKUP trick – Multi-condition lookup Speeding up VLOOKUPs: Using relationships feature in Excel 2013 Faster VLOOKUPs with sorting Transcript of this session: A full transcript of this podcast will be ed soon. Stay tuned. Want to know more about VLOOKUP? Please ask… Still have questions about VLOOKUP? Please post them in the comments section. I will try to help you.

This is going to be epic!!! In the 50th session of Chandoo.org podcast, we have 50 Excel tips to make you awesome. What is in this session? In this podcast, Thank you message Fifty tips in 5 buckets Shortcuts & Productivity Formulas Managing Data Charts Using Excel better Listen to this session Click here to the MP3 file. Resources for this podcast Keyboard shortcuts: Top 10 keyboard shortcuts for you – podcast 012 Comprehensive list of Excel keyboard shortcuts 25 Excel tricks to boost your productivity Formulas: Top 10 formulas for analysts & managers Beyond SUM & IF – 15 formulas for you Using wild cards in formulas (* &) Formulas discussed in the podcast: SUMIFS SUBTOTAL CHOOSE AND OR – Logical formulas – podcast 028 IFERROR Managing Data: Excel Tables – an introduction Using Text to Columns to convert dates Flash fill – an introduction Remove Duplicates – a quick tutorial Go to special – what is so special about it? Introduction to Data model & Relationships in Excel 2013 Power Query – an intro – podcast 040 Charting: Data bars in Conditional formatting – a case study Sparklines can go right to left Hide ‘0’ in axis Dynamic titles & labels in charts Using Excel: How to create custom ribbons in Excel – tutorial Work with charts faster using selection pane How to make gorgeous printable workbooks – podcast 025 Hide away unused rows & columns & 9 more tips to create awesome workbooks Transcript of this session: A full transcript of this podcast will be ed soon. Stay tuned. What is your favorite tip? Now it’s your turn. Which one of the fifty is your favorite? Or do you have something new altogether? Please share in the comments. Spread the love – Review my podcast If you enjoy Chandoo.org podcast, please take a minute and write a review on iTunes. Also, do share this podcast on a colleague / friend. Make them awesome. Send them here: http://chandoo.org/podcast  

In the 49th session of Chandoo.org podcast, let’s talk about data dumps! What is in this session? In this podcast, What is a data dump Examples of data dump Why we dump Ways to avoid data dumps Go for information dumps Sort the dump Filter the dump Give a table Resources for you Listen to this session Click here to the MP3 file. Resources for making animated charts Making better charts in Excel: How to select right type of chart for your data Why 3D pie charts are evil Charting podcasts: 029 – Impress your boss with awesome charts – 6 step road map 032 – Rules for creating legendary column charts 038 – Data to Ink Ratio – What is it and how to optimize it Transcript of this session: A full transcript of this podcast will ed soon. Stay tuned. Come across any data dumps? Share your story… Now it’s your turn. Do you come across any data dumps in your line work? Share the story in the comments section. Dump some love – Review my podcast If you enjoy Chandoo.org podcast, please take a minute and write a review on iTunes. Also, do dump this podcast on a colleague / friend. Make them awesome. Send them here: http://chandoo.org/podcast  

In the 48th session of Chandoo.org podcast, let’s make some animated charts!!! What is in this session? In this podcast, Announcements Why animate your charts? Non-VBA methods to animate charts Excel 2013’s built-in animation effects Iterative formula approach VBA based animation Cartoon film analogy Understanding the VBA part Example animated chart – Sales of a new product Resources and s for you Listen to this session Click here to the MP3 file. Resources for making animated charts Example animated chart (shown in the title image): example animated chart. Play with it to learn more. More animated charts using Excel: Diwali flower pot cracker using animated charts Another Diwali animated chart in Excel Journey of Hurricane Sandy – Animated Chart 3D Dancing pendulums using Excel Charts & VBA Deg a clock using Excel VBA Basics: Podcasts: Introduction to VBA – 022 Using FOR Loops in VBA – 039 Articles: Introduction to VBA – 5 part tutorial Non-VBA animation using formulas: Animation without macros [for fun]   Transcript of this session: A full transcript of this podcast will be ed soon. Stay tuned. How do you create animated charts in Excel? Now it’s your turn. Do you make animated charts? Please share your techniques and samples in the comments section. Wow us.

In the 47th session of Chandoo.org podcast, let’s see how Excel can make you an awesome entrepreneur. What is in this session? In this podcast, Why Excel for entrepreneurs Key areas of a business owner’s work Projects & to dos Finances Customers & marketing Planning & strategy Processes & workflows 5 features of Excel that help Tables Financial formulas Pivot tables Forecasting techniques VBA & formula driven workbooks Conclusions Listen to this session Click here to the MP3 file. Excel resources for entrepreneurs If you are an entrepreneur or small business owner, check out these links and become awesome at your work. On projects & to dos: Introduction to Excel tables Introduction to structured references and awesome ways to use tables Project management using Excel – 6 part tutorial On finances: Basic financial formulas and analysis concepts in Excel – podcast Case study: Cost vs benefit analysis using Excel Financial modeling using Excel – 6 part tutorial On Marketing & customer data analysis: Introduction to pivot tables Don’t be a pivot table virgin – podcast More on Excel pivot tables On forecasting & planning: Introduction to trend analysis and forecasting using Excel – 3 part tutorial Trend analysis using Excel – podcast On processes and workflows: Top 10 formulas for analysts & managers (entrepreneurs can use them too!) Introduction to Excel VBA – podcast Scott Adam’s book – How to fail at almost everything and still win big   Transcript of this session: A full transcript of this podcast will be ed soon. Stay tuned. Are you an entrepreneur? Tell me how you use Excel… Now it’s your turn. If you are an entrepreneur or small business owner, please tell me how you use Excel. Share your story in the comments section. Subscribe to our podcast and get latest episodes automatically Use below link to add our podcast to iTunes. For other options (Android, Windows phone or RSS) click the link below. Thank you. Other options to subscribe

In the 46th session of Chandoo.org podcast, let’s talk about gantt charts and project plans. What is in this session? In this podcast, A brief intro to Excel 2016 What is a Gantt chart? How Gantt charts can help us? How to create Gantt charts in Excel Using bar charts with invisible series Using conditional formatting and formulas Using ready-made templates Resources on Gantt charts & project planning Conclusions Listen to this session Click here to the MP3 file. Resources on Gantt Charts & Project Planning Tutorials on how to create Gantt charts in Excel Gantt charts & project plans in Excel – tutorial Gantt charts using bar charts Quick Gantt charts using conditional formatting Gantt box chart – when there is uncertainty in project plans Project Management Resources & Articles Project status dashboard using Excel Project portfolio dashboard using Excel More project management tips, tutorials & resources for you Excel for PMs – online course form Chandoo.org Ready to use Excel Project Management Templates Ready to use Excel PM Template pack from Chandoo.org Transcript of this session: A full transcript of this podcast will be ed soon. Stay tuned. Are you a project manager? Tell us how you use Excel… I use Excel to manage all my projects – work related, vacation, product launches, product comparison etc. If you are a project manager, what do you use Excel for? Please share your experiences and ideas in the comments section. Subscribe to our podcast and get latest episodes automatically Use below link to add our podcast to iTunes. For other options (Android, Windows phone or RSS) click the link below. Thank you. Other options to subscribe

In the 45th session of Chandoo.org podcast, let’s get in to Monte Carlo simulations. What is in this session? In this podcast, Quick personal updates – 200km BRM and book delay History of Monte Carlo simulations Monte Carlo simulations – an example How to do simulations in Excel Formulas VBA Data Tables Using data tables to run simulations – case study – estimating Pi value Things to keep in mind when setting up your simulation models Resources on Monte Carlo simulations in Excel Conclusions Listen to this session Click here to the MP3 file. Resources on Monte Carlo simulations Articles & tutorials on data tables & Monte Carlo simulations The best explanation about data tables & Monte Carlo simulations Estimating Pi ? value by throwing frozen hot dogs on Excel charts Simulating Monopoly board game to find best strategies Example workbook – Estimating Pi value with Monte Carlo simulations This will be available on Monday – 28th September, 2015. Courses: 50 ways to analyze your data from Chandoo 50 ways to analyze data is a comprehensive online course to help you become a better analyst. In this course, you will learn how to create Monte Carlo simulations, optimization models, advanced analysis models & visualizations. Please click here to know more about 50 ways program Transcript of this session: A full transcript of this podcast will be available soon. Stay tuned. Simulate stuff? Stimulate someone, share stories… Do you simulate stuff at your work (or personal life)? If so, please share your experience with rest of Chandoo.org audience. Post your simulation process, tips & ideas in the comments section.

In the 44th session of Chandoo.org podcast, let’s talk about failures. What is in this session? In this podcast, Book announcement about Dashboards for Excel Story of my first ever dashboard Important lessons – Requirement Analysis for dashboards Resources for creating awesome dashboards Podcasts Books Courses Listen to this session Click here to the MP3 file. Resources to make awesome dashboards Podcast episodes: Create awesome dashboards with this 10 step process Make better charts by optimizing Data to Ink ratio Rules for making legendary column charts Books on Dashboards: Information dashboard design by Stephen Few Non-designers design book by Robin Williams Dashboards for Excel by Jordan & Chandoo Courses: Excel School + Dashboards – Online classes from Chandoo Excel School, is a comprehensive online course to help you become awesome in all aspects of data analysis, visualization, interactive workbooks, dashboard reporting and automation. In this course, you will learn to: Analyze data using simple & advanced formulas in Excel Structure & process large volumes of data quickly using tables & pivot tables Present information using charts, interactive & dynamic charts and complex charts Create dashboards using 8 in-depth tutorials & case studies Make gorgeous workbooks using conditional formatting, color & font choices and more Develop workbooks faster: using my favorite tricks and productivity hacks Please click here to know more about Excel School and enroll Transcript of this session: A full transcript of this podcast will be ed soon. Stay tuned. Help our community & me learn more by sharing your mistakes It’s your turn. Share the mistakes you made during data analysis, dashboard preparation or automation projects. Let’s all learn from these and become stronger.

In the 43rd session of Chandoo.org podcast, let’s talk about top time saving features of Excel. What is in this session? In this podcast, Quick announcement about Awesome August My 9 favorite time saving features of Excel Remove Duplicates Tables Pivot Tables Auto fill Format Painter Find & Replace VBA / Macro Recorder Auto save Auto complete / Intellisence Recap & Conclusions Listen to this session Click here to the MP3 file. Resources to save time Dealing with duplicates Remove duplicates button – explained Remove duplicate combinations Tables & Pivot Table concepts: Introduction to Excel Tables Introduction to Excel Pivot Tables Structural References & how to use them Auto fill & flash fill: Fill up patterns with Auto-fill Flash fill in Excel – a quick intro Format Painter and how it can save time for you: Format faster with format painter & double click Format all charts in same way using format painter Find & Replace: Use find / replace to change formats quickly Change formulas with find / replace VBA & Macro Recorder Introduction to VBA & Macros What is a macro and how to get started – podcast Transcript of this session: A full transcript of this podcast will be ed soon. Stay tuned. Which Excel feature is the most time saving one? I’ve revealed my secrets. Now it’s your turn. Tell me your favorite time saving feature of Excel. And if you have a few minutes time, Please write a review for Chandoo.org  podcast on iTunes. Please click here to do that (see the instructions if you don’t know how to write a review on iTunes).

In the 42nd session of Chandoo.org podcast, Let’s talk about money. We are going to learn about various concepts that are vital for doing financial analysis and building models. What is in this session? In this podcast, Quick announcement about Awesome August 5 key finance concepts Time value of money Compound interest Risk free rate of return Net Present Value – NPV Internal Rate of Return – IRR Case study – Uber vs. Your car Conclusions Listen to this session Click here to the MP3 file. Resources to learn about financial analysis & modeling Uber vs. Your car – Analysis model Please click here to the Uber vs. Your car analysis workbook. Finance concepts: NPV – what is it and how to calculate it in Excel? IRR – how to calculate it? CAGR – how to calculate it? Introduction to financial modeling using Excel – 6 part tutorial Case studies: Cost vs. benefit analysis – which bulbs to use? Interactive mortgage calculator How much money you need to retire? Advanced concepts: Project finance modeling in Excel – case study Data tables & Montecarlo simulations in Excel – Gold mine case study Recommended courses: Financial Modeling school from Chandoo.org – this online course teaches you all the concepts necessary to build full-length valuation & analysis models using Excel 50 Ways to analyze data from Chandoo.org – this online course makes you awesome in all aspects of data analysis, reporting & visual analysis using Excel Transcript of this session: A full transcript of this podcast will be ed soon. Stay tuned. According to you, What are key concepts for financial analysis? I shared my opinion and explained 5 concepts in the podcast. Now its your turn. Tell me what are the key concepts to master if someone needs to learn about financial analysis & modeling? Please share your thoughts and inputs in the comments section.