Course Includes:
- Price: ₹ 14,999 ₹ 20,000
- Instrutor: Ramandeep Sharma
- Days: Monday - Friday
- Duration: 30 Hours
- Enrolled: 3 students
- Articles: 1 Article
- Language: English
- Certificate: Yes
PowerBi
- Learn to connect, transform, and model data from multiple sources including Excel, SQL, web, and Google Sheets
- Master data cleaning, shaping, and relationship building using Power BI Query Editor and Data Modelling tools
- Gain hands-on experience with DAX functions to create dynamic calculations, measures, and KPIs
- Design stunning interactive dashboards and visualizations using charts, maps, and advanced visuals
- Perform advanced analytics including time series analysis, key influencers, decomposition trees, and data insights
- Publish, share, and manage Power BI reports and dashboards with automation, role-based security, and mobile layouts
Course Curriculum
Module 1. Introduction
- Course Introduction
- Introduction to Power BI
Module 2. Terminologies and Interface
- Getting familiar with terminologies and interface
Module 3. Connecting Data Sources
- Supported Data Sources
- Importing data from files (Excel and flat files)
- Importing data from databases (Access, SQL)
- Importing data from Web URLs
- Importing data from Google Sheets
- Demo: Import data from Google Sheets, Excel files, and Web URLs
Module 4. Data Modelling
- Overview of Data and Relationship views
- Introduction to Query Editor and data transformations
- Merge and Append data
- Create relationships using auto-detect and custom relations
- Create, Transform, Load (ETL)
- Data shape transformation
- Data structure enhancement
Module 5. Profile the Data
- Identify data anomalies
- Simplify data structure
- Interrogate column properties
- Analyze data statistics
Module 6. DAX Functions
- Introduction to DAX
- DAX calculation types
- Aggregation and counting functions
- Logical, text, and information functions
- Date and time functions
- Filter functions
- Create new measures using DAX
- Hands-on demos using multiple DAX functions
Module 7. Visualizing Data
- Working with visuals
- Tables, Cards, Treemap
- Scatter Plot, Donut Chart
- Waterfall Chart, Map, Gauge Chart
- Custom visuals
- Creating mobile layouts and mobile-specific views
Module 8. Optimize Model Performance
- Data model performance optimization
- Cardinality reduction
- Optimize DirectQuery models
- Create and manage aggregations
- Query diagnostics
Module 9. Interactivity and Analytics
- Sorting and grouping data
- Visual, page, and report-level filters
- Creating interactivity
- Hierarchy and drill-down
- Conditional formatting
Module 10. Advanced Analytics
- Identify outliers
- Time series analysis
- Grouping and binning
- Key Influencer visual
- Decomposition Tree visual
Module 11. Publishing Power BI Service
- Publishing dashboards
- Sharing dashboards
- Scheduled refresh
- Quick insights
Module 12. Manage Datasets
- Datasets and parameters
- Dynamic reports with parameters
- Incremental refresh
- Row-level security (RLS)
- Promote and certify datasets
Module 13. Dashboards & Administration
- Create dashboards from reports
- Mobile and web views
- Add text, image, HTML, and video widgets
- Natural language queries
- Gateway setup and roles & permissions
Module 14. Projects
- Project 1 – End-to-end Power BI report
- Project 2 – Interactive dashboard with DAX & RLS
Course Rating
5.00 average rating based on 7 rating
Reviews
Write a Review
Haley Bennet
Oct 10, 2024Lorem ipsum dolor sit amet, consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
Simon Baker
Oct 10, 2024Lorem ipsum dolor sit amet, consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
Richard Gere
Oct 10, 2024Lorem ipsum dolor sit amet, consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.