Latest News

19 Jul

Medilink East Midlands Innovation Day

The Pro-Vice Chancellor for Innovation at Oxford University, the Deputy Director of the NHS Innovation Accelerator and an award-winning Science Author and former BBC Science Correspondent were among the guest speakers.

17 Jul

Continued jobs growth bodes well for future prosperity

The number of people in work in the East Midlands continues to rise, according to figures released this morning.

17 Jul

Chamber gives evidence at BEIS committee

Improved rail services and fairer infrastructure investment in the East Midlands will drive growth, East Midlands Chamber Director of Policy Chris Hobson told a Business Energy and Industrial Strategy committee at Westminster this morning.

Digital Skills Academy - Data Visualisation

Host: Digital Skills Academy
Venue: Peak Indicators, Innovation Centre, Brimington Rd, Chesterfield ,S41 0TZ
Date: Tuesday 17th September, 2019
Time: 9am - 4.30pm
Cost: FREE

            4 full day courses:

Day 1: 17th September

Day 2: 24th September

Day 3: 30th September

Day 4: 8th October 

 

Course Overview 

Data is a useful tool to inform great business decisions. But how do you present figures and statistics in interesting and accessible ways to team members or senior management with less knowledge than you?

This four-day training course will provide a comprehensive overview of how you can record and present data in ways that will help inform great business decisions.  The course is about presenting large amounts of information in ways that are universally understandable and how to spot patterns, trends and correlations that then translate into recommendations. The formats covered in the course include charts, graphs, infographics and other pictorial diagrams.

The course also covers use of the tools and software necessary to communicate information in these ways, for clients or your own company. This course is great for anyone who has to analyse, digest and present large amounts of data as part of their role.

Who is eligible? 

D2N2 Digital Skills Academy is set up exclusively to help autistic individuals and women, particularly those who are returning to work after a period of absence, those out of work, and those looking for another role/or to progress within their existing organisation.

Course Outline 

Day 1: Introducing Power BI

  • Setting up Power BI Service, Power BI Desktop and SQL Server Development Studios

  • Connect to the Azure Adventureworks Data Warehouse

  • Basic Transformations in Power Query Editor

  • Changing datatypes and working with dates

  • Power Desktop modelling

  • Optimising models for reporting

  • Creating calculated measures

  • Creating and managing hierarchies

 

Day 2: Power BI Desktop Visualisation

  • Understanding hierarchical axis and concatenating

  • Applying Filters

  • Producing Bar and Clustering charts

  • Understanding and using Slicers

  • Working in Focus Mode

  • Establishing Map visualisations

  • Establishing Gauge charts and KPI

  • Woring with Multiple visualisations

 

Day 3: Working with Power BI Service

  • Uploading to Power BI Service
  • Quick insights
  • Configuring a dashboard
  • Sharing a dashboard
  • Pinning a live page
  • Custom URL
  • Printing a Dashboard
  • Exporting to csv and Excel
  • Power BI Notifications
  • Alerts in the Power BI Service

 

Day 4: Working with Excel

  • Importing Excel data using simple data
  • Excel workbook with the Excel data model
  • Connecting to Excel via one drive
  • Managing Query Groups
  • Transforming Less Structured Data
  • Pivot/Unpivot/Transpose

 

Key training course outcomes

  • Greater understanding of the fundamentals of Power BI
  • Gain experience in using Power Query Editor
  • To create visualisations to provide further insight into data
  • Gain confidence in technical terms with Power BI and Power BI Service

 

Desired skills required

The successful applicant will have a thorough understanding of computer systems and applications, be familiar with file management, word processing and spreadsheet systems, have excellent written skills.

 

  • Excellent analytical skills
  • Ability to work with large amounts of information and see the ‘bigger picture’
  • Comfortable with juggling facts, figures and numbers
  • Critical thinking: able to look at numbers, trends, and data and come to new conclusions based on the findings
  • Attention to detail
  • Excellent maths skills

Personal Attributes 

  • Dynamic, intelligent and passionate about all things digital
  • To be thorough and pay attention to detail

 

Find out more click HERE and book your place – space is limited

Call us on 0333 320 0333 ext. 2153

Email digitalacademy@emc-dnl.co.uk

If you wish to contact Autism East Midlands directly about  this programme, please call Angela Gardner on 01909 506678 
 ext. 222 or email enquiries@autismeastmidlands.org.uk

 


Book Now