Data Analytics Certification
- Format
- Live or Self-paced
Choose how you learn
Compare formats, then explore the details for your choice.
Book directly on nobledesktop.com. Opens in a new tab.
Book live on Noble DesktopSummary
Master the essential tools of data analytics with hands-on training in Excel, SQL, Tableau, and Power BI. Develop the skills to write SQL queries, design dynamic Power BI reports, and create insightful Tableau visualizations before taking the official exams in each subject. Students may also choose to replace the exams with an additional hour of private tutoring. This course is designed to help you pass these exams and includes:
- Microsoft Excel Expert Exam with a free retake.
- Microsoft Power BI Data Analyst Exam with a free retake.
- Tableau Certified Data Analyst Exam with a free retake.
- Oracle Database SQL Certified Associate Exam with a free retake.
Curriculum
What you'll learn
- Excel for Data Analytics: Use advanced Excel functions, PivotTables, and charts to analyze data efficiently and create clear visual reports for business insights.
- SQL Bootcamp: Write and optimize SQL queries, join and filter data across multiple tables, and manage complex databases using PostgreSQL and DBeaver.
- Tableau Bootcamp: Build interactive dashboards and compelling data visualizations with Tableau, applying advanced formatting and storytelling techniques.
- Power BI Bootcamp: Connect and transform data from multiple sources, use DAX for calculated fields, and publish professional reports through Power BI Service.
- Exam Preparation: Prepare for four industry certifications, Excel Expert, Power BI Data Analyst, Tableau Certified Data Analyst, and the Oracle SQL Associate.
Course outline
-
Excel Level I: Fundamentals 6 hours
Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.
- Get comfortable with the Excel interface and learn multiple ways to enter and organize data in a worksheet.
- Work with rows, columns, and worksheets by inserting, deleting, hiding, grouping, and managing spreadsheet elements.
- Build foundational Excel skills with Autofill, basic calculations, AutoSum, and essential functions such as SUM, AVERAGE, MAX, MIN, and COUNT.
- Use formulas more effectively with absolute references, logical true/false tests, text functions, and multi-input functions.
- Format spreadsheets for clarity with cell formatting and conditional formatting that highlights data based on specific rules.
- Create visual reports with column charts, line charts, pie charts, sparklines, and Excel Tables.
- Manage workbooks more efficiently using Freeze Panes, printing tools, display options, templates, and essential keyboard shortcuts and Excel tips.
- Reinforce key concepts through end-of-class projects designed to review what you learned.
-
Excel Level II: Intermediate 6 hours
Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.
- Navigate worksheets more efficiently using keyboard shortcuts and Excel tools that speed up movement within and between cells.
- Work with formulas and text by reviewing calculation methods, splitting text with Text to Columns, and joining text with CONCAT and the ampersand.
- Manage cell ranges with Paste Special, Paste Special Values, and named ranges to format data, hardcode results, and simplify references in calculations.
- Use database tools such as VLOOKUP, XLOOKUP, Sort & Filter, and Remove Duplicates to find, organize, and clean large sets of data.
- Build PivotTables to summarize large databases, group data within PivotTables, and create multiple PivotTables on a single worksheet.
- Apply logical, math, and statistical functions including IF, AND, OR, SUBTOTAL, SUMIFS, and COUNTIFS to analyze data based on conditions and filtered results.
- Improve data quality with Data Validation and reinforce key course concepts by completing an end-of-class project.
-
Excel Level III: Advanced 6 hours
Learn advanced Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.
- Use advanced navigation tools, Autofill techniques, Hot Keys, and Go To Special to move through worksheets and work more efficiently.
- Build stronger formulas with mixed references, cell auditing tools, date functions, and custom number formats.
- Create advanced logic with nested IF statements and IF formulas that incorporate AND/OR criteria for more flexible results.
- Perform What-If Analysis with Goal Seek and Data Tables to test variables and evaluate possible outcomes.
- Analyze data with advanced PivotTable tools, including base fields and sets, calculated fields, and Pivot Charts.
- Use XMATCH, INDEX-MATCH, macros, and dynamic arrays to create powerful lookups, automate tasks, and complete an end-of-class project reviewing key concepts.
-
SQL Bootcamp 18 hours
Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You'll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL.
- Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of DBeaver, a popular free database app.
- Write SQL queries to retrieve data from tables in the database
- Combine information from multiple tables using JOIN statements
- Filter data, group it, and sort it to extract the specific information you need
- Master advanced techniques, including subqueries, string functions, and IF‑Else logic with CASE
- Learn how to use views and functions with parameters instead of directly querying tables
-
Tableau Bootcamp 12 hours
Learn how to use Tableau, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. This course will teach you how to connect to datasets, analyze and structure data, customize visualizations, and publish your work.
- Connect to datasets in various formats and clean, filter, and structure the data for visual storytelling
- Create a variety of visualizations, including bar charts, line charts, treemaps, heat maps, and dual-axis charts
- Use Tableau's calculation tools to build custom fields, apply aggregates, and enhance data analysis
- Format charts with labels, tooltips, colors, and axes to improve clarity and visual impact
- Work with geographic data to build interactive map visualizations, including choropleths and proportional-symbol maps
- Customize dashboards and stories for different audiences and devices using Tableau's interactivity tools
- Integrate external map services and use advanced visualization types such as spider maps and alluvial diagrams
- Publish your work to Tableau Cloud and export dashboards for professional sharing and collaboration
-
Power BI Bootcamp 12 hours
Learn how to use Power BI, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. Learn how to connect to datasets, analyze and structure data, customize visualizations, and publish reports.
- Import data from Excel worksheets, CSV, and many more
- Transform/clean your data using Power Query
- Create interactive visualizations, such as charts, maps, cards, and slicers, to explore trends and patterns
- Use DAX (Data Analysis Expressions) to build measures, calculated columns, and custom aggregations
- Design visually engaging reports by adding titles, logos, and formatting options for a professional finish
- Understand and manage relationships between tables to create dynamic, filterable reports
- Share and collaborate on reports via the Power BI Service
- Set up dashboards and explore the differences between dashboards and reports for business presentations
- Schedule data refreshes and manage reusable datasets to keep reports up-to-date and scalable
-
Power BI Advanced 6 hours
This advanced Power BI course focuses on building more reliable data models using proper relationships, filter flow, fiscal and calendar date tables, Row-Level Security, and more.
- Build better data models by understanding relationships, cardinality, and cross-filter direction
- Design reliable data models and avoid common modeling mistakes
- Create and use hierarchies to organize and drill into data
- Control visual order with custom sort columns
- Create reusable date tables supporting fiscal and calendar years
- Add parameters to make reports interactive and flexible
- Implement Row-Level Security (RLS) with Static and Dynamic roles
What's included
- Free course retake within one year to refresh the material and gain practice.
- Class recordings
Stated by the provider. Confirm what your tuition covers before enrolling.
Live classes
Choose dates and book your instructor-led class on nobledesktop.com.
-
–
In-person or live online
Tue, Wed, Thu, Mon, Fri
10:00–17:00 · America/New_York (EDT/EST)
-
–
In-person or live online
Thu, Fri, Mon, Tue, Wed
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Tue, Wed, Thu
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Tue, Wed, Thu, Fri
10:00–17:00 · America/New_York (EST/EDT)
-
–
In-person or live online
Mon, Wed, Thu, Tue
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Mon, Wed, Thu, Tue
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Mon, Wed, Thu, Tue
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Thu, Wed, Fri, Mon
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Mon, Tue, Thu, Wed
10:00–17:00 · America/New_York (EDT/EST)
Confirm current dates and availability on Noble Desktop before booking.
Self-paced course
Learn through recorded lessons on your own schedule.
This program is available for 180 days. You can choose when to start your access period. Once you activate, you will have 180 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
- Tuition
- $2,995
- Course length
- 66 hours
- Schedule
- On your schedule
Build practical data analytics skills at your own pace with hands-on training in Excel, SQL, Tableau, and Power BI. This self-paced course walks you through writing SQL queries, creating interactive Power BI reports, and designing clear, effective Tableau visualizations, allowing you to progress on your own schedule while developing real, job-ready capabilities.
The course is structured to support preparation for industry-recognized exams in each subject, with the flexibility to replace exams with an additional hour of private tutoring if preferred. Exam options include the Microsoft Excel Expert Exam, Microsoft Power BI Data Analyst Exam, Tableau Certified Data Analyst Exam, and Oracle Database SQL Certified Associate Exam, each with a free retake included.
Self-paced curriculum
What you'll learn self-paced
- Excel for Data Analytics: Progress through advanced Excel techniques at your own pace, using functions, PivotTables, and charts to analyze data and create clear, business-ready reports.
- SQL Bootcamp: Learn to write and optimize SQL queries on your own schedule, working with joins, filters, and multi-table datasets while managing databases with PostgreSQL and DBeaver.
- Tableau Bootcamp: Build interactive dashboards and polished data visualizations at a self-directed pace, applying formatting and data storytelling techniques in Tableau.
- Power BI Bootcamp: Work through data connections, transformations, and DAX calculations on your timeline, and create professional reports published through Power BI Service.
- Exam Preparation: Prepare at your own pace for four industry-recognized certifications: Excel Expert, Power BI Data Analyst, Tableau Certified Data Analyst, and Oracle SQL Associate.
Self-paced course outline
-
Excel Level I: Fundamentals Course Online (Self-Paced) 6 hours
Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.
- Become familiar with the interface and data entry
- Learn essential formulas and functions
- Format and print your work
- Create charts, including line, column, and pie charts
- Learn tips and tricks for easy workbook management
- Review key concepts in a final project
-
Excel Level II: Intermediate Course Online (Self-Paced) 6 hours
Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.
- Learn to split and join text, apply data validation, and create named ranges
- Use database functions such as VLOOKUP and HLOOKUP
- Write logical formulas using AND, OR, and IF functions
- Create Pivot Tables to efficiently summarize and analyze large datasets
- Apply statistical functions such as RANK, COUNTIFS, and SUMIFS
- Build advanced combo charts by combining multiple chart types
- Reinforce key concepts through a guided final project
-
Excel Level III: Advanced Course Online (Self-Paced) 6 hours
Learn advanced Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.
- Cell management, including cell locking, auditing, and hot keys
- Special formatting for calculating dates
- Use advanced functions such as nested IF statements
- Learn advanced analytical tools for data consolidation, conditions to exclude data, and pivot charts
- Use advanced database functions including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
- Record macros and relative reference macros for ad hoc reporting
- Create a project that applies key concepts from the class
-
SQL Course Online (Self-Paced) 18 hours
Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You'll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL.
- Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of DBeaver (a popular free database app)
- Write SQL queries to retrieve data from tables in a database
- Combine information from multiple tables with JOIN statements
- Filter data, group it, and sort it to extract the specific info you need
- Learn advanced techniques like subqueries, string functions, and IF‑ELSE logic with CASE
- Learn how to use views and functions with parameters instead of directly querying tables
-
Tableau Course Online (Self-Paced) 12 hours
Learn how to use Tableau, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. This course will teach you how to connect to datasets, analyze and structure data, customize visualizations, and publish your work.
- Connect to datasets in various formats, then clean, filter, and structure the data for effective visual storytelling
- Create a range of visualizations, including bar charts, line charts, treemaps, heat maps, and dual-axis charts
- Use Tableau’s calculation tools to create custom fields, apply aggregates, and deepen your data analysis
- Format charts using labels, tooltips, color, and axis adjustments to improve clarity and impact
- Work with geographic data to create interactive map visualizations such as choropleths and proportional symbol maps
- Customize dashboards and stories for various audiences and screen sizes using Tableau’s interactivity tools
- Integrate external mapping services and explore advanced visualization types like spider maps and alluvial diagrams
- Publish your work to Tableau Cloud and export dashboards for professional sharing and team collaboration
-
Power BI Bootcamp (Self-Paced) 12 hours
Learn how to use Power BI, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. Learn how to connect to datasets, analyze and structure data, customize visualizations, and publish reports.
- Import and clean data from multiple sources, including Excel, CSV, and online databases, using Power Query
- Create interactive visualizations, such as charts, maps, cards, and slicers, to explore trends and patterns
- Use DAX (Data Analysis Expressions) to build measures, calculated columns, and custom aggregations
- Design visually engaging reports by adding titles, logos, and formatting options for a professional finish
- Understand and manage relationships between tables to create dynamic, filterable reports
- Share and collaborate on reports via the Power BI Service, including exporting, commenting, and app integration
- Set up dashboards and explore the differences between dashboards and reports for business presentations
- Schedule data refreshes and manage reusable datasets to keep reports up-to-date and scalable
-
Power BI Advanced (Self-Paced) 6 hours
This advanced Power BI course focuses on building more reliable data models using proper relationships, filter flow, fiscal and calendar date tables, Row-Level Security, and more.
- Build better data models by understanding relationships, cardinality, and cross-filter direction
- Design reliable data models and avoid common modeling mistakes
- Create and use hierarchies to organize and drill into data
- Control visual order with custom sort columns
- Create reusable date tables supporting fiscal and calendar years
- Add parameters to make reports interactive and flexible
- Implement Row-Level Security (RLS) with Static and Dynamic roles
What's included with self-paced
- Self-paced video lessons
Self-paced lessons
Watch free previews and explore the lessons included with enrollment at Noble Desktop.
Excel Level I: Fundamentals Course Online (Self-Paced)
-
Interface
Lesson 1: Introduction
8:26
Explore the Microsoft Excel user interface, including the Quick Access Toolbar, Ribbon tabs and groups, Review tab features, Insert Function button, Zoom slider, Sheet Selector buttons, and the expansive rows and columns.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Rows and Columns
Lesson 1: Introduction
6:02
Insert, delete, hide, and group rows and columns using ribbon commands, right-click menus, keyboard shortcuts, and grouping buttons.
View enrollment options at Noble Desktop -
Autofill
Lesson 2: Formulas
9:07
Use Excel's autofill and flash fill features to efficiently complete patterns and replicate data across cells.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Data Entry
Lesson 2: Formulas
5:13
Learn techniques for efficient data entry, editing, copying, pasting, and cutting in spreadsheets.
View enrollment options at Noble Desktop -
Enrollment required
Calculations
Lesson 2: Formulas
10:16
Learn to perform basic calculations in Excel using formulas, cell references, and functions like AVERAGE while considering the order of operations (PEMDAS).
View enrollment options at Noble Desktop -
Enrollment required
Autosum Functions
Lesson 2: Formulas
9:58
Use Excel's AutoSum functions to quickly calculate Sum, Average, Max, Min, and Count in tables.
View enrollment options at Noble Desktop -
Enrollment required
Text Functions
Lesson 2: Formulas
8:04
Use text functions like PROPER, UPPER, LOWER, and TRIM in Excel to efficiently adjust text casing and remove extra spaces.
View enrollment options at Noble Desktop -
Enrollment required
True False
Lesson 2: Formulas
7:14
Verify statements in Excel as true or false using comparison operators.
View enrollment options at Noble Desktop -
Enrollment required
Absolute Cell References
Lesson 2: Formulas
10:07
Utilize absolute cell references in Excel formulas to fix a specific cell while autofilling calculations, preventing unwanted shifts in cell references.
View enrollment options at Noble Desktop -
Enrollment required
Multi Input Functions
Lesson 2: Formulas
12:37
Learn to use multi-input Excel functions like LEFT, RIGHT, SUMPRODUCT, and ROUND for extracting data, calculating totals, and managing rounding errors efficiently.
View enrollment options at Noble Desktop -
Enrollment required
Formatting
Lesson 3: Formatting
14:04
Explore various Excel formatting tools to enhance cell appearance, including changing colors, fonts, alignment, number formats, and merging cells.
View enrollment options at Noble Desktop -
Enrollment required
Conditional Formatting
Lesson 3: Formatting
9:30
Use conditional formatting to visually highlight and differentiate data based on set criteria within Excel.
View enrollment options at Noble Desktop -
Line Chart
Lesson 4: Charts & Tables
5:34
Create a basic line chart in Excel by selecting a single cell in your data, using the insert tab to choose a line chart, and customizing it with quick layout, color, and style options.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Column Chart
Lesson 4: Charts & Tables
7:53
Create a column chart by selecting data, inserting it from the Insert tab, and customizing elements like axis titles, data labels, and grid lines through the Chart Design tab.
View enrollment options at Noble Desktop -
Enrollment required
Trendlines
Lesson 4: Charts & Tables
3:05
Apply trend lines to charts by selecting the desired type (linear, exponential, linear forecast, or moving average) in the chart design options.
View enrollment options at Noble Desktop -
Enrollment required
Pie Chart
Lesson 4: Charts & Tables
7:27
Create and customize pie charts by selecting data, converting between 2D, 3D, and donut styles, and isolating specific slices for emphasis.
View enrollment options at Noble Desktop -
Enrollment required
Tables
Lesson 4: Charts & Tables
13:52
Learn to create and use Excel tables for efficient data management and analysis.
View enrollment options at Noble Desktop -
Printing
Lesson 5: Workbook Management
10:00
Explore and adjust printing options in Excel by utilizing the Page Layout tab to control margins, orientation, print area, page breaks, print titles, scale to fit, and gridlines, while adding headers and footers through the Insert tab for enhanced page setup and layout management.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Worksheets
Lesson 5: Workbook Management
7:04
Manage Excel worksheets by inserting, deleting, hiding, moving, copying, and renaming them using right-click options or the ribbon menu.
View enrollment options at Noble Desktop -
Enrollment required
Freeze Panes
Lesson 5: Workbook Management
5:03
Freeze panes by selecting the desired row or column below or to the right of where you want the freeze, then choose "Freeze Panes" from the View tab.
View enrollment options at Noble Desktop -
Enrollment required
Excel Tricks
Lesson 5: Workbook Management
9:14
Explore Excel tricks like repeating commands with F4, applying multiple formats using Format Painter, inserting comments and links, and capturing screenshots directly into your spreadsheet.
View enrollment options at Noble Desktop
Excel Level II: Intermediate Course Online (Self-Paced)
-
Enrollment required
Tips and Fundamentals
Lesson 5: Workbook Management
10:24
Review and apply Excel's autosum functions and formula auditing tools to calculate totals, averages, and high scores, detect and fix errors, and ensure correct formula dependencies.
View enrollment options at Noble Desktop -
Navigation
Lesson 1: Worksheet Management
6:58
Navigate and select cells in a spreadsheet using keyboard shortcuts like arrow keys, control, shift, and page up/down for efficient data management.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Paste Special
Lesson 2: Working with Text
8:55
Use paste special in Excel to apply formats, perform calculations, and change data orientation.
View enrollment options at Noble Desktop -
Enrollment required
Paste Special Values
Lesson 2: Working with Text
3:14
Use "paste special values" to copy and paste only the results of formulas as text without including the formulas themselves.
View enrollment options at Noble Desktop -
Enrollment required
Splitting Text
Lesson 2: Working with Text
5:08
Use text-to-columns to split data in a spreadsheet into separate columns based on delimiters like commas or spaces.
View enrollment options at Noble Desktop -
Enrollment required
Joining Text
Lesson 2: Working with Text
5:06
Join text using either the concatenate function or the ampersand method to combine cells with specified separators like spaces or dashes.
View enrollment options at Noble Desktop -
Enrollment required
Named Ranges
Lesson 3: Cell Ranges
3:56
Create named ranges for assets, liabilities, and equity to simplify referencing them in calculations.
View enrollment options at Noble Desktop -
Data Validation
Lesson 4: Database Functions
7:35
Use data validation in Excel to create drop-down lists that restrict cell input to specified numerical or text values, with options to customize error alerts and input messages.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Remove Duplicates
Lesson 4: Database Functions
3:51
Remove duplicates by selecting a cell in the data, going to the Data tab, clicking Remove Duplicates, and confirming the selection.
View enrollment options at Noble Desktop -
Enrollment required
VLOOKUP
Lesson 4: Database Functions
10:06
Use VLOOKUP to find information in a table by specifying a lookup value, table array, column index number, and choose between exact or approximate match.
View enrollment options at Noble Desktop -
Enrollment required
HLOOKUP
Lesson 4: Database Functions
2:58
Use HLOOKUP to find a lookup value horizontally in a row by selecting the row index number instead of the column index number.
View enrollment options at Noble Desktop -
Enrollment required
Sort and Filter
Lesson 4: Database Functions
15:53
Sort and filter data using Excel's home or data tab, create subtotals for grouped data, and practice these skills through specific tasks like multi-level sorting, filtering, and applying subtotals.
View enrollment options at Noble Desktop -
Pivot Tables New
Lesson 5: Pivot Tables
10:00
Create a basic pivot table by converting your data into an Excel table, then use the pivot table options to summarize and filter the data, remembering to refresh for updates.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Pivot Grouping Timelines
Lesson 5: Pivot Tables
5:16
Group and filter pivot table data by time periods using the group and insert timeline features.
View enrollment options at Noble Desktop -
Enrollment required
Multiple Pivot Tables
Lesson 5: Pivot Tables
11:40
Explore pivot tables by inserting fields multiple times, using value field settings for different calculations, employing slicers for easy filtering, and connecting slicers to multiple pivot tables for synchronized filtering.
View enrollment options at Noble Desktop -
If Statements
Lesson 6: Logical Functions
8:30
Explain how to use if statements and if error functions in Excel for logical testing and error handling.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
And Or
Lesson 6: Logical Functions
6:17
Use AND to ensure all criteria are true and OR to check if at least one criterion is true when evaluating conditions.
View enrollment options at Noble Desktop -
COUNTIFS and SUMIFS
Lesson 7: Statistical Functions
9:46
Count and sum data based on conditions using COUNTIFS and SUMIFS functions in Excel, which act as filters for specified criteria across multiple columns.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Combo Charts
Lesson 8: Advanced Charts
5:01
Create a combo chart with a secondary axis for better comparison, and format it by adjusting bar colors, background, border, and adding effects.
View enrollment options at Noble Desktop
Excel Level III: Advanced Course Online (Self-Paced)
-
Advanced Cell Lock
Lesson 1: Cell Management
10:00
Lock cells in Excel by using mixed referencing to maintain specific row or column values when autofilling formulas.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Hot Keys
Lesson 1: Cell Management
7:14
Utilize the Alt key on a PC to access Excel's ribbon commands and create custom keyboard shortcuts for efficient navigation and task execution.
View enrollment options at Noble Desktop -
Enrollment required
Go To Special
Lesson 1: Cell Management
8:51
Use "Go To Special" in Excel to quickly select specific cell types, such as constants, blanks, or visible cells, for efficient data management and editing.
View enrollment options at Noble Desktop -
Date Functions
Lesson 2: Special Formatting
7:29
Calculate future dates, days between dates, workdays, week numbers, and month ends using Excel's DAYS, NETWORKDAYS, WEEKNUM, EOMONTH, and EDATE functions.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adv Conditional Formatting
Lesson 2: Special Formatting
9:35
Apply advanced conditional formatting using formulas to format cells based on criteria in different columns.
View enrollment options at Noble Desktop -
Enrollment required
Nested IFs
Lesson 2: Special Formatting
9:37
Nest multiple if statements to evaluate more conditions and provide different responses based on the evaluated criteria.
View enrollment options at Noble Desktop -
If AND OR
Lesson 3: Advanced Functions
7:43
Combine the IF statement with AND or OR functions to evaluate multiple conditions and return specific results based on whether those conditions are true or false.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Goal Seek
Lesson 4: What If Analysis
4:18
Use Goal Seek in Excel to determine the required growth rate or exam score needed to reach a specific target value by adjusting a related variable.
View enrollment options at Noble Desktop -
Enrollment required
Data Tables
Lesson 4: What If Analysis
7:32
Create data tables in Excel to analyze the impact of different variables on a formula.
View enrollment options at Noble Desktop -
Conditional Sumproduct
Lesson 5: Advanced Analytical Tools
9:48
Use conditional sum product to calculate totals or averages by applying criteria to filter specific data subsets.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Pivot Table Variances
Lesson 5: Advanced Analytical Tools
6:17
Create a pivot table, group data by quarters and years, and use "difference from" and "percentage difference from" calculations to show variances between years.
View enrollment options at Noble Desktop -
Enrollment required
Pivot Calculations
Lesson 5: Advanced Analytical Tools
10:22
Perform calculations within pivot tables using calculated fields and items for efficient data analysis.
View enrollment options at Noble Desktop -
Enrollment required
Pivot Charts
Lesson 5: Advanced Analytical Tools
6:05
Create dynamic graphical representations of pivot table data using pivot charts in Excel.
View enrollment options at Noble Desktop -
Match Function
Lesson 6: Advanced Database Functions
4:25
Find the relative position of a lookup value within a single column or row using the match function.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Vlookup Match
Lesson 6: Advanced Database Functions
8:08
Enhance VLOOKUP accuracy by using the MATCH function to dynamically determine the column index number, allowing for more efficient data retrieval with mixed referencing.
View enrollment options at Noble Desktop -
Enrollment required
Index Match
Lesson 6: Advanced Database Functions
7:02
Combine INDEX and MATCH functions to efficiently locate a value in a row or column, allowing lookups in either direction.
View enrollment options at Noble Desktop -
Enrollment required
Index Double Match
Lesson 6: Advanced Database Functions
7:07
Utilize the Index Double Match function to perform a two-way lookup by identifying both row and column positions for retrieving specific data from a table.
View enrollment options at Noble Desktop -
Enrollment required
Windows
Lesson 6: Advanced Database Functions
6:56
Learn to use keyboard shortcuts and commands in Windows to efficiently navigate and arrange Excel windows for better multitasking.
View enrollment options at Noble Desktop -
Enrollment required
Working Across Sheets
Lesson 6: Advanced Database Functions
4:38
Apply formatting and summarize calculations across multiple sheets by selecting ranges while holding the shift key and using functions like SUM and autofill for common cells.
View enrollment options at Noble Desktop -
Macros
Lesson 7: Introduction to Macros
8:29
Automate Excel tasks by creating and running macros using the developer tab, keyboard shortcuts, buttons, and the quick access toolbar to efficiently repeat actions like entering data.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
MacrosReport
Lesson 7: Introduction to Macros
6:14
Create a macro to automate daily report formatting tasks, reducing a two-minute manual process to under a second.
View enrollment options at Noble Desktop -
Enrollment required
Consolidation
Lesson 8: Dynamic Arrays
5:10
Use the consolidate function to sum values across multiple sheets into a summary worksheet and enable automatic updates when source data changes.
View enrollment options at Noble Desktop
SQL Course Online (Self-Paced)
-
Benefits of Learning SQL
Lesson 1: Setting Up the Work Environment
Download the PDF workbook and class files, and install the free dBeaver Community Edition to practice SQL querying without modifying databases.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Connecting to Our Database
Lesson 1: Setting Up the Work Environment
14:06
Set up a database connection in dBeaver using the provided credentials, test connectivity, and review available tables.
View enrollment options at Noble Desktop -
Getting Started & Your First Query
Lesson 2: Let's Start Learning SQL Code
7:29
Navigate databases in dBeaver by adjusting preferences, exploring schemas, and running practice queries to build familiarity.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Learning the SQL Language
Lesson 2: Let's Start Learning SQL Code
14:10
Review SQL syntax through slides, live demos, and exercises focused on SELECT, FROM, ORDER BY, DISTINCT, execution order, and result limits.
View enrollment options at Noble Desktop -
Enrollment required
Coding Exercise PostgreSQL
Lesson 2: Let's Start Learning SQL Code
18:29
Connect to the correct database environment and complete Exercise 1C by writing and executing SQL queries.
View enrollment options at Noble Desktop -
Enrollment required
Solution PostgreSQL Challenge
Lesson 2: Let's Start Learning SQL Code
15:11
Query users and orders tables to view, filter, sort, and remove duplicate records.
View enrollment options at Noble Desktop -
Data Types and Filtering Results
Lesson 3: Working with Characters & Numbers
4:44
Differentiate database data types to query text and numeric values correctly, applying quotes and comparison logic appropriately.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Coding Exercise Filtering with WHERE
Lesson 3: Working with Characters & Numbers
5:34
Define the active data source to enable code hints when querying product data based on price conditions.
View enrollment options at Noble Desktop -
Enrollment required
Solution Filtering with WHERE
Lesson 3: Working with Characters & Numbers
22:42
Refine queries to filter specific records, sort results, perform calculations, handle data types accurately, and eliminate duplicates.
View enrollment options at Noble Desktop -
Pattern Matching
Lesson 4: Using SQL Wildcards
4:46
Apply wildcard characters such as percent signs and underscores with LIKE and ILIKE to identify data patterns.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Combining Filters and Aliases
Lesson 4: Using SQL Wildcards
4:32
Combine conditions using AND, OR, and NOT, perform calculations, and assign column aliases for clearer result sets.
View enrollment options at Noble Desktop -
Enrollment required
Coding Exercise Like and Wildcards
Lesson 4: Using SQL Wildcards
12:31
Practice filtering records using LIKE, ILIKE, and NOT to control query results precisely.
View enrollment options at Noble Desktop -
Enrollment required
Solution Like and Wildcards
Lesson 4: Using SQL Wildcards
23:49
Explore table structures and ER diagrams to understand relationships and safely query data such as email domains or state-based orders.
View enrollment options at Noble Desktop -
Database Terminology and Primary & Foreign Keys
Lesson 5: Indentifying Rows & Connecting Tables
6:44
Connect related tables by identifying primary and foreign keys to manage relationships and avoid duplication.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Joins Combining Data from Multiple Tables
Lesson 5: Indentifying Rows & Connecting Tables
12:28
Perform inner joins by matching common columns and using table aliases to simplify query syntax.
View enrollment options at Noble Desktop -
Enrollment required
Exercise Inner Join
Lesson 5: Indentifying Rows & Connecting Tables
18:40
Reinforce inner join logic by combining tables, filtering shared data, and presenting unified results.
View enrollment options at Noble Desktop -
Enrollment required
Solution Inner Join
Lesson 5: Indentifying Rows & Connecting Tables
10:36
Join users, orders, and line items to identify high-value purchases and return distinct customer details.
View enrollment options at Noble Desktop -
Inner vs. Outer Joins
Lesson 6: Inner vs. Outer Joins
9:45
Compare inner joins with left, right, and full outer joins to understand how non-matching rows are handled.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Exercise Outer Join and NULL
Lesson 6: Inner vs. Outer Joins
23:37
Open the designated file, review warm-up exercises, and complete challenge problems to reinforce learning.
View enrollment options at Noble Desktop -
Enrollment required
Solution Outer Join and NULL
Lesson 6: Inner vs. Outer Joins
34:12
Analyze database relationships to uncover insights such as unsold products or specific purchasing behaviors, then export results as CSV files.
View enrollment options at Noble Desktop -
Cast
Lesson 7: Changing Data Types
7:07
Convert data types within queries using CAST without altering the underlying database structure.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Aggregate Functions
Lesson 7: Changing Data Types
6:33
Apply aggregate functions to calculate totals, counts, minimums, maximums, and averages for analysis.
View enrollment options at Noble Desktop -
Enrollment required
Exercise Aggregate Function and ROUND
Lesson 7: Changing Data Types
27:56
Manipulate aggregated results using rounding functions and column aliases for readable output.
View enrollment options at Noble Desktop -
Enrollment required
Solution Aggregate Function and ROUND
Lesson 7: Changing Data Types
19:00
Build aggregate queries incrementally, validating intermediate results before final execution.
View enrollment options at Noble Desktop -
Date Functions
Lesson 8: Working with Dates
2:20
Work with date and time functions to retrieve current timestamps, extract components, and convert data types.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Exercise 2.0 Date Functions
Lesson 8: Working with Dates
19:52
Extract, format, filter, and convert date values using date_part, to_char, CAST, and range-based conditions.
View enrollment options at Noble Desktop -
Enrollment required
Solution 2.0 Date Functions
Lesson 8: Working with Dates
17:40
Analyze account creation data to determine user age, creation year, weekend sign-ups, and date-range activity.
View enrollment options at Noble Desktop -
Grouping Data
Lesson 9: Organizing Statistical Results Into Categories
8:18
Group records using GROUP BY to apply aggregate functions across defined categories.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Subqueries
Lesson 10: Subqueries
27:41
Nest subqueries within main queries to process intermediate results before final selection.
View enrollment options at Noble Desktop -
Enrollment required
Solution Subqueries
Lesson 10: Subqueries
24:51
Prefer joins over subqueries when appropriate to improve clarity and performance.
View enrollment options at Noble Desktop -
Enrollment required
Aggregate Window Functions
Lesson 11: Aggregate Window Functions
23:01
Use window functions to add aggregate insights while preserving row-level detail.
View enrollment options at Noble Desktop -
Enrollment required
Solution WIndow Functions
Lesson 11: Aggregate Window Functions
9:34
Apply PARTITION BY within window functions to analyze grouped metrics without collapsing results.
View enrollment options at Noble Desktop -
Enrollment required
Conditionals
Lesson 12: Conditionals
18:26
Create conditional logic with CASE statements to classify, transform, or correct query output.
View enrollment options at Noble Desktop -
Enrollment required
CASE Exercise
Lesson 12: Conditionals
14:36
Categorize data into regions or groups, calculate order counts, and manage joins for broader analysis.
View enrollment options at Noble Desktop -
Enrollment required
Views
Lesson 13: Views
18:50
Save reusable queries as views to simplify access, enhance security, and streamline workflows.
View enrollment options at Noble Desktop -
Enrollment required
Views Solution
Lesson 13: Views
0:46
Summarize and filter user spending patterns using flexible query criteria.
View enrollment options at Noble Desktop -
String Functions
Lesson 14: String Functions
4:34
Manipulate text data with string functions to change case, extract substrings, split values, and evaluate length.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Learning Resources
Lesson 15: Additional Resources
3:24
Reinforce skills through external SQL resources, practice platforms, cheat sheets, and coding challenges.
View enrollment options at Noble Desktop -
Enrollment required
Finding Datasets
Lesson 15: Additional Resources
2:04
Source datasets from Kaggle and convert them into usable databases with guided setup support.
View enrollment options at Noble Desktop -
AI and SQL
Lesson 16: AI and SQL
11:06
Use AI tools such as ChatGPT to explain, refine, and generate SQL queries while validating results independently.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Challenge AI and SQL
Lesson 16: AI and SQL
5:13
Generate SQL queries from database visuals using tools like Chat2BT, specifying structure and dialect requirements.
View enrollment options at Noble Desktop -
Enrollment required
Solution AI and SQL
Lesson 16: AI and SQL
14:13
Apply best practices for using AI-generated SQL by providing clear requirements, verifying accuracy, and learning from explanations.
View enrollment options at Noble Desktop
Tableau Course Online (Self-Paced)
-
Requirements & Getting Started
Lesson 1: Getting Started With Tableau
9:58
Download and extract the class zip folder, install Tableau Public, and access the provided datasets, images, and presentations to follow along with day one of the Tableau training.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Introduction to Tableau
Lesson 1: Getting Started With Tableau
8:26
Demonstrate how to access, sign into, and use both the Tableau Desktop and Tableau Public online versions to create and manage visualizations.
View enrollment options at Noble Desktop -
Enrollment required
Understanding Data
Lesson 1: Getting Started With Tableau
14:47
Learn key data concepts, explore chart types and visualization principles, understand Tableau features and dashboards, distinguish data types, evaluate data sources, and practice using vetted datasets for effective visual analysis.
View enrollment options at Noble Desktop -
Enrollment required
Foundations for Building Data Visualizations
Lesson 1: Getting Started With Tableau
6:13
Understand key skills for effective Tableau visualizations—statistics, storytelling, graphic design—and align data, questions, and visuals while using appropriate Tableau tools based on privacy and functionality needs.
View enrollment options at Noble Desktop -
Enrollment required
Tableau Versions
Lesson 1: Getting Started With Tableau
7:06
Understand Tableau’s user roles—Creators build content, Explorers analyze it, Viewers interact with it—while noting pricing, feature differences between Tableau Desktop and Public, and comparisons to Power BI in workflow and accessibility.
View enrollment options at Noble Desktop -
Enrollment required
Workflow & Chart Types
Lesson 1: Getting Started With Tableau
4:57
Follow the Tableau workflow by connecting data sources, formatting data, creating and editing visualizations in worksheets, building dashboards, and publishing results, while understanding chart types, and distinguishing dimensions (qualitative) from measures (quantitative).
View enrollment options at Noble Desktop -
Working with your Data
Lesson 1: Getting Started With Tableau
7:52
Connect and structure clean, well-formatted data (like Superstore Sales) in Tableau Public, avoiding unstructured or mislabeled datasets that require correction with limited tools like Data Interpreter.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Creating your First Visualization
Lesson 1: Getting Started With Tableau
6:14
Connect to your data by dragging and dropping the file into Tableau to quickly establish a connection without modifying the original data.
View enrollment options at Noble Desktop -
Enrollment required
Previewing your Data in the Source Menu
Lesson 1: Getting Started With Tableau
9:25
Connect and preview your data in Tableau by importing the main Orders table first, then add People and Returns to build relationships based on matching fields, verify data types, hide unnecessary fields, and ensure dimensions and measures are correctly identified by color.
View enrollment options at Noble Desktop -
Enrollment required
Quickly Creating a Visualization
Lesson 2: Creating Visualizations
8:44
Create a quick category-region report in Tableau using drag-and-drop fields, apply color scales for sales, quantity, and profit, adjust view to entire sheet, and add text labels with one click.
View enrollment options at Noble Desktop -
Enrollment required
Data Visualization Basics
Lesson 2: Creating Visualizations
10:29
Learn how to simplify complex data using visual tools like charts, colors, and sorting to make insights easy to understand at a glance.
View enrollment options at Noble Desktop -
Enrollment required
The Tableau Interface
Lesson 2: Creating Visualizations
16:35
Explore the Tableau interface by navigating the data source area, data sidebar, marks card, shelves, view pane, and menu options to build, format, and manage visualizations.
View enrollment options at Noble Desktop -
Enrollment required
Creating a Pie Chart
Lesson 2: Creating Visualizations
13:33
Create a pie chart using the Show Me panel by selecting one dimension (e.g., Person) and one measure (e.g., Sales), then customize it using the Marks card to add labels, percentages, adjust size and layout, and format text and colors as needed.
View enrollment options at Noble Desktop -
Enrollment required
Creating a Bar or Column Chart
Lesson 2: Creating Visualizations
10:32
Create bar or column charts by dragging dimensions (e.g., Subcategory) to Rows and measures (e.g., Sales) to Columns, adjust formatting using right-click or dropdown options, apply labels with the T button, set default currency formatting via Default Properties, and customize chart appearance through Format options including shading, borders, and axis scaling.
View enrollment options at Noble Desktop -
Swap Rows and Columns
Lesson 2: Creating Visualizations
3:59
Swap rows and columns using the swap button, drag fields to rearrange positions, sort data alphabetically or by field values, reset to original data source order, and adjust view using the fit menu options.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adding a Sub Category
Lesson 2: Creating Visualizations
5:54
Add dimensions like subcategory and product to your chart to display hierarchical data and explore levels of detail, using the "Describe" option to assess member counts for practicality.
View enrollment options at Noble Desktop -
Enrollment required
Sorting and Saving
Lesson 2: Creating Visualizations
3:07
Summarize sorting options, explain saving methods including Save and Save As with TWB and TWX formats, clarify that Ctrl-S publishes to Tableau Public, and outline how to rename or hide sheet titles.
View enrollment options at Noble Desktop -
Organizing the Data Sidebar
Lesson 3: Organizing Data
6:53
Create hierarchies in Tableau by grouping related fields (like country, state, city, zip) to organize the sidebar and simplify visualizations.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Sets
Lesson 3: Organizing Data
15:39
Create a set to filter subcategories where total sales are greater than or equal to 100,000, enable "Show Members in Set," and optionally filter by year using a single value list for dynamic reporting across worksheets.
View enrollment options at Noble Desktop -
Enrollment required
Groups
Lesson 3: Organizing Data
14:14
Create manual groupings within a dimension to categorize data (e.g., electrical vs. non-electrical) by selecting and assigning values, similar to organizing breakout rooms.
View enrollment options at Noble Desktop -
Enrollment required
Labels
Lesson 3: Organizing Data
5:50
Adjust labels, tooltips, alignment, and formatting settings to customize data visualization display.
View enrollment options at Noble Desktop -
Enrollment required
Tool Tips
Lesson 3: Organizing Data
12:22
Edit axes to customize scale, tick marks, and labels; modify and reset tooltips to control displayed data and insert other worksheets for detailed hover views.
View enrollment options at Noble Desktop -
Enrollment required
Measures
Lesson 3: Organizing Data
7:29
Change measure aggregations (e.g., sum to average) and chart types (e.g., bar to line) by adjusting settings and using available controls in Tableau.
View enrollment options at Noble Desktop -
Enrollment required
Marks Card
Lesson 3: Organizing Data
5:49
Format sheets, rows, columns, fonts, alignment, shading, borders, and colors using the formatting sidebar or right-click options.
View enrollment options at Noble Desktop -
Tableau Calculations
Lesson 4: Calculations and Dashboards
8:37
Create a calculated field for profit margin by dividing SUM(Profit) by SUM(Sales), then format it as a percentage and add it to the view using label or tooltip as needed.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Pages
Lesson 4: Calculations and Dashboards
8:21
Use the Pages feature in Tableau with "Show History" enabled to overlay and animate year-by-year data changes in a single worksheet.
View enrollment options at Noble Desktop -
Enrollment required
Dashboards Part 1
Lesson 4: Calculations and Dashboards
14:05
Create a responsive Tableau dashboard by selecting "New Dashboard," setting the size to "Automatic," dragging in sheets and objects like text boxes, containers, and images, arranging them using floating or tiled layouts, customizing layout and appearance, and adding navigation buttons to link multiple dashboards for interactive navigation.
View enrollment options at Noble Desktop -
Enrollment required
Dashboards Part 2
Lesson 4: Calculations and Dashboards
8:25
Demonstrate how to create interactive Tableau dashboards with filters, navigation buttons, and publish them to Tableau Public for user interaction.
View enrollment options at Noble Desktop -
Enrollment required
Creating Stories
Lesson 4: Calculations and Dashboards
2:54
Create a story by dragging dashboards or charts onto blank pages, customizing layout with captions or numbers, adjusting size settings, and navigating in presentation mode.
View enrollment options at Noble Desktop -
Data Interpreter
Lesson 5: Data Interpreter
10:00
Use Tableau's Data Interpreter to automatically detect and clean common spreadsheet issues like extra headers, footers, and multiple tables before importing the data.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Life Expectancy Exercise
Lesson 5: Data Interpreter
8:42
Recreate the initial poor visualization in Tableau using the cleaned data, then improve it by applying best practices demonstrated through Excel's Power Query and pivot table features.
View enrollment options at Noble Desktop -
Enrollment required
Life Expectancy Exercise Solution
Lesson 5: Data Interpreter
7:34
Create a filtered area chart in Tableau showing the top 10 countries by life expectancy using summed values to handle missing data and improve visual clarity.
View enrollment options at Noble Desktop -
Creating Multi Chart Worksheets
Lesson 6: Multi-Chart Worksheets
10:00
Create a multi-chart worksheet by dragging multiple measures into the rows or columns shelf, customizing each chart independently using individual marks cards.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Dual Axis & Combo Chart
Lesson 6: Multi-Chart Worksheets
8:50
Create a dual-axis combo chart by placing two measures on Rows, assigning distinct chart types (e.g., bar for Sales, line for Profit), setting each to a non-automatic type, then selecting Dual Axis from the right-side measure’s dropdown, aligning scales with Synchronize Axis, and customizing colors as needed.
View enrollment options at Noble Desktop -
Enrollment required
Creating a Better Line Chart
Lesson 6: Multi-Chart Worksheets
17:50
Create a better line chart by overlaying two synchronized charts—one as a line and one as customizable circles or shapes—using dual axis in Tableau.
View enrollment options at Noble Desktop -
Enrollment required
Creating a Butterfly Chart Part 1
Lesson 6: Multi-Chart Worksheets
8:48
Create a basic butterfly chart by reversing the axis on one bar chart in a side-by-side layout to visualize opposing data categories.
View enrollment options at Noble Desktop -
Enrollment required
Creating a Butterfly Chart Part 2
Lesson 6: Multi-Chart Worksheets
10:58
Duplicate the basic butterfly chart, insert a zero-value calculated field between the two measures to place category labels in the center, change its mark type to text, clean up axes and gridlines, and adjust label formatting for a cleaner intermediate butterfly chart layout.
View enrollment options at Noble Desktop -
Enrollment required
Formatting the Butterfly Chart
Lesson 6: Multi-Chart Worksheets
13:57
Create an advanced butterfly chart with centered subcategory text by duplicating axes, synchronizing scales, layering dual-axis text fields, and adjusting formatting and colors for clarity.
View enrollment options at Noble Desktop -
Creating State Selector
Lesson 7: Parameters and Filtering
10:00
Create a parameter called "state selector" from the State field, set its default value to New York, then connect it to a calculation, filter, or set to enable interactive map navigation.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Creating a Calculated Field
Lesson 7: Parameters and Filtering
15:26
Create a calculated field called "State Focus" that filters data to a selected state or all states using a parameter.
View enrollment options at Noble Desktop -
Enrollment required
Creating a Parameter to Control a Filter
Lesson 7: Parameters and Filtering
11:06
Demonstrate how to create a parameter to dynamically control a top N filter for subcategories in a bar chart, enabling user input to adjust the number of displayed items (e.g., top 5, top 10), which is not possible using basic filters alone.
View enrollment options at Noble Desktop -
Enrollment required
Creating an International Map Part 1
Lesson 7: Parameters and Filtering
12:12
Troubleshoot and clean data in Tableau by fixing date formats, correcting city name misspellings with aliases, and resolving unrecognized international locations to create accurate visualizations.
View enrollment options at Noble Desktop -
Enrollment required
Creating an International Map Part 2
Lesson 7: Parameters and Filtering
8:18
Exclude "MLS" from city filter, create a calculated field for "country" using an IF statement to assign Canadian cities to "Canada" and others to "US", change its data type to geographic role "country", drag it to the detail mark, and verify all locations appear on the map.
View enrollment options at Noble Desktop -
Enrollment required
More Chart Types
Lesson 7: Parameters and Filtering
12:13
Explore various Tableau chart types—including heat maps, density maps, highlight tables, pie and donut charts, stacked bars, scatter plots, histograms, box plots, Gantt charts, bullet graphs, and flow maps—with brief creation steps and usage tips.
View enrollment options at Noble Desktop
Power BI Bootcamp (Self-Paced)
-
Course Overview & Setup
Lesson 1: Getting Started with Power BI
0:55
Introduces the structure of the Power BI course and explains how to use class files, PDFs, and step-by-step guides to build skills progressively.
This preview is temporarily unavailable. Please try again later.
-
Overview of Power BI
Lesson 1: Getting Started with Power BI
10:00
Explains what Power BI is, how it’s used for business intelligence, and how it compares to Excel, including an overview of Desktop, Service, and mobile access.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Installing the Power BI Desktop app
Lesson 1: Getting Started with Power BI
1:14
Walks through installing Power BI Desktop via the Microsoft Store, explaining update cycles and how to launch the application.
View enrollment options at Noble Desktop -
Enrollment required
Create our First Visualization
Lesson 1: Getting Started with Power BI
16:02
Demonstrates importing data and creating basic visuals like tables and column charts while explaining data types and automatic visual suggestions.
View enrollment options at Noble Desktop -
Enrollment required
Publishing and Sharing Reports
Lesson 1: Getting Started with Power BI
10:35
Covers publishing reports to the Power BI Service, including workspaces, sharing options, licensing, and browser-based access.
View enrollment options at Noble Desktop -
Enrollment required
Managing Links to Data Source Files & Refreshing Data
Lesson 1: Getting Started with Power BI
2:15
Explains how Power BI connects to external data sources rather than embedding files and how to manage paths and refresh data.
View enrollment options at Noble Desktop -
Transforming Data
Lesson 2: Transforming Data Using Power Query
10:00
Introduces Power Query for data transformation, including cleaning data, handling missing values, and improving performance through upstream changes.
This preview is temporarily unavailable. Please try again later.
-
Merge Queries
Lesson 2: Transforming Data Using Power Query
10:00
Explains merging tables in Power Query to combine related data and introduces normalized data concepts and lookup tables.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Append Queries
Lesson 2: Transforming Data Using Power Query
8:13
Demonstrates appending queries to combine multiple tables with the same structure into a single dataset.
View enrollment options at Noble Desktop -
Enrollment required
Fill and Transpose
Lesson 2: Transforming Data Using Power Query
5:16
Covers advanced transformations such as fill down and transpose to correct poorly structured data.
View enrollment options at Noble Desktop -
Enrollment required
Unpivot & Merge Columns
Lesson 2: Transforming Data Using Power Query
10:26
Demonstrates unpivoting data, combining date fields, assigning correct data types, and preparing datasets for time-based analysis.
View enrollment options at Noble Desktop -
Enrollment required
Query Dependencies
Lesson 2: Transforming Data Using Power Query
1:43
Explores Query Dependencies to visualize how data sources and transformations connect and to troubleshoot complex models.
View enrollment options at Noble Desktop -
Enrollment required
Getting Data from Multiple Files in a Folder (Appending from Folder)
Lesson 2: Transforming Data Using Power Query
4:59
Demonstrates importing and automatically appending files from a folder to support scalable data updates.
View enrollment options at Noble Desktop -
Relationships
Lesson 3: Building the Adventure Works Report
10:00
Explains creating relationships between fact and dimension tables and introduces star schema modeling.
This preview is temporarily unavailable. Please try again later.
-
Adventure Works Importing Data and Building Relationships
Lesson 3: Building the Adventure Works Report
10:00
Walks through building a relational model using AdventureWorks data and validating automatically detected relationships.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adventure Works Designing and Building the Report
Lesson 3: Building the Adventure Works Report
7:20
Focuses on report design using text boxes, images, alignment tools, and layout best practices for professional presentations.
View enrollment options at Noble Desktop -
Enrollment required
Adventure Works Intro to DAX Adding the Current Date
Lesson 3: Building the Adventure Works Report
7:22
Introduces DAX by creating a simple date measure and explains the difference between measures and calculated columns.
View enrollment options at Noble Desktop -
Enrollment required
Adventure Works DAX Calculated Columns Profit or Loss
Lesson 3: Building the Adventure Works Report
14:04
Demonstrates creating calculated columns with DAX and using relationships and the RELATED function across tables.
View enrollment options at Noble Desktop -
Adventure Works Removing the Default White Background from VIsuals by editing the Theme
Lesson 4: Visuals, Slicers, and More
2:00
Shows how to customize Power BI themes to remove default styling and apply consistent global design changes.
This preview is temporarily unavailable. Please try again later.
-
Adventure Works Adding more visuals
Lesson 4: Visuals, Slicers, and More
3:17
Builds additional visuals to analyze sales by customer attributes while demonstrating interactive filtering.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adventure Works Slicers
Lesson 4: Visuals, Slicers, and More
20:24
Introduces slicers as interactive filters and demonstrates layout improvements and user-friendly labeling.
View enrollment options at Noble Desktop -
Enrollment required
Adventure Works SUM vs SUMX
Lesson 4: Visuals, Slicers, and More
12:01
Explains the difference between SUM and SUMX in DAX and why iterator functions are needed for row-level calculations.
View enrollment options at Noble Desktop -
Enrollment required
Adjusting a Desktop Report for Mobile Devices
Lesson 4: Visuals, Slicers, and More
2:58
Demonstrates optimizing reports for mobile using the mobile layout view and adjusting visuals for smaller screens.
View enrollment options at Noble Desktop -
Global Superstore Import Data, Define Relationships, and Create Visuals
Lesson 5: Building the Global Superstore Report
10:00
Walks through importing and modeling Global Superstore data to reinforce ETL and star schema concepts.
This preview is temporarily unavailable. Please try again later.
-
Global Superstore Intro to Filters
Lesson 5: Building the Global Superstore Report
10:00
Introduces visual-, page-, and report-level filters and explains when filters are preferable to slicers.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore Top N Filter and Filter Across All Pages
Lesson 5: Building the Global Superstore Report
7:00
Demonstrates Top N filters to highlight best- and worst-performing items and explains how ties affect results.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Sales by Country Page
Lesson 5: Building the Global Superstore Report
9:27
Builds a multi-page report analyzing sales by country using slicers and geographic comparisons.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Edit Interactions
Lesson 5: Building the Global Superstore Report
4:16
Explains how to control visual interactions to compare filtered values against unfiltered totals.
View enrollment options at Noble Desktop -
Global Superstore Controlling Filtering with SUM and SUMX
Lesson 6: Diving Deeper into DAX
8:46
Demonstrates using SUM and SUMX to control whether calculations respect or ignore filters.
This preview is temporarily unavailable. Please try again later.
-
Global Superstore CONCATENATEX, COUNT, and COUNTX
Lesson 6: Diving Deeper into DAX
7:42
Introduces CONCATENATEX, COUNT, and COUNTX for advanced aggregations and dynamic titles.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore CALCULATE
Lesson 6: Diving Deeper into DAX
5:03
Explains how CALCULATE applies filters within DAX expressions to create reusable measures.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Matrix Visual with Conditional Formatting Icons and Data Bars
Lesson 6: Diving Deeper into DAX
4:10
Builds a matrix visual with conditional formatting to highlight performance trends at a glance.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Quick Measures
Lesson 6: Diving Deeper into DAX
7:21
Uses Quick Measures to generate common DAX calculations like YTD and YoY while keeping measures organized.
View enrollment options at Noble Desktop -
Global Superstore Maps
Lesson 7: Maps, Drill Down, and Drill Through
6:14
Creates map visuals with Azure Maps and explains data categorization and geographic field requirements.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Global Superstore Drill Down
Lesson 7: Maps, Drill Down, and Drill Through
10:41
Demonstrates drill-down using hierarchies to move between summary and detailed views.
View enrollment options at Noble Desktop -
Enrollment required
Global Superstore Drill Through
Lesson 7: Maps, Drill Down, and Drill Through
6:21
Builds drill-through navigation between report pages while preserving filter context.
View enrollment options at Noble Desktop -
Global Superstore Scheduling Data Refreshes and Getting Data
Lesson 8: Refreshing Data, Dashboards & Databases
Explains local refresh versus scheduled refresh in the Power BI Service using OneDrive and shared models.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Dashboards
Lesson 8: Refreshing Data, Dashboards & Databases
4:02
Explains how Power BI dashboards aggregate pinned visuals while linking back to underlying reports.
View enrollment options at Noble Desktop -
Enrollment required
Connecting to a Database
Lesson 8: Refreshing Data, Dashboards & Databases
4:00
Demonstrates connecting Power BI to databases like SQL Server and compares Import and DirectQuery modes.
View enrollment options at Noble Desktop -
Enrollment required
Course Outro
Lesson 8: Refreshing Data, Dashboards & Databases
0:13
Encourages continued practice to improve efficiency, confidence, and the ability to build original Power BI reports.
View enrollment options at Noble Desktop
Power BI Advanced (Self-Paced)
-
Course Overview & Setup
Lesson 1: Hierarchies and Sorting
1:03
Explore advanced Power BI training focused on data modeling, performance optimization, and data security.
This preview is temporarily unavailable. Please try again later.
-
Hierarchies
Lesson 1: Hierarchies and Sorting
10:00
Understand how to build and use hierarchies in Power BI to organize data into logical levels like category, subcategory, and product.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Custom Sort Order
Lesson 1: Hierarchies and Sorting
8:37
Learn how to implement custom sorting in Power BI using dedicated sort columns to control data order beyond default alphabetical or numerical sorting.
View enrollment options at Noble Desktop -
Understanding Dates, Date Tables, and Fiscal Years
Lesson 2: Date Tables and Fiscal Calendars
10:00
Master date handling in Power BI by creating dedicated date tables that support time intelligence and fiscal calendars.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Date Hierachies, Column Sorting, and Using our Calendar vs Fiscal Years
Lesson 2: Date Tables and Fiscal Calendars
8:06
Create custom date hierarchies and apply proper column sorting to ensure accurate time-based reporting.
View enrollment options at Noble Desktop -
Data Modeling Diving Deeper
Lesson 3: Data Modeling
10:00
Dive deeper into Power BI data modeling concepts, including relationships, filter flow, and the role of DAX in calculations.
This preview is temporarily unavailable. Please try again later.
-
Data Modeling Example of a Common Many to Many Mistake
Lesson 3: Data Modeling
10:00
Identify common many-to-many relationship mistakes in Power BI and understand how they lead to incorrect calculations and duplicate results.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Data Modeling Many to Many & Bi Directional Filtering
Lesson 3: Data Modeling
14:12
Analyze advanced data modeling scenarios involving many-to-many relationships and bidirectional filtering.
View enrollment options at Noble Desktop -
Enrollment required
Parameters
Lesson 3: Data Modeling
4:39
Enable dynamic reporting in Power BI by using parameters to let users adjust inputs like date ranges or calculation windows.
View enrollment options at Noble Desktop -
Enrollment required
Inactive Relationships and USERELATIONSHIP
Lesson 3: Data Modeling
10:29
Leverage inactive relationships in Power BI and activate them using USERELATIONSHIP within DAX calculations.
View enrollment options at Noble Desktop -
Enrollment required
Troubleshooting Data Modeling Problems
Lesson 3: Data Modeling
1:38
Diagnose common Power BI data modeling issues such as incorrect totals, broken relationships, and inconsistent DAX results.
View enrollment options at Noble Desktop -
Intro to Row Level Security (RLS)
Lesson 4: Row-Level Security (RLS)
3:23
Understand how to implement row-level security (RLS) in Power BI to control data access at the user level.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Row Level Security (RLS) Static Roles
Lesson 4: Row-Level Security (RLS)
13:38
Configure static row-level security roles in Power BI using predefined filters to restrict data visibility.
View enrollment options at Noble Desktop -
Enrollment required
Row Level Security (RLS) Dynamic Roles
Lesson 4: Row-Level Security (RLS)
15:42
Implement dynamic row-level security in Power BI by leveraging user login credentials to control data access.
View enrollment options at Noble Desktop -
Enrollment required
Power BI Certification PL 300 Exam Info and Prep Materials
Lesson 5: Power BI Certification
2:41
Prepare for the Microsoft PL-300 Power BI certification exam with guidance on exam structure, study resources, and practice strategies.
View enrollment options at Noble Desktop -
Connecting to a Database
Lesson 6: Databases and Query Folding
7:41
Connect Power BI to databases like SQL Server using import and DirectQuery modes.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Query Folding
Lesson 6: Databases and Query Folding
11:19
Optimize Power BI performance by understanding query folding and how transformations are pushed to the data source.
View enrollment options at Noble Desktop -
Enrollment required
Course Outro
Lesson 6: Databases and Query Folding
0:11
Wrap up the Power BI training with key takeaways and encouragement to apply learned techniques in real-world projects.
View enrollment options at Noble Desktop