Data Extraction PowerPoint Creation with activities for data students. Level 3 Apprenticeship - 3 or 4 hour powerpoint
Budget: £20 – £100 GBP
I require a PowerPoint presentation on the topic of data extraction,. The ideal candidate will have:
- Proficiency in PowerPoint and teaching material creation
- Experience in Data extraction / Excel / Power Query / API's
- A strong understanding of intermediate data extraction concepts and techniques, including case studies
The presentation should be designed for static slides, with text and images. You're expected to:
- Cover intermediate data extraction concepts comprehensively, with practical examples and case studies and activities for the student to do it Excel.
- Make it UK-centric if possible
- Ensure the material is engaging and easy to understand
- Provide a clear, structured PowerPoint presentation.
some ideas:-
Guide students on using Excel's Power Query to extract data from external sources such as databases, websites, or APIs.
Demonstrate techniques to merge and consolidate data from different worksheets or workbooks using Excel's Power Query or VLOOKUP functions.
Showcase the use of Excel's data formatting tools to ensure consistent formatting across multiple data sources.
Please bid if you're confident in your ability to deliver on these requirements.
Powerpoint appearance and style not important, as I will do that myself at the end
Some of the knowledge, skills and behaviours the content could cover:-
The Knowledge, Skills, and Behaviors (KSBs) relevant to a module called "Data Extraction and Access" are detailed in the document you provided. Here are the key KSBs relevant to this module:
Knowledge
K2: How to access and extract data from a range of already identified sources.
K3: How to collate and format data in line with industry standards.
K6: How to undertake blending of data from multiple sources.
K7: Algorithms, and how they work using a step-by-step solution to a problem, or rules to follow to solve the problem and the potential to use automation.
K8: How to filter details, focusing on information relevant to the data project.
K9: Basic statistical methods and simple data modeling to extract relevant data and normalize unstructured data.
Skills
S1: Source and migrate data from already identified different sources.
S2: Collect, format, and save datasets.
S3: Summarize and explain gathered data.
S4: Blend data sets from multiple sources and present in format appropriate to the task.
S5: Manipulate and link different data sets as required.
S6: Use tools and techniques to identify trends and patterns in data.
S7: Apply basic statistical methods and algorithms to identify trends and patterns in data.
S8: Apply cross-checking techniques for identifying faults and data results for data project requirements.
S9: Audit data results.
S16: Clean data i.e., remove duplicates, typos, duplicate entries, out-of-date data, parse data (e.g., format telephone numbers according to a national standard) and test and assess confidence in the data and its integrity.
S18: Prioritize within the context of a project.
Behaviors
B2: Work independently and take responsibility.
B3: Use own initiative.
B4: A thorough and organized approach.
- Proficiency in PowerPoint and teaching material creation
- Experience in Data extraction / Excel / Power Query / API's
- A strong understanding of intermediate data extraction concepts and techniques, including case studies
The presentation should be designed for static slides, with text and images. You're expected to:
- Cover intermediate data extraction concepts comprehensively, with practical examples and case studies and activities for the student to do it Excel.
- Make it UK-centric if possible
- Ensure the material is engaging and easy to understand
- Provide a clear, structured PowerPoint presentation.
some ideas:-
Guide students on using Excel's Power Query to extract data from external sources such as databases, websites, or APIs.
Demonstrate techniques to merge and consolidate data from different worksheets or workbooks using Excel's Power Query or VLOOKUP functions.
Showcase the use of Excel's data formatting tools to ensure consistent formatting across multiple data sources.
Please bid if you're confident in your ability to deliver on these requirements.
Powerpoint appearance and style not important, as I will do that myself at the end
Some of the knowledge, skills and behaviours the content could cover:-
The Knowledge, Skills, and Behaviors (KSBs) relevant to a module called "Data Extraction and Access" are detailed in the document you provided. Here are the key KSBs relevant to this module:
Knowledge
K2: How to access and extract data from a range of already identified sources.
K3: How to collate and format data in line with industry standards.
K6: How to undertake blending of data from multiple sources.
K7: Algorithms, and how they work using a step-by-step solution to a problem, or rules to follow to solve the problem and the potential to use automation.
K8: How to filter details, focusing on information relevant to the data project.
K9: Basic statistical methods and simple data modeling to extract relevant data and normalize unstructured data.
Skills
S1: Source and migrate data from already identified different sources.
S2: Collect, format, and save datasets.
S3: Summarize and explain gathered data.
S4: Blend data sets from multiple sources and present in format appropriate to the task.
S5: Manipulate and link different data sets as required.
S6: Use tools and techniques to identify trends and patterns in data.
S7: Apply basic statistical methods and algorithms to identify trends and patterns in data.
S8: Apply cross-checking techniques for identifying faults and data results for data project requirements.
S9: Audit data results.
S16: Clean data i.e., remove duplicates, typos, duplicate entries, out-of-date data, parse data (e.g., format telephone numbers according to a national standard) and test and assess confidence in the data and its integrity.
S18: Prioritize within the context of a project.
Behaviors
B2: Work independently and take responsibility.
B3: Use own initiative.
B4: A thorough and organized approach.