Data Analysis BootCamp: Excel, Power BI, Tableau: 3 in 1

Learn how to download, install, and access Microsoft 365 and Excel, compare family and individual plans, and use Google Sheets as a free alternative.

Master the basics of Microsoft Excel by creating and renaming workbooks and sheets, locating cells like A1, and using the Home tab for formatting and tables.

Explore flash fill and text to column to split names and numbers, learn delimited and fixed-width options, and master quick copy, delete, and merge workflows in Excel.

Explore data validation in Excel by setting date restrictions, formatting numbers and currencies, and using lists to limit inputs like cash, UPI, or card payments.

Master sorting data in tables, using smallest-to-largest and largest-to-smallest options, and apply filters to manage visibility. Learn conditional formatting, top/bottom rules, and custom sorts by cell color.

Apply data filtering to show records matching criteria such as greater than 20 or between 20 and 30, and distinguish filtering from sorting with date and currency data types.

learn how to remove duplicate values in Excel by selecting the data or a specific column, using the remove duplicates tool to create unique values in data analysis bootcamp.

Learn how to handle null values in Excel by filling blanks with series, forward and backward methods, and options like mean, median, and mode.

Discover how white spaces affect text length and use the trim function to clean data, then learn to insert columns and preserve formulas with paste values.

Master essential Excel text functions for data analytics, including trim, length, left, right, mid, upper, lower, proper, and concat, find, substitute, and replace.

Learn to apply if conditions, and, or, and not logic, including end conditions, to Excel formulas for pass/fail, filtering by marks and cs background.

Explore essential time functions in Excel, such as today, now, day, month, year, text, date, and edate, and learn to compute working days with network days, holidays, and weekend rules.

Explore maths and logical functions in Excel, including sum, sum ifs, count, count ifs, average, and count blank, with practical examples using salary and age data.

Master Power Query Editor to upload, transform, and clean data, then load it into Excel, using examples like removing rows, deleting columns, and using the first row as header.

learn how to upload a folder of csv data, extract and transform into named queries (customers data, products data, orders, payments, employees, offices) in Power BI/Excel.

Learn to clean data in Power Query Editor by removing unused fields, handling null values, converting data types, and loading the result into Excel.

Power Query editor empowers you to create custom columns, multiply quantity by price to compute total bill, and determine product margins using MSRP and buy price.

Create a conditional column in Power Query Editor to categorize order quantities as low, medium, or high using add clause and filters.

Merge queries across Excel files to bring common columns, such as product code, into order details. Calculate total buy price, total MSRP, discount amount, and discount percentage using merged data.

Explore data modeling and private tables by connecting customers, products, and sales through a common column, then create private and pivot tables to extract and share data in Excel.

Learn to build a location hierarchy in data models by creating a location type, adding city, country, and state, and applying it to automatically organize customer data.

Create charts from pivot tables by selecting appropriate chart types, such as line for date/time and pie for percentages. Customize titles, axes, colors, and data labels to clearly visualize data.

Power BI is a software that stores, cleans, and presents data with charts and tables. It pulls data from Excel, SQL, websites, and Google Analytics.

Learn data analytics basics for beginners, including storing, cleaning, and presenting data. Access a free, two-hour introductory course on data analytics with Excel to ease learning Power BI.

Explore how to access and use ZGPT, an AI chatbot, to assist with Power BI tasks, learn concepts, and solve issues by interactive prompts and screenshot-based explanations.

Learn how to upload and load data into Power BI from Excel, CSV, and other sources, then clean and transform data.

Learn how to create and use pivot tables to reveal patterns in data, summarize profit by region, and support chart creation in Power BI.

Create pivot tables, then generate charts in Power BI, using pie and bar charts to visualize the profit in the data, and save changes as you present the results.

Learn to import data from folders in Power BI, merge transactions with Power Query Editor, and create queries for regions, customers, stores, products, and calendar.

Explore the difference between transform and add column in Power Query Editor, merging fields, creating new columns, and deriving ages from birth dates with date formatting.

create a Power Query custom column to compute total people at home: if marital_status = 'm' then 2 plus children at home else 1 plus children at home.

Master the basics of DAX for data analysis in Excel and Power BI as part of a 3 in 1 bootcamp covering Excel, Power BI, and Tableau.

Learn to create and interpret Power BI charts such as line, area, ribbon, waterfall, funnel, scatter, and pie charts to analyze revenue, profit, quantity, and interactivity with slicers.

Explore unique charts in Power BI, including total profit cards, KPI measures, gauge targets, and decomposition trees. Learn practical formatting, customization, and interactive button navigation for storytelling.

Learn how Tableau helps you transform business data into insights by focusing on analytics, using data provided by the business (e.g., from Google Analytics) to understand trends and inform decisions.

Learn how to download and install Tableau Public on Windows or Mac, create a free account with activation, and understand the two versions—Tableau Public (free) and Tableau Desktop (paid).

Learn to analyze data with Tableau by creating pivot tables and turning them into bar charts, while mastering data cleaning with Excel basics and Power Query.

Learn to integrate Tableau with AI tools like shared GPT to find duplicates and errors, and receive recommendations and feedback.

download the superstore sales full data set for the Tableau project from CocoaCourses via the library or OneDrive links, unzip the downloaded file, and prepare the data for Tableau.

Learn to connect and import data into Tableau from Excel and sources such as text, JSON, PDF, and OData, using the sample superstore file, and explore data interpreter.

Explore pivot table components—rows, columns, values, and filters—and learn how regions become dimensions and sales become metrics, with drag-and-drop construction in Tableau.

Master filters and sorting in Tableau to view targeted data, using region and date filters and profit sorting in ascending or descending order, with ChatGPT as a learning aid.

Use ChatGPT to extract insights from data by uploading screenshots, identify top and bottom regions by profit, and create private tables with dimensions and metrics.

Convert pivot tables into visuals in Tableau to extract insights from regional profit data, exploring bar and pie charts alongside horizontal or vertical formats with built-in formatting options.

Learn to import data from multiple sources, including csv, text files, and excel, into a single data model using Tableau, with guidance on using ChatGPT and saving the combined file.

Develop calculation basics for data analysis in a 3-in-1 bootcamp, exploring essential concepts that underpin analysis workflows across Excel, Power BI, and Tableau.

Create a Tableau dashboard by adding sheets and arranging charts with tiles. Use floating and tileset layouts, stories, and present mode to share dashboards with clients.

Advance your data analysis skills across Excel, Power BI, and Tableau by tackling project task part two, applying practical workflows and integrated analytics.

Explore tableau chart types including text table, heat maps, highlight tables, symbol map, and maps, and learn when to use bar chart, stack chart, and scatterplot for data visualization.

Learn how to group data in Tableau by combining sales and profit into high profit categories, create region and customer groups, and rename groups for analysis.

Create sets and concepts in tableau using groups and subsets on conditions. Master outer, inner, left, right operations and combine sets to analyze high profit, high sales, and losses.

Learn how to create bins to define ranges in Tableau and build histograms by grouping data into consecutive gaps, using calculated fields and numerical measures.

Explore how parameters make dashboards dynamic by creating a top sales parameter, setting min, max, and step, and linking it to product and sales charts to auto-update results.