Subscribe e-Newsletter
    Member Login
    Course Information
    Email
    Pass
    Forget password? Click here
    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.00
    For Member
    SGD 760
    NoteTwo 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.
    Objective
    Through the development of a Monthly Performance Report, you will learn how to:
    1. Establish and connect data from multiple sources such as SQL, SharePoint, Excel workbooks, CSV files and Excel Tables.
    2. Apply the new DAX formulas in Power Pivot.
    3. Create Slicers and enhance the report\\\\\\\'s interactivity.
    4. Prepare Impressive charts and tables for reporting.
    Outline
    1. Creating an Interactive Title for Management Report
    2. Importing Data from multiple sources using Excel Power Pivot
    3. Creating and linking slicers to Power Pivot Table
    4. Displaying selected Historical Data with Power Pivot
    5. Using DAX formulas and Measures in Power Pivot
    6. Creating an interactive line and column chart in Excel
    7. Auto calculate MTD and YTD Actual and Targets with Power Pivot
    8. Activating and using the highly interactive Excel Camera
    9. Automatically display the Top 5 products/customers/categories with Power Pivot
    10. Using Coloured Bands in charts for benchmarking
    11. 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
    Privacy Policy  |  Terms of Use
    Copyright © 2024 CCISG Pte Ltd  |  ACRA Reg No: 201207591D  |  GST Reg No: 201207591D