Academy

Data Analysis and Visualisation Bootcamp

Analyse, interpret and visualise it! Helping organisations make better business decisions

Impactful - IT Capability Academy - Data Analysis and Visualisation Bootcamp

7

Modules

5 - 8

Hours/Week

10

Weeks

R8 044.25

Price (Inc VAT)

English

Language

Academies’ 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

Academy 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.

Academy Outcome

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:

  • Accurately analysing data with MS Excel and PowerBI
  • Understanding the principles of Data Visualization and best practices
  • Effectively communicating the narrative presented by the data
  • Appreciate the interaction between the system and its environment

Academy 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 Modeling
  • Examination
  • Data Visualization: Best Practices for Creating Visuals
  • Excel Visualization: Getting Started with Excel for Data Visualization
  • Excel Visualization: Building Column Charts, Bar Charts, & Histograms
  • Excel Visualization: Visualizing Data using Line Charts & Area Charts
  • Excel Visualization: Plotting Stock Charts, Radar Charts, Treemaps, & Donuts
  • Excel Visualization: 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
  • Analyze data with Power BI
  • How to build a dashboard
  • Power BI Bootcamp: Session 1
  • Power BI Bootcamp: Session 2
  • Power BI Bootcamp: Session 3
  • Bootcamp 1 to 4
  • Creating and Editing Macros in Excel 365

Price: R15237.50 (inc. VAT)

L ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Get in touch

Sabelo Mtshali
New Business Activator sabelom@lrmg.co.za
Contact the Impactful team if you need any assistance.

Academy 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

Academy 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.

Academy Outcome

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:

  • Accurately analysing data with MS Excel and PowerBI
  • Understanding the principles of Data Visualization and best practices
  • Effectively communicating the narrative presented by the data
  • Appreciate the interaction between the system and its environment

Academy 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 Modeling
  • Examination
  • Data Visualization: Best Practices for Creating Visuals
  • Excel Visualization: Getting Started with Excel for Data Visualization
  • Excel Visualization: Building Column Charts, Bar Charts, & Histograms
  • Excel Visualization: Visualizing Data using Line Charts & Area Charts
  • Excel Visualization: Plotting Stock Charts, Radar Charts, Treemaps, & Donuts
  • Excel Visualization: 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
  • Analyze data with Power BI
  • How to build a dashboard
  • Power BI Bootcamp: Session 1
  • Power BI Bootcamp: Session 2
  • Power BI Bootcamp: Session 3
  • Bootcamp 1 to 4
  • Creating and Editing Macros in Excel 365

Are you ready to start?

Certified global best practices in the new technologies…

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.