MOC ON DEMAND: 20779 Analyzing Data with Excel

Description

This 3-day course gives students working with Excel data alalysis the ability to add BI techniques to their current skills and knowledge. The Student will receive an in-depth understanding that will take them beyond the capabilities of tables and charts. Into using Pivot Charts, the Escel Data Model and Power BI. 

IT professionals that are responsible for analyzing data with Excel would benefit greatly from this course. 

****Possible interested attendees: SQL Server report creators interested in alternative methods of presenting data*******

Once a student has completed this course, they will be able to: 

  • Explore and extend a classic Excel dashboard
  • Explore and extend an Excel data model 
  • Pre-format an import a .CSV file
  • Impart data from a SQL Server database
  • Import data from a report
  • Create measures using advanced DAX functions
  • Create data visualizations in Excel
  • Create a Power BI dashboard with Excel 

 

 

 

Prerequisites

It is recommended that Students attending this course have:

  • Basic knowledge of Microsoft Windows operating system and its core functionality
  • Good knowledge of Excel spreadsheets, functions, and charts
  • Working knowledge of relational databases
Contact Us

THE ACADEMY

1.800.482.3172

FTL: 954.351.7040

MIA: 305.648.2000


Request More Information

 

Current Promotions!

 

  _____________________________________

 

 

 

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Sign up for our Email Newsletter!

          

 

Students - Orbund Log-In

 

 

 

 

 

Top
  • Follow us on
  • Facebook Academy Page
  • Twitter Academy Page