This Repository has Power BI Training Materials developed by Myla Ram Reddy.
Please contact Renuka for Training and Certification @ 8374899166(whatsapp)
Gain a 360° of how to explore and use Power BI to build impactful reports. In this course, you’ll go from zero to hero, as you discover how to use this popular business intelligence platform through hands-on exercises. You’ll first learn how to confidently load and transform data using Power Query and the importance of data models, before diving into creating visualizations using Power BI’s drag-and-drop functionality. You’ll also learn how to drill-down into reports and make your reports fully interactive. Lastly, you'll level-up your skills using DAX formulas (Data Analysis Expressions) to create customized calculated columns and fields to better analyze your data. Get started now. You've got the power!
PBI01_03_Demo_Power_View.mp4
PBI01_04_Demo_Power_Service.mp4
PBI01_05_Demo_Apps.mp4
PBI01_06_Demo_Summary.mp4
-
Introduction
- What is Power Platform?
- What are the products of Power Platform?
- Power BI
- Power Apps
- Power Automate
- Power Virtual Agents
- What are the different BI tools available?
- Why Power BI? Why not other BI tools like (Tableau/OBIEE/Cognos/SAP-BO/ ... etc)
- What are the Products of Power BI (Power BI Desktop/ Power BI Pro / Power BI Premium / Power BI Mobile / Power BI Embedded / Power BI Report Server)
- What is Power BI Desktop?
- What is Power Query ?
- What is Power Pivot ?
- What is Power View ?
- What is Power Maps ?
- What is Power BI Service?
- What is Power BI Mobile?
- What is M-Language?
- What is DAX?
-
Data Warehousing Concepts
- What is OLTP?
- What is Data warehouse
- Difference between OLTP Vs OLAP
- Difference among Primery Key/Foriegn Key/Surrogate Key
- Types of Tables
- Dimension Tables
- Fact Tables
- Types of Schemas
- Star Schema
- Snow Flake Schema
- Mixed Schema
-
Power BI Desktop
- Introduction to Power BI Desktop
- Power BI Desktop Components
- Power Query Editor
- Power Pivot
- Power View
-
Power BI Desktop - Power Query Editor
- Connecting to new Source
- File Connections (Excel,CSV,XML,JSON,Folder ... etc)
- Connecting to Databases (MySql,MSSqlServer,Access dtatabase,...etc)
- Cloud Connections(SnowFlake Database, Azure SQL Database ... etc)
- Online Connections(Web,Github,Linkedin ... etc)
- Types of Connections
- Import
- Direct
- Live Connection
- Importing Tables -
- Basic Transformations
- Changing datatypes
- replacing nulls with zero
- concatnating columns
- Computing new columns from available columns
- spliting columns
- renameing columns
- observing transformation steps
- understanding M-Language
- Computed columns/calculations
- M-Language
- About Let and In
- Single Line comments in M-language
- Multi line comments in M-language
- How to write M-language code in multiple lines
- Change Steps in Query settings and observe in M-language
- Change M-language and observe Query Setting Steps
- Build Query using M-Language Script from Blank Query
- Combine Queries
- Append
- Learn SQL Queries of union ,Union all,Minus
- Prove Power BI Append is equal to Union all
- Merge
- Inner Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Left Anti Join
- Right Anti Join
- Learn how to implement Cross join,Non equi join,self join.
- Learn SQL Queries of Joins
- Append
- Query Folding
- What is query folding
- What are the sources support Query Folding
- How to see Native Query
- Project 1: Power Query Editor Level Project
- Import Data from Access Database
- Import Data from a Folder Containing CSV Files
- Import a Less Structured Data from an Excel File
- Connecting to new Source
-
Power BI Desktop - Power Pivot - Modelling
- Introduction
- What is Relationship?
- What is Cardinality
- Types of cardinality
- What cardinality is used between fact and dimension tables and why?
- Can we use many to many cardinality? if we want to skip what are the workarounds?
- Can we use one to one cardinality? if we want to skip what are the workarounds?
- What is active relationship ?
- What is inactive Relationship ?
- When to go for Inactive relation ships ?
- What is role playing dimension? Can we use active and inactive both between role playing dimension and fact ?
- What is Cross Filter Direction?
- Types of Cross Filter Directions?
- What type of direction used in star schema?
- When to go for Single direction?
- When to go for Both direction?
-
Power BI Desktop - Power Pivot - Data Analysis Expressions(DAX)- Calculations
- Introduction
- When to go for new column
- When to go for New Mesure
- New column Vs New Measure
- What is Implicity Mesure
- What is Explicity Mesure
- What is compound Mesure
- What is Computed column?
- Where to create New column in Power Query or DAX ?
- Date and time functions
- CALENDAR
- CALENDARAUTO
- DATE
- DATDIFF
- DATEVALUE
- NOW
- TODAY
- CALENDAR Vs CALENDARAUTO
- NOW Vs TODAY
- ... etc
- Information functions
- USERNAME
- USERPRINCIPALNAME
- USERNAME Vs USERPRINCIPALNAME
- ISBLANK
- ISEMPTY
- ISBLANK Vs ISEMPTY
- HASONEVALUE
- ... etc
- Logical functions
- IF
- IFERROR
- AND
- ... etc
- Math and trignometic functions
- DIVIDE
- DIVIDE Vs /
- TRUNC
- ROUND
- ... etc
- Relationship functions
- CROSSFILTER
- USERELATIONSHIP
- Statistical functions
- Explain Itterator Functions
- sumx
- countx
- minx
- maxx
- rankx
- SUM Vs SUMX
- COUNT Vs COUNTX
- COUNTA Vs COUNTAX
- COUNT Vs COUNTA
- Explain Itterator Functions
- Filter functions
- ALL
- FILTER
- SELECTEDVALUE
- CALCULATE
- CALCULATETABLE
- Difference between Calculate Vs Calculatetable
- REMOVEFILTERS
- ...etc
- Time intelligence functions
- SAMEPERIODLASTYEAR
- TOTALYTD
- ...etc
- Explain DAX Statements
- Define
- Evalute
- Var
- Order By
-
DAX Studio
- Introduction
- Installation
- What are Power BI External Tools
- Open Power BI Model in DAX Studio
- What is DAX Query
- See Dax Query using Performance Analyser tool
- SQL Query Vs DAX Query
- Write Few Queries from Scratch
- select * from Customer Vs EVALUATE Customer
- select city from customer Vs EVALUATE VALUES(Customer[City])
- select * from customer where city ="redmond" Vs EVALUATE CALCULATETABLE ( Customer, Customer[City] = "Redmond" )
- ... etc
- Project 2: Power Pivot Level Project
- Manage Table Relationships
- Last Year Comparison
- Year to Date
- Market Share
- Optimize the Data Model
-
Power BI Desktop - Power View - Report - Visualization
- Introduction
- Hierarchy
- Creating hierarchy
- Drill down
- Drill Up
- Show Next Level
- Expand Next Level
- Drill Through
- Back button
- Customise back button and use userdefined image as back button
- Filters
- Vizulization level filter
- Page Level Filter
- All pages or Report level Filter
- Drill through Filter
- Slicer
- Sync Slicers
- Edit Interactions
- Row Level Security(RLS)
- Row Context Filter
- Bookmarks, Actions, Buttons and Images
- What is book mark
- Understand Bookmarks Pane
- Understand Selections Pane
- Create book marks
- Use bookmark and buttons to Clear All Slicers in Power BI
- Use book marks and images to switch pie and bar charts
- Use Slicers,image andpage naviagation to navigate to required page -
- Visulizations
- Slicer
- Table
- Matrix
- Column Chart
- Bar Chart
- Pie
- Donut
- Treemap
- Bar Chart with Line
- Waterfall
- Scatter Chart
- Project 3: Power View Level Project
- Page Layout and Formatting
- Visual Relationship
- Duplicate Page
- Categories with No Data
- Default Summarization and Categorization
- Positioning, Aligning, and Sorting Visuals
- Custom Hierarchies
- Python - Visual Integration
- Cross-Tabular Report
- Part-to-Whole Report
- Relationship Report
- Trend Report
- Rank Report
-
Power BI Service
- Introduction
- Signup and access app.powerbi.com
- Workspace
- Create Workspace
- Publish PBIX to workspace
- Upload PBIX to workspace
- Upload Spread sheet to workspace
- Dashboard
- Create Dashboard
- Pin Vizulization to Dashboard
- Pin Entire page(live Page) to dashboard
- Pin Vs Pin Live
- Share Dashboard
- Edit Dashboard
- Tiles
- Web Content Tile
- Image Tile
- Text Tile
- Video Tile
- Dashboard Layouts
- Dashboard Mobile View
- Dashboard Web View
- Featured and Favorite Dashboard
- Filtering Dashboard
- Dashboard Settings
- Q&A - Natural Language Queries - NLP
- Printing Dashboard and Exporting Data
- Export to CSV and Excel
- Apps
- Creating App
- Updating App
- Controling reports visibility in app
- Organizing Content
- Creating section in apps
- Creating external links
- Shareing the app to business users
-
Power BI Gateways
- Introduction
- What is Gateway
- Types of Gateways
- Personal Gateway
- Standalone or enterprise gateway
- Installation of Gateway
- Configuring Gateway
- Scheduling
- Refreshing Dataset daily 8 times in Pro licence
- Refreshing Dataset daily 48 times in Premium licence
- Refreshing dateset weekly
- Updateing source credentials of dataset
- Incremental Refresh
- RangeStart
- RangeEnd
- Refresh only last 10 days data
-
Power BI Connections
- Import
- Direct
- Live
- Streaming
- Difference among above 4 connections
-
Power BI Performance Tunning
- Performance Analyser
- Query Folding
- Index
- Dax Formulas tuning
-
Power BI Security
- Authentication
- Object Level Authrization
- Admin
- Member
- Contributor
- Viewer
- Row Level Security
- Static
- Dynamic -
-
Power BI Cmdlets and Rest APIs
- Install Cmdlets
- Connect power BI
- Disconnect Power BI
- Get list of workspaces
- Get list of users
- Add users to workspaces
- Remove users from workspaces
- Create New Workspace
- Export list of reports
- Export list of dashboards
- Backup list of reports/dashboards
- Create Empty Dashboard
- provide security to users using power shell script
-
Deployment Pipelines
- What is environment
- Types of environments
- What is deployment pipeline
- Create deployment pipeline
- Push ojects from development environment to Test Environment
- Push ojects from Test environment to Production Environment
- Compare any two environments
- push only required objects from one environment to another environment
-
SSAS Multidimensional Models using in PowerBI
- Download and Restore Sample Data
- Install SQL Server Analysis Services
- Learn Basic of SSAS
- Develop a simple Cube
- Deploy Cube
- Develop PBI Report using Cube
-
Using Snowflake computing warehouse in Power BI Desktop
- Signup to snowflake
- Create database
- Create warehouse
- load data
- understand basics of snowflake
- connect snowflake using Power BI
- Develop reports
-
Run Python scripts in Power BI Desktop
- Install Python
- Install Numpy,Pandas and Matplotlib packages
- Configre Powerbi to use python
- Write python script to create dataframe
- Develop Power BI report using dataframe
-
Power BI Pro Vs Premium
- Understand all from https://powerbi.microsoft.com/en-us/pricing/
-
Writing CV
-
Marketing CV
- What is the class duration?
- 45 days
- How Many days in a week?
- Monday to Friday
- What time?
- Slot 1: 7AM IST to 8 AM IST or 8:30 PM ET to 9:30 PM ET (Running Batch)(iam half Way in this)
- Slot 2: 8AM to 9AM IST or 9:30 PM to 10:30 PM ET(New Batch)
- Where to get Materials?
- from Github cloud https://github.com/rritec/powerbi
- Where to get Videos?
- From our website https://datahexa.com/course/power-bi/
- Support after course completion?
- CV writing
- Job Marketing
- Once we got job then Job Support