Business Intelligence (BI)

Experienced Mentors

Animeria offers the course in both Online and Classroom mode. Our Mentors are highly qualified and expereinced upto 12 years.

Live Projects

Animeria Provide Practical Based Learning with deep concepts. During Classes, Student will get exposure of working with live Database.

Advance Course Structure

As per comparison, Animeria ranked at No1. for providing the most advance course modules in the Industry.

Animeria Certification

Animeria, Known as The Most Trusted Educational Brand and registered under Ministry and its Certification valid all over.

Program gets you hands-on with data analysis and visualization in Advanced Excel along with equipping you with a understanding of data handling in Power BI with progression towards complex data visualization in Power BI.

 

  Learning Objectives

  1.  Learning using excel in Data Analysis and Visualization

              a. Using Excel inbuilt functions and user defined formula to for data analysis

              b. Using Excel Data Analysis Tool pack for data analysis

              c. Creating and customizing charts in excel for data visualization

    2. Data Visualization in Power BI

              a. Understanding Power BI Interface and Power BI Variants i.e. Power BI Desktop and Web

              b. Using Excel Data in power BI for visualization

              c. Reporting/Dashboarding using power BI

              d. Publishing Power BI Dashboards

              e. Data relationships and queries in Power BI

              f. Data Transformations in power BI

Class 1: INTRODUCTION TO POWER BI

  • Introduction to Power BI – Need, Importance
  • Power BI – Advantages and Scalable Options
  • History – Power View, Power Query, Power Pivot
  • Power BI Data Source Library and DW Files
  • Cloud Collaboration and Usage Scope
  • Business Analyst Tools, MS Cloud Tools
  • Power BI Installation and Cloud Account
  • Power BI Cloud and Power BI Service
  • Power BI Architecture and Data Access
  • On Premise Data Access and Microsoft On Drive
  • Power BI Desktop – Installation, Usage
  • Sample Reports and Visualization Controls
  • Power BI Cloud Account Configuration
  • Understanding Desktop & Mobile Editions
  • Report Rendering Options and End User Access
  • Power View and Power Map. Power BI Licenses
  • Course Plan – Power BI Online Training

Class 2: CREATING POWER BI REPORTS, AUTO FILTERS

  • Report Design with Legacy & .DAT Files
  • Report Design with Database Tables
  • Understanding Power BI Report Designer
  • Report Canvas, Report Pages: Creation, Renames
  • Report Visuals, Fields and UI Options
  • Experimenting Visual Interactions, Advantages
  • Reports with Multiple Pages and Advantages
  • Pages with Multiple Visualizations. Data Access
  • PUBLISH Options and Report Verification in Cloud
  • “GET DATA” Options and Report Fields, Filters
  • Report View Options: Full, Fit Page, Width Scale
  • Report Design using Databases & Queries
  • Query Settings and Data Preloads
  • Navigation Options and Report Refresh
  • Stacked bar chart, Stacked column chart
  • Clustered bar chart, Clustered column chart
  • Adding Report Titles. Report Format Options
  • Focus Mode, Explore and Export Settings

Class 3: REPORT VISUALIZATIONS and PROPERTIES

  • Power BI Design: Canvas, Visualizations and Fields
  • Import Data Options with Power BI Model, Advantages
  • Direct Query Options and Real-time (LIVE) Data Access
  • Data Fields and Filters with Visualizations
  • Visualization Filters, Page Filters, Report Filters
  • Conditional Filters and Clearing. Testing Sets
  • Creating Customized Tables with Power BI Editor
  • General Properties, Sizing, Dimensions, and Positions
  • Alternate Text and Tiles. Header (Column, Row) Properties
  • Grid Properties (Vertical, Horizontal) and Styles
  • Table Styles & Alternate Row Colors – Static, Dynamic
  • Sparse, Flashy Rows, Condensed Table Reports. Focus Mode
  • Totals Computations, Background. Bodes Properties
  • Column Headers, Column Formatting, Value Properties
  • Conditional Formatting Options – Color Scale
  • Page Level Filters and Report Level Filters
  • Visual-Level Filters and Format Options
  • Report Fields, Formats and Analytics
  • Page-Level Filters and Column Formatting, Filters
  • Background Properties, Borders and Lock Aspect

Class 4: CHART AND MAP REPORT PROPERTIES

  • chart report types and properties
  • stacked bar chart, stacked column chart
  • clustered bar chart, clustered column chart
  • 100% stacked bar chart, 100% stacked column chart
  • line charts, area charts, stacked area charts
  • line and stacked row charts
  • line and stacked column charts
  • waterfall chart, scatter chart, pie chart
  • Field Properties: Axis, Legend, Value, Tooltip
  • Field Properties: Color Saturation, Filters Types
  • Formats: Legend, Axis, Data Labels, Plot Area
  • Data Labels: Visibility, Color and Display Units
  • Data Labels: Precision, Position, Text Options
  • Analytics: Constant Line, Position, Labels
  • Working with Waterfall Charts and Default Values
  • Modifying Legends and Visual Filters – Options
  • Map Reports: Working with Map Reports
  • Hierarchies: Grouping Multiple Report Fields
  • Hierarchy Levels and Usages in Visualizations
  • Preordered Attribute Collection – Advantages
  • Using Field Hierarchies with Chart Reports
  • Advanced Query Mode @ Connection Settings – Options
  • Direct Import and In-memory Loads, Advantages

Class 5: HIERARCHIES and DRILLDOWN REPORTS

  • Hierarchies and Drilldown Options
  • Hierarchy Levels and Drill Modes – Usage
  • Drill-thru Options with Tree Map and Pie Chart
  • Higher Levels and Next Level Navigation Options
  • Aggregates with Bottom/Up Navigations. Rules
  • Multi Field Aggregations and Hierarchies in Power BI
  • DRILLDOWN, SHOWNEXTLEVEL, EXPANDTONEXTLEVEL
  • SEE DATA and SEE RECORDS Options. Differences
  • Toggle Options with Tabular Data. Filters
  • Drilldown Buttons and Mouse Hover Options @ Visuals
  • Dependent Aggregations, Independent Aggregations
  • Automated Records Selection with Tabular Data
  • Report Parameters: Creation and Data Type
  • Available Values and Default values. Member Values
  • Parameters for Column Data and Table / Query Filters
  • Parameters Creation – Query Mode, UI Option
  • Linking Parameters to Query Columns – Options
  • Edit Query Options and Parameter Manage Entries
  • Connection Parameters and Dynamic Data Sources
  • Synonyms – Creation and Usage Options

Class 6: POWER QUERY & M LANGUAGE – Part 1

  • Understanding Power Query Editor – Options
  • Power BI Interface and Query / Dataset Edits
  • Working with Empty Tables and Load / Edits
  • Empty Table Names and Header Row Promotions
  • Undo Headers Options. Blank Columns Detection
  • Data Imports and Query Marking in Query Editor
  • JSON Files & Binary Formats with Power Query
  • JavaScript Object Notation – Usage with M Lang.
  • Applied Steps and Usage Options. Revert Options
  • creating Query Groups and Query References. Usage
  • Query Rename, Load Enable and Data Refresh Options
  • Combine Queries – Merge Join and Anti-Join Options
  • Combine Queries – Union and Union All as New Dataset
  • M Language: Nested Join and Join Kind Functions
  • REPLACE, REMOVE ROWS, REMOVE COL, BLANK – M Lang
  • Column Splits and Filled Up / Filled Down Options
  • Query Hide and Change Type Options. Code Generation

Class 7: POWER QUERY & M LANGUAGE – Part 2

  • Invoke Function and Freezing Columns
  • Creating Reference Tables and Queries
  • Detection and Removal of Query Datasets
  • Custom Columns with Power Query
  • Power Query Expressions and Usage
  • Blank Queries and Enumeration Value Generation
  • M Language Semitics and Syntax. Transform Types
  • ELSE Conditions, Transform Column () Types
  • Remove Columns (), Split Columns (),Replace Value()
  • Distinct Options and GROUP BY Options
  • Group (), Table. Sort () with Type Conversions
  • PIVOT Operation and Table. Pivot (). List Functions
  • Using Parameters with M Language (Power Query Editor)
  • Advanced Query Editor and Parameter Scripts
  • List Generation and Table Conversion Options
  • Aggregations using Power Query & Usage in Reports
  • Report Generation using Web Pages & HTML Tables
  • Reports from Page collection with Power Query
  • Aggregate and Evaluate Options with M Language
  • Creating high-density reports, ArcGIS Maps, ESRI Files
  • Generating QR Codes for Reports
  • Table Bars and Drill Thru Filters

Class 8: DAX EXPRESSIONS – Level 1

  • Purpose of Data Analysis Expressions (DAX)
  • Scope of Usage with DAX. Usability Options
  • DAX Context: Row Context and Filter Context
  • DAX Entities: Calculated Columns and Measures
  • DAX Data Types: Numeric, Boolean, Variant, Currency
  • Date time Data Type with DAX. Comparison with Excel
  • DAX Operators & Symbols. Usage. Operator Priority
  • Parenthesis, Comparison, Arithmetic, Text, Logic
  • DAX Functions and Types: Table Valued Functions
  • Filter, Aggregation and Time Intelligence Functions
  • Information Functions, Logical, Parent-Child Functions
  • Statistical and Text Functions. Formulas and Queries
  • Syntax Requirements with DAX. Differences with Excel
  • Naming Conventions and DAX Format Representation
  • Working with Special Characters in Table Names
  • Attribute / Column Scope with DAX – Examples
  • Measure / Column Scope with DAX – Examples

Class 9: DAX EXPRESSIONS – Level 2

  • YTD, QTD, MTD Calculations with DAX
  • DAX Calculations and Measures
  • Using TOPN, RANKX, RANK.EQ
  • Computations using STDEV & VAR
  • SAMPLE Function, COUNTALL, ISERROR
  • ISTEXT, DATEFORMAT, TIMEFORMAT
  • Time Intelligence Functions with DAX
  • Data Analysis Expressions and Functions
  • DATESYTD, DATESQTD, DATESMTD
  • ENDOFYEAR, ENDOFQUARTER, ENDOFMONTH
  • FIRSTDATE, LASTDATE, DATESBETWEEN
  • CLOSINGBALANCEYEAR, CLOSINGBALANCEQTR
  • SAMEPERIOD and PREVIOUSMONTH, QUARTER
  • KPIs with DAX. Vertipaq Queries in DAX
  • ELSEIF. Conditions with DAX
  • Slicing and Dicing Options with Columns, Measures
  • DAX for Query Extraction, Data Mashup Operations
  • Calculated Columns and Calculated Measures with DAX

Class 10: POWERBI DEPLOYMENT & CLOUD

  • PowerBI Report Validation and Publish
  • Understanding PowerBI Cloud Architecture
  • PowerBI Cloud Account and Workspace
  • Reports and DataSet Items Validation
  • Dashboards and Pins – Real-time Usage
  • Dynamic Data Sources and Encryptions
  • Personal and Organizational Content Packs
  • Gateways, Subscriptions, Mobile Reports
  • Data Refresh with Power BI Architecture
  • PBIX and PBIT Files with Power BI – Usage
  • Visual Data Imprts and Visual Schemas
  • Cloud and On-Premise Data Sources
  • How PowerBI Supports Data Model?
  • Relation between Dashboards to Reports
  • Relation between Datasets to Reports
  • Relation between Datasets to Dashboards
  • Page to Report – Mapping Options
  • Publish Options and Data Import Options
  • Need for PINS @ Visuals and PINS @ Reports
  • Need for Data Streams and Cloud Integration

Class 11: POWER BI CLOUD OPERATIONS

  • Report Publish Options and Verifications
  • Working with Power BI Cloud Interface & Options
  • Navigation Paths with “My Workspace” Screens
  • FILE, VIEW, EDIT REPORTS, ACCESS, DRILLDOWN
  • Saving Reports into pdf, ptx, etc. Report Embed
  • Report Rendering and EDIT, SAVE, Print Options
  • Report PIN and individual Visual PIN Options
  • Create and Use Dashboards. Menu Options
  • Goto Dashboard and Goto LIVE Page Options
  • Operations on Pinned Reports and Visuals
  • TITLE, MEDIA, USAGE METRICS & FAVOURITES
  • SUBSCRIPTION Options and Reports with Mobile View
  • Options with Report Page: Print and Subscribe
  • Report Actions: USAGE METRICS, ANALYSE IN EXCEL
  • Report Actions: RELATED ITEMS, RENAME, DELETE
  • Dashboard Actions: METRICS, RELATED ITEMS
  • Dashboard Actions: SETTINGS FOR Q & A, DELETE
  • PIN Actions: METRICS, SHARE, RELATED ITEMS
  • PIN Actions: SETTINGS FOR Q & A, DELETE
  • EDIT DASHBOARD (CLOUD), On-The-Fly Reports
  • Dataset Actions: CREATE REPORT, REFRESH
  • SCHEDULED REFRESH & RELATED ITEMS
  • Dashboard Integration with Apps in Power BI

 

Class 12: IMPROVING POWER BI REPORTS

  • Publish PowerBI Report Templates
  • Import and Export Options with Power BI
  • Dataset Navigations and Report Navigations
  • Quick Navigation Options with “My Workspace
  • Dashboards, Workbooks, Reports, Datasets
  • Working with MY WORK SPACE group
  • Installing the Power BI Personal Gateway
  • Automatic Refresh – Possible Issues
  • Adding images to the dashboards
  • Reading & Editing Power BI Views
  • Power BI Templates (pbit)- Creation, Usage
  • Managing report in Power BI Services
  • PowerBI Gateway – Download and Installation
  • Personal and Enterprise Gateway Features
  • PowerBI Settings: Dataset – Gateway Integration
  • Configuring Dataset for Manual Refresh of Data
  • Configuring Automatic Refresh and Schedules
  • Workbooks and Alerts with Power BI
  • Dataset Actions and Refresh Settings with Gateway
  • Using natural Language Q&A to data – Cortana

Class 13: INSIGHTS AND SUBSCRIPTIONS

  • Data Navigation Paths and Data Splits
  • Getting data from existing systems
  • Data Refresh and LIVE Connections
  • pbit and pixy: differences. Usage Options
  • Quick Insights for Power BI Reports
  • Quick Insights for PowerBI Dashboards
  • Generating Insights with Cloud Datasets
  • Generating Reports with Cloud Datasets
  • Using relational databases on-premises
  • Using relational databases in the cloud
  • Consuming a service content pack
  • Creating a custom data set from a service
  • Creating a content pack for your organization
  • Consuming an organizational content pack
  • Updating an organizational content pack
  • Adding Tiles: Images, Videos, DataStream’s
  • Creating New Reports from Cortana, Advantages

Class 14: POWERBI INTEGRATION ELEMENTS

  • SSRS Integration with Power BI
  • SSRS Report Portal URL to Power BI Cloud
  • Power BI KPI Reports Vs SSRS KPI Reports
  • Converting and Working with Mobile Reports
  • Report Builder Reports to Power BI
  • Generating QR Codes and Report Security
  • Reporting JSON Files, Bulk Data Loads
  • Creating high-density Reports in Power BI
  • OLAP Data Sources in Power BI
  • Using MDX Queries with PowerBI Queries
  • MDX SELECT and Perspective Access
  • KPIs and MDX Expressions with Power BI
  • MDX Queries and Filters with Power BI
  • Linked Servers and T-SQL SPROCs with MDX
  • YTD, PARALLELPERIOD, SCOPE, ALLMEMBERS
  • WHERE, EXCEPT, RANGE, NONEMPTY
  • CURRENT & EMPTY, AND / OR, LEFT / RIGHT
  • Implementing Row Level Security (RLS)
  • Security Roles and Role Members. Tests
  • Using R for Power BI, Streaming Datasets
  • Azure Connections with PowerBI Desktop
  • Power BI Reports using SQL Azure DBs

 

  • Have basic knowledge of working in the Windows environment and Microsoft excel
  • Knowledge of Math’s/Statistics up to Class XII

RELATED COURSES IN TREND

STUDENT REVIEWS

Recently Completed Power BI Course by Mr Nitin Jha, a Corporate Trainer in 6 to 8 pm Batch. Classes were Online and I found Animeria Training up to the mark. I got a Complimentory Course of Ms Excel along with Power BI. My fees for Online was approx 35k. Training was Good. Thanks Nitin Sir.
Rajni Sharma
Data Analyst at Silvertouch
I had successfully completed the Classroom Training for Business Intelligence in 3 months . The exposure by Nitin Sir is mind Blowing. He provide us genuine Corporate data for Analyzing and Visualizing .I will surely recommend to everyone to join Animeria for Power BI.
Rahul Sharma
Data Administrator at Gael Infortech
I am enrolled in September Classroom Batch. Till Now i am happy for my decission to join Animeria. I was referred by one of my Corporate Friend to join Animeria. They don't give me any demo before admission. I was worried but now i am confident. Shashi Ma'am has the best skills over databases and transferring the same to us
Rajat Shokeen
B.tech 3rd year
I joined Animeria at 2nd for this course. I joined another Institute for Business Intelligence and wasted my money in full fledge. I sudden get a call from Animeria then i took Online demo and it was so good that i planned to join Animeria
Nitesh SHarma
MIS Expert at Trademark Department

Power BI

Business Intelligence

Power BI can collect your company data, whether it’s located in the cloud or locally, and provides quick and easy access to this data. Your customers get a live 360 ° view of their business, enabling them to search and explore their data quickly and easily.

Student Ratings
0%
Practical Learning
0%
Placement Assistance
0%
Data Analysis and Visualization in Excel and Power BI

Learn analyzing data and visualizing data with Advanced Excel and build & publish dashboards in Power BI by Microsoft. Extensive Learning hours with 38 hours of classroom training including the classroom assessment with additional 36 hours of online guided practice for better learning and increased retention.