Data Visualization with Tableau and Microsoft Excel
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Data Visualization with Tableau and Microsoft Excel
This course is part of Python, SQL, Tableau for Data Science Professional Certificate
Included with
Learn more
Ask Coursera
Skills you'll gain
- Tableau Software
- Excel Formulas
- Pivot Tables And Charts
- Analytical Skills
- Data Storytelling
- Interactive Data Visualization
- Business Metrics
- Data Visualization Software
- Spreadsheet Software
- Business Intelligence
- Data Analysis Software
- Performance Tuning
- Data Visualization
- Analytics
- Dashboard Creation
- Data Analysis
- Data Presentation
Tools you'll learn
Details to know
See how employees at top companies are mastering in-demand skills
Build your Data Analysis expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate from Coursera
There are 5 modules in this course
Leverage modern data visualization tools in this comprehensive course designed for business professionals and analysts. Through hands-on projects using real-world datasets, you'll learn to create compelling visualizations and interactive dashboards using industry-standard tools like Tableau and Excel, enhanced by AI-driven insights.
This course is perfect for analysts and business professionals who want to transform complex data into clear, actionable insights. Starting with fundamental visualization principles and progressing to advanced dashboard creation, you'll develop the practical skills needed to communicate data stories effectively across any organization. Upon completion, you'll be able to: β’ Create powerful visualizations and interactive dashboards using Tableau and Excel β’ Design and implement custom calculations and metrics for deeper analysis β’ Build compelling data stories through narrative visualization techniques β’ Optimize dashboard performance and implement real-time updates β’ Leverage AI tools to enhance visualization design and automation
Welcome to the transformative world of data visualization, where raw numbers become compelling stories that drive business decisions. In this foundational module, you'll master essential Business Intelligence (BI) tools like Tableau and Excel, learning how to connect to data sources, clean and transform data, and create impactful visualizations that bring insights to life. Working with real-world scenarios from Global Finance Corp, you'll develop practical skills that will immediately enhance your ability to communicate complex data stories effectively.
What's included
5 videos11 readings3 assignments3 ungraded labs
5 videosβ’Total 16 minutes
- Welcome to Data Visualization with BI Toolsβ’2 minutes
- Day in the Life - An Interview With an Expertβ’5 minutes
- Getting Started With Tableau Publicβ’3 minutes
- Connecting Tableau to Data Sourcesβ’3 minutes
- Data Cleaning & Transformation Techniquesβ’3 minutes
11 readingsβ’Total 232 minutes
- Course Syllabus & Roadmapβ’30 minutes
- Introduction to Business Intelligence & Modern BI Toolsβ’30 minutes
- Global Finance Corp Introductionβ’10 minutes
- Video Transcript Accessβ’10 minutes
- BI Tools at a Glanceβ’20 minutes
- Setting Up Tableauβ’30 minutes
- Understanding Data Sources in Tableauβ’20 minutes
- Connecting to Databases and Online Services in Tableau Desktopβ’2 minutes
- Troubleshooting Data Connections in Tableauβ’20 minutes
- Data Cleaning Essentials: From Messy to Analysis-Ready Dataβ’30 minutes
- From Raw Data to First Insights: A Social Media Analysis Challengeβ’30 minutes
3 assignmentsβ’Total 180 minutes
- Module 1 Graded Assessmentβ’120 minutes
- Knowledge Check: Data Source Connectionsβ’30 minutes
- Knowledge Check: Data Transformation Strategiesβ’30 minutes
3 ungraded labsβ’Total 180 minutes
- Data Connection Lab β’60 minutes
- Data Preparation in Tableauβ’60 minutes
- Data Exploration on a Social Media Dataset Challengeβ’60 minutes
Master Tableau's calculation and visualization capabilities to transform raw data into compelling insights. Through hands-on practice with Global Finance Corp's real-world data, you'll learn to create everything from basic calculations to sophisticated LOD expressions, while building both standard and specialized visualizations. You'll develop the skills to craft interactive dashboards that make complex data accessible and drive data-driven decisions.
What's included
4 videos4 readings3 assignments5 ungraded labs
4 videosβ’Total 22 minutes
- Mastering Calculations in Tableauβ’5 minutes
- Advanced Calculation Techniques in Tableau: Mastering LOD Expressionsβ’5 minutes
- Building Your First Visualizationsβ’4 minutes
- Advanced Charting Techniquesβ’8 minutes
4 readingsβ’Total 100 minutes
- Foundations of Calculations in Tableau: From Basic Math to Table Calculationsβ’30 minutes
- Mastering Level of Detail (LOD) Expressions: Beyond Basic Calculationsβ’30 minutes
- Choosing the Right Visualization: A Guide to Basic Chart Typesβ’10 minutes
- Specialized Visualizations in Tableauβ’30 minutes
3 assignmentsβ’Total 180 minutes
- Module 2 Graded Assessmentβ’120 minutes
- Knowledge Check: Calculation Fundamentalsβ’30 minutes
- Knowledge Check: Visualization Fundamentalsβ’30 minutes
5 ungraded labsβ’Total 300 minutes
- Basic and Table Calculation Exercisesβ’60 minutes
- Advanced Calculation Labβ’60 minutes
- Basic Visualization Labβ’60 minutes
- Specialized Visualization Labβ’60 minutes
- Advanced Analytics With Tableau Challengeβ’60 minutes
Master the art of transforming data into interactive, performance-optimized dashboards that tell compelling stories. Through hands-on practice with both Global Finance Corp's financial data and SocialPulse's social media metrics, you'll learn to design intuitive interfaces, implement strategic interactivity, and optimize for real-world deployment. You'll develop skills in combining multiple visualizations, crafting narrative elements, and ensuring smooth performanceβall while creating dashboards that drive data-driven decisions across different business contexts.
What's included
3 videos6 readings3 assignments4 ungraded labs
3 videosβ’Total 15 minutes
- Designing Interactive Dashboardsβ’6 minutes
- Crafting Data Stories With BI Toolsβ’4 minutes
- Optimizing and Sharing Your Dashboardsβ’5 minutes
6 readingsβ’Total 160 minutes
- Dashboard Design Principles: Creating Interactive User Experiencesβ’30 minutes
- Narrative Visualization Techniquesβ’30 minutes
- Leveraging Automated Insights in Tableauβ’20 minutes
- Setting Up Live Data Connectionsβ’30 minutes
- Real-Time Dashboard Techniquesβ’20 minutes
- Best Practices for Dashboard Performance and Publishingβ’30 minutes
3 assignmentsβ’Total 90 minutes
- Module 3 Graded Assessmentβ’30 minutes
- Knowledge Check: Data Storytellingβ’30 minutes
- Knowledge Check: Dashboard Performance and Publishingβ’30 minutes
4 ungraded labsβ’Total 240 minutes
- Dashboard Labβ’60 minutes
- Data Story Labβ’60 minutes
- Open Lab Activity: Public Dashboard Optimizationβ’60 minutes
- Multi-Visual Dashboard Design Challengeβ’60 minutes
Discover how to leverage Excel Online's powerful features for data analysis and visualization while understanding its enterprise capabilities. Through hands-on practice with both Global Finance Corp.'s investment portfolio data and SocialPulse's social media metrics, you'll master essential spreadsheet operations, create dynamic analyses using functions and PivotTables, and build professional dashboards. Learn to enhance your workflow with AI assistance while creating clear, actionable visualizations that drive business decisions. By the end of this module, you'll understand when and how to effectively use Excel within a broader data analysis toolkit, balancing its accessibility with enterprise-level features.
What's included
4 videos4 readings2 assignments3 ungraded labs
4 videosβ’Total 15 minutes
- Why Excel?β’2 minutes
- Getting Started With Excel Onlineβ’3 minutes
- Excel Functions & AI Tools for Data Analysisβ’6 minutes
- Building Your First Excel Dashboardβ’4 minutes
4 readingsβ’Total 100 minutes
- Excel in Modern Data Scienceβ’30 minutes
- Setting Up Excel for Data Analysis β’10 minutes
- Data Visualization Fundamentals for Excel Dashboardsβ’30 minutes
- Advanced Excel Capabilities in Enterprise Settingsβ’30 minutes
2 assignmentsβ’Total 60 minutes
- Module 4 Graded Assessmentβ’30 minutes
- Knowledge Check: Excel Fundamentalsβ’30 minutes
3 ungraded labsβ’Total 180 minutes
- Excel Data Cleaning Labβ’60 minutes
- Data Analysis & Dashboard Creation Labβ’60 minutes
- Comprehensive Excel Project Challengeβ’60 minutes
Apply and integrate all visualization techniques learned throughout the course in a comprehensive capstone project focused on sustainable energy analytics. Through hands-on work with GreenWave Energy Solutions' data, you'll create an end-to-end dashboard solution that demonstrates mastery of data preparation, advanced calculations, interactive visualization, and storytelling. You'll develop a complete visualization strategy that incorporates AI-enhanced features while optimizing for performance and user experience. This capstone project mirrors real-world scenarios, challenging you to transform complex energy operations data into actionable insights that drive strategic business decisions.
What's included
1 video3 readings1 assignment1 ungraded lab
1 videoβ’Total 2 minutes
- The Future of Data Visualizationβ’2 minutes
3 readingsβ’Total 90 minutes
- Introducing Your Capstone Project Dataset β’30 minutes
- Capstone Project Overviewβ’30 minutes
- Course Wrap-Up β’30 minutes
1 assignmentβ’Total 30 minutes
- Graded Assessment: End-of-Course Data Visualization Masteryβ’30 minutes
1 ungraded labβ’Total 60 minutes
- Data Visualization Capstone Lab β’60 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Offered by
Explore more from Data Analysis
- Status: Free TrialU
University of Colorado Boulder
Specialization
- Status: PreviewL
LearnKartS
Course
- Status: Free TrialU
University of Pennsylvania
Course
- Status: PreviewB
Board Infinity
Course
Why people choose Coursera for their career
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
More questions
Financial aid available,
ΒΉ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.
