Power BI
（更多资料和具体参加方法）
Microsoft Power BI – Shining the Data World
- The newest generation of Data Analytics technology with integration of all modern Data Technologies
- Powered with Clouding, Data Visualization, Geometric Reporting, Data Warehouse, Business Intelligence, Big Data, AI and Machine Learning
- The most efficient tool for customizing data analysis for business needs in the easiest way to share your data, reports, visualizations, and dashboards
- All leading industries progressing their next generation of reporting technology
with Power BI, including banking, insurance, manufacture, retail, government
Course: Microsoft Power BI for Data Analytics
Total 20 hours, 7 classes
Class 1. Power BI Overview (2.5 hrs)
- What is Power BI
- Power BI Infrastructure
- How Power BI Works
- Power BI Components
- Power Query, Power Pivot, and Power View
- Course Environment Setup
- Download and Install Power BI Desktop
- Build the First Report in a Few Steps
Class 2. Data Modeling in Power BI Desktop (3 hrs)
- Power BI Data Sources
- What is a Table in Power BI
- Using Excel as Dataset
- Working with Access
- Talking to Database – MS SQL Server
- Relationship
- Data Model
- Big Data, R and Python in Power BI
Class 3. Creating Reports in Power BI Desktop (3 hrs)
- Data Connection
- DirectQuery and Import
- Calculation in Power BI
- Creating Reports
- Shaping and Customizing
- Filtering Data in Reports
Class 4. More Works in Power BI Desktop – M Language, DAX, and SQL (3 hrs)
- Design the Flow – the M Language
- More Details of Data Analysis in Power BI – The DAX
- Sending Requests to Database – SQL Queries
- Executing more – Running Procedures in MS SQL Server
- Fetching Data from SSAS
- Integrating Power BI Reports with SQL Server BI with ETL/SSIS
Class 5. Balancing Performance – Power BI Desktop and Power BI Service (3 hrs)
- Determining Data Processing Modes
- Performance Consideration
- On Premise or On Cloud
- Preparing for Sharing your Power BI Reports
- Power BI on Cloud – powerbi.microsoft.com
- Viewing Reports on the Web
Class 6. Sharing Power BI to the World (3 hrs)
- Sending Power BI Reports to Cloud
- Building and Sharing Dashboards
- Packing your Power BI Applications
- Maintaining Power BI Reports – Scheduling Data Refresh
- Administering Power BI Reports – Reporting Usage Metrics
- Who can do What – Authentications and Permissions
Class 7. Managing Data Security (2.5 hrs)
- Subscriptions - In-house Repository, Personal, On Premise, On Cloud
- Bridging to you Data Sources – What is Power BI Gateway
- Types of Gateway – In-house Repository, Personal, On Premise, On Cloud
- Downloading, Installing and Configuring Data Gateway
- Creating Roles and Applying Role-Based Security
- Licensing and Governance
- Row-Level Data Security Control
- Wrapping the Work up
