Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Data Analyst Skills Bootcamp

12 weeks programme. 10 x 1 day release mid-week or weekends Online Instructor Led, Online directed self-paced, practicals, assignments and online webinars

Description

During this course you will understand understand the different types of data, including open and public data, administrative data, research data, the data life cycle, differences between structured and unstructured data, the importance of clearly defining customer requirements for data analysis, quality issues that can arise with data and how to avoid and/or resolve these, steps involved in carrying out routine data analysis tasks and the range of data protection and legal issues.

Advancing to the fundamentals of data structures, database system design, implementation and maintenance, understanding an organisation's data architecture, analysing & visualising data with Excel, presenting visual insights with dashboards in Excel, performing statistical analysis, modelling and analysing data with Power Pivot.

Audience

Aimed for individuals wishing to follow these following roles:

Data Analyst, Departmental Data Analyst Problem Analyst, Junior Analyst, Marketing Data Analyst, Data Manager, Data Scientist, Data Modeller, Data Architect, Data Engineer

Curriculum

Data Analysis and Visualization with Microsoft Excel

 Course Objectives:

In this course, you will analyze and visualize data using Microsoft Excel and associated tools. You will:

  • Perform data analysis fundamentals.
  • Visualize data with Excel.
  • Analyze data with formulas and functions.
  • Analyze data with PivotTables.
  • Present visual insights with dashboards in Excel.
  • Create geospatial visualization with Excel.
  • Perform statistical analysis.
  • Get and transform data.
  • Model and analyze data with Power Pivot.
  • Present insights with reports.

BCS Data Analysis Concepts

Course Overview

On this course, you’ll explore different types of data; understanding the data life-cycle and learning the fundamentals of data structures. Our expert instructors will take you through the steps of carrying out routine data analysis task and database system design. You’ll also grasp:

  • The importance of clearly defining customer requirements for data analysis
  • Quality issues that arise with data and how to avoid and/or resolve these
  • The organisation’s data architecture
  • The range of data protection and legal issues
  • The importance of the domain context for data analytics

Why a career in technology?

The days of working in one industry in one role have passed. Statistically the typical worker changes their job around 12 times before they retire. This should be reassuring news if you’re contemplating a new career. If you’re looking to get into IT, you may be surprised at why people love it. Here are our top seven reasons to work in IT.

1. You don’t have to be a math whiz.

Contrary to popular belief, dedication and soft skills go a long way in making IT professionals successful. While technical skills are important, they can be learned more easily than a strong work ethic, a natural curiosity and the ability to work well with others. A person with dedication and motivation will take the initiative to learn hardware, cybersecurity, coding or whatever the technical skill may be that will help them move ahead. Millions of individuals working in tech have non-technical backgrounds,  it’s not just a skills gap, but a confidence gap, that’s affecting the IT workforce.

2. You’ll get to show off your creative side.

The most impactful IT workers are also often the most creative. Every day in IT, you’ll need to come up with innovative solutions to complex problems. And you often won’t arrive at those solutions through linear thinking alone. Creativity is the secret sauce that will help you meet your goals on a day-to-day basis.

3. A big part of your job will involve helping people.

Whether you’re helping people solve their daily technology problems or developing technology behind the scenes, a big part of your career will involve making other people’s lives simpler with your specialized knowledge. You'll work closely with others to understand the challenges they face and what they need technology to do. Your ability to problem solve and innovate will help them do their jobs better and help your organization to succeed.

4. There’s no shortage of IT jobs.

Job opportunities are endless for IT professionals with the right skills. Read about Microsoft Get On 2021 programme to understand the vast opportunities that lie ahead for the global workforce of the future, the need for IT workers will only grow. If you feel stifled in your career and feel like you don’t have enough opportunities to move up the ladder, consider expanding your opportunities in the IT realm..

5. IT pays well.

This is one of the major draws for many people who transition to careers in IT. Research available shows the average salary for an IT role is over £45K. As with any profession, there’s a wide range of salaries dependent on numerous factors, but it shows there’s ample opportunity for advancement in terms of both responsibility and salary.  

6. You’ll always be challenged.

The IT realm is constantly in flux in terms of innovation. As an IT professional, you’ll be expected to keep up with industry changes and new technology, which means there will never be a dull moment in your career. If you love learning and are up for a challenge, an IT job may be right up your alley.  

7. A variety of industries need people with your skills.

The sky’s the limit when it comes to where you’ll be able to find employment, and your opportunities won’t be limited to the corporate world. Nonprofits, health care organizations and universities all need smart people to join their IT teams. You’ll get to pick your own adventure and work in a field that you feel truly aligns with your interests.

No matter your reason, if you have an interest in IT, there is a way to get into it. Is IT right for you ? Either register for our information webinars related to the regional government funded programmes or register your interest in the specific bootcamp and one of our advisors will happily discuss how your skills could translate to an IT career.

 

Similar courses

Security in the Cloud, Where are we today, is my data secure in the cloud?

Cloud identity and access management, Data encryption in the cloud, Key management in the cloud, Data residency

More Information
Cloud First, Tools and tips to turn your on-premise focused IT department into a cloud first IT department.

Why is cloud first here to stay, Focusing on the user, Making use of open source and open standards, Sharing, Reuse and Collaboration, Tools to use in a cloud first world

More Information
DevOps, where to start? Tools and stratagems for those new to the DevOps world

The goals of DevOps, Building a DevOps culture, Continuous integration, delivery, and deployment (CI/CD), DevOps Tools

More Information
A lifetime of learning, Techniques and tools to assist you in making learning an on-going part of your life

Setting goals, Building a learning community, Keeping up-to-date with advances in technology, Becoming comfortable with saying “I don’t know” , Learning resources (tools and website to assist with learning)

More Information
AWS Cloud Practitioner Essentials

The fundamental-level full day course is intended for individuals who seek an overall understanding of the AWS Cloud, independent of specific technical roles. It provides a detailed overview of cloud concepts, AWS services, security, architecture, pricing, and support. It includes lab exercises reinforcing some of the core concepts of the lecture. This course also helps you prepare for the AWS Certified Cloud Practitioner exam.

More Information
AWS Security Essentials

This course covers fundamental AWS cloud security concepts, including AWS access control, data encryption methods, and how network access to your AWS infrastructure can be secured. Based on the AWS Shared Security Model, you learn where you are responsible for implementing security in the AWS Cloud and what security-oriented services are available to you and why and how the security services can help meet the security needs of your organization.

More Information
Migrating to AWS

Migrating to AWS focuses on planning and migrating existing workloads to the AWS Cloud. The course covers various cloud migration strategies with a detailed discussion on each phase of the migration process, including portfolio discovery, application migration planning and design, migration execution, and post-migration validation and application optimization.

More Information
Azure Fundamentals - Course AZ-900T01-A

This course will provide foundational-level knowledge of cloud services and how those services are provided with Microsoft Azure. The course can be taken as an optional first step in learning about cloud services and Microsoft Azure, before taking further Microsoft Azure or Microsoft cloud services courses.

More Information
Microsoft 365 Fundamentals - Course MS-900T01-A

This course provides foundational knowledge on the considerations and benefits of adopting cloud services and the Software as a Service (SaaS) cloud model, with a specific focus on Microsoft 365 cloud service offerings. You will begin by learning about cloud fundamentals, including an overview of cloud computing and specifically Microsoft cloud services. You will be introduced to Microsoft Azure, and you will examine the differences between Microsoft 365 and Office 365

More Information
Microsoft Dynamics 365 Fundamentals - Course MB-901T00-A

This course provides learners with a broad overview of Dynamics 365 applications. We will introduce you each of the applications, articulate their business value, and discuss and demo core functionality. We will cover Dynamics 365 security, reporting, and familiarize you with data and product integrations available

More Information
Secrets to Successful Cloud Transformations

In this course, you will learn how to select the right strategy, people, migration plan, and financial management methodology to move your workloads to the AWS Cloud. You will learn how to build a holistic cloud adoption plan and how to hire people to execute that plan. You will learn best practices for choosing workloads to migrate from your on-premises environment to AWS. You will also learn best practices for managing your AWS expenses and dealing with internal chargebacks. This course focuses on the business aspects of cloud transformation, rather than the technical aspects

More Information
AWS Hybrid Network Connectivity

During this course learners will be taught key AWS technologies that they will need to master to connect their networks with AWS. Learners will be taken on a journey from isolated VPCs to highly available hybrid architectures. This course will cover topics such as site-to-site VPNs using virtual private gateways and transit gateways, connectivity using AWS Direct Connect, security for hybrid connections and billing.

More Information
Exam Readiness: AWS Certified Solutions Architect – Professional

Get exam ready for the AWS Certified Solutions Architect - Professional certification with senior instructor, Mike Brown.

More Information
Exam Readiness: AWS Certified Solutions Architect – Associate

Get the exam support you need to achieve your AWS Certified Solutions Architect Associate certification.

More Information
Running Container-Enabled Microservices on AWS

Running Container-Enabled Microservices on AWS is designed to teach you how to manage and scale container-enabled applications by using Amazon EC2 Container Service (ECS). The course highlights the challenges of running containerized applications at scale and provides guidance on creating and using Amazon ECS to develop and deploy containerized microservices-based applications

More Information
Building a Serverless Data Lake on AWS

In this one-day, advanced course, you will learn to design, build, and operate a serverless data lake solution with AWS services. This course will include topics such as ingesting data from any data source at large scale, storing the data securely and durably, enabling the capability to use the right tool to process large volumes of data, and understanding the options available for analysing the data in near-real time

More Information
Which Cloud Provider? Overview of home working and cloud services that support home working

Types of homeworking Benefits of homeworking Consideration of homeworking for employers Connectivity for home workers Collaboration tools for home workers Security of data when working from home

More Information
Protect your Microsoft cloud identities

We are living unprecedented times. Every day we are learning new ways of working and interacting with each other’s and of course this also applies to the workforce. Hackers are also finding new ways of “working” and are taking advantage of the lack of well configured and prepared Systems. Spoofing, phishing are very know terms for IT Professionals and we get surprise by how so simple some attacks against identities are. Still users fall for then. There is a lot of awareness to be made on the user side, nevertheless we, IT Professionals should prevent this. In this Firebrand One I will share the best practices I have been advising customers around to world to protect their identities. We will speak and demo features like MFA, Self-password reset, Conditional access, PIM, FIDO, …. Join us and see how you can provide a safe cloud identity infrastructure to your users.

More Information
Cryptography in a day.

Demistifying the concepts of cryptography and PKI in the working environment and beyond.

More Information
Network Security for the Non-technical

Get a FREE Introduction to Network Security in just half a day.

More Information
User Training and Awareness Sessions - The Good, The Bad and The Ineffective

In this 3-hour webinar, you'll explore how to make your users aware and stay aware of security risks that consistently evolve and circulate.

More Information
Introducing AWS

This course will introduce learners to AWS and the key services that most AWS cloud projects use. During this course learners will be taught about AWS identity and access managment (IAM), Elastic Compute Cloud (EC2) virtual machines, intro to AWS networking, Billing, Storage and an introduction to AWS database services.

More Information
So, you want to pass the AWS Solutions Architect Associate exam?

In this half day session we will cover exam techniques, we will go through the Solutions Architect Associate exam overview (publicly available) we will discuss booking an online exam and the process on the day. We will highlight key exam topics before finishing the session with an exam focused Q&A. We will also explain the next levels of certification and how they can be achieved by learning at Firebrand.

More Information
How statistics are used in modern businesses

How statistics are used in modern businesses - How statistics and correlation of data can assist a modern business

More Information
Introduction to Machine Learning (ML)

Get a FREE introduction to Machine Learning (ML).

More Information
Foundation Data Science Understanding

Foundation Data Science Understanding - What is DS, how is it being used in business today, what terms to look out for, how to commission some DS work

More Information
Deploy to Kubernetes with Azure DevOps

A good CI/CD pipeline is indistinguishable from magic - you commit your code and 2 minutes later the new version of your application is running. Don't believe that you can learn Kubernetes magic in two hours? Challenge accepted, join this course and we'll show you how you can automate a multi-stage docker build and kubectl deployment in just that long.

More Information
Kubernetes routing in the cloud: How to expose your service to the public

You can spin up an AKS cluster and publish a service literally in minutes but hosting a production-grade application will take a little more than that. This course offers a deep dive into kubernetes Services, Ingress Controllers and load balancing.

More Information
Final Exam Q&A Prep for your CCNA

All CCNA related topics - The idea is to prepare students 2 weeks out from their exam, by providing an online Q&A session.

More Information
Cisco SD-Access in a nutshell

Defining the benefits of SD-Access over traditional campus networks - identifying the core SD-Access components.

More Information
Understanding Data Science for Decision Makers

Course Description: DSBIZ (DSZ-110) – CertNexus’ newest THINK level offering – is a credential that offers business leaders, sales and marketing managers, project managers, and other business stakeholders a streamlined course to help make decisions and drive organizational data science strategies. DSBIZ candidates will learn data science concepts, methods of use, plus the challenges and benefits using relative business examples. Successful candidates will earn a DSBIZ digital badge which can be shared via a number of social platforms.

More Information
Why invest in Enterprise Architecture

“In business, you’re either growing or you’re decaying: there’s no middle ground. If you’re standing still you’re decaying.” Alan Arkin. The business world is deterministic – that is to say, every cause has an effect. It is also very complex. The combination of determinism and complexity is chaos and chaotic systems are not readily predictable. What we do know is that to thrive a business must address the perceived threats. We have Security people to address security threats by adjusting the Security Architecture – analogously we are adjusting for Privacy threats and generally we evolve by adjusting for different commercial threats. These include new laws and regulations, process and quality improvements by competitors and a whole myriad of other external changes that threaten our corporate well-being. Understanding how to accommodate responses to subtle threats within our complex corporate environment requires a dispassionate and holistic view which is not easy when it feels like fire-fighting. The role of the Enterprise Architect is to support continuity of business whilst analysing and understanding these threats, then design optimal system modifications to accommodate, reconcile or resist them. This webinar is designed as an overview to the thinking processes that can be used to rationalise the ‘non-security’ commercial threats with a view to understanding the particular skill-set of the Enterprise Architect.

More Information
What is Enterprise Architecture for Architects and the IT community

Understanding how to accommodate responses to subtle threats within our complex corporate environment requires a dispassionate and holistic view which is not easy when it feels like fire-fighting. The role of the Enterprise Architecture is to support continuity of business whilst analysing and understanding these threats, then design optimal system modifications to accommodate, reconcile or resist them. Optimal, in this case, generally includes that they are capable of being implemented whilst minimally compromising the current operational environment – or that a great change is handled with predicted damage limitation. This webinar is designed as an overview to the thinking processes that can be used by the Enterprise Architect to rationalise these seemingly conflicting requirements.

More Information
BCS Blockchain Essentials (BCSBLOCKE) Undertand the basic concepts of blockchain, the potential fields of application, the potential value for the organization and the technology driving the blockchain

Explain how a blockchain works, explain the purpose ledgers have in a blockchain, Identify blockchain vulnerabilities, Explain the role of the public witness in a blockchain, Explain the role of decentralized autonomous organizations (DOA) and sophisticated smart contracts, describe possible applications for a blockchain with regard to identity, identify the possibilities of combining a blockchain with internet of things (IOT) or artifical intelligence (AI), describe the role blockchain can play in the supply chain, explain the use of blockchain technology for the protection of intellectual property (IP) and providence

More Information
AWS Discovery Day

Get a free official introduction to AWS.

More Information
Deploy to Kubernetes with Azure DevOps

Get a free official introduction on how to deploy Kubernetes with Azure DevOps.

More Information
An Overview of Microsoft's Fundamentals

In this 2-hour webinar, you'll get an overview of Microsoft's Azure Fundamental - certifications AZ-900, AI-900 and DP-900.

More Information
Introduction to Microsoft Azure Data Fundamentals Certification

Free 1-hour overview to Microsoft Azure Data Fundamentals certification | Exam DP-900.

More Information
Firebrand Academy Skills Bootcamps

A free overview of Firebrand's Skills Boot Camps

More Information
An Overview of Skills Bootcamps In Digital

Skills Bootcamps in Digital - Part of the Government’s Lifetime Skills Guarantee and Skills for Life. Find out how you can kick start your career in digital.

More Information
IT Technician Skills Bootcamp

A 12 week programme. 10 x 1 day release mid-week or weekends Online Instructor Led, Online directed self-paced, practicals and assignments.

More Information
Cyber Security Technician Skills Bootcamp

12 weeks programme. 7 x 1 day release mid-week or weekends Online Instructor Led, Online directed self-paced, practicals and assignments.

More Information
Software Developer Skills Bootcamp

12 weeks programme. 6 x 1 day release mid-week or weekends Online Instructor Led, Online directed self-paced, practicals, assignments and online webinars

More Information
Cloud Engineer Skills Bootcamp

12 weeks programme. 6 x 1 day release mid-week or weekends Online Instructor Led, Online directed self-paced, practicals and assignments

More Information
Microsoft Certified: Azure Data Fundamentals Certification | Exam DP-900

Get Microsoft Certified in Azure Data Fundamentals in just 1 day!

More Information
Microsoft Certified Data Analyst Associate | Exam DA-100

Free 1-hour introduction to Microsoft Certified Data Analyst Associate certification | Exam DA-100.

More Information
Microsoft Certified: Azure Fundamentals | Exam AZ-900

Achieve your Microsoft Certified Azure Fundamentals certification in just 1 day.

More Information
Github DevOps: How to Deploy to Kubernetes with Microsoft's CI/CD Tool - Part 1

In this free 1-hour webinar, you'll learn how to deploy Kubernetes using Microsoft's CI/CD Tool.

More Information
Github DevOps: How to Deploy to Kubernetes with Microsoft's CI/CD Tool - Part 2

In this free 1-hour webinar, you'll learn how to deploy Kubernetes using Microsoft's CI/CD Tool.

More Information
An Introduction to Microsoft Certified: Security, Compliance and Identity Fundamentals | Exam SC-900

Free 1-hour overview to Microsoft's new Security course: Microsoft Certified: Security, Compliance and Identity Fundamentals.

More Information
Microsoft 365 Certified Fundamentals | Exam MS-900

1-day accelerated Microsoft 365 Certified Fundamentals course and certification.

More Information
Microsoft Dynamics Business Central Consultant Bootcamp

Find out all you need to know of Firebrand's delivery of Microsoft Dynamics Business Central Consultant Bootcamp. Sign up now for free!

More Information
Navigating Microsoft Certifications

Interested in starting your Microsoft career but don't know which pathway to venture? Join this free 1-hour webinar to get the support you need!

More Information
Overview of Microsoft's Dynamic Certifications

Join this FREE 1-hour webinar to find out why YOU want to start your Microsoft Dynamics career.

More Information
A Focus on Microsoft's Security Certifications: SC-200/300/400/900

1 hour summary on the Microsoft Security Certificates

More Information
Microsoft IT Technical Support Specialist Apprenticeship Programme

Join us in this FREE overview of the Microsoft IT Technical Support Specialist Apprenticeship Programme

More Information
AWS Cloud Practitioner Essentials

This course is for individuals who seek an overall understanding of the Amazon Web Services (AWS) Cloud, independent of specific technical roles.

More Information
Microsoft Certified: Power Platform Fundamentals Exam | PL-900

On this accelerated Microsoft Power Platform Fundamentals course, you’ll immerse yourself in the Power Platform, it's extensive product capabilities and the value it will bring to your business.

More Information
Microsoft: Configure secure access to your workloads using networking with Azure Virtual Network AZ-1002

In this learning day, you practice configuring secure access to workloads using Azure networking.

More Information
Microsoft: Secure storage for Azure Files and Azure Blob Storage AZ-1003

In this learning path, you practice storing business data securely by using Azure Blob Storage and Azure Files. The skills validated include creating storage accounts, storage containers, and file shares. Also, configuring encryption and networking to improve the security posture.

More Information
Microsoft: Implement security through a pipeline using Azure DevOps AZ-2001

In this course, learners explore how to configure and secure Azure Pipelines.

More Information

Press enter to see more results