Course PL-300T00: Microsoft Power BI Data Analyst

• Learn about the roles in data.
• Understand the tasks of a data analyst.

• Find & connect to a data source
• Get information from a relational database, such as Microsoft SQL Server.
• Get data from applications
• Get data from Azure Analysis Services
• Select a storage mode
• Obtain data from a file like Microsoft Excel
• Fix performance issues
• Resolve data import errors

• Resolve inconsistencies, unexpected or null values, & data quality issues.
• Data profiling allows you to learn more about a specific column before using it.
• Apply user-friendly value replacements.
• Evaluate & transform column data types.
• Apply data shape transformations to table structures.
• Combine queries.
• Apply user-friendly naming conventions to columns & questions.
• Edit M code in the Advanced Editor.

• Make common data tables
• Configure many-to-many relationships
• Resolve circular relationships
• Design star schemas

• Build temporary measures.
• Make calculated columns.
• Use DAX to build steps.
• Discover how context affects DAX measures.
• Use the CALCULATE function to manipulate filters.
• Implement time intelligence by using DAX.

• Review the implementation of measures, relationships, & visuals.
• Use variables to improve performance & troubleshooting.
• Improve performance by reducing cardinality levels.
• Optimize DirectQuery models with table-level storage.
• Make & manage aggregations.

• Add visualization items to reports.
• Choose a compelling visualization.
• Format & configure visualizations.
• Import a custom visual.
• Add an R or Python graphic.

• Design a report layout.
• Add buttons, bookmarks, & selections.
• Design report navigation.
• Use basic interactions.
• Use advanced interactions & drill through.
• Configure conditional formatting.
• Apply slicing, filtering, & sorting.
• Publish & export reports.
• Comment on reports.
• Use a Performance analyzer to tune statements.
• Optimize reports for mobile use.

• Configure data classification.
• Set a mobile view.
• Pin a live report page to a dashboard.
• Add real-time dataset visuals to your dashboards.
• Add a theme to your dashboard's visuals.

• Explore statistical summary.
• Find outliers with Power BI visuals.
• Group & bin data for analysis.
• Apply clustering techniques.
• Conduct time series analysis.
• Use the Analyze feature.
• Use advanced analytics custom visuals.
• Review Quick insights.
• Apply AI Insights.

• Use the Q&A visual.
• Find essential factors with the Key influencers graphic.
• Use the Decomposition Tree graphic to break down a measure.

• Distribute a report or dashboard.
• Monitor usage & performance.
• Recommend a development life cycle strategy.
• Troubleshoot data by viewing its lineage.
• Configure data protection.

• Make dynamic reports with parameters.
• Make what-if parameters.
• Use a Power BI gateway to connect to on-premises data sources.
• Configure a scheduled refresh for a dataset.
• Configure incremental refresh settings.
• Manage & promote datasets.
• Troubleshoot service connectivity.
• Boost performance with query caching (Premium).

• Set up row-level security by using a static method.
• Configure row-level security by using a dynamic way.

Microsoft Power BI is a business intelligence platform that generally provides nontechnical business users with various tools for aggregating, analyzing, visualizing & sharing data. Users can easily download an application for Windows 10, which is generally called Power BI Desktop, & native mobile apps for Windows, & roid & iOS devices.

To download Power BI Desktop, go to the Power BI Desktop download page & select Download Free. Also, for download options, select See download or language options. From the Power BI service, users can also download Power BI Desktop. Select Power BI Desktop after clicking the Download icon in the top menu bar.

Power BI is a powerful tool where even beginners can make useful dashboards & insights. This means that the investment is not worth the investment for many Power BI users.

The demand for BI (Business Intelligence) & Decision Making will not dip shortly. No other BI tool will overcome Power BI's dominance in the next ten years. Also, Power BI is simple to use as well as it is excellent for data visualization. Moreover, the product is a Microsoft product.

To attend the training session, you should have operational Desktops or Laptops with the required specification and a good internet connection to access the labs. 

We would always recommend you attend the live session to practice & clarify the doubts instantly & get more value from your investment. However, if, due to some contingency, you have to skip the class, Radiant Techlearning will help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption & NOT for distribution or commercial use.

Radiant Techlearning has a data center containing the Virtual Training environment for participants' h&-on-practice. 

Participants can easily access these labs over Cloud with the help of a remote desktop connection. 

Radiant virtual labs allow you to learn from anywhere in the world & in any time zone. 

The learners will be enthralled as we engage them the real-world & industry Oriented projects during the training program. These projects will improve your skills & understanding & you will gain a better experience. These real-time projects will help you a lot in your future tasks & assignments.