Data Analytics & Literacy Fundamentals

On completion of this training, attendees will be able to:
• Understand how to apply processes, tools, roles & responsibilities, collaboration, risk & expectation management to build effective data programs.
• Understand the type of questions that are increasingly being answered by Data Analytics platforms and tools that can add value to their organisation.
• Understand how to harness a leading data analytics tool to answer the questions relative to the organisation in a data rich world.
• Start the collaborative conversations between data and different teams across an organisation on how data might and / or should be used in the organisation to make better decisions.

Day 1: Intro to Data Analytics & Literacy
• Lesson 1:
o The data world
o The crowded vendor spaces.
o Generative AI, its implications and implementation challenges
• Lesson 2:
o Modern Data Analytics Use Case approaches
o Delivery Methodology & Collaboration
• Lesson 3:
o Modern Data Architectures
o Microsoft Analytics Technology Stack
o Microsoft Power BI
o Microsoft Power BI Service
• Group & Individual Exercise
o What is the right business Question?
o What expertise & Team do you need?

Day 2: Get to know your data
• Lesson 1:
o Power BI Power Query
o Clean your data
o Using visuals to assess data quality
• Lesson 2:
o What to look for in your data with Power BI
o Transform your data in Power BI – creating your analytical base table (ABT)
o Classified and Unclassified data
• Group & Individual Exercise
o Load your data
o What visuals would you use to describe your data in Power BI?

Day 3: Model your data
• Lesson 1
o Business to Data Understanding
o Initial statistical investigative techniques
o Business Question to model mapping
• Lesson 2:
o What can Power BI do?
o What can Power BI not do?
o Using analytical visualisations
• Group & Individual Exercise:
o Load more data in Power BI
o Choose your analytical models
o Present your analytical models

Day 4: Present your data
• Lesson 1:
o Know your audience
o Preparing your data to present to your audience
o What insight can your data give?
o What action do you want your audience to take?
• Group & Individual Exercise:
o Load New data to Power BI
o Agree on the business question
o Assess the data
o Present your analysis

Day 5: Workshop
• Bring your own data
• What are your questions?
• Can you load your data?
• How good is your data?
• Can Power BI help answer your questions?

Participants are required to have at least a trial version of Power BI desktop tested and working on their laptop in advance of the course.

A short list of industry white papers will be provided to give delegates a background on the course material. A solid familiarity with Excel and PowerPoint is required.

NB: A link will be sent via email to a Power BI Tutorial that course attendees will be expected to view in advance of the training. This is an important requirement to ensure that all delegates have a baseline familiarity with the context of the course and Power BI in advance.

More expert level workshops and project mentorship are available on demand.

Expleo Academy is happy to discuss your specific training needs to advise on your optimal learning pathway.

This course is tailored for a diverse range of professionals – from senior executives to junior staff members – who are eager to harness the power of data to enhance business decision making. Whether you are a tech enthusiast or a business leader, this course is your stepping stone towards becoming data-savvy professional.