Customer Analytics Dashboard in Excel - Setup & Overview : Part 1
✔ Link to download the Excel data file for Practice: https://leanexcelsolutions.com/custom...
✔ Link to download the complete dashboard from Store:: https://leanexcelsolutions.com/produc...
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: • Customer Analytics Dashboard in Excel - Ad...
Join this channel to get access to perks:
/ @leanexcelsolutions
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: • Customer Analytics Dashboard in Excel - Ad...
✔ Customer Analytics Dashboard in Power BI: • Customer Analytics Dashboard in Power BI |...
Learn more:
✔ Sales Dashboard in Power BI: • Sales Dashboard in Power BI | Power BI Das...
✔ Sales Distribution Dashboard in Power BI: • Sales Distribution Dashboard in Power BI |...
Recommended Playlist:
✔ Excel Dashboard: • Excel Dashboards
✔ Sales & Marketing Dashboard: • Sales & Marketing Dashboard
Be sure to follow the links to stay in touch:
◼ Channel: / leanexcelsolutions
◼ Channel: / @leanexcelsolutions
◼ Website: https://leanexcelsolutions.com
◼ Facebook: / leanexcelsolutions
◼ Instagram: / leanexcelsolutions
◼ Pinterest: https://www.pinterest.ca/leanexcelsol...
◼ LinkedIn: / lean-excel-solutions
✔ Share this Video: • Customer Analytics Dashboard in Excel - Se...
#powerquery
#excel
#exceldashboard
#dashboard
#leanexcelsolutions
#customerexperience