Channel Title: Learn Microsoft Fabric, Power BI, SQL Amit Chandak Channel Description: Learn Microsoft Fabric, Power BI, SQL, and Data Analytics with Amit Chandak. Want to learn Power BI, SQL, and Tableau. With over 600 videos on these topics, we have something for everyone. Whether you're a beginner or an experienced user, you'll find the information you need to master these powerful tools. Our videos cover a wide range of topics, including: Power BI basics Power Query DAX Power BI Service Power BI App XMLA endpoint Advance Power BI SQL vs Power BI Power BI Direct Query Power Bi Dataset Power BI Dataflow Tableau Table calculations Level of Details Tableau LOD Tableau Rank SQL SQL Insert, Update, and Delete SQL Index SQL Joins SQL Windows functions If you are preparing for Power BI DA 100, PL 300, this channel provides you with concepts that you need to clear power bi certification. Feature by Feature comparison of Tableau and Power BI. <video> Power BI November 2024 Features: Text Slicer Visual (Preview) Explained! Search by Text Description: Explore the latest Power BI features in the November 2024 update! This video dives into the exciting new Text Slicer Visual (Preview), a game-changer for filtering large datasets quickly and efficiently. Learn how to enable, create, and use this feature to improve your data analysis and presentation workflows. 🔍 Key Highlights: How to enable the new Text Slicer visual Step-by-step guide to creating and using the Text Slicer Tips for customizing filters for improved user experience Perfect for Power BI enthusiasts, analysts, and professionals preparing for certifications like PL-300, DP-600 and DP-700, this video helps you stay ahead in the data visualization game. Don’t forget to like, share, and subscribe for more updates on Power BI features and tutorials! Share your feedback and questions in the comments below. Release Notes: https://powerbi.microsoft.com/en-us/blog/power-bi-november-2024-feature-summary/#post-28484-_Toc268922914 What You'll Learn: 00:00 Introduction to Text Slicer 02:00 Options and Settings for Text Slicer 02:50 Use Text Slicer 04:00 Text Slicer with List Slicer 06:30 Text Slicer for multiple columns ---- ▶️Follow me on: • Medium: https://amitchandak.medium.com • Twitter: https://twitter.com/amitchandak78 • LinkedIn: https://www.linkedin.com/in/amitchandak78/ --------- ▶️My Other Videos: • Mastering Power BI: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb • Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L -~-~~-~~~-~~-~- Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI" https://www.youtube.com/watch?v=cN8AO3_vmlY -~-~~-~~~-~~-~- 🌟 Explore the Comprehensive Power BI Tutorial: 50 Interview Questions and 10 Advanced Case Studies in a 6-Hour Video! 🌟 Watch here: https://www.youtube.com/watch?v=Wfr1Wh5SxwM&list=PLPaNVDMhUXGZ5uQZ_v0tfC5lIjEHoa6Yk </video> <video> SQL Database in Microsoft Fabric: End-to-End Guide| Dataflow Gen 2| Pipeline| Copy Job| SQL Date Description: Explore the newly released SQL Database in Microsoft Fabric (Preview), announced on November 19, 2024! In this video, we cover the end-to-end flow: creating a database, loading data using Dataflow Gen 2, Data Pipeline, and Copy Job, and creating a date table with SQL procedures. We also build a custom semantic model on the SQL Analytics endpoint and showcase a Power BI report—all in one seamless workflow. 🔍 Key Highlights: Overview of SQL Database in Microsoft Fabric features and benefits Step-by-step guide to database creation and data loading How to create a custom semantic model and Power BI report Demonstrating the integration of AI and analytics with SQL Database Perfect for professionals building AI applications, data engineers, and Power BI enthusiasts preparing for certifications like DP-600 and DP-700. Unlock the power of a unified data platform with SQL Database in Microsoft Fabric! Don’t forget to like, comment, and subscribe for more updates on Microsoft Fabric and data integration workflows. Share your feedback below to help us improve! 🛠 Release Notes: https://blog.fabric.microsoft.com/en-in/blog/announcing-sql-database-in-microsoft-fabric-public-preview?ft=All Learn SQL: https://www.youtube.com/watch?v=ThCZYuYAbnY&list=PLPaNVDMhUXGblXMYDB1P46cBhwPXRVgiD Copy Job in Details: Microsoft Fabric Copy Job: Simplify Data Movement with Data Factory: https://www.youtube.com/watch?v=WJRbKk1EZaE&list=PLPaNVDMhUXGZNJX_cmGNnbroGXETISJQf&index=1 Date Table Script: https://medium.com/@amitchandak/power-bi-direct-query-date-table-in-sql-server-b5f4fe0f6d3d What You'll Learn: How to create and use T-SQL Notebooks in Microsoft Fabric Running T-SQL queries on connected warehouses and SQL analytics endpoints 00:00 Introduction to SQL Database in Microsoft Fabric 10:30 Tenant Setting for Copy Job in Microsoft Fabric 11:00 Create SQL Database in Microsoft Fabric 15:30 Try Basic Statements on SQL Database 18:00 Checking SQL Analytics Endpoint Replication and Power BI 22:30 Various Options with SQL Database 29:00 Load Data using Dataflow Gen2 33:00 Load Data using Data Pipeline 39:00 Load Data using Copy Job 43:00 Create a Date table using SQL Script 46:30 Create a Custom Semantic Model 50:00 Analyze Data in Power BI ---- ▶️Follow me on: • Medium: https://amitchandak.medium.com • Twitter: https://twitter.com/amitchandak78 • LinkedIn: https://www.linkedin.com/in/amitchandak78/ --------- ▶️My Other Videos: • Mastering Power BI: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb • Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L -~-~~-~~~-~~-~- Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI" https://www.youtube.com/watch?v=cN8AO3_vmlY -~-~~-~~~-~~-~- 🌟 Explore the Comprehensive Power BI Tutorial: 50 Interview Questions and 10 Advanced Case Studies in a 6-Hour Video! 🌟 Watch here: https://www.youtube.com/watch?v=Wfr1Wh5SxwM&list=PLPaNVDMhUXGZ5uQZ_v0tfC5lIjEHoa6Yk </video> <video> Power Bi Interview Question: Calculate Unique Combinations of Two Columns| Distinct Count| Q62 Description: Question 62: How do I calculate the unique combinations of two columns in Power BI? Or How to get distinctcount to two columns? Learn how to calculate the unique combinations of two columns in Power BI using DAX. In this tutorial, we'll show you how to use the SUMMARIZE function or create a calculated column to get the distinct count of two columns. This method is useful for scenarios where you need to count unique combinations across multiple fields, such as brand and geography. Key Highlights: Using the SUMMARIZE function to calculate distinct combinations Creating calculated columns for distinct counts Step-by-step guide with examples using real data Enhance your Power BI data analysis with accurate distinct counts Whether you're working with sales data or other fields, mastering this technique will help you get better insights from your reports. 🔔 Don't forget to like, comment, and subscribe for more Power BI tutorials and DAX tips! Medium Blog Link: https://medium.com/microsoft-power-bi/power-bi-interview-questions-part-2-de5c7b16db84 Part 1: https://medium.com/@amitchandak/power-bi-interview-questions-part-1-4982de3be327 Don't forget to like, comment, and subscribe for more great content! ▶️Please Subscribe: https://www.youtube.com/@AmitChandak Complete Power BI in one Video ▶️https://www.youtube.com/watch?v=cN8AO3_vmlY ▶️ Here is the timestamp of all the topics I have discussed in this tutorial: 00:00 How to get distinctcount to two columns? 00:30 Understanding the solution 01:30 Try on Power BI Desktop --------- ▶️Follow me on: • Medium: https://amitchandak.medium.com • Twitter: https://twitter.com/amitchandak78 • LinkedIn: https://www.linkedin.com/in/amitchandak78/ --------- ▶️My Other Videos: • Mastering Power BI: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb • Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L -~-~~-~~~-~~-~- Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI" https://www.youtube.com/watch?v=cN8AO3_vmlY -~-~~-~~~-~~-~- </video> <video> Unlock Historical Data with Time Travel in Microsoft Fabric Lakehouse (Hindi Tutorial)| PySpark Description: In this Hindi tutorial, discover how to unlock the power of historical data using the Time Travel feature in Microsoft Fabric Lakehouse. Learn how Microsoft Fabric Lakehouse provides a robust and scalable solution for managing both structured and unstructured data, integrating seamlessly with various data tools. Understand how the Delta Lake unified table format ensures efficient data handling. We'll explore how to view and revert to historical data states, providing flexibility in data management. By leveraging PySpark and Spark SQL, you'll efficiently interact with and analyze historical data, showcasing the platform's capabilities in maintaining and exploring data history. This feature is crucial for data reliability and recovery, making Microsoft Fabric Lakehouse a powerful tool for comprehensive data management and analysis. 🔍 What You'll Learn: How Time Travel works in Microsoft Fabric Lakehouse The mechanics behind querying data at different historical points without creating multiple data copies Using PySpark and Spark SQL to interact with historical data ⏰ Timestamps: 00:00 | What is Time Travel in Fabric Lakehouse 02:00 | Create a Setup to Check Time Travel 07:30 | Use PySpark and Spark SQL to Time Travel </video> <video> #microsoftfabric #Hindi Microsoft Fabric क्या है? #powerbi #learnmicrosoftfarbic Description: Microsoft Fabric क्या है? #MicrosoftFabric Microsoft Fabric एक end-to-end analytics और comprehensive data platform है, जिसमें Data Engineering, Data Factory, Data Science, Real-Time Analytics, Data Warehouse, और Reporting शामिल हैं। यह एक seamlessly integrated, user-friendly platform प्रदान करता है जो आपकी analytics आवश्यकताओं को सरल बनाता है और organizations /companies को उनके data journey में आवश्यक हर चीज़ को प्राप्त करने में सक्षम बनाता है , जिसमें data movement, processing, ingestion, transformation, real-time event routing, और report building शामिल हैं। Fabric data और सेवाओं को seamlessly integrate करता है, जिससे unified management, governance, और discovery को सक्षम किया जा सकता है, जबकि items, data, और row-level access के लिए सुरक्षा सुनिश्चित की जाती है। यदि आप Microsoft Fabric को गहराई से सीखना चाहते हैं, तो चैनल पर Microsoft Fabric श्रृंखला को फॉलो करें। लिंक बायो में है। #MicrosoftFabric #LakeHouse #powerbi #powerbiinterview #powerbiinterviewquestions #warehouse #powerbijobs 💬 Your Feedback Matters: ✨ Don't forget to like, share, and subscribe for more up-to-date tutorials and tips in Power BI. Your feedback is invaluable – drop your thoughts and questions in the comments below! -~-~~-~~~-~~-~- Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI" https://www.youtube.com/watch?v=cN8AO3_vmlY -~-~~-~~~-~~-~- 🌟 Explore the Comprehensive Power BI Tutorial: 50 Interview Questions and 10 Advanced Case Studies in a 6-Hour Video! 🌟 Watch here: https://www.youtube.com/watch?v=Wfr1Wh5SxwM&list=PLPaNVDMhUXGZ5uQZ_v0tfC5lIjEHoa6Yk </video> <video> Power BI November 2024: Small Multiples in Card Visual (Preview) Explained! PL 300 Description: Power BI's November 2024 update introduces an exciting enhancement: Small Multiples for the new Card Visual (Preview). This feature adds advanced functionality, offering improved data organization, visual clarity, and performance. Learn how to create and customize Small Multiples in Power BI to compare OKRs across multiple fields effortlessly. 🔍 Key Highlights: Overview of Small Multiples in the Card Visual Step-by-step guide to enabling and using Small Multiples Advanced formatting options and layout customization Perfect for Power BI users, data analysts, and professionals preparing for certifications like DP-600 and DP-700, this video showcases the latest capabilities to enhance your data visualization skills. Don’t forget to like, comment, and subscribe for more Power BI updates and tutorials. Share your feedback below to help us bring you better content! 🛠 Release Notes: https://powerbi.microsoft.com/en-us/blog/power-bi-november-2024-feature-summary/#post-28484-_Toc777943875 What You'll Learn: 00:00 Introduction to Small Multiples in the Card Visual 03:30 Options and Settings for the New Card Visual 04:30 Use Small Multiples in the Card Visual 05:30 Various option of Small Multiples in the Card Visual ---- ▶️Follow me on: • Medium: https://amitchandak.medium.com • Twitter: https://twitter.com/amitchandak78 • LinkedIn: https://www.linkedin.com/in/amitchandak78/ --------- ▶️My Other Videos: • Mastering Power BI: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb • Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L -~-~~-~~~-~~-~- Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI" https://www.youtube.com/watch?v=cN8AO3_vmlY -~-~~-~~~-~~-~- 🌟 Explore the Comprehensive Power BI Tutorial: 50 Interview Questions and 10 Advanced Case Studies in a 6-Hour Video! 🌟 Watch here: https://www.youtube.com/watch?v=Wfr1Wh5SxwM&list=PLPaNVDMhUXGZ5uQZ_v0tfC5lIjEHoa6Yk </video> <video> Power BI August 2024 Update: Visual Level Format Strings (Preview) | Full Tutorial Description: What is Visual level format strings? Discover the new Visual Level Format Strings feature in Power BI's August 2024 update! In this video, I demonstrate how to take control of your visual calculations and customize formatting at the visual, model, and element levels. With this new capability, you can now format data directly on visuals without modifying your entire model, providing flexibility for specific visualizations and labels. Key Highlights: Introduction to Visual Level Format Strings in Power BI Formatting at the model, visual, and element levels How to use format strings for visual calculations Customizing data labels and visual formats Turning on the visual calculations preview feature Get ready to enhance your Power BI reports with more flexible and precise formatting options. Perfect for Power BI users looking to improve their data visualization and reporting capabilities. 🔔 Don't forget to like, comment, and subscribe for more Power BI updates and tutorials! 📄 Explore more Power BI features and tips on our blog: https://powerbi.microsoft.com/en-us/blog/power-bi-august-2024-feature-summary/#post-27820-_Toc174544098 #PowerBI #PowerBIUpdate #VisualLevelFormatStrings #DataVisualization #PowerBITutorial #PowerBIDesktop #DataFormatting #August2024Release ▶️ Here is the timestamp of all the topics I have discussed in this tutorial: 00:00 Introduction to Visual level format strings? 04:20 Model-level format strings 05:50 Visual-level format strings 07:20 Element-level format strings --------- ▶️Follow me on: • Medium: https://amitchandak.medium.com • Twitter: https://twitter.com/amitchandak78 • LinkedIn: https://www.linkedin.com/in/amitchandak78/ --------- ▶️My Other Videos: • Mastering Power BI: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb • Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L -~-~~-~~~-~~-~- Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI" https://www.youtube.com/watch?v=cN8AO3_vmlY -~-~~-~~~-~~-~- </video> <video> Power BI Interview Question: Sort Matrix Visual Columns by Month-Year in Descending Order| Q 64 Description: Question 64: How do I sort a column of matrix visual in Power BI using a “Month Year” field in descending order? In this video, learn how to sort columns in a Power BI Matrix visual using a "Month Year" field in descending order. We address the common challenge of the missing built-in option for descending order sorting in Matrix visuals. By creating calculated columns with the RankX function and formatting techniques, you can achieve the desired sorting effect. We'll walk you through creating a "Month Year" field, a "Month Year Sort" field, and a "Month Year Sort Desc" field to effectively sort your Matrix visual columns. Perfect for those preparing for Power BI interviews or looking to enhance their data visualization skills. </video> <video> Power BI: How to Enable Dark Mode in Power BI Desktop (September 2024 Update) Description: Discover how to enable the highly anticipated Dark Mode in Power BI Desktop with the September 2024 update! In this tutorial, we'll guide you through the simple steps to personalize your interface, reduce eye strain, and enhance your data visualization experience. Whether you're burning the midnight oil or just prefer a sleeker look, Dark Mode has got you covered. What You'll Learn: Introduction to Dark Mode in Power BI Navigating to personalization settings Step-by-step guide to enabling Dark Mode Overview of other new features in the September 2024 release: https://powerbi.microsoft.com/en-us/blog/power-bi-september-2024-feature-summary/#post-28098-_Toc177480324 If you find this video helpful, please give it a thumbs up and subscribe for more Power BI tutorials and updates! Connect with me: https://www.linkedin.com/in/amitchandak78/ Subscribe: https://www.youtube.com/c/Amitchandak?sub_confirmation=1 LinkedIn: https://www.linkedin.com/in/amitchandak78/ Website: biworld.in 🔔 Don't forget to like, comment, and subscribe for more Power BI updates and tutorials! 📄 Explore more Power BI features and tips on our blog: https://powerbi.microsoft.com/en-us/blog/power-bi-august-2024-feature-summary/#post-27820-_Toc174544098 #PowerBI #PowerBIUpdate #VisualLevelFormatStrings #DataVisualization #PowerBITutorial #PowerBIDesktop #DataFormatting #August2024Release ▶️ Here is the timestamp of all the topics I have discussed in this tutorial: 00:00 Introduction 00:30 Dark mode is now available in Power BI Desktop! 01:20 Enable Dark Mode 02:30 Use Dark Mode --------- ▶️Follow me on: • Medium: https://amitchandak.medium.com • Twitter: https://twitter.com/amitchandak78 • LinkedIn: https://www.linkedin.com/in/amitchandak78/ --------- ▶️My Other Videos: • Mastering Power BI: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb • Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L -~-~~-~~~-~~-~- Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI" https://www.youtube.com/watch?v=cN8AO3_vmlY -~-~~-~~~-~~-~- </video> <video> How to Handle 'Many to Many' Relationships Between Facts in Power BI | Power BI Data Modeling| Q61 Description: Dive deep into the world of Power BI with our in-depth interview questions! Get ready to ace your next Power BI job interview with these essential questions and expert answers. Learn about data modeling, DAX, visualization techniques, and more. Subscribe now to gain a competitive edge. #PowerBI #InterviewTips #DataAnalytics #BusinessIntelligence Struggling with 'Many to Many' relationships between fact tables in Power BI? In this tutorial, learn how to effectively handle these relationships by creating common dimensions and using bridge tables. I'll guide you through identifying shared dimensions, creating distinct columns using DAX or Power Query, and establishing the necessary relationships to ensure accurate and efficient data models. Key Highlights: Identifying common dimensions between fact tables Creating distinct columns using Power Query or DAX Establishing 'One to Many' relationships between facts and dimensions When to use bi-directional relationships Master the art of Power BI data modeling and ensure your reports deliver accurate insights, even with complex 'Many to Many' relationships. Medium Blog Link: https://medium.com/microsoft-power-bi/power-bi-interview-questions-part-2-de5c7b16db84 Part 1: https://medium.com/@amitchandak/power-bi-interview-questions-part-1-4982de3be327 Don't forget to like, comment, and subscribe for more great content! ▶️Please Subscribe: https://www.youtube.com/@AmitChandak Complete Power BI in one Video ▶️https://www.youtube.com/watch?v=cN8AO3_vmlY ▶️ Here is the timestamp of all the topics I have discussed in this tutorial: 00:00 Question 61: How to Solve the “Many to Many” relationship between facts? 00:30 Understanding the solution 03:00 Solve the “Many to Many” relationship between Sales and Purchase 03:30 Create Common Dimensions 04:30 create relationships 06:30 Fix Gap in Date Table 07:10 Analyze data Together --------- ▶️Follow me on: • Medium: https://amitchandak.medium.com • Twitter: https://twitter.com/amitchandak78 • LinkedIn: https://www.linkedin.com/in/amitchandak78/ --------- ▶️My Other Videos: • Mastering Power BI: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb • Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L -~-~~-~~~-~~-~- Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI" https://www.youtube.com/watch?v=cN8AO3_vmlY -~-~~-~~~-~~-~- </video> <video> Power BI October 2024 Update: Visual Calculations, Combo Charts & Field Parameters Description: In this video, we dive into the Power BI October 2024 Feature Summary, highlighting the latest updates that enhance your reporting and data visualization capabilities. Discover how the Visual Calculations Update (Preview) now supports combo charts and field parameters, allowing you to create more dynamic and insightful reports. Link: https://powerbi.microsoft.com/en-us/blog/power-bi-october-2024-feature-summary/#post-28196-_Toc179458529 What You'll Learn: Combo Charts Now Supported: Learn how to use visual calculations in combo charts, like line and clustered column charts, to display moving averages and more. Field Parameters Integration: See how field parameters are now supported with visual calculations, enabling you to switch around what's shown in a visual seamlessly. Faster Templated Calculations: Explore the new, quicker way to add templated visual calculations directly from the ribbon menu. Chapters: 00:00 Introduction to Power BI October 2024 Update 00:40 Visual Calculations Update Overview 03:15 Faster Way to Add Templated Visual Calculations 04:00 Formatting the Visual Calculations 04:30 Using Visual Calculations in Combo Charts 06:40 Integrating Field Parameters with Visual Calculations Stay ahead in data analytics by mastering these new features in Power BI. Don't forget to like, comment, and subscribe for more updates on Microsoft Fabric and Power BI! --------- ▶️Follow me on: • Medium: https://amitchandak.medium.com • Twitter: https://twitter.com/amitchandak78 • LinkedIn: https://www.linkedin.com/in/amitchandak78/ --------- ▶️My Other Videos: • Mastering Power BI: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb • Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L -~-~~-~~~-~~-~- Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI" https://www.youtube.com/watch?v=cN8AO3_vmlY -~-~~-~~~-~~-~- </video> <video> Microsoft Fabric: Introducing T-SQL Notebooks in Microsoft Fabric: Public Preview Tutorial Description: Discover the new T-SQL Notebooks feature in Microsoft Fabric, now available in public preview! In this video, we'll explore how T-SQL developers and BI analysts can leverage Notebooks for Data Warehouse development and complex query management. Learn how to run T-SQL directly on connected warehouses or SQL analytics endpoints, Using Code Templates, and document your process with Markdown cells for better collaboration. We'll also demonstrate how to add multiple warehouses for versatile data analysis. Don't miss out on unlocking powerful data management and analytics capabilities with T-SQL Notebooks in Microsoft Fabric. What You'll Learn: How to create and use T-SQL Notebooks in Microsoft Fabric Running T-SQL queries on connected warehouses and SQL analytics endpoints 00:00 Introduction to T-SQL Notebooks in Microsoft Fabric 04:00 Creating a T-SQL Notebook 04:30 Adding Data Warehouses and SQL Analytics Endpoints 06:00 Using Code Templates and Running T-SQL Code Cells 10:00 Running Various Queries 13:00 Add Markdown cell 17:30 Understanding the session in cell and across cell ---- ▶️Follow me on: • Medium: https://amitchandak.medium.com • Twitter: https://twitter.com/amitchandak78 • LinkedIn: https://www.linkedin.com/in/amitchandak78/ --------- ▶️My Other Videos: • Mastering Power BI: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb • Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L -~-~~-~~~-~~-~- Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI" https://www.youtube.com/watch?v=cN8AO3_vmlY -~-~~-~~~-~~-~- </video> <video> Power BI Interview Question 63- How to Show All City Values in Power BI Tooltip | Concatenatex Description: I have a visual Brand on the category Axis and net measure on the value axis. I would like to add the city column on the tooltip, but there are multiple cities, how can I show all city values on the tooltip? Learn how to display all city values in the tooltip of a Power BI visual when there are multiple cities for each category. In this tutorial, I’ll show you how to use the CONCATENATEX DAX function to concatenate distinct city names and add them to the tooltip, providing a clear, organized display of city values. Key Highlights: How to use CONCATENATEX to concatenate values in Power BI Displaying all cities in the tooltip of a visual Adding concatenated measures to the tooltip Step-by-step guide with DAX expression for better data visualization This method is perfect for handling multiple values in your tooltips, improving the clarity and usability of your Power BI reports. 🔔 Don't forget to like, comment, and subscribe for more Power BI tips and DAX tutorials! Don't forget to like, comment, and subscribe for more great content! ▶️Please Subscribe: https://www.youtube.com/@AmitChandak Complete Power BI in one Video ▶️https://www.youtube.com/watch?v=cN8AO3_vmlY ▶️ Here is the timestamp of all the topics I have discussed in this tutorial: 00:00 How can I show all city values on the tooltip? 00:30 Understanding the solution 01:15 Try on Power BI Desktop --------- ▶️Follow me on: • Medium: https://amitchandak.medium.com • Twitter: https://twitter.com/amitchandak78 • LinkedIn: https://www.linkedin.com/in/amitchandak78/ --------- ▶️My Other Videos: • Mastering Power BI: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb • Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L -~-~~-~~~-~~-~- Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI" https://www.youtube.com/watch?v=cN8AO3_vmlY -~-~~-~~~-~~-~- </video> <video> Power BI Interview Question 65: Date Slicer Tips: Set Slicer to Today or Current Month Description: In this video, we'll answer one of the most frequently asked Power BI interview questions: Is there a way to set a date slicer to always show today’s date or a month slicer to always show the current month? Learn step-by-step how to create dynamic date and month slicers using DAX formulas in Power BI, leveraging static columns and default settings to make your reports more intuitive. We cover practical tips that will help you stand out in your Power BI skills for interviews and real-world applications. Don't miss out on mastering this important Power BI trick! Power BI Interview Part 1: https://amitchandak.medium.com/power-bi-interview-questions-part-1-4982de3be327 Power BI Interview Part 2: https://amitchandak.medium.com/power-bi-interview-questions-part-2-de5c7b16db84 🔔 If you find this video helpful, please like, subscribe, and hit the notification bell for more Power BI interview prep tips and tutorials! 🔔 Don't forget to like, comment, and subscribe for more Power BI tips and DAX tutorials! Don't forget to like, comment, and subscribe for more great content! ▶️Please Subscribe: https://www.youtube.com/@AmitChandak Complete Power BI in one Video ▶️https://www.youtube.com/watch?v=cN8AO3_vmlY ▶️ Here is the timestamp of all the topics I have discussed in this tutorial: 00:00 How to default date slicer in Power BI 00:30 Understanding how to default the slicer 06:50 Try on Power BI Desktop --------- ▶️Follow me on: • Medium: https://amitchandak.medium.com • Twitter: https://twitter.com/amitchandak78 • LinkedIn: https://www.linkedin.com/in/amitchandak78/ --------- ▶️My Other Videos: • Mastering Power BI: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb • Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L -~-~~-~~~-~~-~- Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI" https://www.youtube.com/watch?v=cN8AO3_vmlY -~-~~-~~~-~~-~- </video> <video> Microsoft Fabric Copy Job: Simplify Data Movement with Data Factory | DP 600 | DP 700 Description: Discover the powerful new feature in Microsoft Fabric: Copy Job in Data Factory. Now in public preview, Copy Job takes data ingestion to the next level with its simple, efficient, flexible, and high-performance capabilities. Learn how you can streamline data movement from any source to any destination with just a few clicks. Whether handling batch operations or incremental updates, Copy Job empowers you to manage PB-scale data with ease and precision. In this video, we’ll cover: Benefits of Copy Job: Simplicity, Efficiency, Flexibility, and Performance Step-by-step guide to getting started Real-time monitoring and management tips Ideal for those preparing for certifications like DP-600 (Azure Data Engineer Associate) and DP-700 (Azure Data Fundamentals), this feature highlights essential skills in data integration and optimization. Unlock seamless data integration with Copy Job today. Perfect for professionals seeking faster, smarter, and scalable data solutions! 🔔 Don’t forget to like, subscribe, and hit the bell icon for updates on Microsoft Fabric innovations. Release Notes: https://blog.fabric.microsoft.com/en-in/blog/announcing-public-preview-copy-job-in-microsoft-fabric?ft=All What You'll Learn: How to create and use T-SQL Notebooks in Microsoft Fabric Running T-SQL queries on connected warehouses and SQL analytics endpoints 00:00 Introduction to Copy Job in Microsoft Fabric 02:10 Tenant Setting for Copy Job in Microsoft Fabric 03:20 Creating Copy Job in Microsoft Fabric 06:30 Table mapping in Copy Job 10:00 Use Copy Job with additional data 11:55 Switch off additional data 13:00 Validate Copy Job with additional data ---- ▶️Follow me on: • Medium: https://amitchandak.medium.com • Twitter: https://twitter.com/amitchandak78 • LinkedIn: https://www.linkedin.com/in/amitchandak78/ --------- ▶️My Other Videos: • Mastering Power BI: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb • Expertise Power BI: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L -~-~~-~~~-~~-~- Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI" https://www.youtube.com/watch?v=cN8AO3_vmlY -~-~~-~~~-~~-~- 🌟 Explore the Comprehensive Power BI Tutorial: 50 Interview Questions and 10 Advanced Case Studies in a 6-Hour Video! 🌟 Watch here: https://www.youtube.com/watch?v=Wfr1Wh5SxwM&list=PLPaNVDMhUXGZ5uQZ_v0tfC5lIjEHoa6Yk </video>

Contacts and Links

Description

Learn Microsoft Fabric, Power BI, SQL, and Data Analytics with Amit Chandak. Want to learn Power BI, SQL, and Tableau. With over 600 videos on these topics, we have something for everyone. Whether you're a beginner or an experienced user, you'll find the information you need to master these powerful tools.

Our videos cover a wide range of topics, including:

Power BI basics
Power Query
DAX
Power BI Service
Power BI App
XMLA endpoint
Advance Power BI
SQL vs Power BI
Power BI Direct Query
Power Bi Dataset
Power BI Dataflow
Tableau
Table calculations
Level of Details
Tableau LOD
Tableau Rank
SQL
SQL Insert, Update, and Delete
SQL Index
SQL Joins
SQL Windows functions
If you are preparing for Power BI DA 100, PL 300, this channel provides you with concepts that you need to clear power bi certification.
Feature by Feature comparison of Tableau and Power BI.

Videos from channel