Customer Analytics Dashboard in Excel - Setup & Overview : Part 1

✔ Link to download the Excel data file for Practice: https://leanexcelsolutions.com/customer-analytics-dashboard-in-power-bi/ ✔ Link to download the complete dashboard from Store:: https://leanexcelsolutions.com/product/customer-analytics-dashboard-in-excel/ Part 1: Customer Analytics Dashboard in Excel - Setup & Overview Description: Welcome to the first segment of our comprehensive tutorial on crafting an interactive Customer Analytics Dashboard in Microsoft Excel. This session introduces you to the foundational steps, ensuring your dashboard utilizes survey data from Microsoft Forms or Google Forms efficiently. What's Covered: Introduction to the data used: Dive into the structure of survey feedback. Data Transformation: Understand the potential of Power Query to refine and ready your data. PowerPivot Connections: Seamlessly integrate data elements ensuring they communicate. Dashboard Background & Design: A walk-through of aesthetic elements and their setup. Constructing Key Visuals: Build essential visuals to represent overall feedback and gender-specific insights. Watch the tutorial to grasp the initial stages of transforming raw survey feedback into an interactive and insightful dashboard. Don't forget to download the accompanying Excel file from our website for a hands-on experience. Link to Next Part: Part 2 - Advanced Visuals & Analysis: https://youtu.be/PkTPec30ttA Join this channel to get access to perks: https://www.youtube.com/channel/UC_B0oWPRDqkXqDJkMBv6jkA/join Chapters: 00:00 Introduction 01:22 Data Transformation in Power Query Editor 07:20 Load data to Data Model and create connections 09:27 Dashboard Background Design 16:35 Overall Rating Visuals 25:05 Gender-specific Visuals 32:14 Add and modify Slicer Recommended Videos from Tutorials: ✔ How to create an Excel Dashboard with Power Query and Power Pivot? | Tutorial 02: https://youtu.be/PkTPec30ttA ✔ Customer Analytics Dashboard in Power BI: https://youtu.be/0mwToWeybS0 Learn more: ✔ Sales Dashboard in Power BI: https://youtu.be/CGgXHsD19Ek ✔ Sales Distribution Dashboard in Power BI: https://youtu.be/C-Cvaqmchq0 Recommended Playlist: ✔ Excel Dashboard: https://youtube.com/playlist?list=PLYjYcSjCw_LVDPyjNfCrlryE7i6sklJ7T ✔ Sales & Marketing Dashboard: https://youtube.com/playlist?list=PLYjYcSjCw_LVe8dNqdE3u_KVWIdAecvXH Be sure to follow the links to stay in touch: ◼ Channel: https://www.youtube.com/c/LeanExcelSolutions ◼ Channel: https://youtube.com/@LeanExcelSolutions ◼ Website: https://leanexcelsolutions.com ◼ Facebook: https://www.facebook.com/LeanExcelSolutions/ ◼ Instagram: https://www.instagram.com/leanexcelsolutions/ ◼ Pinterest: https://www.pinterest.ca/leanexcelsolutions/ ◼ LinkedIn: https://www.linkedin.com/company/lean-excel-solutions ✔ Share this Video: https://youtu.be/J-m0HePOxOY #powerquery #excel #exceldashboard #dashboard #leanexcelsolutions #customerexperience