Descriptions
Microsoft Power BI – Data Modeling and Data Manipulation: Microsoft Power BI gives Excel users the ability to extract data from multiple sources, link them together, perform calculations, and create powerful visualizations. Microsoft Power BI is an AWESOME cloud-based business analytics service from Microsoft that enables users to transform data into rich, interactive visual reports that provide a 360-degree business view and improve business decision making. Microsoft Power BI Desktop is a development platform from Microsoft that enables users to connect to a variety of data sources, clean and transform messy data, establish relationships between data sets, perform calculations, and create stunning interactive reports. Microsoft Power BI allows users to publish their interactive reports and share certain features of those reports with others. Reports published on the platform can be set to update automatically and can be interacted with online using any browser or mobile device.
What you will learn
- Import data from a variety of data sources into Power BI Desktop
- How to combine different records, even if they come from different files, databases or other sources
- Clean and transform your data so it’s ready for use with Power BI
- Dive into Get Data and get an introduction to understanding “M” code (Power Query language).
- Turn short, wide data tables into long, tall tables and learn why it’s so useful for Power BI
- Connect multiple data tables and understand relationships
- Create efficient data models: Merge, append and structure your data sets to create the optimal structure
- Apply your Power Query knowledge to Excel and learn when to choose one over the other
- Use different techniques to create and use a calendar table to segment and summarize your reports.
- Create queries that automatically report errors and missing codes
- Automatically combine all Excel, CSV or text files in a folder into one spreadsheet and see how you can apply this
Who is this course suitable for?
- Excel users and analysts who focus on extracting, reorganizing and analyzing data
- Anyone involved in creating visualizations and data modeling
- Anyone interested in saving a lot of time by automating the work of creating recurring reports and dashboards
Microsoft Power BI Specifications – Data Modeling and Data Manipulation
Contents of Microsoft Power BI – Data modeling and data manipulation
Requirements
- This is an introductory course and although no prior knowledge of Power BI is assumed, participants will learn much more from the course if they have used Power BI at least a little before attending. Even participants who have taught themselves Power BI will benefit from attending as the course will fill in many knowledge gaps and expand their knowledge.
- A general understanding of databases, Excel formulas, and Excel pivot tables is useful but not essential.
Pictures
Sample clip
installation Guide
Extract the files and watch them with your favorite player
Subtitles: English
Quality: 720p
Download links
Password file(s): free download software
File size
5.61GB