Our Workshops

Description

Data Modelling & Analytics With Excel and Power BI

2-Day Workshop

Our Microsoft workshop presenters are Microsoft Certified Trainers as well as Microsoft Certified Technology Specialists

What Is Data Analytics

The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision making.

With more and more businesses relying on statistical analysis to drive decision-making, the ability to extract meaning from data has become a highly valued skill. Data analysts play a key role in helping business leaders make informed choices, distinguish between effective and ineffective practices, cut costs, and solve key problems – they are, therefore, an integral part of any successful organisational team.

Excel

Data Analytics is a growing field in an increasingly data-driven world. Excel has tools to organize data and all professionals need to know how to add these skills to their toolset to drive insight and deliver results to the business.

Learn how data is collected, stored, organised, analysed, and interpreted.

Learn about the functions in Excel that assist in the cleaning up of text and time/date data generated in the activities of business.

The functions that facilitate relevant and accurate analysis of the data, leading to a presentation of worthwhile and applicable information.

The demonstration and application of appropriate shortcut keys, workbook and worksheet design specifically for large amounts of text data as experienced in the administrating of business, as well as the generation of dashboard elements such as charts and pivot tables.

Including External Data

Clean Up

Organised Structure

Creating Information

At a glance

Dashboard Elements

What is Power BI?

These Challenges Can Be Met Thanks To Power BI

Management of Multiple Data Sources

Provide The Right Data To The Right Users At The Right Time

Get ready to connect to the ever-expanding world of data

 Understand how to use Power BI Online and Power BI Desktop

• Perform Big Data Analytics using Real World Scenario
• Transform Big Data and customize
• Create Powerful Visualization based on Big Data
• Sharing Dashboard with other users by emailing them directly or creating a URL link
• Ask questions from Big Data in plain English language
• Download Power BI Desktop
• Create an online account for Power BI Online

______________________________________________________________________________________________________________________________________________________________

On-Site Workshops

• All workshops are offered in-house at your offices to a minimum of 5 delegates
• You provide the venue and refreshments, Front Foot supply all the workshop material – including laptops for computer-based training sessions

 Remote Workshops

• All workshops are offered remotely to a minimum of 5 delegates
• Front Foot supply all the electronic workshop material

_______________________________________________________________________________________________________________________________________________________________