Notice (8): session_start(): ps_files_cleanup_dir: opendir(/var/lib/php/5.6/session) failed: Permission denied (13) [CORE/Cake/Model/Datasource/CakeSession.php, line 694]
20779: Analyzing Data with Excel Certification Training Course
search3
    
    20779: Analyzing Data with Excel

    QUICK

    INFORMATION

    course-duration

    3 Day(s) Course

    courseware

    Official Courseware

    exam-voucher

    Exam Voucher

    certified-trainer

    Certified Trainer

    one-o-one

    1:1 Training Available on Demand

    customize-batch

    Customize Your Batch

    ABOUT

    THE COURSE

    This course provides you the ability to explore BI techniques and add to excel data. Moreover, you will learn to use Pivot charts, Power BI, and Excel Data Model.
     

    Course Objective:
     

    On completion of course, you will be able to
     

    • Explore classic Excel dashboard and data model
    • Import data from report and SQL Server database
    • Create Power BI dashboard, data visualization, and use advanced DAX functions
    • Preformat and import the .CSV file.

    • Module 1: Data Analysis in Excel
    • Module 2: The Excel Data Model
    • Module 3: Importing Data from Files
    • Module 4: Importing Data from Databases
    • Module 5: Importing Data from Excel Reports
    • Module 6: Creating and Formatting Measures
    • Module 7: Visualizing Data in Excel
    • Module 8: Using Excel with Power BI

    Aspirants who want to learn BI techniques

    The participating individual must have prior knowledge on
     

    • MS Windows operating system
    • Relational databases
    • Excel spreadsheets
    • Data analytics

    Name Code Fee

    enquiry

    ENQUIRY FORM

    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.