My Highlights as a “Power BI Developer/Architect” is as under:
- DATA/REPORTING ANALYST/BI DEVELOPER ON BUSINESS SIDE – Working as Data/Reporting Analyst/BI Developer on “Business Side”, who can convert Raw Data into Useful/Actionable/Refreshable Information for Decision Makers in a Business Situation.
- ADVANCE USED OF POWER BI UNIVERSE: Complete knowledge of “Power BI Universe” including Power Query, Power Pivot, Power View, Power Maps, Power BI Desktop, PowerBI.Com services (Microsoft Azure Cloud based services), Power BI Mobile Apps, Power BI Workspace Apps, Power BI Gateway and Power BI Embedded. Can Convert Structured/Unstructured Raw Data and in to Actionable Insights.
- ADVANCE USED OF POWER BI REPORTS/DASHBOARD: Advance user of Power BI including Hierarchies, Grouping and Binning, Slicers, creating Cards, KPI, Matrix, Tables, Charts, Graphs, Visualization and share with users through Workspace Apps or Mobile App;
- ADVANCE USER OF “POWER QUERY (DEVELOPER)” TO CONNECT 100 OF DATA SOURCES AND 300 DATA TRANSFORMATION: Advance user of Microsoft Power Query – which is Data Extraction & Data Transformation engine. Can connect to more than 100 Data Sources and can perform more than 300 Data Transformation on File based Data Like Excel, .txt, .Csv, JSON files, and XML files – Enterprise Databases Like SQL/Oracle Server – Microsoft Cloud/Azure Data Like Azure SQL/Azure Data Warehouse – Web/Online/Cloud Services Data Like Google, Facebook, LinkedIn, Salesforce object through Import/Direct Query/Live Connection;
- ADVANCE USER OF “DAX (DEVELOPER)” – AS A FUNCTIONAL, PROGRAMMING AND QUERYING LANGUAGE: Advance user of DAX as a Functional, Programming and as a Query language to create Calculated Explicit Measures, Calculated Columns, Calculated Tables and Quick Measures. Can create sophisticated Queries using DAX ;
- READY TO PROVIDE VIDEO DEMO ON 12 MILLION ROWS OF DUMMY DATABASE: Ready to provide video DEMO of above Power BI, Power Query and of DAX – on 12 Million Rows of dummy database provided by Microsoft, if being asked for;
- ETL AND DATA WAREHOUSING, AS BUSINESS USER: Can do Virtual ETL (Extract, Transfer & Load) process to deal with data from different departments like Sales, Finance etc. and can create virtual Data Warehouse in Power BI Module, as Business User;
- MICROSOFT DATAFLOW INTO AZURE DATA LAKE STORAGE: Can able to create Microsoft Dataflow to ingest, transform and load data into Microsoft Azure Data Lake Storage Account;
- ON PREMISE MICROSOFT ENTERPRISE DATA GATEWAY: Can able to install on-premise Enterprise Data Gateway to provide quick and secure data transfer between on-premise data to Microsoft Azure Cloud Services/Azure data lake;
- DATA PROFILING/AUDITING TOOLS: Can have advance knowledge of Data Engine/Power Queries Data Profiling/Data Auditing tools for Data Quality, Data Distribution and Data Profile.
- STAR SCHEMA DATA MODELING: Can create Star Schema Data Model in Excel/Power BI to integrate Data from Multiple of Sources, for Data tables (fact/transaction table) & Lookup tables (dimension tables) by establishing “One to Many” relationship between primary & foreign keys and can create “Star Schema” Data Model;