7030957575 7264857575 info@itupgrad.com 2nd floor, above Yuga Hotel, Pimpri-Chinchwad

Business Intelligence Master's Programme

Business Intelligence

Master's Programme

Power BI is a business analytics service tool by Microsoft. It aims to supply interactive visualisations and business intelligence capabilities with an interface simple enough for end users to make their own reports and dashboards.

It can be used for exploratory data analysis. Web automation that imports CSV to Salesforce. Business Intelligence Master Program aims with Business Intelligence and Analytics, organisations can convert data into useful business insights. It provides exposure to relevant tools like SQL, Data Warehousing, Informatica, Microsoft BI Vs Tableau.
  • Any Graduate/Any Post-Graduate
  • Freshers/Working Professionals
  • Perform Power BI desktop data transformation
  • Describe Power BI desktop modelling
  • Implement the Power BI service
  • Connect directly to data stores
  • Describe the Power BI developer API
Business Intelligence Master's Programme
Timeline and Prerequisite
90 Hrs
Course Duration
Business Intelligence Master's Programme
Curriculum
  • Introduction to Power BI
    • Introduction to Data warehouse
    • Data warehouse Tools
    • What is Power BI?
    • Power BI – Flow of Activity
    • Building Blocks of Power BI
    • Power BI – Primary Tools: Power Pivot, Power Query, Power View, Power Map, Power Q&A, Power BI Desktop
  • Power BI Desktop
    • Power BI Desktop – Install
    • Data Sources and Connections
    • Connect to Data in Power BI Desktop
    • How to use Query Editor in Power BI
    • Advanced Data Changes and Transformation
    • Views in Power BI Desktop
    • Modeling Data - Manage Data Relationship, Create Calculated Columns, Optimise Data Models
  • Data Analysis Expressions (DAX)
    • What is DAX?
    • Data Types in DAX
    • Calculation Types
    • DAX Functions: Date and Time, Time Intelligence, Information, Logical, Mathematical, Statistical, Text
    • Aggregate Measures in DAX
    • Table Relationships and DAX
  • Data visualisation
    • Why Data Visualization
    • Practices for Data Visualization
    • How to use Visual in Power BI
    • Reports in Power BI
    • Charts in Power BI (Scatter, Waterfall, Funnel)
    • Slicers
    • Map Visualisations
    • Gauges and Single Number Cards
  • Custom visualisations
    • What Are Custom Visuals?
    • Ofce Store
    • Downloading Custom Visuals
    • Importing Custom Visuals in Power BI Report
    • KPI Visuals
    • Data Binding in Power BI
  • Power BI Integration page And Administration
    • Data Gateways
    • Content packs
    • Power BI Report Server
  • Power BI Embedded
    • Power BI Embedded Conceptual Model
    • Workspace Collection
    • Adding Power BI content to a Workspace
    • Application Authentication Tokens
    • Parts of Power BI embedded - REST API
    • Power BI Embedding without an Embed Token
    • Power BI Embedding with an Embed Token
  • Power BI Q&A
    • Power BI Q&A
    • Dashboard
    • Dashboard vs Reports
    • Creating a Dashboard
    • Dashboard Tiles
    • Pinning Tiles
    • Quick Insights with Power BI
    • Power BI Publisher for Excel