ADVANCED EXCEL 2018 Chandoo Masterclass Special Event ...

1 ADVANCED EXCEL & DASHBOARDSMASTERCLASSA dvanced EXCEL & Dashboard Reporting: Learn to create stunning, world-class EXCEL 21-22 MayBrisbane04-05 JuneMelbourne18-19 JunePerth25-26 JuneConducted by & Plum SolutionsADVANCED EXCEL & DASHBOARD REPORTING POWER EXCEL [ POWER BI, POWER PIVOT, POWER QUERY ]Australia 2018 SessionsPower EXCEL :Develop your Power BI, Power Pivot and Power Query skills to communicate better and do things 23-24 MayBrisbane06-07 JuneMelbourne20-21 JunePerth27-28 June2018 ChandooMasterclass Special Event In these ,Who should 9818 7250 Join now4 Join now4 Learn how to build stunning dashboards & workbooksExcel Dashboards are used to convey vital businessinformation to senior management, partners & customers.

2 Inour two day Masterclasses, learn how to create stunning,world-class EXCEL dashboards, analysedata and create brilliant Power Pivot dashboards. Along the way, you will learnhow to use various ADVANCED features in EXCEL so that you cansave time and look good in front of your bosses & two-day Masterclass sessions can be undertaken individually, or attend all four days for the full Chandooexperience!Benefits of to best-in-class dashboard techniques, design ideas & practical & ideas on using EXCEL stick with Example workbooks, PDF guides & to selected videos & material on opportunities with fellow professionals & support for your EXCEL questions for three months by program is aimed at.

3 Managers Systems & Reporting Analysts Business & Data Analysts MIS Reporting Analysts Business Intelligence Professionals Executives in Sales, Finance, Marketing orCustomer ServiceIf you use EXCEL for more than 6 hours a week, you will benefit from this MasterclassRegister nowBook OnlineMasterclass AgendaAdvanced EXCEL & Dashboard Reporting8:45 RegistrationSession 1 Making modern EXCEL work for you & your organization What is new in EXCEL 2016 / EXCEL 365?oQuick tour of ExceloSmart features for Analysts and Managers Analysing data with TablesoTabular data modeloStructural referencing vs.

4 Cell referencingoAdvantages of tables Formulas for data analysisoSUMIFS and many other IFSoVLOOKUP and other search functionsoBusiness rules & logic in ExceloDate intelligence formulasoError handling Hands-on: Sales & Customer AnalysisoBuild an interactive sales & customer analysis tool in ExceloGather insights on customer behaviouroBuild quick visualisationsMorning breakSession 2 Insights in a snap Pivot Tables & Data Modelling in EXCEL Data modelling and relationships in ExceloMultiple tablesoConnecting tables with relationships Pivot Tables for data analysisoBasics of pivotsoHierarchies and GroupingoTime intelligence in pivotsoSlicers and timelines -interactive filtering oPowerful pivoting features in modern

5 ExceloGETPIVOTDATA and CUBE formulas Visualisingthru PivotsoPivot chartsoRegular charts from Pivot TablesoInteractive charting thru Pivots Hands-on: One-hour dashboard with ExcelLunchSession 3 Visual Analytics with EXCEL Right charts for your dataoHow to pick right charts for your dataoCharting mistakes to avoid ADVANCED Charting for visual analyticsoCombination chartsoWaterfall chartsoTreemapsoBox plots Quick and elegant visualisationsoSparklinesoIn-cell charting Interactive chartingoSlicers + ChartsoForm controls + charts5.

6 00 End of day oneDAY ONES ydney Melbourne21-22 May18-19 JuneBrisbanePerth04-05 June25-26 JuneMasterclass AgendaAdvanced EXCEL & Dashboard Reporting8:45 RegistrationSession 1 Making effective dashboards for your business Process for creating awesome dashboardsoWhat is a bad dashboard?o10-step process for awesome dashboardsoMVC architecture for your dashboardsMorning breakSession 2 Hands-on: Building an awesome KPI dashboard in EXCEL Defining goals for our dashboardoRequirement gatheringoMocking up the dashboardoDefining interactive features Collecting and structuring data in ExceloGathering data thru connections / Power QueryoSetting up tablesoCreating a calendar tableoConnecting tables with relationships Building a calculation engineoUsing pivot tables to process KPIsoAdding necessary formula layeroInteractivity thru Slicers & Form Controls Visualisations for the dashboardoVisual layout for the

7 DashboardoHeadlines and key takeawaysoVisualising trendsoAdding alertsoInteractive graphs / tables Sharing & Publishing the dashboardoSharing for PC / TabletsoSharing for WeboSharing for printLunchSession 3 What can we learn from the world s best dashboards? Design philosophies for dashboardsoCRAP rules for designoMVC architecture for the workbooksoLayout templatesoOne screen vs. scrollable? Inspiration from world s best dashboardsoCase studies on best dashboardsoResources to learn moreoQ&A5:00 End of day oneDAY TWOS ydney Melbourne21-22 May18-19 JuneBrisbanePerth04-05 June25-26 JuneMasterclass AgendaPower EXCEL Power BI, Power Pivot, Power QueryDAY ONE8:45 RegistrationSession 1 How Power BI can help you & your organization What is Power BI?

8 OQuick tour of Power BI DesktopoHow Power BI can collect, analyse, visualise and share your information with worldoPower BI vs. Traditional EXCEL Hands-on: Our first Power BI ReportoDoes temperature impact cricket scores?oAustralian venues & ODI matches in 2014oTemperature stats for the datesoGetting the data in to Power BIoTemp vs. Score Quick analysisoAdding interactivityMorning breakSession 2 Collect and process data with Power Query What is Power Query?oHow it compares with SQL, connectionsoQuick tour of Power QueryoPower Query UI, terminology Hands-on: Read a bunch of CSV files and merge dataoGather data from a folderoData clean up with Power QueryoAdding extra dataoRemoving un-necessary columnsoPublishing to Power BIoRefreshing when you have new files Overview of M languageoWhat is M?

9 OUsing formula bar in Power QueryoPower Query Functions and keywordsLunchSession 3 Modelling and Analysing data with Power Pivot What is Power Pivot?oPower Pivot vs. Data WarehouseoPower Pivot in EXCEL vs. Power BIoTerminology Star schema, Dimensions, Facts, Measures, Cubes, Calculated columns, Groups, Hierarchies and KPIsoQuick Demo Hands-on: Setting up a star schema in Power PivotoGathering tables and connecting themoIntroduction to DAX formula languageoUsing DAX to define calculated columns and measuresoBuilding your first Power PivotoPower Pivot in EXCEL vs.

10 Power Pivot in Power BI behaviour differences5:00 End of day oneSydney Melbourne23-24 May20-21 JuneBrisbanePerth06-07 June27-28 JuneMasterclass AgendaPower EXCEL Power BI, Power Pivot, Power QueryDAY TWOS ydney Melbourne23-24 May20-21 JuneBrisbanePerth06-07 June27-28 June8:45 RegistrationSession 1 Connecting the dots Power Query, Power Pivot and Power BI How each part of the Power pack plays a role in building world s easiest reporting system with Power BI Thinking about performance, privacy and optimization Hands-on: Bicycle sharing in Melbourne Power BI interactive visualisationoBicycle sharing dataoDefining goals for visualisationoBuilding a data modeloMeasures with DAXoVisualisationsoInteractivityMorning breakSession 2 Hands-on.