Channel Title: Analytical Guy Channel Description: The Objective of this channel is to give knowledge related to Data Analytics for FREE. If you want to join my newsletter, you can submit your details here: https://forms.gle/MPMNQRjYmzBWTerr8 This newsletter is a strong community of 2k+ people getting knowledge related to Data Analytics (Excel, Power BI, SQL, Python), as well as Job & Interview tips. #dataanalytics #dataanalyst #datascientist #microsoftpowerbi #sql <video> Data Analyst Resume for Freshers | 0-2 Years of Work Experience | Resume Template Files to Download Description: 🚀 You can Download the FREE resume template: analyticalguy.substack.com (You will receive the link to the template on the mail) ▶ Have queries regarding Data Analytics or studying abroad? Get in touch! https://topmate.io/analyticalguy Are you a fresher looking to break into the world of Data Analytics or Business Analysis? Struggling to craft a resume that grabs the attention of recruiters and hiring managers? In this video, we’ll walk you through how to create an effective resume template specifically designed for freshers and those with little or no experience in the field. 📌 What You’ll Learn in This Video: 1. How to Create your Resume 2. What Sections are important 3. Do's and Don'ts of Resume 4. Tips for Interview Calls --- Comment below to get your RESUME or Linkedin Profile reviewed. 📌 Data Analytics Projects PLAYLIST https://www.youtube.com/playlist?list=PL_JkuH1QNmGHkjzNR4iEqMEnWKL1mEUEr #dataanalyst #ResumeTemplate #resumewriting </video> <video> 1. Getting started with Microsoft Fabric for Beginners | Will this impact your Job growth? Description: ▶ Have queries regarding Data Analytics or studying abroad? Get in touch! https://topmate.io/analyticalguy ▶ Other Microsoft Fabric material for study https://learn.microsoft.com/en-gb/training/courses/dp-600t00 ▶ Study guide for DP600 Certification https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600 Microsoft Fabric is an all-in-one analytics platform that brings together data integration, engineering, real-time analytics, and business intelligence—perfect for anyone looking to streamline their data workflows. Whether you're a Business Analyst, Data Engineer, Data Scientist or just curious about the future of Data & AI, this playlist will help you get started with Fabric, step by step. ▶ Timeline: 00:05 Intro 01:05 What is Microsoft Fabric? 02:05 Who is this course for? 03:10 OneLake 05:00 Introduction to Fabric EXPERIENCES 06:15 Synapse Data Engineering 08:40 Synapse Data Science 12:05 Synapse Real-Time Intelligence 13:45 Data Factory 16:15 Power BI 17:05 Learning Strategy 18:40 Overview of the Fabric Platform 26:05 Pathways for data folks & Salary expected 🔍 What You'll Learn: 1. What is Microsoft Fabric 2. Is this Course for you? 3. Are you working on Power BI and want to up-skill? 4. How to get the DP600 Certification 5. Jobs after Microsoft fabric #microsoftfabric #microsoft #powerbi </video> <video> Study Masters Abroad from UWA | Jobs and Salaries after Masters | Data Science vs Business Analytics Description: ▶ Want to connect with me? https://topmate.io/analyticalguy Timeline: 00:00 Intro 01:20 9 Key Criteria Framework 18:30 Compare Universities 21:00 Salaries for Data Analyst | Data Engineer | Data Scientist 23:30 Data Science Curriculum at UWA Thinking about pursuing your master's abroad? In this video, I explore the amazing opportunities offered by the University of Western Australia (UWA) for international students. I'll compare Data Science and Business Analytics programs, including: ✅ Course structure and career prospects ✅ Job opportunities post-graduation ✅ Salary expectations in Australia ✅ Skills you’ll gain and industries you can work in Whether you're deciding between Data Science or Business Analytics, or just curious about studying at UWA, this video has you covered! 💡 Subscribe for more videos on career tips, study options, and analytics tutorials! ▶ Mastering Data Science | My journey in Australia's Top University #australia #datascience https://www.youtube.com/watch?v=UStwHtsCwGI&t=374s ▶ Instagram Handle: / analyticalguy ▶▶ TOP PLAYLISTS ▶▶ ▶ POWER QUERY: • POWER QUERY ▶ DAX: • DAX Series ▶ Excel training: • Excel Training ▶ POWER BI: • How to Power BI? ▶ Portfolio PROJECTS: • Data Analytics Projects ▶ Data Analytics: • Become a Data Analyst </video> <video> Ultimate XLOOKUP Tutorial | Best EXCEL function for a Data Analyst | Practice Files included Description: ▶ Have queries regarding Data Analytics or studying abroad? Get in touch! https://topmate.io/analyticalguy ▶ Discord Community Channel (FREE) - Invite Only https://discord.gg/4KWBnqYG (This channel will be used to discuss latest trends, data related problems, portfolio projects, resume reviewing and much more) ▶ Dataset Used (XLOOKUP) https://bit.ly/xlookupformula ▶ In this video: Discover how to master Excel's XLOOKUP function with our quick guide! Learn to efficiently retrieve data across your spreadsheets and tackle complex lookup scenarios effortlessly. 📝 Timestamps: 00:20 - XLOOKUP Definition 00:35 - Task 1 03:25 - Task 2 05:15 - Task 3 07:20 - Task 4 08:20 - Task 5 11:15 - Additional functionality of xLOOKUP 🔔 Don't Forget to Subscribe! If you found this video helpful, make sure to hit the subscribe button and ring the bell for more tutorials on Excel, data analysis, and much more. Leave a comment with any questions or topics you'd like us to cover next! 💡 LEARN MORE ======================== ▶ Power BI Playlist -- https://bit.ly/3U3NVts ▶ Data Analytics Projects -- https://bit.ly/3hb84zd ▶ Excel Training - https://bit.ly/3WvCUTs #Dataanalyst #dataanalytics #Analyticsjob #excel #exceltips </video> <video> Become Job ready by 2025 | Roadmap to become a Data Analyst in 2 Months | Top SKILLS to learn Description: 🚀 You can Download the FREE resume template: analyticalguy.substack.com (You will receive the link to the template on the mail) ▶ Have queries regarding Data Analytics or studying abroad? Get in touch! https://topmate.io/analyticalguy Are you ready to kickstart your career as a Data Analyst in just 2 months? In this video, I'll guide you through a focused learning roadmap designed for beginners, covering the essential tools and skills needed to succeed in data analysis. I'll walk you through every step of the journey. Plus, you'll get tips on building a strong portfolio, networking effectively on LinkedIn, and how to use tools like ChatGPT to level up your skills quickly. If you're looking for a clear, actionable path to becoming a successful Data Analyst in just 60 days, this is the video for you! SQL: https://www.youtube.com/playlist?list=PL_JkuH1QNmGEcUvUjYPvSSMP_61pYM-1E Power Query: https://www.youtube.com/playlist?list=PL_JkuH1QNmGHES_TW4BrvZZqtsqxhA33p Power BI https://www.youtube.com/playlist?list=PL_JkuH1QNmGF4rEpyAdlfFITB_CgQbXRt Microsoft Excel https://www.youtube.com/playlist?list=PL_JkuH1QNmGEj59KALRE7jkY8HGIiAzH1 Data Analytics PROJECTS https://www.youtube.com/playlist?list=PL_JkuH1QNmGHkjzNR4iEqMEnWKL1mEUEr #dataanalyst #BecomeJobReady #dataanalystjobs </video> <video> Master Power BI Line Charts – Dynamic Line Highlighting Explained #datavisualization Description: ▶ Have queries regarding Data Analytics or studying abroad? Get in touch! https://topmate.io/analyticalguy In this video, I’ll show you how to create a dynamic line chart where the selected category stands out in vibrant color while the rest fade into grey. This interactive technique is perfect for creating focused insights and cleaner visuals that impress your audience. 🎯 What You’ll Learn in This Video: ▶ How to use filters to dynamically highlight a line. ▶ Step-by-step guide to implementing conditional formatting. ▶ Best practices for making your charts interactive and intuitive. 💡 Why Use Dynamic Highlighting? ▶ This feature allows you to spotlight a specific category in a cluttered chart, making your data stories clearer and more impactful. ▶ Sales Analysis Heat Map by TIME & DAY on POWER BI | Analysing Hourly Sales Data Trends using M Query https://www.youtube.com/watch?v=UQdG9zagLPg&list=PL_JkuH1QNmGF4rEpyAdlfFITB_CgQbXRt&index=5&t=326s ▶ Power BI Playlist -- https://bit.ly/3U3NVts ▶ Data Analytics Projects -- https://bit.ly/3hb84zd ▶ Excel Training - https://bit.ly/3WvCUTs 📁 Data Analyst Resume: ================ Data Analyst Resume for Freshers | 0-2 Years of Work Experience | Resume Template Files to Download https://www.youtube.com/watch?v=0RQaKlCXNpo&t=156s ▶ How I would Study Data Analytics in 2025 (If I had to start over) | Schedule | Salaries | Skill Set? https://www.youtube.com/watch?v=MCoZCs4pamw&t=690s 👉 Don't forget to like, subscribe, and hit the bell icon for more Power BI tips and tricks. #powerbi #datavisualization #datastorytelling </video> <video> How to Land Your First Data Analyst Job: Essential Tips & Strategies for Success! Description: ▶ Have queries regarding Data Analytics or studying abroad? Get in touch! https://topmate.io/analyticalguy Ready to start your career as a Data Analyst? This video is your ultimate guide to landing that first job! Whether you're a recent graduate or making a career switch, I've got you covered with actionable tips and proven strategies. 🔍 What You'll Learn: 1. Effective Job Search Strategies: Discover where and how to find the best data analyst job opportunities. 2. Master the STAR Method: Learn how to craft compelling responses to interview questions and stand out from the competition. 3. Resume Tips That Work: Create a resume that highlights your skills and experiences in a way that catches recruiters’ eyes. 4. Optimize Your LinkedIn Profile: Tips on building a professional LinkedIn profile that attracts job offers. 5. Networking Hacks: Learn how to expand your professional network and leverage connections to get your foot in the door. 💡 LEARN MORE ======================== ▶ Power BI Playlist -- https://bit.ly/3U3NVts ▶ Data Analytics Projects -- https://bit.ly/3hb84zd ▶ Excel Training - https://bit.ly/3WvCUTs #Dataanalyst #dataanalytics #Analyticsjob #powerbi </video> <video> 2. What is Lakehouse and how to Create Lakehouse in Microsoft Fabric | Download Dataset for Practice Description: ▶ Have queries regarding Microsoft Fabric/Analytics or studying abroad? Get in touch! https://topmate.io/analyticalguy ▶ Other Microsoft Fabric material for study https://learn.microsoft.com/en-gb/training/courses/dp-600t00 ▶ Study guide for DP600 Certification https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600 ▶ Dataset to download https://github.com/atikant-sql/Microsoft-Fabric-Course/blob/main/sales_dataforlakehouse.csv A Lakehouse presents as a database and is built on top of a data lake using Delta format tables. Lakehouses combine the SQL-based analytical capabilities of a relational data warehouse and the flexibility and scalability of a data lake. Lakehouses store all data formats and can be used with various analytics tools and programming languages. As cloud-based solutions, lakehouses can scale automatically and provide high availability and disaster recovery. 🔍 What You'll Learn: 1. What is Lakehouse? 2. How to create Lakehouse step by step 3. How to work on spark notebooks ▶ Timeline: 0:10 What is Lakehouse? Data Warehouse + Data Lake 1:50 Step-By-Step guide to create Lakehouse in Fabric Watch Intro Video on Microsoft Fabric: https://www.youtube.com/watch?v=3UDpXvgXJ2M&t=225s #microsoftfabric #lakehouse #datawarehouse #DataTerminology </video> <video> 3. Microsoft Fabric | Data Analysis with Apache Spark | PySpark | Partitioning Data on Month Description: ▶ Have queries regarding Data Analytics or studying abroad? Get in touch! https://topmate.io/analyticalguy ▶ Module3 Dataset Download https://github.com/atikant-sql/Microsoft-Fabric-Course/blob/main/orders.zip ▶ Other Microsoft Fabric material for study https://learn.microsoft.com/en-gb/training/courses/dp-600t00 ▶ Study guide for DP600 Certification https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600 Microsoft Fabric is an all-in-one analytics platform that brings together data integration, engineering, real-time analytics, and business intelligence—perfect for anyone looking to streamline their data workflows. In this video we will perform data analysis using Apache Spark. ▶ Timeline: 00:00 Recap THEORY — 00:35 🔍 What You'll Learn from this video 01:30 What is Apache Spark? 03:50 TIMELINE in Big Data 06:15 Hadoop vs Spark 07:00 Apache Architecture PRACTICAL — 11:50 Microsoft Fabric Platform 12:10 Create Workspace 12:40 Create Lakehouse 13:30 Upload Folder from local 14:30 Create Notebook 16:00 Analysis using Apache spark 18:00 Changing Data Types of columns 25:00 Data Manipulation using Apache spark 28:00 Explore more using PySpark 33:00 Transform Data 40:00 How to Save the Data 45:00 Partition the Data on Month and Year ▶ Module1 : Getting started with Microsoft Fabric for Beginners | Will this impact your Job growth? https://www.youtube.com/watch?v=3UDpXvgXJ2M&t=1086s ▶ Module2 : What is Lakehouse? Step by Step guide to create a Lakehouse in Microsoft Fabric https://www.youtube.com/watch?v=3UDpXvgXJ2M&t=85s #MicrosoftFabric #Microsoft #PowerBI </video> <video> Learn how to use Python in Excel | End-To-End TUTORIAL | Data Cleaning file for practice Description: ▶ Have queries regarding Data Analytics or studying abroad? Get in touch! https://topmate.io/analyticalguy ▶ Download the file for practice https://analyticalguy.substack.com/p/getting-started-with-python-in-excel ▶ Timeline: 00:00 Introduction to Python in Excel 00:50 Licenses required to use Python in Excel 02:00 Basic Operations 13:45 Time Analysis 21:30 Querying in Excel 24:20 Advanced techniques 34:00 Bonus 🔍 What You'll Learn: 1. Python Basics in Excel 2. How to use Queries 3. Various functions of Python 4. Data Cleaning and transformation in Excel #DataAnalyst #Python #exceladvanced </video> <video> 4. Microsoft Fabric | How to create Delta Tables and analyse the data using SQL Queries Description: ▶ Have queries regarding Data Analytics or studying abroad? Get in touch! https://topmate.io/analyticalguy ▶ Module4 Dataset Download https://github.com/atikant-sql/Microsoft-Fabric-Course/tree/main/4.%20Working%20with%20Delta%20Tables Discover how to set up and work with Delta Lake tables in Microsoft Fabric! In this video, we dive into the essentials of Delta Lake and explore the benefits of using Delta tables for data reliability, consistency, and performance. I’ll walk you through each step, from understanding the basics of Delta Lake to creating your first Delta table in Microsoft Fabric. 🔹 Topics Covered: What is Delta Lake? Why use Delta Tables in Microsoft Fabric? Step-by-step creation of Delta tables Key advantages of Delta Lake for data storage and analytics Best practices for managing data in Delta format ▶ Timeline: 00:00 Recap THEORY — 1:50 What to expect in this video? 3:50 What is DELTA LAKE? 07:00 Data Warehouse vs Data Lake vs Delta Lake 9:20 Benefits of Delta Tables 12:20 3 Methods used to create Delta Table PRACTICAL — 15:00 Create Lakehouse 18:00 Create a DataFrame (df) 24:30 Create Delta Table using df 30:15 Create Delta Table using SQL 40:00 Analyse Delta table data using SQL Queries ▶ Module1 : Getting started with Microsoft Fabric for Beginners | Will this impact your Job growth? https://www.youtube.com/watch?v=3UDpXvgXJ2M&t=1260s ▶ Module2 : What is Lakehouse and how to Create Lakehouse in Microsoft Fabric? https://www.youtube.com/watch?v=fVQX7amGwDE ▶ Module3 : Data Analysis with Apache Spark | PySpark https://www.youtube.com/watch?v=pal2HmXFulc&t=1613s #microsoftfabric #deltatable </video> <video> Complete Power Query End to End Tutorial | Full Beginners Guide for Excel or Power BI | Cheatsheet Description: ▶ Have queries regarding Data Analytics or studying abroad? Get in touch! https://topmate.io/analyticalguy ▶ Download the file for practice https://analyticalguy.substack.com/p/effortless-data-cleaning-for-everyone What is Power Query? (Microsoft Definition) Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. Because the engine is available in many products and services, the destination where the data will be stored depends on where Power Query was used. Using Power Query, you can perform the extract, transform, and load (ETL) processing of data. Power Query helps you to automate your tasks, so that you never have to repeat the same steps. ▶ Getting Started: How to access Power Query and load your first dataset. ▶ Data Cleaning Made Easy: Removing duplicates, splitting columns, and handling missing values. ▶ Transformations: Pivoting, unpivoting, and reshaping your data like a pro. ▶ Advanced Features: Merging and appending tables for seamless data integration. ▶ Automation: Refreshing queries and streamlining repetitive tasks. By the end of the tutorial, you’ll have all the tools you need to transform messy data into clean, ready-to-use datasets. ▶ Advanced Power Query for Data Cleaning :::: https://www.youtube.com/watch?v=cx1qosaiLu8&t=584s 🛑Data Analyst Journey: ===================== Data Cleaning Exercises for Data Analyst | Excel tutorial | Practical Examples Challenge |Automation https://www.youtube.com/watch?v=9iH70owW2eM Learn how to use Python in Excel | End-To-End TUTORIAL | Data Cleaning file for practice https://www.youtube.com/watch?v=v-aY3lIBy1s&t=2211s 💡 LEARN MORE ======================== ▶ Power BI Playlist -- https://bit.ly/3U3NVts ▶ Data Analytics Projects -- https://bit.ly/3hb84zd ▶ Excel Training - https://bit.ly/3WvCUTs #powerquery #excel #dataanalyst #powerbi </video> <video> Easiest way to Combine Files from a Folder using POWER QUERY | Step-By-Step Guide (Any extension) Description: ▶ Have queries regarding Data Analytics or studying abroad? Get in touch! https://topmate.io/analyticalguy ▶ Discord Community Channel (FREE) - Invite Only https://discord.com/invite/4KWBnqYG (This channel will be used to discuss latest trends, data related problems, portfolio projects, resume reviewing and much more) ▶ Dataset Used & Python Script https://bit.ly/ExcelCombine ▶ In this video: Learn how to effortlessly combine multiple files from a folder using Power Query in this step-by-step tutorial. Whether you’re dealing with CSVs, Excel sheets, or other file formats, we’ll show you how to merge them into a single dataset quickly. This guide is perfect for streamlining your data analysis and saving time on repetitive tasks. Follow along as we explore the powerful features of Power Query and turn scattered files into organized, actionable insights. 🔔 Please Subscribe! If you found this video helpful, make sure to hit the subscribe button and ring the bell for more tutorials on Excel, data analysis, and much more. Leave a comment with any questions or topics you'd like us to cover next! 💡 LEARN MORE ======================== ▶ Power BI Playlist -- https://bit.ly/3U3NVts ▶ Data Analytics Projects -- https://bit.ly/3hb84zd ▶ Excel Training - https://bit.ly/3WvCUTs ▶ Power Query Training - https://bit.ly/PowerQueryPlaylist #Dataanalyst #dataanalytics #Analyticsjob #excel #exceltips #PowerQuery </video> <video> Power BI Matrix Visuals Made Easy: Advanced Techniques to Impress Clients | Power BI Native Visual Description: ▶ Have queries regarding Data Analytics or studying abroad? Get in touch! https://topmate.io/analyticalguy In this video, I’ll take you through a step-by-step journey of transforming a basic Matrix Visual into an Advanced Matrix Visual that not only looks professional but also delivers insightful analytics for your clients. 📌 What you’ll learn: ✅ How to create and format a basic Matrix Visual. ✅ Tips to add conditional formatting for better data storytelling. ✅ Tricks to utilize subtotals, row and column headers, and hierarchies effectively. ✅ Advanced techniques for making your visuals dynamic and interactive. 📊 Why this is important: Matrix visuals are a cornerstone for showcasing detailed insights in a structured manner. By upgrading them, you can impress your clients and provide more actionable insights! ▶ Sales Analysis Heat Map by TIME & DAY on POWER BI | Analysing Hourly Sales Data Trends using M Query https://www.youtube.com/watch?v=UQdG9zagLPg&list=PL_JkuH1QNmGF4rEpyAdlfFITB_CgQbXRt&index=5&t=326s ▶ Power BI Playlist -- https://bit.ly/3U3NVts ▶ Data Analytics Projects -- https://bit.ly/3hb84zd ▶ Excel Training - https://bit.ly/3WvCUTs 📁 Data Analyst Resume: ================ Data Analyst Resume for Freshers | 0-2 Years of Work Experience | Resume Template Files to Download https://www.youtube.com/watch?v=0RQaKlCXNpo&t=156s ▶ How I would Study Data Analytics in 2023 (If I had to start over) | Schedule | Salaries | Skill Set? https://www.youtube.com/watch?v=MCoZCs4pamw&t=690s #powerbi #datavisualization #datastorytelling </video> <video> From a Business Analyst to Head of Data at Strava | In Conversation with Shailvi Wakhlu Description: Welcome to a new episode of Analytics Unplugged Podcast | Conversations with Experts, where we bring in Data Experts to share their career journey and expertise to help others learn and grow. In this podcast, I had an insightful conversation with Shailvi Wakhlu, a seasoned data leader and Head of Data at Strava. We discussed her impressive career journey from a Business Analyst to a Data Head at top companies, delving into the strategies that have fueled her success. Shailvi shared invaluable advice for data professionals on navigating the competitive landscape, mastering data storytelling, and advancing in the ever-evolving field of data analytics. Tune in to gain actionable tips on career growth in data, leadership, and more! 00:00 Trailer 00:40 Introduction to the podcast 01:00 About the speaker 02:30 Journey at Strava (Data Journey) 03:30 Data Challenges at Strava 04:30 Data Integration 06:00 Common challenges at early stage startups 08:30 Focussing on best practises/concepts rather than tools 09:10 Trending tools ⚒️ 12:00 Trending topics every company is talking about 14:00 Big opportunity 14:30 About Data storytelling www.Shailvi.com 18:00 What is Self-Advocacy? 19:30 Are data folks introvert? 21:30 Try saying NO ? 😀 23:45 How to get PROMOTION? 25:00 Outro Connect with Shailvi Wakhlu: https://www.linkedin.com/in/shailviw/ Connect with me: https://www.linkedin.com/in/atikantjain/ [Data Analytics] [Business Analytics] [Python] [SQL] [Machine Learning] [Data Jobs] [Job Market in United States] [Data Science] [Data Leaders] [Women in Tech] [Power BI] [Tableau] </video>

Contacts and Links

Description

The Objective of this channel is to give knowledge related to Data Analytics for FREE.

If you want to join my newsletter, you can submit your details here: https://forms.gle/MPMNQRjYmzBWTerr8

This newsletter is a strong community of 2k+ people getting knowledge related to Data Analytics (Excel, Power BI, SQL, Python), as well as Job & Interview tips.

#dataanalytics #dataanalyst #datascientist #microsoftpowerbi #sql

Videos from channel