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

Fast track career growth in the new world of work

Accredited learning paths that build relevant skills and competence

Invigorate your skills development offering

University-accredited online and blended short courses
 

Rapidly improve your scorecard metrics

B-BBEE (South Africa) and other scorecard solutions

Trusted accreditation in the palm of your hand

Digitally enabled learning solutions supported by a dedicated team of Wits academics and experience managers

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

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 individual and company needs

Shift 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)

Make better future-fit talent decisions

Talent Management

Get passionate about results

Strategy and Change

Nurture the right habits and behaviours

Leadership and Culture

Innovate and accelerate the future

Digital Transformation

Play your people to their strengths

Talent Assessments

Ignite high performance

Performance Enablement

Awaken the spirit of high performance

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