About the Course
Data analysis using SQL; you will get a big-picture view of using SQL for big data, starting with an overview of data, database systems. Then you will learn the characteristics of data analysis using SQL tools for working on big data platforms. You will be taught also how to install an exercise environment (virtual machine) to be used through the course, and you will have practical exploration of databases and tables in that environment during the course of the training
Data analysis using Power BI; you understand rapid insight of Power BI and is used to extract and visualize data. Power BI brings together data from multiple sources to give you a comprehensive view of your company’s information assets. You learn how to present meaningful data analysis in tables and graphs, how to create high-quality visualizations and interactive reports in addition to tools which allow you to effortlessly share your reports with others. Power BI is a powerful tool for analyzing data from a variety of data sources, you can analyze large amounts of data by extracting valuable information that can easily otherwise be lost. As a beginner, your journey into the world of data intelligence will be a complete success in every respect, which will ultimately lead to you being a power BI strategist.
Course Fee: N80,000
Duration: 6 weeks
Delivery Mode – Live, Instructor Led Online
Contact us for Group or Team Registration
Course Outline
SQL
SQL WITH MYSQL/POSTGRESQL
● Introduction to SQL
● Installation of RDBMs
● Understanding MySQL Workbench/ Postgres PGAdmin
● Data types
● Constraints in SQL
● Understanding primary key and foreign keys
● Working with SQL command line tools
● Database creation
● Data manipulation language
● Data definition language
● The WHERE clause
● The SELECT keyword
● Updating a table with the UPDATE keyword
● The SQL BETWEEN keyword
● The SQL LIKE keyword
● The SQL IN keyword
● Comments in SQL
● Using MySQL for EXCEL to interact with MySQL
● Importing data into an RDBMSs from external files
● Loading query results into an external file
POWER BI
● Installing Power BI from the Microsoft website
● Setting up a Power BI account
● Importing data into Power BI
● Data visualization in Power BI
● Data cleaning with Power BI
● Introduction to DAX
● Time intelligence functions in Power BI
● Data modeling
● Creating Visuals with Q&A
● Custom visuals
● Conditional formatting and other formatting styles
● Data mashup with Power Query
● Time series forecasting
● Publishing report to Power BI Online
