3月初开课Power BI考证班

课程简介

Power BI is quickly gaining popularity among professionals in data science as a cloud-based service that helps them easily visualize and share insights from their organizations’ data.

In this data science course, you will learn from the Power BI product team at Microsoft with a series of short, lecture-based videos, complete with demos, quizzes, and hands-on labs. You’ll walk through Power BI, end to end, starting from how to connect to and import your data, author reports using Power BI Desktop, and publish those reports to the Power BI service. Plus, learn to create dashboards and share with business users—on the web and on mobile devices.

开课时间: 3/8/2018 (Every Thursday night)

课程最优惠价格:(保证市场最低价格)

特惠价格 99$, 如果你报过Reporting Package(任何一期)

限时特惠价格,$245  (报名点击)

 

课程内容

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
  • Configure organizational content packs and apps
    • Create a content pack, publish a content pack, edit a content pack, package dashboards and reports, configure app workspace

 

考试费用$165不包含在课程费用中。