About the Course
Data Analysis with SQL; you understand everything that is not covered in foundation SQL courses. The curriculum covers all the advanced techniques you ever need to wrangle and analyze data in the fastest and most efficient way possible. As a data analyst take your skills further so you can spend less time wrangling data and more time building models, everything is taught in the context of real-world analytics scenarios, meaning you’ll be ready to apply these techniques on the job from day one. Salvatech will dig deep into the advanced toolbox that SQL has to offer, uncovering techniques to solve problems that leave even senior analysts scratching their heads. The course provides a treasure trove of coding exercises that give you ample opportunity for hands-on practice. You have an opportunity to practice every concept you learn, right after you learn it.
Data Analysis with Power BI; you will learn how to use Power BI to perform data analytical functions, how to identify outliers in your data, how to group data together, and how to bin data for analysis. You will also learn how to perform time series analysis. Power BI allows users to extract useful knowledge from data to solve business problems. This white paper will cover the advanced analytic capabilities of Power BI. You will work with advanced analytic features of Power BI, such as Quick Insights, AI Insights, and the Analyze feature.
Course Fee: N120,000
Duration: 10 weeks
Delivery Mode – Live, Instructor Led Online
Contact us for Group or Team Registration
Course Outline
SQL
SQL WITH MYSQL/POSTGRESQL – Advance
● Transaction Control Language
● MySQL/POSTGRESQL-Python Database connection
● SQL CASE statement
● Dropping records
● Understanding relationships
● Controlling numeric precision
● CONCAT function in SQL
● SQL Date functions
● SQL string functions
● Working with numeric data
● Controlling numeric precision
● The ALTER keyword
● Using ALIAS for tables and columns
● Querying
● The JOIN keyword
● Creating Views
● Creating Index
● The set/aggregate functions
● Reverse-engineering in SQL
● Performance tuning in SQL
● Regular Expressions and wildcards in SQL
● Importing data into an RDBMSs from external files
● Loading query results into an external file
Power BI
- Pivoting and unpivoting columns
- Best practice for writing DAX
- Power BI – Python integration
- Using DAX Formatter
- Importing data into Power BI from Python
- Creating templates in Power BI
- The CALCULATE function
- Building wordcloud in Power BI
- Custom visuals in Power BI
- Time series forecasting with Power BI
- LinkedIn Data Analysis in Power BI
- Power BI-R integration
- Row-level security
- Publishing your reports on powerbi.com
- Creating visuals using Q&A
- Drill up and drill down reports