POWER BI
【Microsoft Power BI for Data Analytics】
刘杰老师精心设计、面向未来市场的课程，可以助你在数据求职中脱颖而出、赢得offer！
5/5
课 程 特 色
【特别喜讯】：疫情期间成功拿到Offer的成功学员都上过这门课
- 为什么人人都要学《Power BI 实战班》
- 全新设计，数据处理速度最快，支持数据格式最全面！
- 各大银行|企业|政府|首选的新一代数据服务平台，就业面超广！
- 刘杰老师备受爱戴，获得无数学生好评，被誉为拥有无敌知识与技术储备的就业男神！
- 北美Power BI第一批User作为华人社区Power BI课程的创始人
- 为您揭示最新的数据分析工具的真实工作应用
- 融会贯通的全面介绍BI在整个数据生态系统中的作用
- 以真实工作案例揭示如何正确及专业的使用BI 以构造最有效的数据平台
- 常年保持高就业率的课程
授 课 老 师：Jay Liu
维多利亚数据学院 – 刘杰院长：计算机软件专业毕业，MCITP-DBA 2005/2008，拥有多年大型信息系统设计开发经验。曾经在中国主持设计开发超过1000个用户的大型政府部门办公自动化系统，AT&T全美联机系统的Senior Consultant，加拿大著名金融公司、银行及政府部门的Senior SQL Server DBA Consultant。擅长大型系统的设计，复杂数据结构的应用，企业级数据库系统的维护和开发。对于数据库系统理论及应用有精辟及独到的见解，所教授的SQL Server DBA及Access VBA 课程一直受到众多学员的好评。
Course outline
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
【学数据分析，就来维多利亚！实习就业有保障！】
