More E-books
Follow us on
Contact
I : Preparing Data for Analysis with Microsoft Excel
Welcome
Syllabus
I : Preparing Data for Analysis with Microsoft Excel
Excel Core Skills
1
Excel fundamentals
2
Formulas and functions
3
Preparing data for analysis using functions
Assessment
4
Final project and assessment: Preparing data for analysis with Microsoft Excel
II : Harnessing the Power of Data with Power BI
Foundational Concepts
5
Data analysis in business
6
The right tools for the job
Assessment
7
Final project and assessment: Harnessing the power of data in Power BI
III : Extract, Transform and Load Data in Power BI
ETL Process in Power BI
8
Data Sources in Power BI
9
Transforming Data in Power BI
10
Advanced ETL in Power BI
Assessment
11
Graded Assessment and Course Wrap Up
IV : Data Modeling in Power BI
Core Modeling Techniques
12
Concepts for data modeling
13
Using Data Analysis Expressions (DAX) in Power BI
14
Optimize a model for performance in Power BI
Assessment
15
Final project and assessment: Modeling data in Power BI
V : Data Analysis and Visualization with Power BI
Reporting and Analysis
16
Creating Reports
17
Navigation and Accessibility
18
Bringing Data to the User
19
Identifying Patterns and Trends
Assessment
20
Final project and assessment: Data Analysis and Visualization with Power BI
VI : Creative Designing in Power BI
Design Principles
21
Visualization and Design
22
Designing Powerful Report Pages
23
Dashboard Design and Storytelling
Assessment
24
Final project and assessment: Creative Design in Power BI
VII : Deploy and Maintain Power BI Assets and Capstone project
Enterprise Deployment and Maintenance
25
Power BI in enterprise
26
Deploying assets
27
Security and monitoring
Capstone
28
Capstone project
VIII : Microsoft PL-300 Exam Preparation and Practice
Exam Domain Review
29
Preparing Data
30
Modeling Data
31
Visualize and analyze data
32
Deploy and maintain assets
Practice
33
Practice Exam
References
Contents
Excel Core Skills
Assessment
I : Preparing Data for Analysis with Microsoft Excel
Excel Core Skills
Excel fundamentals
Formulas and functions
Preparing data for analysis using functions
Assessment
Final project and assessment: Preparing data for analysis with Microsoft Excel
Syllabus
1
Excel fundamentals