Get ready to become a Data wizard !
Register here!

Google pay/Phone pe :
7780741024

Share your Payment Status

Whatsapp : +91 8367700222
Email : info@skillsigma.com

SQL+Power BI

A straightforward guide to importing, transforming, and visualizing data in Power BI, with flexible data management using SQL


What will you learn?


  • Interacting with the database
  • Managing the Data of the Database
  • Implementing multiple table access using join
  • Writing the subquery
  • Learn to create POWERFUL reports and dashboards with Microsoft Power BI with a few clicks of the mouse
  • Gain valuable INSIGHT and INTELLIGENCE from your business and marketing data in a FRACTION of the time of traditional spreadsheets
  • PUBLISH reports and dashboards on the Internet and view using laptops, tablets or smartphones in minutes
  • Learn to create Data Models and use the DAX Formula language to develop POWERFUL calculations

Key Highlights

  • Mentors with 15+ years of experience of corporate training with more than 50 MNCs.
  • Hands-on Practical Training
  • Realtime scenarios
  • Coding exercises
  • Program materials.
  • Recordings made available online post session also.
  • Recognized course completion certificate
  • Mentors with 15+ years of experience of corporate training with more than 50 MNCs.
  • Hands-on Practical Training
  • Realtime scenarios
  • Coding exercises
  • Program materials.
  • Recordings made available online post session also.
  • Recognized course completion certificate

Course Includes

Introduction to Power Bi

  • Power BI Installation

Knowing the Interface of Power BI

  • Importing the Excel Data and Creating Visuation and saving the Visualization

Formating and Alignment of Visualization

  • Apply different styles and colors to the Visualization
  • Changing the options for Power BI

Creating Different Visualization in Power BI

  • Bar Chart,Stacked Bar Chart,Table,Pie Chart and other Types

Adding more controls in Power BI

  • Using Filter option for Visualization
  • Slicer Control and Synchronizing Slicers
  • Filter Top N Items
  • Buttons and Actions and ToolTips
  • Enabling Natural Language Query

Working with Advance Visualization

  • Waterfall chart
  • Scatter,Bubble,TreeMaps , Funnel Charts

Mesuring Performance in Power Bi

  • Creating Guage Chart,Card, KPIs

Data Transformation in Power BI

  • Managing Data in Power Query
  • Transforming Data of the Source

Using M Functions IN Power BI

  • Profile the Data
  • Functions and Parameters

DAX Functions in Power BI

  • Working with DAX Functions

Introducing Oracle Database 12c

  • List the features of Oracle Database
  • Discuss the basic design, theoretical and physical aspects of a relational database
  • Categorize the different types of SQL statements
  • Save queries to files and use script files in SQL*PLUS

Retrieving Data Using the SQL SELECT Statement

  • List the capabilities of SQL SELECT statements
  • Generate a report of data from the output of a basic SELECT statement
  • Select All Columns
  • Select Specific Columns
  • Use Column Heading Defaults
  • Use Arithmetic Operators
  • Understand Operator Precedence
  • Learn the DESCRIBE command to display the table structure

Restricting and Sorting Data

  • Write queries that contain a WHERE clause to limit the output retrieved
  • List the comparison operators and logical operators that are used in a WHERE clause
  • Describe the rules of precedence for comparison and logical operators
  • Use character string literals in the WHERE clause
  • Write queries that contain an ORDER BY clause sort the output of a SELECT statement
  • Sort output in descending and ascending order

Using Single-Row Functions to Customize Output

  • Describe the differences between single row and multiple row functions
  • Manipulate strings with character function in the SELECT and WHERE clauses
  • Manipulate numbers with the ROUND, TRUNC and MOD functions
  • Perform arithmetic with date data
  • Manipulate dates with the date functions

Using Conversion Functions and Conditional Expressions

  • Describe implicit and explicit data type conversion
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Nest multiple functions
  • Apply the NVL, NULLIF, and COALESCE functions to data
  • Use conditional IF THEN ELSE logic in a SELECT statement

Reporting Aggregated Data Using the Group Functions

  • Use the aggregation functions in SELECT statements to produce meaningful reports
  • Create queries that divide the data in groups by using the GROUP BY clause
  • Create queries that exclude groups of data by using the HAVING clause

Displaying Data From Multiple Tables

  • Write SELECT statements to access data from more than one table
  • View data that generally does not meet a join condition by using outer joins
  • Join a table by using a self join

Using Sub-queries to Solve Queries

  • Describe the types of problem that sub-queries can solve
  • Define sub-queries
  • List the types of sub-queries
  • Write single-row and multiple-row sub-queries

Using the SET Operators

  • Describe the SET operators
  • Use a SET operator to combine multiple queries into a single query
  • Control the order of rows returned when using the SET operators

Manipulating Data

  • Describe each DML statement
  • Insert rows into a table with the INSERT statement
  • Use the UPDATE statement to change rows in a table
  • Delete rows from a table with the DELETE statement
  • Save and discard changes with the COMMIT and ROLLBACK statements

Using DDL Statements to Create and Manage Tables

  • Categorize the main database objects
  • Review the table structure
  • List the data types available for columns
  • Create a simple table
  • Describe how constraints can be created at table creation
  • Describe how schema objects work

Certification

After completing course you will get a course completion certificate