Data Analysis for Beginners
- Descrição
- Currículo
- FAQ
- Revisões
This unique Data Analyst course is meticulously designed to provide you with the precise skills needed to excel in the field without drowning you in unnecessary tech jargon. From the fundamentals to advanced techniques, you’ll gain hands-on experience in data analysis, visualisation, and interpretation.
The course is split into three sections, Excel, Power BI and SQL. At the end of each section there will be a quiz where you can test your knowledge, there are practical coding exercises and a project at the end of the course.
The goal is to provide you with complete preparation and turn you into an Analyst ready for a Data Analyst job role. To take you there we’ll be covering the following topics extensively:
-
Analysing Data
-
Manipulating and cleaning Data
-
Using Vlookups, Pivot tables, charts and various functions in Excel
-
Building visualisations in Power BI
-
Using Power Query to automate data cleaning steps
-
Coding complex queries in SQL
-
Presenting Data
Unlike other courses, this course focuses solely on the skills demanded by the job market, ensuring you’re equipped with the practical knowledge to land your dream job as a Data Analyst. Whether you’re a beginner or an experienced professional looking to upskill, this course will empower you to navigate the world of data with confidence and efficiency. Join us and embark on a journey towards a rewarding career in Data Analysis.
-
2IntroductionVídeo Aula
-
3Downloading ExcelVídeo Aula
-
4Excel IntroductionVídeo Aula
-
5Active CellVídeo Aula
-
6Entering DataVídeo Aula
-
7Auto-FitVídeo Aula
-
8Auto-CompleteVídeo Aula
-
9Entering NumbersVídeo Aula
-
10Inserting & Deleting Columns/RowsVídeo Aula
-
11Auto SequencingVídeo Aula
-
12Navigating EdgesVídeo Aula
-
13Selecting CellsVídeo Aula
-
14Number FormattingVídeo Aula
-
15Numbers & FractionsVídeo Aula
-
16Currency & AccountingVídeo Aula
-
17PercentageVídeo Aula
-
18Date FormatVídeo Aula
-
19Time FormatVídeo Aula
-
20Data EntryQuestionário
Excel Data Entry Quiz
-
33Download FileVídeo Aula
-
34SignsVídeo Aula
-
35FunctionsVídeo Aula
-
36Auto-Sequence with calculationsVídeo Aula
-
37SUMVídeo Aula
-
38SUMIFVídeo Aula
-
39SUMIFSVídeo Aula
-
40COUNTVídeo Aula
-
41COUNTIFVídeo Aula
-
42COUNTIFSVídeo Aula
-
43MIN, MAX, AVERAGEVídeo Aula
-
44IF/ELSEVídeo Aula
-
45VLOOKUPVídeo Aula
-
46TRIMVídeo Aula
-
47LEFT/RIGHTVídeo Aula
-
48FINDVídeo Aula
-
49LEN/MIDVídeo Aula
-
50REPLACEVídeo Aula
-
51CalculationsQuestionário
Excel Calculations quiz