Group Size
10
Duration
8 Sessions
Course fee
HK$5000
Course Syllabus
Request

Overview

Excel is a powerful tool in Big Data Analytics. Beyond the usual functions and pivot tables frequently mentioned, we would like to show you more. in this course, we would like to show you the advanced features of Excel can now let you perform complicated analysis and analyse big data, to help you better collect, analyse and visualise your data, so you can outperform your peers and drive your business smarter.

What you will be able to do after the class:

After completing this class, you will be able to use advanced features of Excel.

Excel can now let you perform complicated analysis and analyse big data. You will learn how to extract data from multiple sources (SQL, Web sources, Hadoop, Azure and more). Once the data is collected and centralized. You will learn how to use data to  gain deeper insights and make smarter decisions. Finally, you will learn how to implement powerful visualisations using a dashboard to communicate to management. With these skills, you will learn how to outperform your peers and help drive your organization with smart data analytics.

 Learn how to rapidly comprehend information

Develop your eye for pinpointing emerging trends

Identify relationships and patterns within your datasets

Become a data storyteller. You'll learn how to effectively communicate insights to others.

Course Description

Unit 1: Excel Best Practices and Advanced Formulas

Unit 2: Power Query, Connect to Your Big Data

Unit 3: Power Pivot and Charts

Unit 4: Power BI, Set Up & Expand Business Intelligence

Who Should Take This Course

Professionals working with data in any industry. Data analysis skills are in high demand. If you work in Marketing, Supply Chain, Sales, Design etc... You will come across key data to drive your business. We aim at bridging the gap being non-technical people and grow analytical thinking.

Next Course Information

Starting Date: April 16 2018

Time & Duration: 4 Weeks, Mondays & Wednesdays, 19:00 - 21:00

Price: HK$5000

Language: English

*Promotion: Join with a friend and you will both receive an HK$500 discount.

No items found.

Steven Correy
Steven has over 9 years experience in Finance, working for industry leading companies such as Procter & Gamble and more recently Bloomberg. In Bloomberg, he helped build a Fund Trading Platform and implemented Global project for the firm as a senior data analyst. He is passionate with Data Visualization and how to incorporate it with Financial Analysis to gain and spot Financial insights. In his last role, he oversaw the Excel API product and helped many Financial players in setting up powerful workflow tools.

Learn how to collect, analyse and communicate data like a pro.

Did you see these?

You might be interested in these courses as well: