Power BI course in Pune:

Power BI and SQL are two mighty technologies usually used in tandem for analysis of data and visualization.

SQL: SQL (Structured Query Language) is a programming language which helps in managing and manipulating relational databases. It allows developers to query, retrieve, insert, update and delete data from databases. This language has been widely used for data retrieval as well as manipulation tasks across several applications.

With SQL you can write queries to get the data out of SQL based database systems like Microsoft SQL Server, MySQL, Oracle etc. SQL provides powerful capabilities for filtering, aggregating, joining and transforming data within the database.

Pre-requisite Coverage :

• Introduction to Business Intelligence
• Understanding Table Structure and Schema Modelling
• Introduction to Basic SQL
• Concepts of Analysis (Trend Analysis, What-if, As is, Predictive)
• Data Aggregations, Groupings and Drill Downs
  
  Enroll in our power bi developer course in Pune Today.

Duration of Training  :  32 hrs

Batch type  :  Weekdays/Weekends

Mode of Training  :  Classroom/Online/Corporate Training

Hands on Project minimum 1 month duration.

Power Bi Training & Certification in Pune

Highly Experienced Trainer with 10+ yrs Exp. in Industry

Realtime Projects, Scenarios & Assignments

 COURSE CONTENT

Data Transformations :

• Introduction to Power BI Desktop
• Changing Locale
• Connecting to a Database
• Basic Transformations
• Managing Query Groups
• Splitting Columns, Changing Data Types, Working with Dates
• Removing and Reordering Columns
• Conditional Columns
• Merge Queries
• Query Dependency View
• Transforming Less Structured Data
• Query Parameters

 Data Modelling :

• Managing Data Relationships
• Creating Calculated Columns
• Optimizing Models for Reporting
• Creating Calculated Measures
• Creating and Managing Hierarchies
• Using Calculated Tables
• Time Intelligence
• Include and Exclude features
• Grouping and Binning

 Visualizing your Data :

• Introduction to charts: Pie, Tree map, Combo charts, Map Visualizations, Scatter plot, Table, Matrix, Gauge, Card, Shapes, Textboxes, Images and KPI
• Filter (Including TopN), Date Slicer
• Coloring Charts
• Page Layout, Positioning, Aligning, Sorting Visuals and Formatting
• Visual Relationship
• Custom Hierarchies

 Working with PBI Service :

• Overview of Dashboards and Service
• Uploading to Power BI Service
• Configuring a Dashboard
• Dashboard Settings
• In-Focus Mode
• Pinning a Live Page
• Custom URL and Title
• Export to CSV and Excel
• Power BI Notifications
• Publishing to Web

 Working with Excel :

• Importing Excel Data using Simple Table
• Connecting to Excel Workbook on OneDrive for Business
• Pinning Excel Tables or Visuals

 Organization Packs, Security and Groups :

• Creating a Group
• Creating, Using and Editing a Content Pack
• Row Level Security
• Data Classification
• Creating and Using Custom Visuals

IntelliBI Innovations is a trusted training center in administrative and software development courses from past 7+ years. IntelliBi offers strategic preparing ways for the certification abilities to upgrade yourself in a better way. Your success is our aim. We center around offering you the best classrooms/ virtual experience alongside the best client assistance. our certification from our technology partners also extends to our facilities. Our devotion to your prosperity is reflected in our agreeable staff, eager teachers and dynamic homeroom setting and hardware.