SQL for Data Analysis | Michael Olafusi
Hosted by Power BI Learning Community
Details
Speaker: Michael Olafusi
Agenda:
- SQL for Data Analysis
- Q&A
We will be covering, as much as we can in one hour, the following:
- Basic SELECT statement
- SELECT DISTINCT
- SELECT TOP
- WHERE clause
- Multiple WHERE conditions
- ORDER BY
- GROUP BY
- HAVING
- Understanding when to use WHERE vs. HAVING
- AND
- OR
- NOT
- IN
- BETWEEN
- LIKE
- CASE
- Carrying out mathematical operations
- Using alias
- JOIN
Profile:
Michael is a 9x Microsoft MVP (Most Valuable Professional), certified Advanced Financial Modeler (AFM), Chartered Stockbroker (NG), UK CISI member, Microsoft Certified Trainer and founder of UrBizEdge, a business data analysis solutions firm.
He began his professional career as a Radio Access (RA) Engineer for Nokia Siemens Networks, then as a Business Analyst and MIS Analyst for Comviva -- Airtel Africa CRBT operations in 10 countries, and finally as a Service Delivery Lead and Performance Analyst for 21st Century Technologies before resigning to build his own company.
He has done several financial modeling, business intelligence and data analysis projects/training for Telecommunications companies, FMCG companies, FinTech companies and other industries across the globe.
He is addicted to Microsoft Excel, Power BI, Python, business intelligence and Financial Modeling.
You can connect with him on LinkedIn at https://www.linkedin.com/in/olafusimichael/
See you at the online live class session!
RSVP: https://www.meetup.com/power-bi-learning-community/events/jfsjdtyfcmbgc/
The joining link is https://vip.urbizedge.com/power-bi-live
(c) https://class.urbizedge.com
Recording of past sessions are available at
https://www.youtube.com/playlist?list=PL0kdLm6FekrOQU-74fUCXm-OJydJlRVf5