Latest News

14 Sep

Integrated Transport Planning is the Chamber’s Nottinghamshire Business of the Year

Integrated Transport Planning is the Chamber’s Nottinghamshire Business of the Year

09 Sep

Bloc Digital is the Chamber’s Derbyshire Business of the Year

A specialist in the creation and re-use of digital information has won the East Midlands Chamber Derbyshire Business of the Year Award 2019.

03 Sep

Women in Leadership course – September 2019

Nottingham Business School are running two 3-day courses in September that focus on women in small and medium-sized enterprises (SMEs) who want to progress into senior or leadership roles.

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