.jpg){kind=logo}
CU-COMM213.AD1
Computing and Visualization Tools for Business Analytics
Beginner Self-paced · 1 year access
67 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
6 Interactive Lessons · 40 topics01 Data Analysis Foundations 8 topics · 11 LiveLab +
- Data Analysis and Visualization for Business Intelligence
- Self-Service BI with Microsoft Power BI
- Create Data Connections
- Configure and Manage Data Relationships
- Save Files in Power BI
- Introduction to Data Science
- Create and Modify Tables
- Sort and Filter Data
11 LiveLab in this lesson — see the labs panel →
02 Data Cleaning and Pivot Table Analytics 6 topics · 14 LiveLab +
- Clean, Transform, and Load Data with the Query Editor
- Profile Data with the Query Editor
- Shape Data with the Query Editor
- Combine and Manage Data Rows
- Create a PivotTable
- Analyze PivotTable Data
14 LiveLab in this lesson — see the labs panel →
03 Data Modeling and Visualization with Power BI & Excel 7 topics · 13 LiveLab +
- Create Visualizations in Power BI
- Chart Data in Power BI
- Create Calculations with Data Analysis Expressions (DAX)
- Create Calculated Measures and Conditional Columns
- Visualize Data with Charts
- Modify and Format Charts
- Apply Best Practices in Chart Design
13 LiveLab in this lesson — see the labs panel →
04 Data Analysis and Visualization with Excel Dashboards & Maps 9 topics · 14 LiveLab +
- Analyze Data with Formulas and Named Ranges
- Analyze Data with Functions
- Implement Data Validation, Forms, and Controls
- Create Conditional Visualizations with Lookup Functions
- Visualize Data with PivotCharts
- Filter Data Using Slicers and Timelines
- Create a Dashboard in Excel
- Create Map Charts in Excel
- Customize Map Charts in Excel
14 LiveLab in this lesson — see the labs panel →
05 Interactive Data Analysis and Visualization 5 topics · 8 LiveLab +
- Customize Visuals and Pages
- Incorporate Tooltips
- Create and Manage Data Hierarchies
- Filter and Slice Reports
- Create Dashboards
8 LiveLab in this lesson — see the labs panel →
06 Advanced Analysis and Enhanced Reporting 5 topics · 7 LiveLab +
- Create Calculated Tables, Variables, and Parameters
- Enhance Visuals with Statistical Analysis
- Perform Advanced Analysis
- Enhance Reports
- Enhance Dashboards
7 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
67 LiveLabs- Interacting with Visualizations in Power BI
- Creating a Data Connection
- Configuring and Managing Data Relationships
- Saving and Exporting Files in Power BI
- Using Data Types and Conversion
- Handling missing values
- Conditional formatting
- Handling duplicates
- Analyzing Data
- Creating and Modifying a Table
- Sorting and Filtering Data
- Merging and Appending Data in Power BI
- Pivot & Unpivot Column in Power BI
- Histogram and Frequency Table in Power BI
- Cleaning, Transforming, and Loading Connected Data
- Data Modelling in Power BI
- Random Sampling
- Descriptive Statistics in Excel
- Profiling Data in Power BI
- Shaping Data for Analysis
- Using the Transpose Feature
- Frequency Distribution and Histogram
- Box Plots and Cross-Tabulation
- Creating PivotTables
- Analyzing the PivotTable Data
- Visualizing Pie Chart and Clustered Column Chart in Power BI
- Dual Axis and Tree Map in Power BI
- Creating Visualizations
- Charting Data in Power BI
- Creating Calculations with DAX
- Creating Calculated Measures
- Creating Conditional Columns
- Combo and Dual Axis Charts
- Scatter Plot
- Pie Chart
- Creating Charts
- Modifying and Formatting Charts
- Applying the Best Practices of Chart Design
- Excel References
- Text Functions in Excel
- Analyzing Data Using Formulas
- Analyzing Data Using Functions
- Working with Logical Functions
- Implementing Data Validation
- Implementing Form Controls
- Using LOOKUP Functions
- Visualizing Data with PivotCharts
- Filtering Data Using Slicers
- Filtering Data Using Timelines
- Creating a Dashboard in Excel
- Creating Map Charts in Excel
- Formatting and Customizing Map Charts
- Customizing Visuals in Power BI
- Incorporating Tooltips to Enhance Data Analysis
- Creating Dashboards
- Creating and Managing Data Hierarchies (1)
- Filtering and Slicing Reports
- Creating and Managing Data Hierarchies
- Time Intelligence Measures
- Filtering and Slicing Reports
- Creating Calculated Tables, Variables, and Parameters
- Dynamic Top N Slicer
- Creating a Calculated Table
- Enhancing Visuals with Statistical Analysis
- Performing Advanced Analysis
- Enhancing Reports
- Enhancing Dashboards
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for Computing and Visualization Tools for Business Analytics
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 67 LiveLab included
- Certificate of completion
No credit card required