Event Profile | |
Class/ Online | Classroom |
Date | November 07 - 08, 2018 |
Time | 9:00am to 5:00pm |
Venue | 10 Anson Road #26-02A
International Plaza Singapore 079903 |
Fee | 7% GST will apply SGD 800.00For Member SGD 760 |
Note | Two tea breaks and buffet lunch will be served. Limited complimentary car parking coupons are available upon request. |
Trainer | |
Activity |
For powerful, rapid, highly visual business intelligence reporting.
Power Pivot is a brand new function introduced in Excel 2010. A powerful function, it is capable of extracting huge amount of data (multi-million records) from multiple sources, SQL Servers, Sharepoint, Excel workbooks, Excel Tables and CSV files. With Excel Power Pivot, companies can now access and mine data directly from their ERP systems and gain invaluable insights into their business performance like never before.
The use of Pivot Table with Power Pivot means users do not have to start from ground zero to learn the functionality of another report writing tool. Users are therefore able to focus their attention on understanding the dynamics of databases and shorten the time spent on generating their reports using Power Pivot.
Power Pivot is a brand new function introduced in Excel 2010. A powerful function, it is capable of extracting huge amount of data (multi-million records) from multiple sources, SQL Servers, Sharepoint, Excel workbooks, Excel Tables and CSV files. With Excel Power Pivot, companies can now access and mine data directly from their ERP systems and gain invaluable insights into their business performance like never before.
The use of Pivot Table with Power Pivot means users do not have to start from ground zero to learn the functionality of another report writing tool. Users are therefore able to focus their attention on understanding the dynamics of databases and shorten the time spent on generating their reports using Power Pivot.
Objective
Through the development of a Monthly Performance Report, you will learn how to:
- Establish and connect data from multiple sources such as SQL, SharePoint, Excel workbooks, CSV files and Excel Tables.
- Apply the new DAX formulas in Power Pivot.
- Create Slicers and enhance the report\\\\\\\'s interactivity.
- Prepare Impressive charts and tables for reporting.
Outline
- Creating an Interactive Title for Management Report
- Importing Data from multiple sources using Excel Power Pivot
- Creating and linking slicers to Power Pivot Table
- Displaying selected Historical Data with Power Pivot
- Using DAX formulas and Measures in Power Pivot
- Creating an interactive line and column chart in Excel
- Auto calculate MTD and YTD Actual and Targets with Power Pivot
- Activating and using the highly interactive Excel Camera
- Automatically display the Top 5 products/customers/categories with Power Pivot
- Using Coloured Bands in charts for benchmarking
- Turning on PowerPivot auto-refresh function
Who should attend
This course is specially tailored for business managers and executives who are responsible for preparing management reports and are seeking new perspectives to enhance and add value to their presentation. Participants must have attended Hidden Secrets in Data Analysis with Excel Course or possess advanced knowledge about Excel. Advanced Excel users are defined as regular users of VLOOKUP worksheet function, complex functions (formulas within formula), Pivot Table, etc.
Jason Khoo's Profile
Jason Khoo is a Microsoft Certified Trainer (MCT), ACTA certified trainer of 20 years. He is a Microsoft Certified Power BI Data Analyst Associate and a data analytics practitioner of 30 years. During his time of employment, he has worked in Tibs (currently SMRT), MobileOne Ltd, 3M and Virgin Mobile.
During his tenure, he has worked with multiple databases, extracted and downloaded information from systems and run numerous analysis. These analyses spanned across many departments such as Finance, Sales, Marketing, Human Resources, Payroll, etc.
After his employment, he worked as a data analytics consultant for many companies, including Discovery Asia, 3M, Tanah Merah Country Club, Johnson and Johnson Vision Care, National Environmental Agency, Timberland, etc.
His data analytics skills combined with Excel allowed him to deliver many reports to the clients without them having to incur software cost. These reports include Dashboards, Top 10 charts, Risk Analysis, Business Models, KPIs, etc.
As a trainer, he is passionate about transferring his knowledge and imparting his skills to his participants. To day, he has trained thousands in his face to face workshops and had conducted talks for thousands as well.
Trans-Island Bus Services Ltd (Tibs) –Operations and Revenue Analytics, Passengers Travelling Behaviour Analytics
• Daily tracking of revenue,
• Prepare KPI for LTA,
• Fare revision analysis
Mobile One Asia Ltd (M1) – Financial analytics, Customer Call Usage Analytics
• Full company budgeting and business planning,
• Monthly Analysis,
• KPI reporting
3M – Sales, Cost and Inventory analytics
• Daily and Monthly Sales Forecasting,
• Analysis of Marketing Budget,
• Analysis of Inventory and shipments.
• Cost Analysis for new products (BOM analysis)
Virgin Mobile – Retail, Marketing, Payroll, Admin, IT, Finance Analytics
• Daily KPI reporting,
• Monthly Analysis for Finance, Payroll,
• Developed Fully Automated Business Model driven by KPI
During his tenure, he has worked with multiple databases, extracted and downloaded information from systems and run numerous analysis. These analyses spanned across many departments such as Finance, Sales, Marketing, Human Resources, Payroll, etc.
After his employment, he worked as a data analytics consultant for many companies, including Discovery Asia, 3M, Tanah Merah Country Club, Johnson and Johnson Vision Care, National Environmental Agency, Timberland, etc.
His data analytics skills combined with Excel allowed him to deliver many reports to the clients without them having to incur software cost. These reports include Dashboards, Top 10 charts, Risk Analysis, Business Models, KPIs, etc.
As a trainer, he is passionate about transferring his knowledge and imparting his skills to his participants. To day, he has trained thousands in his face to face workshops and had conducted talks for thousands as well.
Trans-Island Bus Services Ltd (Tibs) –Operations and Revenue Analytics, Passengers Travelling Behaviour Analytics
• Daily tracking of revenue,
• Prepare KPI for LTA,
• Fare revision analysis
Mobile One Asia Ltd (M1) – Financial analytics, Customer Call Usage Analytics
• Full company budgeting and business planning,
• Monthly Analysis,
• KPI reporting
3M – Sales, Cost and Inventory analytics
• Daily and Monthly Sales Forecasting,
• Analysis of Marketing Budget,
• Analysis of Inventory and shipments.
• Cost Analysis for new products (BOM analysis)
Virgin Mobile – Retail, Marketing, Payroll, Admin, IT, Finance Analytics
• Daily KPI reporting,
• Monthly Analysis for Finance, Payroll,
• Developed Fully Automated Business Model driven by KPI