![Easy Learning with [3-in-1] Data Viz Bundle: Tableau, Excel & Looker Studio](https://img-c.udemycdn.com/course/750x422/5254946_d374_3.jpg)
Business > Business Analytics & Intelligence
18 h
£19.99 Free for 0 days
Master Data Visualization: Tableau, Excel, & Looker Studio
What you will learn:
- Master Tableau, Excel, and Looker Studio for data visualization.
- Connect and integrate data from diverse sources.
- Compare Tableau, Excel, and Looker Studio's features and use cases.
- Combine data using joins and blends in all three tools.
- Create and customize charts, graphs, and maps.
- Share and publish dashboards and visualizations effectively.
- Apply data visualization best practices for impactful storytelling.
Description
Transform raw data into compelling visuals! This comprehensive course teaches you the power of data visualization using three industry-leading tools: Tableau, Microsoft Excel, and Google Looker Studio. Learn to connect, clean, and transform data, then create impactful dashboards, charts, and maps for any audience.
Unlike other courses, this 3-in-1 bundle provides a thorough comparison of these platforms, empowering you to select the best tool for each specific task. You'll master essential techniques, including data blending, calculated fields, and advanced filtering, creating interactive visualizations that communicate insights effectively.
We’ll cover various chart types – from bar and line graphs to heatmaps and geographic visualizations – across all three platforms. Through hands-on projects and quizzes, you'll gain practical experience, building a portfolio showcasing your newly acquired skills. Our expert instructors guide you every step of the way, ensuring you understand the nuances of each tool and how to leverage their strengths.
Whether you're a business professional, data analyst, or aspiring data scientist, this course provides the expertise you need to excel in today’s data-driven world. Improve your career prospects, boost your analytical skills, and confidently communicate data-driven insights. Enroll today and unlock your data visualization potential!
Curriculum
Introduction
This introductory section sets the stage, explaining the course's structure, resources, and the reasons for focusing on Tableau, Excel, and Looker Studio. Lectures cover the advantages of data visualization and an overview of each platform's features and capabilities, preparing you for the in-depth learning ahead. A short quiz assesses your initial understanding.
Installation and Getting Started
This section guides you through installing Tableau Desktop and Public, introducing the datasets you’ll use. You'll learn how to connect to various data sources, understanding the difference between live connections and data extracts, with quizzes to ensure you can execute these steps confidently.
Data Modeling & Combining Data Sources
Master data modeling techniques by combining data from multiple tables using Tableau's relationship and join functionalities. Learn about different join types (inner, left, right, full outer), union operations, and the importance of physical and logical data layers. Understand the Tableau sheet and prepare your data for visualization using a concluding quiz to reinforce your knowledge.
Data Categorization in Tableau
This section delves into the crucial aspect of data categorization in Tableau. You'll learn to distinguish between dimensions and measures, discreet and continuous data types, and efficiently change data types within Tableau. Practical exercises and quizzes will solidify your understanding of these essential concepts.
Essential Chart Types in Tableau
This section focuses on creating core chart types: bar, line, and scatter plots. You will learn to construct these charts effectively and interpret the results they represent. The information gained here will act as a foundation for more complex visualizations.
Customizing Charts using the Marks Shelf
This section demonstrates how to effectively customize Tableau charts using the marks shelf. Learn how to manipulate dimensions and measures to improve chart readability and convey data more effectively. You'll see how to apply these techniques to various chart types, such as line charts and scatter plots.
Advanced Chart Creation in Tableau
Explore a wider range of chart types, including text tables, heatmaps, pie charts, area charts, treemaps, and dual combination charts. You'll learn how to create custom hierarchies and understand the creation and application of bins and histograms. A quiz will test your comprehension of these techniques.
Data Grouping & Filtering in Tableau
Learn effective data manipulation techniques. You will master filtering data using different filter types (dimension, measure, date-time), exploring various filter options and their order of operation. You'll also learn to customize visual filters, implement sorting options, and understand how these functionalities work together.
Creating Maps in Tableau
This section focuses on creating geographic visualizations in Tableau. You'll learn about map chart creation, considerations, customizations, using map layers, visual toolbars, background images, and territories. Learn how to handle missing geocoding using data blending, followed by a comprehensive quiz.
Calculations & Analytics in Tableau
This section introduces calculated fields, functions, and table calculations in Tableau. You’ll grasp the fundamentals of Level of Detail (LOD) expressions and their practical application using detailed examples. The section also covers the use of the analytics pane.
Sets and Parameters in Tableau
Learn to leverage Sets and Parameters for more dynamic and interactive dashboards. Understand how to create and utilize sets effectively and build parameters to enhance data manipulation and analysis. A quiz assesses your understanding of these advanced techniques.
Dashboard and Story Creation in Tableau
This section guides you through creating effective dashboards and interactive stories to present your data visualizations. Learn how to effectively arrange elements and use the story feature for a dynamic presentation of your insights, concluded by a quiz.
Saving & Sharing Your Tableau Work
Learn best practices for saving and sharing your Tableau workbooks, data sources, views, and dashboards. Ensure your work is accessible and easy to share with others.
Tableau Appendix
This section covers additional topics, including connecting to SQL databases and cloud storage services, providing supplemental resources and practical tasks to further hone your skills. A quiz tests your overall understanding.
Excel Charts: Foundations
This section introduces the world of Excel charting. Learn why charts are essential for conveying data, understanding different chart categories, essential chart elements, and the simple methods for creating charts within Excel.
Excel Charts: Advanced Techniques
Delve into advanced chart creation and best practices in Excel. You’ll master the creation and formatting of bar, column, line, area, pie, doughnut, scatter, histogram, waterfall, and combination charts. Learn best practices for effective chart design, avoiding common pitfalls, and enhancing your visualizations.
Excel Pivot Charts
Learn how to utilize Pivot Tables and Pivot Charts in Excel for powerful data summarization and analysis.
Excel Data Analysis (Microsoft 365)
For Microsoft 365 users, explore the powerful 'Analyze Data' feature to enhance your Excel data analysis workflow.
Less Common Excel Charts
Explore less frequently used but still valuable Excel charts such as stock charts, radar charts, surface charts, and heatmaps. A quiz follows to ensure you’ve grasped the key concepts.
Excel Sparklines
Learn to use Sparklines for compact data visualizations within your spreadsheets.
Infographics with Excel
Learn to transform your data into eye-catching infographics using Excel's charting capabilities. Two examples of creative infographics are presented, followed by a quiz.
Excel Map Charts
Discover how to create Map charts in Excel 2019 and later versions, accompanied by practical tasks to reinforce your learning.
Looker Studio: Introduction
This section introduces Looker Studio, explaining its advantages and use cases for data visualization.
Looker Studio: Core Concepts
Learn essential Looker Studio terminologies and theoretical concepts, understanding the distinctions between datasets, data sources, dimensions, and measures within the platform.
Looker Studio: Practical Application
Begin your practical journey with Looker Studio. Learn to connect to data sources, specifically Google Sheets, and effectively manage your data connections.
Looker Studio Charts for Numeric Data
Master the creation and styling of data tables and scorecards in Looker Studio for visualizing key performance indicators (KPIs) and other numeric data.
Looker Studio: Charts for Comparisons
Learn to create effective bar and stacked column charts for comparing categories of data.
Looker Studio: Geographic Visualizations
Learn how to create engaging geomaps using Looker Studio to visualize data across geographical areas.
Looker Studio: Time-Series Analysis
Master the art of time series, line, and combo charts to effectively highlight trends and patterns over time in Looker Studio.
Looker Studio: Charts for Proportions
Learn to create pie charts, donut charts, and stacked area charts to illustrate contributions to a whole.
Looker Studio: Relationship Visualizations
Create scatter plots and bubble charts to visualize the relationship between multiple variables.
Looker Studio: Cross-Tabulations
Use pivot tables for effective data cross-tabulation in Looker Studio.
Looker Studio: Bullet Charts
Learn to create bullet charts for a concise visualization of a single metric.
Looker Studio: Hierarchical Visualizations
Utilize treemaps to visually represent hierarchical data.
Looker Studio: Branding & Customization
Brand your reports with logos and company colors for a professional presentation.
Looker Studio: Interactive Filters
Empower viewers to interact with data by adding filter controls.
Looker Studio: Adding External Content
Incorporate external content, such as videos and feedback forms, using URL embedding.
Looker Studio: Data Blending
Learn how to blend data from multiple tables using different join types.
Looker Studio: Sharing & Collaboration
Master the techniques of sharing, downloading, and collaborating on your Looker Studio reports.
Looker Studio: Best Practices
Reinforce your understanding of data visualization best practices in Looker Studio to create effective and clear visuals.
Course Completion & Certification
This final section summarizes the course and provides information about your certificate of completion.
Deal Source: real.discount