MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English + srt | Duration: 43 lectures (4h 14m) | Size: 1.47 GB

Data Analysis and Visualization

Connect to data sources
Clean, transform and load data
Create data visualizations
Create and publish reports to the Power BI Service
Transform less structured data
Perform data modelling
Perform intelligence on models
Create and merge queries

Basic knowledge of excel advised
Basic knowledge of SQL advised

Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website.

Connect to hundreds of data sources and bring your data to life with live dashboards and reports.
Discover how to quickly glean insights from your data using Power BI. This formidable set of business analytics tools—which includes the Power BI service, Power BI Desktop, and Power BI Mobile—can help you more effectively create and share impactful visualizations with others in your organization.
In this bners course you will learn how to get started with this powerful toolset. We will cover topics like connecting to and transfog web based data sources. You will learn how to publish and share your reports and visuals on the Power BI service.
You will learn how to import data, create visualizations, and arrange those visualizations into reports. You will learn how to how to pin visualizations to dashboards for sharing. You will also learn how to use DAX language( Data Analysis Expressions) to perform calculations on data models.
Topics include
Connecting to SQL Server and PostgreSQL Databases
Connecting to Microsoft Access Database File
Creating reports with data visualizations
Modifying existing reports
Creating and managing data dashboards
Creating Power BI datasets, dashboards, reports, and workbooks
Connecting to web based data source
Connecting to Excel dataset
Using Query Editor
Joining tables and creating tables
Formulating via DAX logic
Using quick measures and dynamic measures
Using conditional statements
Perfog various transformation on connected dataset

Bner Data Analyst
Bner Data Scientist
Bner Power BI Analyst




DOWNLOAD
uploadgig.com