Manipulating Big Data Using Microsoft Excel Power Query & Power Pivot

Pre-requisites

Delegates should be proficient users of Excel and be experienced in creating Excel PivotTables and Pivot Charts.

[bunch_service_single _id="969977" img1="https://www.ted.com.my/wp-content/uploads/2018/02/people-using-computer-laptop_53876-2403-300×182.jpg" img_caption1="Caption 1" img2="http://www.ted.com.my/wp-content/uploads/2017/08/9.jpg" img_caption2="Caption 2" text="PHAgc3R5bGU9InRleHQtYWxpZ246IGp1c3RpZnk7Ij48aT5CaWcgRGF0YTwvaT4gaXMgYSB0ZXJtIHRoYXQgZGF0YSBzZXRzIHRoYXQgaXMgbGFyZ2UgYW5kIGNvbXBsZXguIEFzIGJpZyBkYXRhIGluIGNvbXBhbnkgaXMgZ3Jvd2luZywgdGhlIGNoYWxsZW5nZSBvZiBJVCBwZXJzb25uZWwsIEJ1c2luZXNzIEludGVsbGlnZW5jZSwgQnVzaW5lc3MgQW5hbHlzdCBhbmQgRGF0YSBBbmFseXN0cyBpcyB0byBhbmFseXplIGJpZyBkYXRhIHdoaWNoIGlzIHNvIGNvbXBsZXggYW5kIGNvbnZlcnQgdG8gbWVhbmluZ2Z1bCBpbmZvcm1hdGlvbiBmb3IgYmV0dGVyIGRlY2lzaW9uIG1ha2luZy4gVGhpcyBpcyB0d28oMikgZGF5cyBwcm9ncmFtIGhlbHAgeW91IHRvIGdhaW4gaW5zaWdodHMgdGhlIEJpZyBEYXRhIHVzaW5nIFBvd2VyIFF1ZXJ5IGFuZCBQb3dlciBQaXZvdCAyMDEwLzIwMTMgdG9vbHMuPC9wPg0KPHAgc3R5bGU9InRleHQtYWxpZ246IGp1c3RpZnk7Ij5Qb3dlciBRdWVyeSBpcyBzaW1wbHkgdGhlIGJlc3QgdHJhbnNmb3JtYXRpb24gYW5kIGRhdGEgbWFuaXB1bGF0aW9uIHRvb2wgZm9yIEV4Y2VsLiBJZiB5b3UgdXNlIEV4Y2VsIHRvIHRyYW5zZm9ybSwgZW5yaWNoLCBhcHBlbmQgb3IgbWVyZ2UgeW91ciA8aT5iaWcgZGF0YTwvaT4gdGhlbiB0aGlzIHRvb2wgaXMgd2hhdCB5b3UgbmVlZC48L3A+DQo8cCBzdHlsZT0idGV4dC1hbGlnbjoganVzdGlmeTsiPlBvd2VyIFBpdm90IGlzIGFuIGFkZC1pbiBmb3IgTWljcm9zb2Z0IEV4Y2VsIDIwMTAgYW5kIDIwMTMgdGhhdCBlbmFibGVzIHlvdSB0byBpbXBvcnQgbWlsbGlvbnMgb2Ygcm93cyBvZiBkYXRhIGZyb20gbXVsdGlwbGUgZGF0YSBzb3VyY2VzIGludG8gYSBzaW5nbGUgRXhjZWwgd29ya2Jvb2ssIGNyZWF0ZSByZWxhdGlvbnNoaXBzIGJldHdlZW4gaGV0ZXJvZ2VuZW91cyBkYXRhLCBjcmVhdGUgY2FsY3VsYXRlZCBjb2x1bW5zIGFuZCBtZWFzdXJlcyB1c2luZyBmb3JtdWxhcywgYnVpbGQgUGl2b3RUYWJsZXMgYW5kPC9wPg0KPHAgc3R5bGU9InRleHQtYWxpZ246IGp1c3RpZnk7Ij5QaXZvdCBDaGFydHMsIGFuZCB0aGVuIGZ1cnRoZXIgYW5hbHl6ZSB0aGUgZGF0YSBzbyB0aGF0IHlvdSBjYW4gbWFrZSB0aW1lbHkgYnVzaW5lc3MgZGVjaXNpb25zIHdpdGhvdXQgcmVxdWlyaW5nIElUIGFzc2lzdGFuY2UuPC9wPg==" tabs="eyIxIjp7ImJ0bl90aXRsZSI6IkRheSAxIiwidGFiX2ltZyI6IiVTSVRFX1VSTCUvd3AtY29udGVudC91cGxvYWRzLzIwMTgvMDYvSWNvbi1wb3dlci1xdWVyeS0xNTB4MTUwLnBuZyIsImxpbmsiOiIiLCJkZXNjIjoiUEhBK1VHOTNaWElnVVhWbGNua2dUM1psY25acFpYYzhMM0ErRFFvOGRXdytEUW84YkdrK1NXNTBjbTlrZFdOMGFXOXVJSFJ2SUZCdmQyVnlJRkYxWlhKNVBDOXNhVDROQ2p4c2FUNUJjSEJsYm1ScGJtY2daR0YwWVR3dmJHaytEUW84YkdrK1RXVnlaMmx1WnlCVVlXSnNaVHd2YkdrK0RRbzhiR2srVkhKaGJuTm1iM0p0YVc1bklFUmhkR0U4TDJ4cFBnMEtQR3hwUGxCdmQyVnlJRkYxWlhKNUlFWnZjbTExYkdGelBDOXNhVDROQ2p4c2FUNURiR1ZoYm1sdVp5QkVhWEowZVNCRVlYUmhQQzlzYVQ0TkNqeHNhVDVFWVhSaFltRnpaWE1nWVhNZ2MyOTFjbU5sY3p3dmJHaytEUW84YkdrK1JYaGphR0Z1WjJVZ1lYTWdZU0JrWVhSaElGTnZkWEpqWlR3dmJHaytEUW84TDNWc1BnPT0ifSwiMiI6eyJidG5fdGl0bGUiOiJEYXkgMiIsInRhYl9pbWciOiIlU0lURV9VUkwlL3dwLWNvbnRlbnQvdXBsb2Fkcy8yMDE4LzA2L0ljb24tcG93ZXItcGl2b3QtMTUweDE1MC5wbmciLCJsaW5rIjoiIiwiZGVzYyI6IlBIQStVRzkzWlhJZ1VHbDJiM1FnVDNabGNuWnBaWGM4TDNBK0RRbzhkV3crRFFvOGJHaytTVzF3YjNKMElHVjRkR1Z5Ym1Gc0lHUmhkR0VnWm5KdmJTQnRkV3gwYVhCc1pTQnpiM1Z5WTJWekxnMEtQSFZzUGcwS1BHeHBQa05zYVdWdWRDQmtZWFJoWW1GelpUd3ZiR2srRFFvOGJHaytSWGhqWld3Z2RHRmliR1Z6UEM5c2FUNE5DanhzYVQ1RFUxWWdabWxzWlhNOEwyeHBQZzBLUEM5MWJENE5Dand2YkdrK0RRbzhiR2srU0dGdVpHeHBibWNnYldGemMybDJaU0JrWVhSaElHWnliMjBnYlhWc2RHbHdiR1VnYzJobFpYUnpMand2YkdrK0RRbzhiR2srUTNKbFlYUmxJSEpsYkdGMGFXOXVjMmhwY0hNZ1ltVjBkMlZsYmlCdGRXeDBhWEJzWlNCMFlXSnNaWE11UEM5c2FUNE5DanhzYVQ1SWIzY2dkRzhnWTNKbFlYUmxJR0VnZFhObGNpQm1jbWxsYm1Sc2VTQnRiMlJsYkhNOEwyeHBQZzBLUEd4cFBsQmxjbVp2Y20wZ1kyRnNZM1ZzWVhScGIyNXpJR2x1SUZCdmQyVnlJRkJwZG05MERRbzhkV3crRFFvOGJHaytRMkZzWTNWc1lYUmxaQ0JqYjJ4MWJXNXpMand2YkdrK0RRbzhiR2srVFdWaGMzVnlaWE1nS0VOaGJHTjFiR0YwWldRZ1ptbGxiR1J6S1R3dmJHaytEUW84TDNWc1BnMEtQQzlzYVQ0TkNqeHNhVDVEY21WaGRHVWdVR2wyYjNSVVlXSnNaWE1nWVc1a0lGQnBkbTkwSUVOb1lYSjBjeTQ4TDJ4cFBnMEtQR3hwUGtsdWRISnZaSFZqZEdsdmJpQjBieUJFWVhSaElFRnVZV3g1YzJseklFVjRjSEpsYzNOcGIyNGdiR0Z1WjNWaFoyVWdLRVJCV0NrOEwyeHBQZzBLUEM5MWJEND0ifX0=" title="What Will I Learn From This Course?" services="eyIxIjp7Imljb25zIjoiaWNvbi1idXNpbmVzcy0xIiwidGl0bGUxIjoiTGVhcm4gUG93ZXIgUXVlcnkiLCJ0ZXh0MSI6IlBHOXNQZzBLUEd4cElITjBlV3hsUFNKMFpYaDBMV0ZzYVdkdU9pQnNaV1owT3lJK1JYaDBjbUZqZENCa1lYUmhJR1p5YjIwZ1pHbG1abVZ5Wlc1MElITnZkWEpqWlhNZ1lXNWtJR1JoZEdGaVlYTmxjend2YkdrK0RRbzhiR2tnYzNSNWJHVTlJblJsZUhRdFlXeHBaMjQ2SUd4bFpuUTdJajVCZFhSdmJXRjBaU0IwYUdVZ1pHRjBZU0IwY21GdWMyWnZjbTFoZEdsdmJpQmhibVFnWkdGMFlTQmpiR1ZoYm5OcGJtY2djSEp2WTJWemMyVnpQQzlzYVQ0TkNqeHNhU0J6ZEhsc1pUMGlkR1Y0ZEMxaGJHbG5iam9nYkdWbWREc2lQa2x1ZEdWbmNtRjBaU0JrWVhSaElHWnliMjBnYlhWc2RHbHdiR1VnYzI5MWNtTmxjeUJwYm5SdklHRWdjMmx1WjJ4bElITnZkWEpqWlR3dmJHaytEUW84YkdrZ2MzUjViR1U5SW5SbGVIUXRZV3hwWjI0NklHeGxablE3SWo1TlpYSm5hVzVuSUdSaGRHRWdkMmwwYUc5MWRDQjBhR1VnYm1WbFpDQm1iM0lnVmt4UFQwdFZVQ3dnU1U1RVJWZ2dKbUZ0Y0RzZ1RVRlVRMGd1UEM5c2FUNE5DanhzYVNCemRIbHNaVDBpZEdWNGRDMWhiR2xuYmpvZ2JHVm1kRHNpUGxCbGNtWnZjbTBnWTJGc1kzVnNZWFJwYjI0Z2RHOGdZV2RuY21WbllYUmxJR1JoZEdFdVBDOXNhVDROQ2p3dmIydysifSwiMiI6eyJpY29ucyI6Imljb24tZ3JhcGhpYzIiLCJ0aXRsZTEiOiJMZWFybiBQb3dlciBQaXZvdCIsInRleHQxIjoiUEc5c1BnMEtQR3hwSUhOMGVXeGxQU0owWlhoMExXRnNhV2R1T2lCc1pXWjBPeUkrUTNKbFlYUmxJSEpsYkdGMGFXOXVjMmhwY0hNZ1ltVjBkMlZsYmlCdGRXeDBhWEJzWlNCMFlXSnNaWE11UEM5c2FUNE5DanhzYVNCemRIbHNaVDBpZEdWNGRDMWhiR2xuYmpvZ2JHVm1kRHNpUGxCbGNtWnZjbTBnWTJGc1kzVnNZWFJwYjI1eklHbHVJRkJ2ZDJWeUlGQnBkbTkwTGp3dmJHaytEUW84YkdrZ2MzUjViR1U5SW5SbGVIUXRZV3hwWjI0NklHeGxablE3SWo1RGNtVmhkR1VnVUdsMmIzUWdkR0ZpYkdWeklHRnVaQ0JRYVhadmRDQmphR0Z5ZEhNOEwyeHBQZzBLUEd4cElITjBlV3hsUFNKMFpYaDBMV0ZzYVdkdU9pQnNaV1owT3lJK1JHbHpZMjkyWlhJZ2RHOGdSR0YwWVNCQmJtRnNlWE5wY3lCRmVIQnlaWE56YVc5dUlFeGhibWQxWVdkbFBDOXNhVDROQ2p3dmIydysifX0=" title1="Topics Included" text2="PHVsPg0KPGxpPlBvd2VyIEJJIE92ZXJ2aWV3PC9saT4NCjxsaT5EaWZmZXJlbmNlcyBiZXR3ZWVuIEV4Y2VsIFBvd2VyIEJJIC8gUG93ZXIgQkkgRGVza3RvcDwvbGk+DQo8bGk+SW5zdGFsbGluZyBhbmQgbGF1bmNoaW5nIFBvd2VyIEJJIERlc2t0b3A8L2xpPg0KPGxpPkNvbm5lY3RpbmcgdG8gRXhjZWwgYW5kIENTViBmaWxlczwvbGk+DQo8bGk+Q29ubmVjdGluZyB0byBhIGRhdGFiYXNlIG9yIHdlYiBkYXRhPC9saT4NCjxsaT5JbnRyb2R1Y3Rpb24gdG8gUG93ZXIgUXVlcnk8L2xpPg0KPGxpPkNvbm5lY3RpbmcgJmFtcDsgUXVlcnlpbmcgZGF0YTwvbGk+DQo8bGk+Q29tYmluaW5nIGRhdGEgZnJvbSBtdWx0aXBsZSBzb3VyY2VzPC9saT4NCjxsaT5TaGFwaW5nIERhdGEgaW4gUG93ZXIgUXVlcnk8L2xpPg0KPGxpPkludHJvZHVjdGlvbiB0byBQb3dlciBQaXZvdDwvbGk+DQo8bGk+Q3JlYXRpbmcgcmVsYXRpb25zaGlwIGJldHdlZW4gdGFibGVzPC9saT4NCjxsaT5EQVggZnVuY3Rpb25zPC9saT4NCjxsaT5DcmVhdGluZyAmYW1wOyBDdXN0b21pc2luZyBWaXN1YWxpc2F0aW9uczwvbGk+DQo8bGk+Q2hhcnRzLCBUcmVlbWFwcywgTWFwcywgVGFibGVzICZhbXA7IENhcmQgVmlzdWFsaXNhdGlvbnM8L2xpPg0KPGxpPkNyZWF0ZSBSZXBvcnRzIGFuZCBEYXNoYm9hcmRzPC9saT4NCjxsaT5QdWJsaXNoaW5nIHRvIHRoZSBQb3dlciBCSSBjbG91ZCBzZXJ2aWNlPC9saT4NCjxsaT5Qb3dlciBCSSBRJmFtcDtBIE5hdHVyYWwgTGFuZ3VhZ2U8L2xpPg0KPC91bD4="]

[kc_contact_form7 _id="267951" slug="general-contact-form" title="Feel Free To Inquire About our Range of Training Course"]

Previous client that we have conducted training with

The Coffee Bean & Tea Leaf Malaysia

Swis Resources Sdn Bhd

Cypark Resources Berhad

Ted Learning

TED Learning is a soft skills training solutions company which was founded in 2010 by three passionate and dedicated professionals. Together, they bring along 35 years of wide and varied experience in training and development. Our mission is to democratize education through the offering of world-class higher education opportunities that are accessible, flexible, and economical.