ChandooData modeling, semantic modeling, star schema and how to make one in Power BI - all explained neatly and clearly in this video.
In this video learn about data modeling in Power BI, using a fictional chocolate company as an example. It explains the importance of setting up a star schema, which involves organizing data into fact and dimension tables. I also cover the process of importing data into Power BI, establishing relationships between tables, and creating visualizations to analyze the data.
๐ก What you will learn: ================== โ What is Data Modelling: โ Data modelling with a real-world example โ Fact vs. Dimension table โ How to set up relationships in Power BI? โ Types of relationships โ What does the "arrow" mean in the semantic model? (filter propagation) โ Importance of "correct" data modelling
โฑ Video timestamps: ================== 0:00 - Introduction to Data Modeling (or Semantic Modeling) 0:43 - Sample dataset and the tables 2:18 - Data model for Awesome Chocolates business ๐ซ (fact vs. dimension, star schema) 9:40 - Loading data into Power BI 11:50 - Creating the semantic (data) model in Power BI 15:35 - What is filter direction & filter propagation in Power BI? 18:08 - Evaluation context explained with data model 20:19 - The importance of "proper" data modeling 21:32 - In conclusion
Learn Data Modelling & Star Schema for Power BI in 20 minutesChandoo2024-10-15 | Data modeling, semantic modeling, star schema and how to make one in Power BI - all explained neatly and clearly in this video.
In this video learn about data modeling in Power BI, using a fictional chocolate company as an example. It explains the importance of setting up a star schema, which involves organizing data into fact and dimension tables. I also cover the process of importing data into Power BI, establishing relationships between tables, and creating visualizations to analyze the data.
๐ก What you will learn: ================== โ What is Data Modelling: โ Data modelling with a real-world example โ Fact vs. Dimension table โ How to set up relationships in Power BI? โ Types of relationships โ What does the "arrow" mean in the semantic model? (filter propagation) โ Importance of "correct" data modelling
โฑ Video timestamps: ================== 0:00 - Introduction to Data Modeling (or Semantic Modeling) 0:43 - Sample dataset and the tables 2:18 - Data model for Awesome Chocolates business ๐ซ (fact vs. dimension, star schema) 9:40 - Loading data into Power BI 11:50 - Creating the semantic (data) model in Power BI 15:35 - What is filter direction & filter propagation in Power BI? 18:08 - Evaluation context explained with data model 20:19 - The importance of "proper" data modeling 21:32 - In conclusion
#powerbi #datamodeling #chandoo #freedataanalystcourse #fdacLearn Power BI Service in Just 15 MinutesChandoo2025-09-09 | Just got access to Power BI reports? Watch this "perfect" getting started tutorial to get more out of the reports and dashboards shared with you.
Topics covered in this video: 0:00 - What is Power BI Service 0:55 - Accessing Power BI Service via app.powerbi.com 2:08 - Power BI Service vs. Power BI Desktop 2:31 - Opening a report in Power BI Service 2:55 - Using a Report in Power BI Service 3:40 - Resetting filters in Power BI 4:00 - Multi-selecting items in Power BI 5:00 - Using "Filter Panel" in Power BI Service 6:17 - Sorting visuals 6:52 - Focus Mode 8:15 - Copying a chart or visual to Word / Outlook / Teams 8:54 - Accessing "other pages" of your reports 9:08 - Personal Bookmarks 10:10 - Exporting Power BI Data to Excel 11:06 - Saving Power BI Report as a PDF 11:52 - Presenting Power BI Reports in Power Point (and teams) 13:00 - Using other buttons in the Power BI Service (app.powerbi.com) 13:50 - Saving Favourites (working faster) 15:00 - Collaboration with team members using Power BI Service 15:38 - Closing Remarks on Power BI Service
#powerbi3 Things I do in my new Job to Succeed as a Data AnalystChandoo2025-09-02 | Recently I started a new job as a "BI Developer". Here is my playbook to quickly impress & succeed in any new job. The BLS Rule.
B = Learn about the business L = View new job as an opportunity to LEARN new things S = Start small + bonus A = Use AI to get a head start
#newjob #careeradviceExcel Trick You Didnโt Know For Ranking Values!Chandoo2025-08-12 | Excel doesn't have DENSE RANK. But sometimes that is exactly what we need. In this video, learn how to use UNIQUE() with LARGE or SORT to create dense rank in Excel, just like how it is in SQL.
#excel #sql #rankImpressive Power Query Trick to See Past DataChandoo2025-08-05 | Use Power Query self-joins to solve tricky data challenges. In this example, I share how I am using self-joins to get the "prior weekly rental" and "prior move out date" from rental agreement data with Power Query.
A data engineer got divorced. When friends ask her what happened, she replied, "I left the join because it wasn't the right join." ๐
#powerbi #powerqueryEasy XLOOKUP Hacks You Need To Try in Excel!Chandoo2025-07-22 | We always lookup 1.
~
XLOOKUP is one of the most powerful and useful XL functions ever. In this video, learn how to take your XLOOKUP skills to next level and impress everyone with a sneaky little trick, by looking up 1.
Topics covered: โ๏ธ How to do multi-criteria lookups โ๏ธ Boolean arithmetic - the powerful of 1s & 0s โ๏ธ Advanced AND criteria โ๏ธ Advanced OR criteria with xlookup โ๏ธ How to see all matching values? FILTER(1) trick!
Learn Advanced Excel and become awesome at work. Join my Excel School program today and master vital spreadsheet skills - right from Power Query to Dashboards. Everything in one place with 50+ practice files, 30 hours of video content and 100+ lessons. Join here - chandoo.org/wp/excel-school-program
~
#xlookup #excelYour Power BI Charts Are Boring - Replace Them With This ๐Chandoo2025-07-08 | ๐คฉ Get my Power BI course and be a star at work - chandoo.org/wp/power-bi-course
Be exciting. Power BI is pretty powerful, but the default charts look ๐คฎ. In this video, learn how to make the ultimate column chart to impress the stakeholders.
#powerbi #datavisualizationXLOOKUP Excel Function - Made Easy for Beginners [In Just 6 Mins!]Chandoo2025-07-02 | Want to learn XLOOKUP? You have come to the right place.
"XLOOKUP is probably the most powerful XL function" - my grandma
How to use XLOOKUP?
=XLOOKUP( value you want to find, in the column where your data is, specify the column you want as a result)
XLOOKUP Example 1:
=XLOOKUP( "Richard", B8:B42, H8:H42)
XLOOKUP Example 2:
=XLOOKUP( "EMP1012", C8:C42, B8:B42, "Person not found")
Why use XLOOKUP?
XLOOKUP is an easy, versatile and powerful XL function that let's you search what you want in your data and get matching results. It is better version of VLOOKUP and INDEX+MATCH functions.
In this 6 minute video, learn how to use XLOOKUP in Microsoft Excel.
The video explains: โ How to use XLOOKUP? โ What happens when XLOOKUP can't find the value? โ XLOOKUP and returning the entire row โ XLOOKUP with two sheets
#xlookup #excelMake an AWESOME Employee Dashboard with Power BI (Adv. DAX)Chandoo2025-06-17 | ๐ฅMaster Power BI for data analysis with my course ๐ chandoo.org/wp/power-bi-course
~
Power BI is great for generating HR reports, employee reports and dashboards. In this video, learn how to use Power BI, Power Query, Power Pivot, DAX, SVG Measures and visual design to create an impressive employee attendance dashboard.
๐ Video Topics & Timestamps: 0:00 - Demo of our Employee Power BI Dashboard 1:29 - A closer look at the data 2:54 - Dashboard Design - Inspiration 3:43 - Designing the Dashboard in OneNote 7:48 - Loading and transforming data (with Power Query) 16:00 - Data Modelling 17:28 - Background Design (in PPT) 20:50 - Page Design in Power BI 21:40 - What visuals we need? 22:23 - Setting up a dedicated measures table in Power BI 23:02 - DAX Measures for our analysis 31:03 - Designing the Calendar View (with just matrix) 33:00 - Using SVG to create a better calendar view 41:35 - Adjusting the SVG Calendar Colors and Matrix Format 45:55 - Designing Employee Card Visual with SVG + DAX 49:00 - But images are not loading with SVG - fixing the issue with Power Query 56:00 - Formatting the dashboard 1:01:00 - Adding dynamic dashboard title to tell a story 1:03:00 - In conclusion
#powerbi #hrdashboard #daxHow I Use AI To Work Smarter Every Day as a Data AnalystChandoo2025-06-10 | ๐ฅ Download Chandoo's Prompting Cheatsheet ๐ chandoo.org/wp/15prompts
Ever wondered how an experienced Data Analyst actually uses AI? In this video, let me lift the curtains and showcase my exact process. You will be surprised for sure.
โ What I don't use AI for? โ What I use AI for? ๐งช To generate Test data and samples ๐จ Design & Mock-up stages of projects ๐งโ๐ป Writing Python Scripts ๐โโ๏ธโโก๏ธ Getting a head start on new projects โ๏ธ Documenting my work ๐ My Prompting Cheat sheet with 15 prompts - chandoo.org/wp/15prompts
๐Video Timestamps: 0:00 - How I use AI? 0:38 - How I don't use AI? 1:55 - Generating and testing sample data with AI 4:20 - AI for Design and Prototyping stages of projects 7:19 - AI for coding and automation 10:28 - Getting a headstart on new projects with AI 12:03 - AI for documenting my work 13:20 - In conclusion - What I do and don't with AI
#excel #powerbi #ai #chatgpt3 Resume Tips for Data Analysts that actually work #jobsearchChandoo2025-06-09 | 1๏ธโฃ2๏ธโฃ3๏ธโฃ Tips that actually work
1๏ธโฃ Make a few distinct versions of your CV and test them out. Improve one that has most traction 2๏ธโฃDon't load up the resume with all sorts of jargon & buzz words. Focus on a few key tech (like SQL, Power BI, Snowflake, Azure) and really go deep. 3๏ธโฃSay what you have done, not what you are asked to do. List your accomplishments instead of job responsibilities in the CV.
#resumetips #dataanalystMaster POWER BIs ALL() Functions in Just 30 Minutes!Chandoo2025-06-04 | Learn the when and how to use ALL function in Power BI. We are also going to cover the difference between ALL, ALLSELECTED, REMOVEFILTERS, ALLEXCEPT and SELECTEDVALUE functions with real-world examples of when and how to use them for data analysis.
What we are going to learn:
1) Explanation of the data model 2) How and why we use ALL funciton 3) Using ALL(table) vs. ALL(table[column]) with a real-world example 4) DAX Query View to debug and check measures 5) Understanding the "evaluation" context and why sometimes doesn't work 6) ALL vs. ALLSELECTED 7) ALL vs. ALLEXCEPT 8) ALL vs. REMOVEFILTERS 9) Understanding ALLCROSSFILTERED & ALLNOBLANKROW\ 10) Practical Example #1: Rank among all vs. Rank in a specific category (ALL with RANKX) 11) Example #2: How a "specific" month sales vary compared to "all months" sales
0:00 - Understanding all the ALL functions in DAX (Power BI) 0:45 - Why and when to use ALL function 3:01 - Using ALL() with a table vs. table column 4:50 - DAX Query View and how it helps you with understanding calculations 6:10 - The key to understanding DAX - Evaluation Context 9:49 - ALL vs. ALLSELECTED 13:27 - ALL vs. ALLEXCEPT 17:20 - ALL vs. REMOVEFILTERS 18:40 - ALLCROSSFILTERED and ALLNOBLANKROW 22:14 - Rank in all vs. Rank in Category - RANKX + ALL Example 26:01 - Specific month sales vs. all month sales - Variance Analysis
๐บ More Power BI Videos and Playlists
๐ฅ Complete Power BI Course: If you want to learn Power BI including Power Query, DAX, Data Modeling and Dashboards - Check out my comprehensive Power BI Course - chandoo.org/wp/power-bi-course Use Code SAVE100 to get upto $100 (or Rs 6,000) discount on my Power BI + Excel bundle.
#powerbi #daxUsing WRAPROWS to Reshape Data (NEW Function ๐คฏ) #excelChandoo2025-05-30 | Manually reshaping data with copy paste? No more!!!! Use WRAPROWS to do the job, like a BOSS ๐ Thank me later...
#excel #datacleaningExcel Functions & Tricks You Need for Data CleaningChandoo2025-05-27 | Clean Data in Excel with this PRO with these amazing "new" functions.
Gone are the days of manual data cleaning. Nowadays, Excel offers amazing functions to automate the data cleaning process. In this masterclass, learn the super tricks and become a data cleaning PRO.
โ Reshaping data with WRAPROWS and TAKE โ Stacking data with HSTACK and VSTACK โ Removing excess spaces with TRIM โ Replacing typing errors and synonyms with a mapping table and XLOOKUP โ Replacing missing values with IF function โ Extracting values from text using TEXTSPLIT, TEXTBEFORE and TEXTAFTER functions โ Date formatting with DATEVALUE โ Using IFERROR & SUBSTITUTE to deal with annoying date problems โ Using REGEXTRACT to get data that matches the pattern we want โ Non-REGEX formula with TEXTSPLIT โ Removing duplicate data values with UNIQUE function
๐ Video Topics & timestamps: 0:00 - Excel Data Cleaning Supertricks 2:31 - Using WRAPROWS to reshape data 4:12 - Combining both datasets using VSTACK 7:00 - Cleaning the Person column with TRIM & CHOOSECOLS 8:14 - Replacing errors & synonyms in City column with XLOOKUP 10:38 - Using LET & IF functions to clean the price data 12:15 - Extracting "date" of the event from event detail column 14:58 - Converting date to correct format with DATEVALUE 16:38 - Fixing errors with Date Conversion 20:04 - Using REGEXTRACT to extract the event time details 25:10 - non-REGEX formula for getting the event time (using TEXTSPLIT and wildcard XLOOKUP) 28:36 - Removing duplicate records with UNIQUE function
Want to learn formulas, Power Query, charting, pivot tables, Power Pivot, DAX, dashboards and advanced features - all in one place? Check out my Excel School program. You will love it.
#excel #datacleaning #functionXLOOKUP MULTI CRITERIA MAGIC #excelChandoo2025-05-22 | Multiple criteria with XLOOKUP using the * operator.The BEST Excel tricks are often the SIMPLEST - Here is the proofChandoo2025-05-20 | Simple yet Powerful. That is the name of the game.
0:24 - TRICK 1: Auto number as you type 3:09 - TRICK 2: Auto highlight when values change more than 10% 6:37 - TRICK 3: Make sure the total adds up to 100%
#excel #tricksDAX: Active vs. Inactive Relationships in Power BIChandoo2025-05-13 | Set up more than one relationship between tables in Power BI Data Model. Learn how to work with USERELATIONSHIP() function in DAX to manage active vs. inactive relationships between tables. Also learn how to visualize data from both tables in matrix and "new" card visuals with powerful story-telling tricks.
๐Complete workbook: Available in my online Power BI class
๐งโ๐ป Join my Power BI Class (get $100 / $50 discount): Visit chandoo.org/wp/power-bi-course to sign up for my complete, step-by-step Power BI course. Use coupon code SAVE100 to get $100 or Rs 6,000 discount on the course fees.
๐ Video timestamps:
0:00 - More than one relationship between tables (how they look) 0:45 - About the dataset (insurance policy data) 3:10 - The relationships between tables - active vs. inactive 4:03 - Creating DAX measures to analyze data 5:52 - USERELATIONSHIP DAX function 8:58 - Matrix visual with net policy gain trends 13:45 - You are going to LOVE ๐ this 14:48 - "NEW" Card Visuals and showing Individual Year Values 18:55 - Reference Labels & Conditional Formatting 21:10 - Dynamic Card Titles 22:30 - Formatting the cards 24:28 - Custom interactions
~
#powerbi #datavisualization #dashboardsMake awesome SVG Charts with DAX in Power BI (easier than you think ๐)Chandoo2025-05-06 | Today, let's create SVG Measures with DAX to jazz up your Power BI reports.
#powerbi #dax #svgHow to Make Cool Male vs Female Charts in Excel!Chandoo2025-04-29 | Need to compare Male vs. Female values? Use this cool interactive technique to impress everyone in the next meeting.
๐คฏ Things you will learn in this video: โ๏ธ How to set up Male & Female "stencils" in PowerPoint โ๏ธ Using XLOOKUP + Data Validation to create a dynamic chart in Excel โ๏ธ Axis formatting tricks to get the scaling right
#excel #chandoo #charting #dashboardsClustered column chart with totals in ExcelChandoo2025-04-17 | Create a clustered column chart in Excel with totals. Perfect for data analysis when you have lots of data points.
#excel #chandooHow to make a Column Chart with TOTALS in Excel (perfect for data analysis)Chandoo2025-04-15 | Create a clustered column chart in Excel with total series. This is ideal when you have many series and want to understand individual vs. total contribution of each data point.
Also learn how to add cool "emoji" based data labels to improve the story-telling.
Learn the DAX concepts for performing New vs. Returning customer analysis in Power BI.
โ Calculate Unique Customer Count โ Get "returning" customer count using SUMX and CALCULATE โ Alternative approach of using INTERSECT dax function โ Visualizing customer data โ Enhancing customer analysis with "windows"
#powerbi #chandoo #dax3 POWER BI TRICKSChandoo2025-04-07 | ...Make an AMAZING Dashboard with Power BI - End to End Tutorial +FilesChandoo2025-03-29 | ๐ฅ $50 Discount on my Power BI Course: Go to chandoo.org/wp/power-bi-course and use code SAVE50
~
In this video:
โ๏ธ How to design the Power BI report for EIC insurance company โ๏ธ Writing DAX to calculate important KPIs โ๏ธ Using "NEW" card visual and adding conditional formatting โ๏ธ Custom bar chart design โ๏ธ Emoji trick for AWESOME labels โ๏ธ Working with Ribbon charts โ๏ธ Layering "donut" charts to make an impossible chart โ๏ธ Using Scatter Plots + Symmetry Shading to find insights โ๏ธ Finding profitable segments for insurance with matrix + conditional formatting โ๏ธ Creating and linking tool-tip pages โ๏ธ Customizing interactions and filter behaviours โ๏ธ Lots of handy little tricks and tips
#Powerbi #dashboardsYou dont need work email to use Power BI - Easy Fix ๐Chandoo2025-03-18 | Power BI is amazing, until it isn't. It asks for "work email" to use the online service part. In this video, let me share an incredibly easy fix to this annoying limitation.
Step 1: Sign up for a free trial of another Microsoft product like Dynamics 365 (microsoft.com/en-us/dynamics-365/free-trial) Step 2: Set up your own free sub-domain on the onmicrosoft.com Step 3: Use that to access Power BI service and publish / share your work with others. Step 4: Join my Power BI course and master the technology - chandoo.org/wp/power-bi-course (use code SAVE50 to get $50 discount)
#powerbiPower Query MAGIC! โกAuto-Categorize Text Like a PRO!Chandoo2025-03-11 | A Power Query PRO trick to help us clean and "automatically tag" data based on a rules table. This time-saving automation has been helping me a lot with "rules-based text classification" and I am excited to share it with you.
What you are going to learn ๐ก ========================
1) The challenge of "tagging" or "categorization" based on rules table. 2) Using Text.Contains and the limitation 3) Introducing "loops" โพ๏ธ in Power Query with List.Accumulate() 4) Using List.Accumulate with a custom function 5) How to convert our rules logic into an invokable M function for future uses 6) Enhancement ideas
Video Timestamps ๐ =================== 0:00 - The ultimate Power Query time-saver trick 1:20 - Loading the data into Power Query 2:20 - Solving for one line item - understanding the logic 4:01 - Using Text.Contains and the limitation 4:55 - List.Accumulate - What is it and how to use it 11:30 - Converting the logic to a Power Query function 19:25 - Ways to enhance the functionality
๐ฐ$50 Discount on My Power Query, Power Pivot & Power BI course ๐ค ==========================================================
If you like this magic show, you are going to LOVE my online, self-paced Power BI course. It helps you unlock the hidden powers & secrets of Power Query, M language, Power Pivot, DAX & Power BI report building. Visit chandoo.org/wp/power-bi-course
Use Coupon code SAVE50 to get $50 (or Rs 3,000) discount.
~
#powerquery #chandooThe Secret VLOOKUP Trick that Lookups Multiple Sheets ๐Chandoo2025-03-05 | Do you want to VLOOKUP but in across sheets? Then you need this mind-blowing ๐คฏ trick.
In this video: 1) How to lookup across multiple sheets 2) Introducing VSTACK to combine all the data 3) Using LET and variables 4) Getting Qty, Date & other details with one spillable formula 5) What if multiple matching values are there - using FILTER
๐ Video timestamps:
0:00 - VLOOKUP across multiple sheets - the problem 1:26 - VSTACK + XLOOKUP solution 3:45 - Two issues with this approach 4:24 - How to get other columns data too 5:58 - Getting "all" matching results from across sheets
๐งฎ Functions used and explained in this video: ======================================
XLOOKUP VSTACK LET CHOOSECOLS TRANSPOSE FILTER
๐งโ๐ Want to learn Excel for real? ==========================
Do you want to learn how to use Excel for doing "actual" work? Check out my Excel School program and unlock your potential. I focus on practical examples like this and share real-world skills for your success.
#excel #vlookupExcel Secrets They Donโt Teach You (Managers Must Watch!)Chandoo2025-03-02 | Do you work as a manager and use Excel? Then this live stream is for you. In this informative, useful and incredibly time-saving session, learn the most impactful Excel concepts & tricks that matter to you.
Wellington (NZ ) Sunday, 2 March 2025 at 2:00 p.m. New Delhi (India) Sunday, 2 March 2025 at 6:30 a.m. New York (USA - EST) Saturday, 1 March 2025 at 8:00 p.m. Chicago(USA - CST) Saturday, 1 March 2025 at 7:00 p.m. Seattle (USA โ PST) Saturday, 1 March 2025 at 5:00 p.m. London (UK - GMT) Sunday, 2 March 2025 at 1:00 a.m. Singapore Sunday, 2 March 2025 at 9:00 a.m. Dubai (UAE) Sunday, 2 March 2025 at 5:00 a.m. Sydney (Australia โ AEDT) Sunday, 2 March 2025 at 12:00 Noon
Share it with your manager...
#excelformanagers #excelThe little known BYROW function changes how you write formulas in Excel ๐คซChandoo2025-02-18 | Excel has many new function, but this one is by far my favourite. In this video, learn why BYROW() should be your new best friend.
Video topics: 1) What is BYROW() formula in Excel and how to use it? 2) BYROW() with LAMBDA() 3) Using BYROW() to lookup in any column (advanced trick)Cumulative Averages in Excel - Easy FormulaChandoo2025-02-11 | Cumulative or Running Averages are hard to calculate in Excel. In this video, let me explain the challenge and show 3 easy ways to calculate them.
How would you do this? Leave a comment and let me know...
#chandoo #exceltipsPower BI is NOT Enough! Hereโs What You Must Learn in 2025 ๐Chandoo2025-02-04 | Want to grow your data career and skills in 2025? Then you need to think beyond Power BI. In this video, let me share my approach for growing your data skills using "value chain analysis".
The key skills you want to gain are: ๐ Data engineering & SQL ๐ Coding (for data - like Python) ๐ User interaction skills ๐ Business domain skills ๐ Other BI / Analysis tools - Tableau, Excel, Python ๐ Forecasting, data insights ๐ AI, Machine learning, GPTs
#powerbiComplete Excel Tutorial for Data Analysis in 4 Hours (with FREE Files)Chandoo2024-12-26 | Power Query โ Tables โ Formulas โ Pivots โ Charts โ Dashboard All in one video. Learn everything, practice the concepts and improve your skills in just 4 hours. This is my holiday gift for you ๐
Power Query Web scraping Data cleaning & automation Adding columns How to use Excel Conditional formatting Quick analysis of data Autosum Excel Tables Excel functions & formulas COUNTIFS, SUMIFS, AVERAGEIFS XLOOKUP FILTER INDEX CHOOSECOLS IFERROR SMALL, LARGE SORT, UNIQUE Statistical analysis of data Excel pivots Slicers, timelines Interactive pivots Interactive charts Pivot charts Pivots + conditional formatting Excel charts Excel data model (power pivot) DAX in Excel Creating a dashboard in Excel Chart customization Using pictures in Excel Dynamic dashboards + hundreds of tips, tricks, shortcuts and ideas ๐ก
๐ Learning Progression:
0 - 15 mins: How to use Excel 15 - 48 mins: Power Query and Data Management 49 - 1 hour 50 mins: Excel formulas & functions 1h 50 - 2h 40 mins: Excel Pivot Tables, Slicers & Charts 2h 40 - 4h: Excel portfolio project
๐ Detailed Timestamps:
00:00 - How to use Excel 14:36 - Power Query and Data Management 49:27 - Excel formulas & functions 1:53:39 - Excel Pivot Tables, Slicers & Charts 2:42:47 - Excel portfolio project
#Chandoo #excelLearn For Loop in Python Properly (with sample code ๐ฉโ๐ป)Chandoo2024-12-17 | Loops & Lists are two most important aspects of Python. In this video, learn how to work with them with clear and practical examples.
What we are going to learn: 1) Programming concepts like data types, objects and control flow 2) How to use for loop to loop through list of items 3) A cool trick to write faster and better loops 4) Using list comprehension - alternative to loops
0:00 - Introduction to looping and list comprehension 0:15 - 3 Main concepts in programming 0:38 - Data types 2:10 - Objects & Classes 3:15 - Control flow 5:18 - Using for loop in Python 8:19 - Printing index number & sport with loops 13:38 - A faster & better way to write loops with enumerate() 16:13 - List comprehension in Python 21:16 - What's next?Stop Dragging in Excel, there is a BETTER way!Chandoo2024-12-03 | Stop dragging in Excel. Use this better and improved way to get what you want.
Introducing the SEQUENCE() in Excel. It puts FUN in Functions. We can use it to get numbers, texts, dates and even improve your formulas.
5 AWESOME examples to get started:
โฌ SEQUENCE(1000) - makes 1000 numbers row-wise โก SEQUENCE(,1000) - makes 1000 numbers column-wise ๐ SEQUENCE(10, 10) - makes 10x10 grid of numbers, 1 to 100 ๐ ="INV" & SEQUENCE(1000) - makes 1000 invoice numbers, starting with INV1, INV2... INV1000 ๐ SEQUENCE(365,, "1-JAN-2025") - makes all the 365 days of 2025
Video topics:
0:00 - Why dragging is bad for you 0:27 - How to make 1000 numbers quickly! 1:16 - Adding prefixes like INV for invoice numbers 2:15 - Using SEQUENCE to make all the dates of 2025 2:55 - Six packs on the fingers ๐ 3:12 - My absolute favourite trick with spill ranges 4:14 - How to add up all the spilled values
We don't drag any more... We don't drag any more Like we used to do.
#chandoo #chan2 #exceltipsPython for Data Analysis: The Beginnerโs Ultimate Guide ๐Chandoo2024-11-26 | Python is essential if you want to work with Data. In this video, learn how to set up and use Python on your computer with your first examples.
Key skills you will gain are: โ How to install Visual Studio Code & Python โ How to set up virtual environment for Python in VS Code โ How to set up and use Jupyter Notebooks with VS Code โ Writing and running your first python code โ Using "notebook" style programming to learn Python โ Working with Python Lists & slicing โ Control flow with IF conditions in Python โ Building a simple grade calculator with Python โ Next steps for Python leaning (lists, comprehension, numpy, matplotlib)
0:00 - What to expect in this video? 0:23 - Installing Visual Studio (VS) Code 2:59 - Installing Python 4:36 - What is VS Code and how to use it? 6:48 - Our first python code 8:10 - Setting up "Virtual Environment" in VS Code 13:06 - Adding Jupyter Notebook Support in VS Code 16:00 - Creating our first Jupyter Notebook in Python 23:35 - Working with variables in Python 26:00 - Using f strings in Python 27:13 - Using Jupyter tab in VS Code to "inspect" the variables 30:15 - Dealing with errors in Python Notebooks 32:14 - Working with Python "Lists" 40:10 - IF condition in Python + a mini project 49:34 - What's next?
~
#python #coding #dataanalytics #fdac #chandooPower BI Visuals Masterclass โ Make Charts That Actually Tell a StoryChandoo2024-11-19 | Learn how to use every major Power BI visual the right way โ with real-world examples, storytelling tips, and chart selection tricks. Whether you're building dashboards or reports, this guide will help you master the Power BI visual gallery from bar charts to matrix tables. We are specifically going to cover,
Column chart ๐ Line chart ๐ Donut charts ๐ฉ KPI Cards ๐ณ Small Multiples ๐ก Matrix ๐ฐ
๐ Video Timestamps: =================== 0:00 - Introduction and what you are going to learn 1:03 - How to set canvas background in Power BI? 2:26 - Column charts in Power BI 5:46 - Line charts for trend analysis in Power BI 10:24 - Donut charts in Power BI 12:04 - KPI Card visual in Power BI (new card) 17:05 - Small Multiples in Power BI 21:33 - Matrix visual in Power BI 24:29 - How to learn more?
๐ผ Resources to learn Power BI: ===========================
#powerbi #dashboardHow to make PERFECT Data Analyst Resume for Beginners [2025]Chandoo2024-11-12 | ๐ Unlock AI for $10 per month โ https://ntn.so/Chandoo2
~
Make the perfect entry level data resume with three easy steps.
Step 1: Set up your resume for success with a clear and well-defined template. Then customize it for the job you are applying for.
Step 2: Build Impact with Limited Experience by highlighting "transferable" skills, using ATR style bullet points and creating a strong summary to reflect your passion.
Step 3: Stand out with personal branding and social media presence by setting up LinkedIn & GitHub profiles, double checking everything on the resume.
Step 4 (optional): Use my free Resume template & resume checker (AI) tool to see if your resume is a good fit for the job.
Notion template link ๐ https://rain-speedwell-127.notion.site/Job-Resume-Match-1228f52290ec801aae70e44f0cbf73c6?pvs=4
โฑ Video topics: ============= 0:00 - 3 steps to make a stunning entry level resume 0:18 - Step 1 (setting up for success) 3:17 - Step 2 (build impact with limited or no experience) 4:09 - Jo on how she hires 5:40 - How to write ATR Bullet Points 7:38 - Jonathan on how he hires 9:34 - Step 3 (standing out from the crowd) 13:04 - My Notion Template and how to use it
~
๐ All the best with your job search.
#resume #dataanalyst #jobsearchHotel Bookings Dashboard with Power BI - COMPLETE MASTERCLASS (with sample file ๐)Chandoo2024-11-09 | Join me for a real-time Power BI session and learn how to build a hotel reservation dashboard using Power Query, Power Pivot (DAX) and Power BI.
๐ฅ Introduction to Live Streaming and Power BI: The session begins with a live streaming setup, greeting participants, and introducing the Power BI session.
๐ Setting Up the Power BI Report: A hotel reservation dashboard is created, illustrating step-by-step setup of metrics, slicers, and background for the report.
๐ก Exploring Data Preparation Techniques: Learn about data cleaning and preparation, including the calculation of relevant columns such as booking and stay dates.
๐ Visualization Techniques: Key visuals such as trend lines, slicers, heatmaps, and tables are used to display booking trends, customer segments, and insights.
๐ง Adding Aesthetic Features: Background customization, theme setting, and color scheme creation in Power BI are demonstrated to enhance report visuals.
๐ Advanced Data Analysis: Insights on weekday vs. weekend bookings, loyalty levels, booking channels, and customer behaviour are included.
๐ DAX Calculation Guidance: Overview of using DAX functions like SUM, COUNT, AVERAGE for calculating metrics and deriving insights.
๐ Topic Timestamps: =================== 0:00 - Welcome to the livestream 8:03 - Starting with the blank (sample) file to build hotel reservation report 10:52 - A look at the Power Query to get the data 13:15 - A closer look at the model & measures 15:50 - KPI card construction explained 16:20 - How to build the reports (mock-up process) & what we are going to build 18:45 - Adding canvas background 20:45 - Stay trend over time 31:35 - Weekday wise stay trend 38:55 - Who stays with us? (by loyalty program) 47:32 - How far ahead the bookings are made? 53:05 - How I am using Power BI report themes? 55:47 - Customer Analysis (matrix visual) 1:01:10 - Adding conditional formatting to the matrix 1:03:02 - A look at the final report and extra story-telling bits 1:06:27 - How to learn Power BI properly? 1:27:00 - Q&A
๐ฅ My Power BI Course:
Save $100 on my Power BI course (pay $199 instead of $299, or Rs 13,500 instead of Rs 18,000). Offer valid until 30th of November only.
#powerbi #chandoo #powerbidashboardLearn 80% of DAX in an Hour (with FREE sample file)Chandoo2024-10-22 | Want to learn DAX but don't have the time? This is the video for you. In this one-hour masterclass, learn the 80% essential DAX with practical examples. Understand and master concepts like:
โ How to create measures ๐ค โ Measure vs. Column โ โ Measure reusability โป โ Evaluation Context ๐ป โ Basic DAX functions - SUM, COUNTROWS, AVERAGE, DIVIDE ๐งฎ โ Conditional DAX functions - IF ๐ฟ โ Understanding and using CALCULATE function ๐ โ Multiple filters with CALCULATE ๐ฅ โ How to get good with DAX using ACMBU technique ๐ก
๐ Download practice workbooks: =============================
โฑ Video Chapters: ================ 0:00 - Introduction to DAX & our data model 3:00 - Our first DAX measures 11:24 - Why we need DAX when you can get the same thing with "auto" calculations 13:18 - DAX Pledge (say it out with me ๐ฃ) 13:39 - Measure vs. Columns 15:08 - More DAX formulas 16:08 - Difference between Excel and DAX functions! 19:24 - Understanding Evaluation Context 25:12 - Reusing DAX measures 28:32 - Why not use table name in the measures? 30:56 - DIVIDE function 34:18 - CALCULATE function 42:21 - More than one filter with CALCULATE() 46:35 - IN operator 49:22 - Conditional logic with IF() 52:51 - Measures are SCALAR (Aggregates) 55:29 - Awesome DAX trick ๐ก 58:20 - ACMBU Technique for Better DAX ๐
๐ฉโ๐ป๐จโ๐ป Join my Power BI Course ==========================
Want to master all aspects of Power BI - right from Power Query to Data Modeling to Power Pivot to DAX to Visual design to Report building? Then you are going to LOVE my Power BI Course. Trusted by more than 1000 people all over the world and consistently rated 5* by everyone.
CALCULATE(), FILTER() and ALL() wanted to have dinner together. But it never happened. Why?
Because FILTER() kept excluding people ALL kept ignoring everything and CALCULATE as usual was late ๐
#Powerbi #dax #chandoo #freedataanalystcourse #fdacPower BI is EASY: Get started and make your first report in 30 mins ๐Chandoo2024-10-08 | Microsoft Power BI is the hottest and most widely sought after skill for data analysts everywhere.
In this video we will be covering,
โถ Introduction to Power BI: how to get started with Power BI, including downloading and installing Power BI Desktop, loading data, and creating visuals and tables.
โถ Creating a Business Report: step-by-step process of creating a complete business report using Power BI, from loading sample data to formatting visuals and sharing the report with others.
โถ Power BI Interface: the main areas of the Power BI interface, including the ribbon, canvas, panels, and switching panel, and how to use these areas to construct and navigate reports.
โถ Building Visuals: how to create various types of visuals, such as column charts, bar charts, and slicers, and how to format and customize these visuals to display data effectively.
โถ Publishing and Sharing Reports: the process of saving, publishing, and sharing Power BI reports, including the benefits of using the Power BI online platform for collaboration and data updates.
โฑ Video Chapters: ================ 0:00 - Introduction to Power BI 0:59 - How to download Power BI? 1:54 - Loading data into Power BI 3:19 - Understanding the Power BI Screen 7:20 - Let's make our first Power BI chart 10:00 - how to format the charts? 11:54 - Making a second graph (using Power BI's auto build option) 12:42 - Most "fun" and "useful" aspect of Power BI 14:16 - Changing calculation type in the visual 15:08 - Using the "Card" visual in Power BI 16:30 - How to apply a slicer? 17:34 - Calendar slicer 18:25 - Let's make a business report 20:22 - Creating the trend chart 23:40 - Sales amount by country (donut chart) 24:20 - Sales person performance as a table 27:36 - Product sales report (bar chart) 30:50 - Adding KPI cards for key metrics 32:15 - Slicers for the report 33:05 - Saving and publishing the Power BI report 36:49 - Coming up...
Power BI is like an iceberg. There is a little we can see, but most of its complexity and technology is hidden underneath. So, in this video, let me demystify Power BI by explaining 50 of the most common and confusing jargon you hear. You will learn how the architecture of Power BI technology looks by the end of this video. This is the part 2 of the video. Watch part 1 here - youtu.be/mO-fvZPg7-Q
I have explained all the main areas of Power BI in the video: Power BI Power BI service Power Query Power Pivot Cloud Data infrastructure Fabric Automation and AI
This is the Part 2 of the 2-part video series. In this video, the following terms are explained:
Power BI Service RLS (Row Level Security) Publishing a Report Dataset Sharing a report Workspace Scheduled Refresh Users Power BI Pro & Premium Gateway Power Platform Power Automate Power Apps Low-code CoPilot AI visuals DAX Query View Cloud Platforms Data Engineering ETL Data Flows Pipeline Real-time data Streaming data Notebook
โ Video Chapters: ================ 0:00 - Power BI jargon explanation (and free PDF for you) 0:55 - Power BI Service (platform, RLS, publish) 7:44 - General Data Terminology (data engineering, pipelines, etl etc.) 11:04 - Power Tools, Cloud and AI terminology (Power Automate, CoPilot, Azure etc.) 16:57 - In conclusion - Power BI terminolgy
#powerbi #jargon #chandooPower BI Ecosystem - Explained in 25 minutesChandoo2024-09-24 | ๐ Unlock AI for $10 per month: https://ntn.so/Chandoo
~
Power BI is like an iceberg. There is a little we can see, but most of its complexity and technology is hidden underneath. So, in this video, let me demystify Power BI by explaining 50 of the most common and confusing jargon you hear. You will learn how the architecture of Power BI technology looks by the end of this video.
I have explained all the main areas of Power BI in the video: Power BI Power BI service Power Query Power Pivot Cloud Data infrastructure Fabric Automation and AI
This is the Part 1 of the 2-part video series. In this video, the following terms are explained:
Connections Query Table OneLake Warehouse Database Datamart Dataverse SQL Transformation Refresh Query Folding M Language Close & Load Query Parameter Power Pivot Modeling Data vs. Semantic Modeling DAX Measure KPI, Metric & Calculation Relationship One to many relationship Filter Direction Star Schema Snowflake Schema Evaluation Context Power BI Canvas Visual Report Dashboard vs. Report Filters Slicer Drillthrough Interaction Paginated Report Conditional Formatting
โ Video Chapters: ================ 0:00 - Power BI is like an iceberg 1:02 - Power BI as a mind-map 2:57 - The data layer of Power BI (power query, connections, M etc.) 11:30 - How I learn and remember technical concepts 13:40 - Calculation layer of Power BI (semantic modelling, relationships, DAX, Power Pivot etc.) 20:14 - Reporting layer of Power BI (visuals, slicers, filters, interactions, drillthrough etc.) 25:34 - The second part of the video
#powerbi #jargon #chandooBecome an Excel PRO with this complete Dashboard Project ๐Chandoo2024-09-17 | ๐ฉโ๐ป Checkout my advanced Excel course at chandoo.org/wp/excel-school-program
In our final lesson of Excel module, we will be building a call centre performance dashboard as show-cased above. In this portfolio project, you will learn:
โถ Designing the dashboard color theme and fonts โถ How to use Data model feature of Excel to connect datasets โถ Creating KPIs and measures using Power Pivot and DAX โถ Using Pivot tables to create all the dashboard calculations โถ Making interactive Pivot Charts with slicers โถ Applying conditional formatting to charts & tables โถ Using XLOOKUP and images in Excel to show dynamic pictures
โฑ Video timestamps: ==================
0:00 - Demo of what we are going to build - call centre dashboard 1:35 - A closer look at the dataset and dashboard assets 2:57 - Set up dashboard color scheme and fonts 4:31 - Creating pivot tables 5:31 - Setting up the data model and relationships 7:29 - Calculating the DAX measures for various KPIs 12:47 - Making dashboard tiles 20:48 - Calls trend line graph 27:22 - Weekday trend bar graph 31:18 - Calls and amounts by rep (dynamic chart) 44:58 - Formatting slicers with styles 47:36 - Calls by customer demographics 50:19 - Rating distribution histogram 52:33 - Customer Revenue Analysis (table) 57:10 - Conditional formatting databars 58:51 - Highlighting selected "rep" in the table 1:01:34 - Adding the "picture" of selected rep 1:10:11 - Making dashboard title etc. 1:11:30 - How to learn more and become really good in Excel
#Excel #Chandoo #fdac #freedataanalystcourseExcel Pivot Tables - Master Data Analysis in just 45 minutesChandoo2024-09-10 | ๐ Check out my complete Excel course - chandoo.org/wp/excel-school-program
While Excel formulas are powerful, you also need to plan and think hard before writing them to solve business problems. This is why I love Pivot tables. They are really easy to make and provide the biggest bang for buck. We can use Pivots to analyze data and answer business questions effectively and elegantly in short amount of time.
In this lesson, learn how to: โ Create a pivot table from your data โ Using the fields panel to construct your "dream" pivot โ Work with report filters, top 10 filters and sort options โ Change calculation in the pivot โ Set up slicers to "interact" with pivot tables โ Create "groups" in pivots โ Make pivot charts to analyze trends โ Calculate Cumulative "running" totals in Pivots โ Use conditional formatting with Pivots โ Percentage analysis with Pivots โ Set up advanced pivot tables to solve business problems
โฑ Video Topics & Timestamps: ==========================
0:00 - Introduction to the data and 10 problems 0:51 - Total calls by customer pivot 5:16 - Customer Satisfaction pivot 7:34 - Top 10 customers with value filters 11:19 - Using Report Filters to see top 10 customers for a specific representative 12:45 - Slicers are better than Report Filters 15:01 - Call duration analysis (grouping in Pivots) 20:32 - Trend analysis with Pivots (using dates) 24:40 - Year to Date Totals (cumulative or running totals in Pivots) 27:50 - YTD totals with financial year start in July 31:43 - Which days are busiest (conditional formatting with Pivots) 36:12 - Link between call duration and satisfaction (2-way pivots) 44:49 - Should we hire extra stuff in any months? 47:25 - Home work problems to practice Pivot Tables 48:30 - Coming up next in the free data analysis course
#freedataanalystcourse #fdac #chandoo #excel #pivotDont tell my boss, but AI is doing all my Excel work now ๐คซChandoo2024-09-03 | I have been using CoPilot to work faster with Excel. Don't tell my boss though, he thinks I am doing all the hard work ๐
In this video: ==========
0:00 - What is CoPilot for Excel and how to enable it? 1:30 - How to use CoPilot to clean your data? 3:13 - Using CoPilot to write formulas 4:48 - CoPilot and natural language queries 6:58 - Complex analysis scenario with CoPilot 8:52 - Making Pivots with CoPilot 10:12 - Tips & Tricks of using CoPilot 11:16 - Asking CoPilot to find insights on its own 13:04 - Alternatives to CoPilot in Excel
I asked CoPilot "How to fly better?" It just made a drawing of a butterfly ๐ฆ We are not talking any more ๐ค๐ฅ๐ค
#copilot #excelBest Excel Formulas in an hour - Beginner to PRO MasterclassChandoo2024-08-27 | ๐ Unlock AI for $10 per month: https://ntn.so/Chandoo
~
Here is something that most people get wrong when learning Excel. They learn the functions, but not "when" and "how" to use them. So in this masterclass, let me tell you "when" and "how" to use Excel functions with 10 business problems.
What you will learn in this video: โ Working with Excel formulas & functions โ COUNTIFS, SUMIFS, AVERAGEIFS โ FILTER Functions, multiple criteria โ CHOOSECOLS function โ MIN, MAX โ SMALL, LARGE โ SORT + TAKE functions โ UNIQUE โ # OPERATOR โ COUNTA vs. COUNT functions โ VLOOKUP โ XLOOKUP โ INDEX@Mat+ MATCH โ IFERROR โ How to nest formulas to get the result you want โ Complex business problems and formula solutions for them โค And plenty of homework problems
0:00 - The problem with learning Excel functions 1:51 - Total salary and headcounts by department (COUNTIFS, SUMIFS, AVERAGEIFS) 8:28 - All employees with more than $100k salary (FILTER) 12:21 - Seeing only a few columns with FILTER using CHOOSECOLS 16:17 - How to learn & remember all this info 20:36 - All female employees with more than $100k salary (FILTER multiple conditions) 24:16 - Lowest, highest, top 5 salary values (MIN, MAX, MINIFS, MAXIFS, SMALL, LARGE, SORT+TAKE) 33:44 - Listing all departments with UNIQUE and using # operator 37:03 - Lookup functions (VLOOKUP, XLOOKUP, INDEX+MATCH, IFERROR) 53:22 - Highest paid person (XLOOKUP + MAX) 57:22 - All the employees that joined in March (FILTER + DATE FUNCTIONS) 1:01:41 - Making a report with formulas (COUNTIFS, SUMIFS, UNIQUE, #, Conditional Formatting) 1:09:09 - What's next?
#excel #dataanalyst #chandoo #freedataanalystcourse #fdacLearn ALL the useful Excel concepts in 40 mins - Tables, Formulas, Pivots & Charts (with file ๐)Chandoo2024-08-20 | Excel has 100s of features, so learning what is important can be tricky. In this video, let me distil the essential concepts and present them in a digestible format in just under 40 minutes.
This is "Essential" Excel in 40 minutes.
What you will learn: 1) How to use data in Excel 2) The importance of Excel tables 3) Working with Filters & Slicers in Excel to do quick analysis 4) Using "Total Row" / SUBTOTAL function 5) Understanding Excel cell references - Relative / Absolute / Structural / Spill 6) Important and useful Excel functions - IF, IFS, SUBTOTAL 7) Creating and using Pivot Tables 8) Making Excel Charts - Box plots to explore salary distribution 9) Interactive charts with slicers 10) Next steps to improve your understanding of Excel
0:00 - What are the Essential Excel topics? 0:41 - About the dataset and the 5 business problems 2:22 - The importance and how to use Excel Tables 8:45 - Using Total Row & SUBTOTAL functions 12:35 - Cell References in Excel - Relative, Absolute, Spill 20:52 - Spill Ranges and Dynamic Array Formulas 22:44 - Using IF / IFS functions in Excel (bonus calculation example) 31:35 - Excel Pivot Tables (and making a department-wise report) 38:35 - Using Excel Charts (Box plots for salary distribution)
#excel #dataanalyst #chandoo #freedataanalystcourse #fdacPower Query - Beginner to PRO Masterclass in 30 minutesChandoo2024-08-13 | Learn Power Query in 30 minutes. Sample file: chandoo.org/dac
~
In this video, you will learn:
Why Power Query is the best feature in Excel and Power BI Webscraping with Power Query Understanding the PQ Editor Screen Data cleaning with Power Query editor Fill down operation (dealing with nulls) Adding columns Filtering the data Find / replace values Trimming data Column Quality Indicators Adding column based on rules (conditional column) Fixing date format issues Splitting First and Last name Writing M code to create columns Calculating tenure from start date Updating and refreshing the data
0:00 - Why Power Query is important? 1:46 - Web scraping with Power Query 4:54 - Understanding the Power Query Editor (PQE) 7:33 - Data cleaning the web scraped data 13:36 - Loading the data to Excel 15:43 - Business Data with Power Query 17:50 - Data cleaning staff data 24:55 - Cleaning "dates" with Power Query 26:15 - Splitting first and last name 28:25 - Bucketing salary values 30:25 - Calculating the "tenure" of the employee 31:54 - Writing M code yourself - simple example 33:35 - Closing and loading the data (and refresh process)
๐บ More videos - FREE Data Analyst Course: =====================================
#powerquery #chandoo #freedataanalystcourse #fdacAdvanced SQL for Data Analysis - 10 Powerful Examples in 40 minutes ๐Chandoo2024-08-06 | Learn ADVANCED SQL with 10 PRACTICAL QUERIES in this video. ๐ฅ Course page ๐ chandoo.org/dac
You will be learning:
How to use WHERE clause in SQL Work with AND / OR / LIKE / IN operators in SQL Getting DISTINCT values with SQL Grouping data with GROUP BY Using SQL JOINS Creating Common Table Expressions (CTE) Business Analysis and Decision Making with SQL
For the purpose of this video, we will be using the Sakila sample database of MySQL. I explain the process of installing MySQL and the sample databases in the previous video of this series here - youtu.be/Iceaqdy7mEs
The queries we will be developing are:
# 1) All films with PG-13 films with rental rate of 2.99 or lower
# 2) All films that have deleted scenes
# 3) All active customers
# 4) Names of customers who rented a movie on 26th July 2005
# 5) Distinct names of customers who rented a movie on 26th July 2005
# 6) How many rentals we do on each day?
# 7) All Sci-fi films in our catalogue
# 8) Customers and how many movies they rented from us so far?
# 9) Which movies should we discontinue from our catalogue (less than 2 lifetime rentals)
# 10) Which movies are not returned yet?
# H1) How many distinct last names we have in the data? # H2) How much money and rentals we make for Store 1 by day? # What are the three top earning days so far?
~
โฑ VIDEO TOPICS: =============== 0:00 - Introduction to Advanced SQL 0:48 - How to understand the structure of any dataset? (ERD) 4:30 - Primary vs. Foreign Key 7:30 - Let's write SQL queries 7:50 - Query 1 11:32 - Query 2 13:37 - Query 3 14:28 - Homework 14:43 - Query 4 19:32 - Bonus Query 20:34 - Query 5 21:43 - Homework 22:04 - Query 6 24:42 - Query 7 29:15 - Query 8 32:10 - Query 9 35:36 - How to use CTEs (Common Table Expressions) 38:37 - Query 10 42:06 - Homework 42:45 - Limitations of SQL
๐ Sample data and completed queries: =================================
For all sample files, completed queries and homework solutions, visit the page below: chandoo.org/dac
๐ฅ ADVANCED DATA COURSES BY CHANDOO ======================================
If you want to learn advanced Excel and / or Power BI, consider my paid courses. These in-depth courses cover the entire spectrum of Excel, Power BI, Power Query, Power Pivot and Dashboard reporting in one place with plenty of real-world examples, portfolio projects and completion certificate.
#sql #database #chandoo #freedataanalystcourse #fdacLearn SQL + Database Concepts in 20 MinutesChandoo2024-07-30 | First lesson of my FREE Data Analyst Course.
๐คWhat you will learn: ================== What is a database? What is SQL How to install MySQL on your computer How to write SQL queries Using the sample database - Sakila
โฑ๏ธtopics in this video: ================== 0:00 - What you are going to learn in this video? 0:17 - What is a database? 1:55 - What is SQL? 3:26 - Key Database Terminology and how databases look 6:42 - Types of database software 8:21 - How to install MySQL and sample datasets (Sakila) on your computer? 10:15 - Using MySQL workbench 12:30 - Understanding the Sakila Sample Database 14:28 - Writing your first SQL queries 17:40 - Using column names, where clause in SQL 19:30 - Using ORDER BY clause 20:30 - Solving a work problem with SQL (all rentals in the last week) 24:03 - What is coming up in the lesson #2