uCertify

Computing and Visualization Tools for Business Analytics

(CU-COMM213.AD1)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Data Analysis Foundations

  • 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
2

Data Cleaning and Pivot Table Analytics

  • 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
3

Data Modeling and Visualization with Power BI & Excel

  • 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
4

Data Analysis and Visualization with Excel Dashboards & Maps

  • 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
5

Interactive Data Analysis and Visualization

  • Customize Visuals and Pages
  • Incorporate Tooltips
  • Create and Manage Data Hierarchies
  • Filter and Slice Reports
  • Create Dashboards
6

Advanced Analysis and Enhanced Reporting

  • Create Calculated Tables, Variables, and Parameters
  • Enhance Visuals with Statistical Analysis
  • Perform Advanced Analysis
  • Enhance Reports
  • Enhance Dashboards

1

Data Analysis Foundations

  • 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
2

Data Cleaning and Pivot Table Analytics

  • Merging and Appending Data in Power BI
  • Pivot & Unpivot Column in Power BI
  • Histogram and Frequency Table in Power BI
  • Data Modelling in Power BI
  • Random Sampling
  • Descriptive Statistics in Excel
  • Cleaning, Transforming, and Loading Connected Data
  • 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
3

Data Modeling and Visualization with Power BI & Excel

  • 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
4

Data Analysis and Visualization with Excel Dashboards & Maps

  • 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
5

Interactive Data Analysis and Visualization

  • Customizing Visuals in Power BI
  • Incorporating Tooltips to Enhance Data Analysis
  • Creating and Managing Data Hierarchies (1)
  • Filtering and Slicing Reports
  • Creating Dashboards
  • Creating and Managing Data Hierarchies
  • Time Intelligence Measures
  • Filtering and Slicing Reports
6

Advanced Analysis and Enhanced Reporting

  • 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

Related Courses

All Courses