Data Analytics (Using Power BI)

Book Demo

Data Analytics

Power BI is a powerful tool for data analytics and visualization. It allows you to connect to various data sources, transform and model the data, and create interactive reports and dashboards.

Training Modes:

Online Training
Corporate Training
Video Training

Training Highlights:

  •  Clean Data with Power Query
  •  Understand Import, Direct Query and Live Modes
  •  Understand Schedule Refresh using Data Gateways
  •  Understand Data Modeling
  •  Understand Row Level Security
  •  Understand PBI Cloud Service Deployment
  •  Write Complex DAX
  •  Create Visualizations
  •  Build Reports and Dashboards

Data Analyst Training

Brochure Download
Register Now

Technical FAQs & Mastery Modules

No Content

No Content

No Content

No Content

No Content

No Content

  1. Power BI Introduction
  2. Data Visualization, Reporting
  3. Business Intelligence (BI), Traditional BI, Self-Serviced BI
  4. Cloud Based BI cloud service VS On Premise BI
  5. Power BI Products
  6. Power BI Desktop
    (Power Query -transformation, Power Pivot- modeling, Power View -reports)
  7. Flow of Work in Power BI Desktop
  8. Server, Power BI Service, Power BI Mobile
  9. Flow of Work in Power BI / Power BI Architecture
  10. A Brief History of Power BI

  1. Power BI Desktop Installation
  2. Building Blocks of Power BI
  3. Datasets, Visualizations, Reports, Dashboards, Tiles
  4. Power BI Desktop User Interface
  5. Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas
  6. Overview of Power Query / Query Editor - Extract, Transform & Load Data
  7. Connecting to Data Sources, Establish connection to the Excel source
  8. Importing Data into Power BI or Query Editor
  9. Transforming the Data using Power Query
  10. Model the Data using Power Pivot – Relationship View
  11. Creating New Measures and New Columns using DAX – Data View
  12. Visualizing the Data using Power View and Power Maps – Report View
  13. Saving and Publishing the Visuals or Reports
  14. Logon to Power BI Service
  15. View the Reports in PBI Service and Share the reports Power View

  1. Report View User Interface
  2. Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas
  3. Visual Interactions
  4. Interaction Type (Filter, Highlight, None)
  5. Visual Interactions Default Behavior, Changing the Interaction Bookmarks, drill through, drilldown, slicer, hierarchy, groupings

  1. Filter Types
  2. Visual Level Filters, Page Level Filters, Report Level Filters, Drill through Filters
  3. Filter Sub Types
  4. Basic Filtering, Advanced Filtering, Top N, Relative Date Filtering
  5. Numeric field filters, Text field filters, Date and Time field Filters

  1. Grouping and Binning Introduction
  2. Using grouping, Creating Groups on Text Columns
  3. Using binning, Creating Bins on Number Column and Date Columns
  4. Sorting Data in Visuals
  5. Changing the Sort Column, Changing the Sort Order
  6. Sort using column that is not used in the Visualization
  7. Sort using the Sort by Column button

  1. Hierarchy Introduction, Default Date Hierarchy
  2. Creating Hierarchy, Creating Custom Date Hierarchy
  3. Change Hierarchy Levels
  4. Drill-Up and Drill-Down Reports
  5. Data Actions, Drill Down, Drill Up, Show Next Level, Expand Next Level
  6. Drilling filters other visuals option

  1. Visualizing Data, Why Visualizations
  2. Visualization types, Field Wells
  3. Visuals for Filtering, Visualizing Categorical Data, Visualizing Trend Data
  4. Visualizing KPI Data, Visualizing Tabular Data, Visualizing Geographical Data
  5. Leveraging Power BI Custom Visuals

  1. Slicer Visualization
  2. When to use a Slicer
  3. Create and format Slicer Visualization
  4. Hierarchy Slicer (Custom Visualization)
  5. When to use a Hierarchy Slicer
  6. Create and format Hierarchy Slicer
  7. Advantages of Hierarchy Slicer

  1. Create and Format Bar and Column Charts
  2. Create and Format Stacked Bar Chart Stacked Column Chart
  3. Create and Format Clustered Bar Chart, Clustered Column Chart
  4. Create and Format 100% Stacked Bar Chart, 100% Stacked Column Chart
  5. Create and Format Pie and Donut Charts
  6. Create and Format the Tree Map Visual
  7. Create and Format Scatter Charts

  1. Line and Area Charts
  2. Create and Format Line Chart, Area Chart, Stacked Area Chart
  3. Combo Charts
  4. Create and Format Line and Stacked Column Chart, Line and Clustered Column Chart
  5. Create and Format Ribbon Chart, Waterfall Chart, Funnel Chart

  1. Create and Format Gauge Visual, KPI Visual
  2. Create and Format Card Visualization, Multi Row Card

No Content

  1. Data Transformation, Benefits of Data Transformation
  2. Shape or Transform Data using Power Query
  3. Overview of Power Query / Query Editor, Query Editor User Interface
  4. The Ribbon (Home, Transform, Add Column, View Tabs)
  5. The Queries Pane, the Data View / Results Pane, The Query Settings Pane, Formula Bar
  6. Advanced Editor – Complete ETL Code
  7. Saving Your Work – Appling ETL Changes – Loading into Power Pivot Model
  8. Power Query Conceptually

  1. Data types, Changing the Data type of a Column
  2. Filters in Power Query
  3. Auto Filter / Basic Filtering
  4. Filter a Column using Text Filters
  5. Filter a Column using Number Filters
  6. Filter a Column using Date Filters
  7. Filter Multiple Columns

  1. Remove Columns / Remove Other Columns
  2. Name / Rename a Column
  3. Reorder Columns or Sort Columns
  4. Add Column / Custom Column
  5. Split Columns
  6. Merge Columns
  7. PIVOT, UNPIVOT Columns
  8. Transpose Columns

  1. Header Row or Use First Row as Headers
  2. Keep Top Rows, Keep Bottom Rows
  3. Keep Range of Rows
  4. Keep Duplicates, Keep Errors
  5. Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows
  6. Remove Duplicates, Remove Blank Rows, Remove Errors
  7. Group Rows / Group By

  1. Append Queries
  2. Append Queries as New
  3. Append 2 or more files individually with different queries
  4. Appending multiple files of same type from a folder using single query
  5. Query Options
  6. Copy Query, Paste Query
  7. Delete Query, Rename Query
  8. Enable Load, Include in report Refresh
  9. Duplicate Query, Reference Query
  10. Move to Group, Move Up, Move Down

  1. Merge Queries, Merge Queries as New
  2. Default Types of Joins / Join Kinds / Merge Type
  3. Left Outer (all from first, matching from second)
  4. Right Outer (all from second, matching from first)
  5. Full Outer (all rows from both)
  6. Inner (only matching rows)
  7. Left Anti (rows only in first)
  8. Right Anti (rows only in second)
  9. Cartesian Join or Cross Join

No Content

  1. Data Modeling Introduction
  2. Relationship, Need of Relationship
  3. Relationship Types / Cardinality in General
  4. One-to-One, One-to-Many (or Many-to-One), Many-to-Many
  5. AutoDetect the relationship, Create a new relationship, Edit existing relationships
  6. Make Relationship Active or Inactive
  7. Delete a relationship
  8. Cross filter direction (Single, Both), Assume Referential Integrity

  1. What is DAX, Calculated Column, Measures?
  2. DAX Table and Column Name Syntax
  3. Creating Calculated Columns, Creating Measures
  4. Implicit Vs Explicit Measures
  5. Calculated Columns Vs Measures
  6. DAX Syntax & Operators
  7. DAX Operators
  8. Types of Operators
  9. Arithmetic Operators, Comparison Operators, Text Concatenation Operator, Logical operators

No Content

  1. Date and Time Functions
  2. Logical Functions
  3. Text Functions
  4. Math & Statistical Functions
  5. Filter Functions
  6. Time Intelligence Functions

  1. YEAR, MONTH, DAY
  2. WEEKDAY, WEEKNUM
  3. Month Name, Weekday NameàFORMAT (Text Function)
  4. DATE, TODAY, NOW
  5. HOUR, MINUTE, SECOND, TIME
  6. DATEDIFF, CALENDAR
  7. Creating Date Dimension Table

  • IF
  • TRUE, FALSE
  • NOT, OR, IN, AND
  • IFERROR

  1. LEN, CONCATENATE (&)
  2. LEFT, RIGHT, MID
  3. UPPER, LOWER
  4. TRIM, SUBSTITUTE, BLANK

  1. INT
  2. ROUND, ROUNDUP, ROUNDDOWN
  3. DIVIDE
  4. EVEN, ODD
  5. POWER, SIGN
  6. SQRT, FACT
  7. SUM, SUMX
  8. MIN, MINX
  9. MAX, MAXX
  10. COUNT, COUNTX
  11. AVERAGE, AVERAGEX
  12. COUNTROWS, COUNTBLANK

  1. CALCULATE
  2. ALL
  3. RELATED

  1. Time Intelligence Introduction
  2. TOTALMTD, TOTALQTD, TOTALYTD
  3. PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR
  4. NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR
  5. SAMEPERIODLASTYEAR
  6. YOY Growth
  7. MOM Growth

  • Create and Format Table Visual, Matrix Visualization
  • Create and Format Map Visual, Filled Map Visual, Arc GIS Maps Visual
  • Create and Format R Script Visual

No Content

  1. Power BI Service Introduction, Power BI Cloud Architecture
  2. Creating Power BI Service Account, SIGN IN to Power BI Service Account
  3. Publishing Reports to the Power BI service, Import / Getting the Report to PBI Service
  4. My Workspace / App Workspaces Tabs
  5. DATASETS, WORKBOOKS, REPORTS, DASHBOARDS
  6. Working with Datasets, Creating Reports in Cloud using Published Datasets
  7. Power BI Datasets Live Connection using Desktop
  8. Working with Workbooks, working with Reports, Sharing Reports

  1. Creating Dashboards
  2. Pin Visuals and Pin LIVE Report Pages to Dashboard
  3. Advantages of Dashboards
  4. Interacting with Dashboards
  5. Adding Tiles to Dashboards
  6. Web Content, Image, Text Box, Video
  7. Formatting Dashboard
  8. Sharing Dashboard

  1. Introduction to Data Gateways
  2. How Data Gateways work
  3. Connect to an on premise Data Source by using a Data Gateway
  4. Download Data Gateway
  5. Installing a Data Gateway
  6. Types of Gateways
  7. On-premises Data Gateway, On-premises Data Gateway (personal mode)
  8. Manage Data Gateway
  9. Add and Remove Administrators
  10. Add Data Source, Add or Remove Users to a Data Source
  11. Refresh On Premise Data
  12. Configuring Automatic Refresh using Schedules

  1. Introduction to App Workspaces
  2. Create an App Workspace
  3. Add Members to App Workspace to Collaborate
  4. App Workspace Access
  5. Admin, Member, Contributor

  1. Introduction to App
  2. Publish an App
  3. Update a Published App
  4. Manage Content in App
  5. Include in App, Exclude in App
  6. Sharing App
  7. Entire Organization, Specific individuals or group
  8. Un-publishing an App
  9. Specific Groups, My Entire Organization
  10. Selecting the Content / Items to Publish or Share

  1. Introduction to Row Level Security
  2. Row Level Security (RLS) with DAX
  3. Manage Roles, Creating Roles, Testing Roles
  4. Adding Members to Roles in Power BI Service
  5. Dynamic Row Level Security
  6. Creating Users Table and Adding to the Model
  7. Capturing users using UserName () or UserPrincipalName () DAX Functions

No Content

  1. Creating a Project
  2. Relationship and measures
  3. Measures and their usage
  4. Advantages of Tabular model
  5. Limitations

  1. Tabular – Development Server
  2. Workspace Server configuration
  3. SSAS Configuration management
  4. Project, Model – Properties

  1. Creating new model
  2. Importing data from different sources
  3. Create and Maintain relationship across data sources
  4. Creating measures and their usage
  5. Creating calculated columns
  6. Creating Hierarchies based on data sources
  7. Deployment

  1. Managing Server Properties
  2. Managing Cube properties
  3. Deploy the Cube

  1. Real-time Project Explanation
  2. Resume Preparation
  3. Interview Questions Discussions
  4. Mock Interviews

Why Choose Data Analytics

  •  100% Real-Time and Practical
  •  Concept wise FAQs
  •  TWO Real-time Case Studies, One Project
  •  24/7 LIVE Server Access
  •  Realtime Project FAQs
  •  Course Completion Certificate
  •  Placement Assistance
  •  Job Support
REGISTER NOW

Book Your FREE Demo Now!

Council for Inclusive Development

24x7 LIVE Online Server (Lab) with Real-time Databases. Course includes ONE Real-time Project.

REGISTER TODAY!
Live Online Training
Corporate Training
Videos Training
CALL NOW +7905830865
Scroll to Top