MCSA Training : SQL Server Developer

Consume and Transform Data By Using Power BI Desktop (20-25%)

Connect to data sources

  • Connect to databases, files, folders; import from Excel; connect to SQL Azure, Big Data, SQL Server Analysis Services (SSAS), and Power Query

Perform transformations

  • Design and implement basic and advanced transformations, apply business rules, change data format to support visualization

Cleanse data

  • Manage incomplete data, meet data quality requirements

Model and Visualize Data (45–50%)

Create and optimize data models

  • Manage data relationships, optimize models for reporting, manually enter data, Use Power Query

Create calculated columns, tables, and measures

  • Create DAX queries for calculated columns, tables, and measures

Create performance KPIs

  • Calculate the actual, calculate the target, calculate actual to target

Create hierarchies

  • Use date hierarchies, use business hierarchies, resolve hierarchy issues

Create and format interactive visualizations

  • Select a visualization type, configure page layout and formatting, setup visual relationships, configure duplicate pages, handle categories that have no data, setup default summaries and categories, position, align, and sort visuals, enable and integrate R visuals, format calculated measures

Manage custom reporting solutions

  • Use Power BI API, use Microsoft Power BI Embedded, enable developers to create and edit dashboards through custom applications, enable developers to embed dashboards in applications, authenticate a Power BI web application, enable developers to create custom visuals

Configure Dashboards in the Power BI Service (25–30%)

Configure a dashboard

  • Connect to the Power BI service, publish connections to services by using SQL Server Analysis Services (SSAS), publish visualizations including dataConfigure a dashboard, add text and images, filter dashboards, configure dashboard settings, customize the URL and title, enable natural language queries

Publish dashboards

  • Publish to web, publish to Microsoft SharePoint, publish to SQL Server Reporting Services (SSRS)

Configure security for dashboards

  • Create a security group by using the Admin Portal, share dashboard with users or security groups, integrate with Microsoft OneDrive for Business, configure row-level Security, configure gateways
Register Today  Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T [ 13+ Yrs of Technical Expertise, Microsoft Certified Trainer ]


Other Trainings

24x7 LIVE Online Server (Lab) with Real-time Databases. Course includes ONE Real-time Project. Register Today