Data Analysis and Visualisation Bootcamp

7

Modules

5 - 8

hours per week

10

weeks

R8 044.25

Price (inc vat)

English

Language

Share this course

Course Information

The delivery consists of online modules with virtual facilitator-based sessions also referred to as subject matter expert sessions.

Content has been grouped together for example students will complete 3 online sessions om MS excel and this will be followed up by a subject matter expert group discussion.

In summary students can expect do between 5 (five) and 8 (eight) hours of online learning per week.

Total estimated online learning is 56 (fifty-six) and Subject Matter Expert sessions spans across 14 (fourteen) hours.

Language: English

Course Overview

All this data, but do your people know how to analyse and interpret it? Most importantly, can your people visualise data and tell compelling business stories for budgeting, project management, sales, customer centricity and customer satisfaction?


Today we are flooded with so much data in our systems. Every manager now needs to know how to analyse the data for insights, highlights and outliers and then produce graphical representation of information and data. By using visual elements like charts, graphs and maps, data visualisation tools provide an accessible way to see and
understand trends and patterns in data. Essentially it helps you tell stories with raw data to make better business decisions.


This 10-week programme will assist your teams in creating world class reports using Microsoft Excel and Microsoft Power BI. Your learners will get access to a learning platform, eLearning, virtual facilitator (Subject Matter Expert) sessions, a practical environment, group discussions, implementation-driven assignments, and model answers.It is the first step towards being able to use tools like Microsoft Excel and Power BI to analyse data whilst exposing students to two critical building blocks, namely Storytelling
and Data Visualisation.

Course outcomes

Course outcomes

The ability to analyse data effectively has become of utmost importance in orginisations. Various reports, including one from Datumize quotes that should organisations be able to make only 10% of data usable, then the return will imply significant increases in profitability and decision making. 

This programme is the first step in being able to use tools like Microsoft Excel and Power BI to analyze data. It also exposes students to two critical building blocks being Storytelling and Data Visualization.

Attendees will thus on completion of the programme be able to:

Play Video

Course Curriculum

· Data – a showcase

· Importance of Data

· What can you do with Data Analysis?

· Exploring Fundamental

· Data Concepts and the value of Analytics Literacy

· Data Literacy for All

· Complete Guide to Excel 365: Getting Started

· Excel 365: Working with Charts & Sparklines

· Excel 365: Using Formatting, Styles, & Themes

· Excel 365: Linking, Printing, & Protecting Workbooks

· Excel 365: Validating, Cleaning, & Performing Lookups on Data

· Excel 365: What-If Analysis, Solver, & Analysis ToolPak

· Excel 365: Pivot, PowerPivot, & Financial Modelling

· Examination

  • Data Visualisation: Best Practices for Creating Visuals
  • Excel Visualisation: Getting Started with Excel for Data Visualisation
  • Excel Visualisation: Building Column Charts, Bar Charts, & Histograms
  • Excel Visualisation: Visualising Data using Line Charts & Area Charts
  • Excel Visualisation: Plotting Stock Charts, Radar Charts, Treemaps, & Donuts
  • Excel Visualisation: Building Box Plots, Sunburst Plots, Gantt Charts, & More
  • Examination
  • Secrets of MS Excel

· Explore what Power BI can do for you

· Create and share your first Power BI report

· Get started building with Power BI

· Analyse data with Power BI

· How to build a dashboard

· Power BI Bootcamp: Session 1

· Power BI Bootcamp: Session 2

· Power BI Bootcamp: Session 3

  • Creating and Editing Macros in Excel 365

What people are saying

Course Lecturer

Francois Timms
Francois is senior facilitator at LRMG with more than 30 years’ experience in the field. He has also worked as a database developer and a business intelligence consultant in the past which enabled him to bring real-world experience, challenges and solutions to the classroom. He has extensive knowledge and experience with MS Excel, including VBA programming (Visual Basic for Applications). In addition, he is also a database specialist with specific focus on, but not limited to, MySQL and Oracle Database, and his skills include database management, database development and database analytics. During his career he was awarded several vendors awards which serves as a testament to his passion for his craft.
Carol Lippert
Carol has worked in the IT training space for over 20 years. She is a Microsoft Certified Trainer and a Microsoft Office Specialist. Carol has worked with various clients to identify their training needs around Office 365 and how best to deliver that training. She has also created dashboards and reports using a combination of Excel and Power BI.
Previous slide
Next slide

Are You Ready To Start?

Eloise Engelbrecht Business Development Consultant EloiseE@lrmg.co.za
Need addition inform? request a Call Back , alternatively  Download Course Information.

Fill in the form below and we will give you access to this exciting resource

Fill in the form below and we will give you access to this exciting resource

Fill in the form below and we will give you access to this exciting resource

Fill in the form below and we will give you access to this exciting resource.

Fill in the form below and we will give you access to this exciting resource

Fill in the form below and we will give you access to this exciting resource

Fill in the form below and we will give you access to this exciting resource

Fill in the form below and we will give you access to this exciting resource

Fill in the form below and we will give you access to this exciting resource

IGNITE

Career Dreams

Fast track career growth in the new world of work:

Certified learning paths that build relevant skills and competencies

Invigorate your skills development offering:

University-certified online and blended short learning courses

Rapidly improve your scorecard metrics:

B-BBEE (South Africa) and other scorecard solutions

Trusted certification:

Digitally enabled learning solutions supported by dedicated teams of Wits, Queen's University Belfast, UFS and GIBS academics and experience managers

Real-world scarce skills training for youth:

Find, recruit and custom train youth to your demand-led specs, getting them work-ready and employable

Learnerships:

We find the talent, match personalities and abilities to your culture fit, and then train them to meet your digital skills needs

Comply with your B-BBEE, transformation and skills levy agenda:

Rapidly improve your scorecard metrics: create a talent pipeline for 4IR, ICT and Tech-future Skills

Work-ready graduates and interns:

We find the candidates (or you find them). We train them to use your technology and digital systems within the defined roles

GROW

Sales and Unlock Customer Value

Discover why your customers buy what they buy:

Learn to meet customers’ social, emotional and functional requirements

Activate and strengthen sales team engagement:

Digital sales activation challenges

Cultivate a performance-based sales culture:

Sales leadership and culture solutions

Mobilise the right sales strategy:

Sales strategy validation and optimisation

Accelerate sales pipelines and spark growth:

Customer-centric sales strategy

Grow and sustain critical sales capabilities:

Digital learning content for Sales

INSPIRE

People Productivity

Engage for sustainable high performance:

Human capital strategy, learning strategy and transformation

Future-fit your organisation for success:

Learning and talent assessments, talent management and people balance sheet planning

Connect learning journeys to performance outcomes:

Onboarding, talent development and learning mapped to your individual and company needs

Move the needle on learning experiences:

Smart learning and talent experience platforms, tools and digital learning assets

Upskill people with new digital smarts:

Digital learning content (customised or plug-and-play)

NURTURE

A Performance Culture

Talent management:

Make better future-fit data-driven decisions for your talent and organisation

Strategy and change:

Inspire your people to change and ignite their passion to deliver business results

Leadership and culture:

Enable your leadership teams to create their unique brand and to build new high-performance habits and behaviours

Digital transformation:

Enable people processes through digital technologies that transform performance

Talent assessments:

Better understand your people's strengths and your team’s productive habits to compete and win

Performance enablement:

Create a culture of feedback that actively measures performance

SHIFT

Leadership Perspectives

Establish a high-performance culture:

Interactive multimedia inspirational stories

Unlock new thinking and shift mindsets:

More than 13 intriguing true stories of high performance

Empower leaders and teams:

Expertly facilitated moderated conversations

Build new habits for high performance:

Smart toolboxes to activate habits for success