Course description
The world is becoming more and more data-driven, with endless amounts of data available to work with. Big companies like Google and Microsoft use data to make decisions, but they’re not the only ones.
Data analysis is used also by small businesses, retail companies, in medicine, and even in the world of sports. It’s a universal language and more important than ever before. It seems like an advanced concept but data analysis is really just a few ideas put into practice.
Data analysisisimportantin business to understand problems facing an organisation, and to exploredatain meaningful ways. Datain itself is merely facts and figures.Data analysisorganises, interprets, structures and presents thedatainto useful information that provides context for thedata.
The main purpose of the Data Analysis Fundamentals training course is to give the attendees a practical knowledge and good understanding of real-world data analysis . The course includes data analysis process, visualisations, data sharing, and creating professional and easy to understand dashboards.
Upcoming start dates
Upcoming start dates
Suitability - Who should attend?
Data Analysis Fundamentals training course, is ideal for :
- Data architects
- Data scientists
- Data analysts
- Accounting and finance professionals, especially those interested in learning and applying data analysis techniques to help their organizations make informed, data-driven business decisions.
Outcome / Qualification etc.
At the end of the Data Analysis Fundamentals training course, PartiPnt will be able to :
- To provide delegates with both an understanding and practical experience of a range of the more common analytical techniques and representation methods for numerical data.
- To give delegates the ability to recognize which types of analysis are best suited to particular types of problems.
- To give delegates sufficient background and theoretical knowledge to be able to judge when an applied technique will likely lead to incorrect conclusions.
- To provide delegates with a working vocabulary of analytical terms to enable them to converse with people who are experts in the areas of data analysis, statistics and probability, and to be able to read and comprehend common textbooks and journal articles in this field.
- To introduce some basic statistical methods and concepts.
- To explore the use of Excel 2010 or 2013 for data analysis and the capabilities of the Data Analysis Tool Pack.
Training Course Content
Day 1
Introduction to data analysis solutions
- Recognize the Value of Using Data to Answer Questions and Address Business Issues
- Explain How Data Has Become the Strategic Business Asset It Is Today
- Data analytics and data analysis concepts
- Introduction to the challenges of data analytics
- Volume – data storage
- Introduction to Amazon S3
- Introduction to data lakes
- Introduction to data storage methods
Day 2
Velocity – data processing
- Discover Usable Data: Its Source, Type, Value, Quality, Location, and Relationships
- Profile the Data to Determine What Is Important or Relevant
- Organize and Manage Data Appropriately
- Acquire Data from Any Source
- Introduction to data processing methods
- Introduction to batch data processing
- Introduction to stream data processing
Day 3
Variety – data structure and types
- Introduction to source data storage
- Introduction to structured data stores
- Introduction to semistructured and unstructured data stores
- Identify and Resolve Problems Associated with Data Collection
- Articulate the Pros and Cons of Data Manipulation
- Determine If Data Samples Are Adequate
- Create a Table That Is Ready to Be Analyzed
Day 4
Value. Reporting, business intelligence and Analyzing the Data
Introduction to analysing data
Introduction to visualizing data
Understand Which Data-Analysis Tools Best Answer Common Analytical Business Questions
Articulate How the Microsoft® Excel Analysis ToolPak and Other Programs Can Be Used for Advanced Data Analysis
Choose the Appropriate Tool and Technique to Analyze Your Data
Putting the pieces together
Day 5
Veracity – cleansing, transformation
Understanding data integrity
Understanding database consistency
Introduction to the ETL process
Request info
London Premier Centre
London Premier Centre is a UK leading training provider based in London and specialises in international short courses. Our inspiring, comprehensive portfolio of more than 400 professional development courses and seminars covers a wide range of professions from Administration, Leadership,...