Power BI Development || Admin || Modelling || DAX
Power BI Development || Admin || Modelling || DAX, available at $49.99, has an average rating of 4.5, with 44 lectures, based on 3 reviews, and has 22 subscribers.
You will learn about Power BI Desktop Installation,Architecture of Power BI,Data sources and Visual Types,Canvas, Visualization and fields Format Button and data labels,Legend, Category and Grid,Visual Interaction, Data Points,Edit Interaction,Format Options,PBIX and PBIT File Formats Spotlight and Focus Mode,Tooltips Visual Sync, Grouping,Slicer Visual: Real-Time Usage,Orientation, Selection Properties,Single and Multi-Select, Ctrl Options Slicer: Number, Text and Date Data,Slicer List and Slicer Drop Down,Visual sync,Disabling Slicer,Clear selection Limitation with slicers Hierarchies, Filters:Creating Hierarchies in Power BI,Independent Drill-Down Options,Dependent Drill-Down Options Conditional Drilldowns, Data Points,Drill Up Buttons and Operations,Expand & Show Next Level Options Dynamic Data Drills Limitations,Show Data and See Records,Filters : Types and Usage in Real-time Visual Filter, Page Filter, Report Filter,Basic, Advanced and TOP N Filters,Category and Summary Level Filters,Drill Thru Filters, Drill Thru Reports Drill-thru Filters, Page Navigations,Bookmarks: Real-time Usage,Bookmarks for Visual Filters, Bookmarks for Page Navigation Selection Pane with Bookmarks Buttons, Images with Actions Buttons, Actions and Text URLs,Bookmarks View & Selection Pane Import & Direct Query with Power BI,SQL Queries and Enter Data,Data Modelling : Currency, Relations,Summary, Format, Synonyms,Web View & Mobile View Module 8: Power Query Level 1,Power Query M Language Purpose,Power Query Architecture and ETL, Data Types, Literals and Values,Power Query Transformation Table & Column Transformations,Text & Number Transformations,Date, Time and Structured Data List, Record and Table Structures let, source, in statements M Lang ,Power Query Functions, Parameter,Invoke Functions, Execution Results Get Data, Table Creations and Edit,Merge and Append Transformations, Join Kinds, Advanced Editor, Apply ETL Operations with Power Query Power Query Level 2 Query Duplicate, Query Reference,Group By and Advanced Options,Aggregations with Power Query Transpose, Header Row Promotion,Reverse Rows and Row Count,Data Type Changes & Detection,Replace Columns: Text, NonText Replace Nulls: Fill Up, Fill Down,PIVOT, UNPIVOT Transformations,Move Column and Split Column Extract, Format and Numbers Date & Time Transformations,Deriving Year, Quarter, Month, Day, Add Column : Query Expressions,Query Step Inserts and Step Edits Creating Parameters in Power Query, Parameter Data Types, Default Lists,Static/Dynamic Lists For Parameters,Removing Columns and Duplicates Convert Tables to List Queries,Linking Parameters to Queries,Testing Parameters and PBI Canvas,Multi-Valued Parameter Lists Creating Lists in Power Query,Converting Lists to Table Data,Advanced Edits and Parameters,Data Type Conversions, Expressions Columns From Examples, Indexes,Conditional Columns, Expressions Power BI Cloud – 1,Power BI Service Architecture,Power BI Cloud Components, Use App Workspace, Report Publish,Reports & Related Data Creating New Reports in Cloud,Report Publish and Report Uploads,Dashboards Creation and Usage,Adding Tiles to Dashboards Pining Visuals and Report Pages,Visual Pin Actions in Dashboards,LIVE Page Interaction in Dashboard,Dashboards Actions, Report Actions DataSet Actions: Create Report,Share, Metrics and Exports,Mobile View & Dashboard Themes,Q & A, and Pin Visuals,Export, Subscribe Favorite, Insights, Embed Code,Featured Dashboards and Refresh,Gateways Configuration, PBI Service Gateway Types, Cloud Connections,Gateway Data Refresh : Manual, Automatic,Power Query Expressions,Import and Upload Options in Excel,Excel Workbooks and Dashboards Datasets in Excel and Dashboards,Using Excel Analyser in Power BI,Using Excel Publisher in PBI Cloud,Excel Workbooks, PINS in Power BI Excel ODC Connections, Power Pivot,Row Level Security (RLS) with DAX,Need for RLS in Power BI Cloud,Data Modelling in Power BI Desktop DAX Roles Creation and Testing,Adding Power BI Users to Roles,Custom Visualizations in Cloud,Create Report on PBI Services,View Usage Metrics DAX Functions This course is ideal for individuals who are Power BI Developer or Fresher + Experience Professional or Anyone who is interested to learn amazing Reporting tool It is particularly useful for Power BI Developer or Fresher + Experience Professional or Anyone who is interested to learn amazing Reporting tool.
Enroll now: Power BI Development || Admin || Modelling || DAX
Summary
Title: Power BI Development || Admin || Modelling || DAX
Price: $49.99
Average Rating: 4.5
Number of Lectures: 44
Number of Published Lectures: 44
Number of Curriculum Items: 44
Number of Published Curriculum Objects: 44
Original Price: ₹3,999
Quality Status: approved
Status: Live
What You Will Learn
- Power BI Desktop Installation,Architecture of Power BI,Data sources and Visual Types,Canvas, Visualization and fields
- Format Button and data labels,Legend, Category and Grid,Visual Interaction, Data Points,Edit Interaction,Format Options,PBIX and PBIT File Formats
- Spotlight and Focus Mode,Tooltips
- Visual Sync, Grouping,Slicer Visual: Real-Time Usage,Orientation, Selection Properties,Single and Multi-Select, Ctrl Options
- Slicer: Number, Text and Date Data,Slicer List and Slicer Drop Down,Visual sync,Disabling Slicer,Clear selection Limitation with slicers
- Hierarchies, Filters:Creating Hierarchies in Power BI,Independent Drill-Down Options,Dependent Drill-Down Options
- Conditional Drilldowns, Data Points,Drill Up Buttons and Operations,Expand & Show Next Level Options
- Dynamic Data Drills Limitations,Show Data and See Records,Filters : Types and Usage in Real-time
- Visual Filter, Page Filter, Report Filter,Basic, Advanced and TOP N Filters,Category and Summary Level Filters,Drill Thru Filters, Drill Thru Reports
- Drill-thru Filters, Page Navigations,Bookmarks: Real-time Usage,Bookmarks for Visual Filters, Bookmarks for Page Navigation
- Selection Pane with Bookmarks Buttons, Images with Actions Buttons, Actions and Text URLs,Bookmarks View & Selection Pane
- Import & Direct Query with Power BI,SQL Queries and Enter Data,Data Modelling : Currency, Relations,Summary, Format, Synonyms,Web View & Mobile View
- Module 8: Power Query Level 1,Power Query M Language Purpose,Power Query Architecture and ETL, Data Types, Literals and Values,Power Query Transformation
- Table & Column Transformations,Text & Number Transformations,Date, Time and Structured Data
- List, Record and Table Structures let, source, in statements M Lang ,Power Query Functions, Parameter,Invoke Functions, Execution Results
- Get Data, Table Creations and Edit,Merge and Append Transformations, Join Kinds, Advanced Editor, Apply ETL Operations with Power Query
- Power Query Level 2 Query Duplicate, Query Reference,Group By and Advanced Options,Aggregations with Power Query
- Transpose, Header Row Promotion,Reverse Rows and Row Count,Data Type Changes & Detection,Replace Columns: Text, NonText
- Replace Nulls: Fill Up, Fill Down,PIVOT, UNPIVOT Transformations,Move Column and Split Column Extract, Format and Numbers
- Date & Time Transformations,Deriving Year, Quarter, Month, Day, Add Column : Query Expressions,Query Step Inserts and Step Edits
- Creating Parameters in Power Query, Parameter Data Types, Default Lists,Static/Dynamic Lists For Parameters,Removing Columns and Duplicates
- Convert Tables to List Queries,Linking Parameters to Queries,Testing Parameters and PBI Canvas,Multi-Valued Parameter Lists
- Creating Lists in Power Query,Converting Lists to Table Data,Advanced Edits and Parameters,Data Type Conversions, Expressions
- Columns From Examples, Indexes,Conditional Columns, Expressions
- Power BI Cloud – 1,Power BI Service Architecture,Power BI Cloud Components, Use App Workspace, Report Publish,Reports & Related Data
- Creating New Reports in Cloud,Report Publish and Report Uploads,Dashboards Creation and Usage,Adding Tiles to Dashboards
- Pining Visuals and Report Pages,Visual Pin Actions in Dashboards,LIVE Page Interaction in Dashboard,Dashboards Actions, Report Actions
- DataSet Actions: Create Report,Share, Metrics and Exports,Mobile View & Dashboard Themes,Q & A, and Pin Visuals,Export, Subscribe
- Favorite, Insights, Embed Code,Featured Dashboards and Refresh,Gateways Configuration, PBI Service Gateway Types, Cloud Connections,Gateway
- Data Refresh : Manual, Automatic,Power Query Expressions,Import and Upload Options in Excel,Excel Workbooks and Dashboards
- Datasets in Excel and Dashboards,Using Excel Analyser in Power BI,Using Excel Publisher in PBI Cloud,Excel Workbooks, PINS in Power BI
- Excel ODC Connections, Power Pivot,Row Level Security (RLS) with DAX,Need for RLS in Power BI Cloud,Data Modelling in Power BI Desktop
- DAX Roles Creation and Testing,Adding Power BI Users to Roles,Custom Visualizations in Cloud,Create Report on PBI Services,View Usage Metrics
- DAX Functions
Who Should Attend
- Power BI Developer
- Fresher + Experience Professional
- Anyone who is interested to learn amazing Reporting tool
Target Audiences
- Power BI Developer
- Fresher + Experience Professional
- Anyone who is interested to learn amazing Reporting tool
-
Introduction to Power BI: Students will gain a basic understanding of what Power BI is and its role in business intelligence. They will learn about the different components of Power BI, including Power BI Desktop, Power BI Service, and Power BI Mobile.
-
Data Sources and Data Transformation: Students will learn how to connect to various data sources, such as databases, Excel files, SharePoint, and online services. They will understand how to import and transform data using Power Query Editor to clean and shape the data for analysis.
-
Data Modeling: Students will learn about data modeling concepts in Power BI. They will understand how to create relationships between different tables, define measures and calculated columns using DAX (Data Analysis Expressions), and create hierarchies for organizing data.
-
Data Visualization: Students will gain skills in creating visually appealing and interactive reports and dashboards in Power BI. They will learn how to use different types of visualizations (such as charts, tables, maps, and slicers) to present data effectively. They will also explore formatting options and best practices for designing engaging visualizations.
-
Power Query: Students will learn advanced techniques in Power Query for data transformation and manipulation. They will understand how to use functions, conditional statements, and other data shaping techniques to clean and prepare data for analysis.
-
DAX (Data Analysis Expressions): Students will gain proficiency in using DAX formulas to create calculations, measures, and calculated columns in Power BI. They will learn how to write DAX expressions for aggregating, filtering, and manipulating data to derive meaningful insights.
-
Interactive Reports and Dashboards: Students will learn how to create interactive reports and dashboards in Power BI. They will understand how to add interactivity through slicers, filters, and drill-through actions to enable users to explore data and gain insights.
-
Data Refresh and Sharing: Students will learn how to refresh data in Power BI and schedule automatic data refreshes. They will understand how to publish and share reports and dashboards with others, both within the organization and externally.
-
Power BI Service: Students will gain an understanding of the Power BI Service, which is the cloud-based platform for sharing and collaborating on Power BI content. They will learn how to publish reports, create workspaces, manage access and permissions, and utilize collaboration features.
-
Advanced Analytics and Custom Visualizations: Depending on the course, students may also learn about advanced analytics features in Power BI, such as forecasting, clustering, and sentiment analysis. They may also explore custom visualizations, where they can import and use third-party visualizations to extend the capabilities of Power BI.
-
Power BI Service Overview: Students will gain an understanding of Power BI Service, which is the cloud-based platform for sharing, collaborating, and publishing Power BI reports and dashboards. They will learn how to navigate the Power BI Service interface, manage workspaces, and utilize collaboration features.
-
Sharing and Collaboration: Students will learn how to share Power BI reports and dashboards with colleagues, teams, and stakeholders. They will understand different sharing options, set access permissions, and manage content collaboration within Power BI Service.
-
Data Refresh and Scheduling: Students will learn how to schedule and manage data refresh in Power BI Service. They will understand how to configure automatic data refresh for reports and datasets, ensuring that the data is up to date and accurate.
-
Power BI Mobile: Students will explore Power BI Mobile, the mobile app for accessing and interacting with Power BI reports and dashboards on smartphones and tablets. They will learn how to navigate the app, view reports offline, and utilize mobile-specific features for enhanced user experience.
-
DAX Formulas and Functions: Students will dive deeper into DAX formulas, which are used for calculations and data modeling in Power BI. They will learn advanced DAX functions and techniques for creating complex calculations, time intelligence, filtering, and conditional logic.
-
Calculated Columns and Measures: Students will understand the difference between calculated columns and measures in Power BI and when to use each. They will learn how to create and use calculated columns and measures effectively for data analysis and visualization.
-
Advanced Data Modeling: Students will learn advanced data modeling techniques using DAX in Power BI. They will explore concepts such as hierarchies, calculated tables, and many-to-many relationships. They will understand how to optimize data models for performance and efficiency.
-
Advanced Visualization Techniques: Students will gain skills in creating advanced visualizations using DAX expressions. They will learn how to use DAX to customize and enhance visualizations, create dynamic visuals, and implement advanced charting techniques.
-
Advanced Analytics with DAX: Students will explore advanced analytics capabilities in Power BI using DAX. They will learn how to perform statistical analysis, implement advanced calculations, and create complex data models to support advanced analytics scenarios.
-
Performance Optimization: Students will understand techniques for optimizing the performance of Power BI reports and dashboards. They will learn how to improve query performance, optimize data models, and manage large datasets efficiently.
Course Curriculum
Chapter 1: Introduction
Lecture 1: Power BI Installation-1
Lecture 2: Power BI Installation-2
Lecture 3: Report Hands On
Lecture 4: Visual Properties-Sorting,spotlight,export,focus mode
Lecture 5: Filter Types 1- Visual, Page, Report, DrillThrough
Lecture 6: Filter Types 2 – Basic, Advanced, TopN
Lecture 7: Edit Interaction and Sync Slicer
Lecture 8: BookMark-Switch Visuals
Lecture 9: BookMark-ClearFilter
Lecture 10: BookMark-ON_OFF_Button
Lecture 11: BookMark-Slicer Panel
Lecture 12: Tooltip
Lecture 13: DrillDown
Lecture 14: Conditional Formatting
Lecture 15: Hierarchy
Lecture 16: Ribbon-1
Lecture 17: Ribbon-2
Lecture 18: TransformData-Home Tab
Lecture 19: TransformData-Home Tab
Lecture 20: TransformData-Home Tab
Lecture 21: TransformData-Transform Tab
Lecture 22: TransformData- Add Column Tab
Lecture 23: Power BI Service-Email Creation
Lecture 24: Power BI Service-Email Creation
Lecture 25: Power BI Service- Publish Report, Workspace, Dashboard
Lecture 26: Power BI Service- Create Report,datasets,Download,Export,QR Code,Search,View
Lecture 27: Power BI Service-Quick Insight
Lecture 28: Power BI Service- Metrics,Quick Insight,Subscription,Sharing,RLS
Lecture 29: Power BI Service – Delete,Uses of Shared with me, App Creation
Lecture 30: Power BI Services-Schedule Refresh,Gateway Installation
Lecture 31: SQL Connectivity
Lecture 32: Web Connectivity
Lecture 33: RelationShip-1
Lecture 34: Relationship-2
Lecture 35: Relationship-3
Lecture 36: Relationship-4
Lecture 37: 1.DAX-Date and Time Functions
Lecture 38: 2.DAX-Text Functions
Lecture 39: 3.DAX-Logical Functions
Lecture 40: 4.DAX-Information Functions
Lecture 41: 5.DAX-Math & Statistical Functions
Lecture 42: 6.DAX-Time Intelligence Functions
Lecture 43: 7.DAX-Table Functions
Lecture 44: Custom Visual
Instructors
-
Sachin Agrawal
Technical Lead-Business Intelligence
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 0 votes
- 3 stars: 1 votes
- 4 stars: 0 votes
- 5 stars: 2 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024