BI , Apps , Automation

The business world is increasingly data driven. Small and large businesses alike use data to make decisions about sales, hiring, goals, and all areas for which they have data. While most businesses have access to data of one type or another, it can be intimidating to try to understand without a background in data analytics or statistics. Even if you do understand the data, a challenge may arise in displaying the data in an easy to understand way and communicating it to other relevant people. Power BI takes the intimidation and hassle out of data analysis and visualization. By connecting to one or more of the hundreds of existing data sources and using a secure, easy to understand interface, you can quickly and simply interact with and understand your data to influence all business systems.

• Module 01 Get Started with Microsoft Data Analytics 
• Module 02 Prepare Data in Power BI 
• Module 03 Cleaning, Transforming and Loading Data
• Module 04 Designing a Data Model in Power BI 
• Module 05 Create Model Calculations using DAX in Power BI 
• Module 06 Optimize Model Performance 
• Module 07 Create Reports 
• Module  08 Create Dashboards 
• Module 09 Create Paginated Reports 
• Module 10 Perform Advanced Analytics 
• Module 11 Create and Manage Workspaces 
• Module 12 Manage Datasets in Power BI 
• Module 13 Row-level Security 

Prerequisites

Microsoft Excel and fundamental relational database knowledge is required.   

Power Automate is used to automate repetitive business processes. Beyond simple workflows, Power Automate can send reminders on past due tasks, move business data between systems on a schedule, talk to more than 275 data sources or any publicly available API, and can even automate tasks on your local computer like computing data in Excel. All of this can be done by all skill levels from typical business users to IT using Power Automate's no-code/low-code platform.

Module 01 An Introduction to Power Automate 

Module 02 Getting started with Power Automate 

• Power Automate Templates 
• Publish and Trigger Power Automate 
• Building Processes in Office 365 

Module 03 Power Automate Logic 

• Adding Conditions
• Designing switches
• Configuring Decision Controls 

Module 04      Integration

• Standard and Premium Connectors
• Connecting to Web Services 
• Designing Processes 

Module 05     The Mobile App 

Module 06     Administration and Maintenance 

Prerequisites 

There is no prerequisites to attend to this course.