Data Analysis

Leverage data analytics techniques to enhance your technical abilities, make better business decisions and influence organisati...

£650

Courses
You are here: / / / Data Analysis

Leverage data analytics techniques to enhance your technical abilities, make better business decisions and influence organisational strategy. Over four modules, you will develop a solid foundation in the principles and techniques of data analysis and learn how to produce accurate information about performance, productivity, quality, trends and forecasts. Find out how to use SQL to extract data. Discover how to use Excel to collate, manipulate and draw valuable insights from data from multiple sources. The course is specifically designed for non- technical business professionals such as NHS RTT Specialist, information Analyst, marketing, sales, HR, operations and product managers

There are no prerequisites to this course. New starters are welcome

  •  Pre-reading and intermodular work required.
  • Participants need to bring their own laptops to all sessions with MS Excel installed. A series of databases will be loaded onto your machine for you to practice sample scenarios in class and between sessions.
  • Free 5 hours mentoring services included in the course s

Day 1: Data analysis principles

  • The Organisational structure
  • Need and Impact analysis into an organisation
  • Role of data analyst in an organisation
  • Expected deliverables from a data analyst
  • Data analysis lifecycle
  • Data understanding techniques
  • Data manipulation techniques
  • Data interrogation techniques
  • Identification of trends and patterns
  • Drilling down / Rolling up data
  • Presenting data using chart
  Day 2: Microsoft Excel to Analyze Data
  • Excel as a modelling/analytical/data visualisation tool
  • Review of 12 Functions specifically for Data analysis.
  • Pivot tables; business measurement / business description
  • Manipulating data in Excel
  • Drill down/rolling up data in Excel
  • Presenting data in Excel for specify business users
  Day 3: Analyzing data using a database/SQL
  • Introduction into relational modelling
  • Introduction into database structure
  • Introduction into Structured Query Language
  • Writing simple/ complex SQL queries
  • Manipulating data in a database
 

Delegates will have relevant skills and experience of managing a team and delivering a project from start to finish.

  • IT Project Manager, or
  • Project Manager in other fields based on previous experience.

  • TITLE
    Data Analysis
  • DURATION
    3 intensive weekends
  • TYPE
    This course is offered in class
  • PRICE
    £650.00

UPCOMING SESSIONS

No Sessions found.

ENROLL NOW £650

ENROLL

Payment will allow you book an upcoming Batch.

Related products

Microsoft SharePoint Microsoft Excel