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.
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.
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
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.
Starting Date: April 16 2018
Time & Duration: 4 Weeks, Mondays & Wednesdays, 19:00 - 21:00
*Promotion: Join with a friend and you will both receive an HK$500 discount.