Develop and deploy dashboards, visualizations and autonomous and dynamic reporting to health care and financial industries via the BI reporting platform, web portal and Mobile application. We have developed different dashboards and visuals from data warehousing, structured and unstructured data. Here is the skills expertise we have done in Power BI and azure cloud based Power BI environment.
Skills:
- Build Analysis Services reporting models.
- Develop visual reports and dashboards using Power BI desktop.
- Connect to various data sources, importing data and transforming data for Business Intelligence.
- DAX scripts in Power BI desktop.
- Use advance level calculations on the data set and report level.
- Adept in development, publishing and scheduling Power BI reports as per the business requirements.
- Understand the business requirements and develop data models accordingly.
- Integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation.
- Creating Model and Develop custom visuals in Power BI.
Data Source:
File: Excel, Text/CSV, JSON, Folder, SharePoint folder
Databases: Access DB, SQL server, MySQL DB, Oracle DB, PostgreSQL, impala, BI Connector
Power Platform: Power BI dataflows
Online Services: Salesforce Objects, Salesforce Reports, Microsoft Azure SQL
Data Refresh: Refreshing online dataset using On-premises Gateway connection.
Power BI Embedded Services: Power BI Embedding with web applications with Security Implementation.
Web Applications: node JS, PHP,Power BI Rest APIs,Power BI Embed service in Microsoft Azure.
Data Transform: Shape and Combine the Dataset Using DAX Scripting.
- Adding or removing columns
- Changing data types
- Splitting columns
- Other data-driven tasks
- Group rows
- Pivot columns
- Create custom columns.
- Query formulas
Dashboard Sharing:
Sharing Dashboard via Power BI online and provide access to the authorized user.
Scripting: DAX script
Creating Measure, Creating Columns
Other BI Tools:
Tableau, QlikView, Tibco Spotfire
Use Cases:
Developed and enhanced sales dashboard for pharma client. Important dimensions are SalesRep, drug category, latitude and longitude, territory mapping, color coding based on sales figures. The system was using cloud Power BI.
Built a SaaS project for medical device testing using embedded Power BI, python backend processing, JIRA.
Based on medicare data-built sales territory mapping using Power BI.
Converted Qlikview, tableau projects into Power BI applications.
Implemented fine grained row level access control based on user privileges in Power BI.