sanjay kumar

316
reputation
1
6

I think about problem statement to find the solution specially in PowerBI reporting, SSIS etl development and SSAS tabular cube.

Profile pdf

My specialties include:

• DAX- complete data modeling • M language- power query or edit query • Power BI Desktop • Power BI service- managing powerbi..com service • Power Pivot • Power Query • PowerBI Report Automation- scheduling data refresh from different sources • SQL Server 2012+ • SSAS Tabular - Cube Development • SSIS- developing ETL for automation of reports and data refresh • SSRS 2016 with Power BI on premises- complete offline/in-house PowerBI solution • SQL Azure- storing data online and used in automatic data refresh for Azure PowerBI embedded service • Azure PowerBI Embedded • Azure Portal Management- Creating/Maintaining virtual machines(VM), SQL azure Analysis Services and other azure products

Power BI Solutions:

  • Power BI custom Demo report development for your brand/company.
  • Power BI on-premises with SQL Server 2016.
  • Provide support in writing DAX Measures.
  • Error handling and debugging Power BI file and report -Advanced Data Modeling using DAX, PowerQuery/EditQuery in PowerBI Desktop and working with Custom Visuals. -Applying dynamic Row Level Security on PowerBI Dashboards as per user logged in user to PowerBI.com
  • Live Streaming Dashboard in PowerBI. -PowerBI Embedded in PHP and dot Net.
  • PowerBI Embedded with Azure.
  • PowerBI Embedded with dynamic Row Level Security (Role based)
  • PowerBI : Consultant, Online Trainer, and Blog writer -PowerBI Dashboard from various data sources like Survey data, google analytics data, Dynamic CRM, SharePoint, on-premises SQL Server Database, Excel data, CSV data -configuring/using PowerBI Enterprise Gateway for live dashboards

Power BI tools - PowerBI Desktop, Power Pivot, Power Query, Power View, Power Map, Power BI Dashboard, calculated columns and calculated measures using DAX, data modeling

SSIS - ETL package development and automating data processing from different sources like excel, CSV, text and other databases SSAS - Tabular cube development MSBI - SSIS,SSAS(Tabular), DAX, SSRS