|
Description: |
I am looking for a skilled Power BI trainer to deliver a customized, one-week intensive training program tailored to my background as an IT Business Analyst and Project Manager. With strong skills in SQL, data migration, and experience in ERP/CRM systems, I aim to master Power BI for practical business analysis and reporting. The training should be hands-on, focused on real-world use cases, and cover data modeling, DAX, dashboard creation, and integrations with tools like SQL and Excel.
Below is my data experience:
Data Analysis & Modeling Skills
• Understanding of relational databases and normalized data structures
• Experience with data mapping between source and target systems
• Familiarity with data dictionaries, ERDs, and data lineage
• Competence in working with reference tables, lookups, and master data
• Ability to analyze data across multiple systems/modules (e.g., CRM to ERP)
• Understanding of KPI frameworks, dashboard logic, and reporting requirements
• Experience gathering business intelligence needs from stakeholders
SQL Knowledge & Capabilities
• Using WHERE, GROUP BY, HAVING, and ORDER BY
• Creating nested queries, common table expressions (CTEs), and subqueries
• Using aggregations like SUM, COUNT, AVG, MIN, MAX
• Writing CASE statements, calculated fields, and aliases
• Understanding views, stored procedures, and basic data validation rules
Real-World Applications
• Pulling data for gap analysis and requirements traceability
• Validating data integrity between integrated systems
• Supporting UAT with SQL-based data checks
• Assisting data migration projects with source-to-target verification |
