Address
Form of workTitle: Power BI Developer
Duration: 3 Months
Place of work: Remote Description of Projects
o Migrate Dashboard from AAS Model to PowerBI
Migrate from AAS model (based on SSDT) to PowerBI
Update calculations, bring in new data points from a data warehouse, add row level security
o Build Microsoft PowerApp
Migrate from 10 Google sheets to a read/write PowerApp
PowerApp takes in data from a data warehouse
Add calculations/visuals, security
Periodic snapshotting for comparison purpose
Skills - High Level
• Tech Stack:
o Must Have Power BI, SQL Server, Oracle
o Nice to have: SSDT, AAS, Tabular Model
• Skills:
o Must Have:
Creating data models and writing DAX
SQL queries to fetch the data from source
o Nice to Have: Data Visualization/make reports and dashboards in Power BI
Detailed Requirements:
1) Analyze functional/nonfunctional requirements and seek clarifications for a better understanding of requirements.
2) Experience in optimizing Microsoft Power BI dashboards with a focus on usability and performance
3) Very good SQL and query writing skills.
4) Strong experience on DAX Data Analysis expressions and functions, Power Pivot, Enhancing Power BI visuals. Data extraction and Power query for data transformation.
5) Creating Row level security with Power BI and integration with Power BI Service Portal.
6) Exposure to Gateway services
7) Understand the underlying data and able to map the same with the dashboard.
8) Creation of Power BI dashboard and transforming the manual reports, support Power BI dashboard deployment
Duration: 3 Months
Place of work: Remote Description of Projects
o Migrate Dashboard from AAS Model to PowerBI
Migrate from AAS model (based on SSDT) to PowerBI
Update calculations, bring in new data points from a data warehouse, add row level security
o Build Microsoft PowerApp
Migrate from 10 Google sheets to a read/write PowerApp
PowerApp takes in data from a data warehouse
Add calculations/visuals, security
Periodic snapshotting for comparison purpose
Skills - High Level
• Tech Stack:
o Must Have Power BI, SQL Server, Oracle
o Nice to have: SSDT, AAS, Tabular Model
• Skills:
o Must Have:
Creating data models and writing DAX
SQL queries to fetch the data from source
o Nice to Have: Data Visualization/make reports and dashboards in Power BI
Detailed Requirements:
1) Analyze functional/nonfunctional requirements and seek clarifications for a better understanding of requirements.
2) Experience in optimizing Microsoft Power BI dashboards with a focus on usability and performance
3) Very good SQL and query writing skills.
4) Strong experience on DAX Data Analysis expressions and functions, Power Pivot, Enhancing Power BI visuals. Data extraction and Power query for data transformation.
5) Creating Row level security with Power BI and integration with Power BI Service Portal.
6) Exposure to Gateway services
7) Understand the underlying data and able to map the same with the dashboard.
8) Creation of Power BI dashboard and transforming the manual reports, support Power BI dashboard deployment
