Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI Services & DAX
Rating: 3.9 out of 5(5 ratings)
13 students

Power BI Services & DAX

Power BI Services & DAX
Created bySachin Agrawal
Last updated 4/2022
English
English [Auto],

What you'll learn

  • Power BI Cloud - 1 ,Power BI Service Architecture, Power BI Cloud Components,Use,App Workspaces,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 [Cortana] 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

Course content

1 section • 16 lectures • 2h 7m total length

  • PBI Services0- Email Creation3:22

    Create a cloud services account, verify with a mobile code, and set your domain as your company name to enable email creation in Power BI services.

  • PBI Services0- Email Creation4:00

    Learn to set up Power BI services by inviting users, configuring licenses, and enabling email-based access, while navigating cloud services and login requirements in an organization.

  • PBI Services1- Publish Report, Workspace, Dashboard9:26

    Publish reports to a Power BI service workspace, create and manage workspaces, and build dashboards, while understanding pro and premium licensing and sharing requirements for end users.

  • PBI Services2 - Create Report,dataset,Download,Export,QR Code,Search,View10:08

    Learn how to create a report and dataset in Power BI, and manage download, export, QR code access, search, and viewing on mobile and web devices.

  • PBI Services3- Metrics,Quick Insight,Subscription,Sharing,RLS15:07

    Explore how to use metrics to identify who accessed reports, set up a quick insight, create subscriptions, share reports securely, and implement row-level security in Power BI services.

  • PBI Services3- Metrics,Quick Insight,Subscription,Sharing,RLS3:35

    Explore Power BI services features such as metrics, quick insight, subscriptions, sharing, and row-level security to publish, manage access, and collaborate securely within workspaces.

  • PBI Services4 - Delete,Uses of Shared with me, AppCreation8:10

    Learn how to manage shared with me items and app creation in Power BI by handling delete options for reports, datasets, and workspaces, and publishing apps to end users.

  • PBI Services5-ScheduleRefresh,Gateway Installation15:28

    Explore installing and configuring the gateway, connecting on-premises and cloud data sources, and scheduling refresh in Power BI services, including workspace management, report publishing, and licensing options.

  • 1.DAX-Date and Time Functions11:33

    Explore DAX date and time functions in Power BI services, using now and today to build calculated columns and time-based measures with year, month, hour, minute, and second.

  • 2.DAX-Text Functions4:44

    Explore dax text functions in Power BI by applying upper and lower cases and using concatenate to join first and last names with a space.

  • 3.DAX-Logical Functions9:53

    Learn DAX logical functions, including IF, AND, OR, and SWITCH, to build conditional logic and nested conditions for reporting in Power BI.

  • 4.DAX-Information Functions1:38

    Explore DAX information functions and learn how to test data in a name column, determining whether values are true or defaults to validate data quality in Power BI.

  • 5.DAX-Math & Statistical Functions3:11

    Explore DAX statistical and math functions in Power BI, computing sum, mean, min, max, and count from the salary dataset to generate dynamic insights.

  • 6.DAX-Time Intelligence Functions10:04

    Explore DAX time intelligence functions in Power BI, using calculate to filter data, build year and month comparisons, handle missing data, and create dynamic measures that span multiple periods.

  • 7.DAX-Table Functions12:46

    Explore DAX table functions such as union, intersect, and except to merge data across tables in Power BI, and use summarize to create a global country report.

  • Custom Visual4:41

Requirements

  • Laptop with good configuration, Power BI Desktop software, Internet , Basic SQL

Description

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

  8. 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.

  9. 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.

  10. 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.

By completing a Power BI Services and DAX course, students will develop advanced skills in utilizing Power BI Service for sharing and collaboration, as well as leveraging DAX formulas for sophisticated data analysis and modeling. These skills are valuable for professionals working in business intelligence, data analysis, and decision-making roles.

Who this course is for:

  • Power BI Developer
  • Fresher + Experience Professional

Report abuse