Data Analysis
Leverage data analytics techniques to enhance your technical abilities, make better business decisions and influence organisati...
£650
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
- 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
- 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.
Lesson # | Date | Time |
---|---|---|
No Lessons added yet! |
-
TITLEData Analysis
-
DURATION3 intensive weekends
-
TYPEThis course is offered in class
-
PRICE£650.00
UPCOMING SESSIONS
No Sessions found.