Power BI/Data Analyst – Power BI/SQL/Azure/Excel/Alteryx

Power BI/Data Analyst  - Power BI/SQL/Azure/Excel/Alteryx

Power BI/Data Analyst – Power BI/SQL/Azure/Excel/Alteryx

Perform Data Analysis and create visualizations

Language: english

Note: 0/5 (0 notes) 111 students

Instructor(s): Digital Learning Academy

What you will learn

  • 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 time intelligence on models
  • Create and merge queries
  • Create bulk SQL queries with excel

 

Requirements

  • Basic knowledge of excel advised
  • Basic knowledge of SQL advised

 

Power BI/Data Analyst  - Power BI/SQL/Azure/Excel/AlteryxPower BI/Data Analyst  - Power BI/SQL/Azure/Excel/Alteryx

 

Description

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 beginners course you will learn how to  get started with this powerful toolset.  We will  cover topics like  connecting to and transforming 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


Performing various transformation on connected dataset

 

Power BI/Data Analyst  - Power BI/SQL/Azure/Excel/AlteryxPower BI/Data Analyst  - Power BI/SQL/Azure/Excel/Alteryx

 

Who should attend

  • Beginner Data Analyst
  • Beginner Data Scientist
  • Beginner Power BI Analyst

 

Time remaining or 889 remaining registrations

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate