Excel Dashboards and Data Analysis Course

Overview

Develop your skills to perform powerful data analysis using the Excel Power Tools to visualise vast amounts of data and create stunning interactive data visualisations. Use the Get and Transform tools to import and combine data from a variety of sources such as databases and web sites. Create data models with Power Pivot, Power View and create interactive Power Maps to visualise geographic data.
 

This is best for

Business end users who want to develop their skills using a range of Microsoft Data Analysis power tools, to process and analyse data to produce rich reports, visualisations and stunning dashboards.

     

Content

 

Get & Transform

  • Understanding get and transform
  • Create a new query from data
  • Transforming data work with queries
         

Power View

  • Understanding power view  
  • Creating a power view sheet  
  • Working with a power view object and fields
  • Rearranging and sorting fields
  • Tiling data and filtering data in power view
  • Switching visualisations            

 

Power Pivot

  • Understanding power view and relational data   
  • Connecting to a data source   
  • Working with the data model   
  • Changing a power pivot view  
  • Formatting a data model - PivotTable    
  • Creating a calculated field                
  • Adding slicers and timeline 

Power Map

  • Understanding power map  
  • Creating a power map tour  
  • Working with location fields, mapping confidence and height, also category fields 
  • Filtering data
  • Navigating a data map 
  • Changing the look           
  • Working with layers and scenes
  • Viewing and editing a tour
  • Exporting a tour as a video

 

Power BI

  • Introduction to Power BI and its components
  • Introduction to main features
  • Connecting to data sources with Power BI - Excel, Access and CSV files.
  • Data visualisations - instant dashboards and reports
         
           

Learning outcomes

Use a range of Power Tools to examine and analyse data and perform a variety of analytical tasks using Power View, Power Pivot, Get & Transform, Power Map and Power BI.
           

Prerequisite

Completion of Excel Intermediate or equivalent knowledge is required.
       

Course duration

1 day
   
    

Further development

Microsoft Excel Advanced
   

 

Book Now

   

   

 

  IT

  

"Our suite of Computer Training courses are designed to support each participant in learning new skills and implementing them back into their workplace. We want to ensure that your organisation’s key assets, your people, are equipped to achieve maximum productivity."   

 

  

Standard Course Information

  
Inclusions:

  • Take home course manual
  • Facilitator led training
  • Qualified trainer
  • Certificate of Attendance for participants
  • Post-course Help Desk support
  • Morning & afternoon refreshments
  • Lunch

    
 
 
Training venue:

Cloisters Level 1, 863 Hay Street
Perth CBD
  
    
     
Additional information:

  • IT standard training day runs from 9.00am - 4.00pm
  • 1 hour lunch break for full day courses
  • ½ day courses vary, please contact us for timings
  • Prices quoted are standard rates
  • Government and other discounts may apply and will be confirmed on invoice

                
 
  

Roving Training

Need IT Training? Don't have time to go on a course? We are happy to come to you!

One of our expert instructors roams your workplace calling in any users that require coaching in any desktop applications. 

Roving training is perfect if numerous employees need some tips and tricks on various programs. Training is tailored to your individual needs and we are able to train using your own documents.   

   
  

Customised Solutions

We understand one size does not always fit all. Our team of qualified trainers can create a customised solution tailored to your specific needs.

We are happy to offer closed group sessions or additional dates as you require.

To discuss customisation training, simply call 08 9218 9059 or email admin@ati-mirage.com.au

 
 

Logo Bulb
  

Enriching lives.
Empowering organisations.