POWER BI FLOWCHART
Course Length: 1-Day
Course Overview
Learn to load external data into Power BI for use in reporting, charting, dashboarding, and business intelligence. Connect to a range of external databases and other data sources to find data and pull that data into your local report for further analysis. After data is accessed, make it useful in tabular form with cleaning and rearranging. For advanced problems, the M language that is built into Power Query will be studied to specifically support mashing up data in support of business intelligence and analysis.
What you will Learn
- Connect to a range of external data, from databases to Azure sources
- Cleanse and prepare external data so it can be used inside Power BI
- Refresh data quickly and easily to always have the latest information
- Transform data into ready-to-use structures that fit the report format
- Execute M language functions for complex data transformations
Prerequisites
- Power BI or MS PL 300 Microsoft BI Data Analyst
- Or Equivalent Knowledge
Course Outline
- Using Power Query to Discover and Load Data
- Discovering and Loading file-based Data with Power Query
- Loading Data from Databases and Data Warehouses
- Loading Data from the Web and the Cloud
- Generic Data Sources
- Structuring Imported Data
- Data Transformation
- Restructuring Data
- Complex Data Loads
- Organizing and Managing Queries
- Parameterizing Queries
- The M Language