Data Analytics Course in Bangalore

Marathahalli, Bangalore
8050601060
ayaz@riainstitute.in
Marathahalli Branch

Power BI Course Marathahalli

Master the art of data visualization. Learn to create interactive dashboards, stunning reports, and drive data-driven decisions with our Power BI training in Marathahalli.

Duration
2 Months
Mode
Classroom & Online
Fee
₹11,800/-

Enquire Now

✓

Query Sent!

We will call you shortly.

Course Curriculum

1

Introduction to BI & Power BI

  • Understanding Business Intelligence concepts
  • Installation & Configuration of Power BI Desktop
  • Introduction to Data Modeling and Star Schema
  • Navigating Power BI Interface and Workspaces
2

Data Transformation & Modeling

  • Data Profiling in Power Query Editor
  • Handling Missing Values & Errors
  • Creating Relationships between tables
  • Introduction to Data Analysis Expressions (DAX)
3

Visualization Techniques

  • Creating Charts (Bar, Pie, Line, Area)
  • Using Slicers for interactive filtering
  • Formatting visuals for professional reports
  • Introduction to Custom Visuals
4

DAX Fundamentals

  • Understanding DAX syntax and context
  • Calculated Columns and Measures
  • Aggregation Functions (SUM, COUNT, AVERAGE)
  • Filtering and Evaluation Context
5

Advanced DAX Concepts

  • Time Intelligence Functions (YTD, MTD, QTD)
  • Variables and Parameters
  • Row-Level Security (RLS)
  • DAX Studio for debugging code
6

Publishing & Sharing

  • Publishing reports to Power BI Service
  • Configuring Scheduled Refreshes
  • Sharing Dashboards via Embed Code
  • Using Power BI Mobile App

Why Choose RIA Institute?

👨‍🏫

Microsoft Certified Trainers

Learn from certified Power BI professionals who are experts in data modeling and visualization.

📈

Real-Time Dashboards

Work on creating live business dashboards and solving real-world reporting challenges during classes.

💼

Marathahalli Center

Our training center in Marathahalli is easily accessible from across Bangalore, offering weekday and weekend batches.

🤝

Industry Standard Curriculum

Our syllabus is aligned with the latest Power BI updates and industry visualization practices.

Marathahalli Branch

Power BI Course Marathahalli

Master the art of data visualization. Learn to create interactive dashboards, stunning reports, and drive data-driven decisions with our Power BI training in Marathahalli.

Duration
2 Months
Mode
Classroom & Online
Fee
₹11,800/-

    Enquire Now






    Course Curriculum

    1

    Power BI Introduction & Reporting

    • Introduction to Power BI: Need/Importance/Advantages, History (PowerView, Power Query, Power Pivot), Data Source Library, Cloud Collaboration, Installation, Architecture, Data Access, OnPremise/OnDrive.
    • Creating Reports: Design with Legacy/.DAT/Database Tables, Designer/Canvas/Pages, Visuals/Interactions, Filters, Report Fields, View Options, Navigation, Refresh, Charts.
    • Report Visuals & Properties: Import/Direct Query, Visuals/Fields/Filters, Conditional Filters, Custom Tables, General/Size/Pos/Header Properties, Grid/Styles, Totals/Column Formatting.
    2

    Charts, Maps & Hierarchies

    • Charts/Maps: Stacked/Clustered Bar/Column, Line/Area/Waterfall/Scatter/Pie, Map Reports, Hierarchies, Drilldown, Advanced Query Mode.
    • Hierarchies & Drilldown: Hierarchy Levels, Drill Modes, Drill-thru Options, Toggle Options, Aggregates, Report Parameters, Dynamic Data Sources, Parameters, Query Mode, Linking Parameters.
    3

    Power Query & M Language (Part 1)

    • Editor & Interface: Understanding Power Query Editor, Working with Empty Tables, Load/Edits, Header Promotions.
    • Data Imports: JSON Files & Binary Formats, JavaScript Object Notation, Applied Steps, Query Groups/References, Query Rename/Load.
    • M Language: Combine Queries (Merge/Anti-Join, Union), NestedJoin/JoinKind Functions, Replace/Remove/Columns/Split, FillUp/Down.
    4

    Power Query & M Language (Part 2)

    • Advanced Transformations: Invoke Function, Reference Tables, Removing Datasets, Custom Columns, M Language Semantics/Syntax (If/Else, TransformColumn).
    • Aggregations & Lists: Table.Distinct, Table.Group, Table.Sort, PIVOT Operation, Table.Pivot, Using Parameters, Advanced Query Editor, List Generation.
    • Advanced Data Gen: Aggregations using PowerQuery, Reports from Web Pages/HTML Tables, High-density Reports, ArcGIS Maps, ESRI Files, Generating QR Codes.
    5

    DAX Expressions (Level 1)

    • Core Concepts: Purpose/Scope, Row/Filter Context, Entities (Calc Columns/Measures), Data Types, Operators/Symbols.
    • Functions: Table Valued Functions, Filter/Aggregation/Time Intelligence, Information/Logical/Parent-Child Functions, Statistical/Text Functions.
    • Syntax: Naming Conventions, Attribute/Column Scope, Measure/Column Scope.
    6

    DAX Expressions (Level 2)

    • Calculations: YTD/QTD/MTD, Calculations/Measures, TOPN/RANKX, STDEV/VAR, SAMPLE/COUNTALL/ISERROR/ISTEXT/DATE/TIMEFORMAT.
    • Time Intelligence: Data Analysis Expressions, DATESYTD/DATESQTD/DATESMTD, ENDOFYEAR/QUARTER/MONTH, FIRSTDATE/LASTDATE, DATESBETWEEN.
    • Advanced: CLOSINGBALANCEYEAR/QUARTER, SAMEPERIOD, PREVIOUSMONTH, KPIs, Vertipaq, IF/ELSEIF conditions.
    7

    Power BI Deployment & Cloud

    • Deployment: Publish, Cloud Architecture, Workspace, Reports/Datasets, Dashboards/Pins, Dynamic Data Sources.
    • Cloud Features: Personal/Organizational Content Packs, Gateways, Subscriptions, Mobile Reports, Refresh, PBIX/PBIT Files, Visual Schemas.
    • Data Model: Dashboards to Reports, Datasets to Reports, Page to Report mapping, Publish Options, Data Import, Data Streams.
    8

    Power BI Cloud Operations

    • Operations: Publish/Options, Navigation (My Workspace), File/View/Edit/Access/Save/Print, Pin, Goto Dashboard/Live.
    • Management: Media, Usage Metrics/Favourites, Subscriptions, Settings/Q&A, Edit Dashboard, Dataset Actions.
    • Integration: Dashboard Integration with Apps, CREATE/USE Dashboards, Menu Options, Operations on Pinned Reports/Visuals.
    9

    Improvements, Insights & Subscriptions

    • Improvements: Templates, Import/Export, Navigations, Work Space, Personal Gateway, Automatic Refresh, Adding images, Managing reports, Enterprise Gateway, Data Refresh, Cortana Q&A.
    • Insights: Data Nav/Splits, Existing Systems, pbit/pbix differences, Quick Insights, Generating Reports, Relational DBs (OnPrem/Cloud), Service Content, Organizational Packs, Adding Tiles, Cortana.
    10

    Power BI Integration Elements

    • Integration: SSRS Integration, Report Builder to Power BI, Generating QR Codes, JSON/Bulk Loads, High-Density Reports, OLAP DataSources.
    • MDX & Security: MDX Queries (Select/Perspective), KPIs and MDX Expressions, Linked Servers/T-SQL Procs, Implementing Row Level Security (RLS), Security Roles/Members.
    • Advanced: Using R for Power BI, Streaming DataSets, Azure Connections, PowerBI Reports using SQL Azure DBs.

    Why Choose RIA Institute?

    👨‍🏫

    Microsoft Certified Trainers

    Learn from certified Power BI professionals who are experts in data modeling and visualization.

    📈

    Real-Time Dashboards

    Work on creating live business dashboards and solving real-world reporting challenges during classes.

    💼

    Marathahalli Center

    Our training center in Marathahalli is easily accessible from across Bangalore, offering weekday and weekend batches.

    🤝

    Industry Standard Curriculum

    Our syllabus is aligned with the latest Power BI updates and industry visualization practices.