HK$158.99

Analyze Big Data with Power Query

Event Information

Share this event

Date and Time

Location

Location

Naked Hub, | 16F,#40-44 Bonham Strand, Sheung Wan | Hong Kong SAR China

Hong Kong

View Map

Refund Policy

Refund Policy

No Refunds

Event description

Description

If you are using Excel on a regular basis to prepare reports, and if you have to repeat the same tasks to perform your analysis. Then you should definitely be using Power Query.

Excel Power Query is the best thing that happened to Excel since Power Pivot. It lets you extracts large set of data from multiple sources such as:

  • Files (txt, csv, xls, folder)
  • Databases (SQL, MySQL, Access, PostgreSQL, Teradata, SAP)
  • Online Services (SalesForce, Sharepoint, Facebook, Exchange)
  • Other sources (Table, Web, Hadoop, OData Feed, ODBC)

By the end of this workshop you will learn how you can pull multiple set of data in different format and aggregate it in a very clean way

If your firm is connected to any of this service, then you can save a lot of time and focus more value added tasks to help drive your business or career.

Join us on Wednesday, 28th to see what Power Query can help you. We will share with you templates that were created with these powerful functions.

Share with friends

Date and Time

Location

Naked Hub, | 16F,#40-44 Bonham Strand, Sheung Wan | Hong Kong SAR China

Hong Kong

View Map

Refund Policy

No Refunds

Save This Event

Event Saved