Advanced Data Analysis with SQL and Power BI – N120,000

​​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

 

Register for this Course

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

Leave a Comment

Your email address will not be published. Required fields are marked *