As a Power BI Developer, I have hands-on experience in creating insightful reports and dashboards by connecting directly to databases such as SQL Server Management Studio (SSMS) and Oracle SQL Developer. I am proficient in leveraging DAX queries to calculate complex metrics and Key Performance Indicators (KPIs), and skilled in using Power Query for data transformation and manipulation within Power BI, ensuring data quality and consistency across reports. My expertise includes setting up and managing Dataflows to ingest, transform, and integrate data from various sources for centralized reporting. Additionally, I have experience configuring and managing Gateways to establish secure connections between on-premises data sources and Power BI Service, implementing Incremental Refresh strategies to efficiently load and refresh large datasets, and optimizing report performance. I am knowledgeable in Power BI Service features such as dashboard creation, scheduling data refreshes, and managing user access and permissions.
Programming Languages: SQL, Python
Business Intelligence Tools: Power BI
Databases: Oracle, PostgreSQL, SQL Server Management Studio (SSMS)
Data Modelling & ETL Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)
Web Technologies: HTML, CSS
Manual Testing: Experience with manual testing methodologies and practices