Profile Summary:
Results-driven Power BI Developer with strong expertise in data visualization, business intelligence, and data analytics. Skilled in transforming raw data into meaningful insights and interactive dashboards that support data-driven decision-making. Proficient in Power BI, DAX, Power Query, SQL, and data modeling with hands-on experience in integrating data from multiple sources including Azure, SQL Server, Excel, APIs, and cloud-based platforms.
Core Skills:
- BI & Visualization Tools: Power BI (Desktop, Service, Report Builder, Embedded)
- Data Transformation: Power Query (M Language), ETL pipelines
- Data Modeling: Star schema, Snowflake schema, Fact & Dimension modeling
- DAX (Data Analysis Expressions): Calculated columns, measures, KPIs, time intelligence functions
- Databases: SQL Server, Oracle, Azure SQL, MySQL, PostgreSQL
- Cloud Platforms: Azure Data Lake, Azure Synapse, AWS Redshift, Google BigQuery
- Reporting & Dashboards: Interactive visuals, drill-down reports, row-level security (RLS)
- Other Tools/Technologies: SSIS, SSRS, Excel (Power Pivot), Python/R for advanced analytics
- DevOps & Deployment: Power BI Service, Gateway configuration, workspace & dataset management
Roles & Responsibilities:
- Develop, publish, and maintain interactive Power BI dashboards and reports.
- Perform data extraction, cleaning, and transformation using Power Query and SQL.
- Design optimized data models with relationships, hierarchies, and calculated measures using DAX.
- Implement row-level security (RLS) and governance policies for secure data access.
- Collaborate with business stakeholders to understand requirements and translate them into BI solutions.
- Optimize dashboard performance with data aggregation, incremental refresh, and query optimization.
- Deploy and schedule reports in Power BI Service, ensuring refresh and availability.
- Work with Azure/AWS data sources for cloud-based analytics integration.
- Support self-service BI adoption by training end-users and creating documentation.
Laporkan kerja
