MCSEClasses Certification Training Boot Camp MCSE MCSD MCDBA Cisco CIW Linux Oracle Java Security Military Discounts Testimonials About Us Linux/Unix Certification MCSD Certification Home MCSE Certification MCDBA Certification Cisco Certification Security Certification Java Certification Oracle® Certification CIW Certification Jobs Boot Camp Financing Boot Camp Pricing Boot Camp Technical Schedule Contact Us

Microsoft Course 20779: Analyzing Data with Excel

Course Length: 3 days

Class Schedule
Call for Class Schedule
  • Hands-on instruction by a certified instructor
  • Includes all course materials
  • The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

    Audience profile

    This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques.

    The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

    At course completion

    After completing this course, students will be able to:

    • Explore and extend a classic Excel dashboard.
    • Explore and extend an Excel data model.
    • Pre-format and import a .CSV file.
    • Import 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.


    Before attending this course, students must have:

    • Basic knowledge of the Microsoft Windows operating system and its core functionality.
    • Working knowledge of relational databases.
    • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
    • Basic knowledge of data analytics equivalent to having attended course 10994.

    Course Outline

    Module 1: Data Analysis in Excel

    This module looks at the classic Excel dashboard and at ways to extend it.

    • Classic Data Analysis with Excel
    • Excel Pivot Tables
    • Limitations of Classic Data Analysis

    After completing this module, students will be able to:

    • Describe classic data analysis with Excel
    • Describe Excel pivot tables
    • Describe the limitations of classic data analysis with Excel
    Module 2: The Excel Data Model

    This module looks at the classic Excel data model and at ways to extend it.

    • Using an Excel Data Model
    • DAX

    After completing this module, students will be able to:

    • Describe an Excel data model
    • View data within an Excel data table
    • Describe DAX
    Module 3: Importing Data from Files

    This module looks at pre-formatting and importing CSV files.

    • Importing Data into Excel
    • Shaping and Transforming Data
    • Loading Data

    After completing this module, students will be able to:

    • Import data into excel.
    • Shape and transform data.
    • Load data.
    Module 4: Importing Data from Databases

    This module looks at how to import data into Excel from a SQL Server database.

    • Available Data Sources
    • Previewing, Shaping, and Transforming Data
    • Table Relationships and Hierarchies
    • Loading Data

    After completing this module, students will be able to:

    • Identify available data sources.
    • Preview, shape, and transform data.
    • Explain table relationships and hierarchies.
    • Load data from various sources.
    Module 5: Importing Data from Excel Reports

    This module describes how to import data from a report.

    • Importing Data from Excel Reports
    • Transforming Excel report Data

    After completing this module, students will be able to:

    • Import data from Excel reports.
    • Transform Excel report data.
    Module 6: Creating and Formatting Measures

    This module describes how to create and format measures.

    • DAX
    • Measures
    • Advanced DAX Functions

    After completing this module, students will be able to:

    • Explain what DAX is and when to use it.
    • Describe a measure.
    • Use some of the advanced functions within DAX.
    Module 7: Visualizing Data in Excel

    This module describes how to visualize data in Excel.

    • Pivot Charts
    • Cube Functions
    • Charts for Cube Functions

    After completing this module, students will be able to:

    • Create and refine a pivot chart.
    • Describe cube functions and when to use them.
    • Describe a number of charts for use with cube functions.
    Module 8: Using Excel with Power BI

    This module describes how to use Excel with Power BI.

    • Power BI
    • Uploading Excel Data to Power BI
    • Power BI Mobile App

    After completing this module, students will be able to:

    • Describe Power Bi and the various versions available.
    • Upload Excel data to Power BI.
    • Describe the Power BI App. is your best choice for MOC 20779, MOC 20779 training, MOC 20779 certification, MOC 20779 certification boot camp, MOC 20779 boot camp, MOC 20779 certification training, MOC 20779 boot camp training, MOC 20779 boot camp certification, MOC 20779 certification course, MOC 20779 course, training MOC 20779, certification MOC 20779, boot camp MOC 20779, certification MOC 20779 boot camp, certification MOC 20779 training, boot camp MOC 20779 training, certification MOC 20779 course.

    mcseclasses home | technical schedule | application schedule | class outlines | mcse, mcdba, mcsd training | microsoft .net | cisco certification | security training | ced solutions oracle® certification training | linux, unix, aix | comptia certification | webmaster training | pricing | locations | financing | instructors needed | e-mail us

    Search classes by keyword:

    Search classes by category:

    Copyright © 2021 CED Solutions. CED Solutions Refund Policy. All Rights Reserved.

    MCSE certification boot camps and courses are offered in these select cities: Albany MCSE, Albuquerque MCSE, Alexandria MCSE, Anchorage MCSE, Atlanta MCSE, Austin MCSE, Billings MCSE, Birmingham MCSE, Bismarck MCSE, Boise MCSE, Boston MCSE, Charleston MCSE, Charlotte MCSE, Cheyenne MCSE, Chicago MCSE, Cincinnati MCSE, Cleveland MCSE, Columbia MCSE, Columbus MCSE, Dallas MCSE, Denver MCSE, Des Moines MCSE, Detroit MCSE, Hartford MCSE, Honolulu MCSE, Houston MCSE, Indianapolis MCSE, Jackson MCSE, Kansas City MCSE, Las Cruces MCSE, Lincoln MCSE, Little Rock MCSE, Los Angeles MCSE, Louisville MCSE, Madison MCSE, Milwaukee MCSE, Minneapolis MCSE, Montpelier MCSE, New Orleans MCSE, New York City MCSE, Norfolk MCSE, Oklahoma City MCSE, Omaha MCSE, Philadelphia MCSE, Phoenix MCSE, Pierre MCSE, Pittsburgh MCSE, Portland MCSE, Princeton MCSE, Providence MCSE, Raleigh MCSE, Richmond MCSE, Sacramento MCSE, Salt Lake City MCSE, San Antonio MCSE, San Diego MCSE, San Francisco MCSE, San Jose MCSE, Seattle MCSE, Stamford MCSE, Tulsa MCSE, Washington MCSE, Wilmington MCSE.

    MCSE Canada Boot Camps : mcse Calgary, mcse Edmonton, mcse Halifax, mcse Hamilton, mcse Kitchener, mcse London, mcse Montreal, mcse Ottawa, mcse Quebec City, mcse Toronto, mcse Vancouver, mcse Winnipeg.

    CED Solutions offers MCSE certification boot camps and courses in the United States: MCSE Alabama, MCSE Alaska, MCSE Arizona, MCSE Arkansas, MCSE California, MCSE Colorado, MCSE Connecticut, MCSE District of Columbia, MCSE Delaware, MCSE Georgia, MCSE Hawaii, MCSE Idaho, MCSE Illinois, MCSE Indiana, MCSE Iowa, MCSE Kansas, MCSE Kentucky, MCSE Louisiana, MCSE Maine, MCSE Massachusetts, MCSE Michigan, MCSE Minnesota, MCSE Mississippi, MCSE Missouri, MCSE Montana, MCSE Nebraska, MCSE New Jersey, MCSE New Mexico, MCSE New York, MCSE North Carolina, MCSE North Dakota, MCSE Ohio, MCSE Oklahoma, MCSE Oregon, MCSE Pennsylvania, MCSE Rhode Island, MCSE South Carolina, MCSE South Dakota, MCSE Texas, MCSE Utah, MCSE Vermont, MCSE Virginia, MCSE Washington, MCSE West Virginia, MCSE Wisconsin, MCSE Wyoming.

    MCSE Canada Boot Camps : Alberta mcse, British Columbia mcse, Manitoba mcse, New Brunswick mcse, Newfoundland mcse, Nova Scotia mcse, Ontario mcse, Saskatchewan mcse. Quebec mcse.