Data Analytics Bootcamp : Excel, Google Sheets And Tableau

Learn how a spreadsheet organizes data, from cells, rows, and columns to workbooks, and explore the Excel and Google Sheets interface, including the menu bar, tab bar, and share button.

Learn how to input data, select and copy and paste across cells, and use autocomplete to extend patterns, while understanding absolute versus relative references, and creating formulas in Excel spreadsheets.

Format your data and tables to save time and look professional. Learn fonts, alignment, wrapping, currency and date formats, absolute referencing, and combining names for clean analytics.

Format your data tables using alternating colors, borders, and grid lines; apply headers, merge cells, adjust fonts and colors, add checkboxes, and freeze rows for clearer spreadsheets.

Master conditional formatting in Excel and Google Sheets by applying range-based rules, colors, and thresholds to highlight key values, and integrate with formulas for data analysis.

Explore Excel basics, from navigating the interface and templates to formatting data, wrapping text, and conditional formatting, with hands-on workbook operations and pivot tables.

Analyze data with insights, filter and sort with a slicer and a dropdown list, apply formulas to combine and extract data, and learn data validation and data cleaning in Excel.

Master filtering and sorting in Excel to organize data, explore built-in insights like averages and histograms, and apply slicers for multi-criteria filtering.

Master data validation to create dropdown lists and prevent invalid input, then apply core formulas and functions, including sum, count, min, max, today, and absolute and relative references.

Learn to combine names with concatenate, insert spaces, and extract first, middle, and last names with left, right, and mid, plus text to column and find and replace techniques.

Learn to use the if function in Excel to categorize salary as high paid or low paid using a logical test, handle errors with iferror, and enable data validation.

Learn to use vlookup to merge data across sheets and clean datasets. See how to pull division values into a second sheet without manual entry.

Learn to format, sort, filter, and validate data in Excel, and create checkboxes and dropdown lists, then build dashboards with slicers and dynamic charts.

Learn essential Excel techniques for data analysis, including formatting, data validation, filtering, multi-sheet workbooks, and macros, and explore dashboards and data extraction to streamline analytics.

Create powerful pivot tables in Excel to organize sales data by product, year, and country, analyze profit, and visualize grand totals with filters and percentage calculations.

Learn to create and customize bar, line, and map visualizations from pivot tables, selecting data ranges and chart types; build a dynamic dashboard with slicers.

Master creating pivot tables and charts in Excel, including drag-and-drop fields, slicers, and dynamic vs static charts. Explore chart formatting, 3D maps, geographic charts, and dashboards.

Learn to build dynamic Excel dashboards by blueprinting data needs, designing a layout with a header, charts, and slicers, and linking sheets to reveal key sales insights.

Learn to automate repetitive data tasks with macros in Excel and Google Sheets, recording steps, running macros via shortcuts or buttons, and understanding relative and absolute references for reliable automation.

Celebrate completing part 1 of the data analytics bootcamp. Preview rate analysis, data preparation, auditing, cleaning, and visualization to build an amazing dashboard on a real project.

Explore the data analysis mindset, learn how to gather information with stakeholder input, define the dashboard purpose and user needs, and blueprint visualizations to improve decision making.

Explore dashboards as a tool to facilitate decision making and communicate data, and learn about analytical, operational, and strategic dashboard types driven by historical data for stakeholders.

Explore how to define a business problem and blueprint dashboards for data analytics, choosing visualizations like distributions, compositions, and relationships to support exploratory data analysis.

Download Tableau to begin exploring data visualizations, including Excel’s bar graphs, tables, and charts, and using Google Sheets for data sources. Discover Tableau basics, connections, upgrades, and a supportive community.

Load and prepare data in Tableau by importing Excel and text files, exploring data source panels, using data interpreter options, and mastering unions and joins for dashboards.

Combine data in Tableau by using unions to stack tables and joins to merge on common columns, exploring inner, left, right, and full outer joins with data preview.

Learn practical data cleaning: work with data sources, use union and left joins, hide columns, fix data types, convert price strings to numbers, and create calculated fields.

Master data preparation in spreadsheets by creating calculated fields, extracting years with regular expressions, converting to date formats, and applying conditional logic for pricing classifications.

Create your first visualizations in Tableau by building maps, bar charts, and tables using dimensions and measures, apply filters, and explore discrete versus continuous data.

Create your first map visualization by plotting countries and comparing their average wine prices, then customize marks and charts, and explore filters to deepen geographic insights.

Create territories in Tableau maps to visualize regional performance. Join country data to world type and convert to country geographical role for new world vs old world insights.

Master the marks card: colour by discrete and continuous data, adjust size and shape, apply labels and tooltips, and connect sheets for dynamic visualizations.

Learn to create and apply filters in Tableau, exclude or include values, edit filter settings, and show top N counts for discrete data, guiding data visualization from dimensions to maps.

Apply data cleaning and preparation to drive visualizations in tableau, create a final dashboard, and build tree maps and hollow pie charts using filters and labeled data.

Learn to create a hollow pie chart by building a pie, then carve a white center using a calculated field and dual axis. Show labels and adjust size for clarity.

Create a heat table in tableau to reveal the relationship between ship mode and subcategory, using profit as the value and adding labels for clarity.

Create a city-level map with drill-downs by subcategory to compare average profit and sales, using calculated fields, color coding, and tooltips to reveal profitable and loss making areas.

Create an interactive dashboard by preparing data, identifying top profit and sales cities, and building the layout with tile, horizontal, and text panels while configuring filters and device previews.

Create an analytical dashboard by designing dashboard layouts, formatting sheets, and assembling charts such as donut charts, with a map and drill-down panels.

Learn to make dashboards in Tableau dynamic and interactive by applying filters, context filtering, and parameters, and by configuring a map, tree map, and bar charts.

Explore Tableau's story feature to combine dashboards and show a timeline of performance, while learning to refresh data, group categories, and share or download dashboards via shareable links.

Celebrate your hard work and confidently showcase your data analytics skills in Excel, Google Sheets, and Tableau as you finish the bootcamp—then leave a five-star review.