Microsoft Power BI

No#1 Business Intelligence with Placement Assistance


Register 

Learn from Industry Experts with Placement Support

Skill level

Industry Standard

Time to Complete

Approx. 8 hours

Certificate of completion

Yes

Prerequisites

Passion to Learn 

About this course

Information is all around us. You can put it to use by learning SQL basics. Used in data science, analytics, and engineering, SQL makes it easy to work with data and make more informed strategy, operations, and business decisions. It’s a helpful skill for anyone who works with data (even in non-tech roles). In this SQL course, you’ll learn how to manage large datasets and analyze real data.

Skills you'll gain

Work with databases using SQL

Create queries for tables

Build SQL projects

Syllabus

Get a brief idea on Data Visualization and Tableau Prep Builder tool.

  • What is powerBi?
  • Introduce tableau file types
  • Get help in tableau

Perform more complex queries by learning essential query keywords and functionality

  • What is Join related data source?
  • Clean up source data
  • Reorder fields in a visualization
  • Change the summary operation
  • Split text in multiple columns

Learn powerful functions for performing complex database operations with ease.

  • Add, duplicate and rename worksheets
  • Reorder, clear, and delete worksheets
  • Change a worksheets tab colour
  • Show or hide element
  • Create a packaged workbook

Learn powerful functions for performing complex database operations with ease.

  • Count occurrence and distinct
  • Display the summary card
  • Forecast future values

Learn powerful functions for performing complex database operations with ease.

  • Create a nested sort
  • Create a selection filter
  • Create a wildcard filter

Learn powerful functions for performing complex database operations with ease.

  • Define a group for other values
  • Find members of a group
  • Edit and delete group
  • Create summaries using sets

Learn powerful functions for performing complex database operations with ease.

  • Create line chart and area fill chart
  • Identify data clusters
  • Summarize data using smart histogram
  • Create a tree map

Learn powerful functions for performing complex database operations with ease.

  • Change the appearance of your data
  • Set a default format for a field
  • Display a visualization in Presentation mode
  • Create a highlight table

Learn powerful functions for performing complex database operations with ease.

  • Annotate a visualization
  • Format chart elements
  • Display a visualization in Presentation mode
  • Add a trend line to a chart
  • Add reference lines and quartile indicators

Learn powerful functions for performing complex database operations with ease.

  • Create a basic map
  • Add and remove map layers
  • Enhance map analysis using distance measurement tools
  • Disable pens and zoom in map
  • Define custom regions

Learn powerful functions for performing complex database operations with ease.

  • Present data using Storylines
  • Create a dashboard
  • Arrange and resize dashboard elements
  • Replace a worksheet in a dashboard quickly
  • Define a filter action

Learn from World-class Faculty & Get ready for Dream IT Career! 

Learn more

100+
Courses

Preparing You Enough

1500+
Students

Learning Partners

500
Certificates

Accomplishments

20+
Instructors

Going Stronger

Recommended by Top IT Companies & Professionals

join now
  • AmplifyDreams Technologies

  • Social Icon

© 2022 Amplify Dreams. All rights reserved |Disclaimer - All Trademarks/Wordmarks are property of respective owners/companies/institutions.