Unterrichten:
Computer Software
Excel
Hi! I am Promise Chinonso 👋 A certified Excel tutor with multiple success stories from past students. I have 3 years+ working experience in the Edtech industry where I have trained 3000+ students to become better in tech, creating an enabling environment for them to learn the best practices, approaches and skills that makes one a Data professional and a proficient Excel, SQL and Power BI user.
Need an excellent Excel, SQL, Power BI tutor? Book atrial session with me today!
Below are concepts I will teach you extensively with hands-on practice using real world scenarios in Excel:
• Data collection from various sources
• Data Manipulation and management using in-built functionalities
• Data Cleaning and Transformation
• Important Formulas and Functions
• Data Summarization and Analysis using Pivot Tables
• Data Visualization, Storytelling with Data
• Dashboard building
• Reporting
Below are concepts I will teach you extensively with hands-on practice using real world scenarios in SQL:
• Introduction to SQL, Data and Databases
• Creation of Databases and Database objects
• Database Update and Modification
• Database Querying & Manipulation
• Functions (Aggregate, String, Date/Time)
• JOINS (Inner, Outer, Left, Right, Cross, Self)
• Advanced SQL (Window functions, CTEs and Subqueries)
• Views and Stored Procedures
Below are concepts I will teach you extensively with hands-on practice using real world scenarios in Microsoft Power BI:
• Data Collection and Connection to over 100 sources
• Data Cleaning and Transformation in Microsoft Power Query Editor
• Data Modelling
• Data Analysis and Visualization
• DAX (Data Analysis Expressions)
• Report Building
• Report Publishing Online and Dashboard Creation in Power BI Service
Take note: you don't need to know what Data Analysis is to join my class. I will walk you through that path seamlessly.
I have no doubt that the demand for Data Analysts will continue grow, this is why I have taken it upon myself to help more people acquire skills that will be paying them well in the long run.
Being a Data Analyst is very rewarding! I currently work as a Data Analyst in the Energy industry where my knowledge and strength in data has helped my company grow from medium to large scale.
If you are considering pursuing a career in Data Analyst, take a moment to schedule a session so we can discuss your needs, and the roadmap that will land you your dream role in a couple of months.
Mehr Filter
