fbpx

Risk Management solution in Uk | Basel IV | Financial advisor | Credit & liquidity Risk Management

0(0 Ratings)

Data Analytics

Categories Individual training

What I will learn?

  • Data Analytics using Excel, SQL and Power BI
  • Improve your critical thinking and problem-solving skills
  • Stand out in the job market
  • Learn how to use powerful data analysis tools
  • Build your portfolio
  • Gain access to a community of data analysts

Course Curriculum

Excel Basics for Analytics

  • The Excel Makeup
  • Relative & Absolute Referencing
  • Named Ranges
  • Table Range and Excel Tables

Formulas in Excel

Pivot Tables

Pivot Charts

Data Modelling in Excel

Data Tools

Extras

More Excel Analytical Capabilities

Learn how to code in SQL and become an expert
This topic will cover the basics of SQL, including data types, operators, and clauses. You will learn how to write simple and complex queries, and how to use them to manipulate data in a database. You will also learn about some of the more advanced features of SQL, such as stored procedures and triggers.

Create, design, and operate with SQL databases
This topic will cover the process of creating a database, from designing the tables to loading the data. You will learn how to create relationships between tables, and how to use constraints to ensure the integrity of your data. You will also learn how to operate a database, including managing users and permissions, and backing up and restoring data.

Start using MySQL – one of the most common Database Management System (DBMS)
This topic will focus on MySQL, one of the most popular open-source DBMSs. You will learn how to install and configure MySQL, and how to use it to create and manage databases. You will also learn about some of the features that make MySQL a powerful and versatile DBMS.

Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities

Adopt professionally tested SQL best practices.

Gain theoretical insights about relational databases

Add data analytical tools to your skillset

Develop business intuition while solving tasks with big data

Introduction to Microsoft Power BI

Get Data into Microsoft Power BI

Making Power BI Visuals

Introduction to Data Modelling

Introduction to DAX

Data Cleaning with PowerQuery (I)

Data Cleaning with PowerQuery (II)

Date Transformation

Data Modelling

Advanced DAX Functions

Other Functions

Student Ratings & Reviews

No Review Yet
No Review Yet
$507

Tags

Want to receive push notifications for all major on-site activities?

Need help?
1