I am currently working with automation and data development using Powerapps, Microsoft Flow, PowerBI and MSBI stack. My experience includes:
- Work with automation development by designing apps, control logic and monitor the REST APIs.
- Advancement of these APIs with connectors to create/automate the flow of data using triggers.
- Data extraction, transformation, and loading using Powerquery, query editor through PowerBI APIs.'
- Implemented DAX measures on the entities depend on the environment
- Analysed the data through SQL server analysis servers on dimtables, fact tables, KPIs, aggregations.
- Applied ETL processes through SSIS on aggregating, incremental loading, merge and conditional split.
(A) Automation on Data Development
1) Powerapps- App designer, Logic flow designer and app service management.
2) Microsoft Flow- Triggers, approvals logics, conditions set and automate processess.
(B) Data Development
3) PowerBI- Powerpivot,powerquery,M-language, DAX, Visualisation tricks, Report server
4) Reporting Process- Report processing, Model processing, Scheduling.
5) Analysis Process- MDX queries, Facts and Dimensions, KPI Indicators, Partitions,Aggregations.
6) ETL Process- Conditional split, Merge, Multicast, Aggregate.
7) T-SQL- Joins, Keys, Performance tuning, Query Optimisation techniques, Index, Stored Procedures, Views, Triggers.
I am also highly integrated with polish society whereby I speak and conduct meetup on data meetup group view and learning polish each day. More information is available in www.samanalytiks.com as well.
https://www.meetup.com/polishpowerbi/ and https://www.meetup.com/Poland-apps-and-flow/