POWER PIVOT & POWER QUERY

POWER PIVOT & POWER QUERY

Summary

Location

Location

Malaysia

Duration

Duration

2 Days
Format

Format

Public Class

Public Class

Unlocking Your Data Potential with Power Query

Are you ready to supercharge your data analysis skills and take your career to the next level? Look no further than the ‘Power Pivot & Power Query’ course, where we dive deep into the dynamic world of Power Query.

Unleash the Power of Data Transformation

In today’s data-driven business landscape, harnessing the full potential of your data is paramount. Power Query is your gateway to this transformation. In this course, you will learn how to seamlessly extract, transform, and load data from a variety of sources. From databases to Excel files, you’ll gain the skills to effortlessly prepare data for analysis, creating a solid foundation for decision-making.

Empower Your Career

Imagine the doors that will open for you with these invaluable skills. For sales executives, business analysts, project managers, and more, mastering Power Query can be a game-changer. Whether you’re looking to streamline your workflow, enhance your analytical capabilities, or simply stay ahead in the corporate world, this course is your ticket to success.

Don’t miss out on this opportunity to become a data wizard. Join us and become the go-to data expert in your organization, armed with the transformative power of Power Query.

Course Details

Course Code: Instructor-led

Audience

  • Sales Executive / Managers
  • Business Analysist
  • Resource Planning Team
  • Project Managers
  • Purchasing Manager
  • Financial Executive / Managers

Prerequisites

Basic knowledge of Windows is essential with the following pre-requisites:

  • Able to create a spreadsheet with simple formatting
  • Able to use Auto Filter command
  • Able to use basic functions – AutoSum, Count, Max, Min and Average functions
  • Able to switch between task applications

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.

Course Objectives

Upon completion of this program, participants should be able to:

  • Getting Started with Microsoft Excel 2019, Identify the Elements, and Interface of Excel
  • Performing Calculation, Basic Formula and Functions
  • Modify worksheet & Formatting Worksheet
  • Printing and managing large workbook

Outlines

  • Add-ins Power Pivot from Options
  • Launch the PowerPivot window
  • A Tour to PowerPivot window
  • Switching Normal mode and Advanced Mode
  • Exploring the PowerPivot tab
  • Changing between Data & Diagram view
  • Get Data from database
  • Get data from Excel files
  • Get data from Text or CSV files sources and types supported in PowerPivot workbooks
  • Add Data by using Excel Linked Tables
  • Load from Power Query
  • Working with Tables
  • Managing Columns
  • Set Data Type and Format
  • Filtering and Sorting Data
  • Understanding Types of Relationships
  • Create a Relationship Between Tables
  • View and Edit Relationships
  • Delete Relationships
  • Refresh with latest data
  • Editing connection
  • Deleting connection
  • Building Calculated Columns within a Table
  • Building calculate Column across multiple table
  • Creating a New Measure

Formatting a Measure

  • Creating Measure across multiple Tables
  • Useful DAX Functions
    • FILTER
    • ALL
    • RELATED
    • TOTALYTD
    • TOTALQTD
    • TOTALMTD
    • SAMEPERIODLASTYEAR
    • CALCULATE
  • Modify and Delete Measures
  • Mark as Date Table
  • Create a Date Table
  • Import data from database
  • Import data from Text or Text Files
  • Import data from folder
  • Duplicate Query
  • Rename Query
  • Switching Between Power Query Editor and Excel Screen
  • Viewing Applied Steps in Query Settings pane
  • Renaming and Deleting Applied Steps
  • Identify Column Header via Promote and Demote
  • Removing Repeated Headers from Subsequent Files
  • Removing Duplicate Records
  • Changing Column Headers
  • Changing Data Type
  • Removing, Moving, Renaming Columns
  • Reorganize data with Sorting
  • Get relevant data with Filter
  •  
  • Joining multiple tables into master table via Append
  • Merging Queries on Single or Multiple Matching Columns
  • Returning Referenced Details on Those Matched
  • Returning Results on Those Not Matched
  •  
  • Close and Load data into Excel from Power Query
  • Refresh query to get latest data from source
  • Unpivoting Columns
  • Pivoting Columns
  • Splitting Column into Multiple Columns
  • Merging Columns
  • Fill empty rows with data above and below
  • Manage number column with some calculation
  • Converting Text to Uppercase, Lowercase
  • Extracting Part of Text
  • Cleaning up non-printable characters
  • Showing Date Time as Date or Time
  • Combining Date Column and Time Column as One Column
  • Format or Extract date based on date value day, month and year
  • Summing Values based on Grouping
  • Replace value
  • Create Custom Columns
  • Create Conditional Column
  • Indexing Column
  • Data Source Settings
  • Change Source Location
  • Change to Different Source

Trainers

Reviews

Interested In

POWER PIVOT & POWER QUERY

Starting From
RM1000
Intake Date
26-27 MAR 2024
,
27-28 MAY 2024
,
15-16 JULY 2024
,
11-12 SEPT 2024
,
11-12 NOV 2024
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Course Name: POWER PIVOT & POWER QUERY
Duration: 2 Days
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *