SESSION OUTLINE: Sam Chatterjee will present on using Flow, Power Query, and Power BI to automate a process that uses data from flat files. Flat file systems are a necessity for many businesses to gather, store, and edit their data. This session illustrates how Flow can update old processes and fulfill the need for standardization with automation.
Sam will demonstrate how a Flow automation can enhance current processes. You will also learn how to extend this application using Power BI via Power Query, and ultimately display in Excel though implementation of a timed schedule. This can modernize the workflow for on-going processes with a prescribed time frame. Additionally, cloud services allow you to share the automation among users, and much more. All the examples will be shared and discussed during the session.
SPEAKER PROFILE: Sam Chatterjee is a business intelligence developer who is passionate about data. Apart for being a full time datanaut, he is also involved in PowerApps and Microsoft Flow as an active automation developer and use his time in R, PowerBI, SSIS, SSAS , SSRS and SQL Server for data analysis. He is really addicted to giving back to the Business Intelligence Community because the Power Platform, Business Intelligence and Machine learning community has given him so much to him. Learn more about our speaker at https://www.linkedin.com/in/samdata/ and http://www.samanalytiks.com/ or follow him on Twitter (@bidata).
We are a group of Power BI and Modern Excel enthusiasts. This group is dedicated to running monthly meetings to share techniques and inspire incredible data analytics and dashboards using Power BI and the Modern Excel tools (Power Pivot and Power Query.)