Data Science Training Course in Thane Mumbai | Insys Technologies
• Classroom Training   • Live Online Training   • Corporate Training  • Live Projects & Guidance 

+91 7045518424 / +91 7021019517

info@insystechnologies.in


ISO 9001:2015 Certified
Enquiry

Power BI

Power BI Information

Power BI is a business analytics tool developed by Microsoft that enables users to visualize data and share insights across their organization. It integrates with a wide range of data sources, allowing users to create interactive reports and dashboards. With Power BI, users can easily explore data, identify trends, and make informed decisions.

The platform is user-friendly, offering drag-and-drop features and a variety of customizable visualizations. It also supports real-time data analysis, ensuring that businesses can stay up-to-date with their latest metrics.

 

Curriculum
Module 1 - Power BI Introduction
  • Power BI Desktop
  • Flow of Work in Power BI Desktop
  • A Brief History of Power BI
Module2 : Power Query
  • Introduction
  • Data Transformation, Benefits of Data Transformation
  • Overview of Power Query / Query Editor, Query Editor User Interface The
  • Ribbon (Home, Transform, Add Column, View Tabs)
  • Saving the Work
  • Datatypes, Changing the Datatype of a Column Filter in Power Query
  • Auto Filter / Basic Filtering
  • Filter a Column using Text Filters
  • Filter a Column using Number Filters
  • Filter a Column using Date Filters
  • Filter Multiple Columns
  • Remove Columns
  • Name / Rename a Column
  • Useful functions in Numpy
  • Reorder Columns or Sort Columns
  • Add Column
  • Merge Columns
  • Transpose Columns
  • Header Row or Use First Row as Headers
  • Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows
  • Remove Duplicates, Remove Blank Rows, Remove Errors
  • Group Rows / Group By
Module3 : DAX
  • Introduction to R
  • What is DAX, Calculated Column, Measures
  • DAX Table and Column Name Syntax
  • Creating Calculated Columns, Creating Measures Calculated
  • DataFrames
  • Columns Vs Measures
  • DAX Syntax & Operators
  • DAX Operators
Module 4 - Time Intelligence Functions Date and Time Functions
  • YEAR, MONTH, DAY
  • WEEKDAY, WEEKNUM
  • FORMAT (Text Function) à Month Name, Weekday Name
  • DATE, TODAY, NOW
  • HOUR, MINUTE, SECOND, TIME
  • DATEDIFF, CALENDAR
  • Creating Date Dimension Table
Module 5 - Text Functions
  • LEN, CONCATENATE (&)
  • LEFT, RIGHT, MID UPPER
  • LOWER
  • TRIM, SUBSTITUTE, BLANK
Module 6: Logical Functions
  • IF
  • TRUE, FALSE NOT
  • OR, IN, AND
  • IFERROR SWITCH
Module 7 - Math & Statistical Functions
  • ROUND, ROUNDUP, ROUNDDOWN
  • DIVIDE
  • EVEN, ODD
  • POWER, SIGN
  • SQRT, FACT
  • SUM, SUMX
  • MIN, MINX
  • MAX, MAXX
  • COUNT, COUNTX
  • AVERAGE, AVERAGEX
  • COUNTROWS, COUNTBLANK
Module 8 - Visualizations
  • Visualizing Data, Why Visualizations
  • Visualization types, Create and Format Bar and Column Charts
  • Create and Format Stacked Bar Chart Stacked Column Chart
  • Create and Format Clustered Bar Chart, Clustered Column Chart
  • Create and Format Stacked Bar Chart, Stacked Column Chart
  • Why Big Data
  • Create and Format Pie and Donut Charts
  • Create and Format Scatter Charts
  • Create and Format Line Chart, Area Chart, Stacked Area Chart
Module 9 - Creating Dashboards
  • Advantages of Dashboards
  • Interacting with Dashboards
  • Formatting Dashboard

Courses

Related Courses

Trending Courses

img

Data Science
Data Science
img

Machine Learning & AI
Machine Learning & AI
img

Python

Python
img

Cloud Computing
Cloud Computing
img

AWS

AWS
img

IT-IMS (Networking & Server)
IT-IMS (Networking & Server)
img

Web App. Development

Web App. Development
img

Data Analytics

Data Analytics
img

Power BI Course
Power BI Course